| | We're noticing significant performance differences in FluxBB 1.4.X vs. the 1.2.X series. I'm going to attach a few things that come to mind, and I'd be glad to chip in more, but here we go. | | We're noticing significant performance differences in FluxBB 1.4.X vs. the 1.2.X series. I'm going to attach a few things that come to mind, and I'd be glad to chip in more, but here we go. |
| | | | |
| | + | [quote] |
| | $ mysqladmin status | | $ mysqladmin status |
| | Uptime: 309733 Threads: 1 Questions: 31691959 Slow queries: 1110 Opens: 1146 Flush tables: 1 Open tables: 291 Queries per second avg: 102.320 | | Uptime: 309733 Threads: 1 Questions: 31691959 Slow queries: 1110 Opens: 1146 Flush tables: 1 Open tables: 291 Queries per second avg: 102.320 |
| | $ mysqld --version | | $ mysqld --version |
| | mysqld Ver 5.1.47-log for unknown-linux-gnu on x86_64 (Source distribution) | | mysqld Ver 5.1.47-log for unknown-linux-gnu on x86_64 (Source distribution) |
| | $ uname -a | | $ uname -a |
| | Linux gudrun 2.6.34-ARCH #1 SMP PREEMPT Mon Jul 5 22:12:11 CEST 2010 x86_64 Intel(R) Xeon(TM) CPU 2.80GHz GenuineIntel GNU/Linux | | Linux gudrun 2.6.34-ARCH #1 SMP PREEMPT Mon Jul 5 22:12:11 CEST 2010 x86_64 Intel(R) Xeon(TM) CPU 2.80GHz GenuineIntel GNU/Linux |
| | + | [/quote] |
| | | | |
| | All FluxBB tables are InnoDB. | | All FluxBB tables are InnoDB. |
| | | | |
| | + | [quote] |
| | mysql> SELECT TABLE_SCHEMA, count(*) TABLES, concat(round(sum(table_rows)/1000000,2),'M') rows, concat(round(sum(data_length)/(1024*1024*1024),2),'G') DATA, concat(round(sum(index_length)/(1024*1024*1024),2),'G') idx, concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'G') total_size, round(sum(index_length)/sum(data_length),2) idxfrac FROM information_schema.TABLES WHERE table_schema = 'fluxbb' GROUP BY TABLE_SCHEMA; | | mysql> SELECT TABLE_SCHEMA, count(*) TABLES, concat(round(sum(table_rows)/1000000,2),'M') rows, concat(round(sum(data_length)/(1024*1024*1024),2),'G') DATA, concat(round(sum(index_length)/(1024*1024*1024),2),'G') idx, concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'G') total_size, round(sum(index_length)/sum(data_length),2) idxfrac FROM information_schema.TABLES WHERE table_schema = 'fluxbb' GROUP BY TABLE_SCHEMA; |
| | +--------------+--------+--------+-------+-------+------------+---------+ | | +--------------+--------+--------+-------+-------+------------+---------+ |
| | | TABLE_SCHEMA | TABLES | rows | DATA | idx | total_size | idxfrac | | | | TABLE_SCHEMA | TABLES | rows | DATA | idx | total_size | idxfrac | |
| | +--------------+--------+--------+-------+-------+------------+---------+ | | +--------------+--------+--------+-------+-------+------------+---------+ |
| | | fluxbb | 17 | 23.14M | 1.34G | 0.91G | 2.26G | 0.68 | | | | fluxbb | 17 | 23.14M | 1.34G | 0.91G | 2.26G | 0.68 | |
| | +--------------+--------+--------+-------+-------+------------+---------+ | | +--------------+--------+--------+-------+-------+------------+---------+ |
| | 1 row in set (0.84 sec) | | 1 row in set (0.84 sec) |
| | + | [/quote] |
