…Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance_schema_table_handles_lostblogpercona.commanual Performance_schema_table_instances_lostblogpercona.commanual Performance… sql_big_selectsblogpercona.commanual sql_big_…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… to the question is: for small tables, everything can reside within a single extent. For big tables, a secondary index reserves different extents…. I frequently see batch jobs killing server performance overtaking buffer pool. Though full table scan is only one of replacement policy optimizations…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 141 Comments
… server to manage a big tables (now about 78Mb, with increment of 1Mb/day) — I have used a table MyISAM, info from phpmyadmin… # clients (those using the mysqlclient10 compatibility package). old_passwords=1 big-tables [mysqld_safe] log-error=/var/log/mysqld.log pid-file… manually in my.cnf for best performance & low disk usage? – may i remove old_passwords=1 & big-tables? — Web Server with Apache 2…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… things happen – MySQL kept being “simple” and introduced relatively simple performance boosters – Query Cache and Replication, which were clearly not enough… and processing was using non SQL and not systems – Google Big Table, Amazon Dynamo and SimpleDB, Hadoop, CouchDB which comes computed with…
Post: Optimizing InnoDB for creating 30,000 tables (and nothing else)
December 22, 2011 By 5 Comments
… which means I can lie, cheat and steal to get performance. The simplest way is to use libeatmydata. This is a… disk all the time would get closer to the libeatmydata performance. I also want to disable syncing of the FRM file… CREATE TABLE into transactions of creating 100 tables at a time, I get an execution time of 3 minutes. This is a big…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… in sorted order can be a lot of help for big scans. This will reduce the gap but I doubt it… compose the complex object which was previously normalized to several tables or perform complex queries finding relationships between objects. Normalized structure and… join of the table to other 30mil rows table and it will be completely random. We’ll need to perform 30 millions of…
Post: Performance Schema tables stats
May 2, 2011 By 2 Comments
My previous benchmark on Performance Schema was mainly in memory workload and against single tables. Now after adding multi-tables support to sysbench… are on Benchmark Wiki. If we look on performance overhead it appears rather big in read-only benchmark, and it is well… able to get from performance schema tables. 1. table_io_waits_summary_by_table mysql> select * from table_io_waits_summary_by_table where OBJECT_NAME…
Post: Performance Schema overhead
April 25, 2011 By 22 Comments
…) PERFORMANCE SCHMEA enabled, with all consumers ON (PS on) PERFORMANCE SCHMEA enabled, but only global_instrumentation consumer enabled. It allows to gather table and index access statistics (PS only global) PERFORMANCE SCHMEA… is about the same with all disabled consumers. Is that big or small ? I leave it for you to decide, I…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… can make a substantial difference for the database and application performance. Over time msl patch grew with new features to let…-federated-storage-engine’ ‘–without-bench’ ‘–with-zlib-dir=bundled’ ‘–with-big-tables‘ ‘–enable-assembler’ ‘–enable-local-infile’ ‘–with-mysqld-user=mysql’ ‘–with…
Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
September 17, 2007 By 14 Comments
… MySQL. Why am I looking on reporting performance optimization ? It is for ClickAider project which… *************************** 1. row *************************** id: 1 select_type: SIMPLE table: dt type: ALL possible_keys: NULL key:…method for GROUP BY by using SQL_BIG_RESULT hint I can see GROUP BY…
