…MySQL/InnoDB uses async writes, so this will emulate database load, and second, async mode allows to…size=16384 –report-interval=10 run You may see I gather metrics every 10 sec to see how stable the…
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…size 7864319 Buffer pool size, bytes 128849002496 Free buffers 1 Database pages 8252672 Old database pages 3046376 Modified db pages 23419 I’m using the…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…in the database directory and then you try to drop the database, it will fail. These things tend to happen at inconvenient times. The pmp-check-mysql…the incremental increase in…
Post: When should you store serialized objects in the database?
January 21, 2010 By 42 Comments
…to one piece of data in a very large blob, the effort MySQL has to go to is greatly increased. The…In practical terms I would expect this increases the size of a working set since more data must be kept in the buffer pool. The…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…database sizes tend to always grow and very rarely shrink. Which leads to a challenge faced by almost everyone how do you maintain your performance in the…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…the database more than just prefix compression. The downside in gzip is increased usage of CPU time. PZ: We will see how…the execution is not serializable. PZ: Cool. This is one of little known new features in MySQL 5.1 Q15: How…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… increase recovery time, so in case of MySQL crash or power failure it may take long time before MySQL Server is operational again. So how to… from which already made it to the database. Unlike “redo” phase “undo” phase can’t be reduced by sizing your log files. Even more…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
…to the disk and undo phase – rolling back uncommitted transactions. As MySQL 5.0 these seems to be done in the background. In the future to increase…
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 116 Comments
…Mysql server version 4.1.20 and i in my server there are almost 10 databases but 2 databases…size=8M key_buffer_size=64M read_buffer_size=1M read_rnd_buffer_size=1M sort_buffer_size=203K innodb_additional_mem_pool_size…1.615 ————– Please suggest me how to increase the performance of my server…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql…size…# Databases # …to guess whenever current IO subsystem can handle it or whenever it needs an increase. The…to know the costs in “utility” model and you do not have to be in the cloud to…
