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
-
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
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!
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
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
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
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: **
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
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
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
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
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
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
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
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
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
16 matches
Mail list logo