… only a final result, but how the system behaves in dynamic. What’s wrong with existing benchmarks? Well, all benchmarks are… that handle user load ? The same for mysqldump, how does it affect short user queries ? In fact I have a prototype based…). There are some results from my early experiments. Assume we have an usual sysbench setup, and we target an arrival rate…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…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: Content delivery system design mistakes
February 11, 2007 By 9 Comments
…, dynamic content has some of its own issues which need different treatment. DNS TTL Settings The system was using DNS based load… 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. Use Proper Web…
Post: Speedup your LAMP stack with LigHTTPD
May 21, 2006 By 14 Comments
… you have to stick to at least for dynamic content served by PHP or ModPerl. With “client per process” you end up having large amount of processes if you have… is load balacing and HA – you may have round robin or random request routing to your proxy servers, which pretty much any load…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… recently released by Oracle. First thing I’ve tried was DYNAMIC row format. After 3,5 hours of conversion we’ve… 30% drop in our I/O load. This was related to the fact that with DYNAMIC row format InnoDB was able to… happy with these changes and we’re really glad to have such a nice tool as new InnoDB plugin which now…
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… where it could be when peak load returns. This is actually the question I do not have good answer for. How can we detect how good IO subsystem do we have and how much load it can…
Post: Progress with ClickAider project
October 24, 2007 By 21 Comments
… those who interested. The project generates decent interest and we have about 3000 sites Registered over this time, which I consider… and working out few bugs which we might have. We use GeoIP DNS based load balancing between “gathering” servers in Europe and… from real time aggregation because we want absolutely unrestricted dynamic filters and dynamic timezones and this makes things hard to aggregate. This…
Post: Trying Archive Storage Engine
November 12, 2006 By 6 Comments
…. row *************************** Name: requests_061111 Engine: MyISAM Version: 9 Row_format: Dynamic Rows: 8048913 Avg_row_length: 252 Data_length: 2030206088 Max… which is surprising. May be this is because server is loaded and having concurrent IO which randomizes otherwise sequential IO. It would…
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… the main features which limits query cache effectiveness – if you have high write application such as forums, query cache efficiency might… you’re building application which is not designed for extreme load, like many personal application query cache might be all you…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
… something obviously wrong. Emulated Prepared Statements I would like to have easy time to switch from PS to standard statements to… one query per request make persistent connections relevant again. Automatic load balancing and fall back I would like to be able…. I however would like to go further and have TTL based client cache with dynamic back end. I would expect many people…
