Implement Twitter's MySQL Numa Patches
Bug #1059812 reported by
Will Gunty
This bug affects 3 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Wishlist
|
Alexey Kopytov | ||
5.5 |
Fix Released
|
Wishlist
|
Alexey Kopytov |
Bug Description
Twitter has implemented a few changes to mysql and mysqld safe that help prevent imbalanced memory allocation across numa nodes. Implementing these in Percona Server would be a huge win for my company, as we have been having issues with Numa imbalance. We have found that modifying the mysqld_safe to do numactl --interleave all has helped, but has not resolved the issue totally.
Here are the twitter patches that I would like to request be implemented in Percona Server.
https:/
https:/
Related branches
lp:~akopytov/percona-server/i26611-bug1059812-5.5
- Laurynas Biveinis (community): Approve
- Davi Arnaut (community): Needs Fixing
-
Diff: 441 lines (+177/-10)15 files modifiedPercona-Server/mysql-test/r/percona_server_variables_debug.result (+1/-0)
Percona-Server/mysql-test/r/percona_server_variables_release.result (+1/-0)
Percona-Server/mysql-test/suite/sys_vars/r/innodb_buffer_pool_populate_basic.result (+12/-0)
Percona-Server/mysql-test/suite/sys_vars/t/innodb_buffer_pool_populate_basic-master.opt (+1/-0)
Percona-Server/mysql-test/suite/sys_vars/t/innodb_buffer_pool_populate_basic.test (+16/-0)
Percona-Server/scripts/mysqld_safe.sh (+68/-0)
Percona-Server/storage/innobase/buf/buf0buf.c (+7/-4)
Percona-Server/storage/innobase/handler/ha_innodb.cc (+7/-0)
Percona-Server/storage/innobase/include/buf0buf.h (+1/-0)
Percona-Server/storage/innobase/include/os0proc.h (+2/-1)
Percona-Server/storage/innobase/include/srv0srv.h (+1/-0)
Percona-Server/storage/innobase/os/os0proc.c (+55/-3)
Percona-Server/storage/innobase/row/row0merge.c (+1/-1)
Percona-Server/storage/innobase/srv/srv0srv.c (+2/-0)
Percona-Server/storage/innobase/srv/srv0start.c (+2/-1)
tags: | added: i26611 |
To post a comment you must log in.
Here is the background blog:
http:// blog.jcole. us/2010/ 09/28/mysql- swap-insanity- and-the- numa-architectu re/