Grokbase Groups MySQL innodb
FAQ

Search Discussions

39 discussions - 80 posts

  • Hi, I have two servers Mysql 5.5 with master to master replication. The second server failed and I needed to remove it to repair the operating system. After this incident the application users have ...
    Camilo VieiraCamilo Vieira
    Nov 5, 2014 at 8:06 pm
    Nov 5, 2014 at 8:06 pm
  • Hi, Can't we grow mysql tablespace configured on raw LVM volume, once it gets out of space ? I did following tests: 1) configured mysql server on raw LVM volume of size 20MB with following ...
    Vivek SatputeVivek Satpute
    Mar 12, 2014 at 11:14 pm
    Mar 12, 2014 at 11:14 pm
  • hi all: I want to know the sql of the lock which blocks current query. So I record the query id of the sql creating the lock. If waiting for it , then output it through show innodb status. But I ...
    孔智孔智
    Feb 13, 2014 at 3:18 pm
    Feb 13, 2014 at 3:18 pm
  • Hi, I unfortunately probably already know what the answer is, but to be sure: Does the ibdata1 file contain information for databases of which all tables are InnoDB and created with ...
    Wiebe CazemierWiebe Cazemier
    Nov 12, 2013 at 6:49 am
    Nov 12, 2013 at 9:39 am
  • Greetings. I'm receiving the following error log often on my MySQL database server: 130715 8:40:18InnoDB: Assertion failure in thread 2974165904 in file btr0cur.c line 160 InnoDB: Failing assertion ...
    Luis H. ForchesattoLuis H. Forchesatto
    Jul 15, 2013 at 12:09 pm
    Jul 15, 2013 at 12:09 pm
  • In MySQL 5.6.11 I observed that the OPTIMIZE TABLE query does not have the restoring secondary index status although my table has a primary and a secondary key. Here is the query profile i got when I ...
    Shashank Raj HolavanalliShashank Raj Holavanalli
    Apr 26, 2013 at 2:23 am
    Apr 26, 2013 at 10:47 pm
  • Hello, I know the directory page is designed to faster read using binary search, since the records of one page is unordered(in physical). With the purpose of binary search, we also can do it in the ...
    Bohu TANGBohu TANG
    Feb 21, 2013 at 3:47 am
    Feb 21, 2013 at 4:44 am
  • Hi everybody, 2013 is near… and so is the next FOSDEM edition ! This year again, MySQL will be represented by its Community. If you want to discuss with friends of MySQL it's the place to be in ...
    Frédéric DescampsFrédéric Descamps
    Nov 14, 2012 at 3:14 pm
    Nov 14, 2012 at 3:14 pm
  • Hello, I had several time an error like Incorrect key file for table '/tmp/#sql_4aa7_1.MYI'; try to repair it and I didn't found any really deep info about how MySQL uses and create the temporary ...
    Franco riggiFranco riggi
    Oct 18, 2012 at 8:02 am
    Oct 18, 2012 at 8:43 am
  • Hi, I have found this difference while converting one of the table from MyISAM to InnoDB engine. I am giving you the differences what i noticed. Could you please answer the possible reason for this ...
    Rahul JhaRahul Jha
    Sep 24, 2012 at 11:36 am
    Sep 24, 2012 at 7:30 pm
  • Hi, Most of my tables have a fixed row size. Some others have a few variable size rows. Is there any gain if i fix the size of these rows? I see there are only two row formats: compact and redundant, ...
    Andras GyomreyAndras Gyomrey
    Apr 9, 2012 at 11:17 pm
    Apr 9, 2012 at 11:17 pm
  • Dear Team I am Database administrator. We have a high transactional database. We want to move on SAN. Are there any guidelines for SAN designing? like stripe size, block size etc? If not then how we ...
    ANIL YADAVANIL YADAV
    Feb 9, 2012 at 5:04 pm
    Feb 9, 2012 at 11:57 pm
  • Hi, I have read several articles in the Internet on how to dump and re-create an innodb to reclaim disk space. I am trying to do this in a test environment, but no luck. I run the commands and script ...
    DrsystemsDrsystems
    Jan 24, 2012 at 3:59 pm
    Jan 27, 2012 at 5:26 am
  • Hi, I read in http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablespaces.html that using the innodb_file_per_table will help to reclaim space when a mysql database grows too large, even ...
    DrsystemsDrsystems
    Jan 11, 2012 at 4:22 pm
    Jan 11, 2012 at 4:23 pm
  • To confirm that you would like <span class="m_body_email_addr" title="38c5e321ea462d1a40de26a6353ba09d" jlistreader@gmail.com</span added to the innodb mailing list, please click on the following ...
    Innodb-helpInnodb-help
    Dec 5, 2011 at 10:16 am
    Dec 5, 2011 at 10:16 am
  • MySQL 5.1 on slave server getting the following error: Error 'Got error -1 from storage engine' on query. Default database: 'listings'. Query: 'UPDATE scripts SET running = 1, last_run = NOW() WHERE ...
    AlAl
    Sep 19, 2011 at 1:58 pm
    Sep 19, 2011 at 1:58 pm
  • Hi Is there anyway we can shrink Innodb database?? Say I want to create a bash script which checks the database regularly & when it reaches above 1GB it automatically shrinks it down. Regards Sushant ...
    Sushant chawlaSushant chawla
    Jan 5, 2011 at 7:30 am
    Jan 5, 2011 at 7:30 am
  • I am trying to benchmark InnoDB's row-based locking vs MyISAM to see if it will add a great benefit to my application, but am coming up short on how to produce such a test. I've looked at ...
    ArielAriel
    Dec 17, 2010 at 8:22 pm
    Dec 19, 2010 at 7:08 pm
  • Hi, Do we have to use InnoDB as the storage engine for a particular database, for it to get recovered during a crash ,or merely the presence of InnoDB storage engine in the list of engines available, ...
    Neeraj N TNeeraj N T
    Dec 16, 2010 at 6:14 am
    Dec 16, 2010 at 6:14 am
  • Hi , Can someone recommend a stable mysql version having Innodb which I can use in my embedded system?. (Some applications in my system need to read and write some configuration data eg: HDMI data, ...
    Neeraj N TNeeraj N T
    Dec 14, 2010 at 12:42 pm
    Dec 15, 2010 at 9:42 am
  • Hi , Suppose one of my application is using mysql as database and mysql got crashed.The next time when the application tries to connect to the server, will it know about the crash?.What's the role of ...
    Neeraj N TNeeraj N T
    Dec 13, 2010 at 8:27 am
    Dec 13, 2010 at 2:42 pm
  • Hi, I would like to understand how InnoDB allocates/re-use space for an update statement. Some cases might be; a- row has all fixed length fields b- row has variable length fields, new data is not ...
    Ozgur AkanOzgur Akan
    Nov 19, 2010 at 5:28 pm
    Nov 19, 2010 at 5:28 pm
  • Suppose I wanted to be able to perform queries against three columns of my table: 'user_id', 'product_id' and 'created'. Most of the time I'll just be range-selecting records from the table ordering ...
    Jonas GalvezJonas Galvez
    Oct 1, 2010 at 6:47 pm
    Oct 1, 2010 at 6:47 pm
  • Hi Yesterday we had an issue with one our servers. It seemed to be performing quite poorly. At some point we noticed that it was running with the stock standard innodb settings although the my.cnf ...
    Brett skinnerBrett skinner
    Sep 28, 2010 at 7:17 am
    Sep 28, 2010 at 8:48 am
  • Dear all, I want to know that how we can determine the current size of ibdata files. I have 4 ibdata files. First 3 having 10MB size. And the final is 10MB autoextend. I store a table *emp* of size ...
    Adarsh SharmaAdarsh Sharma
    Sep 14, 2010 at 8:39 am
    Sep 14, 2010 at 8:39 am
  • Hi, I've been searching for workarounds for the issue http://bugs.mysql.com/bug.php?id=25847. Is there any chance this will get done? Or is there other options one could take? Please point out if ...
    Andras GyomreyAndras Gyomrey
    Aug 22, 2010 at 4:11 am
    Aug 22, 2010 at 4:11 am
  • Hi all, I don't fully understand the importance of doublewrite in InnoDB. (1) Performance wise. Performance wise I can understand that, doublewrite can coalesce many dirty pages into a big buf chunk, ...
    NeutronNeutron
    Aug 17, 2010 at 8:10 pm
    Aug 17, 2010 at 8:10 pm
  • Hi My Server is run as MySQL on DRBD After that the inserts are very slow, Is DRBD having performance Issue? My Server configuration is here 8 GB RAM QUAD core processor #[client] #password = ...
    Bijumon K NBijumon K N
    Apr 6, 2010 at 12:44 pm
    Apr 6, 2010 at 12:44 pm
  • Thanks & Regards Bijumon K. N. Sr. MySQL DBA IMImobile Plot 770, Rd. 44 Jubilee Hills, Hyderabad - 500033 T +91 40 23555945 - Ext: 335 www.imimobile.com ...
    Bijumon K NBijumon K N
    Apr 6, 2010 at 12:27 pm
    Apr 6, 2010 at 12:27 pm
  • Hi, When my server is in heavy load, insertion on innodb tables getting very slow, How to make it fast Thanks & Regards Bijumon K. N. Sr. MySQL DBA IMImobile Plot 770, Rd. 44 Jubilee Hills, Hyderabad ...
    Bijumon K NBijumon K N
    Apr 6, 2010 at 8:49 am
    Apr 6, 2010 at 9:56 am
  • Hey guys, How do you recommend I organize my innodb files? I'm afraid of them getting too big ( 5gb) because then it becomes hard to deal with them (move them around, store them, etc). Currently, I ...
    Konstantin KKonstantin K
    Mar 4, 2010 at 11:44 pm
    Mar 4, 2010 at 11:44 pm
  • Hi I want to optimize my MySQL schema in order to increase performance of my application. And I see several points that could be corrected but I am not sure what would be the impacts and benefits. ...
    Antoine NoalAntoine Noal
    Dec 15, 2009 at 4:59 pm
    Dec 16, 2009 at 4:11 pm
  • If you use InnoDB and need to do hot backups (doesn't everyone?) you should know about xtrabackup. I've written an article about it here: ...
    Marcus BointonMarcus Bointon
    Sep 12, 2009 at 8:28 pm
    Sep 13, 2009 at 8:10 am
  • Hello, I have a database with about 1000 tables and 150GB. I have done a simple "for f in $(cat tables); do mysql -uuser -ppassword database_name -e "alter table $f engine=InnoDB;" ; done I took ...
    Arthur Meeks MeeksArthur Meeks Meeks
    Sep 12, 2009 at 7:50 pm
    Sep 12, 2009 at 7:50 pm
  • The InnoDB team is pleased to announce the availability of InnoDB Plugin release 1.0.4, which brings additional performance gains of 20% or more! This latest early adopter version of the InnoDB ...
    Calvin SunCalvin Sun
    Aug 11, 2009 at 8:08 pm
    Aug 11, 2009 at 8:08 pm
  • Hi, I'm having a weird problem with creating temporary tables in a 100% InnoDB database. This works (so I have permissions etc): mysql create temporary table a (b int); With identical schemas and ...
    Marcus BointonMarcus Bointon
    Jun 28, 2009 at 1:28 am
    Jun 29, 2009 at 9:31 am
  • Hi there, OpenSQL Camp is a free conference of, by, and for the open-source database community of users and developers. The OpenSQLCamp 2009, European Edition (http://opensqlcamp.org/) will take part ...
    Lenz GrimmerLenz Grimmer
    Jun 18, 2009 at 4:22 pm
    Jun 18, 2009 at 4:22 pm
  • Hi, I am working on adding InnoDB embedded to the openSUSE Build Service at http://build.opensuse.org/ - which will build and provide RPMs of this library for a wide range of RPM-based distributions. ...
    Lenz GrimmerLenz Grimmer
    Jun 17, 2009 at 6:53 pm
    Jun 17, 2009 at 6:53 pm
  • This list is for discussions about the InnoDB storage engine for the MySQL database system. Enjoy!
    MySQL Lists AdministratorMySQL Lists Administrator
    Jun 9, 2009 at 4:54 pm
    Jun 9, 2009 at 4:54 pm
Group Navigation
period‹ prev | Latest | first ›
Group Overview
groupinnodb @
categoriesmysql
discussions39
posts80
users39
websitemysql.com
irc#mysql

Top users

Reindl Harald: 7 posts Franco riggi: 5 posts Neeraj N T: 5 posts Brett skinner: 4 posts Marcus Bointon: 4 posts Shashank Raj Holavanalli: 4 posts Luis Motta Campos: 3 posts Yogesh Kore: 3 posts Paul Wilson: 3 posts ANIL YADAV: 3 posts Bijumon K N: 3 posts Drsystems: 3 posts Bohu TANG: 2 posts Lenz Grimmer: 2 posts Andrew 2 Moore: 2 posts Lixun Peng: 2 posts Andras Gyomrey: 2 posts Arthur Meeks Meeks: 2 posts MySQL Lists Administrator: 1 post Wiebe Cazemier: 1 post
show more