…up in the PROCESSLIST or will not take too much combined time in the logs to attract your…(“a”,1000000); select sleep(1); … Causes MySQL to “leak” 1MB of memory per second with no apparent good …LIST and you can’t really track how much memory was allocated for given session (or restrict this number)…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… Valgrind does not need much introduction, especially to the MySQL server developers. The Valgrind… a block of size 800000 alloc‘d ==9090== at 0x4C28FDF: malloc (… the benign and minor cases too–if only to declare an … and using MySQL 5.5 atomic operation primitives with proper memory barriers, so …
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… MySQL handles connections, allocating one thread per connection to the server. MySQL is … memory or other means. It’s cheap to create a connection to MySQL… servers. Mark Callaghan has done much more investigation of the pool …be a great OLTP web database too. MySQL replication is one of the core, …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…allocation of 2M for sort buffer was very expensive. It can negatively impact some large sorts though shifting to sort merge much…now allowing MySQL to handle larger queries. Makes sense as amount of memory available is much larger …by default as value of 1M is too small to be practical if someone …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…442 mysql tables in use 1, locked 0 MySQL thread… will not grow too large. Transaction id is… it is pretty much for informational purposes only. — …memory usage. You can see total memory allocated by Innodb (sometimes it is higher than you anticipated), amount of memory allocated in additional memory…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
…profile (often together with strace) are great tools for MySQL Performance analyses. Too many people end tuning on plans and indexes while… mmap allocation. Indeed allocating with mmap is much slower than allocating from memory memory pool which process already “owns” and in real life it can get much…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…_size and indeed I oversimplified things a bit too much, so let me write a bit better description. … pool and log buffer) and total amount of memory allocated by Innodb is typically a bit over 13GB. … for other MySQL needs while factoring this in. The next step would be to decide How Much Memory do …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…and query optimization can give much greater improvements, for example. … if you want to allocate a lot of memory to mysqld. … to get this information, too. The last three commands …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…
Post: Are larger buffers always better ?
June 6, 2006 By 9 Comments
…was running much faster with 32K sort_buffer_size, compared to 32M. The problem was memory allocation – sorting …LARGETABLE LIMIT 5 MyISAM will allocate the buffer and populate if fully when MySQL will read only 5 …m quite sure there are others. For example too large table_cache may slow your opens …
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…allocated to it. This is pattern which is somewhat typical for Enterprise managing a lot of relatively small MySQL…too which will make read caching more efficient in its memory while write buffering can too be done by MySQL…surprised performance is not “scaling” as much as you expected. You should …
