Topic profile page for InnoDB.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: InnoDB.
Topic "Innodb" was discussed 2,042 times on 270 sites in last 3 months
Started 3 days, 2 hours ago (2009-11-13 14:24:00)
by gclarkson
I am using the command line in trying to reset the root password in MySQL 5.1 using mysqld.exe but all I get is: 091113 20:59:36 [Note] Plugin FEDERATED is disabled. 091113 20:59:36 InnoDB: Operating system error number 5 in a file operation InnoDB: The error means mysqld does not have access rights to InnoDB: the directory. It may also be you have created a subdirectory ...
Started 5 days, 7 hours ago (2009-11-11 08:44:00)
by Andrew Powell
Hi there I have an INSERT trigger on a database that has recently been updated from MyISAM to InnoDB. Whilst it used to run without issue it now raises the following error ... "Explicit or implicit commit is not allowed in stored function or trigger. query" The trigger is pretty long so a snippet of it is ... IF @name = 'profile_country' THEN /*Do we have an ...
Started 5 days, 12 hours ago (2009-11-11 03:55:00)
by Andrew Powell
Hi there I have a quick question about transactional control within an InnoDB stored Procedure ... Our MYSQL database is being converted from MyISAM to InnoDB and I have been told that I need to explicitly add "COMMIT" statements to each stored procedure that is run on it. However, from looking at the MYSQL documentation it seems to me that autocommit is implicitly set to true by default...
Started 1 week ago (2009-11-09 09:20:00)
by beersage
For shared hosting... InnoDB 1.0.4 came out back in August. Current installed version is 1.0.3. Supposedly increases performance quite a lot. http://www.innodb.com/wp/2009/08/11/...-104-releas ed/
Started 1 week, 2 days ago (2009-11-07 15:18:00)
by SmokinJ
I was trying to install the Civicrm module and found out my hosting company doesn't support InnoDB. This sounds like the perfect module and I was wondering if most hosting companies support InnoDB and I should change or if there is an alternative to Civicrm? I am creating a site for a political oriented organization. Edited by silverwing: moved out of deprecated forum
Started 1 week, 3 days ago (2009-11-05 18:33:00)
by quiquedcode
Hi guys I have this structure in my 3 tables Code: SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; CREATE TABLE IF NOT EXISTS `sis_param_tax` ( `id` int(5) NOT NULL auto_increment, `description` varchar(50) NOT NULL, `code` varchar(5) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7; CREATE TABLE IF NOT EXISTS `sis...
Started 3 days, 9 hours ago (2009-11-13 07:18:00)
by Antnee
I know this is a question that comes up a lot, but I have a question pertaining to my specific database usage, if you don't mind? At present we use all MyISAM tables and every query comes via a web-server (PHP mysql commands). However, since the system was originally developed, the number of JOINs that we use has vastly increased. They're effectively being used as FKs in a number of tables, ...
Started 3 days, 8 hours ago (2009-11-13 07:34:00)
by Antnee
No, we don't use fulltext indexing. So, with row locks, instead of table locks, if for example, one query is taking a long time, another query will still be able to work on that same table? As for the FKs vs code, yes, the code is already written to deal with invalid relationships, but there's a lot of new code coming as a result of me fixing long-standing DB design issues (like having an id ...
Started 6 days, 6 hours ago (2009-11-10 09:29:00)
by thespider
Hi, I have a mysql database with 20 tables. Out of these 20 tables, one is having more than 6 lakh record.The table is InnoDB with size 17 GB. I have to add one more field in the table. When i tried to add using command line, it shows the error that the table is full. I am not sure how to resize an innodb table. Can anyone give me some details to increase the size. ...
Started 5 days, 8 hours ago (2009-11-11 08:07:00)
by Tiago
Hello There! I have windows 2008 server running Plesk with high mysql CPU load and very low memory. Server is a xeon quad core with 8 GB of memory. My mysql configuration is: default-character-set=latin1 default-storage-engine=INNODB read_buffer_size=1M read_rnd_buffer_size=256K sort_buffer_size=256K innodb_additional_mem_pool_size=2M innodb_flush_log_at_trx_...
Started 3 days, 13 hours ago (2009-11-13 03:19:00)
by Nanda kishore Toomula
Hi you are correct ,Umesh is more senior in MySQL than any one he is working on it since mysql 3.1 ! i just redirected you to correct forum, where you can ask your question Regards Nanda
Started 5 days, 2 hours ago (2009-11-11 13:59:00)
by Jue (Jacky) Shu
thanks nanda. there are quite a few variables need to check, but i'll answer the first question here. it is a mysql only db server. but other than 2.5GB for innodb, also allocated 1.6GB to myisam. here are some myisam config in my.cnf skip-locking set-variable = key_buffer=1792M set-variable = max_allowed_packet=64M set-variable = table_cache=1024 set-variable = ...
![Pentaho Data Integration [Kettle]](http://icons.boardreader.com/33/bb/33bbec7d617ac328c22bfdb37cb8ff40.png "Pentaho Data Integration [Kettle]"){kind=icon}
