Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [innodb]

InnoDB is the main ACID-compliant Storage Engine used in MySQL.

2
votes
1answer
51 views

What is the maximum number of words allowed in a MariaDB InnoDB Full Text Search query

I recieved this error when performing a search with 746 words (it wasn't intentional someone pasted text into the wrong box). HA_ERR_FTS_TOO_MANY_WORDS_IN_PHRASE: Too many words in a FTS phrase or ...
2
votes
1answer
116 views

Mysql high cpu usage (over 600%)

The server has 8core CPU and 22 GB of ram. Every day receives many requests from users, and recently a replication mechanism has been activated, with an implementation of a db master and a slave. Now ...
1
vote
1answer
106 views

MySQL server (mariadb) auto shutdown without overload

With old configs, my VPS (1 CPU, 1 GB RAM, 1 GB swap) works normally for almost 2 years. I didn't change anything from beginning. But I have this issue several days ago, MySQL server automatically ...
0
votes
1answer
60 views

MariaDB - import raw InnoDB frm/ibd files?

Good afternoon. My Debian 9 server ran into an issue that rendered the OS inaccessible , I managed to extract all the raw database files (/var/lib/mysql) for my project but unfortunately the engine ...
0
votes
0answers
43 views

InnoDB recovery from ibdata1 from disk failure

I started recovering data for a non-profit organization from a server that had a hard drive failure. The mysqldump was not working, but I managed to tar the /var/lib/mysql on time and download via ...
0
votes
0answers
134 views

MySQL's innodb_buffer_pool_size doesn't seem to have any effect on RAM usage

(I have checked similar questions, none of them cover my situation) I'm trying to increase MySQL 5.7 memory usage on my Ubuntu 16.04. Before my changes mysqld was using about 8% of RAM out of 8GB ...
0
votes
1answer
71 views

MySQL perf bad on SSD-based server. Small tables. MySQL config? RAID?

I have a couple of servers in an industrial setting (air-gapped network) that do some fairly light telemetry gathering. We generate about 10GB of telemetry history in ~30 days. All telemetry goes ...
0
votes
0answers
116 views

mySQL shutdown “ERROR: 1050 Table 'plugin' already exists”

Have a mySQL DB (running on a Debian LAMP) that seems to do a maintenance shutdown or check each night, and fails with the following. The only "plugin" table is the empty one in the mysql db, and I'm ...
0
votes
0answers
64 views

Dump all data reduced size, but fragmentation got worse

I have a question about tables and fragmentation in MySQL My starting point is this question: How find and fix fragmented MySQL tables I have a table with 1 million of rows and 128MB of space. This ...
0
votes
0answers
94 views

MySQL causing major I/O Lag

I have a mysql server (version 5.1) running Roundcube Webmail client on a plesk box (onyx). We have a few hundred users on it during the day. My hypervisor, Virtuozzo, they have been working with us ...
0
votes
0answers
55 views

Can't start MySQL after InnoDB conversion

I'm having an issue starting MySQL after i converted all tables to InnoDB. When i try to start MySQL i simply get the following: [root@THEP01VMD01 jeffrey]# service mysqld start MySQL Daemon failed ...
1
vote
1answer
38 views

What would cause mysqlcheck to incorrectly report a table as undamaged?

We are administering a MySQL server for one of our customers that has >100 databases with about 50 tables each, many of them InnoDB tables. The server crashed and I'm trying to find the culprit. When ...
0
votes
1answer
88 views

Why are partitioned MySQL InnoDB tables twice as big as unpartitioned ones?

I have two InnoDB tables identical in every respect except for one being partitioned, and the other - not: DROP TABLE IF EXISTS `simple_table`; CREATE TABLE `simple_table` ( `date` date NOT NULL, ...
0
votes
1answer
384 views

Mariadb tuning - slow writes

Background: I have a a website I am migrating from a stand alone MariaDB server to a MariaDB galera cluster. Part of this had me convert the tables from a large number of MyISAM to InnoDB. For what it ...
0
votes
0answers
106 views

Some questions on configuring mysql, maybe apache, maybe CentOS 6 too - InnoDB engine fails to load

please be soft on me as I am starting to get into server admin and have lots of gaps in my knowledge I am running an app on CentOS 6.9_x64 I installed default apache, php and mysql packages and the ...
-1
votes
1answer
67 views

Cannot log in to the MySQL server after hosting company restarted my server

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 ...
3
votes
0answers
275 views

MariaDB on Windows - InnoDB hang on table conversion to MyISAM

This is a bit of a strange one (and a big post, sorry), i am working with a customer who runs MariaDB on Windows (Server 2008 R2). They have several large MyISAM tables (up to 30 GB each, 200+ ...
0
votes
1answer
89 views

How to decrese MySQL Innodb crash recovery time (force MySQL to do it faster)

I'm running MySQL 5.7 with 1GB of innodb_log_file_size on CentOS 7 x64 and I can't change the value of that parameter right now. In the case of crashes, it takes about 20 minutes to recover, but ...
0
votes
1answer
115 views

Different InnoDB data file sizes on Galera

We have a cluster of 3 Galera-MariaDB boxes, using InnoDB as an engine. Cluster's in sync, and reporting all good as far as I can see. Much to my surprise, the size of the InnoDB data files differ ...
0
votes
0answers
398 views

Occasional slow database queries caused by InnoDB

Update 2017-11-26 The problem seems to be related to InnoDB. The CI as well as the Wordpress installations are using InnoDB Engines while the rest is working with MyISAM. After I converted all MODx ...
0
votes
1answer
485 views

innodb-read-only prevent mysql replication? Table 'gtid_slave_pos' is read only

I set up a couple of maraidb v10.2.10 containers with the official docker image. Master can read/write and slave is read-only with this my.cnf. [mysqld] server_id=2 read_only=1 innodb_read_only=1 ...
0
votes
2answers
126 views

MySQL server doesn't start because of missing InnoDB plugin

I cannot start the MySQL server. My machine is an Ubuntu 14.04 with mysql-5.6: $> dpkg --get-selections | grep mysql libdbd-mysql-perl install libmysqlclient18:amd64 install ...
1
vote
1answer
3k views

Mysql cannot start - Could not find valid tablespace file for

My mysql service is currently unable to start with the error InnoDB: Could not find a valid tablespace file for 'wowcher/temp_import'. I think I know what the issue is. I have a PHP script which ...
0
votes
2answers
811 views

MySQL maximum possible memory usage above installed RAM

I'm using debian 8 Jessie and MariaDB. My mysqltuner seems to indicate as MariaDB can use 142% of RAM : -------- Storage Engine Statistics ------------------------------------------- [--] Status: +...
-1
votes
1answer
76 views

MariaDB generating INDEX_*.ibd files, racking up server space

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 ...
0
votes
1answer
266 views

How to deal with mysqldump and innodb_buffer_pool_size?

We have a database of about 100GB. However, most of this 100GB is "archived" data that we rarely access -- about 25GB is active data. We have innodb_buffer_pool_size set to 48G, which is typically ...
0
votes
1answer
878 views

Mysql Fails to start [InnoDB Repair]

After inspecting the log files I see that some of the databases have errors. 2017-05-16 08:52:48 7fc0cb8abb00 InnoDB: Assertion failure in thread 140466025315072 in file ha_innodb.cc line 21990 ...
0
votes
0answers
1k views

Trying to rebuild InnoDB files after server crash with no dump file

I am having a major problem starting mysql (using mariadb). I had a server crash (and didn't have a dump of the databases in the server. After restoring the server, I tried to manually copy the ...
1
vote
1answer
58 views

How to avoid updates to ALL rows in Mysql table? [closed]

Is there a way by which update to ALL rows of a Mysql table could be denied or avoided? Background: I have a table 'Orders' having 'OrderID' (Type VARCHAR) and 'VendorID' (Type Integer) as two of ...
2
votes
0answers
1k views

MySQL/InnoDB crash - “Log Sequence Number is in the future!”

So, after a database's files were copied over successfully, however an older version of InnoDB's logs were transferred, MySQL fails to start up in anything less than innodb_force_recovery=6. Due to ...
0
votes
2answers
390 views

MySQL limiting user disk space by tablespace

I am trying to figure out how to set a limit of disk space for users in MySQL. What I want is, for example, administrator assign 1G disk space for user A, if A used up the 1G disk space, MySQL would ...
0
votes
3answers
104 views

How can I copy only part of a MySQL database server to a new slave?

I'm trying to set up a slave MySQL server on another continent. I don't have enough space on the new server for the entire database that the master contains. Therefore I am trying to bring up this ...
12
votes
5answers
3k views

Backing up a MySQL database via ZFS snapshots

I've found a number of sites talking about doing exactly this, but I'm missing a few important details. The general steps are Run FLUSH TABLES WITH READ LOCK Take the ZFS snapshot Run UNLOCK TABLES ...
0
votes
1answer
352 views

Trying to recover MySQL database from a crashed server and I keep getting “mysqldump couldn't execute 'show create table doesn't exist (1146)”

My OpenSuse 13.1 server crashed and couldn't boot but I managed to connect the hard drive to another computer and copied the files in /var/lib/mysql On a new installation, I followed the steps ...
0
votes
1answer
176 views

MySQL 5.7 Multi Master Multi Source Replication issues after mysqld restart

I've a multi master & multi source replication setup working perfectly fine. M1 -> M2 || M1 -> M3 M2 -> M1 || M2 -> M3 M3 -> M1 || M3 -> M2 As soon as I restart mysqld on M2 I'm missing a ...
0
votes
2answers
3k views

InnoDB (Not Really) Out Of Memory?

MySQL keeps on crashing on my server. I'm running several dozen sites using VestaCP and haven't had issues with MySQL for months. I'm running on a Linode VPS with 12GB of Ram, normally 9GB of it ...
0
votes
1answer
692 views

How do I configure full-text InnoDb functionality in MariaDB on AWS RDS?

I'm in the process of moving to MariaDB on RDS. My tables are up and running and everything looks good, but given that I'm on MariaDB 10.0.24, I'm considering switching a couple of my MyISAM tables ...
-1
votes
2answers
3k views

Removed ib files to make mysql start but now it does not recognize tables

I had problem starting innodb and read somewhere that deleting ib_logfile0,ib_logfile1 files works. It worked and mysql started again and when I use "Show tables" it shows all tables of my database ...
1
vote
1answer
240 views

How to exclude specific table from innodb buffer pool?

Here's my situation. I have one really large table that holds about 90 GB of data. I've utilized DATA DIRECTORY to place that table on another drive, as I rarely use the table and don't want it ...
1
vote
1answer
3k views

How to tune MySQL server when big peak of usage is expected

I'm having pretty big issues trying to tune my MySQL server. I was expecting a lot of people on my website after buying a tv ads between 5pm and 6pm, I have more or less 300 persons at the time on the ...
1
vote
1answer
689 views

MySQL (MariaDB) crashing

Good morning - I have reviewed a previous post regarding changing the performance schema to "Off in the configuration settings. It looks as though our configuration is already set to this. So not sure ...
0
votes
1answer
287 views

MariaDB refuse to start after VServer reboot

After I rebooted my VServer, MariaDB refuses to start. This are the error messages: # systemctl status mysql.service ● mysql.service - LSB: Start and stop the mysql database server daemon Loaded: ...
0
votes
0answers
468 views

InnoDB causing mysqld to crash on Amazon Linux AMI

This Amazon Linux server is running a single WordPress site that is constantly crashing. The way to resolve it seems to be to run service mysqld restart and it resumes operation until it crashes again....
1
vote
1answer
223 views

MySQL keeps crashing at unknown intervals

Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 160130 08:29:38 mysqld_safe Number of ...
1
vote
2answers
4k views

Mysql innodb_buffer_pool_size in relation to innodb_buffer_pool_instances

I run a virtual server with an Owncloud installation on it. Now Owncloud has the problem that the way it's developed at the moment, each file upload causes a little MySql overhead. So is very ...
0
votes
1answer
178 views

how to prevent Innob db spiking at 97% Disk I/O Utilization

Our database(InnobDb) is spiking at 99% I/O at random times. After the spike it goes down to about 2% until it spikes agian. There are not some "super" queries that are running in these intervals. We ...
0
votes
0answers
351 views

InnoDB settings - mysql tuner results after running for awhile

Newbie as far as InnoDB goes, but I installed MySQLTuner awhile back and according to this it looks like I need to adjust my settings, but can someone chime in with some deeper understanding of all ...
1
vote
1answer
282 views

MariaDB won't start - fails to check integrity

I have a MariaDB installed with brew in my macbook. Worked fine till today. All of a sudden it wound not start: -> mysql.server start Starting MySQL ERROR! also, if I issue mysql -uroot or any ...
0
votes
3answers
110 views

Mysql master slave replication fail PID error

I have Master on 5.6 & Slave on 5.5, this will be the test ENV to check if 5.6 can replicate on 5.5 on PROD. I am getting this below error when starting mysql ERROR! MySQL server PID file ...
-1
votes
1answer
158 views

mySQL keeps crashing with a specific Wordpress theme enabled

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 ...