MyBB Community Forums

I have a forum with 100K posts with 300-1000 users online (200K pageviews per day).
The problem is:
- Browsing is OK
- Create new thread, Move, Delete,.... takes around 6-10 seconds. This is my only problem

How to make it fast?

First I used myisam, and someone recommended me to change to innodb.
Now I use innodb but still same problem.

Uptime: 51496  Threads: 2  Questions: 8035942  Slow queries: 1428  Opens: 378  Flush tables: 1  Open tables: 366  Queries per second avg: 156.49

Server specs:
Intel Core2due 2.2Ghz
Ram 3GB

---

no one?

option one - check for disappeared indexes
1. compare database structure with installation template
( you can find the template in install/resources/mysql_db_tables.php )
2. recover missed indexes

if all indexes are in place, then

option two - optimise by new indexes
1.enable log-slow-queries in my.cnf
2.then see, which queries are slow. try to identify, where new indexes can help

Can we have your admin stats details? (By the footer and can be enabled in Servers & Optimization settings).

It may be the case if you have lots of resource using plugins installed.

300-1000 users at a time ? i have big board too where 600-700 users at a time coming and reading threads and 4-5 users are posting Video links there from youtube , dailymotion it have server Core2Quad with 8 GB DDR2 Ram sometimes got slow but not all the time. So i think u need some Upgrade in your Server Specs.

sorry this is from light weight period as for now

Generated in 0.0503352 seconds (72.00% PHP / 28.00% MySQL)
SQL Queries: 12 / Global Parsing Time: 0.0144851 / Memory Usage: 2.75 MB
PHP version: 5.3.3 / Server Load: 2.66 / GZip Compression: Enabled


Generated in 0.0866630 seconds (52.55% PHP / 47.45% MySQL)
SQL Queries: 9 / Global Parsing Time: 0.0401590 / Memory Usage: 2.75 MB
PHP version: 5.3.3 / Server Load: 2.92 / GZip Compression: Enabled