… most popular. I do not particularly like its write performance – I wrote about it before, that’s why…There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and … there is no a reliable way in the Linux asynchronous IO library to get time metrics for…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
…There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and second… there is no a reliable way in the Linux asynchronous IO library to get time metrics for… every 10 sec to see how stable the performance is, and it really helps to observe some …
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… write workload): ext4 1 thread: 87 MiB/sec ext4 4 threads: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance… and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO in Linux. Let’s… question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it seems…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…System Summary Report ############################## Platform | Linux Release | Ubuntu 10.04….performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL…performance improvement is marginal however WB cache brings single thread random write performance…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…been many changes to core file handling on Linux and what worked on one system might…mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing… to do any MySQL profiling or dealing with crashes. It does not slow MySQL performance yet it …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…. Yet, a lot of us are using MySQL because it seems to offer the neccessary performance. Are we just kidding ourselves, and… from 8Gig to 16Gig help the write performance of Innodb on Solaris? HT: Yes, if your ‘write working set’ fits in 16 GB… these non-mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql server for…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…64 x86_64 GNU/Linux [percona@db1 ~]$ cat /etc/*release Red Hat Enterprise Linux Server release 5.2 (…’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first …variables or whatever other data I need, and write something instructional to the client about it. …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… of memory. Do not do this. If using Linux setup LVM for database directory to get more… OS so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones … consistency and to get better performance. Next if your application has any writes be prepared to handle deadlocks …
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
…our concern is general IO performance in this case – it is not something MySQL related. I tested things…O_DIRECT often executes quite special path in Linux kernel so I did couple of other runs…and I would expect any system doing writes to experience the “performance shock” when LVM snapshot is created…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…. The other benefit of read-write snapshot is you can actually start MySQL Server on it and perform recovery, check tables or do… need to do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES… database to the slave database directory. 10) Start MySQL Server. Wait for it to perform recovery. 11) Use CHANGE MASTER TO to…
