Welcome to the JaguarPC Community
JaguarPC
Sales: (888) 338-5261
Support: (888)-551-3050
Results 1 to 10 of 10

This is a discussion on Optimizing MySQL - How Often in the Open Discussion & Chit-chat forum
I check my sql db, and optimize it, at least once a day, sometimes more... I was just doing it, and wondered, how often do ...

  1. 07-10-2005, 12:07 AM #1
    Vin DSL
    Vin DSL is offline
    Yeah, I know a LOT! Vin DSL's Avatar
    Join Date
    Mar 2003
    Location
    Arizona Uplands
    Posts
    10,775

    Question Optimizing MySQL - How Often

    I check my sql db, and optimize it, at least once a day, sometimes more...

    I was just doing it, and wondered, how often do YOU optimize MySQL?
    DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.

    No Guts, No Story! VinDSL © 2010
    Reply With Quote Reply With Quote
  2. 07-10-2005, 01:47 AM #2
    Spathiphyllum
    Spathiphyllum is offline
    || $name ne 'R.Stiltskin'
    Join Date
    Jun 2003
    Location
    Tejas
    Posts
    2,438
    Weekly.
    Reply With Quote Reply With Quote
  3. 07-10-2005, 10:10 AM #3
    Julian Muñoz
    Julian Muñoz is offline
    Like a star... Julian Muñoz's Avatar
    Join Date
    Oct 2002
    Location
    Colombia
    Posts
    1,399
    When I have the time.... :S My sql server's been running for 31 days, over 55 million queries has been sent to the server and I have an overall of 20 queries per second... But I don't optimize the database that often... I backup my database daily however...
    Julian D. Muñoz - LANeros.com
    Reply With Quote Reply With Quote
  4. 07-10-2005, 12:12 PM #4
    Gwaihir
    Gwaihir is offline
    the Windlord Gwaihir's Avatar
    Join Date
    Jun 2002
    Posts
    2,562
    Rarely actually. Lot of work to go by every table for that stuff. Also a bit of an "if it isn't broken don't try to fix it" feeling about it.

    I assume you've got that all scripted then, Vin?
    Regards,

    Wim Heemskerk
    ---
    Visit MeCCG.net - Cardgaming in J.R.R. Tolkien's Middle-earth
    And Gwaihir.net - The Middle-earth CCG store
    Reply With Quote Reply With Quote
  5. 07-10-2005, 01:49 PM #5
    Vin DSL
    Vin DSL is offline
    Yeah, I know a LOT! Vin DSL's Avatar
    Join Date
    Mar 2003
    Location
    Arizona Uplands
    Posts
    10,775
    Quote Originally Posted by Gwaihir
    I assume you've got that all scripted then, Vin?
    If you're asking, "Is the optimization process scripted?” the answer is yes 'n' no. I can optimize my db using a script on my site, but I prefer to use phpMyAdmin instead.

    The 'problem' with PHP-Nuke, if you want to call it a 'problem', is it hammers the sql server pretty hard, and every once in a while the server hiccups. When the server collects enough unclosed queries, it says, "Screw you!” hangs and/or starts cross-linking (corrupting) tables, et cetera...

    To be fair, I doubt that PHP-Nuke is totally at fault here. For instance, it could be a bad RSS feed, or something else that starts the ball rolling. It'll go for months with no problem. However, a hung sql server is disastrous to PHP-Nuke. Nuke will not run (exclamation point) without a properly functioning MySQL server, so I'm a little paranoid about letting things get carried away. Accordingly, I probably check/optimize more than necessary.
    DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.

    No Guts, No Story! VinDSL © 2010
    Reply With Quote Reply With Quote
  6. 07-10-2005, 01:57 PM #6
    Vin DSL
    Vin DSL is offline
    Yeah, I know a LOT! Vin DSL's Avatar
    Join Date
    Mar 2003
    Location
    Arizona Uplands
    Posts
    10,775
    Quote Originally Posted by Julian Muñoz
    When I have the time.... :S My sql server's been running for 31 days, over 55 million queries has been sent to the server and I have an overall of 20 queries per second...
    My runtime: 9 days, 40 million queries total, 46 queries per second...
    DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.

    No Guts, No Story! VinDSL © 2010
    Reply With Quote Reply With Quote
  7. 07-10-2005, 06:23 PM #7
    Zenigata
    Zenigata is offline
    JPC Senior Member Zenigata's Avatar
    Join Date
    Jan 2005
    Location
    Italy
    Posts
    71
    How can you get stats from mysql?

    Thanks
    Reply With Quote Reply With Quote
  8. 07-10-2005, 06:37 PM #8
    Vin DSL
    Vin DSL is offline
    Yeah, I know a LOT! Vin DSL's Avatar
    Join Date
    Mar 2003
    Location
    Arizona Uplands
    Posts
    10,775
    Quote Originally Posted by Zenigata
    How can you get stats from mysql?
    I run my own install of phpMyAdmin. I get this info by simply clicking a link. Other than that, I dunno. Never did it the 'hard way'...
    DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.

    No Guts, No Story! VinDSL © 2010
    Reply With Quote Reply With Quote
  9. 07-10-2005, 08:42 PM #9
    Gwaihir
    Gwaihir is offline
    the Windlord Gwaihir's Avatar
    Join Date
    Jun 2002
    Posts
    2,562
    Still surprising: if I try to access that same page on the site wide phpMyAdmin it answers "No Privileges", yet doing your own install doesn't give you more privileges on the MySQL server, does it?
    Regards,

    Wim Heemskerk
    ---
    Visit MeCCG.net - Cardgaming in J.R.R. Tolkien's Middle-earth
    And Gwaihir.net - The Middle-earth CCG store
    Reply With Quote Reply With Quote
  10. 07-11-2005, 01:45 AM #10
    Vin DSL
    Vin DSL is offline
    Yeah, I know a LOT! Vin DSL's Avatar
    Join Date
    Mar 2003
    Location
    Arizona Uplands
    Posts
    10,775
    Quote Originally Posted by Gwaihir
    Still surprising: if I try to access that same page on the site wide phpMyAdmin it answers "No Privileges", yet doing your own install doesn't give you more privileges on the MySQL server, does it?
    'They' probably have that feature disabled in the phpMyAdmin config. As a matter of fact, 'they' probably have a lot of stuff disabled in the cPanel version of phpMyAdmin. I've never done an A-B comparison.

    You can setup phpMyAdmin every which way to Sunday. That's one of the reasons why I like to run my own install. There's even a 'demo' mode...
    DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.

    No Guts, No Story! VinDSL © 2010
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules