Make your site faster by 89,99% faster.

**subzero** · 15-02-11, 16:24

Add file called opt.php

to www folder

add All your database like

<?php
include("your_config.php");
include("your_core.php");

mysql_query("OPTIMIZE TABLE `users`,`forums`,`chat`") or die("ERROR: DATABASE NOT IN THIS FILE!");

?>

In order
Minute Hour Day Month Weekday
0 * * * *

Now the Command
Corn Job
/usr/local/bin/php /home/USERNAME/public_html/opt.php>/dev/null

Only Change is in red USERNAME to your cpanel username...

Enjoy

**khan** · 15-02-11, 16:27

what will happen if normally opt in every query shot?

**subzero** · 15-02-11, 16:32

This will do it for you as far lavalair using alot of cpu as for mysql and owners are fooking lazy to OPTIMIZE TABLE THERE SITE to make it run smoothly and best

Get corn job to do it for you lol

You need to select all in phpmyadmin then OPTIMIZE TABLE it copy your OPTIMIZE TABLE `user thing in phpmyadmin will auto give this code then add it how i show you.

Now when corn job OPTIMIZE TABLE your table it will do it to all tables and make your site run faster.

Also it does not hurt to add your email to get updates on corn jobs

Got the idea now ?

**khan** · 15-02-11, 16:41

yep.... Gooood. I personally dnt like lava. Not only for lava users, it will work for those who hv lotsa table in their db.
Gonna use it to my next site

**subzero** · 15-02-11, 16:45

Thats right this can be used for any site

Also note this does it in a hour time so your tables of more or less

users online | hours / mins / days

1 to 10 = day
1 to 60 = once a day
1 to 100 = 1 hour base
1 to 1000 = 1 min base

So basic your site always OPTIMIZE TABLE it self

**morency** · 15-02-11, 16:50

you tested and get a 89.99% better result ?
Is just a question ...

I also optimize db table when I log in to panel.

You can add a httpd restart every 3-5 days (I dont know if is ok:D)

**subzero** · 15-02-11, 17:04

restarting httpd is not a good idea as does nothing to phpmyadmin

My old site had 500 + members online and cpu was 1.92% as user was online using httpd i notice once i had 100 members my cpu was 4.99% or more i don't remember its was old lol days but i did this tick ever time user login or brows the site it will optimize the site.

then my cpu jump to 2.99% and it was using mysql too many times so i set corn jobs

got my self a 1.92% adv speed and now i can defate my scripts with gzip so the site is moving hell alot faster then my old one but its has not had users online yet as it is still in beta mode as i don't yet pay to sell ads for my site like i did before...

Prodigits do the same way but in other way as it is in asp coding.

**morency** · 15-02-11, 18:46

So , you recommend , for a site ..let's say with 500online users (real ,ofcourse) the cron job to be set to 1m up to 1h ?!

**subzero** · 15-02-11, 18:53

its upto how much bullsh()$*#t users use like

Inboxing
Chat
Forums
Online

or having overhead over 1 kb in phpmyadmin

**GumSlone** · 15-02-11, 18:54

Originally Posted by morency [Only registered and activated users can see links. Click Here To Register...]

So , you recommend , for a site ..let's say with 500online users (real ,ofcourse) the cron job to be set to 1m up to 1h ?!

dont do that, because when the mysql runs the optimize/repair query and some other processes will write data to mysql it may break the table structure, make a cron to optimize mysql once a day, at night time when thr traffic is low.