…: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-… is probably a bit closer to real life workloads. It’s still the AUTOCOMMIT mode,… = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… all caches compared to MySQL Server, by measuring just the time it takes cache to return the data. In the real life …envinronment are: Cache Type Cache Gets/sec Array Cache 365000 APC Cache 98000 File Cache 27000 Memcached Cache (TCP/IP) 12200 MySQL Query Cache (TCP/IP) 9900 MySQL Query Cache (Unix …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… can make your life easy. However, there is one such tool, pt-query-digest (from Percona Toolkit… to attack the right query in the right way. But vanilla MySQL does have its limitations, … as information about the queries‘ execution plan (which includes things like whether Query cache was used or not…
Post: Getting real life query speeds with MySQL
January 10, 2007 By 10 Comments
…query performance improvements followed indexing/query changes or MySQL configuration changes our customers often decide to run the query…_NO_CACHE or disabling QueryCache for the test. This works by blocking query cache but …by these queries will not be cached, if it is not the case in your real life…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
…most sense, including caching, message queuing, database sharding, and replication. Optimize MySQL schema and indexes to support efficient queries. Instrument … MySQL replication. Monitor MySQL servers in production. Discuss security issues with MySQL. Solve via case-study some real-life problems …
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
… global user data is expected to be cached on startup but even if it …(often together with strace) are great tools for MySQL Performance analyses. Too many people end …which process already “owns” and in real life it can get much slower than Monty…or LIMIT 10 in full table scan query you well may not …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… CPU usage. In real life workload results are likely to be very different. The schema and queries are described here Used hardware….004 cache size : 4096 KB 16GB of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5… OS cache is not scaled. READ_KEY_POINT_LIMIT Query: SELECT name FROM $tableName WHERE country_id = %d LIMIT 5 The same query…
Post: Living with backups
November 6, 2008 By 28 Comments
… out and ready to save someone’s life (or job at least). Unfortunately taking backup …Since the hit ratio becomes worse as the cache is being filled with random information additional … MySQL data directory will result in a total disaster after MySQL stops responding to the incoming queries quick…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… CPU usage. In real life workload results are likely to be very different. The schema and queries are described here Used hardware… : 2 cpu MHz : 1800.163 cache size : 1024 KB 4GB of RAM MySQL version We used MySQL 5.1.16-beta sources for… %d and %d The same comment as for previous query. READ_KEY_RANGE Query: SELECT name FROM $tableName WHERE country_id = %d…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… storage engine because it makes life much simpler in the end for …slave available for all long reporting queries. In case MyISAM was chosen … see clustering by primary key, caching data, higher concurrency, background flushes …not so common paths in the MySQL server – in particular Optimizer may …
