…line driven and builds the html after each run, so I find it convenient to set…for a high level overview of the table sizes and an easy way to use the search feature of your browser to zero in…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…for fast inserts, but it is suitable for range selects by `id`. However it will interesting how…line to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
…MySQL configuration, we quite often want to know how various buffer sizes are used. This matters because some buffers (sort_buffer_size for example) are allocated to…in special cases. A join buffer is allocated to cache rows from each table in…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…to your TV set using the Composite RCA (PAL & NTSC) connector. Once you have your hardware, here is how to get Percona Server for MySQL…in your DHCP range), you can always check your router’s DHCP table…
Post: Time for Zero Administration effort at MySQL ?
January 8, 2012 By 4 Comments
…tables rather than command line options (like much of Performance Schema configuration). Innodb settings alone push 100. True you do not need to set…in MySQL which makes it hard to…for example MySQL would use the same sort_buffer_size…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…how it uses MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements ? memory tables ? In…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…size, while MariaDB introduces a different variable to control the MRR buffer size mrr_buffer_size. Both buffer sizes default to 256K in MySQL…MySQL 5.6 are reporting high numbers for Innodb_rows_read, which is completely in line with how…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…line 1: CAL0001: Insert Failed: St9bad_alloc Alright, colxml / cpimport was more successful, however it has less flexibility in…size of data after load, until someone points me how to get real size…in Google Spreadsheet or in summary table at the bottom) Query Q1: mysql…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…for Created_tmp_tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table_size…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…settings for the initial run. Later I will change them in searching for optimal values. innodb_file_per_table…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…
