… means MySQL can employ many other optimizations like for example if columns other then the secondary key columns are required to be… MySQL 5.5 While with join_buffer_size set to 6M and read_rnd_buffer_size set to 6M, the query time for MySQL… counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
March 7, 2012 By 21 Comments
I am using AWS MySQL RDS, InnoDB engine. Our requirement is to insert data in same table and read from … 22,518,912 rows it is taking 14min ( avg_row_size is 136 around 2.85 GB). I wrote separate script…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld…increase CPU time spent. This is because IO handling requires significant number of CPU. With Percona Server, enabled full…12.83M 324.99 0 32.65k 0 # Query size 294.90M 14 783 158.14 621.67 …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in… general. This plugin requires careful configuration because it uses a threshold for which there is no good one-size-fits-all value… max_connections problems (the use of fixed-size connection pooling, for example, which can sometimes require application downtime to resolve), then it…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…does not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, which… 0x5e06270 is 0 bytes inside a block of size 800000 alloc’d ==9090== at 0x4C28FDF: malloc… unsigned int*) (sp_head.cc:2913) ==9090== Required order was established by acquisition of lock …
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt its…are not configuring the InnoDB buffer pool size or log file size, and not using InnoDB. If …that person involved if possible. In addition to requiring more than the configuration as input, the consultant…
Post: MySQL Sizing questions
June 23, 2006 By 4 Comments
… to the order of magnitude. Seriously in MySQL Consulting practice it would not be exception … case differences it hard even to give sizing recomendations even if application is defined. For …few more variables and very well estimate hardware requirements. These would of course apply to particular …
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… – these are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size. If you’re using… be impractical. Here is why: List of rarely considered MySQL Server Memory Requirements Thread buffers can be allocated more than once for…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…, and read from the db only when required. I tested with a memcached size of 1GB, 2GB, and 4GB. For… do. Using this application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions like Tokyo Tyrant… update, and read from the db only when required. I tested with a memcached size of 1GB, 2GB, and 4GB. For these…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL will fail to start on…=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size…-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To…
