Any tips on what is causing this? System is as follows:
Red Hat 7.1
Dual-Athlon 1.2 Ghz
1 GB DDR RAM
15K RPM SCSI HDD
about 300,000 pageviews a day -- each with about 7-10 queries a page
Here is the processlist output: (warning, its BIG)
+--------+-------+-----------+--------+---------+------+----------------+---
-----------------------
----------------------------------------------------------------------------
+
| Id | User | Host | db | Command | Time | State |
Info
|
+--------+-------+-----------+--------+---------+------+----------------+---
-----------------------
----------------------------------------------------------------------------
+
| 197614 | amdmb | localhost | Amdmb | Sleep | 810 | |
|
| 201987 | amdmb | localhost | Amdmb | Sleep | 557 | |
|
| 204595 | amdmb | localhost | forum | Sleep | 416 | |
|
| 205056 | amdmb | localhost | forum | Sleep | 196 | |
|
| 205113 | amdmb | localhost | forum | Sleep | 185 | |
|
| 205141 | amdmb | localhost | forum | Sleep | 100 | |
|
| 205210 | amdmb | localhost | forum | Sleep | 86 | |
|
| 205250 | amdmb | localhost | forum | Sleep | 80 | |
|
| 205455 | amdmb | localhost | forum | Query | 17 | |
|
| 205536 | amdmb | localhost | forum | Sleep | 3 | |
|
| 205531 | amdmb | localhost | forum | Sleep | 58 | |
|
| 205530 | amdmb | localhost | forum | Init DB | 193 | |
|
| 205598 | amdmb | localhost | forum | Sleep | 185 | |
|
| 205653 | amdmb | localhost | forum | Sleep | 183 | |
|
| 205688 | amdmb | localhost | Amdmb | Query | 4 | Sorting result |
SELECT News.NewsID, News.
Title, News.Date, News.Author, News.Source, News.Link, News.Information, Ne
|
| 205689 | amdmb | localhost | Amdmb | Query | 11 | cleaning up |
SELECT News.NewsID, News.
Title, News.Date, News.Author, News.Source, News.Link, News.Information, Ne
|
| 205742 | amdmb | localhost | forum | Query | 3 | Sending data |
SELECT COUNT(*) AS messag
es FROM privatemessage WHERE userid=10842 AND dateline>1005351553 AND folde
|
| 205724 | amdmb | localhost | forum | Init DB | 161 | |
|
| 205793 | amdmb | localhost | forum | Sleep | 104 | |
|
| 205795 | amdmb | localhost | forum | Sleep | 101 | |
|
| 205798 | amdmb | localhost | forum | Sleep | 161 | |
|
| 205787 | amdmb | localhost | forum | Sleep | 3 | |
|
| 205826 | amdmb | localhost | forum | Init DB | 146 | |
|
| 205809 | amdmb | localhost | forum | Sleep | 129 | |
|
| 205844 | amdmb | localhost | forum | Init DB | 3 | |
|
| 205899 | amdmb | localhost | Amdmb | Query | 18 | cleaning up |
SELECT News.NewsID, News.
Title, News.Date, News.Author, News.Source, News.Link, News.Information, Ne
|
| 205906 | amdmb | localhost | forum | Sleep | 101 | |
|
| 205875 | amdmb | localhost | forum | Sleep | 101 | |
|
| 205942 | amdmb | localhost | Amdmb | Query | 3 | Sorting result |
SELECT News.NewsID, News.
Title, News.Date, News.Author, News.Source, News.Link, News.Information, Ne
|
| 205944 | amdmb | localhost | forum | Sleep | 104 | |
|
| 205946 | amdmb | localhost | forum | Sleep | 92 | |
|
| 205957 | amdmb | localhost | forum | Sleep | 91 | |
|
| 205959 | amdmb | localhost | forum | Sleep | 92 | |
|
| 205971 | amdmb | localhost | forum | Sleep | 104 | |
| 205963 | amdmb | localhost | Amdmb | Query | 3 | Sorting result |
SELECT News.NewsID, News.
Title, News.Date, News.Author, News.Source, News.Link, News.Information, Ne
|
| 205956 | amdmb | localhost | forum | Sleep | 4 | |
|
| 205949 | amdmb | localhost | forum | Sleep | 80 | |
|
| 206007 | amdmb | localhost | forum | Sleep | 91 | |
|
| 206010 | amdmb | localhost | Amdmb | Query | 3 | Writing to net |
SELECT News.NewsID, News.
Title, News.Date, News.Author, News.Source, News.Link, News.Information, Ne
|
| 206115 | amdmb | localhost | Amdmb | Sleep | 83 | |
|
| 206131 | amdmb | localhost | forum | Sleep | 79 | |
|
| 206112 | amdmb | localhost | forum | Sleep | 84 | |
|
| 206158 | amdmb | localhost | forum | Sleep | 79 | |
|
| 206161 | amdmb | localhost | forum | Sleep | 79 | |
|
| 206180 | amdmb | localhost | forum | Sleep | 58 | |
|
| 206184 | amdmb | localhost | forum | Sleep | 72 | |
|
| 206205 | amdmb | localhost | forum | Sleep | 72 | |
|
| 206204 | amdmb | localhost | forum | Sleep | 72 | |
|
| 206189 | amdmb | localhost | forum | Sleep | 53 | |
|
| 206212 | amdmb | localhost | forum | Sleep | 58 | |
|
| 206213 | amdmb | localhost | forum | Sleep | 58 | |
|
| 206222 | amdmb | localhost | forum | Sleep | 58 | |
|
| 206217 | amdmb | localhost | forum | Sleep | 72 | |
|
| 206236 | amdmb | localhost | forum | Sleep | 58 | |
|
| 206240 | amdmb | localhost | forum | Sleep | 58 | |
|
| 206246 | amdmb | localhost | forum | Sleep | 54 | |
|
| 206251 | amdmb | localhost | forum | Sleep | 50 | |
|
| 206258 | amdmb | localhost | forum | Sleep | 65 | |
|
| 206257 | amdmb | localhost | forum | Sleep | 72 | |
|
| 206263 | amdmb | localhost | forum | Sleep | 72 | |
|
| 206279 | amdmb | localhost | forum | Sleep | 53 | |
|
| 206278 | amdmb | localhost | forum | Sleep | 52 | |
|
| 206287 | amdmb | localhost | forum | Sleep | 53 | |
|
| 206298 | amdmb | localhost | forum | Sleep | 50 | |
|
| 206299 | amdmb | localhost | forum | Sleep | 50 | |
|
| 206294 | amdmb | localhost | forum | Sleep | 58 | |
|
| 206290 | amdmb | localhost | forum | Sleep | 58 | |
|
| 206308 | amdmb | localhost | forum | Sleep | 66 | |
|
| 206319 | amdmb | localhost | forum | Sleep | 55 | |
|
| 206321 | amdmb | localhost | forum | Sleep | 58 | |
|
| 206324 | amdmb | localhost | forum | Sleep | 58 | |
|
| 206333 | amdmb | localhost | forum | Sleep | 65 | |
|
| 206343 | amdmb | localhost | forum | Sleep | 47 | |
|
| 206339 | amdmb | localhost | forum | Sleep | 52 | |
|
| 206307 | amdmb | localhost | forum | Sleep | 56 | |
| 206302 | amdmb | localhost | forum | Sleep | 44 | |
|
| 206242 | amdmb | localhost | forum | Sleep | 58 | |
|
| 206352 | amdmb | localhost | forum | Sleep | 58 | |
|
| 206347 | amdmb | localhost | forum | Sleep | 51 | |
|
| 206364 | amdmb | localhost | forum | Sleep | 40 | |
|
| 206386 | amdmb | localhost | Amdmb | Quit | 55 | |
|
| 206395 | amdmb | localhost | forum | Sleep | 47 | |
|
| 206399 | amdmb | localhost | forum | Sleep | 39 | |
|
| 206409 | amdmb | localhost | forum | Sleep | 50 | |
|
| 206401 | amdmb | localhost | forum | Sleep | 40 | |
|
| 206412 | amdmb | localhost | forum | Sleep | 47 | |
|
| 206427 | amdmb | localhost | forum | Sleep | 40 | |
|
| 206442 | amdmb | localhost | forum | Sleep | 37 | |
|
| 206448 | amdmb | localhost | forum | Sleep | 40 | |
|
| 206482 | amdmb | localhost | forum | Sleep | 40 | |
|
| 206592 | root | localhost | phpads | Query | 14 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206606 | root | localhost | phpads | Quit | 19 | |
|
| 206604 | root | localhost | phpads | Query | 7 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206536 | root | localhost | phpads | Query | 21 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='14'
|
| 206633 | amdmb | localhost | forum | Sleep | 37 | |
|
| 206650 | root | localhost | phpads | Query | 7 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206652 | amdmb | localhost | forum | Sleep | 27 | |
|
| 206669 | root | localhost | phpads | Query | 15 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206682 | root | localhost | phpads | Query | 5 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206685 | amdmb | localhost | Amdmb | Quit | 32 | |
|
| 206683 | root | localhost | phpads | Query | 7 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206678 | root | localhost | phpads | Query | 15 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='8'
|
| 206687 | root | localhost | phpads | Query | 20 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='12'
|
| 206686 | amdmb | localhost | forum | Sleep | 27 | |
|
| 206675 | amdmb | localhost | forum | Sleep | 26 | |
|
| 206698 | amdmb | localhost | forum | Sleep | 27 | |
|
| 206696 | root | localhost | phpads | Query | 6 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206701 | root | localhost | phpads | Query | 6 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206702 | amdmb | localhost | forum | Sleep | 34 | |
|
| 206690 | amdmb | localhost | forum | Sleep | 26 | |
|
| 206658 | root | localhost | phpads | Query | 14 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206655 | amdmb | localhost | Amdmb | Sleep | 3 | |
|
| 206705 | amdmb | localhost | forum | Sleep | 34 | |
|
| 206710 | root | localhost | phpads | Query | 10 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206714 | root | localhost | phpads | Query | 20 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='14'
|
| 206726 | root | localhost | phpads | Query | 20 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='12'
|
| 206737 | root | localhost | phpads | Sleep | 11 | |
|
| 206744 | root | localhost | phpads | Quit | 22 | |
|
| 206751 | amdmb | localhost | forum | Sleep | 26 | |
|
| 206764 | amdmb | localhost | Amdmb | Quit | 25 | |
|
| 206768 | root | localhost | phpads | Query | 22 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='14'
|
| 206776 | amdmb | localhost | forum | Sleep | 26 | |
|
| 206761 | root | localhost | phpads | Query | 23 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='14'
|
| 206760 | amdmb | localhost | forum | Sleep | 26 | |
|
| 206780 | root | localhost | phpads | Query | 22 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='6'
|
| 206787 | root | localhost | phpads | Query | 23 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='6'
|
| 206788 | root | localhost | phpads | Query | 22 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='6'
|
| 206790 | root | localhost | phpads | Query | 22 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='12'
|
| 206716 | root | localhost | phpads | Query | 21 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='14'
|
| 206715 | root | localhost | phpads | Query | 21 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='14'
|
| 206798 | root | localhost | phpads | Query | 20 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='12'
|
| 206808 | root | localhost | phpads | Query | 19 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='14'
|
| 206820 | amdmb | localhost | Amdmb | Quit | 24 | |
|
| 206831 | amdmb | localhost | Amdmb | Sleep | 4 | |
|
| 206837 | root | localhost | phpads | Init DB | 17 | cleaning up |
|
| 206838 | root | localhost | | Connect | | login |
|
| 206840 | root | localhost | phpads | Query | 11 | cleaning up |
SELECT * FROM phpads_zone
s WHERE zoneid='1' OR zonename='1'
|
| 206846 | root | localhost | | Init DB | 11 | |
|
| 206847 | root | localhost | phpads | Query | 15 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206845 | root | localhost | phpads | Query | 14 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206851 | root | localhost | | Connect | | login |
|
| 206862 | root | localhost | phpads | Query | 5 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206867 | root | localhost | phpads | Query | 14 | |
|
| 206870 | root | localhost | phpads | Query | 14 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206865 | root | localhost | phpads | Query | 5 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206860 | root | localhost | phpads | Query | 14 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206859 | root | localhost | phpads | Query | 14 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206854 | root | localhost | phpads | Query | 5 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206853 | root | localhost | phpads | Query | 14 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206852 | root | localhost | | Init DB | 16 | |
|
| 206844 | root | localhost | phpads | Sleep | 4 | |
|
| 206841 | root | localhost | phpads | Query | 14 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206835 | root | localhost | phpads | Query | 14 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206834 | root | localhost | phpads | Query | 11 | cleaning up |
SELECT * FROM phpads_zone
s WHERE zoneid='1' OR zonename='1'
|
| 206881 | root | localhost | phpads | Init DB | 14 | cleaning up |
|
| 206888 | root | localhost | | Connect | | login |
|
| 206887 | root | localhost | phpads | Query | 6 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206885 | root | localhost | phpads | Query | 5 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206884 | root | localhost | phpads | Query | 6 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206882 | root | localhost | | Init DB | 11 | |
|
| 206891 | amdmb | localhost | forum | Query | 13 | |
|
| 206890 | root | localhost | phpads | Query | 5 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206894 | root | localhost | phpads | Query | 6 | |
|
| 206893 | root | localhost | phpads | Sleep | 6 | |
|
| 206880 | root | localhost | phpads | Sleep | 6 | |
|
| 206879 | root | localhost | phpads | Quit | 13 | |
|
| 206876 | root | localhost | phpads | Query | 13 | |
|
| 206875 | root | localhost | | Init DB | 13 | |
|
| 206929 | root | localhost | phpads | Query | 3 | |
|
| 206930 | root | localhost | | Connect | | login |
|
| 206928 | amdmb | localhost | | Connect | | login |
|
| 206931 | root | localhost | | Connect | | login |
|
| 206932 | root | localhost | | Connect | | login |
|
| 206927 | root | localhost | | Init DB | 3 | |
|
| 206926 | amdmb | localhost | | Connect | | login |
|
| 206923 | amdmb | localhost | Amdmb | Query | 3 | Sorting result |
SELECT News.NewsID, News.
Title, News.Date, News.Author, News.Source, News.Link, News.Information, Ne
|
| 206922 | root | localhost | phpads | Query | 5 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206921 | root | localhost | phpads | Query | 3 | cleaning up |
UPDATE phpads_banners SET
seq=seq-1 WHERE bannerID='12'
|
| 206920 | amdmb | localhost | Amdmb | Query | 4 | Sorting result |
SELECT News.NewsID, News.
Title, News.Date, News.Author, News.Source, News.Link, News.Information, Ne
|
| 206918 | amdmb | localhost | Amdmb | Query | 4 | Sorting result |
SELECT News.NewsID, News.
Title, News.Date, News.Author, News.Source, News.Link, News.Information, Ne
|
| 206915 | root | localhost | phpads | Sleep | 4 | |
|
| 206912 | root | localhost | | Connect | | login |
|
| 206911 | root | localhost | | Connect | | login |
|
| 206906 | root | localhost | phpads | Query | 3 | Writing to net |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206905 | root | localhost | phpads | Query | 5 | cleaning up |
SELECT
phpads_banners.bannerID as bannerID,
phpads_banners.banner as banner,
php |
| 206900 | amdmb | localhost | Amdmb | Sleep | 3 | |
|
| 206899 | amdmb | localhost | Amdmb | Sleep | 4 | |
|
| 206898 | amdmb | localhost | Amdmb | Sleep | 4 | |
|
| 206939 | root | localhost | | Query | 3 | |
show processlist
|
+--------+-------+-----------+--------+---------+------+----------------+---
-----------------------
----------------------------------------------------------------------------
+
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
