EmmanuelD I got >1 000 000 entries in the posts table, the issue is that on the production server, the posts table break (I need to repair it almost every hour) Any ideas on how to avoid that ? (Mysql param or other?) I use nginx as web server
luceos EmmanuelD I'm not sure, I know Flarum runs the posts table under MyISAM which can result in table locking issues. You might try making a backup and changing the table type to InnoDB as a test. Otherwise we might need more information what is causing the broken tables. And maybe @Franz has an idea where to look otherwise.
EmmanuelD Davis broken means "corrupted" I need to repair it in order to be able to read the data again
EmmanuelD Yes I already have backups, right now I have an issue with the posts.MYI that I cannot repair with myisamchk -r or -f
Franz Hmm, I haven't ever encountered such issues, but I've never run such a large forum either. @EmmanuelD Did you import the data from another forum? Have the database logs told you anything about which operation broke the table?
EmmanuelD In order to set "posts" as an InnoDB table you have to use MySQL 5.6 (FULLTEXT with InnoDB is only ok with MySQL 5.6). For the moment it seems to work, i will keep you updated in a day or 2
EmmanuelD luceos no I've migrated from 5.5 to 5.6 (not without broking nginx unfortunatly) but now that everything is fixed it seems to work fine (the db is > 1,5Go)
EmmanuelD by the way @luceos i really need to implement slug for discussion and get private message, do you know if those feature are scheduled in a near future ?
luceos EmmanuelD A custom slug and private messages will probably come eventually. I'm not sure what our core devs have planned, but even if they don't implement these, you can be sure an Extension developer will. It's just a matter of patience in that sense.
