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
http://dev
:~> -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? Shou
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 database.
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
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 master
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)
/v
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 th
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 in
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
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 co
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 fi
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. Ever
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
> -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
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
In
;- 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
>>
inal 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
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 Quest
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, Novembe
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
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, wh
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 ibd
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 d
a.
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
>
> ---
t;Leo Huang" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, 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
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 option
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 o
28 matches
Mail list logo
