… appears there is no a reliable way in the Linux asynchronous IO library to get time metrics for… stable the performance is, and it really helps to observe some artifacts, as you will see in following … you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance in case with 4 threads for ext4 is a signal that… MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO in Linux. Let’s test “async” mode in…: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it seems it is not. In my…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… appears there is no a reliable way in the Linux asynchronous IO library to get time metrics for… stable the performance is, and it really helps to observe some artifacts, as you will see in following … you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on…
Comment: Finding your MySQL High-Availability solution – Replication
April 11, 2012 By 6 Comments
…-20GB of mysql database, we need performance to increase 500%. currently we are using free mysql version thats comes under centos linux, we are had enough resource left, RAM, CPU in server. My question is: Does mysql enterprise…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… /var/lib/mysql (datadir) on my system (Ubuntu). You might be lucky and it might work in your system…have been many changes to core file handling on Linux and what worked on one system might not … expect to do any MySQL profiling or dealing with crashes. It does not slow MySQL performance yet it is …
Post: MySQL Performance Engineer opening
May 13, 2008 By Leave a Comment
… performance of various MySQL features, benchmark, compare, analyze things and post our findings on MySQL Performance Blog…MySQL, Operation System, Hardware) when for example row is being inserted into Innodb table on Linux…should be able to read and write in English language pretty well. If you …
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
… test as our concern is general IO performance in this case – it is not something MySQL related. I tested things on RHEL5, RAID10… you might know O_DIRECT often executes quite special path in Linux kernel so I did couple of other runs. First run… they can sustain this performance drop, in particular during some slow times (which often have 2x-3x lower performance requirements) So we’ll…
Post: Percona white paper: Forecasting MySQL Scalability
November 16, 2010 By 6 Comments
… to in the paper is extracting the necessary metrics from network traffic. I had this idea after studying the data in Linux‘s /proc/diskstats file. It turns out that two simple metrics can provide amazingly rich insight into system performance and scalability, in… time that requests were resident in the system. There are different terms for the latter, but in MySQL we’d call it query…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…_64 x86_64 x86_64 GNU/Linux [percona@db1 ~]$ cat /etc/*release Red Hat Enterprise Linux Server release 5.2 (Tikanga) From… these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From this I… in a high-performance system is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… MySQL won’t be much different whether one or another distribution is used. All use common Linux kernel – the heart of Linux operating system – which in principle will behave the same way in all cases. The… may carry new features or slight performance improvements, however these days it is rarely important to MySQL users. If it is to…
