TutorialGrub.com Databases tutorials. http://www.tutorialgrub.com 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 http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/MySQL-Tuner-Optimization_18492.html http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/MySQL-Tuner-Optimization_18492.html Thu, 29 Sep 2011 20:00:01 CDT This article demonstrates how to use the TRUNCATE command and what is the difference between truncate and delete in MySQL. http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/Truncate-table-in-MySQL_18491.html http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/Truncate-table-in-MySQL_18491.html Thu, 29 Sep 2011 10:00:01 CDT This tutorial explains the steps needed to replicate one or more databases from one server in MySQL across to another, ensuring they synchronise and s http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/Simple-Replication-in-MySQL_18481.html http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/Simple-Replication-in-MySQL_18481.html Sun, 25 Sep 2011 06:00:01 CDT How to use the distinct keyword in MySQL to eliminate duplicated values in the result list of a select statement. http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/MySQL-DISTINCT-usage-_18484.html http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/MySQL-DISTINCT-usage-_18484.html Thu, 22 Sep 2011 12:00:03 CDT 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 r http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/Setting-Up-PHPMysql-on-Server-2003_18495.html http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/Setting-Up-PHPMysql-on-Server-2003_18495.html Wed, 21 Sep 2011 02:00:02 CDT This article shows you how to use UNION in MySQL to combine more query output into a single result set. http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/MySQL-UNION-usage-_18494.html http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/MySQL-UNION-usage-_18494.html Tue, 20 Sep 2011 15:00:01 CDT This article demonstrates how to concatenate two or more strings and fields in MySQL using the CONCAT() function. http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/Concatenate-strings-and-fields-in-MySQL_18480.html http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/Concatenate-strings-and-fields-in-MySQL_18480.html Mon, 19 Sep 2011 15:00:01 CDT In this tutorial we'll take a closer look at MySQL configuration directives which have direct influence on MySQL performance. http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/Optimizing-MySQL-Configuration_17124.html http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/Optimizing-MySQL-Configuration_17124.html Sat, 27 Aug 2011 04:00:01 CDT This third part of MySQL optimizing tutorial mini series shows an importance of table order during JOIN. The difference between regular JOIN and optim http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/Optimizing-MySQL-Importance-of-JOIN-Order_17130.html http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/Optimizing-MySQL-Importance-of-JOIN-Order_17130.html Mon, 22 Aug 2011 10:00:01 CDT 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. http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/Optimizing-MySQL-Log-Slow-Queries_17145.html http://www.tutorialgrub.com/tutorials/MySQL/Miscellaneous/Optimizing-MySQL-Log-Slow-Queries_17145.html Sat, 13 Aug 2011 19:30:01 CDT