… & Applications, Linux Journal, O’Reilly, Web and PHP Magazine 2013 MySQL Community Awards Nominations are now open for the 2013 MySQL Community Awards… Wednesday, April 24, during the Percona Live MySQL Conference and Expo Community Reception. The deadline to submit nominations is January 31. Super…
Post: New Keynote Speakers and Sponsors and Applications Open for DotOrg Pavilion for Percona Live MySQL Conference and Expo
January 22, 2013 By Leave a Comment
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
… RedHat / CentOS 5.x may be not so good for MySQL. And yesterday one customer reported that just changing cfq to… in RAID10, controller Perc/6i with BBU) to compare cfq, deadline, noop and anticipatory (last one just to get number, I… (column bo in vmstat) during benchmark As you see noop / deadline can utilize disks much better. For reference I used tpcc…
Post: Linux IO Schedulers and MySQL
January 30, 2007 By 7 Comments
Found a great article about Linux IO Schedulers today which is quite interesting. It goes in … ago “AS” scheduler could be several times slower than deadline for MySQL workloads such as SysBench or DBT2 when it went down… docs it is mentioned it uses “per process” scheduling while MySQL is single process but single thread – does each thread gets…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…System Summary Report ############################## Platform | Linux Release | Ubuntu 10.04…. Schedulers And Queue Size ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller …MySQL configurations, I didn’t try out different MySQL…
Post: Living with backups
November 6, 2008 By 28 Comments
…copy operation from MySQL data directory will result in a total disaster after MySQL stops … not something you can do with standard Linux tools like cp, scp or tar. …?/queue/scheduler noop anticipatory [deadline] cfq noop anticipatory [deadline] cfq noop anticipatory [deadline] cfq In order to…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… point mysql‘s tmpdir elsewhere) Everything else for MySQL (/mnt/data or similar): (sym-link /var/lib/mysql into here when you setup mysql… modern Linux systems for this to be off? Maybe not, but here’s how you check. We want to use mysql on… IO setup properly. The best choices here are between ‘deadline‘ and ‘noop’. Deadline is an active scheduler, and noop simply means IO…
Comment: Living with backups
November 18, 2008 By 28 Comments
…/setting do see how it affects the results. Originally running Linux-2.6.22, I had to upgrade to 2.6…* dd (Idle class) and MySQL (default class) to slow down to ridiculously low speed! – Using the deadline scheduler (which was the default… still a bit faster than using deadline, and MySQL is lagging behind significantly more than using deadline. The IO subsystem is a hardware…
Comment: Benchmarks of new innodb_flush_neighbor_pages
July 3, 2012 By 8 Comments
… check out the improvements in mysql 5.6 http://dev.mysql.com/tech-resources/articles/whats-new-in-mysql-5.6.html These… locking ie. a special algorithm. I think something like the Deadline scheduler would help because it imposes a time limit on… on stalled read/writes. I believe the Deadline scheduler is not the default schedualer of linux but was recommended for ext4. If…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
… your normal working set from OS cache. Operation Systems and MySQL Itself employs various strategies to attempt to minimize such effect… some older disk schedulers could be poor. I remember in Linux 2.4 times I could make single full table scan… seconds for directory with couple of files. In recent Linux Kernels deadline or cfq IO schedulers should be better with this. So…
