Questions tagged [innodb]

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

Filter by
Sorted by
Tagged with
-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 ...
3 votes
3 answers
7k views

How to disable all MariaDB storage engine except MyISAM?

(in my.cnf) I've tried default-storage-engine = myisam, skip-innodb, and commented out every innodb features, but none of them works
-1 votes
2 answers
4k views

Cannot drop index from MySQL INNODB table with foreign keys/references

I'm about to drop an index from a mySQL INNODB table. There are references defined already. When I try to alter it, it says: #1025 - Error on rename of 'X/#sql-2a5f_219828' to 'X' (errno: 150) Which ...
14 votes
1 answer
18k views

How to disable keys in MySQL InnoDB tables?

Is it possible to disable keys in InnoDB tables? If yes, how? If not, why?
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 ...
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 ...
1 vote
2 answers
3k views

How can I lower MySQL single-page reads?

My innodb buffer pool size is 8GB and my database is 6GB in size but I see this: Innodb_buffer_pool_reads 263.5k - The number of logical reads that InnoDB could not satisfy from buffer pool and had ...
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 ...
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 ...
4 votes
2 answers
21k views

InnoDB "log sequence in the future!" crashing, won't start

I stopped mysql only to find that it wouldn't come back up, /etc/init.d/mysql start only outputs . . . . . . failed. I've narrowed it down to an issue with InnoDB. The database starts when ...
3 votes
1 answer
17k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...
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
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 ...
15 votes
4 answers
52k views

How to know storage engine used of a database?

Previously, on every database created, I use: mysql -u root -p CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_bin; GRANT ALL ON dbname.* TO 'dbuser'@'localhost'; and then use the database ...
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
2 answers
16k views

Changing innodb_buffer_pool_size on the fly

I'm wondering if it's possible to change the innodb_buffer_pool_size on the fly. It looks like the buffer pool has been over allocated on my server and it's swapping now. I've changed this value on ...
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 ...
1 vote
3 answers
190 views

Database select error

Database select error its my problem and when I restart my mysql to fix this error this problem solve but after 30 minutes or after hours again this error happen again. I put link here screenshot ...
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
2 answers
2k views

Troubleshooting MySQL Performance Issues

Environment: 1 physical machine 8GB RAM some older Core2Duo CPU 1 HDD Windows Vista 64 bit 1 Virtual Machine 16 GB RAM 2 vCPUs Windows 7 64bit Both machines running MySQL 5.5.28 (64Bit) with ...
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 ...
1 vote
1 answer
21k views

MySQL server quit without updating PID file

I need help on how to start the mysql server. The problem arise when the root directory was full. To be able to login to directadmin and start mysql, I added a soft link of the /var/lib/mysql/ to /...
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 ...
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 ...
19 votes
5 answers
32k views

Modifying columns of very large mysql tables with little or no downtime

I periodically need to make changes to tables in mysql 5.1, mostly adding columns. Very simple with the alter table command. But my tables have up to 40 million rows now and they are growing fast... ...
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 ...
5 votes
1 answer
3k views

MySQL and large pages/hugetlb performance gain in numbers?

MySQL has large page/hugetlb support for InnoDB. And there's plenty of posts (example) on the topic. But does anyone have examples of what performance changes they saw ? I have seen other database ...
-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
629 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/...
0 votes
2 answers
2k views

MySQL fails to start with one config line change - innodb_buffer_pool_size = 1G

My curent config works great but my innodb_buffer_pool_size is too small as the database is very large. All I am changing in my MySQL.cnf is innodb_buffer_pool_size = 1G to ...
6 votes
3 answers
24k views

1286 - Unknown storage engine 'InnoDB'

I am trying to use roundcube and it recently just broke. I don't know if this is due to a MySQL update that happened recently or not but in phpMyAdmin I get the following error if I try and view a ...
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), ...
3 votes
1 answer
27k views

MySQL failed to start. Error 1053. Windows Server 2008 R2

I did a server restart for my web server and on restart, MySQL won't start. If I use taskmanager to kill mysqld.exe and try the start from services console, it gets about 50% through the startup, ...
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 ...
4 votes
7 answers
11k views

Is there any equivalent of mysqlhotcopy for InnoDB?

Currently I'm using mysqldump to make backups which is slow, but OKish. The big problem is restoring database, which takes a few days. The dump is around 7GB gzipped, so it's not a tiny database, but ...
5 votes
1 answer
1k views

How to drop an 8 GB InnoDB table smoothly without global locks

MySQL version: 5.1.63. I am about to DROP a bigger ~8 GB InnoDB table. Last week I dropped a four times bigger table on another machine and a global lock kicked in that took us down for ~90 seconds. ...
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....
17 votes
5 answers
10k views

What is the difference between InnoDB and MyISAM?

I am using MySQL as my database for my current web project. I am new to MySQL. Please explain to me the difference between InnoDB and MyISAM.

1 2
3
4 5
8