NEW VPS Plans

ServerTune provides -- managed and un-managed -- VPS hosting solutions at affordable prices to accommodate your personal and/or businesses needs.

Click here for more info ...

NEW VPS Plans

Click to hideClick to view
ServerTune

Browse by category

Search    |    Advanced search

Home / MySQL/

Articles Showing: 1-12 of 12  

Article
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...
 
Rating Indicator
08 Mar, 2011
Views: 1908
Article
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...
 
Not rated
08 Mar, 2011
Views: 2623
Article
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>...
 
Not rated
08 Mar, 2011
Views: 1929
Article
HowTo :: commands, statements, and clauses
MySQL commands, statements, and clauses Description Command To login...
 
Not rated
07 Mar, 2011
Views: 2071
Article
HowTo :: change MySQL root password
Run the following commands at the prompt /etc/init.d/mysql stop mysqld_safe...
 
Not rated
06 Mar, 2011
Views: 1829
Article
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...
 
Not rated
06 Mar, 2011
Views: 4030
Article
MySQL :: HowTo fix Access-Denied Errors
If you get any of the following error messages when you try to connect to MySQL...
 
Not rated
03 Mar, 2011
Views: 1627
Article
Warning: MySQL server has gone away
If you get the following error message: *Warning*: MySQL server has gone away that means your...
 
Rating Indicator
08 Aug, 2011
Views: 4717
Article
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: ...
 
Not rated
03 Mar, 2011
Views: 1742
Article
Who is exhausting MySQL resources on my server?
We suggest you monitor MySQL processes on a regular basis either using a third-party software...
 
Not rated
03 Mar, 2011
Views: 1163
Article
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...
 
Not rated
15 Apr, 2011
Views: 1797
Article
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...
 
Not rated
11 Jul, 2011
Views: 911
RSS
Copyright © 2004-2011 ServerTune, Inc.