… LV when we need to and align the partition correctly. We got decent tpcc performance, nearly 37k … the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while…ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… term to read from a partitioned table, as, depending on the size of the partitions, the whole partition can be cached, as opposed… dont do replace… ever)… if across partitions, will be slower, if in the same partition will be faster. 4. If you do… on a partitioned table, as Mysql can fire off one thread per partition (at least I have seen this happen in a MyIsam environment…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… MySQL manual, especially the option and…myisam_recoverblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_repair_threadsblogpercona.commanual myisam_sort_buffer_sizeblogpercona.commanual myisam_stats_methodblogpercona.commanual myisam…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
… 3 hour tutorial focusing on indexing within MyISAM and Innodb with a side of Partitioning. I’d expect folks interested in efficient… when this was not the case at a MySQL conference. There are several MySQL HA related tutorials: Using Tungsten Replicator to solve replication problems (3 hr) Ramp-up tutorial for MySQL Cluster – Scaling with continuous availability (6 hr) Percona XtraDB Cluster…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…XFS file system on a raw partition I was using full partition size which was slightly over…IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings….= 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover…
Post: How many partitions can you have ?
December 5, 2009 By 19 Comments
…(700001), PARTITION p800000 VALUES LESS THAN(800001), PARTITION p900000 VALUES LESS THAN(900001), PARTITION p1000000 VALUES LESS THAN(1000001) ); I used MySQL 5.1… in 22 seconds for 1 partition and 250 for 1000 partitions – which is over 10x difference. Both MyISAM and Innodb are affected by…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… to the cost of repairing huge MyISAM tables and taking downtime, I would not use MyISAM for anything but read-only tables… change the lifecycle of your application in advance. What about partitioning in MySQL 5.1? I know there are some cases… There are already inconvenient limitations on some key parts of partitioning, such as maintenance and repair commands, that essentially negate the…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… your MySQL server to run out of file descriptors. The same is true for Partitioned tables in MySQL 5.1 Disk Space For MyISAM tables hosting providers used to use disk quotas for MyISAM tables. You… disable password brute force protection. Mutex Saturation Both Innodb and MyISAM have hotspots and having few connections which use appropriate operations…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
… memory. Last time I worked with similar system it used MyISAM and the system was built using multiple tables. Using multiple…_buffer_pool_instances=8 was very important. Second thing – Partitioning. Unfortunately MySQL 5.5 leaves the huge bottleneck for write workloads in… would expect gains can be higher with more cores. PARTITION BY HASH(col) PARTITIONS 8 is what we used. This looks like…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: I… in large zabbix deployments, you may want to partition your large history tables, so it can keep… works as a sst method for myisam? A: Yes, but for MyISAM xtrabackup is blocking, since it is…
