returns
*** 120. row ***
Variable_name: timezone
Value: IST
I'm sure I've missed something simple here but what?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 21, 2005 08:55
To: mysql@lists.mysql.com
Subject: Timezone setting wrong?
I've got a RHEL3 server I just installed with mysql 4.0.16.
The hardware clock and system clock are both set to UTC
:
A - B - A
Is it necessary to start the servers with --log_slave_updates?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 20, 2005 17:13
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: Circular Replication
Jeff wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday
,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Friday, September 16, 2005 11:34
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: Circular Replication
In the last episode (Sep 16), Jeff said:
Does anyone use circular replication with MySQL 4.x
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Friday, September 16, 2005 11:55
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: Circular Replication
Jeff wrote:
Am I correct in this setup process:
Server A exists
Server B to be built
Stop
-Original Message-
From: Jeff McKeon
Sent: Friday, September 16, 2005 13:19
To: Devananda
Cc: mysql@lists.mysql.com
Subject: RE: Circular Replication
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Friday, September 16, 2005 11:55
To: Jeff
Cc
-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: [EMAIL PROTECTED]
From: Jeff Shapiro [EMAIL PROTECTED]
--
Q: Why did the chicken cross the road?
A: He was giving it last rites.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
:
Seconds_Behind_Master: NULL
Any ideas as to what is locking it up?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, you MUST use the /usr/bin/mysqlbug script!
Starting MySQL...[FAILED]
Anyone have this problem and know how to fix it???
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi. Thanks for any help on this. I've been beating my head over it for
hours.
Here's what I am trying to do: I have four tables I am joining via a
unique key (Fellow_id).
The results I want to group into three categories, each alphabetized
within the group.
Is this too much to do in a single
On Monday 29 August 2005 04:55 pm, Alexey Polyakov wrote:
I'd try setting
innodb_buffer_pool_size=8G
in my.cnf
Then it will run out of memory. You only get 2gig for bufferpools no matter
how much more you have.
--
===
are on by default in 4.1.x. To get multiple
inserts (usually slower) use a command like:
mysqldump --skip-extended-insert mydatabase mydatabase.sql
--
Jeff Shapiro
listserv only address
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Does anyone know if there are any problems replicating from a master
database on version 4.0.16 to a slave running version 4.1.13?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lack of a primary key was the problem.
I am surprised the problem didnt show up in 3.23
but did in 4.12
Thanks for the suggestions!
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
order by sex LIMIT 200
Any ideas/help is much appreciated. Im a relative
newbie to mysql and databases in general.
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
| |
+---+--+--+-+-+---+
20 rows in set (0.01 sec)
I also realized that if I say:
mysql select * from user_stats1;
I get an immediate response also. If I use column names it takes a while.
It never did in 3.23.
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http
'
AND userid=user_stats1.id AND userid=user_wants1.id AND userid=user_account1.id;
Id still like to know why, but at least its a huge start.
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the text file look like:
NULLstudents
NULLfaculty
NULLstaff
where I would acutally type NULL
or
0students
1faculty
2staff
where I would supply the number (would it start with 0 (zero) or 1)?
or
what else is there?
Thanks for the help.
Jeff
, using named pipes (i think, but maybe tcp).
so then there is no need to pass the -h
That error message says the socket doesnt exist..
Your either pointing mysql to the wrong area, or mysqld isnt started.
Jeff
pgpULUOI2faEA.pgp
Description: PGP signature
on the command line the only way?
Thanks,
Jeff
--
Jeff Richards
Consulting Architect
Openwave Systems Asia Pacific
+61 415 638757
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
an unlock tables;
The reason I ask is that this list is the only place I can find
reference to this procedure. Everywhere else talks about either
mysqldump or the InnoDB Hot Backup utility for making online backups.
Thanks in advance!
Jeff
--
Jeff Richards
Consulting Architect
Openwave Systems
Hi Dobromir,
Thanks for the feedback. So you have successfully restored from a
Snapshot created in this way?
Jeff
On Wed, 2005-07-27 at 12:30 +0300, Dobromir Velev wrote:
Hi,
--
Jeff Richards
Consulting Architect
Openwave Systems Asia Pacific
+61 415 638757
--
MySQL General Mailing List
is, I can't find the rpm or source for the MySQL-shared-compat
for 4.1.13 (or any other version for that matter).
Anyone know where I can get my hands on the correct RPM? Are they
hidden somewhere on the MySQL site?
Best regards,
Jeff
--
MySQL General Mailing List
For list archives: http
Thanks!
Jeff
-Original Message-
From: Jason Pyeron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 26, 2005 3:03 PM
To: mysql@lists.mysql.com
Subject: Re: Mysql-shared-compat for 4.13
you can find what you need here:
http://public.pdinc.us/rpms/mysql
please email
testdb.foo;
ERROR 1146 (42S02): Table 'testdb.testdb' doesn't exist
Seems like a serious bug to me.
Why not submit a bug?
Jeff
pgpx29Q7QtMCz.pgp
Description: PGP signature
kernels have things to let you go over, but you get weird
results when doing so.
Jeff
pgpzqaIko4NhJ.pgp
Description: PGP signature
Anyone using any third party products like Arkeia that enable you to do
a live backup of MySQL database?
I'm searching for a backup solution for our new data center and would
like to here what other people are using for MySQL.
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http
Yes, that's the way we currently do it but we were looking for more
options.
Jeff
-Original Message-
From: Kieran Kelleher [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 16, 2005 11:26 AM
To: Jeff McKeon
Cc: mysql@lists.mysql.com
Subject: Re: Backing up live MySQL Databases
I
keep mine to 1.5 and all the others are really low or turned off.
Jeff
pgpTAtr1JpbRo.pgp
Description: PGP signature
On Wednesday 08 June 2005 10:57 pm, George Sexton wrote:
1)Why can't I declare a datetime field with DEFAULT NOW()
4.1 has options to default timestamps on update/inserts or both..
Jeff
pgp2pHd6mM2jF.pgp
Description: PGP signature
with the timestamp of when the query would have actually been
inserted?
Jeff
pgpGXWuwLb4Lp.pgp
Description: PGP signature
?
Jeff
pgpqFlRnr8VLc.pgp
Description: PGP signature
..
Why do you keep bringing this up?
Jeff
pgp6PCudsBfQQ.pgp
Description: PGP signature
is the best way
to get this fixed...
Jeff
pgpWnixubL90D.pgp
Description: PGP signature
On Wednesday 08 June 2005 10:56 am, you wrote:
In the last episode (Jun 08), Jeff Smelser said:
On Tuesday 07 June 2005 04:22 pm, Kevin Burton wrote:
Subqueries in 4.1 are totally broken. They don't use indexes.
They're evil. We're told we have subqueries but there's no way
anyone
..Or direct them to the right person..
Jeff
pgpSieE9hrblQ.pgp
Description: PGP signature
On Wednesday 08 June 2005 11:49 am, you wrote:
Easy there boss, I was just responding to the thread and meant no
offense. I saw the whole thing as funny.
Oh.. email sucks that way..
My apologies as well..
Jeff
pgpvHgJLsGjaw.pgp
Description: PGP signature
files, then starting the db when done. Does mysqlhotcopy
allow you to take a full snapshot of the db without needing to shut it
down? What happens to read writes and updates while mysqlhotcopy is
running?
Any info or experiences anyone has would be greatly appreciated.
Thanks,
Jeff
--
MySQL
Am I right in assuming that while mysqlhotcopy is running, nobody else
can write to or update the DB?
Jeff
-Original Message-
From: Jeremiah Gowdy [mailto:[EMAIL PROTECTED]
Sent: Friday, June 03, 2005 2:24 PM
To: Jeff McKeon; mysql@lists.mysql.com
Subject: Re: mysqlhotcopy
I
On Friday 03 June 2005 03:36 pm, Joey wrote:
SET PASSWORD FOR mailto:'user'@'localhost' 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Why not recompile php to work with 4.1?
--old-password
Jeff
pgpEctk2PnMK1.pgp
Description: PGP signature
On Wednesday 01 June 2005 10:40 am, Josh Trutwin wrote:
Just curious - was there a 5.0.5-beta release? The last beta I had
was 5.0.4 unless I missed a release announcement...
You need to read that email.. it says it was never released.
Jeff
pgpk9pJzWINTK.pgp
Description: PGP signature
together in another cell,...
=C1 - D1 - right(A1,2)
Look at the functions left, right, mid to see how to pull out parts,...
Jeff
*
Jeff Mao
Coodinator of Educational Technology
Maine Department of Education
23 State House Station Augusta, ME 04333
://dev.mysql.com/doc/mysql/en/CREATE_VIEW.html
Jeff
pgpLkLDLqUMyZ.pgp
Description: PGP signature
pointers on where to go to fix this. I have googled
and searched the archives and I haven't come up with anything that works.
--Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing
into the dark) I have binlogs starting from Nov 12, a
snapshot from sept 10th. Is there some way anyone can suggest that I
can reconstruct the database table with what I have?
Best Reguards,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Interesting idea.
So if I take the table from Sept 10th and then do that with the binlog
I'll be missing about 2 months worth of data because my earliest binlog
file is Nov 12th.
The queries are always one to a line in the binlog?
Best Reguards,
Jeff
-Original Message-
From
|
+---+
./mysqlshow
+---+
| Databases |
+---+
| test |
+---+
Please give me some pointers on where to go to fix this. I have googled and
searched the archives and I haven't come up with anything that works.
--Jeff
--
MySQL General Mailing List
For list
?
Thanks,
http://www.mtsu.edu/~itd Information Technology Division
Jeff Hinds, ocp
Database Specialist
Middle Tennessee State University
001 Cope Administration Building
Murfreesboro, TN 37132
mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
tel:
fax:
(615) 898-5719
(615) 898
I have a number of very large text files I need to import. The first line of each
file contains the field names. Is there a way to automatically create the
associated tables based on the filed names in the first line of the text file,
then import the data using LOAD DATA INFILE?
Thanks
Jeff
I'm running MySQL 4.0.14 and it's locking tables for everything including
counting records and select statements. I don't use any lock statements.
Has anyone else encountered this? Any suggestions?
Thanks,
Jeff
__
Do You Yahoo!?
Tired
links to 5 corresponding records in table2,
I want to pull the latest record from table2 where table2.parentid = 100
and table2.user not like 'john'
There is a datestamp field in table2.
I just can't figure out how to do this.
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http
Thanks all but I don't have a mysql version high enough for subqueries.
Thanks,
Jeff
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 4:01 PM
To: Jeff McKeon
Cc: mysql@lists.mysql.com
Subject: Re: Query question
Jeff,
Something
Peter,
I'm unfamiliar with the @d := section you describe. Is this psudo
code or real syntax?
thanks,
Jeff
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 4:17 PM
To: Jeff McKeon
Cc: mysql
3.23.
no control over this right now or i'd upgrade, believe me!
jeff
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 4:43 PM
To: Jeff McKeon
Cc: mysql@lists.mysql.com
Subject: Re: Query
25, 2005 4:36 PM
To: Jeff McKeon
Cc: mysql@lists.mysql.com
Subject: RE: Query question
Jeff McKeon [EMAIL PROTECTED] wrote on 04/25/2005
04:08:29 PM:
Thanks all but I don't have a mysql version high enough for
subqueries
://www.mtsu.edu/~itd Information Technology Division
Jeff Hinds, ocp
Database Specialist
Middle Tennessee State University
001 Cope Administration Building
Murfreesboro, TN 37132
mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
tel:
fax:
(615) 898-5719
(615) 898-5720
On 4/16/05, Scott Gifford [EMAIL PROTECTED] wrote:
Jeff Kolber [EMAIL PROTECTED] writes:
How are sites doing the search by zip and coming up with results within x
miles? Is there some OSS zip code download that has been created for this?
The ones I'm familiar with use this:
http
missing out
somehow.
Thanks
Jeff
, anyone have insights into doing with Canadian
Zip Codes or otherwise optimizing a database of Canadian Zip Codes?
Jeff Kolber
http://www.ForSaleByOwner.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
there..
If your missing bin log files, then you need to set up the master to not
delete logs the slave has not processed yet. This would assure your up to
date, once the slave comes back alive..
Or am I missing something?
Jeff
pgpsJU5d3COjX.pgp
Description: PGP signature
, the mysqld_safe script says it's:
- using /export for data
- using a .pid file in /export
- exits without starting mysql.
There are no other error messages.
Can datadir be set to /export successfully? If yes, is there some other
configuration that needs to be changed?
Thanks
Jeff
Yes, there is a MySQL beta version of the administrator, but be warned,
it has many bugs that I personally believe makes it unusable.
Jeff J.
On Apr 7, 2005, at 8:35 AM, Brent Baisley wrote:
If you are looking for a GUI admin, MySQL has released a beta of MySQL
Administrator for OSX. MySQL
/mysql/en/reset-slave.html
Jeff
pgpqS6H2r2My8.pgp
Description: PGP signature
file in /var/lib/mysql for
messages. Look at the last entries in the file.
That is what got mysql version 4 running on my FC3 box.
Jeff Steinkamp - N7YG
Tucson, AZ
SCUD Missile Coordinates
N32-13-52 W110-52-15
http://home.earthlink.net/~jksteinkamp
http://n7yg.webhop.org
with both the MySQL preference pane and the Administrator utility.
Jeff
On Mar 16, 2005, at 10:56 PM, Michael Stassen wrote:
It should be in mysql's bin directory, typically /usr/local/mysql/bin.
You either need to add that to your PATH,
export PATH=$PATH:/usr/local/mysql/bin
or use the full path
for me, it is time well spent to try and get the GUI
working.
Jeff
On Mar 17, 2005, at 10:31 AM, Michael Stassen wrote:
You can't call TextEdit from the command line like that, you have to
launch it in the GUI. That doesn't really matter, though, as you do
not want to use TextEdit, because
of MySQL for OSX?
Jeff
On Mar 17, 2005, at 10:46 AM, Jeff Justice wrote:
Okay...now we're getting somewhere. Thank you. Adding the file
wasn't the problem, I just wasn't sure WHERE it should be added. Yes,
I am using 10.3. Just trying to pin down why the GUI tools can't seem
to start
Using the OSX MySQL Administrator, when Stop Server is clicked under
the Service tab, the server doesn't stop. In fact, the only way I
have been able to quit the MySQL process is through the Activity
Monitor, and a force quit at that. What's up with that?
Jeff
--
MySQL General Mailing List
Okay, so MySQL is now installed and running. It looks like a database
named test was created with no tables. Is this just used for
installation purposes? Can it now be deleted or is there a reason to
keep it? Or does it have some magical purpose like the mysql
database?
Jeff
--
MySQL
.
Is there a way to un-install this and start COMPLETELY from scratch?
It did work once.
Jeff J.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
installed it.
Something is still goofy.
Jeff J.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and.or pointers would be greatly appreciated.
No, LOG is a all or nothing type thing.. LOG-ERROR gets you
warnings/notes/errors though.. (an not all the other stuff). I do wish i
could get a log with connections, without every query that goes through the
system..
Jeff
pgpH7HCKlY9wF.pgp
copy for innodb too,
but you have to pay for it.. (something like that anyway)
Jeff
pgp6nYOwRR6P1.pgp
Description: PGP signature
will work.
Then you can solve why its not resolving.
Jeff
pgpmTQHtRMU79.pgp
Description: PGP signature
are ridiculously messy as you can guess.
You have a server thats on DHCP? Well, your problem is dhcp I am sure.. But
good luck with that horror flick.
What is this world coming to.
Jeff
pgpZsHHBXfcXQ.pgp
Description: PGP signature
.. Since its a
binary.
Jeff
pgpG4TIEO5elB.pgp
Description: PGP signature
to start all over.
Jeff
pgpd6v4TIoxmG.pgp
Description: PGP signature
earlier,...
Is this a Mac OS X thing? Or is this normal? Do all the rest of you
have newer version of MySQL recognized by php/apache?
Thoughts?
Thanks in advance
Jeff
--
Jeff Mao
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Thanks,...that's the info I needed to help me know where to look for
a solution,..I'll direct my work on the php side of things!
Jeff
At 9:07 AM -0800 2/11/05, Hassan Schroeder wrote:
Jeff Mao wrote:
I'm back,...I've removed MySQL completely and reinstalled it using
the binaries for Mac OS X
for Macs,...I'm checking back on his site to
see if this was an oops on his part or by design, etc,...
Jeff
At 1:19 PM -0500 2/11/05, Dean, Michael L USAATC wrote:
Jeff,
When you upgraded to the 4.1 version of MySQL did you run the
mysql_fix_privilege_tables script? I just upgraded a 3.23
something?
Thanks
Jeff
--
Jeff Mao
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
,...
Thanks for any other ideas!
Jeff
At 2:09 PM -0600 2/10/05, Jay Blanchard wrote:
[snip]
In the past, I've always simply installed these two pieces as I
mentioned above and everything was so easy,but it's been awhile
since I last did this,did I miss something?
[/snip]
Permissions?
--
MySQL General
steps every time!
Jeff
At 8:55 PM + 2/10/05, mel list_php wrote:
I'm not sure if it can be a password problem as you can connect
through command line,but when upgrading to 4.1 I had the classical
access deny error with phpmyadmin whereas everything else was ok.
You can still have a look
I'm running Mac OS X,...so if the the disable and rebuild isn't too
hard, can you outline that process?
Jeff
Probably because they don't have the time to get the latest and greatest
client library every time. I'm not sure how to rebuild it on Windows but
you can disable the built in on unix
Argh,...this is what happens when you leave your sysadmin job to
become a bureaucrat! Lost my edge I guess,...I just looked again at
what I downloaded earlier today to install,...and I had the version
for Mac OS X v 10.2 and not 10.3,...
Thanks all for your help!
Jeff
At 8:29 AM +1100 2/11/05
On Tuesday 08 February 2005 03:32 pm, Emmett Bishop wrote:
is it possible to force a field to be NOT NULL but not
have any default value (I.E the insert statement must
explicitly provide data for the field in question)?
of course: col1 int not null
Jeff
pgpKRoQG6Ktfo.pgp
Description: PGP
to selecting the data from the table I would like to be able to select
all the data and decrypt any fields as required. Is this possible with one
query, or do I have to select every data item then decrypt it then present
the data?
Wouldn't select decode(col1) from table work?
Jeff
whatever is in that column, was encoded.
Jeff
pgpDfYZf8nbn6.pgp
Description: PGP signature
for the right
syntax to use near '))' at line 1
your right, i was mistaken.. I use:
select des_decrypt(des_encrypt(foo)); which works fine..
I am not sure what version he is using, but that should have worked.
Jeff
pgp7spCyw8ane.pgp
Description: PGP signature
that is inserted by B
while A is running is not visible to A. If A is re-started all the data
that was inserted by B is now available.
A is a plotting program and B is a data importer process.
Any clue on what may be going wrong?
Thank you in advance.
Jose.
--
Jeff Mathis, Ph.D. 505
) is actually used? I would like to
have an idea of the data space progression? Per database (I have 3).
Thank you in advance
Johanne Duhaime
IRCM
courrier: [EMAIL PROTECTED]
--
Jeff Mathis, Ph.D. 505-955-1434
Prediction Company [EMAIL PROTECTED
is this insert/select not working?
insert into the_db (place,address,number) values(stuff,stuff2,select
this from that where one=two);
i tried ()s around the 'select' too but it didn't work.
thanks.
--
Jeff Mathis, Ph.D. 505-955-1434
Prediction Company
choose to add the /bin/ directory of MySQL to the path, during the
installation.
Do the developers read these messages as well? If not, where should I
report the problem?
bugs.mysql.com..
Jeff
pgpWdoIKbXEGb.pgp
Description: PGP signature
in my search for an equivalent method in MySQL or even an
alternative. Any help, hints or suggestions are welcome,
Cast will work, its in every DB..
Jeff
pgpbdMaJFEcXW.pgp
Description: PGP signature
count anything.
So the select count(*) theory isnt correct.
Jeff
pgpywUqJPtAY0.pgp
Description: PGP signature
rename the files in step 3, just in case,
right?
Jeff;
On Fri, 8 Oct 2004 16:34:31 +0300, Dobromir Velev [EMAIL PROTECTED]
said:
Hi,
According to the manual -
http://dev.mysql.com/doc/mysql/en/OPTIMIZE_TABLE.html
http://dev.mysql.com/doc/mysql/en/InnoDB_File_Defragmenting.html
running a null
before the machine stop responding ?
HP Pentium4 - 2.2mhz - 512 mb, 99% used and no swap, HD of 40GB.
What table type you using?
Jeff
pgpaVttIiLwf1.pgp
Description: PGP signature
On Thursday 09 December 2004 01:06 pm, Patrick Marquetecken wrote:
and for ansewring Jeff Smelser i have installed mysql 4.x on linux and then
dit from the commandline create database and then run the create table
commands from snort.
No idea.. you can do a show create table db.table to find
101 - 200 of 828 matches
Mail list logo