Categories
MYSQL

How To Move MySQL Data Directory On A Separate Partition

Prerequisite: A free partition that will serve as a dedicated MySQL partition. Note: These instructions assume that the partition you wish to mount is /dev/sdc1 Backup all MySQL databases Code: mysqldump –opt –all-databases | gzip > /home/alldatabases.sql.gz Stop tailwatchd and the mysql (tailwatchd monitors services, so disable it to prevent it from prematurely restarting mysql) Code: […]

Categories
MYSQL

How To Back Up Your MySQL Databases

MySQL is an open source relational database management system (DBMS) which is frequently deployed in a wide assortment of contexts. Most frequently it is deployed as part of the LAMP Stack. The database system is also easy to use and highly portable and is, in the context of many applications, extremely efficient. As MySQL is often […]

Categories
General Linux MYSQL

How To Use MySQL Query Profiling

What is the MySQL slow query log? The MySQL slow query log is a log that MySQL sends slow, potentially problematic queries to. This logging functionality comes with MySQL but is turned off by default. What queries are logged is determined by customizable server variables that allow for query profiling based on an application’s performance […]