SMF 2.0.18 has been released! Please update. Read more.
Started by [Unknown], September 20, 2005, 04:31:53 PM
Quote from: qtime on February 09, 2007, 04:52:17 PMWhat will happen if I replaced the table with an empty one from a fresh install?
Quote from: Triangle on May 19, 2006, 02:05:08 PMI just changed these to Innodb:log_search_messageslog_search_resultslog_search_subjectslog_search_topicslog_search_wordslog_search_words at 475MB took 2 hours! Anyway, all those tables still show as MYISAM even though the query claimed to be successful. I changed flood_control to HEAP and it shows up correctly.Now what??
[mysqld]skip-lockingskip-innodbquery_cache_limit=1Mquery_cache_size=32Mquery_cache_type=1max_connections=500interactive_timeout=100wait_timeout=100connect_timeout=10thread_cache_size=128key_buffer=16Mjoin_buffer=1Mmax_allowed_packet=16Mtable_cache=1024record_buffer=1Msort_buffer_size=2Mread_buffer_size=2Mmax_connect_errors=10# Try number of CPU's*2 for thread_concurrencythread_concurrency=4myisam_sort_buffer_size=64Mlog-binserver-id=1[safe_mysqld]err-log=/var/log/mysqld.logopen_files_limit=8192[mysqldump]quickmax_allowed_packet=16M[mysql]no-auto-rehash#safe-updates[isamchk]key_buffer=64Msort_buffer=64Mread_buffer=16Mwrite_buffer=16M[myisamchk]key_buffer=64Msort_buffer=64Mread_buffer=16Mwrite_buffer=16M[mysqlhotcopy]interactive-timeout
Quote from: groundup on February 08, 2007, 11:36:28 PMWhy do you want to prune a table?
Quote from: heavyccasey on September 01, 2007, 01:26:44 AMIt's supposedly really slow and unnecessary for small forums.
Quote from: SleePy on September 02, 2007, 12:47:27 AMDid you read some of the stickies at the top of the board?I believe some of them explain about InnoDB.
Quote from: SleePy on September 02, 2007, 12:47:27 AMHow large is your forum?
Quote from: SleePy on September 02, 2007, 12:47:27 AMHow many on-line in a time period?
Quote from: tmdg link=topic=quote author=tmdg link=topic=50217.msg1224445#msg1224445 date=1188663586]Quote from: heavyccasey on September 01, 2007, 01:26:44 AMIt's supposedly really slow and unnecessary for small forums.But how big is a small forum. I'm new to administering smf and investigating what can be done to improve performance. I've not seen any guide lines (Havn't been looking long though.) as to what size things have to et to before they teh forum is deemed to be large enough to gain advantage from using InnoDB.t.Tom.