Find the answer to your Linux question:
Results 1 to 3 of 3
How intensive is the MySQL process on your server? At the moment my MySQL is only using a very low amount of system resources, but I am interested to learn ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Dec 2008
    Posts
    3

    SQL Server


    How intensive is the MySQL process on your server?

    At the moment my MySQL is only using a very low amount of system resources, but I am interested to learn how much memory and cpu MySQL would use if there was lets say 500,000,000 queries a month.

  2. #2
    Just Joined!
    Join Date
    Dec 2008
    Location
    Lithuania
    Posts
    12
    You might be interested in this blog post and especially in its' replies:
    how-much-network-traffic-does-your-mysql-server-receive .

    # of queries is not linked to CPU/memory usage. It's the kind of query you send to server that eats up your CPU. Try to see how many "slow queries" you have on a server.

  3. #3
    Just Joined!
    Join Date
    Dec 2008
    Location
    Maryland
    Posts
    18
    I agree with checking the amount of slow queries that you get. I also use the Performance Tuning Primer script (http://www.day32.com/MySQL). It can give you a good idea of some settings that can be tweaked in your my.cnf file. The script suggests that your MySQL server should be up and running for at least 48 hours before using the script and following its recommendations. I'll also add that you should take whatever it tells you with a grain of salt and do some research before you change anything. It can, however, give you a good frame of reference as to some things that can help your performance.

Posting Permissions

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