Make your site faster by 89,99% faster.

[subzero]

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]

what will happen if normally opt in every query shot?

[subzero]

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]

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]

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]

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]

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]

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]

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

Inboxing
Chat
Forums
Online

or having overhead over 1 kb in phpmyadmin

[GumSlone]

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.

[opticalpigion]

easy way is database and page caching.

[GumSlone]

install memcached to cache your database query results (facebook and vkontakte use it too),
use templates engine like smarty,
avoid multiple css/javascript files,
compress css/javascript,
also use nginx reverse proxy for static content (big russian sites like rambler and vkontakte use it),
you can also use mysql table type memory instead of myisam if you want store the data temporarily, eg for online users or chat messages.

this is actually the best way to speed up your site.

[subzero]

i installed nginx on my billing server and it had the up most crapped out lol i mean 100 was on it then boom dead server....

Unstalled nginx 100+ on billing fine lol wtf

[GumSlone]

i installed nginx on my billing server and it had the up most crapped out lol i mean 100 was on it then boom dead server....

Unstalled nginx 100+ on billing fine lol wtf

works fine for me, the server can handle now about 40% more users as it was before.

[subzero]

i mite know why lol

1. Script i use is apache and Nginx lol