MySQL issues

Status
Not open for further replies.

denizx13

Member
Messages
41
Reaction score
0
Points
6
MySQL is very slow in processing queries. What is everyone using ? Outside servers? PHPMyadmin is not helping setting the memory limits, etc.
What can you suggest to do?
 

garrettroyce

Community Support
Community Support
Messages
5,611
Reaction score
249
Points
63
Where are you seeing an issue?

I don't believe outgoing SQL connections are allowed through the firewall, but I had only experienced that years ago.

PHPMyAdmin isn't going to help as your user credentials will not allow you to override the system limits.
 

denizx13

Member
Messages
41
Reaction score
0
Points
6
Thank You for your response. I know the firewall issue because I tried to use my own MySQL server here but could not connect.
Having said that the issue is sql queries are very slow. I am starting a new site that has many products and sorting them to serve on the website takes long time and visitors dont wait so no sales. I am trying to speed up the response time. I indexed most tables increased speed many folds but still slow .
with PHPMyAdmin I can only do so much.
Again thanks for your reply.
 

garrettroyce

Community Support
Community Support
Messages
5,611
Reaction score
249
Points
63
Your website looks pretty quick to me, assuming I'm looking at the right thing. Have you tried benchmarking a query and making sure it's not something else? I get these JS errors on your site:

GET http://deniz.x10host.com/w.sharethis.com/button/buttons.js net::ERR_ABORTED 404 (Not Found)
(index):964 GET http://deniz.x10host.com/s.sharethis.com/loader.js net::ERR_ABORTED 404 (Not Found)
(index):963 GET http://deniz.x10host.com/w.sharethis.com/button/buttons.js net::ERR_ABORTED 404 (Not Found)
(index):964 GET http://deniz.x10host.com/s.sharethis.com/loader.js net::ERR_ABORTED 404 (Not Found)
(index):967 Uncaught ReferenceError: sharethis is not defined
at (index):967
(anonymous) @ (index):967

Your whole page loads in 53ms for me, except for the broken links.
 

denizx13

Member
Messages
41
Reaction score
0
Points
6
That is the old site. All html. I dont know why it is serving that.
New site is www.deniz.com it is PHP and MySQL. Open cart site.
That is the slow one.
 

garrettroyce

Community Support
Community Support
Messages
5,611
Reaction score
249
Points
63
@denizx13 I'm closing this thread because there has been no activity in several days. Please open a new thread if you have any further issues.
 
Status
Not open for further replies.
Top