…with servers located in two data centers, one with Solaris servers and the other one with Linux servers. The…maybe just normal. We didn’t try too hard to get better performance because we already …other drive in the mirror. Better availability and disk usage On purpose, I allocated mirror pairs using…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… make it “try harder”, even though it already tried pretty hard to keep working despite recoverable errors and such. Whereas pt…, and 5.6), plus at least four major forks (Percona Server, MariaDB, Percona XtraDB Cluster, and MariaDB Galera Cluster), upgrades are…. saved results from running queries on a server. Granted, this can take a lot of disk space, but it allows you to…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… had were rotating hard disk drives. I think the reason is very simple – when systems only had one bearing hard disk drive (HDD) as… however mention couple things about InnoDB storage: first – in Percona Server you can now customize page size and it may be… decide on very early when configuring RAID. Disk sectors Most if not all hard disk drives available on the market these days use…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… LTS (lucid) Kernel | 2.6.32-31-server Architecture | CPU = 64-bit, OS = 64-bit # Processor ##################################################… ======= ============ =========== Hard Disk SAS Online 0/0/0 SEAGATE ST3600057SS 558.911 Hard Disk SAS Online 0/0/0 SEAGATE ST3600057SS 558.911 Hard Disk…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… problem here is that the system has quite slow hard drives (2 hard disks in software RAID0). As you can see, after the… with slow disks); and 3) MySQL does not support innodb_log_file_size > 4GB (it is supported in Percona Server). To make…_flush_neighbor_pages in Percona Server)? Well, it may help to some extent, but remember that hard disks love sequential operations, and your…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…) and establish both baseline behavior and deviations from it. The hard part used to be step 2. However, over time the… that the disks are not responding within reasonable and expected tolerances, and sometimes the disks are responding very well but the server is abusing them and overloading them. And sometimes, of course, the CPUs and disks…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
… methods. Smaller applications usually start with single server which has both MySQL and Web server on it. In this case it is… web server crashes and this sort of things. You can ether clone web servers from template hard drive or even have them disk less booting by NFS. So if using dedicated boxes is so great why to think about sharing MySQL and Web server…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…, Performance Optimization and Six Sigma. In Percona Server (and actually even before that, in percona-… PowerEdge R900 box, using RAID10 over 8 disks and a FusionIO 320GB MLC card. First,Â…neighborhoods feature was created as an optimization for hard drives, since InnoDB tries to combine writing …
Comment: How Percona Server handles data corruption more gracefully
January 6, 2012 By 2 Comments
Dave, that is exactly the scenario that we are trying to handle. Each page of data has a checksum. InnoDB checks the checksum when it reads the page off the disk. If the checksum does not match the contents of the page, then the page is corrupt. Standard InnoDB will now crash the server hard.
Comment: Why MySQL could be slow with large tables ?
June 19, 2006 By 141 Comments
… another standalone PC to run some tests without killing my server Cpu/IO every time I run a query. I am… million rows). I guess it’s all about memory vs hard disk access. Now my question is for a current project that…
