منتدى استراحات زايد

منتدى استراحات زايد (http://vb.ma7room.com/index.php)
-   منتدى أخبار المواقع والمنتديات العربية والأجنبية (http://vb.ma7room.com/forumdisplay.php?f=183)
-   -   CMS extremely slow site - connection time outs (http://vb.ma7room.com/showthread.php?t=1021092)

محروم.كوم 09-24-2012 10:10 PM

CMS extremely slow site - connection time outs
 
Hello.
For the last few days my site has been running extremely slow (CMS running a lot slower than it's usual "sluggish" and even the forum pages have been slow to react.
After lots of communicating with my host Ipage, they first stated it was browsers or ISP issues (even though i told them this was being reported by multiple users on different platforms in different countries!!)
now they have finally said it is because the 75000 mysql querie limit per user per hour is being tripped.
I cannot get my head around the fact my little site with 150 users, only 10 of which are probably on at any one time posting one or two articles per day and no more than 40 forum posts per day can overload the system???

I'm not an expert on this so wonder if someone could tell me in better words what they mean and how I can restore some speed and reliability to my site.
Their reply was
Quote:
We apologize for any inconvenience this has caused you. The Reason you are receiving this error is due to the ‘max_questions’ setting which is set to 75,000 per user per hour. This setting is there to ensure that the MySQL database cannot be overloaded with to many query requests. The queries will reset every hour and is kept by user however every time the pages on your site are accessed you are still attempting to make queries to the database server. Because of this even though you are getting errors your script are still accumulating the queries. As a temporary fix for this issue you can delete and recreate your user however this error will still come back if you do not condense the amount of queries your script uses by optimizing your SQL usage. Below is a link that should help show you how to optimize your MySQL usage:
http://www.sitepoint.com/article/opt...ql-application

We apologize for any inconvenience; however, on a shared hosting platform, there are practical limits to the amount of resources we can dedicate to individual customers. If this becomes an issue for you, you may be able to reduce the number of queries you are running by using application-level caching, combining queries or taking advantage of nested queries wherever you can.

To ensure optimum MySQL performance for all our customers, we are limiting the number of queries per login to 75,000 per hour and the duration of individual queries to 60 seconds. Be sure to closely monitor your applications -- don't let them get spammed or abused! These tips will help keep you protected, as well as keep our MySQL servers running at peak performance:
* Check your bulletin boards, forums, blogs, etc.,for spammers. Fake posts and comments compromise the integrity of your site and slow down database performance.

* Turn off Guest or Anonymous posting to these applications.

* Require registration, and registration confirmation. Spammers can use programs to automatically sign up accounts on your site and start posting bad content; requiring registration confirmation can reduce this risk.

* Keep your code up to date. New releases of applications often include built-in spam protection and can greatly reduce the number of queries and amount of bandwidth you use.

* Turn off unused applications. Just because you don't link to an application anymore doesn't mean it's not getting traffic.

I've since turned off "free view" which I had so people could use the facebook "like" option. I understand this means my users now need to log in.
Hope someone can offer some good advice (although i dare say some will just say change host!! :))


الساعة الآن 10:14 PM

Powered by vBulletin® Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By Almuhajir


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 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 190 191 192 193 194 195 196 197 198 199 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 226 227