…x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used …so that we can see the impact of growth in data-set on the insert rate. We can see … regular spikes in the insert rate, and the variation in the rate can be classified as large, because it …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…in most cases you do not know where exactly memory is allocated. This was not much of the problem in MySQL…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… available in both MySQL 5.6 and MariaDB 5.5. You can read more about BKA in MySQL 5.6 here and BKA in MariaDB 5.5 here. However, MariaDB 5.5 has one additional optimization that is used in… of 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
…89G 1.53G 1.89G 1.53G Innodb_data_reads 120552 123872 100551 103011 77213 Innodb_…in MySQL 5.6, is that because of a bug in MySQL 5.6 code? As MRR was used in both MySQL…large enough so that the index tuples fit in the buffer. But there is no performance improvement when the workload is in-memory, in…
Comment: Finding out largest tables on MySQL Server
April 24, 2012 By 24 Comments
… will not shrink if data is deleted. However, what I’m wondering is if there is a large discrepancy in the sizes, is… table that looks like this from the query in this article: +—————————————+———+——–+——–+————+———+ | CONCAT(table_schema, ‘.’, table_name) | rows | DATA | idx | total_size | idxfrac…/lib/mysql/databasename # ls -lh tablename* -rw-rw—- 1 mysql mysql 8.7K 2010-08-05 16:31 tablename.frm -rw-rw—- 1 mysql mysql…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… WITH READ LOCK to temporary make MySQL read only. In many cases the period for which …large because of the time it may take to complete this statement. Lets look at what the problem is. As of MySQL… option can be especially helpful when backing up data from the slave with –safe-slave-backup option…
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 … 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…… this however results in the challenge as results you’ve gotten for small data set may not apply to large data set so you…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… 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… even with large data set but it will crawl with default innodb_buffer_pool_size. Also Innodb buffer pool caches both data and…_file_size Very important for write intensive workloads especially for large data sets. Larger sizes offer better performance but increase recovery times…
Post: Data mart or data warehouse?
July 15, 2010 By 13 Comments
… over multiple MySQL storage engines at various data scales. What is a data warehouse? It … two methodologies approach the problem of storing data in very different ways. The first methodology … fully normalized schema at data warehouse volumes. This is in large part because commercial database …
Post: Testing MySQL column stores
August 16, 2010 By 15 Comments
… had the opportunity to do some testing on a large data set against two MySQL column-store storage engines. I’d like to… of results of queries over the large data set Speed of results of queries over the large data set Basic security aspects The report… get accurate results for all of the queries on InfiniDB. In particular the query “select count(*) from carsales.sales_fact” when…
