…MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements ? memory tables ? In a lot of cases you have to…complicated as good tools to detect memory leaks like valgrind are too slow to run in production. So the best thing to…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
…of users use prepared statements. Bug Reporting and Tracking The MySQL…to run MySQL in production. MySQL as it is now works for a lot of applications, in particular because most of them use only small portion of MySQL…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
…have to wait until statement is completed to make sure it will be executed on the slave in proper order. Gets pretty complicated…to be done outside of MySQL Server) as otherwise the script will fail second time. If you need result to be even closer to one of…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…one must consider the cost of the benefit versus the value added by having the benefit available. Making a blanket statement…MySQL you might be > better of using several queries than doing complicated ones. Of > course you would rather use IN() than do 100 of…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…statements and catching up) The main challenge in such failure is the fact you have many trashed copies to deal with. If you have just one or several small tables corrupted you can reload them. One option is to…
