# MySQL Tuning for 300mb VPS

**URL:** <https://forums.percona.com/t/mysql-tuning-for-300mb-vps/1115>\
**Category:** Other MySQL® Questions\
**Created:** [March 14, 2009, 9:08am UTC](https://forums.percona.com/t/mysql-tuning-for-300mb-vps/1115 "2009-03-14T09:08:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![fnando](https://avatars.discourse-cdn.com/v4/letter/f/da6949/32.png) [@fnando](https://forums.percona.com/u/fnando)\
**Post date:** [March 14, 2009, 9:08am UTC](https://forums.percona.com/t/mysql-tuning-for-300mb-vps/1115/1 "2009-03-14T09:08:16Z")

</div>

I’m getting a 300mb RAM VPS and I’d like to know what would be a good MySQL configuration for InnoDB database.

Any tips on that?

---

<div class="post-metadata">

**Author:** ![MarkRose](https://avatars.discourse-cdn.com/v4/letter/m/85f322/32.png) [@MarkRose](https://forums.percona.com/u/MarkRose)\
**Post date:** [March 21, 2009, 12:35pm UTC](https://forums.percona.com/t/mysql-tuning-for-300mb-vps/1115/2 "2009-03-21T12:35:13Z")

</div>

What kind of queries will you be running? How many concurrent connections do you expect? How much RAM can you commit to MySQL alone? Will you be sorting joined table with text/blobs in them? Will you be accessing mostly the same data, or are your access patterns spread out across all your data? How big is your database (data+indexes)?