…increase after executing a particular query. Or, maybe mysqld is seemingly…you have stripped binaries, simply test the procedure below and see …cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona/mysql…find that the default options will perform well in most scenario’s. …
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…hear complains about MySQL interactive performance – serving simple standard web traffic is drastically impacted when some heavy queries are ran in…MB test.md_cache_test_small.PRIMARY 216.35031509 test.md_cache_test_small.k 0.13414192 test.md_cache_test_big.PRIMARY 253.21095276 test.md_cache_test_big…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | 38563413074 |…performance system is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL…. Or we might have a test server to run on. It…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
…performance, while join performance degraded dramatically. Here is why: mysql> explain select SQL_NO_CACHE…query performance is 30% lower. Also note the times themselves – traversing about same amount of rows full table scan performs…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
…bit more query hacking and we get a query which will …caches: mysql> select concat(“CACHE INDEX “,table_schema,”.”,table_name,” IN “,table_schema,”_”,table_name,”;”) from information_schema.tables where table_schema=’test… key cache creation exercise you probably wonder how much performance gains…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…of storage engines we tested ranges with and without LIMIT clause, and tested queries which need …cache size : 4096 KB 16GB of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL… 50 READ_FTS Query: SELECT min(dob) FROM $tableName The hardest query performs a scan of all …
Post: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
August 28, 2007 By 57 Comments
…; mysql_query(“INSERT INTO count_test SET b=$b, c=ROUND(RAND()*10), d=MD5($i)”); } First of all, let’s try to perform some query on this table using indexed column b in where clause: mysql> SELECT SQL_NO_CACHE SQL_CALC_FOUND_ROWS * FROM count_test… if we’ll try to use two separate queries: mysql> SELECT SQL_NO_CACHE * FROM count_test WHERE b = 666 ORDER BY c LIMIT…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… as memory). With MySQL common sense however does not always works – we’ve seen performance issues with large query_cache_size also sort_buffer…. It performs same as MySQL 5.0 and MySQL 5.1 with small table cache. With table_open_cache increased to 16384 the test took 750… even in Performance focused MySQL 5.4. As we can see large table_cache (or table_open_cache_ values indeed can cause significant performance problems…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration… cause downward spikes in performance. Other then that, I have also disabled query cache to avoid contention caused by query cache on write heavy workload…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… of storage engines we tested ranges with and without LIMIT clause, and tested queries which need to …cpu MHz : 1800.163 cache size : 1024 KB 4GB of RAM MySQL version We used MySQL 5.1.16-… LIMIT 50 READ_FTS Query: SELECT min(dob) FROM $tableName The hardest query performs a scan of all million…
