Mysql
Mysql is most famous open source RDBMS (Relational database management system) software used by millions of websites. Most of website with very large Mysql database experience storage problem because /var partition is to small which holds Mysql data files and folder by default. If you are experiencing such a problem then you have to move your Mysql data directory to other linux partition (eg: /home). To change your directory without affecting Mysql configuration. Follow these steps. Read more…
Some times there are many many sleep processes in your SQL connection. These sleep connections consume a lot of resources (RAM, cache and processor). This can cause you mysql server slow down. If your mysql server is not responding then the query to the database will take a lot of time. In such situations, your website will open very slowly.
This is really frustrating for webmasters. Here, I will show you how can you get rid of these sleep processes. Read more…
If you have very large mysql database then it is very hard to backup and restore using the conventional phpmyadmin or any other program ( like bigdump).
In this Tutorial I will explain you how to backup and restore a larger database ( having millions of rows). This tutorial can be used while moving your database from one server to another.
First you need to have shell (ssh) access to your server.You can use any free program like putty to connect your server Then follow the steps: Read more…
Does your website take too much time to load? The load time of your website could be a crucial parameter that makes it impressive and useful for its end users.
Normally the websites with too many graphics and heavy designs take long time to load. However, sometimes even simple and light weight designed websites take exceptionally long time to load.
While there are many factors that contribute to the load time, one important factor is the SQL performance. If your website uses a very big database and there are many DB queries then this too contributes to the long load times.
In this case you have 2 tricks to enhance the performance of your website:
- Enable Mysql query Cache
- Or Install APC Cache
Read more…
Recent Comments