…gets killed. In 32bit systems it was even easier as all you had to do is to get enough memory allocated to get to…cause other users being unable to run their queries. Stored Procedures – How much memory can stored …value up to max_allowed_packet in size (1M by default) but there does not seems to be …
Post: New variable slave_max_allowed_packet for slave servers
July 24, 2012 By 2 Comments
…size (less than max_allowed_packet) and the second one, upgrade to a version that has slave_max_allowed_packet. Training In September I’m going to…to deliver the training in Spanish 
If you’re interested just click on the previous link to get…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…to get information about the physical drives installed; then I can find out exactly what they are, both in terms of size…to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… set of buffers correspond to connections – orphaned prepared statements, user variables, huge network buffer (can grow up to max_packet_size per connection) are all… a lot of cases you have to guess and test, you can’t get information of how much memory connection uses and for…. There is a max_heap_table_size variable which allows you to limit size of MEMORY tables (the limit applies both to implicit and explicit…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…to use LIMIT or PK Rangers when MySQL crashes you will not get all data in the network packet you potentially could get due to…how many rows do you need to skip exactly to recover as much data as possible. Row size can be good help to…to make sure indexes are not corrupted. So we looked at how to get…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… I had to redo all of the benchmarks to get the …max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size…to IO alignment yourself. In this case offset is correct, but file system is unaware how to…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections”. …max_allowed_packet). And keys for user locks! I set my max_allowed_packet…34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) | +—————–+ | …lock key. Note how long it took to run these…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…max_allowed_packet = 1M max_connections=300 max_connect_errors=100 table_cache = 6000 read_rnd_buffer_size = 2M sort_buffer_size…buffer_size = 32k – It is interested how much…max_dirty_pages_pct=15 – Another interesting one. So the it was better to restrict amount of dirty pages Innodb can have to get…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…how many processors and processor type, processor cache, RAM size, front side bus speed, harddrive rpms, harddrive max… 3000 packets of data per second. The processor would go up to about …to get the data to be inserted faster than it is coming in. Please post the my.cnf file that you were able to get…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…is there, so I decided to test how it performs in tpcc-mysql …may need a bigger innodb logfiles to get more stable results. So there it…max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size…
