• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Linux I have a problem with mySql

F

fironfox

New Member
Joined
Dec 14, 2012
Messages
42
Reaction score
1
Well, I bought a dedicated server at OVH to host my tibia server. The problem started when I let him online , my old machine was SSD and ran perfectly , and the machine is now bought HDD , the problem is that MySQL does not get ta realizing data and ridiculously begins lock and press play when it reaches write 8MB . 8MB written to an HDD of 7200 rpm using SAS is ridiculous !! Ja efetuei countless tests on the HDD even ran a test to write a 1GB file and reached the same 160MB / s speed, then the problem is not in HDD but in MySql ... not to understand what is going on , someone could help me urgently ?
 
Sort by date Sort by votes
Yeap bro, my problem is this: I use HDD in my open tibia server, and this are making my server freeze and lag when MySql get 8MB/S of write in the DB (i have checked with IOTOP in linux), but 8MB/s its a low speed for two HDD's with RAID1 and SAS... I have tried many things but not have sucess with that...
 
Upvote 0 Downvote
Why not?? Look at this: 1073741824 bytes (1.1 GB) copied, 6.82945 s, 157 MB/s. My hd is normaly... What u think its the problem??
 
Upvote 0 Downvote
lol? Because write speed in mySql it's all in otserv... If have any delay or anything, the server not work perfectly... And this problem begin after i bought this dedicated... When i run in VPS with SSD i never get this problem. If not load tha much of data, why when i take a server save de iotop of mysql up to 20 mb/s ?? and why every second my iotop get 8mb/s of write?? all time
 
Upvote 0 Downvote
Thats not true. the system is stored on the ram memory, and when it saves, dump the data to the mysql tables.
 
Upvote 0 Downvote
I have 32gb de ram, in mysql.cnf i have dedicated 16 gb for my sql works... U have any light for me to solve this problem???
 
Upvote 0 Downvote
SSD usually fixes that, database writing speed depends on how many queries are being executed at the time so If you have a Hardcore-WAR server with lots of scripts that require sql queries, you will have some lag unless you get a SSD or optimize your scripts. Perhaps your Distribution is not as optimizable as the new ones or using an old rev.
 
Upvote 0 Downvote
Back
Top