…_profile (often together with strace) are great tools for MySQL Performance analyses. Too many people end tuning on plans and indexes… course you can tune you malloc settings so more buffers are allocated from the pools rather than mmap. This though will at…’m not sure how much luck you will have with malloc algorithms if they are forced to deal with very large…
Comment: Read Buffers, mmap, malloc and MySQL Performance
May 7, 2008 By 8 Comments
[...] MySQL Performance Blog: Read Buffers, mmap, malloc and MySQL Performance [...]
Comment: Read Buffers, mmap, malloc and MySQL Performance
March 6, 2008 By 8 Comments
[...] http://mysql-ha.com/2007/09/06/read-buffer-performance-hit/ http://www.mysqlperformanceblog.com/2007/09/12/read-buffers-mmap-malloc-and-mysql-performance/ [...]
Comment: Read Buffers, mmap, malloc and MySQL Performance
March 6, 2008 By 8 Comments
[...] http://www.mysqlperformanceblog.com/2007/09/12/read-buffers-mmap-malloc-and-mysql-performance/ [...]
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…commanual myisam_mmap_sizeblogpercona.commanual…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…
Comment: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
Like Monty wrote, the performance degradation is caused by the flip between regular malloc and mmap() at 256K (default): http://bonglonglong.com/2007/09/06/read-buffer-performance-hit/ -j
