…than you would expect, causing swapping or other problems. This simple problem on the surface becomes challenge with MySQL because there are…it is a lot larger problems with MySQL …grow up to max_packet_size per connection) are all connection …can create it does not really allows to restrict memory…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…LVM was slightly better than with LVM as …max_connections = 2500 max_connect_errors = 10 table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max…are done to random positions (not consecutive PK causing page splits) etc. Benchmark results are… benchmarks on a larger RAID5 system where …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… XtraDB. Requires m1.large or larger. ami-f65ea19f shard-query-infobright-…than one node. This would not be the case in normal circumstances. The extra data will not…. The queries for the benchmark are in ~ec2-user/shard-query/…=/var/log/mysqld-innodb.log max-allowed-packet=1M net-buffer-length=16K #…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…queries memory usage might be even larger – bulk inserts may allocate bulk_… buffers can be allocated more than once for each thread. Consider for …re deaing with large Blobs (your max_allowed_packet is large) Processing of 256MB … or global memory allocations which are not tuned as buffers. Watch for …
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…-8K per table though complex tables can require larger sizes, so this is mainly the problem for …can hold value up to max_allowed_packet in size (1M by default) but there does not seems to be any … of magnitude slower than in normal case. Some of these comes from real experiences others are just my …
