Maintenance

This topic is empty.

Viewing 5 reply threads

Author

Posts
- May 27, 2005 at 5:31 am #9013
  
  Strigoi
  Member
  
  hi, kinda new to all this, is there any maintenance that needs to be done to Sglyog, and or Mysql, ive noticed my site slowing justa little, and cant trace the cause, notta big issue, just fishing for information, any thing i need to run , to keep the data base moving right along ??
  
  Strigoi
- May 27, 2005 at 5:52 am #17958
  
  CalEvans
  Member
  
  Generally no.
  
  If you find your site slowing down and you think it might be mysql related then you can either 1) tune Mysql or 2) Tune your queries/database. The second is by far the easier.
  
  i.e. do you have the proper indexes built to support your queries? If you table is growing but you don't have the proper indexes, it would lead to things slowing down as you are doing full tablescans.
  
  =C=
- May 27, 2005 at 6:03 am #17959
  
  Ritesh
  Member
  
  SQLyog is just a client tool. It has nothing to do with the performance of your database servers. I will suggest that you check out with admin about the sluggishness.
- May 27, 2005 at 4:48 pm #17960
  
  peterlaursen
  Participant
  
  Slowing down could be because of the DB defragmenting.
  
  With InnoDB fragmentation can occurs “within” the InnoDB data-file (normally ONE file unless you specify the “InnoDB_file_pr_table” -option). It is described as far as InnoDB tables goes.
  
  http://dev.mysql.com/doc/mysql/en/innodb-f…ragmenting.html.
  
  But fragmentation can allways occur with the server file system. With MyIsam there can be a lot of seperate files (data files and index files) . They can be spread over the entire disk volumes available to the server, and each file can be in many fragments. Especially if you use webhosting you probably share the disk volumes with thousands of other users. Dumping and reloading data at intervals could be a solution here.
  
  You also could discuss the matter with the servers' maintanaince personnel. There might be some tools available with your webhosting. It depends on the server OS (and version) and what maintanaince software they use.
- May 27, 2005 at 4:49 pm #17961
  
  peterlaursen
  Participant
  
  Of couser it should have read:
  
  Slowing down could be because of the DB fragmenting. :wub:
- May 27, 2005 at 10:48 pm #17962
  
  Strigoi
  Member
  
  Compaq Proliant ml530
  
  12 – 10k RPM 32 Gig drives
  
  Windows XP SP2
  
  Abyss Web Server
  
  mysql 4 x's
  
  Sqlyog
  
  php 4 module
  
  6 Meg cable line ( 800 k up )
  
  Running a simple site, few html pages, and a forum, nothing elaborate. just wanted to know if there is any maintenance to be done, speed tweaks, things like that, thnx for the responses.
  
  New to all of this, but learning fast.
  
  Strigoi
  
  http://Www.Pirates-Paradise.coM
Author

Posts