… and mirrors. You dont know your 9x percentile response time performance until you use it against your work load with your… use mysql proxy and an alterate server with a snapshotted dataset and compare apples to apples there. I did dick around with proxy…
Post: mysql-proxy, urgh performance and scalability ?
June 9, 2009 By 27 Comments
… mysql-proxy is one of well-known, so it was logical first choice. The obvious question which come in mind is what performance penalty we have using mysql-proxy, version 0.7.1. So it is easy… want to run Query Analyzer with MySQL-proxy on your MySQL Enterprise setup. There is alternative – Dormando-proxy, which I want to try also…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up… high-performance system is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL Proxy, packet…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance….commanual proxy_userblogpercona….
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… and performance of MySQL is often the problem even for medium scale sites. As response to these things few things happen – MySQL kept being “simple” and introduced relatively simple performance boosters – Query Cache and Replication, which were clearly not enough to solve all performance… MySQL side we have further development of MySQL Cluster to be more usable for web apps as well as development of MySQL Proxy to…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… passive master, too. Is that all? “Buffer pool warmed up, performance is better, case closed!” No. This isn’t as simple… write-only workload! The insert buffer can also cause terrible performance. There are some subtleties about exactly what’s happening that… have to be the tools I used — it could be MySQL Proxy or a TCP sniffer or anything else. But if you…
Comment: mysql-proxy, urgh performance and scalability ?
June 10, 2009 By 27 Comments
… across different applications. My rule of thumb for 0.7 performance is: The shorter the query execution time, the higher the…, because MySQL Proxy 0.7 can make progress whenever it waits for events, so naturally many short queries will mean that Proxy needs… them at http://bugs.mysql.com in the Proxy component. If you have additional questions, we are on #mysql-proxy on freenode, as well…
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 in…Each Shard-Query instance is a essentially a proxy for the distributed set based SQL operations… which speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s law…
Post: Announce: Front End Performance Optimization
October 10, 2008 By 8 Comments
… help customers with performance, scalability, high availability as the whole, not just MySQL related issues. Indeed if you look at MySQL driven web… of factors – good web side configuration, which is about caching, proxying, using multiple data centers or CDN, serving static content reliably…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 6 Comments
… as run by the native database interface (MySQL): mysql> select word, md5(word), md5(reverse(word)), …SQL execution time, and parse time, respectively. Actually performance is a little worse. This is not unexpected… because Shard-Query is a smart database proxy that can add parallelism. In this mode…
