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

learn more… | top users | synonyms

0
votes
1answer
192 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
230 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 ...
1
vote
1answer
13k 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 /...
3
votes
1answer
2k 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
2k 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 [...
5
votes
2answers
3k views

INNODB mysql. Plugin disabled [duplicate]

When I startup mysql on my unbuntu server I will get a message. 121122 17:39:37 [Note] Plugin 'FEDERATED' is disabled. 121122 17:39:37 InnoDB: The InnoDB memory heap is disabled 121122 17:39:37 ...
2
votes
2answers
3k views

After adding skip-innodb mysql doesn't start

I am trying to setup these values: #skip-bdb #skip-locking #skip-innodb When I add them to /etc/mysql/my.cnf and even if I turn ON of of, them after I do the service restart mysql fails to start, ...
-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
4k 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
313 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
520 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
1k 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 ...
1
vote
1answer
437 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
0answers
181 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 ...
4
votes
2answers
2k views

Migrating from MyISAM to XtraDB

Just a few questions that I just can't find anywhere about migrating to XtraDB. My group has been using MyISAM dbs for production and was wondering how hard is it to migrate to Percona's XtraDB and ...
1
vote
0answers
295 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 ...
1
vote
2answers
2k 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 ...
3
votes
1answer
310 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 ...
3
votes
1answer
6k 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
2k 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 ...
0
votes
2answers
4k 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 ...
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 ...
0
votes
1answer
218 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 ...
1
vote
3answers
149 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 ...
9
votes
5answers
462 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 ...
0
votes
2answers
17k views

Optimal MySQL my.cnf setting for large Magento site on a dedicated server

Our dedicated server is running a large Magento store with a MySQL database approximately 250MB in size. The server spec is listed as having 5 Xeon 2Ghz processors (4MB cache) and 12GB of memory. I'...
1
vote
1answer
140 views

How can I uniquely pop from a MySQL InnoDB table without race hazard issues? [closed]

How can I improve the following code with row locking / stored procedure. UPDATE `data` SET status=':temp_status' WHERE account_id = :account_id AND dataset_id=':dataset' AND status=':source' LIMIT $...
1
vote
2answers
1k views

large number of InnoDB tables plus SHOW TABLE STATUS

We've got several hundred InnoDB tables in a database, and we use phpMyAdmin to manage them. Unfortunately, phpMyAdmin does a SHOW TABLE STATUS query whenever the list of tables is shown, and this ...
9
votes
3answers
5k views

Do InnoDB tables got locked during mysqldump when mixed with MyISAM?

I'm looking for a backup solution for my mysql servers and I need as less downtime as possible. I have the following: MySQL servers they are not replicated each server stands for its own This ...
5
votes
2answers
3k 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 ...
4
votes
2answers
3k views

MySQL Slow Writes

Inserts into the following table are taking up to 70 seconds to complete: CREATE TABLE IF NOT EXISTS `productsCategories` ( `categoriesId` int(11) NOT NULL, `productsId` int(11) NOT NULL, ...
1
vote
1answer
642 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 ...
0
votes
1answer
292 views

In MySQL 5.1 InnoDB, does the maximum length of a VARCHAR affect secondary index size? [closed]

Assuming the data is the same either way, does the maximum length of the VARCHAR affect the space usage of a secondary index? Does InnoDB use fixed length records for indexes? Assume that we're ...
2
votes
0answers
4k 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 ...
1
vote
2answers
4k views

innodb recovery from .ibd files

My website has crashed a few days ago. The hosting company says some innodb database crashed. They sent a MySql data folder. I tried to restore the database, but phpmyadmin is only showing MyISAM ...
0
votes
4answers
2k views

Percona-xtrabackup hot backup issue with MyIsam Engine

We are running with the MyIsam Engine and Percona-xtrabackup is throwing the following error as the inndb engine is skipped [ my.cnf skip-innodb]. How could I resolve this issue with out enabling the ...
2
votes
2answers
2k 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
5k 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/...
1
vote
1answer
405 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 :...
4
votes
2answers
545 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 ...
0
votes
2answers
417 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 ...
2
votes
2answers
597 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
1answer
132 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 ...
4
votes
2answers
5k 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
4k 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:...
8
votes
2answers
18k views

How big is too big for ibdata file?

My ibdata file is very large, at least it seems to me to be very large. Is this excessive or not that bad? -rw-rw---- 1 mysql mysql 15G Apr 18 10:11 ibdata1
2
votes
3answers
97 views

Innodb statistics

We're running InnoDB as a MySQL engine and using phpMyadmin to administer our database. Under Status → Query statistics, phpMyadmin gives us the following: We would like to know where these figures ...
23
votes
5answers
62k views

Unknown/unsupported storage engine: InnoDB | MySQL Ubuntu

I recently upgraded from the previous LTS Ubuntu to Precise and now mysql refuses to start. It complains of the following when I attempt to start it: ╰$ sudo service mysql restart stop: Unknown ...
0
votes
2answers
5k views

MySQL server crashes InnoDB

Today we got some DB crash. The DB is InnoDB. At firstin log: 120404 10:57:40 InnoDB: ERROR: the age of the last checkpoint is 9433732, InnoDB: which exceeds the log group capacity 9433498. InnoDB: ...
5
votes
2answers
2k 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,...