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

learn more… | top users | synonyms

0
votes
2answers
137 views

mysql error InnoDB: 13

mysql not started @ server boot automatically but I can start manually as long as log as user "mysql" by using "/etc/init.d/mysql.server" the error I got on the log is InnoDB: Operating system error ...
0
votes
0answers
651 views

InnoDb In Use due to InnoDb_buffer_pool_size

I'm trying to increase my innodb_buffer_pool_size in my.cnf as I have a mysql database that is about 1.5GB on an 8GB VPS. If I increase it to over 512MB, then innodb seems to fail to start, and all ...
1
vote
1answer
237 views

fine tuning of my.cnf for InnoDB tables fails with setting of: `innodb_log_file_size=256`

I read some fine tuning recommendations on the mysqlperfomanceblog and tryed to adapt them. I added to my.cnf: innodb_buffer_pool_size = 1000M innodb_log_file_size = 256M After ...
2
votes
3answers
2k views

How to detect if InnoDB has pool size big enough?

I found out how much the innodb pool size has allocated memory from show innodb status but I couldn't figure out how much actually it uses. Maybe it needs more or I can take some memory off from it? ...
0
votes
1answer
224 views

Mysql : Cannot create Index:

Hi all we are having trouble to create/drop index(s) on a table I keep getting the following error: ERROR 1280 (42000): Incorrect index name '<>' Now the table has the following: 1. PRIMARY ...
5
votes
1answer
6k views

MySQL: InnoDB: ERROR: the age of the last checkpoint is X, which exceeds the log group capacity Y?

In a production MySQL environment the following error message is written to /var/log/mysql/error.log every fourth minute: 110723 18:36:02 InnoDB: ERROR: the age of the last checkpoint is 9433856, ...
0
votes
1answer
170 views

Cannot start MySQL on windows box with named pipes

I've installed MySQL server on Windows although in the configuration have selected to not run MySQL as a server and have disabled TCP/IP access so only named pipes can be used, I'm now having problems ...
1
vote
2answers
413 views

Copying /var/lib/mysql files over resulted in InnoDB corruption

My server had to be re-installed yesterday so they replaced the hard drive and hooked the old one up via USB. I grabbed the database files (/var/lib/mysql) and downloaded them and then I erased all ...
1
vote
3answers
690 views

MySQL / InnoDB replication: how to perform crash recovery?

How do I perform crash recovery in a MySQL/InnoDB Master-Slave asynchronous replication setup? Specifically: If a slave crashes, how do I make it syncs up with the master after I bring it back up? ...
0
votes
1answer
419 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 ...
0
votes
1answer
171 views

MySQL 5.1 to 5.5 Upgrade - InnoDB question

I posted this on stackoverflow, but was advised that here might be better... I am planning an upgrade of some MySQL servers (5.1 to 5.5). I am aware that the InnoDB plugin is now built in to MySQL. ...
2
votes
2answers
347 views

MySQL not using specified RAM anymore

A few days ago I got a new machine setup running CentOS 5.6 (64bit), with 12GB ddr3 ram, 4x SAS 15k rpm drives in RAID10. On this machine I'm running MySQL Server version: ...
2
votes
0answers
103 views

lost tables in drupal site database

i have drupal site on my local server build using pressflow i had problems with the xammp 1.7.4 server so i delete it except the mysql and htdocs folders i installed the server again but the drupal ...
0
votes
2answers
390 views

MySql is not picking up changes to my.cnf file on a custom Ubuntu AMI. How do I fix this?

I created an AMI from my running EC2 Ubuntu instance. I then brought it up, and MySql is not running the same way on this copied instance. 1) Changes to my my.cnf file are not getting picked up. ...
3
votes
1answer
160 views

How much disk space does innodb need to ALTER TABLE

I have a large InnoDB table that I want to alter by adding a small column to. I'm prepared to wait a while, but I'm wondering how much disk space will the ALTER TABLE command consume while it's ...
0
votes
0answers
283 views

How do i enable innodb on ubuntu server 10.04

