| | 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. |
| | | | |
| - | $ mysqladmin status | + | [code]$ 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[/code] |
| - | $ mysqld --version | + | |
| - | mysqld Ver 5.1.47-log for unknown-linux-gnu on x86_64 (Source distribution) | + | [code]$ mysqld --version |
| - | $ uname -a | + | mysqld Ver 5.1.47-log for unknown-linux-gnu on x86_64 (Source distribution)[/code] |
| - | 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 | + | |
| | + | [code]$ 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[/code] |
| | | | |
| | All FluxBB tables are InnoDB. | | All FluxBB tables are InnoDB. |
| | | | |
| - | 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; | + | [code]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)[/code] |
