Em Andamento

sessions not closing properly on site, site slow

We are having a problem with slow speeds on our site Curveclothing co uk

When ever there is more than say 8 people online the site and the backend (cscart) slows down and then eventually crashes

Webfusion host the site, and we are on a dedicated server. We contacted them about this issue and they ran something called a "slow query log" on our site. this was what they came back with (in Blue):

The following queries have been logged so far in the slow query log

# Time: 091210 15:24:05

# User@Host: curvemain[curvemain] @ localhost []

# Query_time: 28 Lock_time: 0 Rows_sent: 1 Rows_examined: 688958

use curvemain;

SELECT COUNT(distinct cscart_stat_requests.sess_id) FROM cscart_stat_requests LEFT JOIN cscart_stat_sessions ON cscart_stat_requests.sess_id = cscart_stat_sessions.sess_id WHERE [url removed, login to view] <= 300 AND cscart_stat_sessions.client_type='U';

# Time: 091210 16:54:39

# User@Host: curvemain[curvemain] @ localhost []

# Query_time: 51 Lock_time: 0 Rows_sent: 1 Rows_examined: 689106

SELECT COUNT(distinct cscart_stat_requests.sess_id) FROM cscart_stat_requests LEFT JOIN cscart_stat_sessions ON cscart_stat_requests.sess_id = cscart_stat_sessions.sess_id WHERE [url removed, login to view] <= 300 AND cscart_stat_sessions.client_type='U';

# Time: 091210 18:17:54

# User@Host: curvemain[curvemain] @ localhost []

# Query_time: 13 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

SELECT value FROM cscart_language_values WHERE lang_code='EN' AND name='copyright';

As you can see these are taking a very long time to execute. This is usually caused by there being a huge number of rows in the table for the query to read and work with. Indexing the tables correctly is often a way of reducing the time the queries will take to execute.

In addition I have watched the active process list on the server and have noticed that php seems to regularly have high CPU usage. This high usage generally lasts less than a second, but is still a large spike. Unfortunately it does not provide any information as to which script is running, only the account that is running the script which in this case is the curvemain account. Likely the script is using high resource usage because it is accessing a table in the database that is taking a few moments to retrieve the data. As you can imagine, if a query takes several seconds to execute and is using 80 -90% of the available resources on the CPU and memory, if a couple of people run the same script at the same time while browsing, the server will begin to grind to a halt, and this is likely the cause of your issues. However actually locating the issue in the code and indexing the tables to make searches and data retrieval more efficient will be down to yourselves to perform I'm afraid.

Would you be able to fix this problem, if so what information would you need to complete the job ?

after looking into the database, to clear the session table

which is extremely long, and probably stores the sessions since the website has been is online

Habilidades: PHP, Instalação de Script, Carrinhos de compras, SQL

Ver mais: query_time lock_time, cscart_stat_requests large, cscart_stat_requests, online work site, online php execute, online job on php, looking for a second job online, job searches, i will be on site, fix on site, execute php online, execute c++ code online, cscart_stat_sessions, webfusion, value stores, so slow, blue host, timestamp, online data en, locating, fix slow, cscart, accessing, read process memory, php script execute

Acerca do Empregador:
( 2 comentários ) london, United Kingdom

ID do Projeto: #589415

Premiar a:

cheapestandbest

Ready to start

$100 USD em 2 dias
(645 Avaliações)
8.8

4 freelancers are bidding on average $190 for this job

USAGraphicPR0

**************************************************************************.. YOUR SEARCH ENDS HERE .. **************************************************************************** GET IT DONE RIGHT THE FIRST TIM Mais

$400 USD in 8 dias
(40 Comentários)
7.4
profitcom220

hi plz check pm

$80 USD em 1 dia
(68 Comentários)
5.8
ajdove

I am fully versed in the PHP and MYSQL. It is probably a result of inefficient coding which I should be able to fix. I would need a copy of your source code to examine in order to find the cause of the problem. Look f Mais

$70 USD in 2 dias
(0 Comentários)
0.0
zerift

I would enjoy being able to take on this project and work with you to resolve the issues that have arisen with your PHP based shopping cart. If you would like further details. Please read my Private message.

$91 USD in 5 dias
(0 Comentários)
0.0
msklizmantas

hello, I am pro sysadmin and specialize in web hosting scenarious, especially for high performance needs. I would like to propose my services for checking your server configuration, application implementation and datab Mais

$200 USD in 3 dias
(0 Comentários)
0.0