… I attended during MySQL Users Conference but I did not get too far yet, too busy. So …use two phase commit for transactions spawning multiple databases – this might not even add too much overhead as XA already used… to happen anyway. We also checked for CPU bound workload – with disk IO situation can…
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… of MySQL and PostgreSQL benchmarks on various platforms which I have not seen before. Very interesting reading. It does not share too much information about how MySQL or PostgreSQL was configured or about queries. Furthermore MySQL and PostgreSQL has a bit… are used – it turns out Both are used in the benchmark. This is CPU bound benchmark with working set fitting in memory. MySQL and…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… space and how much data we can comfortably put in MySQL Instance without getting in too much trouble with backups etc … mistakes you can make. One application can become CPU bound even with 5% of total data set … well because this makes it very easy to use LVM for backups while assuming you have BBU …
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… slaves used for long reporting queries can have queries running for hours which stalls replication progress for this time. As MySQL Replication… them executes the query) it is not able to use the CPU or the Disks on the slaves as efficient on the… replication lag – MySQL Toolkit has a great tool for real latency measurement. Do not trust Seconds_Behind_Master too much, even though it…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
…_repeat(‘, ?’, count($params) – 1) . “) Good suggestion, Jonathan. Since you can use parameters for only one value at a time, it’s… the procedure language MySQL offers, and also it moves too much computation load onto their database server. Their MySQL server became CPU-bound, while their…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, which is synonymous with Valgrind itself, is relatively widely used… it is likely that if other CPU cores will read this same variable,… use atomic access primitives in InnoDB for the benign and minor cases too–…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…Schema and query optimization can give much greater improvements, for example. If…: processor : 7 vendor_id : GenuineIntel cpu family : 6 model : 15 model name …ways to get this information, too. The last three commands are…s not possible to use a patched binary, we can use MySQL Proxy, packet …
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
…is going to be way too much IO bound anyway. Interesting enough because of MySQL scaling issues it is…utilization, low CPU usage) one should think about how much CPU capacity is available. If your CPU is 25% …larger system you’re trying to compare to. Using this approach you also should be careful …
Post: MySQL caching methods and tips
April 4, 2011 By 5 Comments
…, offer very much improvement for keys which are not accessed very frequently. Use what you need Both Memcached and the MySQL query cache… CPU and other resources too. Pick an efficient cache representation If you can cache an entire HTML block instead of the rows used… populated. MySQL includes two statements that make this easier: CREATE TABLE .. SELECT and INSERT .. SELECT. These SQL commands can be used to…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… instantly much smaller amount of cases are about IO because we would call cases when too much of logical IO is happening CPU bound. The beauty of this terminlogy (and so why I use it) – it is very easy to see if system is IO bound or CPU bound, while to understand if MySQL goes…
