June 19, 2013

Post: Why MySQL could be slow with large tables ?

June 9, 2006 By 141 Comments

…sequential access, jam packed rows – quite possible scenario for MyISAM tables. Now if we take the same hard drive …sorted order can be a lot of help for big scans. This will reduce the gap but I …of the table to other 30mil rows table and it will be completely random. We’ll need to perform 30 …

Filed Under: Insight for DBAs Tagged With: ,

Post: Innodb performance gotcha w Larger queries.

August 28, 2009 By 7 Comments

… in the batch performance improved, especially for network tests, however going to batches of 100 and 1000 values performance started to degrade… a batch. This was a big surprise for me as I’ve used batching with great performance gains a lot of times… on Innodb level, so I tried running the test with MyISAM tables instead. The process completed in 12 seconds for 1000 rows…

Filed Under: Insight for Developers Tagged With:

Post: Updated msl (microslow) patch, installation walk-through!

April 20, 2008 By 17 Comments

…difference for the database and application performance. Over time msl patch grew …without-bench’ ‘–with-zlib-dir=bundled’ ‘–with-big-tables‘ ‘–enable-assembler’ ‘–enable-local-infile’ ‘–with-… take significantly longer to close than MyISAM), database configuration, load, etc. Configuration …

Filed Under: Percona Software Tagged With:

Post: Troubleshooting MySQL Upgrade Performance Regressions

February 15, 2012 By Leave a Comment

….5 and instead of expected performance improvement you see your performance being worse. What should you do…INDEX, BIG_RESULT/SMALL_RESULT. Check whatever stats are the same (run SHOW INDEXES FROM for tables… settings such as innodb-stats-method and myisam-stats-method. For Innodb storage engines it…

Filed Under: Insight for DBAs, MySQL

Post: Performance impact of complex queries

January 17, 2007 By 11 Comments

…you use Innodb tables and so do not suffer from table locks reporting queries can affect web site performance dramatically. … or even careful file transfer if you’re using MyISAM tables. Chop it If you can’t execute this …it, meaning do not do it as all one big simple query or as set of queries going …

Filed Under: Insight for Developers Tagged With:

Post: Analyzing air traffic performance with InfoBright and MonetDB

October 2, 2009 By 50 Comments

….com/2009/09/29/quick-comparison-of-myisam-infobright-and-monetdb/) this week. And following… was 0.9.1 The table I loaded data is: CREATE TABLE `ontime` ( `Year` year(4) DEFAULT… how to do that, so I generated big SQL file which contained load statements. Load…compare or get info about air performance…

Filed Under: Benchmarks, MySQL Tagged With: , , ,

Post: Using VIEW to reduce number of tables used

September 28, 2007 By 12 Comments

…. For MyISAM it works better but still overhead can get significant because table_cache …you could write triggers to perform insert inserts to base tables instead of views. BEFORE …big problem. Technically if you can’t make inserts to the base table but can have them going to the different table…

Filed Under: Insight for Developers Tagged With: ,

Post: Why you should ignore MySQL's key cache hit ratio

February 28, 2010 By 28 Comments

… or miss takes. If you approach application performance optimization from the standpoint of response time …’s dedicated to MyISAM tables. Consider your mixture of storage engines (some InnoDB, some MyISAM, which is … based on how important those tables are to you, how big the indexes are on disk,…

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

Post: MySQL 5.6.7-RC in tpcc-mysql benchmark

October 8, 2012 By 22 Comments

…to test how it performs in tpcc-mysql workload from both performance and stability standpoints. …_buffer_pool_instances=8 makes a big difference on small buffer_pool sizes,…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover user=root skip-grant-tables…

Filed Under: Benchmarks, MySQL

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

February 26, 2013 By 1 Comment

…MyISAM FTS. We’ll get to performance…table_name | | | use_stopword | 1 | | table_state | 0 | +—————————+———+ 10 rows in set (0.02 sec) mysql> optimize table dir_test_innodb; +———————-+———-+———-+———-+ | Table…

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