Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options questions only user 4846

InnoDB : MySQL's ACID-compliant Storage Engine

3
votes
2answers
I Have configured the mysql server with innodb per table. There was a table watchdog having approximate 19GB of watchdog.ibd file. I have truncated the table now it has zero record. But the …
asked Jan 17 '12 by Abdul Manaf
20
votes
2answers
I have 170GB of InnoDB index and Data. I have to readjust the innodb_buffer_pool size for better performance.The Max table size of a InnoDB table(Index+data) is 28GB. So what should be the optimal … size of innodb_buffer_pool. UPDATE we are going to migrate our this local database to ec2 so will set the RAM according to the current statistics of innodb that's why i need the size of buffer pool so we can have available RAM there. File Per table is enabled. I am using Linux machine. …
asked Jun 13 '12 by Abdul Manaf
3
votes
1answer
I Have a Innodb table i got the error as mysql> check table City; +-------------------+-------+----------+----------------------------------------------------------+ | Table | Op … ... Content of error log are as 120207 11:50:47 InnoDB: highest supported file format is Barracuda. 120207 11:50:47 InnoDB: Waiting for the background threads to start 120207 11:50:48 InnoDB: 1.1.8 started …
asked Feb 7 '12 by Abdul Manaf
3
votes
2answers
I have a very large table approx 28GB and that is continually increasing. I am thinking about partitioning my table. The table is InnoDB and The File Per Table is enabled I have a field name … (1325356200) ENGINE = InnoDB, # Data before 2012 PARTITION p1 VALUES LESS THAN (1333218600) ENGINE = InnoDB, # Data for JAN,FEB,MARCH YEAR 2012 PARTITION p2 VALUES LESS THAN (1341081000) ENGINE = InnoDB
asked Jun 15 '12 by Abdul Manaf
25
votes
4answers
I am finding what is the best way to estimate size of a table for that i have studied lot of blogs and forums but unable to find any accurate answer For an example we have a table City with InnoDB
asked Jul 10 '13 by Abdul Manaf
62
votes
1answer
I have some Production servers whose ibdata files increase in size day by day. It has already consumed 290GB of space. The tables in the servers are mostly InnoDB and there are high read and write …
asked Dec 9 '11 by Abdul Manaf
13
votes
2answers
I have a Database having number of tables. I want to delete some records from the tables say the no of records are more than 20K or 50K. The All the Tables are InnoDB. And file_per_table is off …
asked Apr 11 '12 by Abdul Manaf
1
vote
1answer
on /EBSroot innodb logs are on some other location The total ibdata size is approx 600GB due to this test work it increased to 900GB. Now i want to reclaim the space.I am thinking as delete the …
asked May 21 '12 by Abdul Manaf
5
votes
2answers
Have approximately all tables with Innodb.I am not using innodb per table. I have my idbata on lvm.So How much i should increase it for future use..? Or any other Best way to Handle the Scenario. …
asked Feb 22 '12 by Abdul Manaf
3
votes
1answer
`K_feedId` (`feedId`), KEY `K_subPublisherId` (`subPublisherId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 So my questions are Does the approach i am going to opt will work and is it optimized way to …
asked Jan 9 '14 by Abdul Manaf