… instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the….0 sites in particular design for having everything they need in memory, which is not that hard after … easy to use LVM for backups while assuming you have BBU on the raid volume impact on transactional…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… unhappy how MySQL handled this problem. While working for MySQL we spotted this problem early in MySQL 5….the same time you should not have hardware RAID or have one without battery backed up … MySQL – because paying customers would normally have enough money to get BBU unit which is great for …
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 11 Comments
…MySQL Performance. Here are couple of links (1,2). It is good to see though there are some controllers coming out which… plus flash. Capacitor provides enough energy for contents of DRAM to be flushed …device number 0 Logical device name : RAID10-A RAID level : 10 Status of logical device : Optimal …
Post: Query Profiling with MySQL: Bypassing caches
September 12, 2007 By 6 Comments
… query cache but it has no change on other caches, which are MySQL Caches – Innodb Buffer Pool and Key Buffer are best… RAID cache is the one but more important SAN caches which can be pretty big. So How can you bypass these caches? For MySQL Caches you can restart MySQL and this…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…a data generator which produces data for a star schema. Star schema are commonly used for analytics because …: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with…disk 7200RPM RAID 10 array with 512MB write-back cache Star Schema Benchmark – Scale Factor 1 – Mysql …
Post: L2 cache for MySQL
October 25, 2012 By 13 Comments
…, there is a project in progress Flash_Cache_For_InnoDB by David which implements this. David helped us to port his work… benchmark on tpcc-mysql 2500W (250GB), I used data on RAID data on SSD (Intel SSD 910) data on RAID with L2 cache… with Percona Server. Right now there are two challenging questions, which we need to resolve: Backup. In current state only mysqldump…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
… and misconfiguration scenarios which can result in performance problem on single node only such as disk failing in RAID, resync initiated, BBU… of the art high availability solutions for MySQL such as Clustrix, Tungsten Replicator, PRM, Percona XtraDB Cluster, MySQL and DRBD as well as…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… actual failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is… unheard of for a monitoring agent or RAID utility software to do this. The pmp-check-unix-memory plugin checks for a single… pmp-check-mysql-status plugin can be configured to alert when Threads_connected approaches max_connections too closely, which can give the…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
… now which requires seeks which make certain disks to flush their cache. Watch out for MySQL 5.0 – if you enabled Binary log with MySQL… which can dramatically increase commit rate for multiple user load. See this post by Vadim for benchmark results. Solution with Battery Backed up RAID…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…-laptop:~$ ec2-add-group hamysql -d ‘nodes for HA MySQL solution’ GROUP hamysql nodes for HA MySQL solution From now, I’ll always assume… configuration files, /etc/ha.d/authkeys for cluster authentication and /etc/ha.d/ha.cf which is the configuration file per say… but Pacemaker will not manager MySQL, just the host running it. I’ll also skip the raid configuration of multiple EBS volumes…
