is there anyone using mysql8? can you please monitor the loading speed of your websites using that DB server?
this problem happens intermittent. sometimes it’s normal, but sometimes take ages to load your website.
you can also try it by browsing your DB via phpMyAdmin on mysql8
ticket ref: MOW-50062-542
Looks like backups maybe the cause here. I’ve notified admins to make necessary backup policy changes for this DB server.
please let me know when will this be done. And let’s see how it will perform.
I was told in ticket to move my DB to another mysql server, but I think I’m gonna wait for the above first.
the problem is still there X(
looks like I’m going to have to move my websites.
this is what I got from my website → Dynamic page generated in 41.523 seconds
it’s totally NOT acceptable! X(
and you know what I just got?
Error establishing a database connection
aarrrgggghhhhhh X(
I have had to go through the process of moving a database from mysql8. A phpBB website was having similar problems to those you describe. It was a painless exercise with Help Desk assistance. Down time was negligible, although I did lock the forum to prevent posts being made between the start of the backup of mysql8 and restore of the database on the new server (in my case, mysql9). The non-phpBB parts of the website were unaffected by the move.
The improvement in performance has be nothing less than dramatic. I’d highly recommend making the move.
We have found a large db with a large amount of steady connections making problems on MySQL8, we have stopped their DB temporarily and others looking much better now.
But we would like you to move your database on our new database server i.e, Mysql10. For this you can take help of our support team by confirming the database move on ticket and we’ll help you to take backup/restore on new server.
Good old Stephen let me in to this tip-top FOR YOUR EYES ONLY secret part of the forum at last! Re stopping that DB temporarily - it certainly seems to have improved the performance of my Joomla sites on Web4/MySQL8. Long may it continue! If it doesn’t I’ll put in a request for a move to MySQL10 too.
Monday 20th Feb 2012
Just requested a MySQL DB move from MySQL8 to another MySQL Server with the Help Desk people.
My Joomla sites on Web4 are pretty much unusable - the fault I suspect being with MySQL8 as discussed in the prvious posts on this thread.
I’m only requesting one move to see how it goes and to see what’s involved. Then I’ll ask for them all (about 5 sites) to be moved.
More often than not the sites give a 500 error - a timeout I think caused by the database connection.
So, here’s hoping…
Just got this. I was under the wrong impression that the HelpDesk people moved it. I’ll give it a try and shout for help if needed!
…
Hello,
There is not any automatic process to move database on different server. you can create a new account in your reseller control panel and create a new database under this account. After that you can move the backup from current account to new account.
Please feel free to contact us for any further assistance.
With Regards,
Manoj Saini
JodoHost Support
Hello,
We can aid you in moving it, but there is only an automated move process for website portion, not DB portion.
This is the same for IIS, and Apache sites, they will move, but DBs won’t. You can take a SQL backup image from phpmyadmin and then restore it to a new account and it will be on a new server. Alternatively you can backup, save the copy, delete all DBs on the account then make again and it will go on a new server where you can restore, but this will require a possibly extended downtime.
Thanks Stephen, I’ll give it a go and see how far I get. Fingers crossed!
This has brought up a good point however, for our talks with Parallels about the future of the Hsphere hosting platform and I will bring up the option for moving DBs, and even mail between servers automated 
Well that would be ace!
“You can take a SQL backup image from phpmyadmin and then restore it to a new account”
Is this the same as Exporting the database?
Is this the same as Exporting the database?
Ans : Yes , It is same as Exporting the database.