Hello.
Have a look here:
http://lists.mysql.com/mysql/194596
http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html
If you feel uncomfortable with 10G ibdata size, you may want to
switch to per-file tablespace:
http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html
Shaun Adams wrote:
1. The ibdata1 file size is 10GB. Does that sound right? Should this file
be this big?
That sounds right. Innodb seems to incur large space overheads. but with
the cost of diskspace nowadays...
2. Once a week, I have to perform HUGE insert imports into the
:~ -Original Message-
:~ From: Shaun Adams [mailto:[EMAIL PROTECTED]
:~ Sent: Tuesday, February 07, 2006 4:32 PM
:~ To: mysql@lists.mysql.com
:~ Subject: INNODB Questions and Optimization help
:~
:~ Questions:
:~
:~ 1. The ibdata1 file size is 10GB. Does that sound right? Should this
Ware,
Thanks so much for your help.
This is what I'm planning on doing, please let me know if you see any problems
here. This is on my test server, so losing data isn't the end of the world.
This is what I plan on doing in order:
1. Backup the database via mysqldump
2. Purge the
On Feb 1, 2006, at 6:35 AM, Grant Giddens wrote:
This is what I'm planning on doing, please let me know if you see
any problems here. This is on my test server, so losing data isn't
the end of the world. This is what I plan on doing in order:
1. Backup the database via mysqldump
We've
On Jan 31, 2006, at 9:54 PM, Grant Giddens wrote:
Since changing these tables, I've noticed some large files in my /
var/lib/mysql directory. This is on my test server and I'm running
gentoo linux.
The files in this directory look like:
/var/lib/mysql/gentoo1-bin.01 (1 Gig in size)
Dan Tappin wrote (quotes from several posts, my thoughts interspersed):
I am running into repeatable table corruption with MySQL 4.x on Mac OS X
10.x.
Many people, myself included, are running mysql 4.x on OS X without reporting
this sort of problem, so the trick is to find out what your
On Jul 24, 2005, at 9:13 AM, Michael Stassen wrote:
Dan Tappin wrote (quotes from several posts, my thoughts
interspersed):
I am running into repeatable table corruption with MySQL 4.x on
Mac OS X
10.x.
Many people, myself included, are running mysql 4.x on OS X without
reporting
On Jul 23, 2005, at 11:56 AM, Dan Tappin wrote:
I am all most ready to give up on MySQL at this point. I'm still
getting regular table corruption on multiple installs of OS X.
I went as far as reporting it as a bug:
http://bugs.mysql.com/bug.php?id=12066
They seem to want more info but my
On Jul 23, 2005, at 10:14 AM, Ware Adams wrote:
Has your mysql crashed or have your restarted the machine without
first shutting down mysql manually? We only saw this error when
mysql was not shut down normally. You can look in your .err file
which should be in your data directory.
On Jul 23, 2005, at 1:58 PM, Dan Tappin wrote:
On Jul 23, 2005, at 10:14 AM, Ware Adams wrote:
Has your mysql crashed or have your restarted the machine without
first shutting down mysql manually? We only saw this error when
mysql was not shut down normally. You can look in your .err
On Jul 23, 2005, at 12:49 PM, Ware Adams wrote:
Then I don't know what to say about the MyISAM error, though I'd
watch InnoDB pretty carefully as I think MyISAM is pretty robust on
OS X too. We did also see these when a disk is failing, but I
assume you've run disk utility. I guess it
So I've been poking around my system and I found
/usr/lib/mysql/
/usr/share/mysql/
The mod dates on these are really old. Can I delete these safely?
I'm guessing the are from the Apple install.
These files seem to be in the /usr/local/mysql/ path also. Hmmm... I
looked at my old Mac OS
-Original Message-
From: Lou Olsten [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 6:45 AM
To: [EMAIL PROTECTED]
Subject: InnoDB Questions
Need someone with some insight or experience with InnoDB (Heikki?? :-)
a) Where does InnoDB store all of this information (such as
Russ,
you can also use
mysqldump --single-transaction
to back up InnoDB type tables. The advantage of InnoDB Hot Backup over that
method is that InnoDB Hot Backup takes binary backups of the ibdata files.
Restoring a binary backup is much faster than a table dump.
Best regards,
Heikki Tuuri
(ofcourse
other than root) can see the data.
For more info, have a look at:
http://www.mysql.com/doc/en/InnoDB_File_space.html
Enjoy
Nitin
- Original Message -
From: Leo Huang [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 8:00 PM
Subject: Re: InnoDB Questions
(ofcourse
other than root) can see the data.
For more info, have a look at:
http://www.mysql.com/doc/en/InnoDB_File_space.html
Enjoy
Nitin
- Original Message -
From: Leo Huang [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 8:00 PM
Subject: Re: InnoDB Questions
Hello,
first things first, you cann't resize your datafiles without shutting down
your database. if it's ok with you, have a look at
http://www.mysql.com/doc/en/Adding_and_removing.html
you may want to have a look at you my.cnf file, stored in mysql data dir or
in /etc dir, for the default
, November 05, 2003 1:01 AM
Subject: Re: InnoDB Questions
Hello,
first things first, you cann't resize your datafiles without
shutting down
your database. if it's ok with you, have a look at
http://www.mysql.com/doc/en/Adding_and_removing.html
you may want to have a look at you my.cnf file
at:
http://www.mysql.com/doc/en/InnoDB_File_space.html
Enjoy
Nitin
- Original Message -
From: Leo Huang [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 8:00 PM
Subject: Re: InnoDB Questions
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thank you very much
On Tuesday, November 4, 2003, at 07:58 AM, Leo Huang wrote:
In InnoDB documentation, it suggests to add another file ibdata2 to
get higher performance. Can I do that now, after I have created the
ibdata1 and used it for a while?
How exactly does this increase performance? Will InnoDB store some
I don't know.
I will get some time this week, shutdown MySQL, backup my binary files,
have a go as what Nitin said and see what's going on there.
Leo
Gabriel Ricard wrote:
On Tuesday, November 4, 2003, at 07:58 AM, Leo Huang wrote:
In InnoDB documentation, it suggests to add another file
Hello Nitin,
From the timestamp of the log files, it seems that the first two files
works together while the last one seems just sitting there, doesn't do
anything.
Also, will the log files getting bigger and bigger in the future?? If so
how should I deal with them?
For your last suggestion,
The last one you're referring to - could it be the error log?
The log files will only grow to a pre-determined limit. These log files
are used to ensure that transactions maintain their durability.
With Oracle, you'd want to be careful. Oracle gets very, very picky
about the stuff underneath
have data more than the size you're specifying, it'll
through error and wont do nothing.
Nitin
- Original Message -
From: Leo Huang [EMAIL PROTECTED]
To: Nitin [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 5:12 AM
Subject: Re: InnoDB Questions
Hello Nitin
yea, he's right, it may be error log file
Nitin
- Original Message -
From: Chris Nolan [EMAIL PROTECTED]
To: Leo Huang [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 5:53 AM
Subject: Re: InnoDB Questions
The last one you're referring to - could
Chris,
From: Chris Nolan ([EMAIL PROTECTED])
Subject: InnoDB questions for all!
This is the only article in this thread
View: Original Format
Newsgroups: mailing.database.myodbc
Date: 2003-08-28 16:16:53 PST
Hi everyone!
My silly questions for today concern the not-silly-at-all InnoDB table
Hi!
- Original Message -
From: PR [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, September 05, 2002 5:31 PM
Subject: innodb questions about message board apps
Hi all, I've been reading a bit on the innodb table type for mysql here
and
on the site and some other
28 matches
Mail list logo