InnoDB is the main ACID-compliant Storage Engine used in MySQL.
2
votes
2answers
25 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
39 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 ...
2
votes
1answer
629 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! ...
0
votes
1answer
21 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
28 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 ...
0
votes
1answer
17 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.
3
votes
2answers
441 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
56 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
2answers
987 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 ...
6
votes
3answers
7k 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 ...
10
votes
5answers
5k views
MySQL InnoDB - innodb_file_per_table cons?
By default MySQL InnoDB stores all tables of all DBs in one global file. You can change this by setting innodb_file_per_table in the config, which then creates one data file for each table.
I am ...
0
votes
1answer
65 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
171 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
73 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
51 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 ...
6
votes
5answers
10k views
How to improve MySQL INSERT and UPDATE performance?
This question can probably be asked on StackOverflow as well, but I'll try here first...
Performance of INSERT and UPDATE statements in our database seems to be degrading and causing poor performance ...
3
votes
1answer
82 views
InnoDB erratic performance
I'm doing some tests with a really simple InnoDB table (named Test) with the following structure:
Id int(10) unsigned NOT NULL AUTO_INCREMENT
UserId int(10) NOT NULL
Body varchar(512) COLLATE ...
0
votes
1answer
156 views
Troubleshooting MySQL Performance Issues
Environment:
1 physical machine
8GB RAM
some older Core2Duo CPU
1 HDD
Windows Vista 64 bit
1 Virtual Machine
16 GB RAM
2 vCPUs
Windows 7 64bit
Both machines running MySQL 5.5.28 (64Bit) with ...
0
votes
4answers
7k 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
0answers
114 views
Mysql Innodb native AIO flag causes high apparent iowait on virtualised host
There is a mysql config setting for InnoDB
innodb_use_native_aio = 0
This is documented here:
http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_use_native_aio
It is ...
6
votes
2answers
3k views
MySQL InnoDB database 'hangs' on selects
I'm trying to fix MySQL configuration on our server.
Our app's specifics is that a lot of data is stored in single table (currently over 300 millions of rows). This table is used often for inserts ...
1
vote
2answers
87 views
Is it possible to create a mysql slave from start of masters binlog without copying data first?
info: my tables are all innodb.
i know i can create a mysql slave by copying the data from master to slave and noting the position in the binlog and set that on the slave. thus the slave should be ...
1
vote
1answer
67 views
MySQL InnoDB Backup: are dump files enough?
What exactly does the default ibdata1 file store that does not exist in a mysqldump?
I've got a backup/rsync job that stores dump files of a MySQL 5.5 database on a remote server for rotating ...
0
votes
2answers
109 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
...
1
vote
1answer
53 views
MySQL database repair
Using Vbulletin 4.2.0 PL3
I've used the repair / optimize database feature in vbulletin admin panel but these below tables remain at the same size. Is this normal?
Last column is "overhead" which ...
0
votes
0answers
276 views
MySQL 5.5 - signal 11… Why?
128GB RAM, 32 Core , Xeon - running Ubuntu 12.04 with MySQL 5.5.28 .
We again had an assertion failure after restoring the image onto another system in case there was hardware issues. However ...
0
votes
0answers
79 views
Import large InnoDB table dump
i've a mysqldump ( 1.5G large ) of a table I need to import.
The server i bought, which is clean and not under load, takes > 2hours to import it.
I read many tweaks i can use to speed up the import ...
2
votes
2answers
4k views
Why do MySQL queries pile up in “Sending data” state?
We're using InnoDB tables as the back end of a web application, and everything was fine for about two years until we had to restart MySQL a few weeks ago. (We hadn't disabled reverse DNS lookups, ...
0
votes
0answers
35 views
Restoring .ibd file from a formatted ext3 partition
I'm trying to find an IBD file (InnoDB tablespace) signature for PhotoRec utility http://www.cgsecurity.org/wiki/Add_your_own_extension_to_PhotoRec ; ...
2
votes
2answers
1k views
mysqld crashes on any statement
I restarted my slave to change configuration settings to skip reverse hostname lookup on connecting and to enable the slow query log.
I edited /etc/my.cnf making only these changes, then restarted ...
0
votes
1answer
65 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
104 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 ...
0
votes
1answer
786 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 ...
0
votes
1answer
275 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
2answers
860 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 ...
1
vote
2answers
290 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 ...
1
vote
2answers
214 views
INNODB mysql. Plugin disabled
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 ...
0
votes
1answer
181 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, ...
4
votes
5answers
4k views
Is there any equivalent of mysqlhotcopy for InnoDB?
Currently I'm using mysqldump to make backups which is slow, but OKish. The big problem is restoring database, which takes a few days. The dump is around 7GB gzipped, so it's not a tiny database, but ...
-1
votes
1answer
452 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
729 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 ...
6
votes
4answers
2k views
Modifying columns of very large mysql tables with little or no downtime
I periodically need to make changes to tables in mysql 5.1, mostly adding columns. Very simple with the alter table command. But my tables have up to 40 million rows now and they are growing fast... ...
2
votes
1answer
110 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, ...
0
votes
0answers
73 views
Error connecting to DB [closed]
In regards to:
Remounting MySQL under a new mount point
Everything is running. MySQL started but for websites they can not connect to the mysql database at all.
Error log does not show much. Only:
...
1
vote
0answers
189 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]
...
1
vote
1answer
139 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.
...
0
votes
2answers
1k views
Plesk: libmysqlclient_16 not defined in file libmysqlclient_r.so.16
I've found this error in my logs:
relocation error: /usr/lib64/libmyodbc5.so: symbol strmov, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference
...
1
vote
1answer
170 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
922 views
MySQL show table status always returns Data_free 17825792
When I execute SHOW TABLE STATUS databaseName;
I get Data_free info with 17825792 value in all tables :
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | ...
1
vote
2answers
943 views
InnoDB recovery
My MySQL server run to crash due to (page file write error). I did a disk diagnosis but no errors found. I restarted MySQL server. It scanned the bin log like for 1-2 hours and recorded log as below:
...
