Previous Thread
Next Thread
Print Thread
Rate Thread
#285244 05/11/2005 4:36 AM
Joined: Feb 2002
Posts: 8
SKB
Offline
Lurker
Lurker
Joined: Feb 2002
Posts: 8
Hi,

I wondered if anyone has any ideas on what might help with some slow mySQL queries that we're getting.

We're on version 6.4 right now (will be upgrading), and the slowdowns don't seem to occur on any one page or doing anything one thing.

Here are a few examples:

Generated in 27.738 seconds in which 27.725 seconds were spent on a total of 6 queries. Zlib compression enabled.

Generated in 45.657 seconds in which 44.546 seconds were spent on a total of 33 queries. Zlib compression enabled.

Generated in 56.191 seconds in which 56.172 seconds were spent on a total of 11 queries. Zlib compression enabled.

I just noticed the mySQL topic about tuning mySQL, which I will look into. Although I don't know if that'd help anything like this.

I'm not that much of a techy. It's a dedicated server, so we can alter things, but please go a bit easy on me with any advice. Also anything to monitor these queries, and if that would provide more information, would be welcome.

Many thanks

Sponsored Links
Squib #285245 05/11/2005 7:54 AM
Joined: May 2001
Posts: 550
Code Monkey
Code Monkey
Offline
Joined: May 2001
Posts: 550
>Also anything to monitor these queries, and if that would provide more information, would be welcome.

If you have phpMyAdmin you can let it shouw you all active queries. Then you will see which queries kills the server.

domain123 #285246 05/11/2005 6:34 PM
Joined: Feb 2002
Posts: 8
SKB
Offline
Lurker
Lurker
Joined: Feb 2002
Posts: 8
Thank you for the reply Anno. I do have that, yes, but I wasn't aware that you could view active queries. How does one do that?

But also, will it act as a historical record? I can look at mySQL process list and look at queries, but that only works if something is going on at that particular point. Whereas these slow queries are sporadic and random.

Thanks

Squib #285247 05/11/2005 11:22 PM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
There's a link in phpmyadmin to show current queries.


- Allen wavey
- What Drives You?
Joined: Feb 2002
Posts: 8
SKB
Offline
Lurker
Lurker
Joined: Feb 2002
Posts: 8
[]AllenAyres said:
There's a link in phpmyadmin to show current queries. [/]

Thanks. But I can only see a 'processlist' link. Is there something else?

Sponsored Links
Squib #285249 05/12/2005 5:57 AM
Joined: Dec 2000
Posts: 1,471
Addict
Addict
Offline
Joined: Dec 2000
Posts: 1,471
Processlist is the right spot. It shows the query in the last column.

-Fusion- #285250 05/12/2005 5:05 PM
Joined: Feb 2002
Posts: 8
SKB
Offline
Lurker
Lurker
Joined: Feb 2002
Posts: 8
Thanks guy. But that's just a fancy interface for looking at a process list in an ssh prompt. What it does it just show active queries at that particular moment in time; as I said above, the slow queries are random and sporadic. To look at the process list at the exact moment a slow query is running would be near impossible.

I've since read about a mySQL option that will create a log of slow queries. Has anyone had any experience in using that to know of it's useful?

Squib #285251 05/12/2005 7:13 PM
Joined: Oct 2001
Posts: 213
Member
Member
Offline
Joined: Oct 2001
Posts: 213
You really should work through the recommendations in the Tuning MySQL threads (and search that forum for more advice). We had the same problem on occasion, I spent some time tuning MySQL, and our forums have been flying ever since.

The problem we were experiencing was massive table locks. If you look at processlist and see a lot of table locks, you need to tune your my.cnf settings.


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Bill B
Bill B
Issaquah, WA
Posts: 87
Joined: December 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)