What is ://URLFAN and how does it work? / Contact Us / Home

We're currently ranking the popularity of 3,783,534 websites by parsing 125,191,955 blog posts from 2,076,212 blog feeds.

HOME / TOP 100 SITES / REAL-TIME BUZZ RADAR / 2008 ZEITGEIST / SUBMIT YOUR FEED

Article Structure
2 paragraphs
797 characters
0 images
0 outgoing links

Quick note on innodb_file_per_table

Post Date: Mar 03, 2008 8:03 p.m.
Ranked website: planetmysql.org (Ranks #49794 of 3,783,534)

For full text please visit source:
http://www.bigdbahead.com/?p=45

Ran into an interesting issue with a client today who was using innodb_file_per_table. This client had a lot of tables ( 300K+), they were using innodb_file_per_table. Today they had a problem that caused their db to crash. After fixing their issue, the database restart seemed to hang. The only thing in the error log was the mysql was started, their was no crash recovery messages. An strace revealed that the mysqld process was stating all the datafiles. It seems that during a recovery the first step is to just check to see if all the individual files are really their. The entire process to simply stat each datafile took over 45 minutes to complete after which the actual crash recovery started. Just a quick note to remind myself in the future if I see this again.

Content suppressed by ://URLFAN, for full article visit source

Websites mentioned in article

No websites were mentioned in article

Buzz Words mentioned in article:

No buzz words were found in article

How popular is www.bigdbahead.com?

Click here to view stats and graphs for planetmysql.org

More posts from www.bigdbahead.com

Migrating from one RDBMS to another
From: haidongji.com
Post Date: 2008-03-03 20:17:34

Here is some of my thoughts on migrating MySQL to Sql Server. It came out of an email discussion. I’d love to hear your thoughts on migrating to a different database platform, not just MySQL to Sql Server. I actually thought about writing a white paper or even a course on migrating from MySQL to Sql Server, but never got the time to do it. Sometimes a project doing similar things can serve as a launchpad for this endeavour, but that never came along, at least not yet. I am very intere... more

iodbc and mac os x problems
From: trainedmonkey.com
Post Date: 2008-03-03 19:23:01

working with the iodbc driver manager on mac os x has been a frustration on two fronts. first, the installer api functions provided by iodbc constantly set the configuration mode to ODBC_BOTH_DSN, which means you have to keep resetting it to the correct value after nearly every installer api call. this problem is platform-agnostic ? the iodbc code is just plain wrong. second, when called from the odbc administrator application on mac os x, any failures that the driver reports or passes throu... more

MySQL: Solution for ERROR 1442 (HY000): Can?t update table ?t1? in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
From: crazytoon.com
Post Date: 2008-03-03 18:42:02

Here is a sample table you can create to test following problem/solution on: CREATE TABLE `t1` ( `a` char(1) default NULL, `b` smallint(6) default NULL ); insert into t1 values (’y’,’1’); I have a table t1 which has column a and b, I want column a to be updated to ‘n’ when column b = 0. Here is the first version [...]... more

Feeds and posts are not affliated with ://URLFAN. They are displayed here simply for informational purposes, if you would like to remove your feed, posts, or domain from ranking and analysis, please contact us.