Results 1 to 9 of 9
  1. #1

    perfect my.cnf for 1GB vps

    Hello,

    Is there any premade mysql configs for a 1GB vps?

    I only want it to use around 512MB.

    mysqltuner shows high memory dangerous.

    Thanks

  2. #2
    Join Date
    Mar 2003
    Location
    WebHostingTalk
    Posts
    16,952
    Moved > Hosting Security and Technology .

  3. #3
    Join Date
    Jun 2011
    Posts
    2,286
    You might like to post your existing /etc/my.cnf file here as well as the results of mysqltuner. You may also like to look at Tuning-primer, which some prefer over mysqltuner: https://launchpad.net/mysql-tuning-primer

    That way we can advise on your requirements a little more, rather than the requirements from somebody elses server.

  4. #4
    Join Date
    Mar 2003
    Location
    California USA
    Posts
    13,290
    One thing to keep in mind, if you severely limit the memory usage, and your database actually needs it due to the type of queries you have and the way its structured, you will severely hinder the performance.
    Steven Ciaburri | Industry's Best Server Management - Rack911.com
    Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
    Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
    FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance

  5. #5
    Here's my.cnf contents:
    [mysqld]
    max_connections=500
    innodb_file_per_table=1
    default-storage-engine=MyISAM
    open_files_limit=2060

    I'm also getting an error of memory limit set too high.
    How can I set the memory limit for 1gb vps?

    This will be used for Multicraft if you have heard of it, with 100 mc servers.

    Thanks

  6. #6
    Join Date
    Mar 2005
    Location
    Ten1/0/2
    Posts
    2,509
    Posting a config without details of actual usage as per the output of both tuning-primer.sh and mysqltuner.pl is useless as any advice will only be a guess and won't help you at all.

    Please, tell us the steps you have taken so far in tuning the config.
    CPanel Shared and Reseller Hosting, OpenVZ VPS Hosting. West Coast (LA) Servers and Nodes
    Running Linux since 1.0.8 Kernel!
    Providing Internet Services since 1995 and Hosting Since 2004

  7. #7
    Quote Originally Posted by RRWH View Post
    Posting a config without details of actual usage as per the output of both tuning-primer.sh and mysqltuner.pl is useless as any advice will only be a guess and won't help you at all.

    Please, tell us the steps you have taken so far in tuning the config.
    I've taken no steps so far as I'm not sure how to tune it. All I know is that it is using over 70% of my ram.

    The databases get used regularly every 30 seconds or so but not a lot of data is stored. Only table data is updated regularly.

  8. #8
    Quote Originally Posted by charlielove View Post
    I'm also getting an error of memory limit set too high.
    I believe you are receiving this message in mysqltuner. Most probably you are receiving this message because you have set 500 connection limit.

  9. #9
    Join Date
    Mar 2005
    Location
    Ten1/0/2
    Posts
    2,509
    Quote Originally Posted by RRWH View Post
    Posting a config without details of actual usage as per the output of both tuning-primer.sh and mysqltuner.pl is useless as any advice will only be a guess and won't help you at all.

    Please, tell us the steps you have taken so far in tuning the config.
    Once again, until you run the 2 scripts and post the output you will not get any help.

    Mysql has over 300 variables that can be tuned - so unless you are willing to provide requested output nobody will give more of their time to assist you. My suggestion is in fact that you look fir a system admin to do this for you and post a job request for help.
    CPanel Shared and Reseller Hosting, OpenVZ VPS Hosting. West Coast (LA) Servers and Nodes
    Running Linux since 1.0.8 Kernel!
    Providing Internet Services since 1995 and Hosting Since 2004

Similar Threads

  1. my.cnf optimize on VPS with cPanel
    By scal in forum VPS Hosting
    Replies: 9
    Last Post: 05-03-2013, 01:40 AM
  2. Replies: 0
    Last Post: 01-22-2012, 11:48 PM
  3. Optimize VPS, my.cnf mysql
    By coxis in forum Hosting Security and Technology
    Replies: 3
    Last Post: 04-25-2011, 01:25 PM
  4. Optimize my.cnf on VPS
    By ashras99 in forum VPS Hosting
    Replies: 0
    Last Post: 04-08-2011, 09:01 AM
  5. my.cnf for 256mb ram VPS
    By kafloofen in forum VPS Hosting
    Replies: 3
    Last Post: 12-07-2005, 09:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •