… using AWS MySQL RDS, InnoDB engine. Our requirement is to insert data in same table and read from same…1st column of composite (5 columns) primary key). Reading and Writing in same table. For 22,518,912 rows it…around 2.85 GB). I wrote separate script to split the same insert in 8 chunks then it took…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… like how to build for massive scalability, how to do read-write splitting without breaking the user experience, how to take online non…/mysql and it’s reading from /etc/my.cnf. I’ve seen a lot of cases where there’s a /var/lib/mysql…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult…
Post: Presentations Announcement: 2010 O'Reilly MySQL Conference & Expo
April 29, 2010 By 4 Comments
… Schwartz HA Solutions for MySQL Author: Yves Trudeau, Read by Peter Zaitsev How Solid state Technologies are Transforming MySQL Server Performance and the… to MySQL and InnoDB Author: Bill Schuler, Baron Schwartz PHP Object Relational Mapping Libraries In Action Author: Fernando Ipar, Ryan Lowe Read Write Splitting…
Post: Percona sessions at the MySQL conference
March 15, 2010 By 6 Comments
… and Feature Enhancements to MySQL and InnoDB Fernando Ipar: PHP Object-Relational Mapping Libraries In Action Baron Schwartz: Read-Write Splitting: Techniques, Challenges, and… Zaitsev: Choosing Hardware and Operating Systems for MySQL Peter Zaitsev: Instrumenting your Application for MySQL and Memcached Peter Zaitsev: InnoDB Architecture and…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings….random positions (not consecutive PK causing page splits) etc. Benchmark results are fairly consistent …had some collateral effects in a mixed read/write environment. Note that the benchmarks were …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… i970 test machine. It is possible to distribute splitting and/or loading among multiple nodes as well….-delay=0 innodb-use-sys-stats-table innodb-write-io-threads=4 join-buffer-size=16M key…=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…reading this document, you don’t need HA. For the others, let’s move on! How to determine which MySQL… write capacity of a database server. In term of write capacity here are you choices. Write capacity MySQL…for a growth that will need sharding (splitting the database over multiple servers), then you…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
…. We did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1…. As you can see there is some gain for MySQL from read-write lock split patch (found in Percona Builds) though it is not… patch not full patch set in testing. MySQL 5.1 is 4% slower than MySQL 5.0 with two cores and just…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… summarize the simplest HA architecture using MySQL replication. All writes are going to the master while reads are spread between the master and… suitable for high write loads All the servers can be used, no idle standby read scaling only if application splits reads from writes Supports MyISAM… is one write VIP, where write operations are sent and as many read VIPs as the number of MySQL servers. For the write VIP, MMM…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… too which will make read caching more efficient in its memory while write buffering can too be done by MySQL and local RAID… what is about MySQL/Innodb specifics ? First, in MySQL if you’re looking for durable transactions the log write latency is triple important… a benefit of having the system which you can actually split in two (ie for recovery purposes). Sure it needs double…
