5

MySQL unstable behavior with external stroge

view full story
linux-howto

http://serverfault.com – In our project we are using MySQL 5.0.90(InnoDB engine) server with an external storage. We store MySQL data files in an external storage. When the external storage down for a reason we have unstable behaviours. So we made some tests. In Windows Server 2008 We closed external storage physically. MySQL service stoped and we could not reach the server. Then we opened the storage unit and we could start service Logs 120618 14:49:30 InnoDB: Operating system error number 21 in a file operation. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refma (HowTos)

taskli's picture
Submitted by taskli on 06/18/2012 – Made popular on 06/18/2012

Stories similar to MySQL unstable behavior with external stroge

I've changed data directory in /etc/my.cnf.

Yesterday my server died because an outage in the data center. Today it's back up, but having some problems with mysql.

First of all my mysql server was not able to start. For this reason I deleted the files ib_logfile0 and ib_logfile1 in /var/lib/mysql folder (I still have the old failing files).

After this my server was able to startup again.

Today I have changed mysql config file and restarted mysql with:

service mysql restart

And saw the following:

Stopping mysql database server: mysqld. Starting mysql database server: mysqld. Checking for corrupt, not cleanly closed and upgrade needing tables..

After that the mysql service started working, but later I saw errors on my website and realized that InnoDB engine was not star

Hi, I have cPanel server with MySQL 5.5.27, with lot of users and databases. I want to convert all tables in all databases from MyISAM type to InnoDB storage engine, how can I achive this using mysql client from shell with root privileges ?

Also, I have added to my /etc/my.cnf for future tables: default-storage-engine=InnoDB

Thank you, Kind regards

mysql - InnoDB plug in error 1 year 38 weeks ago

Hi,I've tried to install a mysql server on my arm machine but I can't start mysqld.

I have a fresh install of ubuntu 12.04 server edition and mysql server is not starting properly.

I did a simple apt-get install

apt-get install mysql-server

But, it's failing with this error message

root@test:~# mysqld

120618 20:57:32 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release.

MySQL won't start 1 year 10 weeks ago

Hi,I'm trying to configure MySQL: ArchWikimysqld won't start. My /var/lib/mysql/stovepipebox.err:120310 16:24:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/mysqld: Table 'mysql.plugin' doesn't exist 120310 16:24:31 [ERROR] Can't open the mysql.plugin table.

I have already optimize many times my Mysql server but now I want to have your advices.

mysqltuner:

-------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.1.52-log [OK] Operating on 64-bit architecture

-------- Storage Engine Statistics --------------------------------------

Most people don't bother about what MySQL engine they are using. Generally, it doesn't even matter, the default MyISAM does the job really well but sometimes switching to some other engine or at least knowing what others are capable of, could speed up a lot of things for you. Managing transactions for a Financial website was how I came across InnoDB engine at first.