InnoDB is the main ACID-compliant Storage Engine used in MySQL.
0
votes
1answer
31 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
28 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, ...
-1
votes
0answers
18 views
what happens when InnoDB logspace is too small [migrated]
I've just seen several mysql errors in my log:
InnoDB: ERROR: the age of the last checkpoint is X
InnoDB: which exceeds the log group capacity Y
I understand, that I do have to increase the ...
0
votes
3answers
44 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
36 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
53 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
24 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
29 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
23 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
92 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 ...
0
votes
1answer
76 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
208 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
99 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
52 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 ...
0
votes
1answer
168 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
0answers
139 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 ...
1
vote
2answers
103 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
114 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
58 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
80 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 ...
0
votes
0answers
37 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 ; ...
0
votes
1answer
70 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
113 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
932 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
308 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 ...
1
vote
2answers
264 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
0answers
306 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
1answer
190 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, ...
-1
votes
1answer
484 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
838 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 ...
2
votes
1answer
114 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
75 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
192 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
180 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
145 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.
...
1
vote
0answers
99 views
Simple UPDATE query with (sometime) long query times
I run a dedicated MySQL server (2 cores, 16GB RAM) serving 100-200 requests per second. It is getting sluggish during peak traffic and I have a hard time optimizing the server. So I'm looking for some ...
0
votes
0answers
84 views
checking health status of large InnoDB databases
What is the fastest way to check health status of an InnoDB database, I mean checking if it's corrupted or not. It's about 10GB, and I tried mysqlcheck but it hangs on InnoDB tables. is there any ...
3
votes
2answers
482 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
164 views
Mysql innoDB corruption after server crash
Yesterday my server died because an outage in the data center. Today it's back up, but having some problems with mysql.
First of all my mysql server was not able to start. For this reason I deleted ...
1
vote
1answer
179 views
How can I lower MySQL single-page reads?
My innodb buffer pool size is 8GB and my database is 6GB in size but I see this:
Innodb_buffer_pool_reads 263.5k - The number of logical reads that InnoDB could not satisfy from buffer pool and had ...
3
votes
1answer
140 views
mysql 5.1 - innodb - query_cache_size - 9,418,108 queries have been removed from the query cache due to lack of memory
Currently running on a 16GB system - Ubuntu 64 bit.
INnodb Buffer Pool is set to 10GB.
tuning-primer shows the following:
QUERY CACHE
Query cache is enabled
Current query_cache_size = 512 M
Current ...
3
votes
1answer
686 views
mysql - can't drop table does not exist, can't create table exists
After a server crash we are having some very strange issues with one particular table reference.
Opting for a restoration from backup the database was dropped and a backup SQL dump loaded, only this ...
0
votes
1answer
1k 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
387 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 ...
2
votes
2answers
823 views
Can fragmented MySQL innodb tables cause I/O issues? “task hung for 120 seconds” crashes?
Large innodb databases with load spikes seem to be causing random crashes with "task hung for 120 seconds" in the console. There are no logs being written to the system during these crashes.
The ...
0
votes
1answer
58 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 ...
1
vote
3answers
79 views
Database select error
Database select error
its my problem and when I restart my mysql to fix this error this problem solve but after 30 minutes or after hours again this error happen again.
I put link here screenshot ...
9
votes
5answers
268 views
MyISAM for data reads
I have a table with around 1 Billion rows, and its 98% read intensive.
I tried tuning the database, with different storage engines (MyISAM and InnoDB)
Then ran a few test to view the performance
In ...
0
votes
0answers
99 views
InnoTop Server Groups Configuration file
I have pool of Mysql:InnoDB servers and i want to use innotop to monitor whole server group, but I have big problems to configure such pool in innotop.conf. I was fighting with it for three days ...
