LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 08-02-2006, 01:56 PM   #1
muskiediver
LQ Newbie
 
Registered: Mar 2006
Posts: 24

Rep: Reputation: 15
MY SQL running at 90% - Web site is bogged down - culprit?


Hello. I have the latest mambo CMS, 4.5.4 with the latest security updates. Recently my server was running at 90% of MY SQL resource usage. I restarted MY SQL and now it is running fine. I do not want this to happen again.

My ISP suggested I check any newer scripts that I have installed on my server. They said I can also check for updates to any web applications that I have installed. Finally they said my server does not log with enough detail to determine the source of the high usage.

Since the only programs installed on my server that uses mysql are mambo and its components, modules and mambots, what should I look for in trouble shooting why my server is running at 90% usage? What would point to the culprit? This is the first time this has happened since I moved to a new server a few days ago. I understand from my isp there are no mysql log files.

Please advise and thank you.
 
Old 08-03-2006, 08:05 AM   #2
Hangdog42
LQ Veteran
 
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,791
Blog Entries: 1

Rep: Reputation: 414Reputation: 414Reputation: 414Reputation: 414Reputation: 414
Have you installed any site statistics modules? I know on Joomla those can cause some serious problems with MySQL and have caused more than a few people to be cut off by their ISP.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Web-based reporting tool for MS SQL Server nkendrick Linux - Software 0 06-27-2004 01:02 PM
Running SQL on linux digital bots Linux - Software 3 06-04-2004 05:44 PM
which web site is that ? satishpatel Linux - Wireless Networking 1 05-05-2004 05:38 AM
What do I want for my web site? rickenbacherus General 8 01-20-2004 09:29 PM
how do i connect thru SQL Server Running on windows NT puru_09 Linux - Software 1 08-11-2002 11:05 AM


All times are GMT -5. The time now is 08:13 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration