Re: What does optimize mean?

2006-07-28 Thread Martin Jespersen
read the manual: http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html Jesse wrote: Seeing posts about mysqlcheck on the list prompted me to check out that utility. A lot of it I can see is very useful, and I understand what it does. However, what does the optimize command mean? What

Re: What does optimize mean?

2006-07-28 Thread Jesse
- From: Martin Jespersen [EMAIL PROTECTED] To: Jesse [EMAIL PROTECTED] Cc: MySQL List mysql@lists.mysql.com Sent: Friday, July 28, 2006 7:59 AM Subject: Re: What does optimize mean? read the manual: http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html Jesse wrote: Seeing posts about

Re: what does Rows_examined mean exactly?

2004-07-25 Thread Michael Stassen
tinys xuefer wrote: slow.log: # Query_time: 14 Lock_time: 0 Rows_sent: 30 Rows_examined: 771327 SELECT * FROM `post` LIMIT 771297, 30; i dp have privmary key on table `post` does 'Rows_examined: 771327' means mysqlserver read through those 771327 rows to get 30 rows? it takes 14 seconds!

Re: what does Rows_examined mean exactly?

2004-07-25 Thread tinys xuefer
hrm.. but i tried SELECT * FROM post ORDER BY postdate DESC LIMIT 771297, 30 postdate is not primary key but just an INDEX it still examined 771297 rows From: Michael Stassen [EMAIL PROTECTED] To: tinys xuefer [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: what does Rows_examined mean

RE: What Does This Mean

2004-01-13 Thread Chris L. White
OK I got the database created and stuff; When in the MySQLAdmin screen under databases it doesn't show under databases. That is the first problem. And for some reason the MYSQLadmin screen list the local user name as Administrator and will not let me change it. But I can get into the mysql

Re: What Does This Mean

2004-01-12 Thread robert_rowe
Did you set a password for the root account? MySQL comes with a root user that (initially) has no password and all privileges. Most setup instructions have you assign a password to the root account pretty early on. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: What does this Mean

2004-01-12 Thread Chris L. White
C:\MySQL\binmysql show ERROR 1045 (28000): Access denied for user: 'ODBC'@'localhost' (Using password: YES) C:\MySQL\binmysql show -u root ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password: YES) C:\MySQL\binmysql show -u root -p Enter password: **

Re: What does this Mean

2004-01-12 Thread William R. Mussatto
Chris L. White said: C:\MySQL\binmysql show ERROR 1045 (28000): Access denied for user: 'ODBC'@'localhost' (Using password: YES) C:\MySQL\binmysql show -u root ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password: YES) Your musql setup requires a password

RE: What Does This Mean

2004-01-12 Thread Chris L. White
You know what is even more screwed up now. I did this command and when it prompted me for the password I just hit enter and wallah look what I got. But I am sure there is other stuff messed up now: C:\MySQL\binmysql -u root -p Enter password: ** ERROR 1045 (28000): Access denied

RE: What Does This Mean

2004-01-12 Thread William R. Mussatto
Chris L. White said: You know what is even more screwed up now. I did this command and when it prompted me for the password I just hit enter and wallah look what I got. But I am sure there is other stuff messed up now: SET YOUR ROOT PASSWORD it its blank it will behave as you describe. Sorry

Re: What does this mean? : Warning: thr_alarm queue is full

2002-12-27 Thread Stefan Hinz, iConnect \(Berlin\)
Chung, Warning: thr_alarm queue is full What's this? Is it serious problem? Looking for thr_alarm in the MySQL Manual, I find this: If mysqld is compiled with -DUSE_ALARM_THREAD, a dedicated thread that handles alarms is created. This is only used on some systems where there are problems

Re: what does this mean please?

2001-06-22 Thread Seth Northrop
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) and how you fix it? It means you have no local socket for mysql to connect through. Meaning, something/someone either deleted or mangled /tmp/mysql.sock or mysqld isn't running to begin with. Try to

Re: What does this mean

2001-03-16 Thread Mark Maggelet
On Fri, 16 Mar 2001 13:35:18 -0500, Hardy Merrill ([EMAIL PROTECTED]) wrote: Sure it's easier, but which is safer? I don't have Charles first message on this topic, but I believe his error message was from logrotate which is a cron job. If Charles put mysqladmin -uuser -ppassword into a

RE: What does this mean ?

2001-01-16 Thread Steven Roussey
al Message- From: Denis Gasparin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 8:50 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: What does this mean ? I use php 4.0.3 with persistent connections. MySQL is installed on Linux RedHat 7.0. The problem is that the My

mysql_pconnect still broken (was: RE: What does this mean ?)

2001-01-16 Thread Maciek Uhlig
OK. Look at a quick report. I've just installed php4-200101152345. It runs with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local host) and 2.4 (remote connection). What I can see is: the offending messages didn't vanish at all (both hosts are involved): 010116 20:52:30 Aborted connection

Re: [PHP-DEV] RE: mysql_pconnect still broken (was: RE: What does this mean ?)

2001-01-16 Thread Zeev Suraski
Yep, you're right. Fixed. Thanks, Zeev At 23:24 16/1/2001, Steven Roussey wrote: OK. Look at a quick report. I've just installed php4-200101152345. It runs with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local host) and 2.4 (remote connection). What I can see is: the offending