Here is my entire my.cnf [client] port = 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least ...
1
vote
1answer
91 views

MySQL - Best Engine(s) for 2 Tables - One running heavy updates, 1 keeping a 15 minute log

I have a system where users are submitting work to my server frequently. With 1500 active at one time, it's about 6000 units of work being submitted per minute. I've been using one large table to ...
1
vote
1answer
306 views

MySQL InnoDB random data corruptions: hardware or software errors?

I'm an administrator of a social game which uses MySQL(Percona 5.1.56 to be precise) for data storage(all tables have InnoDB type). There are about 2 millions of players in the game and database size ...
0
votes
1answer
2k views

MySQL crash with long semaphore wait

A MySQL-server crashed here yesterday, and I'm not sure why (the most irritating kind of crash). The error log is full of Semaphore waits, but I don't know how to interpret most of it (<path> = ...
2
votes
2answers
875 views

Why ibdata1 is still growing when I have used innodb_file_per_table in MySQL 5.1

All my table in the db are created after I enabled the option "innodb_file_per_table", so I don't understand why ibdata1 is still growing from time to time, even with a very slow speed.
1
vote
1answer
102 views

mysql innodb index creation for foreign keys

INNODB automatically creates an index on foreign key fields. Is there a storage engine that allows me to disable that? My googling on xtradb doesn't give me positive results. Perhaps, it is possible ...
1
vote
2answers
394 views

Switching To `innodb_file_per_table` In MySQL

If I turn on innodb_file_per_table (not currently active), will it destroy my existing tables?
0
votes
1answer
139 views

MYSQL delete optimization

I have the following delete SQL statement: delete w,r from table1 w, table2 r where (w.status=1 or r.status=1) show engine innodb status shows the following. is the read rate(237.29 reads/s) ...
2
votes
1answer
925 views

InnoDB options crashing mysql start AND mysql tuning

I have an innodb on a Ubuntu 10.10 server running on an ESXi platform. I have dedicated 8 CPUs, 32 Gigs of ram, and files stored in a Raid 5 HP SAN of SAS 10k rpm disks. I'm expecting FAST queries! ...
2
votes
1answer
639 views

show table status not showing innodb tables

After a server reboot I noticed that phpMyAdmin was not showing my innodb tables, just the myisam. I logged into mysql server directly and while show tables is showing the innodb tables, when I use ...
0
votes
1answer
1k views

Mysql: Innodb error when migrating mysql from linux to windows

I have migrated my data directory for an InnoDB mysql server from a linux machine to a windows machine. I started the server up, selected the database, and tried to query a table. Got the error "Table ...
1
vote
1answer
570 views

Will innodb benefit from memcached?

from - http://www.readwriteweb.com/hack/2011/04/you-got-nosql-in-mysql-memcach.php (correct me if does not make sense) potential benefits saving complex query calculation into distributed ...
1
vote
1answer
978 views

MySQL InnoDB: how to switch to Barracuda format?

In new MySQL versions Barracuda file format was introduced. So I havew a few questions: Is it working only with file_per_table option? How to switch existing system to it (preferably the whole ...
0
votes
3answers
121 views

Explaining the MySQL Indexing

On my journey exploring MySQL and its advanced features, especially regarding the performance optimization I bumped in some extremely important feature for SQL performance improvement mos of us knows ...
1
vote
2answers
306 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 ...
2
votes
1answer
2k views

Mysql InnoDB optimisation

(asked on stackoverflow but was suggested to move here!) I'm having some trouble understanding InnoDB usage - we have a drupal based DB (5:1 read:write) running on mysql (Server version: ...
1
vote
1answer
84 views

Limiting space for a MySQL user

I maintain a MySQL server. There is one user whose database size has very quickly grown enormously. Since he is using InnoDB, the /data/mysql/ibdata1 file has grown out of porpotions. I could mount a ...
2
votes
1answer
792 views

innodb memory usage mysql

I have a small vps, with only 256mb of ram, with maximum burst up to 512mb. When I configure my vps without innodb, it only uses 130 mb of ram, so that is no problem for me. But when I turn on innodb, ...
2
votes
1answer
363 views

CHECK TABLE locking a large (12GB) InnoDB table on MySQL

I'm having problems with a large MySQL InnoDB table and I was wondering if anyone here had advice for improving stabililty. The issue that I'm having is that CHECK TABLE ... FAST will lock the table, ...
6
votes
2answers
2k views

Good/Better config for MySQL on an EC2 Large Instance

I have an EC2 Large instance dedicated to MySQL. It will be serving a Joomla/Magento combo so it has a blend of InnoDB and MyISAM tables. I have only worked with MyISAM in the past and am therefore ...
1
vote
2answers
183 views

mysql queries not working suddenly !

When I do simple select or insert it says- Unknown table engine InnoDB It was working properly just few days back.what it's suddenly gone wrong ?
1
vote
1answer
265 views

Mysql InnoDB recovery, transferred from a dead Mac to Windows

After a Mac server crashed, I'm scrambling to recover records from an InnoDB table. All tables shared a single data file. I've copied ibdata1 and the two log files over to a new mysql server hosted ...
4
votes
1answer
939 views

Changing MySQL tmpdir kills InnoDB functionality

I've got a query that keeps failing because I don't have enough temporary space available. So, I created a directory on a different partition at /data/tmp, chmoded this directory to 777, and updated ...
4
votes
2answers
712 views

MySQL 5.5.9 Query Cache not working when schemas have hyphens (“-”) in their name

I am running MySQL 5.5.9 x86_64 RPM as downloaded from mysql.com. Running on CentOS 5.5 Xen DomU. I have enabled the Query_cache however MySQL NEVER uses it. All of my tables are InnoDB. Why is the ...
4
votes
2answers
2k views

Simpler way to convert all tables from InnoDB to MyISAM

Previously, I use this: USE dbname; ALTER TABLE tablename ENGINE=MYISAM; I'm looking for simpler way to convert all tables in a database, rather than writing every table name one by one
3
votes
2answers
2k 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
vote
3answers
2k 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 ...
1
vote
1answer
1k views

How do you load a database with foreign keys on the master without out breaking replication?

I have a MySQL master-slave setup. One master; One slave; Lots of databases. I'm moving an app into this setup from third party. They provided a mysqldump file of the data and database structure. It ...
0
votes
1answer
597 views

Unable to start mysqld due to inability to allocate memory

I'm unable to start mysqld due to it being unable to allocate enough memory. I've installed the DB using the defaults: sudo mysql_install_db --user=mysql Then when I try to start mysqld, I get ...
1
vote
4answers
12k views

Setting a time limit for a transaction in MySQL/InnoDB

This sprang from this related question, where I wanted to know how to force two transactions to occur sequentially in a trivial case (where both are operating on only a single row). I got an ...
0
votes
2answers
295 views

Can transactions be forced to occur sequentially in MySQL?

Let's say that I have two servers that simultaneously initiate a transaction on a MySQL 5.5 database using InnoDB. Both transactions do the same thing: Read a single row, then update the row based on ...
2
votes
4answers
2k views

MySQL: how to convert many MyISAM tables to InnoDB in a production database?

We have a production database that is made up entirely of MyISAM tables. We are considering converting them to InnoDB to gain better concurrency & reliability. Can I just alter the myISAM ...
1
vote
1answer
1k views

what is gen_clust_index used for in mysql?

It seems I have a deadlock in mysql (running innodb) that's due in part to a lock on gen_clust_index, however, this isn't a table that I've created. So... what's the short and sweet description of ...
0
votes
1answer
194 views

A Most Puzzling MySQL Problem: Queries Sporadically Slow

This is the most puzzling MySQL problem that I've encountered in my career as an administrator. Can anyone with MySQL mastery help me a bit on this?: Right now, I run an application that queries my ...
6
votes
1answer
2k views

how to disable keys in mysql innodb

how to disable keys in mysql innodb? or is this not possible? why?