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 1
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.
I currently have a customer who we switched over to INNODB from MyISM. It's
a Dell Server with 4GB or Memory and RHEL4 64-bit. It's a fairly big
database the size of the MyISM folders (before we converted to INNODB)
was about 2-3Gigs.
Questions:
1. The ibdata1 file size is 10GB. Does tha
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
Hi,
I recently converted some of my tables to innodb from myisam. I don't need
transactions or rollback capability, I switched because I needed row-level
locking. These are large tables with many rows and lots of INSERTS and UPDATES.
Since changing these tables, I've noticed some large fi
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
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 requests for clarification have
gone unanswered.
> -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 st
d now, undo tablespaces.
Occasionally, if the rollback data overwrites itself, you can get a "Snapshot too old"
message. But you can control the size and number of the rollback segments to fit your
system. So, my InnoDB questions are:
a) Where does InnoDB store all of this informati
AIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, December 22, 2003 1:22 PM
Subject: innodb questions (backup and transactions)
> Hey Guys,
>
> I have just a couple of questions regarding the innodb database type
> that I'd appreciate any advice with. I'm cu
Hey Guys,
I have just a couple of questions regarding the innodb database type
that I'd appreciate any advice with. I'm currently developing a custom
shopping cart / backend and, due to the nature of such a system, would
like to take advantage of transactions - so innodb seems the logical choic
;- 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
to restore data in case of any
crash or mishap.
for further info, have a look at:
http://www.mysql.com/doc/en/InnoDB_start.html
Enjoy
Nitin
- Original Message -
From: "Leo Huang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 6:28 PM
Subject:
;
>Enjoy
>Nitin
>
>
>- Original Message -
>From: "Leo Huang" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Tuesday, November 04, 2003 6:28 PM
>Subject: InnoDB Questions
>
>
>
>
>>Hello,
>>
>>I have a few q
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
start.html
Enjoy
Nitin
- Original Message -
From: "Leo Huang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 6:28 PM
Subject: InnoDB Questions
> Hello,
>
> I have a few questions about InnoDB.
> I am new to InnoDB, and j
Hello,
I have a few questions about InnoDB.
I am new to InnoDB, and just converted my MyISAM tables into InnoDB a
few days ago.
I notice that it generates these files
-rw-rw1 mysqlmysql2560 Nov 2 13:07
ib_arch_log_00
-rw-rw1 mysqlmysql790626304 Nov 4
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-a
Hi everyone!
My silly questions for today concern the not-silly-at-all InnoDB table
backend.
1. If I do an ALTER TABLE tbl_name TYPE=InnoDB on an InnoDB table,
Heikki has
indicated that a defrag of that table should happen. Does anyone have
any comments regarding the
result of a power failure
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
an
Hi all, I've been reading a bit on the innodb table type for mysql here and
on the site and some other board sites and just wanted to ask a quick
question or two in general about it, as it relates mostly to message boards
and compared to myisam. Is the only gotcha in forum code generally the
selec
Hi!
Good questions!
- Original Message -
From: "Michael Bacarella" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, May 16, 2002 6:41 PM
Subject: MySQL/InnoDB questions from a MyISAM background
> We have just migrated a huge installation to
We have just migrated a huge installation to InnoDB from MyISAM.
While I can feel the power and potential and appreciate this
sophistication of what I have at my disposal, I am having some
performance issues that are most likely due to my ignorance.
Answers to the following questions should help
Hi!
I run MySQL 3.23.49 with InnoDB tables on a AlphaServer 4100 with 4 x 600
MHz EV5.6 CPUs with 8 MB cache. The machine has 4 GB memory.
There are about 8 tables. The tables are small in size (only 1-5 GB each)
but has alot of rows (usually > 4 million each).
There are only a few concurrent se
39 matches
Mail list logo
