…Hard Disk SAS Online 0/0/0 SEAGATE ST3600057SS 558.911 Hard Disk SAS Online 0/0/0 SEAGATE ST3600057SS 558.911 Hard Disk…performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…MySQL UC2008 Scalability Panel ? Indeed disks MAY be the most important part in your system performance… solving replication delay or speeding up this 3 hours …and another one for Transactional Logs you will often wast 4 hard drives from performance standpoint without a good reason. Having OS and…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…gather a lot of the data for us and speed the process, when possible, but the core commands…serious performance problem. Not really for the server, since it’s a cheap query. It adds hardly any … values for Created_tmp_tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… may affect index scan/range scan speed dramatically. The rows referenced by …disk bound workloads. There are certain optimizations in works which would improve performance…and MySQL issues IO requests one by one for query execution, which means if single query execution time is your concern many hard…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…MySQL version and starting new one. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL…is often hard to ensure queries work same way with different MySQL version,…speed is not enough. You also need to perform stress testing to ensure both MySQL…
Post: Group commit and real fsync
May 3, 2006 By 9 Comments
… few cases of customers upgrading to MySQL 5.0 and having serious performance slow downs, up to 10 times… fsync() call suppose to place data on the disk securely, which unless you have battery backed up… your hard drive speed. With fake fsync() call the data is only written to the drives memory and so…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… is that it commits too often and we’re only seeing 33% of the raw disk write speed. Since the commit isn’t… load is CPU bound and you’re scaling out you can get better performance by using couple of MySQL Servers on single node. You can make them to use different hard drives and bind to…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
…performance you care about while running MySQL over DRBD. Your reads are going to be serviced from local hard drive and… on the speed of the disk subsystem and network. If you do not have BBU on disk when …req/sec in-cache write speed (and this is what a lot of transaction and binary logs are) – …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…and Falcon storage engines. Fast Backup You simply do file copy in the binary form so it is hard to beat in speed…perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… STATUS output and how to use this info to improve MySQL Performance. To … data makes it to the disk – just passing it to OS …speed up row lookup replacing btree search with hash search. This section shows hash table size, number of used cells and…to 100% hit rate. It is hard to tell what buffer pool …
