Em Andamento

Help Find Problem on my Server that causes it to Collapse

I'm currently on a VPS Server with 1gb dedicated ram (just for me) and burstable to 2gb. I have a huge database (one table in INNODB while other in MyISAM), with about 200,000 records (was more before serever crashed and I had to restore an older backup) Problems: - When left a longtime without restarting, the server starts to really slow down, pages load from usually .5 seconds to 30 seconds+++. - When in PHP MY Admin and trying to browse all records it shows one time "Showing rows 0 - 229 (94,931 total, Query took [url removed, login to view] sec)" "Showing rows 0 - 229 (25,251 total, Query took [url removed, login to view] sec)" "Showing rows 0 - 229 (102,974 total, Query took [url removed, login to view] sec)" for same table, always different number. Solutions Tried: - Turning off all the functions that required grabbing lots of rows from mysql at once. - upgrading ram - setting a restart server function every couple min (very cheap way to fix) Need help to fix this, to have a smooth running server. I prefer to have myself get directions how to fix it, as I cannot afford to lose data on the server for the company. If you give me a valid fix and server still keeps working after 5 days min and 10 days max at optimal I will release funds.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

php mysql innodb apache linux

Habilidades: Vale Tudo, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, Redação técnica

Ver mais: vps linux cheap, vps 2gb ram, smooth on, release funds, place hire, one cheap code, need software engineering company, need hire engineering, find solutions, get coder problem, fix sites, find problems, find package, find hire, find coder hire, directions software solutions, coder cheap, cheap web sites, cheap law, buyer find, find myself, linux find, find seller, apache web server software, my funds

Acerca do Empregador:
( 6 comentários ) Vancouver, Canada

ID do Projeto: #3041394

Premiar a:

sysadminonline

See private message.

$42.5 USD em 10 dias
(361 Avaliações)
6.6