Questions tagged [innodb]

InnoDB : MySQL's ACID-compliant Storage Engine

Filter by
Sorted by
Tagged with
0
votes
1answer
26 views

MySQL Cluster binlog replication order

We are facing an issue with our MySQL replication stack: We actually have a MySQL ndb cluster (7.6.11) acting as a master and an innoDB(5.7) as a slave. Everything seemed to be working right until we ...
0
votes
0answers
15 views

I Altered a Table Column and phpMyAdmin Responded by Removing the Table. Is That Table Recoverable? Is my phpMyAdmin Installation Safe to Use?

So, I was added a new, null column to my innoDB table as the second last column. It was a of a type BOOLEAN and as soon as I did it told me that I was betraying a foreign key constraint for doing so. ...
0
votes
1answer
52 views

XAMPP Mysql shutdown unexpevtedly

Please, my MySQL is damaged after my PC suddenly shutdown. 18:05:24 [mysql] Error: MySQL shutdown unexpectedly. 18:05:24 [mysql] This may be due to a blocked port, missing dependencies, 18:05:24 [...
1
vote
0answers
18 views

Rollbacks in transactional DDL statements for innodb in MySQL 8.0

System: MySQL 8.0, Storage engine - Innodb In a given scenario, I obtain an explicit transaction in application layer, and run some DDL and DML statements. If tx fails, I roll-back it. But only DML ...
0
votes
0answers
8 views

Need help about MariaDB always stop to run

I don't know why, my server MariaDb always stop to run each day. I tried many solution here but the problem still there. I can't see why and this is my recent log: > 190718 08:58:09 mysqld_safe ...
0
votes
0answers
48 views

InnoDB: The error means that another program is using InnoDB's files.Getting this error in MYSQL error log

Errors: [ERROR] InnoDB: Operating system error number 32 in a file operation. [ERROR] InnoDB: The error means that another program is using InnoDB's files. Configuration changes in my.cnf: ...
0
votes
0answers
460 views

MariaDB won't restart / InnoDB: Unable to lock ./ibdata1, error: 11

i stopped mysql in order to change root password and wanted to restart the service again, but it timed out that's my error log /var/log/mysql (just an excerpt!) 2019-06-05 21:40:49 1977992000 [Note] ...
0
votes
0answers
715 views

InnoDB Cluster - addInstance have issue. what is the step for troubleshoot

cluster.addInstance("root@c-1:3306"); A new instance will be added to the InnoDB cluster. Depending on the amount of data on the cluster this might take from a few seconds to several hours. Adding ...
1
vote
0answers
11 views

Restoring InnoDB-Table does not work

i have some issue while restoring data from ibd and ibdata-file. I had worked with these instructions, Recovering A Corrupt MySQL Database and it worked fine until I took a look at the data. The ...
0
votes
0answers
235 views

How to restore corrupted .IDB files on a MySQL server?

I currently have all the old .frm and .idb files from a MySQL server (actually the entire data directory). The server itself has been deleted by the user in his troubleshooting and he has installed a ...
0
votes
1answer
610 views

MariaDB Server cannot start: “InnoDB: No valid checkpoint found.”

After my VM server has fully crashed, and I do not know why, MariaDB on this Debian cannot be launched again. Content of error.log with log files: 2019-04-15 0:40:43 139787712552320 [Note] InnoDB: ...
1
vote
1answer
4k views

How to fix MariaDB when it gets stuck during shutdown (Waiting for page_cleaner)?

I am running MariaDB (v 10.3.13) on Arch Linux (Manjaro). It worked normally for the last months but now there are some issues. When I try to reboot the computer, it gets stuck at A stop job is ...
0
votes
1answer
52 views

How exactly does the InnoDB engine in MySQL update its main data storage files?

It's come to my attention in the course of testing Linux's Back In Time backup utility that I can't understand how MariaDB actually saves data. After adding a bogus record to a table and leaving it ...
15
votes
3answers
12k views

Cannot start mysql: InnoDB: Upgrade after a crash is not supported

I am trying to run MySQL from a Homebrew installation, but it keeps failing when trying mysql.server start. My /usr/local/var/mysql/<name>.local.err reads as so, and keeps sending this error ...
0
votes
0answers
48 views

How to check how much InnoDB space is used?

I have 20GB /var/lib/mysql/ibdata1. How to check how much of this file is really used and how much are junk data which does not store any real data, but just takes space of my disk?
1
vote
1answer
38 views

Is it possible or desirable to run MySQL without any MyISAM tables?

We would like to avoid using MyISAM tables because they don't support transactions. However, I've noticed that many internal tables in MySQL use MyISAM. I can get a list like this: select ...
3
votes
1answer
74 views

How to find whether mysql database my key_buffer and innodb_buffer_pool contending

Server infrastructure: I'm having a centos server running nginx + wordpress + mysql. Problem: mysql frequently getting shutodown and wordpress showing the "cannot connect to database" alerts. ...
0
votes
0answers
74 views

InnoDB + Windows 10 “Storage Spaces” =?

Ok, I think I can repeat this problem. Win 8.1 Pro x64 . Drive S: is "Storage Spaces" mirror made of two 250 GB HD's. Drive C: is SanDisk SSD 120 GB WAMP/MySQL Inno DB consistently refuses to start ...
0
votes
2answers
331 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
729 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
3k 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
223 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 ...
33
votes
3answers
128k 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
3answers
228 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
12k 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
720 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
708 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 ...