…working for a customer benchmarking insert…volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL …can see the impact of growth in data-set on the insert rate. We can…in the rate can be classified as large, because it varies between ~6.5k to ~12.5k INSERTs per second, with…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements ? memory tables ? In…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…in both MySQL 5.6 and MariaDB 5.5. You can read more about BKA in MySQL 5.6 here and BKA in…works with equi-joins. Now let me briefly explain how hash join algorithm works…data is read from disk 2.2G vs 5G. However, there is one number in MariaDB 5.5 that is quite large…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
….53G Innodb_data_reads 120552…in MySQL 5.6, is that because of a bug in MySQL 5.6 code? As MRR was used in both MySQL…this works only with joins and specifically with …set large enough so that the index tuples fit in the buffer. But there is no performance improvement when the workload is in-memory, in…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…WITH READ LOCK can be quite large…MySQL 5.5 FLUSH TABLES WITH READ LOCK does not work as optimally as you could think it works. Even though with… 5 rows in set…with Percona Xtrabackup. Many other tools have similar option. This option can be especially helpful when backing up data from the slave with…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
What does working with large data sets in mySQL teach you ? Of course you have to learn a lot … to learn when working with large data things in MySQL is patience and careful planning. Both of which relate two single property of large data sets – it can take…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… more MySQL limitation which requires you to be extra careful working with large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues… result sets. So if you’re dealing with large data sets and complex queries here are few tips Try to fit data set you’re working with in memory – Processing in…
Page: Consulting for MySQL
July 31, 2006 By
… avoid downtime. Customized Training for MySQL Want your developers to learn MySQL best practices ? How to work with large data sets in MySQL or how to optimize queries ? Customized…. Data Recovery for MySQL Lost your data due to corruption, hardware failure or developer error ? We’ll work with you to recover as much data as…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight… to MyISAM. MyISAM may work kind of OK with default key_buffer_size even with large data set but it will crawl with default innodb_buffer_pool…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
We’re working with web site preparing for massive growth. To make sure it handles large data sets as part of the process we work on generation test database of significant size as testing your application on table with…. Why ? Because by default mysql_query uses mysql_store_result C library call and buffers all result set in the process memory. Not good…
