Feb 03, 2013
 FOSDEM 2013
  Raghavendra Prabhu

Feed me more: MySQL Memory analysed

- During capacity planning, a frequent question which pops up is “How much memory should I allocate for MySQL and for the system in general?”.

- Memory is quite underestimated much like everything else but more so than others.

- Umpteen thumb rules about this on the Internet, often overruns the memory and/or frequently OOMs

About the Author

Raghavendra Prabhu

Raghavendra Prabhu is the Product Lead of Galera-based Percona XtraDB Cluster (PXC) at Percona. He also works on Xtrabackup and Percona Server intermittently. He joined Percona in the fall of 2011. Before joining, he worked at Yahoo! SDC, Bangalore for 3 years as Systems Engineer, primarily dealing with databases (MySQL and Yahoo Sherpa/PNUTS) and configuration management. Raghavendra's main interests include databases, virtualization and containers, distributed systems, operating systems including linux kernel. He also likes to contribute and has contributed code upstream to several FOSS projects — for more details on that visit http://wnohang.net/code. In his spare time, he likes to read books, technical papers/literature, listen to music, hack on software, nature hiking, and exploring in general while on vacations. You may also often find him on IRC channels on freenode and/or oftc. Speaking experience ============== He has spoken previously at PLMCE ('13 and '14), FOSDEM ('13), LinuxConfAu ('14), Fossetcon ('14), RICON.io ('14) and Highload++ ('14). Slides (and details) can be reviewed at http://www.slideshare.net/slidunder. Recorded talks: LinuxConfAu 2014: https://www.youtube.com/watch?v=YSFLMtXpBn8 https://www.youtube.com/watch?v=GJJo9kO3CiQ RICON.io 2014: https://www.youtube.com/watch?v=xRD6A8TY_Uw Presented paper at IEEE conferences: ======================== i) SOMGPU: Self Organizing Maps on a Graphical Processing Unit for Pattern Classification: Published at IEEE Congress on Evolutionary Computation (CEC) which was part of IEEE World Congress on Computational Intelligence (WCCI) 2008. http://dx.doi.org/10.1109/CEC.2008.4630920 ii) GNeuron: Parallel Neural Networks with GPU: Presented at 14th International IEEE Conference on High Performance Computing (HiPC) 2007. http://hipc.org/hipc2007/posters/GNeuron.pdf Social/Contact: =========== Mail : raghavendra.prabhu@percona.com, raghavendra.d.prabhu@gmail.com Twitter : randomsurfer Linkedin : linkedin.com/in/rdprabhu Github : ronin13 Launchpad : raghavendra-prabhu Keybase.io : rdprabhu IRC : tlonim Blog : https://blog.wnohang.net About.me : http://about.me/raghavendra.prabhu Lanyrd : http://lanyrd.com/profile/raghavendraprabhu For more, you can contact him at http://wnohang.net/contact. GPG: D72BE977