…the table sizes and an easy way to use the search feature of your browser to zero in on a particular table Constraints – lists the…you‘re done. What are some ERD tools you use and how do they compare with SchemaSpy? Feel free to answer via the…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…the combined size of the secondary key tuples fetched, and N is the buffer size. In MySQL 5.6 the buffer size used by MRR can be controlled by the…in the table above you can with default buffer size of 256K, MariaDB 5.5 shows that Handler_mrr_rowid_refills = 1, which means the…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…the added costs So, how about if you could setup a small Arch Linux ARMv6-based hardware device which runs Percona Server for MySQL, in…in the configuration file, update it in Tunnelier now also) Re-connect to see if your password change…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
…the talk: Q: How do you install the tools? The manual has full details, but it’s important to know that the…the toolkit installed. Q: How to make the tools connect to MySQL The…change, does renaming the table take a long time, and what about the transaction in the meanwhile? The rename table…
Post: Write contentions on the query cache
September 5, 2012 By 5 Comments
…how MySQL executes this query. So I used commands you…you should suspect either some change in data access pattern (reads on disk vs reads in memory, execution plan instability) or contention somewhere while the…do we have 2 lines showing waits on the query cache lock instead of one in the…
Post: Time for Zero Administration effort at MySQL ?
January 8, 2012 By 4 Comments
…changing tables rather than command line options (like much of Performance Schema configuration). Innodb settings alone push 100. True you do…the same time however I am happy many more options got exposed over last few years. Majority of options in MySQL…MySQL would use the same sort_buffer_size…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table_size | 268435456 | +———————+———–+ If these are not the same size…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…you‘re altering gigabyte size tables…the “downtime” part. The longer it takes to apply application changes, the longer is the downtime. Our customer built his application so it automatically detects the…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…in MB or GB and shows what amount of the space in innodb_log_file corresponds to changed pages in the buffer pool. You…the stable line in MySQL 5.5.8. But, finally, let me show the result I got running Percona Server in optimized mode: innodb_buffer_pool_size…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…you know you‘ll get there, it can change the lifecycle of your application in advance. What about partitioning in MySQL…the indexes less than half the size. In real life this technique often makes the table+index much less than half the size. You…
