ServerTune

Browse by category

Search    |    Advanced search

ArticlesShowing: 1-12 of 12  

Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
If you get this error, do the following: Add --single-transaction option to mysqldump command: mysqldump --single-transaction -uYOUR_USER...
 
Not rated
07 Dec, 2014
Views: 1877
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
This error message is related to the variable innodb_lock_wait_timeout which can be found in MySQL configuration file, my.cnf. The default value...
 
Not rated
07 Dec, 2014
Views: 4179
Who is exhausting MySQL resources on my server?
We suggest you monitor MySQL processes on a regular basis either using a third-party software application such: "mytop", and/or by manually using...
 
Not rated
08 Dec, 2014
Views: 966
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: 2002- can`t connect to mysql server on IP/host ...
 
Not rated
08 Dec, 2014
Views: 912
Warning: MySQL server has gone away
If you get the following error message: *Warning*: MySQL server has gone away that means your Php or Perl/cgi powered application has not...
 
Not rated
07 Dec, 2014
Views: 1358
MySQL :: HowTo fix Access-Denied Errors
If you get any of the following error messages when you try to connect to MySQL server: ERROR 2003: Can't connect to MySQL server on 'host_name'...
 
Not rated
08 Dec, 2014
Views: 846
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 server (more details from MySQL documentation at:...
 
Not rated
08 Dec, 2014
Views: 1039
HowTo :: change MySQL root password
Run the following commands at the prompt /etc/init.d/mysql stop mysqld_safe --skip-grant-tables & Connect to MySQL...
 
Not rated
08 Dec, 2014
Views: 889
HowTo :: commands, statements, and clauses
MySQL commands, statements, and clauses Description Command To login (from unix shell) use -h only if needed mysql -h...
 
Not rated
08 Dec, 2014
Views: 890
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: show status like...
 
Not rated
07 Dec, 2014
Views: 814
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 you comment out or remove the basedir directive...
 
Not rated
08 Dec, 2014
Views: 915
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 MySQL servers). SSH to the server and edit...
 
Not rated
07 Dec, 2014
Views: 1106
RSS