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 does it do? The
help file says that the -o option optimizes, but what does that mean?? I
does it do?
The help file says that the -o option optimizes, but what does that
mean?? I ran it on one of my databases, and most of them said OK,
and some of them said table is already up to date. But I still have
no idea what it did, if anything.
Thanks,
Jesse
--
MySQL General Mailing
-
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
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!
possible to show
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
Hi,
Currently, I have a situation where an app makes connections (via JDBC)
to a mysql server, 50 connections at once, and everything just becomes
super-slow. For instance, a SELECT that should take 0.01 sec takes
several minutes. SHOW PROCESSLIST says that these threads that are
connections
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
It says I am not allowed to connect to the mySQL server. I am trying root
and admin and it won't let me in. Have I done something wrong and what do I
check?
Chris L. White
Network Administrator
Coe-Truman Technologies, Inc.
Email: [EMAIL PROTECTED]
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
Hello mysql,
mysql version: 4.0.14-standard for linux
linux kernel: 2.4.21
mysqladmin -umef -p shutdown
Enter password:
./bin/mysqld_safe: line 1: 31500 Segmentation fault nohup
/usr/local/mysql/bin/mysqld --defaults-file=/var/lib/mysql/my.cnf
--basedir=/usr/local/mysql
While accessing MySQl data base by means of perl the value of variable $! sometimes
equals Resource temporarily unavailable. At the mean time everything works correct.
What does that mean?
___
http://chat.bigmir.net/ - ñàìûé óäîáíûé
Hi!
Chung == Chung Ha-nyung [EMAIL PROTECTED] writes:
Chung query.
Chung I happened to find out that the lots of following error messages are
Chung stored
Chung error log file:
Chung Warning: thr_alarm queue is full
Chung What's this? Is it serious problem?
The above is a very strange
PROTECTED]
Geschaftsfuhrer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Chung Ha-nyung [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 27, 2002 3:49 AM
Subject: What does
query.
I happened to find out that the lots of following error messages are
stored
error log file:
Warning: thr_alarm queue is full
What's this? Is it serious problem?
--
Chung Ha-nyung alita@[neowiz.com|kldp.org]
Sayclub http://www.sayclub.com
NeoWiz http://www.neowiz.com
At 20:55 -0700 5/10/02, Frederick Shaul wrote:
I understand what test% might mean, but don't know what test\_% means.
It's a SQL pattern string that matches a literal test followed by
a literal _ followed by anything. _ in SQL patterns normally
matches any single character. \_ escapes it to
I understand what test% might mean, but don't know what test\_% means.
Following is from a fresh MySQL install ...
mysql use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql select *
Hi,
can somebody answer my question?
Subject: what does it mean Open_files?
Date: Mon, 22 Oct 2001 06:41:03 +0200
From: Michal ejdl [EMAIL PROTECTED]
To: MySQL list [EMAIL PROTECTED]
Hi,
after some testing on a new db, I have this status:
[root@rachab /root
Hi,
after some testing on a new db, I have this status:
[root@rachab /root]# mysqladmin e | grep "onn\|pen.*es"
| Aborted_connects | 12 |
| Connections | 150194 |
| Max_used_connections | 24 |
| Open_tables | 0 |
|
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
and how you fix it?
thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
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
Found this message from mysql in my root mailbox. What does it mean?
"errors occured while rotating /var/lib/mysql/mysqld.log {
^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
error running postrotate s
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
Hi;
I'm getting this error:
Unsatisfied dependencies for mod-php3-mysql-3.0.8-2: mod-php3 = 3.0.8
What does it mean and what should I do about it (if anything)?
TIA,
BenO
-
Before posting, please check:
http
- Original Message -
From: "Ben Ocean" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 3:28 PM
Subject: [PHP] What Does This Mean?
Hi;
I'm getting this error:
Unsatisfied dependencies for mod-php3-mysql-3.0.8-2: mod-ph
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
32 matches
Mail list logo