June 20, 2013

Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5

April 4, 2012 By 4 Comments

… that the following changes were made on MariaDB 5.5 config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on… 2.2G Innodb_data_reads 329115 355323 143808 335526 16164 15506 Innodb_pages_read 329115 355323 143808 358308 144798 144881 Innodb_rows_read… two other most important numbers are values for Innodb_buffer_pool_reads and Innodb_data_read. We can see that with appropriately…

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , , , , , , , , , , , , , ,

Comment: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 27, 2013 By 1 Comment

… vital important is from the design. When deleting a document, InnoDB Fulltext index does not delete its tokenized words from corresponding… re-inserted, but with different documents And regarding why the config.ibd etc. are still there when you drop the indexes… index again. In terms of information_schema.innodb_ft_config table, it is really an internal config table, not for the purpose of…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

… this article can cover, and might wander into Apache, networking config, caching layers, etc. Wherever the problem is, we’ll track… indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be.) Or maybe the… might find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA…

Filed Under: Insight for Developers Tagged With:

Comment: Why MySQL could be slow with large tables ?

November 14, 2008 By 141 Comments

…, but when I change mysql vars and restart server, my configs are not applied, defautl mysql applied, and my.cnf are…? Where are written this configs? – do i switch table from MyISAM to InnoDB (if yes, how to configure InnoDB for best performance?) – what…

Filed Under: Insight for DBAs Tagged With: ,

Comment: New Forum Categories: Help Wanted, For Hire

March 5, 2013 By 1 Comment

Hi, My Current MYSQL Config as below. Could you please provide us suggestions to improve …_DIRECT innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb…_DIRECT innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb…

Filed Under: Events and Announcements Tagged With:

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

… of 1 to 20 nodes. cd shard-query #generate a config for 20 shards (adjust to your number of nodes) php…=8 innodb-read-io-threads=16 innodb-recovery-stats innodb-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-timeout innodb-rollback-segments=16 innodb-stats-auto-update=0 innodb-stats…

Filed Under: MySQL

Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5

March 21, 2012 By 10 Comments

… note that the following changes were made in the MySQL config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on… 20920 23734 Innodb_buffer_pool_read_requests 1361851 1264739 1235472 1263290 1235781 Innodb_buffer_pool_reads 120548 102948 76882 102672 76832 Innodb_data….89G 1.53G Innodb_data_reads 120552 123872 100551 103011 77213 Innodb_pages_read 120548 123868 100551 123592 100566 Innodb_rows_read 799239…

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , , , , , , , , , , , , , ,

Post: Using Flexviews - part two, change data capture

March 25, 2011 By 26 Comments

….demo ( > c1 int auto_increment primary key, > c2 int > ) > engine=innodb; Query OK, 0 rows affected (0.00 sec) mysql> insert… Note that you can enable auto_changelog=true in the config file to automatically record changes for any table, starting from… –ini=consumer.ini. This is because this is the default config filename to search for. I included it in the earlier…

Filed Under: Insight for DBAs, Insight for Developers, MySQL

Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)

December 21, 2010 By 11 Comments

… Server: innodb_log_file_size=4G (innodb_log_files_in_group=2) innodb_flush_neighbor_pages=0 innodb_adaptive_checkpoint=keep_average innodb_read_ahead… ibdata1 and innodb_log_files located on separate RAID10 partitions, InnoDB datafiles on the Virident tachIOn 400G card The raw results, config, and script are in our Benchmarks Wiki. Here are the graphs: 13G innodb_buffer_pool_size: In…

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , ,

Comment: How to estimate time it takes Innodb to Recover ?

June 25, 2008 By 7 Comments

…! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… InnoDB… currently: these config (my.cnf) were all disabled from 20 servers: # Uncomment the following if you are using InnoDB tables #innodb_data_home…

Filed Under: Insight for DBAs Tagged With:
« Older Posts
Newer Posts »