SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Zealot
    Join Date
    Dec 2001
    Posts
    198
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    database size vs server load

    I'm having a few problems with my webserver, so I just want to verify this : Does the size of a big mysql database have any effect on the overal performance of a server ?

    Currently my db is 1.4 gig big and my server is really working slow with a normal number of visitors. Only at quiet moments is everything loading fast. A few weeks ago it was only 0.9 gig and there were no problems at all, even with high number of visitors everything loaded well enough. Is this co´ncidence or not ?

    Also : if size does matter here , are the 'active' databases the ones that determine the limit, or all mysql databases that are located on the server ? I have some backup db's there too, also 1.4 gig big each... and if you count them all together, it becomes quiet a bit.

    (server : intel dual xeon 2.4 GHz, 1 gig ram, debian)

  2. #2
    SitePoint Columnist
    Join Date
    Nov 2003
    Location
    Ohio
    Posts
    411
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am sure we have some expert dba's who can address this in granular specifics. I defer to a dba in my own practice as I know enough to be dangerous even after using relational dbs for a decade. However - some starting points are below. And if you want one of the authorities on MySQL - read a book by Jeremy Zawodny.

    http://www.amazon.com/exec/obidos/AS...969654-2683214

    More important is the architecture of the database. Thus - the way you have constructed tables, indexing you use to tune the database and also the base configuration through max_connections, error handling and other issues come into play to manage database size.

    Central to this may be moving your mysql database to a separate server - which controls load as it does not have to handle double duty by also serving up web content by way of Apache, Tomcat or other.

    You may want to read some on this:
    http://www.linux-mag.com/2001-06/mysql_01.html
    http://www.linux-mag.com/2004-09/mysql_01.html
    http://www-css.fnal.gov/dsg/external...sqlTuning.html

    Also - and maybe first - spend some time in the MySQL manual (http://dev.mysql.com/doc/mysql/en/My...istration.html) and review using innodb tables as well as some of the tuning and admin techniques they recommend.
    Freelance System Administrator, Researcher, Writer
    Practical Applications
    Open Sourcery "SitePoint's Open Source Blog"


Bookmarks

Posting Permissions

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