Moving MySQL from root to main hard drive: Does it affect speed?
I had an issue with /dev/root being full so I decided to move the MySQL from /dev/root to the main hard drive.
The problem is that initially moving the mysql created some issues in the database, so I decided to restore yesterday's mysql which was Ok. Now, my site goes slower.
Note: For 2 months now I have moved to a new server, the speed was awesome, and suddently all of my colleagues have noticed a 20% speed decrease. So Iam just wondering, is it because we have moved the mysql to the main hard drive instead of /dev/root ? Does this really affect speed? Iam just thinking that it's not possible for the speed to change from one day to the other since the site was working fine and fast.
Thank you.
ikoula posted this at 16:06 — 25th January 2016.
They have: 4 posts
Joined: Sep 2015
Hello,
Mysql response time depends on many factors but first could you be more precise with your explanations ? what's the "main hard drive" have you moved the database from one hard drive to another and if yes does the two drives have the same performances ?
Thomas | Community manager | ikoula Dedicated servers, VPS and Public Cloud.
Contact us by email | Follow us on Twitter | Like us on Facebook
visio posted this at 11:54 — 8th April 2016.
He has: 8 posts
Joined: Nov 2005
no it will not affect speed. I had the same issue on one of our servers, used for shared hosting and the databases were some of them very large, we had to move all the databases to /home/mysql and there was no speed difference at all.
Shared FFmpeg and Red5 Broadcast Live with Wowza or Red5 Hosting.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.