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

learn more… | top users | synonyms

0
votes
2answers
1k 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 ...
0
votes
2answers
803 views

Will dropping AUTO_INCREMENT rebuild table in MySQL?

I've got table with following schema: CREATE TABLE `tblsomething` ( `something_id` int(11) NOT NULL AUTO_INCREMENT, … PRIMARY KEY (`something_id`) ) ENGINE=InnoDB AUTO_INCREMENT=144620955 I ...
0
votes
1answer
112 views

how to permanently increase innodb_buffer_pool_size on ubuntu

I have read lot of posts & manuals to try to find out how to increase memory in mysql 5.6 on Ubuntu, which say there are 3 methods: by editing innodb_buffer_pool_size in the my.cnf by command ...
0
votes
1answer
118 views

Mysql crashed, dumped DB's in recovery mode. What now?

I ran into an InnoDB issue that only seemed to get worse as I tried to fix it. Started with InnoDB: Unable to lock ./ibdata1, error: 11, I moved and then copied it back. I soon had an ib_logfile issue ...
0
votes
1answer
61 views

Check if MySQL configuration was applied

I'm performing some heavy MySQL operations at my VM and constantly getting the following error: SQLSTATE[HY000]: General error: 1206 The total number of locks exceeds the lock table size I ...
0
votes
1answer
84 views

Setting innodb_buffer_pool_size in for Mysql

We have a dedicated DB box with with 8 GB of RAM and running Redhat linux 64 bit OS. Our MySQL Data + Index size almost 7.8 GB. About setting innodb_buffer_pool_size, I have read 2 suggestions Set ...
0
votes
1answer
510 views

MySQL “Too many connections” + > 6000 queries / second

We have quite a big mysql (innodb) database with a lot of insert queries and 6000 queries per second. Settings are: max_connections = 1000 and usually when i do show status like '%onn%'; ...
0
votes
1answer
3k 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
4answers
1k 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 ...
0
votes
1answer
971 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
1answer
735 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
0
votes
3answers
1k views

MySQL server not starting up

I have a server running CentOS 5.5 x86_64, and have recently installed MySQL Server via YUM, but when starting the server I get: [root@server etc]# service mysqld start Warning: World-writable ...
0
votes
1answer
582 views

Moved mySQL to an EBS volume, now innoDB performs very slowly

Hello has anyone had a similar problem to this.. I've set up a new instance on Amazon EC2 for a client. I've also attached a 250GB EBS volume to hold the files and configured mySQL to use the EBS ...
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 ...
0
votes
3answers
133 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 ...
0
votes
2answers
174 views

MySQL - Innodb, search

I recently switched from myisam to innodb in one of my mysql tables. Before i was using MATCH(). Since innodb doesn't support match() i decided to use LIKE. Now I have a problem. My table is 190,6 ...
0
votes
2answers
999 views

Is it ever safe to set innodb_flush_log_at_trx_commit=0?

I have a server (Dell PE2950) with a battery-backed write cache on the raid controller. Is it safe for me to set innodb_flush_log_at_trx_commit=0 on a mysql server with data files stored on a raid0 ...
0
votes
1answer
46 views

InnoDB “Table xx Is Full” during database alterations

I am running Percona Mysql Server 5.6.14-56 on CentOS 6.3 64bit. Server has plenty ram (96gb) and storage free. File system type: ext4 dev/sda6 ext4 1093623528 56576512 981494148 6% ...
0
votes
1answer
96 views

MySQL crashing at service start. Hit a bug? DB corruption?

I've a web server that's offline at this moment because MySQL fails to start with an exception. I can't find the root cause of the problem, but I'm afraid of database corruption crashing the MySQL ...
0
votes
1answer
53 views

Set MySQL innodb buffer pool size on IIS7

I am using VPS, Windows 2008 r2, IIS7, MYSQL 5.1.73, Hardward Config: Ram 2GB , Hardisk 40GB On this VPS only 1 .NET application is running. Application is currently using by only 5 users. I found ...
0
votes
1answer
79 views

Re-ocurring issue with keys on temp tables

We run a large forum with lots of reads and writes, particularly to the posts and topics tables which are both innodb. Last week I started doing 12 hourly backups with innobackupex because mysqldump ...
0
votes
1answer
1k views

Is enabling MySQL query_cache_size Innodb Lock Safe?

