# Optimizing MySQL

**URL:** <https://forums.speedlife.net/t/optimizing-mysql/27522>\
**Category:** NYSpeed Off Topic\
**Created:** [April 12, 2007, 7:29am UTC](https://forums.speedlife.net/t/optimizing-mysql/27522 "2007-04-12T07:29:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![itsJim](https://avatars.discourse-cdn.com/v4/letter/i/c67d28/32.png) [@itsJim](https://forums.speedlife.net/u/itsJim)\
**Post date:** [April 12, 2007, 7:29am UTC](https://forums.speedlife.net/t/optimizing-mysql/27522/1 "2007-04-12T07:29:16Z")

</div>

Anyone have any good tips or resources on optimizing MySQL. Most of the articles I’ve read are for servers running 1GB of RAM or less. I’m trying to come up with different configuration files for servers running any where from 512MB RAM to \>10GB of RAM. I’ve installed mytop and mtop but have yet to really play around with them and to be honest I’ve never really done anything with MySQL until I started working for this small (\<10 employees) software company less than 2 months ago. Any help would be much appreciated.

---

<div class="post-metadata">

**Author:** ![LZ1](https://avatars.discourse-cdn.com/v4/letter/l/7ab992/32.png) [@LZ1](https://forums.speedlife.net/u/LZ1)\
**Post date:** [April 12, 2007, 7:38am UTC](https://forums.speedlife.net/t/optimizing-mysql/27522/2 "2007-04-12T07:38:17Z")

</div>

Theres a shit load you can do with the MySQL configuration…Changing the storage engine/clustering.

---

<div class="post-metadata">

**Author:** ![itsJim](https://avatars.discourse-cdn.com/v4/letter/i/c67d28/32.png) [@itsJim](https://forums.speedlife.net/u/itsJim)\
**Post date:** [April 12, 2007, 7:50am UTC](https://forums.speedlife.net/t/optimizing-mysql/27522/3 "2007-04-12T07:50:54Z")

</div>

I’m looking for how to know what kind of values I should be using.

---

<div class="post-metadata">

**Author:** ![LZ1](https://avatars.discourse-cdn.com/v4/letter/l/7ab992/32.png) [@LZ1](https://forums.speedlife.net/u/LZ1)\
**Post date:** [April 12, 2007, 7:59am UTC](https://forums.speedlife.net/t/optimizing-mysql/27522/4 "2007-04-12T07:59:34Z")

</div>

Size of databases, concurrent connections…

---

<div class="post-metadata">

**Author:** ![itsJim](https://avatars.discourse-cdn.com/v4/letter/i/c67d28/32.png) [@itsJim](https://forums.speedlife.net/u/itsJim)\
**Post date:** [April 12, 2007, 8:06am UTC](https://forums.speedlife.net/t/optimizing-mysql/27522/5 "2007-04-12T08:06:24Z")

</div>

That’s the thing, the db’s range from just over 1GB to 20MB, so I’m trying to put together different configuration files for those and some decent mediums. Connections range from 2 to ~300.