… connections but yet MySQL takes much more memory than you would expect,… it is a lot larger problems with MySQL 5.5 with addition …max_packet_size per connection) are all connection buffers and so if you close connection MySQL… application can create it does not really allows to restrict memory usage….
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… than …not different MySQL configurations, I didn’t try out different MySQL…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… larger…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…are available in 32 and 64 bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL…m1.large or larger. ami-f65ea19f…than one node. This would not be the case in normal circumstances. The extra data will not…-innodb.log max-allowed-packet=1M net-…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… might be even larger – bulk inserts …MySQL Server Memory Requirements Thread buffers can be allocated more than…large Blobs (your max_allowed_packet is large) …are not tuned as buffers. Watch for these especially now with many storage engines being released for MySQL by various parties. I do not…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…not allow any access to MySQL Server you are reasonably secure. There were few attacks which did not require valid MySQL… can require larger sizes, so …than couple of file descriptors. This is not…MySQL which of course depends on query size which is controlled by max_allowed_packet. However some MySQL…
