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

learn more… | top users | synonyms

-1
votes
0answers
22 views

How to acheive Concurrency in mysql when there is 500+ request simultaneously to the server

I am using Mysql (InnoDb), in this I am facing problem when we checked the curl request upto 500 connection at a time (simultaneously) but when we try more than that then my servers goes to idle ...
0
votes
0answers
25 views

How to fix mysql error InnoDB?

[root@localhost ~]# tail -f /var/log/mysqld.log 140316 5:14:01 [ERROR] Plugin 'InnoDB' init function returned error. 140316 5:14:01 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. ...
0
votes
2answers
52 views

MySQL's InnoDb performance downfall

I'm trying to configure a MySQL production server using InnoDb and I can not get the performance I want out of it. I've used Percona tools to give me the following configurations: [mysql] # CLIENT # ...
1
vote
0answers
21 views

mariadb 5.5.36 with innodb plugin

I installed mariadb 5.5.36 on a win32 system. Everything runs fine except innodb requests are 2 x slower than an identical MySQL installation. So I want to switch back to original innodb plugin to ...
1
vote
1answer
53 views

changing mySQL (5.6) database from MyISAM to InnoDB

I have recently upgraded my CPanel server from mySQL 5.5 to mySQL 5.6 as it now supports full-text searches for InnoDB. Now, I'm not so great at mySQL so I was wondering is there anything special I ...
0
votes
1answer
18 views

Over 100% of stage done during DROP COLUMN

I'm running a DROP COLUMN on the primary key column (I know, it's terrible but I had to do it). There's a progress indicator: Stage: 1 of 2 'copy to tmp table' 107% of stage done I haven't been ...
2
votes
1answer
71 views

MySQL Periodically Crashing

MySQL Seems to be crashing quite often, I'd say every hour or so. The only thing running on this server that is using MySQL is a Drupal installation that I'm working on, there's only one person ...
1
vote
1answer
26 views

MySQL InnoDB buffer_pool_size not increasing?

There are no errors in the log file, but this doesn't seem to add up to me. Maybe I'm misunderstanding something: mysql> show variables like '%buffer_pool%'; ...
0
votes
1answer
68 views

Why is innodb engine disabled by default in ubuntu 13.10 mysql server?

We all know that InnoDB is the default engine as of MySQL 5.5 but ... for some reason an extra configuration file zentyal.cnf is included in MySQL's conf.d directory when installing mysql server ...
0
votes
0answers
80 views

MySQL 5.5 : Cannot drop database : Lost connection to MySQL server during query

After a huge crash of my mysql database, I've made a recovery, all is ok except one schema. In phpMyAdmin, this schema doest not cotains any tables, but we i ask mysql to drop the schema (drop ...
0
votes
1answer
20 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
0answers
113 views

MySQL (MariaDB) crashes frequently

I recently migrated an old server running MySQL to a new VPS running MariaDB 5.5. I don't have too much running on the server (just a few PHP sites) and free memory seems to be OK, but the DB keeps ...
0
votes
0answers
122 views

MySQL 5.6 Create Table VERY slow

I recently upgraded my MySQL server from 5.1 to 5.6 (running on CentOS 6.x). Ever since the upgrade, when I try to perform certain table tasks the queries take a REALLY long time. This is really ...
1
vote
1answer
56 views

MySQL Queries taking too long to execute

I have a database table, with 300,000 rows and 113.7 MB in size. I have my database running on Ubuntu 13.10 with 8 Cores and 8GB of RAM. As things are now, the MySQL server uses up an average of 750% ...
2
votes
1answer
55 views

innodb Table is full and autoexpand

Hi I use bacula and one of the tables is full: JobId 8946: Fatal error: sql_create.c:860 Fill File table Query failed: INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) ...
0
votes
0answers
48 views

MySQL Tables Disappearing

We're having some issues of tables "magically" disappearing. Here is the log file leading to the point of what seems to be the point of the table disappearing: 131103 9:08:39 InnoDB: Error: table ...
1
vote
2answers
100 views

MySQL SELECT query hangs

On my server I have 6 MySQL databases. They all power Wordpress websites. For some reason, 2 of these databases are not accessible. To my knowledge they use INNODB, but I can't confirm it as even ...
4
votes
1answer
71 views

How to drop an 8 GB InnoDB table smoothly without global locks

MySQL version: 5.1.63. I am about to DROP a bigger ~8 GB InnoDB table. Last week I dropped a four times bigger table on another machine and a global lock kicked in that took us down for ~90 seconds. ...
0
votes
2answers
1k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...
0
votes
1answer
46 views

mysql: unknown option '--skip-innodb'

In trying to disable innodb by adding this to mysql config [mysql] skip-innodb But I get the error shown in title.. I also tried to change [mysql] to [mysqld] with no luck. SHOW ENGINES: ...
0
votes
1answer
96 views

MySQL tmp tables: how to clean up diskspace after killing a copying to tmp table process?

i ran out of disk space while running an alter table on a large table. I restarted MySQL afterwards and checked the MySQL tmp dir. A show status like '%tmp%' lists 5 tmp files and 4 tmp tables. A df ...
0
votes
0answers
85 views

need assistance with my.cnf - 1500% CPU usage

I'm running into a few issues with our new database server. It is a HP G8 with 2 INTEL XEON E5-2650 processors and 32GB of ram. This server is dedicated as a MySQL server (5.1.69) for our intranet ...
0
votes
0answers
152 views

Mysql Innodb tablespace is missing for table

