Not signed in (Sign In)

Categories

Vanilla 1.1.5 is a product of Lussumo. More Information: Documentation, Community Support.

Help keep Vanilla free:
Welcome Guest!
Want to take part in these discussions? If you have an account, sign in now.
If you don't have an account, apply for one now.
    • CommentAuthormarkezz
    • CommentTimeApr 11th 2008 edited
     # 1

    Many MySql database operations result in space that is left unused and resulting in slower data queries. You can use this extension to reclaim this unused space and to defragment the tables data files.

    Changelog

    • 0.4
      • 2008/04/28 - Fixed MySql issue causing a php notice on optimization
      • 2008/04/28 - Added FAQ to ReadMe.txt
    • 0.3
      • 2008/04/12 - Fixed MySql issue
    • 0.2
      • 2008/04/12 - Added IpHistory cleanup options
      • 2008/04/12 - Fixed an error in ReadMe.txt ;)
    • 0.1
      • 2008/04/12 - Initial Release
    • CommentAuthorfysicsluvr
    • CommentTimeApr 11th 2008
     # 2
    you could also have it auto-delete old ip address data as mentioned here.
    • CommentAuthormarkezz
    • CommentTimeApr 11th 2008
     # 3
    Thats a great suggestion. I am going to integrate that in the next version (asap). Thanks!
    • CommentAuthorfysicsluvr
    • CommentTimeApr 11th 2008
     # 4
    Try making it an admin option as to how long until ip data is deleted. (1 hour? 1 day? 1 week? 1 month? 3 months? 6 months? 1 year?) If it's too soon, it deems the ip logging feature useless (it might as well be disabled), if it's too long, the gained performance is useless. This happy medium will be at a different place for each forum depending on traffic, and admin capabilities.
    • CommentAuthorabcpeanuts
    • CommentTimeApr 11th 2008
     # 5
    Hi fysicsluvr adn markezz. Thanks for your help on the forum. I will download this tomorrow and implement it.
  1.  # 6
    Uploaded version 0.2 of Optimize Tables.
    •  
      CommentAuthorHamed
    • CommentTimeApr 11th 2008
     # 7
    sounds pretty sweet
    cool stuff
    •  
      CommentAuthorWanderer
    • CommentTimeApr 12th 2008
     # 8
    Oops...

    undefined.undefined();
    The error occurred on or near: You have an error in your SQL syntax;
    check the manual that corresponds to your MySQL server version for the
    right syntax to use near 'WHERE `Name` LIKE 'LUM_%' AND `Data_free` > 0' at line 1
  2.  # 9
    Uploaded version 0.3 of Optimize Tables.
    • CommentAuthormarkezz
    • CommentTimeApr 12th 2008
     # 10
    That error occured because of a mysql version prior to 5.0.1 - sorry, did not think about that. now its compatible from mysql 3.23...
    •  
      CommentAuthorWanderer
    • CommentTimeApr 12th 2008
     # 11
    OK great it seems to work now.

    So how often does it check to optimize?
    Is it configurable?

    Posted: Sunday, 13 April 2008 at 12:05PM

    •  
      CommentAuthorWanderer
    • CommentTimeApr 12th 2008
     # 12
    Another question, I cleaned up the IP history using this extension.

    How come I can still see each user's "Last Known Ip"?
    • CommentAuthorfysicsluvr
    • CommentTimeApr 12th 2008
     # 13
    it doesn't clean up all ip's, just the ones from the past. (it logs more than you think)
    • CommentAuthormarkezz
    • CommentTimeApr 13th 2008 edited
     # 14
    So how often does it check to optimize?
    Is it configurable?

    The optimization can only be started manually.
    •  
      CommentAuthorWanderer
    • CommentTimeApr 13th 2008
     # 15
    OK I see the "Optimize tables now" button appears now that I have 32 bytes overhead, great.

    Is the IP history deleted automatically? I have it set to one month.
    • CommentAuthormarkezz
    • CommentTimeApr 13th 2008
     # 16
    The IP history will be deleted when you either press the Button "Optimize tables now" or (if there is no overhead) the Button "Cleanup ip history now". For your setting it will then remove all entries from the IP history that are older than one month.

    An automated feature would mean to either use a cron-job, or to check on every page request if its already the time and need to perfom the cleanup again. Most of the standard web-hosters do not offer cron-usage and in my opinion an extension like this should not affect the speed of the forum. But if there is need for an automatic cleanup feature, I can implement an admin option in the next release to activate something like this.
    • CommentAuthorfysicsluvr
    • CommentTimeApr 13th 2008
     # 17
    I think it would be nice to have this feature. If I'm the only one, then don't waste your time.

    You should have the cron-job options separate in case someone wants only one option automated.
    •  
      CommentAuthorWanderer
    • CommentTimeApr 13th 2008
     # 18
    Actually mate, I prefer it as it is, we tend to forget about automatic jobs then when something goes wrong we don't know where to look.

    You've done a massive job on this extension, I was satisfied to do the optimizing in the control panel provided by my host but it's much more convenient using your interface within Vanilla itself.

    Could I suggest you include a little more information in the read-me? This would stop people like me bugging you with questions.

    Otherwise, a top job, thank you sincerely.
    • CommentAuthorfysicsluvr
    • CommentTimeApr 13th 2008
     # 19
    hmm... good point.
    • CommentAuthorlibido
    • CommentTimeApr 27th 2008
     # 20
    i tried this extension
    i hit optimize tables after setting it to '1 week' above
    & got the following errors :

    Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47

    Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47

    Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47

    Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47

    Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47

    Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47

    Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47

    fortunately the forum still works, but i was wondering if this was normal to get these errors?
    • CommentAuthormarkezz
    • CommentTimeApr 27th 2008
     # 21
    no, it is not.. i am going to fix that tonight. may i ask what mysql-version you are using ?
    • CommentAuthorlibido
    • CommentTimeApr 27th 2008
     # 22
    it's a godaddy account with mysql 4.0, it seems
  3.  # 23
    Uploaded version 0.4 of Optimize Tables.
    • CommentAuthorcircuit
    • CommentTime7 days ago
     # 24
    thanks, this cut my database down from more than 60mb to 21mb.
Add your comments
    Username Password
  • Format comments as