View Full Version : Laston Table is huge, can i empty it?
October 14th, 2005, 01:44 AM
in mysqladmin my laston table has 259,000 entries. Can this be emptied? my photopost has been ruining my server lately. I'm up to 15,000 images. I just need to find a way to optimize mysql usage.
October 14th, 2005, 08:08 AM
You can empty it safely. Other ones as iponline ipcache admlog can be emptied as well
October 14th, 2005, 10:23 AM
thanks for the info. My main page seems to load a lot faster now. My site always has over 100+ guests online at once looking at pictures. A good day will be around 180.
Have you thought of doing more sql optimaztion. I'm not a pro, but I ran into this problem with OScommerce and 12,000 products. All the products are just in one table, products. I see in photopost all the images are in the table photos.
If it were broken up into more tables say like photo-a photo-b etc would that speed things up for sites with thousands of images?
October 14th, 2005, 11:00 AM
Our problem has been optimized alot. 5.2 even has a cache table that loads the index and popular items from a cache and not the tables.
October 14th, 2005, 11:54 AM
i have my options set for yes, but if I look at the source on my page there is this. Would that cancel it out?
<!-- no cache headers -->
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="expires" content="Tue, 21 Nov 2000 05:00:00 GMT" />
<meta http-equiv="cache-control" content="no-cache, must-revalidate" />
<!-- end no cache headers -->
October 14th, 2005, 02:14 PM
That has nothing to do with our cache thats our normal headers
The cache grabs the cat info etc from the cache table instead of multiple queries and tables which saves generation time and over half the needed queries to generate the page. Thats how it works
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.