BetaArchive Logo
Navigation Home Screenshots Image Uploader Server Info FTP Servers Wiki Forum RSS Feed Rules Please Donate
UP: 24d, 12h, 54m | CPU: 85% | MEM: 6079MB of 12227MB used
{The community for beta collectors}

Post new topic Reply to topic  [ 13 posts ] 
Author Message
 PostPost subject: MySQL Updated        Posted: Sat Sep 08, 2018 4:05 pm 
Reply with quote
Administrator
User avatar
Offline

Joined
Fri Aug 18, 2006 11:47 am

Posts
12459

Location
Merseyside, United Kingdom

Favourite OS
Microsoft Windows 7 Ultimate x64
Hi all,

We have updated MySQL and converted the database to a more suitable format. This should help address some intermittent slowdowns especially when making posts.

Let us know if you still experience these.

Thanks

Andy (Admin)

_________________
Image

BetaArchive Discord: https://discord.gg/epK3r6A


Top  Profile  WWW
 PostPost subject: Re: MySQL Updated        Posted: Sun Sep 09, 2018 7:08 pm 
Reply with quote
Staff
User avatar
Offline

Joined
Thu Nov 30, 2006 6:10 pm

Posts
2639

Location
Land of The Tea.

Favourite OS
Windows 10 Pro x64
Move to MariaDB, its a load better than MYSQL and its a drop in replacement.

_________________
Image
| Personal site - Social links - PC setup | TF2 Game Servers |
Liking traps isn't gay, its not gay if it looks like a girl
I-i-it's n-not as if I wanted to ban you or anything. B-baka. (「・ω・)「


Top  Profile  WWW
 PostPost subject: Re: MySQL Updated        Posted: Sun Sep 09, 2018 7:09 pm 
Reply with quote
Administrator
User avatar
Offline

Joined
Fri Aug 18, 2006 11:47 am

Posts
12459

Location
Merseyside, United Kingdom

Favourite OS
Microsoft Windows 7 Ultimate x64
We run MariaDB, it's just easier to say MySQL when referring to it.

_________________
Image

BetaArchive Discord: https://discord.gg/epK3r6A


Top  Profile  WWW
 PostPost subject: Re: MySQL Updated        Posted: Sun Sep 09, 2018 7:26 pm 
Reply with quote
Staff
User avatar
Offline

Joined
Thu Nov 30, 2006 6:10 pm

Posts
2639

Location
Land of The Tea.

Favourite OS
Windows 10 Pro x64
Might wanna increase cache sizes then as it still hangs when posting, I'll send over what im using for my configs tonight.

_________________
Image
| Personal site - Social links - PC setup | TF2 Game Servers |
Liking traps isn't gay, its not gay if it looks like a girl
I-i-it's n-not as if I wanted to ban you or anything. B-baka. (「・ω・)「


Top  Profile  WWW
 PostPost subject: Re: MySQL Updated        Posted: Sun Sep 09, 2018 7:35 pm 
Reply with quote
Administrator
User avatar
Offline

Joined
Fri Aug 18, 2006 11:47 am

Posts
12459

Location
Merseyside, United Kingdom

Favourite OS
Microsoft Windows 7 Ultimate x64
Cache is pretty big already but some pointers wouldn't go amiss - thanks. It's not writing anything to the slow log so I don't think it's a query speed issue, it's something else.

_________________
Image

BetaArchive Discord: https://discord.gg/epK3r6A


Top  Profile  WWW
 PostPost subject: Re: MySQL Updated        Posted: Sun Sep 09, 2018 7:40 pm 
Reply with quote
Staff
User avatar
Offline

Joined
Thu Nov 30, 2006 6:10 pm

Posts
2639

Location
Land of The Tea.

Favourite OS
Windows 10 Pro x64
The forums database us Myisma iirc, if its not too big could probably ram cache the entire forums

_________________
Image
| Personal site - Social links - PC setup | TF2 Game Servers |
Liking traps isn't gay, its not gay if it looks like a girl
I-i-it's n-not as if I wanted to ban you or anything. B-baka. (「・ω・)「


Top  Profile  WWW
 PostPost subject: Re: MySQL Updated        Posted: Sun Sep 09, 2018 7:50 pm 
