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

learn more… | top users | synonyms

0
votes
2answers
395 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 ...
0
votes
2answers
3k views

Huge #sql-xxxx_xxxx.ibd files in mysql-data folder

On one of our mysql databases the size on disk is way larger (28GB) than the actual data (~5GB) so I had a closer look to the files contained in mysql-data I see the following files 12K ...
0
votes
1answer
84 views

Should I upgrade memory for my dedicated server?

My memory usage hangs around 25% (swap is generally 1%) on my dedicated server and load is around 2-5. My host recommended that I upgrade from 2GB of ram to 4GB so that I can increase my ...
0
votes
2answers
268 views

MySQL: Increased buffer pool, ibdata1 corrupt?

I tried increasing innodb_buffer_pool_size via my.cnf from default 128m to 256m, but on restart attempt, mysql shutdown failed with: 130125 11:49:55 InnoDB: Initializing buffer pool, size = 256.0M ...
0
votes
2answers
14k 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. ...
0
votes
2answers
1k views

SHOW ENGINES; does not list InnoDB

Since yesterday, my InnoDB tables in my Mysql installation on Ubuntu don't work anymore, I tried to open them using Navicat, but I get the "Unknown Table engine 'InnoDB'" error. When I try listing ...
0
votes
1answer
172 views

Strange MySQL table problem

I have copied the /var/lib/mysql/mydbname db to a new machine from a crashed server (booted using a live cd) but now I cannot access the tables within the db... All the tables only have a .frm ...
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
817 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
293 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
179 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
90 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
91 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
582 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
1k 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
885 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
587 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
137 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
1answer
1k 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
177 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
1k 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
116 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
168 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
74 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
108 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
990 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
5k 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, ...
0
votes
1answer
145 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
822 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
154 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
263 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
778 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
270 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
513 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
274 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
223 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
2answers
664 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
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
147 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
2answers
748 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
199 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 ...