0
votes
1answer
189 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
1answer
149 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
1answer
478 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 ...
2
votes
2answers
1k 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 ...
1
vote
3answers
85 views

Innodb statistics

We're running InnoDB as a MySQL engine and using phpMyadmin to administer our database. Under Status -> Query statistics, phpMyadmin gives us the following: We would like to know where these ...
11
votes
4answers
23k 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 ...
1
vote
1answer
119 views

MySQL in VMWare Ubuntu 11.10 64bit, Configuration

Can anyone suggest an optimal setting for what I'm doing? (Note that this is a one time job, after finishing my code, I'll put this back to development setting.) I am setting up a 64bit Ubuntu 11.10 ...
1
vote
1answer
108 views

Can I use a newer InnoDB plugin in Ubuntu MySQL?

The MySQL that comes with Ubuntu 10.04.2 is 5.1.41, which is distributed by MySQL with InnoDB 1.0.5. But for some reason Ubuntu ships it with InnoDB 1.0. Can I install InnoDB 1.0.5 (or newer?)
0
votes
2answers
413 views

MySql is not picking up changes to my.cnf file on a custom Ubuntu AMI. How do I fix this?

I created an AMI from my running EC2 Ubuntu instance. I then brought it up, and MySql is not running the same way on this copied instance. 1) Changes to my my.cnf file are not getting picked up. ...
0
votes
0answers
292 views

How do i enable innodb on ubuntu server 10.04

Here is my entire my.cnf [client] port = 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least ...
2
votes
1answer
1k 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! ...
6
votes
2answers
2k views

Good/Better config for MySQL on an EC2 Large Instance

I have an EC2 Large instance dedicated to MySQL. It will be serving a Joomla/Magento combo so it has a blend of InnoDB and MyISAM tables. I have only worked with MyISAM in the past and am therefore ...
0
votes
1answer
596 views

Import from *.sql into mysql… IBD files missing

Running ubuntu 10.10, MySQL, I imported a set of databases from a backup. The import looks OK - I can query the databases and see data in them. The strange thing is that in the /var/lib/mysql/ ...
0
votes
2answers
912 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 ...
2
votes
2answers
203 views

How can I know if there are innodb tables in a mysql server?

I have a mysql server and I want to disable innodb support for it. It's said that I can cut-off my memory usage up to 100MB. I'm pretty sure but not 100% sure, that there is no innodb tables in the ...