Reply with quote
Administrator
User avatar
Offline

Joined
Fri Aug 18, 2006 11:47 am

Posts
12459

Location
Merseyside, United Kingdom

Favourite OS
Microsoft Windows 7 Ultimate x64
We use InnoDB as of the update on this topic. One of the things I thought may have been causing it was table level locks and InnoDB doesn't have that issue. If we can RAM cache the entire forum (500MB) without risk to data if there is a crash then I'll consider it.

_________________
Image

BetaArchive Discord: https://discord.gg/epK3r6A


Top  Profile  WWW
 PostPost subject: Re: MySQL Updated        Posted: Sun Sep 09, 2018 7:57 pm 
Reply with quote
Staff
User avatar
Offline

Joined
Thu Nov 30, 2006 6:10 pm

Posts
2639

Location
Land of The Tea.

Favourite OS
Windows 10 Pro x64
Done an optimise recently?

_________________
Image
| Personal site - Social links - PC setup | TF2 Game Servers |
Liking traps isn't gay, its not gay if it looks like a girl
I-i-it's n-not as if I wanted to ban you or anything. B-baka. (「・ω・)「


Top  Profile  WWW
 PostPost subject: Re: MySQL Updated        Posted: Sun Sep 09, 2018 8:22 pm 
Reply with quote
Administrator
User avatar
Offline

Joined
Fri Aug 18, 2006 11:47 am

Posts
12459

Location
Merseyside, United Kingdom

Favourite OS
Microsoft Windows 7 Ultimate x64
Yes done all of that.

_________________
Image

BetaArchive Discord: https://discord.gg/epK3r6A


Top  Profile  WWW
 PostPost subject: Re: MySQL Updated        Posted: Sun Sep 09, 2018 8:57 pm 
Reply with quote
Staff
User avatar
Offline

Joined
Thu Nov 30, 2006 6:10 pm

Posts
2639

Location
Land of The Tea.

Favourite OS
Windows 10 Pro x64
I've found one of my databases would hang due to a slight corruption on one of the tables, had to delete that table and re-make to get things working properly again. This was when i migrated from mysql to maria.

_________________
Image
| Personal site - Social links - PC setup | TF2 Game Servers |
Liking traps isn't gay, its not gay if it looks like a girl
I-i-it's n-not as if I wanted to ban you or anything. B-baka. (「・ω・)「


Top  Profile  WWW
 PostPost subject: Re: MySQL Updated        Posted: Sun Sep 09, 2018 8:58 pm 
Reply with quote
Administrator
User avatar
Offline

Joined
Fri Aug 18, 2006 11:47 am

Posts
12459

Location
Merseyside, United Kingdom

Favourite OS
Microsoft Windows 7 Ultimate x64
I could dump the DB and re-import it to get around that issue then?

_________________
Image

BetaArchive Discord: https://discord.gg/epK3r6A


Top  Profile  WWW
 PostPost subject: Re: MySQL Updated        Posted: Sun Sep 09, 2018 9:16 pm 
Reply with quote
Staff
User avatar
Offline

Joined
Thu Nov 30, 2006 6:10 pm

Posts
2639

Location
Land of The Tea.

Favourite OS
Windows 10 Pro x64
Maybe, i'd test first.

_________________
Image
| Personal site - Social links - PC setup | TF2 Game Servers |
Liking traps isn't gay, its not gay if it looks like a girl
I-i-it's n-not as if I wanted to ban you or anything. B-baka. (「・ω・)「


Top  Profile  WWW
 PostPost subject: Re: MySQL Updated        Posted: Sun Sep 09, 2018 9:31 pm 
Reply with quote
Administrator
User avatar
Offline

Joined
Fri Aug 18, 2006 11:47 am

Posts
12459

Location
Merseyside, United Kingdom

Favourite OS
Microsoft Windows 7 Ultimate x64
Well it's all I can try since I can't delete a database and recreate if it has data in it really.

_________________
Image

BetaArchive Discord: https://discord.gg/epK3r6A


Top  Profile  WWW
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 




Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  

All views expressed in these forums are those of the author and do not necessarily represent the views of the BetaArchive site owner.

Powered by phpBB® Forum Software © phpBB Group

Copyright © 2006-2018

 

Sitemap | XML | RSS