https://linkatopia.com/rob215/mysql The 25 latest links tagged, "MySQL" by Robert Giordano https://www.devart.com/dbforge/mysql/studio/mysql-create-index.html 2025-09-13T18:13:37Z good article on using INDEXES https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html 2021-10-12T02:40:15Z See changes in 5.7 that affect queries with GROUP BY https://www.liquidweb.com/kb/mysql-performance-myisam-vs-innodb/ 2021-04-16T03:23:15Z "Should I use InnoDB with WordPress, Magento or Joomla Sites? The short answer here is yes, in most cases."See the rest of this article for details https://stackoverflow.blog/2021/01/14/have-the-tables-turned-on-nosql/ 2021-01-21T14:35:06Z Interesting comparison https://www.techrepublic.com/article/how-to-back-up-mysql-databases-from-the-command-line-with-linux/ 2018-12-28T18:31:45Z http://stackoverflow.com/questions/6432178/how-can-i-check-if-a-mysql-table-exists-with-php 2016-06-14T02:23:26Z Even though this isn't the accepted answer, it looks like the best:if(mysql_query("DESCRIBE [table]")) { https://www.sitepoint.com/community/t/the-big-bad-thread-of-mysql-best-practices-and-other-useful-information/2716 2016-05-11T21:48:24Z Good stuff in here http://www.techonthenet.com/mysql/in.php 2016-05-11T22:18:40Z WHERE some-text-column IN ('aaa','bbb','ccc')WHERE some-int-column IN (1,2,3) http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php?rq=1 2016-02-21T21:20:02Z See two answers from user "Your Common Sense" https://phpdelusions.net/sql_injection 2016-02-21T21:39:02Z https://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html 2015-12-23T00:56:39Z Upgrading to MySQL 5.5 from earlier versions http://dba.stackexchange.com/questions/31412/which-mysql-version-to-use-5-1-or-5-5 2015-12-23T01:00:14Z https://seravo.fi/2015/10-reasons-to-migrate-to-mariadb-if-still-using-mysql 2015-05-20T19:59:05Z https://en.wikipedia.org/wiki/NoSQL 2013-06-05T13:31:21Z http://20bits.com/articles/10-tips-for-optimizing-mysql-queries-that-dont-suck/ 2009-09-16T18:43:56Z good article with some basics http://kevin.vanzonneveld.net/techblog/article/survive_heavy_traffic_with_your_webserver/ 2009-09-16T19:26:07Z Good tips to follow for mysql optimization http://jeremy.zawodny.com/blog/archives/002194.html 2008-04-09T02:45:27Z The first article I read on abstraction layers http://mysqldump.azundris.com/archives/57-Annotations-to-Five-Common-PHP-database-problems.html 2008-04-09T03:20:19Z The second article I read, somewhat related but also lists some schemas I need to read up on. http://www.xaprb.com/blog/2006/08/13/four-types-of-database-abstraction-layers/ 2008-04-09T03:29:09Z A third article with links to the other articles http://www.ilovejackdaniels.com/cheat-sheets/ 2008-02-26T23:41:08Z A bunch of nice cheat sheets and quick reference charts in PDF format. http://www.codepoetry.net/archives/2006/03/21/optimizing_a_vps_for_getting_dugg 2007-05-29T01:42:03Z Notes on Apache and MySQL optimization. http://iamcal.com/publish/articles/php/search/ 2006-11-06T22:16:17Z http://dev.mysql.com/doc/refman/4.1/en/index.html 2006-05-05T04:21:23Z http://www.simplemachines.org/ 2006-05-04T23:06:29Z http://www.tutorialized.com/tutorial/Optimize-MySQL-tables-for-speed/10695 2006-05-03T20:03:56Z