…have_dynamic_loadingblogpercona.commanual have_geometryblogpercona.commanual have_innodbblogpercona.commanual have_opensslblogpercona.commanual have_partitioningblogpercona.commanual have_profilingblogpercona.commanual have_query_cacheblogpercona.commanual have_rtree_keysblogpercona.commanual have…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…to multithreading–deadlocks, data races, starvations etc–have a big impact on application’s stability…Valgrind dynamic analyzer suite. Now, Valgrind does not need much introduction, especially to the MySQL server …it is true that machine native word stores/loads are technically atomic, i.e. you cannot…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
… have to match byte by byte for cache hit to happen. This means if you would place dynamic comments in the query, have…. Most of them quite likely would not have change their result set but MySQL has no way to identify which one of… it works with MySQL to add caching but you can enable query cache so it works faster. Low load applications – If you…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
…following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If … request make persistent connections relevant again. Automatic load balancing and fall back I would like …would like to go further and have TTL based client cache with dynamic back end. I would …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… yet know answer for – for example will LOAD DATA INFILE be optimized same way as … for building the indexes – does it uses dynamic or static record format ? (static record format …have the problem fixed soon ? Yes indeed there is patch out where already which may come in MySQL 5.2 or even MySQL…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… dealing with performance problems (part MySQL related and part related to LAMP in …dynamic pages (there are also exceptions) but you really should have Keep Alive enabled while serving images. It especially hurts not to have one if 30 thumbnails are loaded per page if you do not have one…
Post: Progress with ClickAider project
October 24, 2007 By 21 Comments
… few bugs which we might have. We use GeoIP DNS based load balancing between “gathering” servers… just not ready. MySQL Performance is in fact the most serious issues we have to work … aggregation because we want absolutely unrestricted dynamic filters and dynamic timezones and this makes things hard …
Post: Trying Archive Storage Engine
November 12, 2006 By 6 Comments
… Name: requests_061111 Engine: MyISAM Version: 9 Row_format: Dynamic Rows: 8048913 Avg_row_length: 252 Data_length… So we have to go and check size of on disk file: -rw-rw—- 1 mysql mysql 19 …. May be this is because server is loaded and having concurrent IO which randomizes otherwise sequential IO…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…in sysbench; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in comments, … result, but how the system behaves in dynamic. What’s wrong with existing benchmarks? Well, …user load ? The same for mysqldump, how does it affect short user queries ? In fact I have …
Post: Innodb Fuzzy checkpointing woes
May 10, 2006 By Leave a Comment
… to fix it ?  I think fuzzy checkpointing should be dynamic and based at amount of log space free rather than… is loaded and compare it to constant. However the shared drive at shared MySQL virtual hosting and powerful RAID system may have very different performance properties. This means for example if you have RAID…