The query_cache_size looks like the kind of setting that one would usually want enabled which puzzled me since it defaults to 0. Then I read the following about the query_cache_wlock_invalidate ...
0
votes
1answer
840 views

restore mysql from ibdata/frm files

A hard disk failure has left me trying to restore mysql from copy of "data" folder I had dumps of "most" content but am missing some Data folder has idbdata1 / log files / folders of .frm files So, ...
0
votes
1answer
138 views

Large InnoDB data size even though entire database is MyISAM?

I'm running mysqltuner to tune up my database and I'm running into a very strange occurrence. Even though the entire database is MyISAM (all tables) it says the following: [!!] InnoDB data size / ...
0
votes
1answer
731 views

Cannot stop MariaDB on Ubuntu Lucid

On starting MariaDB 5.5 I am getting the following error: InnoDB: Unable to lock /var/lib/mysql/ibdata1 Initially ran into this error after a server reboot was done running MariaDB 5.1. Have ...
0
votes
1answer
2k views

Reducing memory usage of MySQL

Conclusion: if you really want to use little memory out-of-the-box drop MySQL and use PostgreSQL: it has a ~30Mo memory footprint, i.e. more than 10x less than MySQL; the migration was quite easy be ...
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 ...
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
1answer
133 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 ...
0
votes
1answer
246 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 ...
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: ...
0
votes
2answers
720 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 ...
0
votes
1answer
266 views

mysql innodb broken, after hostname change

Gents, Have a mysql cluster down right now... in dev, but down nonetheless. This occurred after a hostname change on both nodes. InnoDB: Check that you do not already have another mysqld process ...
0
votes
1answer
441 views

How to prevent InnoDB log files from getting corrupted?

We run a MySQL server using 600GB of storage over 4 EBS volumes on Amazon EC2. About every 2-3 weeks, the active InnoDB log file gets corrupted, and MySQL won't allow any access on those tables ...
0
votes
1answer
265 views

Measuring Performance through SHOW INNODB STATUS;

When looking at the output of SHOW INNODB STATUS on mysql what are the most important values to be looking at, and what would be an indicator of poor performance? Specifically under FILE I/O and ...
0
votes
1answer
214 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 ...
0
votes
1answer
195 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. ...
0
votes
1answer
3k 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> = ...
0
votes
1answer
143 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) ...
0
votes
1answer
919 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 ...
0
votes
2answers
728 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 ...
0
votes
1answer
190 views

mySQL process overloading server - Need Help

I ran into an issue the last few days, I have a database server 2 Quad Core Processors and 24 gb of ram, recently we have come across a big issue the server is running normally at about 130% cpu then ...
0
votes
1answer
822 views

MySQL innodb has lots of processes hanging in “update” state once every minute

Description of problem I have a fairly large MySQL installation. There are at least 3 separate servers which run the innoDB storage engine. Once every minute, at the same time each minute, for about ...
0
votes
1answer
3k views

Fail to set innodb as default engine on Ubuntu 10.04

I've got a problem setting innodb as the default database engine in MySQL 5.1 on Ubuntu 10.04. As soon as I switch to innodb as default engine the server refuses to start. This is what I get in the ...
0
votes
1answer
720 views

MySQL Server - Got error -1 from storage engine

I am currently trying to restore a MySQL table from the .ibd file. I have been following the instructions on the MySQL reference manual on how to use DISCARD and IMPORT TABLESPACE to replace the .idb ...
0
votes
1answer
131 views

Column locking in innodb?

I know this sounds weird, but apparently one of my columns is locked. select * from table where type_id = 1 and updated_at < '2010-03-14' limit 1; select * from table where type_id = 3 and ...
0
votes
1answer
523 views

Mysql- “FLUSH TABLES WITH READ LOCK” started automatically

I would like to understand how this happened. I was running a query that would take a long time, but should not lock up any table. However, my dbs were practically down - it seems like it was being ...
0
votes
1answer
700 views

InnoDB table locks without apparent reason

I have an InnoDB table for visitors' counting, which has perfectly worked for several years, but it failed twice yesterday, may be cause of the increase of visitors Without apparent reason, this table ...
0
votes
4answers
382 views

MySQL InnoDB unrecoverable crash

Whenever I start MySQL server 5.1.33 or 5.1.40 (developers build) and try to read from one table the server crashes with this message in log files: InnoDB: Error: (1500) Couldn't read the MAX(userFK) ...
0
votes
2answers
20 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 ...