-
Recent Posts
Recent Comments
Archives
- June 2018
- March 2018
- October 2017
- August 2015
- May 2015
- February 2015
- January 2015
- December 2014
- August 2014
- July 2014
- May 2014
- March 2014
- December 2013
- November 2013
- October 2013
- September 2013
- August 2013
- January 2013
- August 2012
- December 2011
- November 2011
- March 2011
- August 2010
- February 2010
- January 2010
- June 2009
- April 2009
- March 2009
- December 2008
- November 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005
- September 2005
- August 2005
- July 2005
- June 2005
- May 2005
- April 2005
- March 2005
- February 2005
- January 2005
- December 2004
- November 2004
- October 2004
- September 2004
Categories
Meta
Category Archives: MySQL
Alter tables with MySQL replication
I couldn’t find anything particularly useful about how to alter MySQL table structure in a situation where replication was being performed so I pretty much had to try something out to see if it worked. What I found was that … Continue reading
Posted in MySQL, Programming
Leave a comment
TRUNCATE TABLE on MySQL InnoDB databases
Having come up against the extremely poor performance of using TRUNCATE instead of DELETE on MySQL InnoDB tables (see previous post MySQL Truncate slow performance problems) I thought I better come up with a solution that didn’t mean leaving a … Continue reading
Posted in MySQL, Programming
2 Comments
Multiple SQL queries using MySQL and PHP
Something that I’ve had problems with using MySQL/PHP is the limitation of only being able to run one line of SQL at a time. Using something such as Microsoft SQL Server it’s possible to write multiple lines of SQL and … Continue reading
Posted in MySQL, PHP, Programming
3 Comments
Optimising MySQL a query with packed keys
I’ve been learning more about MySQL lately and particularly optimising SQL queries on large tables. Large, in this case, being at the moment hundreds of thousands of rows but soon to be millions. One of the problems I’ve had is … Continue reading
Posted in MySQL, Other, Programming
Leave a comment
MySQL Truncate slow performance problems
I was having problems with a MySQL TRUNCATE taking a long time on a very large table (with foreign keys). I had thought that TRUNCATE ran more quickly than DELETE but, according to the MySQL manual, that isn’t the case … Continue reading
Posted in MySQL, Programming
1 Comment
Implementing Iterator in PHP 5
There’s a good article on sharepoint about implementing Iterator in PHP 5: http://www.sitepoint.com/article/php5-standard-library/1. I’ve used it a couple of times now and it’s a great way to treat objects as collections. More info about the Standard PHP Library can be … Continue reading
Posted in MySQL, Programming
Leave a comment
MySQL load data infile and foreign key constraints
I’ve been up against a(nother) MySQL 4/PHP 5 ‘not doing all I want it to’ type problem. This time, it involved trying to do a bulk update on potentially tens of thousands of lines. Now, I don’t want to do … Continue reading