| |
| MySQL Tuner Optimization
Posted in MySQL > Miscellaneous by tutorialgrub on Sep 29, 2011
Hey guys, if you are having MySQL issues on a linux box, try using this, its called MySQL Tuner. Its a neat little tool that tells you why your MySQL Configuration sucks, and it tells you how to fix it. Idiot proof. |
| |
| Truncate table in MySQL
Posted in MySQL > Miscellaneous by tutorialgrub on Sep 29, 2011
This article demonstrates how to use the TRUNCATE command and what is the difference between truncate and delete in MySQL. |
| |
| Simple Replication in MySQL
Posted in MySQL > Miscellaneous by tutorialgrub on Sep 25, 2011
This tutorial explains the steps needed to replicate one or more databases from one server in MySQL across to another, ensuring they synchronise and stay up-to-date throughout, with the minimal amount of downtime possible. |
| |
| MySQL DISTINCT usage
Posted in MySQL > Miscellaneous by tutorialgrub on Sep 22, 2011
How to use the distinct keyword in MySQL to eliminate duplicated values in the result list of a select statement. |
| |
| Setting Up PHP/Mysql on Server 2003
Posted in MySQL > Miscellaneous by tutorialgrub on Sep 21, 2011
Since this can be a pain in the a^&, and Jordan wanted a tutorial, I thought I would post this here (and not to mention that I can use it for future reference). |
| |
| MySQL UNION usage
Posted in MySQL > Miscellaneous by tutorialgrub on Sep 20, 2011
This article shows you how to use UNION in MySQL to combine more query output into a single result set. |
| |
| Concatenate strings and fields in MySQL
Posted in MySQL > Miscellaneous by tutorialgrub on Sep 19, 2011
This article demonstrates how to concatenate two or more strings and fields in MySQL using the CONCAT() function. |
| |
| Optimizing MySQL: Configuration
Posted in MySQL > Miscellaneous by tutorialgrub on Aug 27, 2011
In this tutorial we'll take a closer look at MySQL configuration directives which have direct influence on MySQL performance. |
| |
| Optimizing MySQL: Importance of JOIN Order
Posted in MySQL > Miscellaneous by tutorialgrub on Aug 22, 2011
This third part of MySQL optimizing tutorial mini series shows an importance of table order during JOIN. The difference between regular JOIN and optimized one is dramatic, so keep reading! |
| |
| Optimizing MySQL: Log Slow Queries
Posted in MySQL > Miscellaneous by tutorialgrub on Aug 13, 2011
This tutorial is the second part of the MySQL Optimization mini series and introduces the Slow Query Log as well as describes its setup and output. |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 >> Next |
