Manage Query Cache
You can check whether the query cache is present in your MySQL server using the following statement: mysql> SHOW VARIABLES LIKE ‘have_query_cache’; You can defragment …
You can check whether the query cache is present in your MySQL server using the following statement: mysql> SHOW VARIABLES LIKE ‘have_query_cache’; You can defragment …
mysql -u -p -h By default you would use the root user with no password if connecting to localhost only. While it does simplify administration …
In a replication setup, a master MySQL server updates one or more slaves. Transactions are committed sequentially, and a slow transaction can cause the slave …
Mysql set up (“my.cnf”). The MySQL config file, my.cnf. Here is what to add under the [mysqld] heading. The two lines, “max_connections” and “max_user_connections” are …
If your MySQL connection is failing and returning the message ERROR 2002 (HY000): Can’t connect to local MySQL server through socket, then chances are your …
Use the following outline to connect and begin querying the MySQL server from within your PHP scripts. Connect to the MySQL server Use the following …
Here are a few initial things (common mistakes) to take a look at: – Make sure that after you created your database and database user …
The most common cause for this error, is a failed downgrade of MySQL from 4.1 to 4.0. Many changes were made between MySQL 3.x, 4.0.x, …
Overview This function displays a table of the processes that use CPU, memory, and MySQL. The table displays who is using the process, CPU usage …
Overview The Service Manager area enables you to start and stop available services on your server. The following services are available: antirelayd – The …
You can restart any of the available services on the web server at any time. You can restart the following services: Mail Server (Exim) DNS/Name …