It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 9 years ago. We have a new centos 6.2 setup. Below … Read more
I’m about to drop an index from a mySQL INNODB table. There are references defined already. When I try to alter it, it says: #1025 – Error on rename of ‘X/#sql-2a5f_219828’ to ‘X’ (errno: 150) Which at first seems logical, since there are relations, it can’t be renamed. But even if I disable foreign key … Read more
It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 8 years ago. I have MySQL 5.5 installed. I tried to … Read more
I currently have backups that were taken with Percona XtraBackup of all my mySQL databases. My specific scenario is that I want to restore a month old InnoDB database snapshot to my local machine for testing but I can’t seem to find instructions for doing that in the Percona documentation. Reading around on Google I … Read more
nice people 😉 I have a problem with my server after I setup a new theme on one of my wordpress sites. At first mySQL started to crash once in a while, then it became more and more often and now you click on any page and the whole VPS Server goes down. Cant even … Read more
Little bit of context before diving into the issue, I have a WordPress based blog running on 1 GB (RAM), 20 GB (disk space) linode instance. The database itself is around ~105 MB. Recently, I noticed that the entire disk space was used (from ~4 GB) with the database directory /var/lib/mysql/DATABASE_NAME consuming about ~15 GB … Read more
Today my hosting company decided to patch their systems due to Meltdown/Spectre and restart all servers. I had my CentOS 7.2 server running for 280 days with no problems of any kind at all. But now I can’t use my website anymore, it says “Error establishing a database connection”. When I try to log in … Read more
Last night the server was upgraded from a MySQL server with InnoDB Cpanel have much of a problem when MySQL server will shut down! Because many of the sites on vps in their database to InnoDB Engine Table Does not have put up their site and say error: Unknown table engine ‘InnoDB’ Error Log into … Read more
I have a mysql database instance with more than 3000 database inside. Each database contains more than 200 tables. I have more than 100 gb of data in all these database at present. I am using windows server 2012R2 operating system with a 4GB of RAM. The RAM memory utilization of the server system was … Read more
My server seems to crash/restart under a load that would not have previously made it crash. How can I troubleshoot this? VPS is running Centos 6.x, 8GB ram Mysql is crashing/restarting itself under loads that would not have previously done it in. This error: InnoDB: Unable to lock ./ibdata1, error: 11 pops up in the … Read more
