…might look like. Using MySQL Performance Schema to debug performance issues - (Zburivsky Danil, Pythian) – I haven’t explored the performance_schema very much … Managing data and data archiving using MySQL 5.6 new features of Portable Tablespace and EXCHANGE PARTITION - (Marco Tusa, Pythian) — This …
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… good idea anyway as you can put it on different partition etc so you are not risking to run out of…/sbin/mysqld[0x516a61] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you… if you expect to do any MySQL profiling or dealing with crashes. It does not slow MySQL performance yet it is very helpful…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
… Innodb with a side of Partitioning. I’d expect folks interested in efficient schema design for high performance to get a lot… 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: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and… things to consider when you are concerned with write performance is using partitioning to reduce the size of the B+tree, having…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… case). When I have mounted the partition with inode64 option however, the effect disappeared and performance without LVM was slightly better than… goal was to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings…
Post: How many partitions can you have ?
December 5, 2009 By 19 Comments
…partition insert took 50 seconds to complete, 10 partitions 52, 100 partitions 72, 1000 partitions 290 seconds. The performance loss with large number of partitions…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… last ounce of performance from the box. Fiddling with how to allocate drives and drive space from partition to partition is a lot…. Get start boundary of our mysql partition from fdisk: 27344896. See if the Start boundary for our mysql partition falls on a stripe boundary by dividing the start sector of the partition by the sectors per…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… you can build the functionality you need and get the performance you need. Because I’ve built two such systems to… change the lifecycle of your application in advance. What about partitioning in MySQL 5.1? I know there are some cases…, like star schemas. The problem is that MySQL doesn’t tend to perform well on a data warehousing workload. The…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
…_buffer_pool_instances=8 was very important. Second thing – Partitioning. Unfortunately MySQL 5.5 leaves the huge bottleneck for write workloads in… cores. PARTITION BY HASH(col) PARTITIONS 8 is what we used. This looks like a good workaround but remember partitioning can impact performance of…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… rows are the worst case for performance. Optimal mathematical performance requires operations on reduced sets. Keep …on sets, and features pluggable partition mapping, it allows partitioning resources to any depth and …which speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s …
