Showing: 1-10 of 10
Articles |
|||||
 |
I see hundreds of mysql-bin.00xxxxxxx files in /var/lib/mysql directory. What are these files? These files are created when you fail to turn log-bin off for MySQL (needed if you allow off-site... |
||||
|
|||||
 |
|||||
|
Starting MySQLCouldn't find MySQL manager or server If you upgraded MySQL to v5.x, you might find that MySQL won't start. In this case, make sure that... |
||||
|
|||||
|
|||||
|
How can I check if query cache is working on my MySQL server? From inside the MySQL CLI:
show status like 'qc%';
It will produce output like this:
mysql>... |
||||
|
|||||
|
|||||
|
HowTo :: commands, statements, and clauses
Description
Command
|
||||
|
|||||
|
|||||
|
HowTo :: change MySQL root password Run the following commands at the prompt
/etc/init.d/mysql stop
mysqld_safe... |
||||
|
|||||
|
|||||
|
Got a packet bigger than 'max_allowed_packet' bytes If you get this error when trying to dump a MySQL DB, this is due to the packet limit of MySQL... |
||||
|
|||||
|
|||||
|
MySQL :: HowTo fix Access-Denied Errors If you get any of the following error messages when you try to connect to MySQL... |
||||
|
|||||
|
|||||
|
Warning: MySQL server has gone away If you get the following error message:
*Warning*: MySQL server has gone away
that means your... |
||||
|
|||||
|
|||||
|
Error :: Can't connect to [local] MySQL server If you are trying to, remotely, connect to MySQL and get one of the following error messages:
... |
||||
|
|||||
|
|||||
|
Who is exhausting MySQL resources on my server? We suggest you monitor MySQL processes on a regular basis either using a third-party software... |
||||
|
|||||
|
|||||
Last update: March 21st, 2010 ••• Copyright © 2004-2010 ServerTune Inc.
