| Re: xoops.org hosting specs and statistics |
| by targbi on 2011/3/30 4:09:12 Hi, How much databases for mysql? Thank. |
| Re: xoops.org hosting specs and statistics |
| by wishcraft on 2011/3/16 12:19:13 YEAH Sounds like it was clogging the query cache on mysql. |
| Re: xoops.org hosting specs and statistics |
| by kerkyra on 2011/3/16 9:41:07 thanks guys. I think the problem was the plesk cron jobs (i.e webalizer) running every 30 minutes or so . right now it seems to be doing well (after deactivating it) the server load seems to be around 0.5 to 1 occasionally. So perhaps that was it. I'm monitoring right now to check. Thanks for the info again. :) |
| Re: xoops.org hosting specs and statistics |
| by trabis on 2011/3/15 20:56:47 You should check your mysql processes and see what queries are taking to long. If you are running xoops websites then turn debug on, go to the most visited module and check the queries times. Take the longest query and use EXPLAIN to see what indexes are being used. Adding indexes, caching or removing some features may improve your server performance greatly. Check if you are running out of memory, if memory usage is above 75% you should get some more. My server is running smoothly with 2 million pageviews/month with this specs: CPU - Intel Core 2 Quad Q9500 2.83 Ghz Memory - 4096 MB Drive 1 - 160 GB SATA (7.2k) Drive 2 - 250 GB SATA (7.2k) Uplink Speed - 10 mbit Operating System - CentOS 5 Control Panel - cPanel |
| Re: xoops.org hosting specs and statistics |
| by wishcraft on 2011/3/15 16:14:36 Could be your MySQL Service, sometime a slow mysql service or the number of questions going to the server will cause it to slow down due to the query cache. Try adjusting it by caching some modules. To Give you an idea tho, the google analytics are reporting the following for today: Visits: 33K Page views: 131K Pages per visit: 4 Avg. Time on Site: 4m Top Layer of countries today with this is: Visits 33,135 % of Site Total: 100.00% Pages/Visit 3.96 Site Avg: 3.96 (0.00%) Avg. Time on Site 00:03:31 Site Avg: 00:03:31 (0.00%) % New Visits 69.55% Site Avg: 68.44% (1.62%) Bounce Rate 56.66% Site Avg: 56.66% (0.00%) Detail Level: Country/Territory Visits Pages/Visit Avg. Time on Site % New Visits Bounce Rate 1. United States 5,385 4.64 00:03:38 67.63% 49.25% 2. Taiwan 3,323 3.97 00:03:32 67.11% 60.73% 3. China 1,502 2.38 00:02:05 79.43% 67.04% 4. France 1,354 3.60 00:02:25 68.61% 62.56% 5. Turkey 1,166 2.73 00:02:18 82.85% 69.13% 6. India 1,092 2.45 00:02:32 88.74% 69.60% 7. United Kingdom 1,090 4.31 00:03:08 68.35% 55.14% 8. Germany 1,064 4.25 00:03:02 63.91% 54.14% 9. Japan 1,054 4.55 00:03:10 65.37% 61.20% 10. Brazil 1,006 4.30 00:04:24 69.48% 52.68% |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|