Tip for Database Tuners

[Huffd]

If you've got tens of thousands of products to sell, love to tune databases like I do and want to get every last bit of performance from your database this page is a good read.

 

http://www.databasejournal.com/features/my...cle.php/3110171

 

Once you've read it, understood it, performed it and lived it, there is one sticking point in osCommerce that will cause the Qcache_not_cached to continue to grow. It took me some hunting but I finally found what was causing osC not to write a letter perfect cache every time.

 

includes/application_top.php

// auto expire special products

// require(DIR_WS_FUNCTIONS . 'specials.php');

// tep_expire_specials();

 

Of course it's the script that performs a lookup on the specials and flags them when they are no longer on sale. For me this is an easy fix since all of my specials are on sale until sold so I simply commented out the line(s). Maybe someone would like to move this to the admin so that it is only called when an admin logs in.

 

Strangely I never came across this information in Oreilly's MySQL Cookbook, I haven't gotten my hands on Monty's new book yet, I'd bet I'd find it there.

 

And I don't know if this is available in 3.x versions since I've been using only MySQL4 in production since the week MySQL 4.0.0.-- went alpha a few years ago.

 

Other readings from this same site can be found here:

http://www.databasejournal.com/features/mysql/archives.php

 

Happy tooling!