GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

MySQL Tuning for 300mb VPS

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL Tuning for 300mb VPS

    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?

  • #2
    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)?

    Comment

    Working...
    X