slow, underpowdered and always hang :oIo:
-
IP addresses are NOT logged in this forum so there's no point asking. Please note that this forum is full of homophobes, racists, lunatics, schizophrenics & absolute nut jobs with a smattering of geniuses, Chinese chauvinists, Moderate Muslims and last but not least a couple of "know-it-alls" constantly sprouting their dubious wisdom. If you believe that content generated by unsavory characters might cause you offense PLEASE LEAVE NOW! Sammyboy Admin and Staff are not responsible for your hurt feelings should you choose to read any of the content here. The OTHER forum is HERE so please stop asking.
Sam Leong, this is a picture of your f. database
- Thread starter Rogue Trader
- Start date
another one, el cheapo.
.jpg)
Another one for you. since your F database always kenna 'hack' like these losers below. Ha ha ha ha
slow, underpowdered and always hang :oIo:
I love this pic. This is Sam's POOR ASS!
Sam can consider to have his MYSQL sever running in a separated box apart from the same box hosting Apache & PHP during next upgrade.
That is to setup a new server box within the same data center, running only MYSQL dedicated, link via 1000BT ethernet to the existing box, through standard TCPIP port #3306. Migrate the SQL DB over there from existing box, and point this V-bulletin's PHP over to the new box for database. Once working drop the SQL DB & turn off the MYSQL Server at localhost. From then onwards this box will be only the Apache web & PHP server only. SQL database is in another stronger box with more RAM & CPU power.
This is going to $$$cost$$$ few hundred more per month.
So sell ads space to cover?:p
For a V-Bulletin forum like this, usually Apache is not so big overhead for CPU & RAM (only WAN bandwidth mainly). PHP is slightly more CPU & RAM (heavier on CPU side). MYSQL is the main consumption of RAM & CPU resources in this case. It is not so bad at the beginning when the database is small, when we guys posted more and more and number of user A/C increased, the load expands exponentially upwards on CPU & RAM, taken to do each SQL search & update. I know that Sam got customized scripts to anti-spam and clean up this forum besides the regular V-bulletin PHP scripts, do not under-estimate these things, they can take up more CPU + RAM on the MYSQL side, surely also load down the PHP or whatever script host which Sam's script are written in, I assume it is PHP, but can be Perl or Ruby or anything.
That is to setup a new server box within the same data center, running only MYSQL dedicated, link via 1000BT ethernet to the existing box, through standard TCPIP port #3306. Migrate the SQL DB over there from existing box, and point this V-bulletin's PHP over to the new box for database. Once working drop the SQL DB & turn off the MYSQL Server at localhost. From then onwards this box will be only the Apache web & PHP server only. SQL database is in another stronger box with more RAM & CPU power.
This is going to $$$cost$$$ few hundred more per month.
So sell ads space to cover?:p
For a V-Bulletin forum like this, usually Apache is not so big overhead for CPU & RAM (only WAN bandwidth mainly). PHP is slightly more CPU & RAM (heavier on CPU side). MYSQL is the main consumption of RAM & CPU resources in this case. It is not so bad at the beginning when the database is small, when we guys posted more and more and number of user A/C increased, the load expands exponentially upwards on CPU & RAM, taken to do each SQL search & update. I know that Sam got customized scripts to anti-spam and clean up this forum besides the regular V-bulletin PHP scripts, do not under-estimate these things, they can take up more CPU + RAM on the MYSQL side, surely also load down the PHP or whatever script host which Sam's script are written in, I assume it is PHP, but can be Perl or Ruby or anything.
Last edited:
He is another attention seeker. lmfao
Similar threads
