forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: dogwalks on June 05, 2012, 04:47:38 am
-
Hi
First post in this forum, my name is Rob, pleased to meet you all.
This is quite an urgent problem for me, it's a money making website and the gallery is very important. Here's what hostgator said when they took CPG down...
The issue is what appears to be a common query in the software is examining 55k rows of data every time it's ran which is almost the entire table:
dogwalks_joom
cpg14x_jos_pictures 58536 <----- total rows in the table:
| 1 | SIMPLE | cpg14x_jos_pictures | range | aid_approved,pic_aid | aid_approved | 5 | NULL | 55310 <----- rows examined on the below query| Using where; Using filesort |
mysql> explain SELECT * FROM cpg14x_jos_pictures WHERE approved = 'YES' AND aid IN
What follows that is a very long list of numbers.
Hostgator then suggest:
As a start I would be sure the software is running the latest version and if possible purge any non-used rows of data from the table cpg14x_jos_pictures
..........
This gallery is rather big, it's 5.12 GB, 13 folders with over 160,000 files. I am reasonably comfortable updating from the current version 1.4 .25 to 1.5.2 but wouldn't know how to purge any non-used rows of data from the table. Also, a couple of months ago I moved the site from a Joomla platform to WordPress, but didn't tidy up my SQL databases (didn't know how). So I was wondering whether dogwalks_joom cpg14x_jos_pictures should be running at all anyway?
Can anybody help me with this or I am quite happy to pay somebody to fix this gallery up and optimise it so it runs as smoothly as possible. Obviously I can't link to the website gallery, it's down. Hostgator have given me IP privileges to log in, but if any of you are happy to accept the job to fix it, I'll get the IP changed to yours.
Many thanks
Rob
-
mysql> explain SELECT * FROM cpg14x_jos_pictures WHERE approved = 'YES' AND aid IN
What follows that is a very long list of numbers.
Please post the complete query (you can left out everything inside the brackets after AND aid IN), as it probably tells us what's going wrong. I guess it's the lastup meta album, but that's just an assumption without to know how your gallery looks like. Please post a link to your gallery, at least Google should have your gallery in the cache.
wouldn't know how to purge any non-used rows of data from the table [..] I was wondering whether dogwalks_joom cpg14x_jos_pictures should be running at all anyway?
That table is mandatory, there's nothing to purge.
-
Hi Andre
Thanks for getting back to me.
This is the link to the Gallery...
http://www.dogwalks.com.au/cpg/index.php
Google's cached pages link seems to have disappeared for me, hopefully you know where it is.
Here is the full query that hostgator sent me...
Coppermine Photo Gallery
The issue is what appears to be a common query in the software is examining 55k rows of data every time it's ran which is almost the entire table:
dogwalks_joom
cpg14x_jos_pictures 58536 <----- total rows in the table:
| 1 | SIMPLE | cpg14x_jos_pictures | range | aid_approved,pic_aid | aid_approved | 5 | NULL | 55310 <----- rows examined on the below query| Using where; Using filesort |
mysql> explain SELECT * FROM cpg14x_jos_pictures WHERE approved = 'YES' AND aid IN
-> (16,15,14,30,29,28,17,18,19,20,21,22,23,24,25,32,33,35,36,37,38,39,40,41,42,43,45,46,47,48,49,50,54,52,53,55,56,57,58,60,61,62,64,65,66,67,68,70,74,75,76,77,78,79,80,81,82,84,85,86,88,89,91,92,93,94,95,96,97,98,100,101,102,103,106,107,108,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,191,194,195,197,198,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,246,228,245,359,232,233,234,235,236,237,238,239,240,241,242,243,244,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,298,299,300,301,302,303,304,305,306,30! 8,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,355,356,357,358,360,361,362,364,365,366,367,368,369,371,372,373,374,375,376,377,378,380,381,382,383,384,385,386,387,388,389,390,395,392,393,397,398,399,400,401,402,403,404,405,406,407,408,443,411,412,413,414,415,416,417,419,420,421,422,423,424,425,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,444,445,446,447,448,449,450,453,452,456,457,458,460,461,462,463,464,465,466,467,469,470,471,472,473,474,475,476,477,478,480,481,482,483,484,485,486,487,488,490,491,492,493,494,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,
-> 535,536,537,538,539,540,541,542,543,544,546,547,549,550,551,552,553,555,556,557,558,559,562,563,565,566,567,568,574,569,570,571,572,575,576,577,580,581,582,583,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,602,603,604,605,607,608,609,610,611,612,616,617,618,619,620,621,622,623,629,625,627,630,631,632,633,634,635,636,637,638,639,640,641,643,644,645,646,647,648,650,651,652,653,654,655,657,658,659,671,661,662,665,666,667,668,672,673,674,675,676,677,679,680,681,682,698,684,685,686,687,688,690,691,693,695,696,697,699,700,702,703,704,705,706,707,708,709,710,712,713,715,716,717,718,719,722,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,748,749,750,751,752,753,754,755,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,779,780,781,782,784,785,786,800,788,789,790,791,792,793,795,796,797,798,799,802,803,804,805,806,807,808,809,810,811,812,813,814,818,819,820,821,822,823,824,827,8! 28,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,855,856,857,860,861,862,863,864,865,866,867,868,869,870,871,872,874,875,876,877,878,879,880,882,883,884,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,903,904,905,906,907,908,909,910,911,912,913,914,915,937,917,941,919,920,921,922,923,924,925,926,927,929,930,931,932,938,934,939,940,942,943,944,945,946,947,948,949,950,951,953,954,955,956,957,958,959,960,963,964,965,966,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,991,992,993,994,995,996,998,999,1000,1001,1004,1005,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1020,1023,1024,1025,1026,1027,1028,1030,1031,1032,1033,1034,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1076,1067,1068,1069,1070,1071,1072,1073,1074,1075,1077,1078,1079,1080,1081,1082,1083,1085,1087,1088,1089,! 1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,11! 05,1106, 1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1124,1125,1127,1128,1130,1131,1133,1134,1135,1136,1137,1138,1139,1140,1141,1143,1144,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1159,1160,1161,1162,1165,1166,1168,1170,1171,1172,1173,1174,1175,1176,1177,1178,1180,1181,1182,1184,1188,1189,1190,1191,1192,1193,1194,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1207,1208,1209,1210,1211,1212,1213,1214,1215,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1234,1235,1237,1238,1239,1240,1241) ORDER BY pid DESC LIMIT 35703
-> ;
+----+-------------+---------------------+-------+----------------------+--------------+---------+------+-------+-----------------------------+
Thanks
Rob
-
I found your cached gallery here (http://webcache.googleusercontent.com/search?q=cache:JQPVe08z13UJ:www.dogwalks.com.au/cpg/index.php+&cd=1&hl=de&ct=clnk&gl=de&client=firefox-a). On your index page I can see the random and the lastup meta album.
Unfortunately I wasn't able to find such a query in my gallery with the same gallery settings on the quick. Please enable debug mode and search for that query in the debug output (searching for ORDER BY pid should be enough). You'll find something like
[include\functions.inc.php:1908]
which will help us to find the source.
-
Not sure if I'm doing this right, but I enabled debug mode and then copied the information into notepad, but is search found nothing similar to ORDER BY pid, so I hope it's okay to post everything ...
USER:
------------------
Array
(
[ID] => a780edcf2085e5b7908d301d17f0d485
[am] => 1
[lang] => english_gb
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_name] => karenkiernan
[groups] => Array
(
)
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 1
[ufc_max] => 3
[ufc_min] => 3
[custom_user_upload] => 0
[num_file_upload] => 5
[num_URI_upload] => 3
[can_post_comments] => 1
[can_upload_pictures] => 1
[can_create_albums] => 1
[has_admin_access] => 1
[pub_upl_need_approval] => 0
[priv_upl_need_approval] => 0
[group_name] => Administrators
[upload_form_config] => 3
[group_quota] => 0
[can_see_all_albums] => 1
[group_id] => 1
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content, player FROM cpg14x_jos_filetypes; (0s)
[1] => select * from cpg14x_jos_plugins order by priority asc; (0s)
[2] => delete from `dogwalks_joom`.cpg14x_jos_sessions where time<1338885984 and remember=0; (0.001s)
[3] => delete from `dogwalks_joom`.cpg14x_jos_sessions where time<1337679984; (0s)
[4] => select user_id from `dogwalks_joom`.cpg14x_jos_sessions where session_id = '3d3a50fba213f6e7ae23b2095ed501b0' (0s)
[5] => select user_id as id, user_password as password from `dogwalks_joom`.cpg14x_jos_users where user_id=1 (0s)
[6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `dogwalks_joom`.cpg14x_jos_users AS u INNER JOIN `dogwalks_joom`.cpg14x_jos_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
[7] => SELECT user_group_list FROM `dogwalks_joom`.cpg14x_jos_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
[8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as priv_upl_need_approval FROM cpg14x_jos_usergroups WHERE group_id in (1) (0s)
[9] => SELECT group_name FROM cpg14x_jos_usergroups WHERE group_id= 1 (0s)
[10] => update `dogwalks_joom`.cpg14x_jos_sessions set time='1338889584' where session_id = '3d3a50fba213f6e7ae23b2095ed501b0' (0s)
[11] => SELECT user_favpics FROM cpg14x_jos_favpics WHERE user_id = 1 (0s)
[12] => DELETE FROM cpg14x_jos_banned WHERE expiry < '2012-06-05 04:46:24' (0s)
[13] => SELECT * FROM cpg14x_jos_banned WHERE (ip_addr='60.241.109.151' OR ip_addr='60.241.109.151' OR user_id=1) AND brute_force=0 (0s)
[14] => SELECT COUNT(*) FROM cpg14x_jos_pictures WHERE approved = 'NO' (0s)
[15] => SELECT value FROM cpg14x_jos_config WHERE name = 'theme' (0s)
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 5.2.17 - OK
------------------
mySQL version: 5.5.23-55
------------------
Coppermine version: 1.4.25(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:
==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 5.5.23
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib64 -lmysqlclient
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | dl | dl
file_uploads | On | On
include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 64M | 64M
post_max_size | 64M | 64M
==========================
Page generated in 0.149 seconds - 16 queries in 0.001 seconds - Album set : ; Meta set: ;
-
I assume that's not the debug output from the index page, right?
if any of you are happy to accept the job to fix it, I'll get the IP changed to yours.
That seems to be easier. If you want, I'll send you my current IP address via PM.
-
You're right, it wasn't. I've just redone it from the index page and this is what it says next to order by pid...
[139] => SELECT * FROM cpg14x_jos_pictures WHERE approved = 'YES' ORDER BY pid DESC LIMIT 0 ,8 (0s)
But I think you are right, probably best if you PM me your IP address and I'll get hostgator to switch over access to you.
Thanks Andre
Rob
-
PM sent.
-
I have passed your IP over to hostgator, as soon as they grant you access I will email you.
Thanks!
-
That was quick, Hostgator have granted access. I have sent you an email.
Thanks!
-
Okay it seems that cpg1.4.x behaves different than cpg1.5.x regarding the debug output. However, I changed your default gallery layout in the config ("The content of the main page") from
breadcrumb/catlist/alblist/random,2/lastup,2
to
breadcrumb/catlist/alblist
Now the query Hostgator gave you isn't executed on every page load, though the Coppermine debug output told me that this query wasn't the culprit. I think it's save to put your page back online for now. Regarding the limit issue, I suggest to update to cpg1.5.x as there's no support for cpg1.4.x anymore. Maybe that issue is already fixed there, I don't know.
-
Erm, I just recognized that the query I just eliminated differs from that one Hostgator told you. My query had a correct limit value of
ORDER BY pid DESC LIMIT 0 ,8
the other one has something like
ORDER BY pid DESC LIMIT 35703
I'll search for it now.
-
I wasn't able to find a query which has such a high limit (selecting ~35k files). It has to be related with the lastup meta album, as the query looks very similar.
In include/functions.inc.php you'll find
$query = "SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES' $META_ALBUM_SET ORDER BY pid DESC $limit";
$limit is set some lines above within the same function:
$limit = ($limit1 != -1) ? ' LIMIT '. $limit1 : '';
$limit .= ($limit2 != -1) ? ' ,'. $limit2 : '';
$limit2 seems to be -1, that's the only way such a limit value is generated for queries. But, I searched through the code and it seems to be impossible to generate a big value for $limit1 and silmutaneously -1 for $limit2.
Maybe Hostgator can find out a corresponding URL for that query?
-
You've lost me a bit Andre, but I assume you haven't been able to repeat the problem experienced by hostgator where a 'query in the software is examining 55k rows of data every time it's ran'? Or repeat the error code 35703?
So I will go back to hostgator and invite them to take a look at what you have just said and see what happens from there.
I'll come back to you.
Thanks.
-
Here's Hostgator's reply...
Unfortuntely I wasn't able to locate a URL which could reproduce this result, however, it's very clear from our logs that this query is occurring very frequently on your site.
I did notice, however, that some of the code may be different between the two sites. You appear to be running an older version of Coppermine, 1.4.25. It's possible that this particular issue was fixed between then and the latest version.
------
Not sure what he meant by "between the two sites", unless he thinks you are trying to replicate the query on a more updated site? Do you have any idea, maybe the comment makes more sense to you?
-
Doesn't makes sense to me, sorry. As I said I disabled 2 meta album blocks in your gallery. I'd like to know if this already fixed the issue. Of course (as I wasn't successful to reproduce the issue) Hostgator has to re-enable your gallery, at least temporary if it's not fixed yet.
-
Okay, I've asked them to test to see if the fault has gone, I'll get back to you when I get an answer. It might be a while though, it's 1:20 in the morning here, so it depends how long Hostgator take to run the test.
Thanks.
-
Okay, so Hostgator set the gallery to live again about 16 hours ago and I emailed them to see how it was going. Here's what they said:
In the time frame I was watching the server I did not observe any issues with the load of your script.
So, they are not exactly saying it's fixed, but it appears to be. Thanks Andre for all your help.
Going forward, I suspect I should upgrade to the latest version 1.5 .20. Is it wise to do that directly from my version which is 1.4 .25? I see quite a few problems in the forums from people who have attempted that in the past.
Thanks
-
Most issues during upgrade occur because of people doesn't read & follow the upgrade docs (http://documentation.coppermine-gallery.net/en/upgrading.htm#upgrade) carefully/completely and/or use themes that are not compatible with cpg1.5.x after the upgrade.
It's advisable to test the upgrade procedure on a (local) copy of your website.
-
Incredible! I've just discovered that actually, Hostgator didn't lift restrictions as they said they had, I've had three people contact me to say they can't access the page. The only people who have been accessing the gallery for the last 18 hours are me and you Andre. So it's not surprising they haven't seen any high resource usage, is it? They have now set it live, properly, so I'll need to wait until tomorrow to see if it is fixed.
My only concern with the upgrade is my theme, which is called siteground9. if it doesn't work, can I just select a new theme after upgrading or will the installation become unstable?
-
You can just select/download a new theme if it's not compatible. You have to know that there are two "compatibility levels". The first one is the optical compatibility (CSS classes, etc.), but the technical compatibility is more important. The more your theme.php file contains, the more likely it is that something won't work after the upgrade. But your theme looks like there are not much changes in the theme.php file.
-
Incredible! I've just discovered that actually, Hostgator didn't lift restrictions as they said they had, I've had three people contact me to say they can't access the page.
The page was working just a few moments ago. I suggest using a third party to take a look for you when it appears to be down.
Try:
network-tools.com + downforeveryoneorjustme.com
(there are many others to use also)
-
If it's any help - it loads for me in the UK.
-
Thanks for your help guys, the gallery went live properly about an hour after I posted on here last. I sent a sharp email to Hostgator support. CPU usage now seems to be under control (thanks Andre) so now time to upgrade.
I'm going in...
-
Hello I just write in this topic cause I have the same problems with Hostgator. I remove all unactive plugins and themes. I disable a photo details, automatic language. I also disable uses uploads and registration and block some IPs. There aren't any changes. A lot of problems and downtime. I also make upgrade of CMS and now I am with lates version of Coppermine Gallery. I've got about 5000 visits per day and I don't think that it's too high to move on dedicated server how the HostGator's support advice me.
Here the support latest email:
Quote
Hello,
This message is to advise you of a temporary block placed on your account. This account was found to be consuming an inordinate amount of processor time, to the point of degrading overall system performance. While we do limit each account to no more than 25% of a system's CPU in our terms of service, we do not actively disable accounts until they greatly exceed that number, which is what happened in this case.
Requests to this scripts under this account may become degraded by limiting the abilty for scripts to run for a limited amount of time, or if the issue persists, we may be forced to restrict how fast processes can be spawned until the issue has been resolved.
We recommend taking steps to reduce the overall CPU usage for the account, which may be as simple as generating a flat HTML page for popular content, or enabling caching that is available through many popular scripts, or disabling high CPU usage features such as searches or Ajax refreshes. Although we may not be able to help in all cases, we would be more than happy to assist if you are unable to determine any cause, or if you need help interpreting any of the information.
CPU seconds used in the past hour: 3125.92999999977, 87% CPU
Fri Aug 9 15:01:06 CDT 2013
Running Processes:
Running Queries:
Open connections
Current Site Requests:
106.66.117.178 tuningcars.us /albums/userpics/10001/accent-lc-tuning_281229.jpg
119.235.237.17 tuningcars.us /displayimage.php?album=351&pid=11105
157.55.33.50 tuningcars.us /albums/userpics/10001/bmw-3-tuning-e36_285229.jpg
176.8.29.136 tuningcars.us /albums/userpics/10001/audi-tt-8n-tuning_288729.jpg
178.238.209.5 tuningcars.us /albums/userpics/10001/VW_Polo_6N2_Tuning_284529.jpg
178.36.143.203 tuningcars.us /albums/userpics/10001/honda-civic-6-generation-hatchback-t
178.36.143.203 tuningcars.us /albums/userpics/10001/honda-civic-6-generation-hatchback-t
178.36.143.203 tuningcars.us /albums/userpics/10001/honda-civic-6-generation-hatchback-t
178.36.143.203 tuningcars.us /albums/userpics/10001/honda-civic-6-generation-hatchback-t
186.37.108.6 tuningcars.us /albums/userpics/10001/Honda_Civic_EK_JDM_Tuning.jpg
187.174.157.178 tuningcars.us /albums/userpics/10001/Seat_Ibiza_MK2_Tuning_281229.jpg
187.195.55.133 tuningcars.us /albums/userpics/10001/golf-5-tuning_281429.jpg
189.203.219.21 tuningcars.us /albums/userpics/10001/thumb_golf_2_customs_284229.jpg
189.203.219.21 tuningcars.us /albums/userpics/10001/thumb_golf_2_customs_284329.jpg
189.203.219.21 tuningcars.us /albums/userpics/10001/thumb_golf_2_customs_284429.jpg
189.203.219.21 tuningcars.us /albums/userpics/10001/thumb_golf_2_customs_284629.jpg
189.203.219.21 tuningcars.us /albums/userpics/10001/thumb_golf_2_customs_284729.jpg
189.203.219.21 tuningcars.us /albums/userpics/10001/thumb_golf_2_customs_284829.jpg
189.64.226.118 tuningcars.us //albums/userpics/10001/dodge-ram-3-tuning_282629.jpg
190.148.95.166 tuningcars.us /albums/userpics/10001/honda-civic-8th-generation-sedan-tun
198.228.201.154 tuningcars.us /albums/userpics/10001/subaru-impreza-wrx-sti-iii-tuning.jp
199.30.16.34 tuningcars.us /albums/userpics/10001/custom_golf_1_281729.jpg
199.30.20.83 tuningcars.us /albums/userpics/10001/renntech-c74-widebod-4_1600x0w.jpg
2.187.247.230 tuningcars.us /albums/userpics/10001/thumb_Bugatti_Veyron_Tuning_28329.jp
212.93.105.50 tuningcars.us /albums/userpics/10001/new-fiat-500-tuning_28129.jpg
217.112.161.56 tuningcars.us /albums/userpics/10001/mazda-mx5-miata-tuning_28429.jpg
31.80.154.222 tuningcars.us /albums/userpics/10001/mitsubishi-fto-tuning_28129.jpg
37.11.204.73 tuningcars.us /albums/userpics/10001/opel-corsa-c-tuning_2811829.jpg
37.113.12.211 tuningcars.us /db_input.php
37.113.12.211 tuningcars.us /displayimage.php?album=111&pid=42209
37.113.12.211 tuningcars.us /displayimage.php?album=111&pid=42311
47.64.241.197 tuningcars.us /albums/userpics/10001/79743258.jpg
65.111.77.138 tuningbikes.tuningcars.us /albums/userpics/10002/2000-suzuki-hayabusa-tuning_28329.jp
65.111.77.138 tuningbikes.tuningcars.us /albums/userpics/10002/2000-suzuki-hayabusa-tuning_28329.jp
65.55.215.69 tuningbikes.tuningcars.us /albums/userpics/10002/2003_suzuki_hayabusa-triple-wheels_2
65.55.215.69 tuningbikes.tuningcars.us /albums/userpics/10002/2003_suzuki_hayabusa-triple-wheels_2
65.55.215.69 tuningbikes.tuningcars.us /robots.txt
65.55.215.69 tuningbikes.tuningcars.us /robots.txt
65.55.215.69 tuningcars.us /albums/userpics/10001/seat-leon-mk1-tuning_2834829.jpg
65.55.215.69 tuningcars.us /robots.txt
66.249.73.20 tuningcars.us /displayimage.php?album=269&pid=9394
66.249.73.20 tuningcars.us /displayimage.php?pid=42882
66.249.73.6 tuningbikes.tuningcars.us /displayimage-1044.htmlalbums/userpics/10002/albums/userpic
66.249.73.6 tuningbikes.tuningcars.us /displayimage-1044.htmlalbums/userpics/10002/albums/userpic
66.249.73.88 tuningbikes.tuningcars.us /displayimage-31-211.htmlalbums/userpics/10002/albums/userp
66.249.73.88 tuningbikes.tuningcars.us /displayimage-31-211.htmlalbums/userpics/10002/albums/userp
66.249.73.88 tuningbikes.tuningcars.us /displayimage-46-466.htmlalbums/userpics/10002/albums/userp
66.249.73.88 tuningbikes.tuningcars.us /displayimage-46-466.htmlalbums/userpics/10002/albums/userp
66.249.81.137 tuningcars.us /albums/userpics/10001/normal_modified-honda-nsx-wallpaper_
66.249.81.137 tuningcars.us /captcha.php
70.199.131.55 tuningcars.us /albums/userpics/10001/honda-fit-tjin-editi_1600x0w.jpg
70.211.15.71 tuningcars.us /albums/userpics/10001/honda-civic-iv-4-tuning_28829.jpg
79.129.160.229 tuningcars.us /albums/userpics/10001/bmw-e36-tuning-picture_2826029.jpg
82.14.25.19 tuningcars.us /albums/userpics/10001/custom-nissan-370z_28129.jpg
83.173.130.6 tuningcars.us /albums/userpics/10001/toyota_mrs_tuning_288929.jpg
83.173.130.6 tuningcars.us /albums/userpics/10001/toyota_mrs_tuning_288929.jpg
84.115.39.121 tuningcars.us /albums/userpics/10001/Citroen_Xsara_1_Tuning.jpg
84.138.79.239 tuningcars.us /js/jquery-1.3.2.js
84.138.79.239 tuningcars.us /plugins/lightbox_notes_for_net/script.js
85.118.193.146 tuningcars.us /albums/userpics/10001/opel-astra-f-tuning_2837129.jpg
85.3.74.71 tuningcars.us /albums/userpics/10001/modified-honda-nsx-wallpaper_286429.
86.88.155.220 tuningcars.us /albums/userpics/10001/opel-tigra-tuning_2857029.jpg
88.158.199.90 tuningcars.us /albums/userpics/10001/thumb_Citroen_C5_Tuning.jpg
88.158.199.90 tuningcars.us /albums/userpics/10001/thumb_Citroen_Xantia_Tuning_28129.jp
88.158.199.90 tuningcars.us /albums/userpics/10001/thumb_Modified_Saxo.jpg
90.224.198.31 tuningcars.us /displayimage.php?pid=8891
91.138.28.65 tuningcars.us /albums/userpics/10001/vw-golf-3-tuning_281129.jpg
92.114.247.16 tuningcars.us /albums/userpics/10001/Passat_B4_Tuning_28629.jpg
93.181.160.120 tuningcars.us /albums/userpics/10001/Volkswagen-Golf2--176050.jpg
93.197.150.62 tuningcars.us /displayimage.php?album=599&pid=32946
95.108.244.253 tuningcars.us /displayimage.php?album=200&pid=67789
95.108.244.253 tuningcars.us /displayimage.php?pid=67891
Best regards,
Systems Monitoring Department
HostGator.com
I am ready to pay if someone. It's interesting that at December 2012 and Janury 2013 before Google's change of Image Search Browsing I have 60%-70% more traffic without any problems.
-
Hi terzo
5000 visits a day is too many for Hostgator on their shared server, I have another website that doesn't run Coppermine and it was at around that level that I had to move away from Hostgator, because my site was being disabled by them four or five times per month.
As it's a shared server, the terms and conditions say you must not exceed something like 25% of the total CPU on that server at any time, with around the same number of visitors a day that you are currently getting, I used to exceed that CPU level regularly, sometimes hitting 90%.
It hurts, moving to a better server, I now pay $100 a month for my hosting for just one website, I think it's definitely time for you to look at upgrading your server as well, I do not think this is a Coppermine issue.
Good luck.
-
For anyone in the UK I can heartily recommend Bytemark.co.uk and one of their VM setups. They kindly donate the hosting we use for this very site and we het far more than 5000 per hour. Some shared hosts are very tight with their limits which is good for their profits.
-
I have some addon sites into main account. I will move all of them to a diffrent acc. If the problems are continued I will looking for dedicated server. The earnings aren't so hight thats why i want to try all i have before i move do managed server.
@dogwalks
Was your problems with CPU Usage were solved after moving?
@Phill Luckhurst
I'm using USA hosts and probably i will chose server in to a HostGator. I just don't want to change IPs. Its strange that before a couple of mounth I had 50% more traffic than now and no problems, but it could be from something else... who knows.
Thank you for replies, guys. They were helpful for me.
-
Yes the problems were all solved when I moved to a new hosting, the site I am talking about is a WordPress site, I went with a company called Lightning Base (USA) who offer managed hosting with built in CDN, security and other features that make websites load faster. Not sure, but I think they only host WordPress websites though, so although I highly recommend them, I don't think you will be able to use them. Where ever you go, shop wisely though, one quote I got after supplying the host company with full details of my traffic was over $600 a month!
By the way, before I moved from Hostgator I did all sorts of tweaks, I removed plug-ins that were a bit heavy on the load, I compressed images, disabled some features, all sorts of stuff, just to try and stay with them but for my situation, it was the traffic that really caused the problems so until you move, I think you will continue to be shut down on a regular basis.