Truemag

  • Categories
    • Tips And Tricks
    • Internet
    • PHP
    • Javascript
    • CSharp
    • SQL Server
    • Linux
  • Lastest Videos
  • Our Demos
  • About
  • Contact
  • Home
  • Write With Us
  • Job Request
Home MySQL Tips For Tuning And Optimizing Mysql On Low Memory Dedicated Server Or VPS

Tips For Tuning And Optimizing Mysql On Low Memory Dedicated Server Or VPS

Not all of us has chance or money to play with a professional dedicated server or virtual private server (VPS) so a cheap plan with low memory (216 ~ 512 MBs) is a not bad plan in order to start building the business.

As a MySQL DBA or administrator of the server/vps, we should be aware of the MySQL performance to ensure it conserves as much as memory as possible. Below is an example of MySQL configuration file (usually located in /etc/my.cnf or /etc/mysql/my.cnf)

1
2
3
4
5
6
7
8
9
10
11
12
[mysqld]
port               = 3306
socket             = /var/lib/mysql/mysql.sock
skip-locking
key_buffer         = 16K
max_allowed_packet = 1M
table_cache        = 4
sort_buffer_size   = 64K
read_buffer_size   = 256K
read_rnd_buffer_size = 256K
net_buffer_length  = 2K
thread_stack       = 64K

[mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 16K max_allowed_packet = 1M table_cache = 4 sort_buffer_size = 64K read_buffer_size = 256K read_rnd_buffer_size = 256K net_buffer_length = 2K thread_stack = 64K

And if you don’t use the InnoDB storage engine feature, let disable it by adding the line below to the my.cnf. It will reduce significant your memory.

skip-innodb

Bonus: consider to know how to tune and optimize your MySQL performance with MySQLTuner

Jun 25, 2011Hoan Huynh
How To Tune And Optimize MySQL Performance With MySQLTunerFree Software To Monitor and Log Directories Files Changed On Windows 2000 XP 2003 Vista 7 Server 2008
You Might Also Like:
  • How To Tune And Optimize MySQL Performance With MySQLTuner
  • Free Mysql Profiler similar to Microsoft SQL Server Profiler – LogMonitor
  • Where MySQL Data Dir And Innodb Data Home Dir Location
  • Ubuntu CentOS Clear Filesystem Memory Cache
  • Connect Remotely To MySQL or SQL Server Databases for Godaddy Hosting Account
  • MySQL Incorrect Data Type Value In Column
  • Mysql Create FullText Index and Load Index Into Cache
  • Install LAMP (Apache, MySQL and PHP in Linux) on CentOS
  • Move To Dedicated Server At Serverloft
  • Mysql restore database from dump file with GZIP compression
Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at [email protected]

11 years ago MySQLInnoDB, my.cnf, optimize, performance269
0
GooglePlus
0
Facebook
0
Twitter
0
Digg
0
Delicious
0
Stumbleupon
0
Linkedin
0
Pinterest
Most Viewed
PHP Download Image Or File From URL
24,451 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
21,829 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
17,646 views
JQuery Allow only numeric characters or only alphabet characters in textbox
14,984 views
C# Read Json From URL And Parse/Deserialize Json
11,710 views
4 Rapid Development is a central page that is targeted at newbie and professional programmers, database administrators, system admin, web masters and bloggers.
Recent Posts
  • Things to Learn about Installingderm Loan Type S
  • Online Photo Editor – Free Photoediting Software
  • A Guide to Finding the Best Paper Sellers
  • Photoediting in Home Isn’t Hard to Do!

  • Free Photo Editor Online
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (27)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (141)
  • Uncategorized (647)
Recommended
  • Custom Software Development Company
  • Online Useful Tools
  • Premium Themes
  • VPS
2014 © 4 Rapid Development