Database Auto-Optimizer

youngvet1 · #21 05-13-2006, 05:46 PM

Is there any difference between optimizing like this and just clicking repair for the database -- from the mysql section in cpanel?

adrock5150 · #22 06-19-2006, 09:20 AM

Hello,

would this work for a litecommerce installation? Could it be made to work or is there something like this out there for litecommerce?

NuAlpha · #23 06-19-2006, 01:21 PM

It should work for no matter what shopping cart system you are using.

designtrade · #24 06-20-2006, 03:50 PM

currently using this on my site, thank you very much!

youngvet1 · #25 06-20-2006, 04:17 PM

Is there a difference between optimizing a database and repairing a database??

NuAlpha · #26 06-22-2006, 01:32 PM

Quote:

Originally Posted by youngvet1

Is there a difference between optimizing a database and repairing a database??

Repairing tables instead of optimizing them can be signifigant slower in some cases.

An example of this happening can be seen in the comments on this MySQL documentation page:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html

designerweb · #27 07-23-2006, 12:34 PM

Can this script crash your database in any way?

carpeperdiem · #28 09-18-2006, 03:10 PM

Has anyone used this on a 4.1 database? Anything to know about? Thanks!

Jeremy

2coolbaby · #29 10-01-2006, 11:55 AM

Anyone want to make $20 to add this to my site? I am on a VPS with Plesk control panel. I don't think I have it right and it seems like a very useful script to run.

smrtsu · #30 10-05-2006, 03:38 PM

Quote:

Originally Posted by mltriebe

So how can I tell if this is working? I am trying it on my local test copy and can't see any difference in the SQL coding. I have no idea if it is doing anything or not. I know I had some settings wrong in the first few tries but I think I have it all correct now but nothing still seems to be happening.

Thanks

Same here. when I put this "http://localhost/inspa/db_optimizer.php" in the browser i just get a blank page - I have a test site on my localhost, so this is how I have the db_optomizer.php set up:
-----------------------------------------------
# Ensure the script execution request is by the server.
if (empty($_SERVER['REMOTE_ADDR']) && empty($_SERVER['SERVER_ADDR'])) {

# Define Constants
define('ERROR_LOG', 'http://localhost/inspa/log/db_optimization_errors.html');
define('DB_LINK', mysql_connect('localhost','',''));
define('DB_NAME', 'inspa');
----------------------------------------------
also, do I need to create this file? db_optimization_errors.html or does the optimizer do it for you? I don't want to run it on my live site until I make sure I'm doing it correctly.
What am I doing wrong?