…MySQL because there are no clear resource usage metrics available, and so in most cases you do not know where…MySQL memory consumption plotted. I use “VSZ” columns from “ps” output on Linux…file used space gradually growing and there are “swap outs” but a lot less “swap ins” chances are…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… | Linux …mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log…log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in…where there’s a lot of data being modified, inserts are…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
…MySQL you might need to deal with…point in time recovery while backup setup only takes you to the point where last binary log…it can be recovered as any generic Linux server. When you restart the system RAID5…25/228395008 files, 14579695/3654303744 blocks good so now we are pretty sure it is in a good …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…in a generic way here — we focus on far more than my.cnf files. In fact my.cnf files are…where there’s a /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql…log_file_size. I won’t give you a full rundown over every option in the file…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…file system Why snapshot based MySQL backups are great ? There are number of reasons: Almost Hot backup In…log position: change master to master_host=”master”, master_user=”user”, master_password=”password”, master_log_file=”host-bin.000335″, master_log…
Comment: Linux schedulers in tpcc like benchmark
January 31, 2009 By 19 Comments
…MySQL using O_DIRECT to move data from sequentially written log files to the more write-costly spreaded/random innodb data file. Whatever, I stand corrected now, thank you 
You are…where…log file in…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… facts about the execution in the log file. # QC_Hit: No Full_…files. INNODB USAGE The final part are the InnoDB usage statistics. MySQL… SELECT DISTINCT c from sbtest where id between 501895 and 502895…in production or on any important system! The patch is available for MySQL Community 5.0.45 on Linux…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
…in the transaction log. As I said before, dirty pages are flushed to disk in the background. The order in which they are…Linux native AIO. These can also be rendered useless by filesystems that don’t allow parallel writing to the same file…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…file in a log file group. My questions are: What is always being written to the first file in the log file…mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…file address, then InnoDB schedules the read of all the 64 pages of the extent where the next index page in… MySQL. There are two solutions here. Memlock and O_DIRECT. Memlock is apparently unstable on Linux. O… Golubchik serialized the MySQL binlog write and the InnoDB log flush with a mutex in 5.1,…
