…tuning couple of MySQL settings. When low hanging fruits are fixed you end up with either fine tuning…, caching, using memcached, sphinx, implementing proper web caching…MySQL Server hardware the cost is going to be increasing dramatically after certain hardware size…. For single thread workload the …
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… For small and medium size applications you can log all requests to MySQL table for larger ones …times – mysql, memcache, sphinx, web services etc. For web applications doing processing in a single thread the … my checklist is usually get rid of it, cache it, tune it, get more hardware in this order…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
…no thinking time, no keying time), it uses MySQL C API and the server side prepared statement… the data cache of the storage. main common settings innodb_buffer_pool_size = 2048M innodb_thread_concurrency = … in some extreme cases, it is worth to tune. The following parameters are added. innodb_read_…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… bound, while to understand if MySQL goes through more rows than…thread and with some high amount of threads which do not show this effect well. So as you might see tuning IO subsystem can indeed be fun – there is a lot to deal with not even mentioning various seriolization, stripe sizes, cache…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…), and run some benchmarks. Tuning of TokuDB is much easier…size is also that TokuDB can keep in memory much more records then InnoDB / MyISAM. Actually in internal cache… take there https://launchpad.net/mysql-patch/mytools What makes …multi-core boxes running concurrent threads. Tokutek plans to fix …
