… transactions per second, more is better) ThreadsMySQL-5.0.77MySQL-proxy+MySQL-5.0.77 1 660.02 349.86 2 1158… thread). MySQL per-request statistics: min: 1.31ms avg: 1.51ms max: 5.30ms approx. 95 percentile: 1.56ms Proxy+MySQL per-request… 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: Fixing MySQL with a comment in the config file
February 4, 2011 By 5 Comments
… the first one. The multiple instances were started through the mysql_multi init script. Perhaps you already know what was wrong… string “mysqld_multi”. It was using this text as a proxy for “I found a [mysqld_multi] configuration section.” This was… on; I just checked a recent download, and the official MySQL distribution contains a file called mysqld_multi (note the different…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…constantly referring to the amazing MySQL manual, especially the option and variable reference table. But…profilingblogpercona.commanual profiling_history_sizeblogpercona.commanual protocol_versionblogpercona.commanual proxy_userblogpercona.commanual pseudo_thread_idblogpercona.commanual Qcache_free_…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult…_tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max… not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… more chunks. Each Shard-Query instance is a essentially a proxy for the distributed set based SQL operations executed on the nodes under the proxy. The databases do 99.9% of the work, due to… of compute resource which speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s law applies to the…
Comment: MySQL Sizing questions
February 9, 2012 By 4 Comments
… proxy. PHP installed. Apache Server. 2 Database server with the same configuration, but active-pasive controlled by load balancing using HT proxy. MySQL…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp… –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp… MySQL will think that the connections are always coming from the load balancer. You can work this around using T-Proxy patches…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… and complex procedure. Lets now compare it to MySQL Replication based solution. With MySQL Replication you have to have one Master node… case which allows to use simple solutions such as HA Proxy with these technologies – node is either part of the cluster… talks about Percona XtraDB Cluster, Synchronous Replication and Galera Technology, MySQL Cluster production use, and Keynote and Talk about Clustrix – another…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… scale sites. As response to these things few things happen – MySQL kept being “simple” and introduced relatively simple performance boosters – Query… lot of custom technologies created for caching or scalability issues MySQL could not solve well. There are inhouse and opensource solutions… 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: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
… the serial version as run by the native database interface (MySQL): mysql> select word, md5(word), md5(reverse(word)), count(*) from words2… doesn’t matter because Shard-Query is a smart database proxy that can add parallelism. In this mode it will add…. Likely current network technologies can not support such a degree. mysql> select min(id),max(id) from words; +———+———+ | min(id) | max…
