…sets are cached from query cache. Pretty impressive. So what my recommendations would be about using these caches for your application ? Cache…caches to work, ie query cache enabled, memcached running, apc enabled for cli mode etc. Main PHP File: global.php file with…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…Query will perform on each database. To do the size comparison, I used the du utility: InnoDB file size on disk: 42GB (with…SET character_set…cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
… PHP driver. If …caching them. Persistent Connections Ajax applications with frequent case of one query…size caching Would be very helpful for simple applications which may run query…cache with dynamic back end. I would expect many people would like to see memcached hooked up to it to share result sets…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… of full table scan. Not all queries are going to be affected same way…with following simple shell script: [root@DB10 ~]# for i in 1 10 100 1000 10000; do ./benchmark.php…settings for MyISAM (table_cache=64) and set innodb_buffer_pool_size=8G innodb_flush_logs_at_trx_commit=2 innodb_log_file_size…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…sooner with focused… medium size …16651488365119 | +———-+—————–+——————+——————+——————+——————+ 1 row in set (2… PHP code…cache it, tune it, get more hardware in this order. It is often it is possible to get rid of some queries, cache…
Comment: MySQL Query Cache
July 28, 2006 By 70 Comments
… on the query cache is almost pointless. It just ends up being invalidated all the time so I just set the cache size to zero to avoid even wasting any memory. I find my real boosts are when I use php with memcached and squid or mod_cache on Apache. Kevin
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… to play with read-ahead depth here. These settings mean there…data corruption, crashes, or wrong query results get the highest …http://bugs.mysql.com/bug.php?id=29560 Concerning a…Cache with good results. I just wrote the post on this this matter the other day – choosing innodb_buffer_pool_size…
Post: Why do you need many apache children ?
February 5, 2007 By 15 Comments
… used even for medium size web sites which … rather high MaxClients settings (in hundreds) and …with your local network – Database Server, File Servers etc, if you’re querying…seconds or use some caching or lower timeout is other …fat and ugly. Seriously with modern PHP applications each apache children…
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
… operations! (http://www.pcper.com/article.php?aid=669&type=expert&pid=3)…filesystems-to-an-ssds-erase-block-size/) 5) Set the drive mount in /…OS caches innodb_flush_method=O_DIRECT 9) We get the best results with…3500 queries a second with peaks up to 10000 queries being handled well. The query mix …
