Database Maintenance
Hey you! Reader! Want to be a part of the GREATEST COMIC BOOK AND GEEK COMMUNITY on the web?! Well, they're not accepting new members, but we'll take anyone here, so why not sign up for a free acount? It's fast and it's easy, like your mom! Sign up today! Membership spots are limited!*
*Membership spots not really limited!
Hey you! Reader! Want to be a part of the GREATEST COMIC BOOK AND GEEK COMMUNITY on the web?! Well, they're not accepting new members, but we'll take anyone here, so why not sign up for a free acount? It's fast and it's easy, like your mom! Sign up today! Membership spots are limited!*
*Membership spots not really limited!
|
||
|
||
Trying to get something together that can run automatically at some late hour on a weekend each week to keep the tables running smoothly. This will be the first test run. |
||
|
||
|
||
Also getting the Thread does no exists when I click the go to last post icon in the threads list. |
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
In order to have search enabled, the board keeps an index on post subject, post text, and both together. This essentially duplicates the post table twice. Every time a post is made, both indexes must be updated. Means we're altering 2.5 million rows every time. I plan to replace search with a custom search engine. It will separate those indexes, reducing the posts table by 2/3, making posting much faster. With posting faster, the tables won't be locked when trying to read from it. Search will also go faster, being its own table. It's just gonna be some work to get that going. |
||
|
||
|
||
It requires, instead of a query that loads 50 or so posts, going through 115,000 posts or something (on the twenty-somethings thread for instance) in order to make the pagination. |
||
|
||
|
||
|
||
|
||
|
||
![]() Seriously. How much additional space can we also free up if we delete all the fucking endless "Legion of Super Heroes reboot is an abortion" and "it just gets worse" sales doom-n-gloom posts ? ![]() |
||
|
||
|
||
Are you saying this "maintenance" is a secret ploy to get rid of Nac and Herald? ![]() |
||
|
||
|
||
|
||
|
||
|
||
Jude is going to do the Superboy punch/Flashpoint??? ![]() |
||
|
||
|
||
![]() I have disabled search and I am importing all the posts into a new database table, one with less indexes, which is INNODB, which supports row level locking (making a post won't prevent reading from the table). This will probably take most of the day. After that, we will begin rebuilding the search engine, and search will return (this could take several days). After that, everything should be a fuck of a lot faster. |
||
|
||
|
||
Posts table is now INNODB. Let's see if the awful slowness goes away now. |
||
|
||
|
||
|
||
leave a comment with facebook
Who is online
Users browsing this forum: No registered users and 29 guests
Advertisement |
---|
|