Questions tagged [innodb]
InnoDB is the main ACID-compliant Storage Engine used in MySQL.
388
questions
1
vote
2
answers
644
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
1
answer
465
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
1
answer
1k
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 ...
-1
votes
1
answer
698
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
0
answers
476
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
1
answer
323
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
1
answer
626
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
0
answers
955
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 ...
1
vote
3
answers
3k
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
2
answers
1k
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
...
3
votes
1
answer
12k
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
2
answers
7k
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
1
answer
523
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 ...
2
votes
3
answers
1k
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 ...
1
vote
1
answer
20k
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
0
answers
4k
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
1
answer
77
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
0
answers
5k
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 ...
2
votes
2
answers
1k
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
3
answers
590
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 ...
19
votes
6
answers
8k
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
1
answer
667
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
1
answer
263
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
2
answers
5k
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
1
answer
1k
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 ...
0
votes
2
answers
13k
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
1
answer
552
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
1
answer
6k
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
1
answer
1k
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
1
answer
402
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
0
answers
583
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
1
answer
351
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 ...
3
votes
2
answers
11k
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
1
answer
624
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
0
answers
831
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
1
answer
489
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
3
answers
221
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
1
answer
249
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 ...
0
votes
3
answers
630
views
moving live innodb db from one server to another
I need to move an innodb db from one server to another - it is also going from mysql > mariadb. I want to ensure there are no problems at all and with that I will be using mysqldump to export and ...
0
votes
1
answer
1k
views
Unusually high RDS MySQL memory
could use your help in understanding this. I'm running an RDS MySQL instance (db.m3.large on SSD) with 100GB of storage.
I'm a little freaked out that my memory is 50% there:
chart http://f.cl.ly/...
3
votes
1
answer
11k
views
Recover mysql database innodb 'table doesn't exist'
Our server crashed last week and we lost a lot of information. We were able to recover .frm files for the tables, ib_logfile0, ib_logfile1 and ibdata1 but no .ibd.
I've tried the innodb-force-...
1
vote
1
answer
36
views
Examine MySQL INNODB folder
Consider the following situation.
I currently have an Ubuntu installation installed in my Virtual Machine. This installation has mysql installed in it.
Data for the mysql-server can be found under;
...
0
votes
1
answer
139
views
Why mysql don't start in ubuntu server?
I edit mysql config for remote connect, I paste there
bind_address = 0.0.0.0
After it i tryed to restart (sudo /etc/init.d/mysql restart or start) but I see fail of it in both commands.
in logs i ...
2
votes
1
answer
12k
views
MySQL innodb recovery from datafiles
Last night, my MySQL server crashed and now I have several databases, which data I'm unable to recover.
According to errorlog, the coruptions in tablespaces happend quite a while ago (few months), ...
1
vote
2
answers
7k
views
InnoDB: mmap(68878336 bytes) failed; errno 12 [duplicate]
The screenshots explain everything, first I try to start it, and it won't, so I check the status, then I check the logs.
After following a number of previous suggestions that I founder around ...
4
votes
0
answers
961
views
MySQL (InnoDB) - processes waiting on futex
Currently troubleshooting a MySQL server spending a lot of time in futex syscalls. All databases are InnoDB and seeing high load on my 16 core machine, and slightly more than half of CPU time is in ...
0
votes
0
answers
2k
views
Creating my.cnf leads to error with innodb
I got access to an existing mysqld server (5.5.35 from Debian Wheezy) with existing data in production use. I found no existing configuration file in /etc/my.cnf or /etc/mysql/my.cnf. So I copied the ...
0
votes
2
answers
191
views
MyISAM Throughput spike at 12000 record insert
I am testing database performance with bulk record inserts.
Both systems are identical apart from storage engine
**Database 1000 4000 12000**
MySQL_InnoDB 60.95330976 218....
0
votes
1
answer
71
views
innodb files in wrong directory
I have created a database called TEST with innodb tables. When I look in the /var/lib/mysql/TEST directory I see a .frm file for each table. However, there are no .ibd files in that directory. The ...
0
votes
0
answers
518
views
MySQL/Percona Server sudden CPU usage spikes
I've got some trouble with Percona Server 5.5: suddenly abnormous MySQL CPU usage caused the system
to become unresponsive as it was eating up all CPU with a large number of threads.
It's a 24 core ...