Find the answer to your Linux question:
Results 1 to 3 of 3
Hi guys, I have been asked to investigate the possibilities of implementing a MySQL server. The problem is that it is almost impossible to know how many people I have ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux User Allblack's Avatar
    Join Date
    May 2003
    Location
    Godzone
    Posts
    416

    dedicated MySQL server


    Hi guys,

    I have been asked to investigate the possibilities of implementing a MySQL server. The problem is that it is almost impossible to know how many people I have to cather for. I would like to get some feedback on your personal experiences. For example, what server can handle what load.

    Let say I have a dual P 1.2 ghz available with 1 gig of Ram. What amount of data/users would it be able to handle.

    I also like to have some feedback on Disk confguration. How do I get the best performance (logs on seperate drives etc.)

    I work for an academic institution and we provide hosting for our users. I don't expect any excessive use.

    Maybe Sykkn can give me some feedback on the load of the database of this forum?

    Cheers
    I am on a journey to mastering Linux and I got a bloody long way to go!!!

  2. #2
    Linux Engineer
    Join Date
    Apr 2003
    Location
    Sweden
    Posts
    796
    I havent runned Mysql on "heavy load" systems, but my experience says that mysql is very fast but dont have all thoose fancy features that other databases have like, Oracle,Sybase. But it can surely compete with them otherwhise.

    To optimze the system i should have my datafiles och separate disks if possible for faster IO. 1gig RAM should be enough, but you will notice that fast if the system starts swapping alot, if so but in some more ram.
    Regards

    Andutt

  3. #3
    Linux Guru
    Join Date
    Apr 2003
    Location
    London, UK
    Posts
    3,284
    At work our Database handles about 50+ queries a second non-stop, and the load avg barely goes above 1.0, the machine is running BSD.

    Hope that provides some sort of estimate, the machine spec is proberly a bit less than what you quoted.

    Of course, this is a dedicated box, the ONLY thing it runs is mysql and ssh. IE, its a server, so no XWindows draining resources etc

    Jason

  4. $spacer_open
    $spacer_close

Posting Permissions

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