Home » Tag Archives: MySQL

Tag Archives: MySQL

MySQL Backup and Restore

MySQL

Tutorial for MySQL backup and restore using command line for those of you who are doing it for the first time or have forgotten some parameter. First of all don’t forget that you need to have permissions to connect with the user you are going to use from the host you are executing this command. If it is from the ...

Read More »

MySQL Tuning Scripts

MySQL

MySQL tuning is essential if you are running high volume websites that run on MySQL. You will need this two scripts to help your MySQL tuning. I’m running a lot of high volume WordPress websites and apart from getting the advantages from caching with APC or memcached I’m tuning my MySQL server from time to time. For that purpose I’m ...

Read More »

skip-name-resolve to speed up MySQL and avoid problems

MySQL

MySQL Reverse DNS took us all day to debug and before reinstalling MySQL on another server guy who had this problem told us the solution: skip-name-resolve skip-name-resolve Problem After searching the net I’ve found that by default MySQL grants authentication on users based on IP address or hostnames. When there is a connection from a particular host, MySQL does a ...

Read More »

MySQL Full-Text Search with Multiple words

MySQL

Few weeks ago i had a project where i needed to search a large database and provide results based on their relevance. The answer was MySQL Full-Text Search. Normaly i have started coding and used the LIKE finction in MySQL to get the results and started testing on a small temporary database that i’ve created. After some part of the ...

Read More »