… the relational database was first implemented, write-ahead-logging and other technologies did not exist. This … can we effectively reduce the data size of any set, possibly by orders of magnitude, with almost no work? … sec) We can also check to see if any two numbers sum to zero: mysql> select a.val…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… of course. You need buffer pool a bit (say 10%) larger than your data (total size of …It is usually much better to simply check it. Start MySQL With 10GB Innodb buffer pool for… tables (mysql database, temporary etc) will need it, .frm file, binary logs, or relay logs, Innodb Transactional Logs also…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
… I noticed one of server used for web request profiling stats logging is taking about 2GB per day for logs, which are written… about size on disk and compression buffer stage in memory should be readily available. So we have to go and check size of on disk file: -rw-rw—- 1 mysql mysql 19 Nov 12 11:31 requests_061111.ARM -rw-rw—- 1 mysql mysql 984628803…
Post: Adaptive flushing in MySQL 5.6
September 4, 2012 By 8 Comments
… that comes with MySQL 5.6 it is a support of big InnoDB log files, so let’s check if bigger log files helps there… logs, but there I guess we have a flushing of dirty pages (I did not gather stats to check it). As a conclusion: MySQL…_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 2 innodb_buffer_pool_size = 150G innodb_log_file_size = 4G innodb_log_files_in…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
…log records in the log file (which is circular). Size of log records While we speak about log file size it is number of…of log files and perform same amount of checks if page was already flushed since last checkpoint. True – smaller amount of…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…a lot of variables in MySQL Servers only few of them are really…indexes in many cases. Check however if all of key_buffer is used over time – it is not rare to see key_buffer being set to 4G while combined size of…server size. innodb_log_buffer_size Default for this one is kind of …
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…size of those files. What are those ML* files? When you run a big UPDATE, INSERT or LOAD DATA INFILE MySQL…size of the /tmp partition. Increase the size of the binary log cache. binlog_cache_size and binlog_stmt_cache_size. Before 5.5.9 binlog_cache_size…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…administration mistake to delete one of MySQL‘s log or data files from…check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in the processlist. The pmp-check-mysql-processlist plugin checks…_connections problems (the use of fixed-size connection pooling, for example…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… innodb_log_file_size do not matter, and changing these settings won’t help. Ironically, these settings are most important for tuning MySQL… or MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size are…, then increasing innodb_log_file_size may help, but check checkpoint age history to see if that is really needed. Of course, more memory…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…options are must (otherwise JDBC will have a lot of extra calls checking various server changes which typically never change). We … /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb_additional_mem_pool_size = 20M innodb_log_file_size = 1600M innodb_log…
