…, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – now … this may be too much of the wish but at least it should happen … still would normally need to manually chop your data to the multiple databases and handle…much support from MySQL to do so. What is really bad is Parallel query. …
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
…directly impact service availability, which means that what you could wish for the most are quick and …problems were with MySQL packages upgraded from 5.1 to 5.5. The former were not fully uninstalled, … One example of such specific case, which limits your options, is for example a requirement for …
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…as DECIMAL field got whole another meaning in MySQL 5.0 MySQL generally supports legacy storage format for …. Safe Approach So what if you actually care about your user experience or at least about your data ? In … is taking a lot of time you may wish to create second QA/dev environment just for …
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… upgraded from MySQL 5.1 to Percona Server 5.5 and instead of expected performance improvement you see your performance being worse. What should you… but more often you just waste your time. Instead try to understand what has changed and what exactly changed for worse. I am… you might be up for deep investigation. You may also wish to create a repeatable test case which does not use…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…slave and pick the “crash point” as I wished. (I didn’t shut down the slave, … `test`; insert into test.t(a) values(1) *************************** 5. row *************************** Log_name: mysql-bin.000011 Pos: …7 rows in set (0.00 sec) What you see depends on your version of MySQL, because the …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… is more consistent with what I’ve seen others do. Then again, having your own wrapper function to … do much better with denormalized data. You may wish > to use denormalized data as cached lookup table … statement that using relations is bad is unwise. > 5. The n+1 pattern This probably should rather…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… CPU) using MySQL 4.1 and PHP 5.0. For memcached access memcache extension from…. Pretty impressive. So what my recommendations would be about using these caches for your application ? Cache… for your application. In different circumstances different layering may make sense. For example you might wish…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…at least we can use same “cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple …, such as where this query comes from or what application user triggered such query. Query Cache matching …this list. I also challenge you to post your own query cache wishes and ideas here, as far as …
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
… is fully transparent to the application, and what is very important it does not…query_cache appropriately. Otherwise you might wish to increase it and see if …SQL_CACHE col from foo where id=5. If you run in default …Cache might be not cache for your application: It caches queries Application objects…
Post: Trying Archive Storage Engine
November 12, 2006 By 6 Comments
… set (0.62 sec) Lets see what table compression gives us: *************************** 1. row …better than compressed by gzip. I wish Archive storage engine would specify… on the table changed from 5 min to about 4 minutes,…Summary: Archive storage engine does compresses your data and should be good…