I got a bad error in a Mysql 5.6 installation. After a normal windows 7 boot up the database seems to be return with data of some days ago, moreover if I run "Show tables;" I got all tables but if I ...
0
votes
0answers
13 views

Innodb + 8K length row limit

I've a Innodb table with, amongst other fields, a blob field that can contain up to ~15KB of data. Reading here and there on the web I found that my blob field can lead (when the overall fields exceed ...
0
votes
1answer
216 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, ...
1
vote
1answer
177 views

InnoDB Buffer pool hit rate missing from engine status output

I want to check the buffer pool hit rate for InnoDB on MySQL but when I query the database the hit rate seems to be gone from the results: Using query: SHOW ENGINE INNODB STATUS\G ...
1
vote
1answer
70 views

Does adding a foreign key constraint in MySQL cause a table rebuild?

I need to alter a large table in order to add a foreign key. Does adding the constraint cause the table to be rebuilt? The referenced table already exists and has an index on the column.
1
vote
1answer
123 views

MySQL (innodb) always crashes on big ORDER BY statements

I'm running MySQL on Debian stable (normally installed from the stable packages). Everytime when I do a big ORDER BY, mysql crashes. Example query (innodb tables): SELECT * FROM `table` INNER JOIN ( ...
0
votes
0answers
75 views

MySQL fail after change of innodb_flush_method=O_DIRECT and innodb_log_file_size

We changed innodb_flush_method to O_DIRECT innodb_log_file_size to bigger value, and 3 other things (innodb_buffer_pool_size, innodb_additional_mem_pool_size, innodb_log_buffer_size) while MySQL was ...
1
vote
1answer
68 views

Lost Frm files recovering data from ibdata

I was working with a mysql innodb datbase. When I was working with mysqlworkbench accidentally all the .frm files got deleted from mysql data folder but I still have ibdata file in the data folder. I ...
3
votes
2answers
99 views

Dropping Index on 10GB+ InnoDB table takes over 4 hours

This is the table I'm working with: CREATE TABLE IF NOT EXISTS `checklist_answer` ( `id` varchar(36) NOT NULL, `created_by` varchar(36) NOT NULL, `date_created` datetime NOT NULL, ...
0
votes
1answer
892 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
44 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
98 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
222 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
0answers
41 views

Innotop and Monit to kill thread using too much resources

Instead of restarting the whole MYSQL process, sometimes I just want to kill the offending thread instead of making everything go down. Usually the spike in CPU is when a bot is crawling the first ...
2
votes
2answers
325 views

InnoDB no longer available

Recently changed servers and went from CentOS 5.8 to CentOS 6.4. I installed MySQL 5.1.69 on my new server, and manually swapped /var/lib/mysql. I am not sure what version of MySQL was on my old ...
0
votes
1answer
371 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 ...
1
vote
1answer
206 views

MySQL MyISAM multi-core optimization

I've noticed that our app does not respond to requests when a demanding request is in execution. Running top seems to identify the source of the problem: top - 13:54:25 up 1 day, 13:43, 2 users, ...
0
votes
3answers
140 views

Disable innodb_file_per_table

I have 24GB RAM i7 dedicated server, running CPanel 11.36 with MySQL 5.1.68. In my.cnf I have innodb_file_per_table enabled. Is it safe to just disable the option, not doing any damage to databases in ...
2
votes
2answers
182 views

Innodb one file per tablespace

I'm walking into an environment that uses MySQL and Innodb as the storage engine. I'd like to enable innodb_file_per_table to increase performance. Considering all of the databases/tables are ...
1
vote
1answer
268 views

Mysql crashing due to InnoDB not able to allocate memory

MySQL crashes every now and then due to, I believe, a large request hitting it above the innodb-buffer-pool-size set in my.cnf (currently at 210M), which I needed to set for mysql to start in the ...
0
votes
1answer
111 views

What can I do with corrupted DB in InnoDB format in this case?

guys, I have a big problem. There is one server with CRM database. I corrupted it probably and don't know what to do. ls /var/lib/mysql/sugarcrm/ accounts_audit.frm address_book.ibd ...
-1
votes
1answer
32 views

InnoDB Failure of some kind [closed]

I have MySQL 5.5 installed. I tried to install Joolma but it failed. I went into their sql and replace EGNINE=InnoDB with MyISAM and the install worked. InnoDB is listed under SHOW ENGINES; Any idea ...
1
vote
1answer
48 views

Heroku : Support of InnoDB

Does Heroku supports MySQL (esp. InnoDB database engine) ? I see there is ClearDB add-on, but it didn't state it supports InnoDB or not.
1
vote
0answers
259 views

InnoDB restore from ibdata: “mysql post-start process terminated with status 1”

I discovered way too late that the backup script for our MySQL databases wasn't working properly. Namely, when the disk on the server had already started to fail, and I logged in via SSH and got a ...
1
vote
1answer
561 views

Tuning MySQL of 1.3 G DB, 8GB Ram, High IO Wait

I am having MySQL database of size 1.3 GB on 8 core virtual machine, 8 GB of memory and I am having troubles optimizing the configuration. There is a lot of small rows and lot of joins going on. I've ...
0
votes
0answers
897 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 ...
2
votes
2answers
976 views

1286 - Unknown storage engine 'InnoDB'

I am trying to use roundcube and it recently just broke. I don't know if this is due to a MySQL update that happened recently or not but in phpMyAdmin I get the following error if I try and view a ...
0
votes
1answer
92 views

Get mysql database from raw files

My root access linux server has crashed and I cannot SSH into it or interact with it. I can, however tell the online console to do a network boot to a "rescue system" which allows me to access the ...