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,264 times on 290 sites in last 3 months
Started 3 days, 19 hours ago (2009-11-26 12:05:00)
by sql_er
Hello, Our database size is 16 GB, and contains almost exclusively InnoDB tables. Our Buffer Pool size is set to 2 GB. I read that larger Pool size yields better performance and it should be set to at least the size of the database or even 20 % larger to accommodate for database growth. We are using Linux Kernel 2.6.18. It is a 64 Bit machine. MySQL 5.0.44 is installed. Does ...
Started 1 week, 3 days ago (2009-11-20 04:38:00)
by ForMod
I'm having site problems and it seems to be related to MySQL hanging and I'd like to know if anyone knows whether switching from MyISAM to InnoDB MySQL tables will help and is supported? Here's the type of query I usually see when things lock up: | 1665 | jazzfanz_jazz | localhost | jazzfanz_jazz | Query | 11 | Copying to tmp table | SELECT p.poster_id, p.post_subject, p.post_text, p.bbcode...
Started 1 week, 4 days ago (2009-11-19 01:36:00)
by Don Muller
I've done some tuning on mysql and it runs much better. However I do have one strange problem. Whenever I add innodb_log_file_size to my config file the innodb engine gets disabled. I can see this using phpmyadmin. It doesn't matter what size I make it, it always gets disabld. When I comment out that line and restart mysql the innodb engine is enabled again. Anyone have any idea why?...
Started 1 week, 4 days ago (2009-11-18 21:30:00)
by mike grafton
Running a mixed workload seems to cause InnoDB to lock up... SELECT/UPDATE works fine but when I add in INSERT it locks. Show innodb status shows MAKING CHECKPOINT and many lines as follows: ---TRANSACTION 47033C34, ACTIVE 43 sec, process no 21956, OS thread id 1320294720 inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s) MySQL thread id 573, ...
Started 2 weeks, 2 days 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 2 weeks, 4 days 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 2 weeks, 5 days 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 2 weeks, 6 days 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 5 days, 21 hours ago (2009-11-24 09:51:00)
by motion-ex
I am trying to get my around a functionality that i have to code for an application, the client wants a functionality that makes it possible to lock the access to a database resource (row/table/) when someone has an access to it... And also that this locked state should not exceed 1h, after 1 hour if i for example have not closed my acccess to the resource, i should get automaticaly kicked ...
Started 5 days, 18 hours ago (2009-11-24 12:57:00)
by crmalibu
I don't think you should use the databases locking functionality for this, because it sounds like application logic. Although, the database will be involved. http://www.sitepoint.com/forums/showthread.php?t=5 99868 But basically, a user acquires access by updating a row in a database. The only way the update is allowed is of one of these conditions is true: Code: locked = 0 ...
Started 4 days, 18 hours ago (2009-11-25 12:57:00)
by tomlus
newbie question, what is the difference between S3 and an EBS volume? Are InnoDB databases fully supported and easily accessable/mountable from an EC2 instance if they are on S3 or EBS ? I would like to know where to start. Thanks! Message was edited by: tomlus
Hi We have a large mySQL (innoDB) database today with several tables. One of these consist of a (foreign) key and a text blob. This table has grown large (>70 GB), and it is impossible to do any searches in the text column (at least "online"). Innodb doesn't handle fulltext searches, so I'm using normal "where textcol LIKE '%searchstring%' " Any advice on how to be able to fulltext ...
Started 5 days, 16 hours ago (2009-11-24 15:10:00)
by Stephan_Craft
Hi, While I was trying to improve mysql performance, I tried to increase innodb_log_file_size Code: mysql> SHOW variables like "%innodb_log%"; +---------------------------+---------+ | Variable_name | Value | +---------------------------+---------+ | innodb_log_arch_dir | | | innodb_log_archive | OFF | | innodb_log_buffer_size | ...
Started 2 days, 8 hours ago (2009-11-27 22:44:00)
by xiaobin she
Hi everyone, recently I'm reading the codes about the io subsystem of innodb, and I got some questions, hope you can help me to answer that, thanks. the questions are: 1. from what I have know from the soucre code, it seems that for each data file(like ibdata1,ibdata2, or if you set the innodb_file_per_table, then the table1.ibd, table2.ibd ...), innodb will only open it once and ...
Started 6 days, 20 hours ago (2009-11-23 10:40:00)
by ETdeMarte
Error in my_thread_global_end 1 threads didn't exit I have this error i know the solution: This error is actually a bug in the latter PHP/MySQL release, which is generated when the MySQL's InnoDB database storage engine's connection handlers while exiting properly did not decrement the server's thread count. It can be fixed easily by changing/switching the PHP Server API from CGI/FastCGI to ...
Started 4 days ago (2009-11-26 07:05:00)
by Vitaly Karasik
>yes,in fact it is explaining why a transaction waits until the conflicting or >existing lock is released ,this is not necessarily only for deadlocks,resolution >for your scenario is innodb_rollback_on_timeout=1 @ my.cnf , my intention is >dont increase innodb_lock_wait_timeout until,unless it is really,really! >necessary Thank you for explanation! Unfortunately, MySQL reference manual ...