….log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL… sec) Innodb Memory Usage Finally it is often helpful to check how much memory Innodb has allocated. In fact this is… memory allocated 2623331 Buffer pool size 7864319 Buffer pool size, bytes 128849002496 Free buffers 1 Database pages 8252672 Old database pages 3046376 Modified db…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
…_type=1 query_cache_size=32M thread_cache_size=30 table_cache=4096 join_buffer_size=6M key_buffer_size=12M server-id = 1…_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock When I start the database service that starts smoothly with… to the database increases reaching the maximum of connections and I have to re-restart the server. I’ve checked the security…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
…based replication. To accomplish that, row level locking databases also acquire gap locks. What is a …72C, ACTIVE 755 sec 4 lock struct(s), heap size 1248, 3 row lock(s), undo log … gap locks except for foreign-key constraint checking or duplicate-key checking. The most important difference between …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… your database is large so you need large buffer pool, if not – setting buffer pool a bit larger than your database size will… than your database size you would not loose much anyway. You also may choose to set buffer pool as if your database size is…. After you have decided with database size you need to check if there are any restrictions on Innodb Buffer Size you can use. Typically…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… per second. Database Size This comes back to the data locality but with same data access distribution the larger database you’ll have the more scattered records will be in the end thus larger database tend to recover longer. Buffer Pool Size… same portion of log files and perform same amount of checks if page was already flushed since last checkpoint. True – smaller…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… you can check if your innodb_log_buffer_size is optimal – if you see more than 30% of log buffer size being unflushed… buffer pool is sized well – if you have constantly a lot of pages free, it probably means your active database size is smaller than allocated buffer pool size so you can tune it down. Even…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 69 Comments
… depend on the workload. Hardware If you have large Innodb database size Memory is paramount. 16G-32G is the cost efficient value…’re looking for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your… MySQL 4.1 and now stable enough to use. Also check if your application can run in READ-COMMITED isolation mode…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… sure what application does or does not do with the database. Database is production critical with serious role in serious company so… First we needed to do a sanity check on existing replication setup. As we’re checking replication consistency down the road we… to keep this into account. We move database to MySQL 5.1 As the database size is relatively small we do mysqldump and…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… total load time is 8836 sec (2.45h). The size of database after load is 1.6G which is impressive and give… DELIMITERS ‘,’,'\n’,'\”‘ NULL AS ”;” Load time: 13065 sec ( 3.6h) Database size after load is 65G , which is discouraging. It seems it… really about InfoBright vs MonetDB comparison. My goal was to check how available OpenSource software is able to handle such kind…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… lot lot of insertions queries on these same tables. I checked “iostat -dx 10″ and the %util is not really constant… “innodb_buffer_pool_size” is set to 4Go but the whole database size is almost 8Go (~60 millions records). This database contains some real-time information, so if the database is slow…
