Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [innodb]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
194 views

MySQL database repair

Using Vbulletin 4.2.0 PL3 I've used the repair / optimize database feature in vbulletin admin panel but these below tables remain at the same size. Is this normal? Last column is "overhead" which ...
6
votes
2answers
24k views

Why do MySQL queries pile up in “Sending data” state?

We're using InnoDB tables as the back end of a web application, and everything was fine for about two years until we had to restart MySQL a few weeks ago. (We hadn't disabled reverse DNS lookups, ...
2
votes
2answers
3k views

mysqld crashes on any statement

I restarted my slave to change configuration settings to skip reverse hostname lookup on connecting and to enable the slow query log. I edited /etc/my.cnf making only these changes, then restarted ...
0
votes
1answer
253 views

Recovering InnoDB

Bit of tough situation. Running MySQL 5.5 on Ubuntu 12.04. Looking to add some functionality to our internal site, I installed Kaltura. In doing so, my existing MySQL databases seemed to lose all ...
-1
votes
2answers
261 views

InnoDB on server with 2 SSDs [closed]

I have a server with 2 SSDs. I'm running a LAMP install and have an innoDB database on it. my questions are : 1) would innoDB automatically use both SSDs or would it only use one ? 2) would I incur ...
3
votes
1answer
3k views

MySQL slave replication Seconds behind master increasing?

