… percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name…-ending stream of queries to playback. Read-only playback Using the –session-init-… than an actual database write. The slow logs were split into chunks, each containing roughly…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and… MySQL was not involved. The server was running with nearly 7GB of free memory but the push to S3 involves a split…, the server is reading a lot (~150MB/s) but doing very little physical writes. The writes were cached and the write cache was causing…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…important use case for PARTITIONing (“uneven reads“, Re: #1); let me rephrase the use …) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one at a …-partition equivalent. Even single-row writes are likely to be slower …about) 5 levels deep. If you split that table into 100 partitions, …
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
Today I gave a presentation on “Read/Write Splitting with PHP” for Percona Webinars. If you missed it, you … as the page remains in the buffer pool. But the read/write split solution is intended for cases where the query load is… forward to. Q: What about write splitting (updates,inserts) on multiple MySQL servers? Or is it possible to split only read queries (select etc.)? A…
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: Webinar on Read/Write Splitting with PHP
January 17, 2013 By 2 Comments
… application developers should think about for scaling out read-query traffic using multiple MySQL instances in a replication pair. Specifically, about the… webinar by registering here: http://www.percona.com/webinars/readwrite-splitting-mysql-and-php
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…
Comment: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
… slave promotion issues like you have with MySQL replication, but Galera is still better than MySQL replication so it is not totally… different ports for write and ready traffic? Why would you want to split read and write traffic? You can both read and write to all nodes, you should get rid of legacy code or scripts that do read-write splitting…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 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 …
