Slow Query Log analyzes tools
MySQL has simple but quite handy feature - slow query log, which
allows you to log all queries which took over define number of
seconds to execute. There is also an option to enable logging
queries which do not use indexes even if they take less time
(--log-queries-not-using-indexes)
|
|
Read more... [Slow Query Log analyzes tools]
|
How to Backup and Restore MySQL Databases
phpMyAdmin can be used to export or backup MySQL databases easily.
However, if the database size is very big, it probably won’t
be a good idea. phpMyAdmin allows users to save database dump as
file or display on screen, which involves exporting SQL statements
from the server, and transmitting the data across slower network
connection or Internet to user’s computer. This process slow
the exporting process, increase database locking time and thus
MySQL unavailability, slow the server and may simply crash the
Apache HTTPD server if too many incoming web connections hogging
the system’s resources.
|
|
Read more... [How to Backup and Restore MySQL Databases]
|
Check and Optimize MySQL Database Automatically with
Crontab/Cron
MySQL is a very popular free yet powerful database system. But
even in great databases, the tables may get fragmented with
overhead due to continuous update, or delete and insert operation
on data stored in database. Beside, it’s also possibility
that the databases may get corrupted. Thus, performing health check
on database and optimize MySQL server regularly is an important
task. |
|
Read more... [Check and Optimize MySQL Database Automatically with Crontab/Cron]
|
Administrating a MySQL server
Tips and tricks about administrating a MySQL server. |
|
Read more... [Administrating a MySQL server]
|
Resyncing table on MySQL Slave
Sometimes MySQL Replication may run out of sync - because of its
own buts or operational limitations or because of application
mistake, such as writing to the slave when you should be only
writing to the master. In any case you need slave to be synced with
Master.
|
|
Read more... [Resyncing table on MySQL Slave]
|