I started a MySQL slave using innobackupexand the Read_Master_Log_Pos: and the Relay_Log_Pos: are updating however the seconds behind master keeps on increasing (it's at Seconds_Behind_Master:496637 ...
0
votes
1answer
3k views

innodb corrupt tables

Running shared hosting cpanel box with Mysql 5.5. Restoring or packaging (using pkgacct) is giving off some serious database errors, on multiple various users sum_joom954.jos_wf_profiles OK warn [...
0
votes
2answers
2k views

Mysql start fails with Operating System error 13

I have XAMPP on my Ubuntu Lucid system and everything worked fine. But there seems to be some problem now and mysql wouldn't start. I had tried to recover a few Drupal databases and hence copied ...
1
vote
2answers
2k views

How to enable InnoDB storage engine for Mysql in Linux

When I run the query "Show Engines" on this particular Linux host, it shows that the InnoDB storage engine is Disabled. Other storage engines (like MyISAM) are showing enabled. What steps would I ...
-1
votes
1answer
2k views

MySQL InnoDB Crash

Last night the server was upgraded from a MySQL server with InnoDB Cpanel have much of a problem when MySQL server will shut down! Because many of the sites on vps in their database to InnoDB Engine ...
8
votes
4answers
6k views

How to efficiently dump a huge MySQL innodb database?

I got an Ubuntu 10.04 production MySQL database server where total size of database is 260 GB while size of root partition is itself 300 GB where DB is stored, essentially means around 96% of / is ...
2
votes
1answer
437 views

Which is more durable? MyISAM or InnoDB with innodb_flush_log_at_trx_commit=0 [closed]

I am trying to determine the difference in durability between MySQL's MyISAM and InnoDB when innodb_flush_log_at_trx_commit=0. I am aware of the some of the benefits of InnoDB with ACID. However, ...
1
vote
0answers
665 views

mysqld service crashes on restart, after importing mysqldump #innodb

I have 2 mysql servers. Let's call them server01 & server02. Both have the same configuration: mysqladmin Ver 8.42 Distrib 5.1.61, for redhat-linux-gnu on x86_64 [client] default-character-set=...
1
vote
1answer
532 views

Intermittent blocking mysql query

I have a big problem on our server which host about ten magento website. I make all obvious optimizations like APC for Opcode, APC for cache backend, innodb settings tuning, magento compilation, etc. ...
1
vote
1answer
2k views

Mysql migrate huge db from innodb to ndbcluster Err: the table is full

I'm trying to migrate old database to mysql cluster (4 data nodes) by using command: ALTER TABLE sample ENGINE=NDBCLUSTER but I'm getting the following error: The table '#sql-7ff3_3' is full There ...
1
vote
1answer
491 views

Issue with percona-xtrabackup-2.0.0 hotbackup on MyIsam tables

I am trying to implement hot backup for MyIsam tables with "percona-xtrabackup-2.0.0" and getting the following error? As the all tables are MyIsam I doubt am I using the correct package ? Backup :...
6
votes
1answer
3k views

MySQL show table status always returns Data_free 17825792

When I execute SHOW TABLE STATUS databaseName; I get Data_free info with 17825792 value in all tables : | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | ...
1
vote
0answers
307 views

Simple UPDATE query with (sometime) long query times

I run a dedicated MySQL server (2 cores, 16GB RAM) serving 100-200 requests per second. It is getting sluggish during peak traffic and I have a hard time optimizing the server. So I'm looking for some ...
1
vote
0answers
503 views

Mysql innoDB corruption after server crash

Yesterday my server died because an outage in the data center. Today it's back up, but having some problems with mysql. First of all my mysql server was not able to start. For this reason I deleted ...
3
votes
1answer
376 views

mysql 5.1 - innodb - query_cache_size - 9,418,108 queries have been removed from the query cache due to lack of memory

Currently running on a 16GB system - Ubuntu 64 bit. INnodb Buffer Pool is set to 10GB. tuning-primer shows the following: QUERY CACHE Query cache is enabled Current query_cache_size = 512 M Current ...
4
votes
1answer
10k views

mysql - can't drop table does not exist, can't create table exists

After a server crash we are having some very strange issues with one particular table reference. Opting for a restoration from backup the database was dropped and a backup SQL dump loaded, only this ...
0
votes
1answer
3k views

MySQL too many connections during normal conditions (Percona, InnoDB)

We're getting too many connections errors in normal conditions, so I'm assuming it's a configuration issue. Four webservers, not using persistant connections partly because that triggers to the too ...
1
vote
0answers
460 views

MySQL InnoDB: Assertion failure ibuf0ibuf.c line 4185 unrecoverable data crash

I get this assertion failure on MySQL 5.5.15 version. Here are the MySQL server errors: 110927 21:56:51 InnoDB: Assertion failure in thread 1126107456 in file ibuf0ibuf.c line 4185 InnoDB: Failing ...
3
votes
2answers
2k views

Can fragmented MySQL innodb tables cause I/O issues? “task hung for 120 seconds” crashes?

Large innodb databases with load spikes seem to be causing random crashes with "task hung for 120 seconds" in the console. There are no logs being written to the system during these crashes. The ...
2
votes
0answers
5k views

Temporary MySQL Error: 1286 Unknown storage engine 'InnoDB'

I operate a cPanel/WHM server on CentOS 5.8 which is running MySQL 5.5.24. It seems that ever other week or so, some clients websites exhibit the following error: SQLSTATE[42000]: Syntax error or ...
0
votes
1answer
498 views

Why does MySQL use a different index for my query in different versions?

I have a large-ish InnoDB table (about 800MB), and I'd like to count rows. I know SELECT COUNT(*) has issues in InnoDB, but one of the solutions I've seen is to create a secondary index, which is ...
10
votes
5answers
726 views

MyISAM for data reads

I have a table with around 1 Billion rows, and its 98% read intensive. I tried tuning the database, with different storage engines (MyISAM and InnoDB) Then ran a few test to view the performance In ...
1
vote
1answer
157 views

Can I use a newer InnoDB plugin in Ubuntu MySQL?

The MySQL that comes with Ubuntu 10.04.2 is 5.1.41, which is distributed by MySQL with InnoDB 1.0.5. But for some reason Ubuntu ships it with InnoDB 1.0. Can I install InnoDB 1.0.5 (or newer?)
5
votes
2answers
4k views

Reclaim disk space after deleting Magento MySQL database

I needed to reclaim some disk space so I removed an old Magento database from my server. The database size was around 16 GB. I was surprised that once the database was deleted, it did not really free ...
2
votes
1answer
156 views

How do I backup a database to a .sql statement?

How do I backup a database to a single SQL file? After it's backed up, how can I load it/restore the database with InnoDB? It must be InnoDB.
0
votes
2answers
798 views

What causes “InnoDB: Corruption of an index tree” error

Today I experienced this error a second time in two weeks and I wonder why that is? Is it more a hardware- or software-related thing? (e.g. what should I check?) That DB server didn't have any ...
1
vote
1answer
1k views

Issue with InnoDB engine while enabling and [ skip-innodb ] - [ERROR] Plugin 'InnoDB' init function returned error

In production server as of now we are running with MyIsam tables only, hence we have disabled the innodb engine with skip-innodb option. But now onwards we need to enable the innodb engine as well for ...
2
votes
2answers
3k views

MySQL InnoDB ext3 block size

I'm looking for recommendations for ext3 filesystem block size for MySQL 5.6 using InnoDB. Running a CentOS 5.4 VM in VMware ESXi 5, VMFS 5 datastore on NetApp FibreChannel LUNs (which have 4k chunk ...
1
vote
2answers
6k views

Unknown table engine 'InnoDB' error

When I start my mysql it gives the following error on the log file. My default engine is MyIsam and I am using Innodb for a set of DB s only. 120604 12:24:49 mysqld_safe mysqld from pid file /var/...
4
votes
2answers
606 views

MySql Data Loss - post mortem analysis - RackSpace Cloud Server

After a recent 'emergency migration' of a RS cloud server, the mysql databases on our server snapshot image proved to be days out of date from the backup date. And yet files that were uploaded ...
3
votes
2answers
1k views

Mysqld InnoDB crash

my MySQL server just crashed and I cannot restart/recover it. I've tried: /etc/init.d/mysql restart Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld . . . . . . . . . . ...
2
votes
2answers
2k views

Unknown table engine 'InnoDB' after deleting ibdata1 file

I was having innodb with one ibdata file. i have changed it in my.cnf to have ibd file for every table (innodb_file_per_table). then i run the following query on all of my innodb tables to have its ...
-2
votes
1answer
135 views

Mysql server setup configuration [closed]

We have a new centos 6.2 setup. Below is the configuration file. The machine is going to be fully innodb and it has 8Gb ram. What else must I include in the .cnf? I know one major thing is the ...
2
votes
2answers
2k views

Whats the best practice for defragmenting a MySQL InnoDB table in production?

A lot of my Innodb tables require 'defragmentaion'. My understanding is that 'OPTIMIZE' may not be the best way to do it. Some people suggest doing a 'ALTER TABLE' to have Mysql rebuild (and therefore ...
4
votes
2answers
7k views

Why is MySQL is using so many temporary tables?

Can any configuration mistake lead to creating too many temp tables by mysql..mysql tuner shows Current max_heap_table_size = 200 M Current tmp_table_size = 200 M Of 17158 temp tables, 30% were ...
4
votes
1answer
7k views

Is it safe to modify innodb_data_file_path value for mysql 5?

I recently experienced data corruption after changing the value of this parameter in my.cnf from : innodb_data_file_path = ibdata1:10M:autoextend:max:128M to : innodb_data_file_path = ibdata1:10M:...
5
votes
2answers
2k views

MySQL InnoDB table shows a negative number of rows in phpMyAdmin

I just converted a MyISAM table to InnoDB with around 1.4 million rows. When I converted it to InnoDB, it now shows -1.4 million rows. The table still works as expected, but why does it shows ...
0
votes
4answers
9k views

Unable to enable InnoDB in mySQL on Ubuntu 10.04

I am trying to enable InnDB on my linux server. I have installed Ubuntu 10.04 JeOS on an ESX server. I then installed mySQL and tomcat using aptitude. However when I use SHOW ENGINES; in mySQL it ...
5
votes
2answers
6k views

Disk I/O utilization up to 100% after tuning InnoDB-related MySQL configuration

I have added following lines to "my.conf": query_cache_size=128M innodb_buffer_pool_size=512M innodb_flush_method=O_DIRECT After that Disk utilization started raising, reached 100% and holds steady, ...
0
votes
1answer
2k views

Safe conversion from one InnoDB(ibdata) file to innodb file per table

I have MySQL database with tables on InnoDB engine. But server is configured to use only one file ibdata0 without parameter innodb_file_per_table. I want to change this without making dump and restore ...
0
votes
2answers
1k views

MySQL InnoDB database 'hangs'

I have a problem with a MySql server causing it to freeze all the time. In phpMyAdmin when this happens I can see in "Show Processlist" are lots of processes for User "unauthenticated user" with ...
1
vote
1answer
164 views

MySQL in VMWare Ubuntu 11.10 64bit, Configuration

Can anyone suggest an optimal setting for what I'm doing? (Note that this is a one time job, after finishing my code, I'll put this back to development setting.) I am setting up a 64bit Ubuntu 11.10 ...
5
votes
1answer
7k views

MySQL, check & enable binary logs

I am running MySQL 5.1.47 on CentOS. How do I check if binary logging for InnoDB is active? How do I enable binary logging if they are not enabled? Just run? mysqld --log-bin
2
votes
1answer
2k views

MySQL write intensive setup, kjournald performs a lot of I/O

I have a MySQL (actually, MariaDB 5.2) setup deployed on a Rackspacecloud 4Gb node. All tables are InnoDB, InnoDB buffer pool size is 2G and it is 95% full most of the time. I use ext3 as a filesystem ...
0
votes
2answers
1k views

changing innodb_buffer_pool_size makes error

i want to increase my innodb_buffer_pool_size value to get some more performance and when i try, my select queries arises error such as "Incorrect information file in .." i'm just adding ...