InnoDB : MySQL's ACID-compliant Storage Engine

learn more… | top users | synonyms

0
votes
1answer
126 views

innodb buffer pool size and munin

I was looking at the below graph of one of my db server's memory usage and have the following question. Is the mysql innodb buffer pool included in the apps or the cache memory allocation? Right now ...
0
votes
1answer
179 views

Why there is always a tilde (~) sign in the result message in mysql

Whenever I refresh or search anything in the table in mysql, the result message always shows result like this. Showing rows 0 - 10 ( ~11 total , Query took 0.0004 sec) When it is showing the exact ...
2
votes
1answer
958 views

MYSQL fails with: InnoDB: Operating system error number 30 in a file operation

My MYSQL server has been stopping recently about once a week. It requires a reboot to get is working again. But once its rebooted, it will work again for another week or two. The error in question is ...
0
votes
2answers
123 views

MySQL server stopped working

Yesterday, out of the blue, the MySQL working as a backend for my private postfix server stopped working. No log entries, nothing, it just won't start. I reinstalled it and it worked until I copied ...
8
votes
2answers
29k views

MySQL InnoDB lost tables but files exist

I have a MySQL InnoDB which has all the database table files, but MySQL doesn't see them, and isn't loading them. The problem happened because I deleted these three files: ibdata1, ib_logfile0 and ...
0
votes
2answers
90 views

Is MyIsam safer than InnoDB?

Is MyIsam engine safer than InnoDB about loss of data due to FileSystem error? It seems that InnoDB is not reparable with MySQL tool. I had to choose my engine and I chose InnoDB because of foreign ...
4
votes
2answers
6k views

Can't start mysql (xampp) after installing on external drive

I decided to move my XAMPP installation to external drive. It's USB3 3TB Seagate drive. Unfortunately mysql doesn't want to start. All works fine if I install XAMPP to C drive but doesn't work when I ...
1
vote
1answer
506 views

xampp on external 4tb usb 3.0 seagate goflex drive

I can't seem to start MySQL on my external USB 3.0 drive. In the past, I haven't had problems working off of external drives. This is the first time using a large drive. Any help will be appreciated. ...
1
vote
2answers
462 views

Mysql InnoDB Disabled

I have modified the my.cnf for a MySQL 5 installation and now I receive the following error in syslog: InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than ...