Hello.
Send the piece of 'SHOW PROCESSLIST', 'SHOW STATUS' output and
corresponding configuration file (after applying all previous advices).
It could provide more information to reflection.
Marcin Lewandowski [EMAIL PROTECTED] wrote:
Hi,
I've got webserver. There, I've got
Hello.
See:
http://dev.mysql.com/doc/mysql/en/adding-and-removing.html
Hi,
our logfile size is not set like:
Set the log file size to about 25% of the buffer pool size
Could we remove the actual log file and set the new or is this
important?
Without removing the
The MyIsam storage engine is a non transactional engine and InnoDb is a
transactional engine. That is the main difference. So I think the MyIsam
engine should be faster.
Try to adjust the innodb_thread_concurrency parameter when you have a
lot of users.
Reto
Marcin Lewandowski wrote:
Hi,
I've
Marcin Lewandowski wrote:
Hi,
I've got webserver. There, I've got phpbb2 with circa 6000 users
(average 70-100 users online). There was problems with locking or
something else, when phpbb was using myisam tables. Yesterday, we have
converted tables to innodb, because it should be more
I've changed settings to:
innodb_data_file_path = ibdata1:128M:autoextend
innodb_buffer_pool_size=150M
innodb_additional_mem_pool_size = 50M
and system load is only 2 to 3.
kernel napisa(a):
What does the cpu % show when the machine has the high load avg ?
Now, there are about 50% of normal load
Gary Richardson napisa(a):
Hey,
How much load is system vs user? I found that when my company
converted some large tables on our old server, the concurrent disk IO
increased. Your database server is doing more in parallel and
accessing more from your disk at one time. That would be my guess.
One
I've got IDE hdd. Is there simple way to check, if it's overloaded?
Would RAID1 help? (I don't know if in raid1 there are parralel reads or
maybe one disk is only a mirror)
If it's IDE, probably not. Moving the database to a different
subsystem would give more IO. You can use iostat to check
Marcin Lewandowski wrote:
Hi,
I've got webserver. There, I've got phpbb2 with circa 6000 users
(average 70-100 users online). There was problems with locking or
something else, when phpbb was using myisam tables. Yesterday, we have
converted tables to innodb, because it should be more
Johanne,
- Original Message -
From: Duhaime Johanne [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, April 06, 2005 10:12 PM
Subject: innodb, log_bin and ib_logfiles
--_=_NextPart_001_01C53ADC.86591B2F
Content-Type: text/plain;
charset=us-ascii
Heikki,
See inline.
Heikki Tuuri wrote:
James,
- Original Message - From: James Green
[EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, April 04, 2005 1:28 PM
Subject: Innodb: Alter table progress
Hi,
Is there any way of checking the progress of an ALTER TABLE query on
James,
- Original Message -
From: James Green [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, April 05, 2005 11:06 AM
Subject: Re: Innodb: Alter table progress
Heikki,
See inline.
Heikki Tuuri wrote:
James,
- Original Message - From: James Green
[EMAIL
Hello.
I think, you should recreate an InnoDB tablespace on a new
server and import the data exported with mysqldump. If you
remove the database directory and InnoDB files, on startup
server recreates InnoDB tablespace and then you should be able
to import the data from the old server.
James,
- Original Message -
From: James Green [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, April 04, 2005 1:28 PM
Subject: Innodb: Alter table progress
Hi,
Is there any way of checking the progress of an ALTER TABLE query on
an InnoDB table? show innodb status
On Mar 31, 2005, at 1:13 AM, Rafal Kedziorski wrote:
I'm working with JBoss and MySQL 4.0.22 (and 4.0.18 on Testsystem).
But under the load, I get sometimes Exceptions like this:
java.sql.SQLException: Deadlock found when trying to get lock; Try
restarting transaction message from server: Lock
To me what is more important is where this is leading,
http://www.distlab.dk/badger/Publications/exec_summary.pdf
a true parallel database cluster, with the end goal of this
work being a parallel MySQL.
My cluster waits ..
-pete
On Mon, 2005-02-28 at 14:04, Greg Whalin wrote:
Just found
]
Newsgroups: mailing.database.myodbc
Sent: Sunday, February 27, 2005 12:33 AM
Subject: Re: InnoDB Rollback - 162 hrs remaining!?
John,
- Original Message -
From: John Taylor [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 26, 2005 11:37 PM
Subject: Re: InnoDB
John,
- Original Message -
From: John Taylor [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 26, 2005 6:54 PM
Subject: InnoDB Rollback - 162 hrs remaining!?
Hi,
We have a large InnoDB table to which we recently added an index. That
index creation thread
Thanks for the quick response. I note within the database directory a
#sql- file but it has not been modified for two days, around the time
the index was begun.
Does this have a bearing on matters? Last thing we need is to kill
mysqld processes and find the innodb data file is corrupt beyond
John,
- Original Message -
From: John Taylor [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 26, 2005 11:37 PM
Subject: Re: InnoDB Rollback - 162 hrs remaining!?
Thanks for the quick response. I note within the database directory a
#sql- file but it has
Greg,
- Original Message -
From: Greg Whalin [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, February 24, 2005 12:04 AM
Subject: Innodb - raw partition vs filesystem store?
What are pros/cons as far as performance, reliability, and ease of
backup/restore?
Anyone
Heikki Tuuri wrote:
A journaling file system like ReiserFS does not help if fsync does not
work. A journaling file system itself is actually a bit like a
transactional database. A broken fsync might cause bad damage there.
I would be happy if users tested the 'pull-the-plug' performance of
Begumisa Gerald M [EMAIL PROTECTED] wrote on 02/22/2005 02:03:43 AM:
Hi,
I'm writing an application that uses InnoDB tables to provide
transactional integrity. The front-end is a web-based interface.
I'd like to know - is there a way one can issue a query to test whether
a
particular
Hi
I must be blind. Please help a DB-Newbie. What's wrong here:
create table users (
email varchar (80) unique not null,
ownerdomain int not null,
foreign key (ownerdomain) references domains on delete cascade
) type=innodb;
MySQL sais: ERROR 1005: Can't create table
think
you'll see what's wrong with your statement. If you fix that, I think your
table will be created correctly.
Rhino
- Original Message -
From: Philipp Snizek [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, February 22, 2005 11:08 AM
Subject: RE: InnoDB Row Lock test (A query
Hi Shawn,
Thanks for taking time to respond to this.
[...]Usually the database sets and releases locks like that in
response to a series of statements on the order of sub-seconds, not
for the several seconds to minutes that may be required of an
application-level lock).
Ivan,
- Original Message -
From: Latindeveloper [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, February 20, 2005 10:51 PM
Subject: InnoDB Files
Hi to all,
I'm working with mysql 4.1, the InnoDb files are ~1.5Gb.
The question is: How to compress a inndodb data file?
James,
page number 22357 is corrupt. InnoDB Hot Backup notices these checksum
errors, and refuses to do the backup. Sometimes it happens that an unused
(i.e., freed) page in an ibdata file becomes corrupt. Then it would be nice
to have some tool to reset the checksums on that page, so that
James,
We've had this issue twice (every 4 months) - running on 4.0.20 - due to
an old kernel (we just upgraded the kernel after the last issue).
Do you have a replicated (slave) database? We shut down the master and
then the slave (a few minutes after the master to let all changes
propigate),
Ben,
- Original Message -
From: Ben Kutsch [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, February 15, 2005 1:55 AM
Subject: innodb error 995
Hi I'm running version MySQL 4.0.20a-debug
windows server 2003
on a dedicated database server with an external SCSI RAID
http://dev.mysql.com/doc/mysql/en/innodb-auto-increment-column.html
Rishi Daryanani wrote:
Hi,
My database is mostly made up of MyIsam tables, and some InnoDB tables.
One particular Innodb table works fine with an auto increment field.
The table is updated often, records being added and deleted at
You may want to read this section of the manual:
http://dev.mysql.com/doc/mysql/en/innodb-auto-increment-column.html
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Rishi Daryanani [mailto:[EMAIL PROTECTED]
Sent: Friday, February 11, 2005
Devananda,
the ALTER TABLE creates a temporary table #sql... The rollback is running in
that table. The manual contains instructions on how to rename and drop such
table.
You should upgrade to 4.1.9. That version commits ALTER TABLE at every 10
000 rows, and a runaway rollback can no longer
On Tue, 8 Feb 2005, Heikki Tuuri wrote:
You should upgrade to 4.1.9. That version commits ALTER TABLE at every 10
000 rows, and a runaway rollback can no longer happen.
This is very nice!
Are there any plans for the same with INSERT ... SELECT -type statements?
--
MySQL General Mailing List
Tobias,
- Alkuperäinen viesti -
Lähettäjä: Tobias Asplund [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
Kopio: mysql@lists.mysql.com
Lähetetty: Tuesday, February 08, 2005 7:46 PM
Aihe: Re: InnoDB crash and runaway rollback - help pls
On Tue, 8 Feb 2005, Heikki Tuuri
Assuming that the record named B is insterted using connection 2, and the
transaction is started and rolled back using connection 1, that record should
not be rolled back.
You can experiment with things like that easily from multiple terminal windows
or a graphical client.
-Original
Andre Matos wrote:
Hi List,
Let's suppose that I have this sequence of events:
- create a connection 1
-- start a transaction
--- create a new connection 2
insert a new record named B
--- close the connection 2
--- insert a new record named A
-- rollback
- close the connection 1
This sequence
Hello.
Use the max attribute. See:
http://dev.mysql.com/doc/mysql/en/innodb-configuration.html
If you want to decrease the size of your tablespace, see:
http://dev.mysql.com/doc/mysql/en/adding-and-removing.html
[EMAIL PROTECTED] wrote:
Hello, my name's Matteo, probably my
Matteo,
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, February 04, 2005 3:51 PM
Subject: innodb problem
Hello, my name's Matteo, probably my question
is basic but I'm new with mysql.
I've an application that write some milion of row in
Ed Patterson wrote:
Do I need to recompile MySQL to enable innodb tables, maybe I should
simply go buy another book on MySQL that does not require innodb :-)
Maybe -- better -- you should simply remove this crippled version
of MySQL, wherever it came from, and get a binary from MySQL.com. :-)
default-storage-engine=INNODB in [mysqld] section of the config file will make
InnoDB default for a server.
-Original Message-
From: symbulos partners [mailto:[EMAIL PROTECTED]
Sent: Friday, January 28, 2005 8:03 AM
To: mysql@lists.mysql.com
Subject: InnoDB engine as default for an
Hello.
You can change it by using the --default-storage-engine or --default-table-type
server startup option, or by setting the storage_engine or table_type system
variable.
See:
http://dev.mysql.com/doc/mysql/en/storage-engines.html
symbulos partners [EMAIL PROTECTED] wrote:
Hello.
In my opinion, you should use SERIALIZABLE transaction isolation level or
SELECT ... LOCK IN SHARE MODE.
?ngelo M. Rigo [EMAIL PROTECTED] wrote:
[-- text/plain, encoding 8bit, charset: iso-8859-1, 25 lines --]
Hi
I am using innodb tables to implement transactions on my
Hello.
Use:
set autocommit=0;
or begin a transaction before executing 'select ... lock in share mode'.
Commit the tramsaction to release lock.
Mojtaba Faridzad [EMAIL PROTECTED] wrote:
Hi,
I am trying to learn more about InnoDB to convert MyISAM to InnoDB.
according to MySQL
Sirisha,
you cannot remove just a single ibdata file:
http://dev.mysql.com/doc/mysql/en/Adding_and_removing.html
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
Hi,
I'm not sure if this reply to your problem, but it will surely put you
on the correct answer.
http://dev.mysql.com/doc/mysql/en/InnoDB_Next-key_locking.html
Philip Ross wrote:
MySQL 4.1.8
I have an InnoDB table with a unique constraint:
CREATE TABLE TEST (
ID bigint NOT NULL
Richard,
- Original Message -
From: Richard F. Rebel [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, January 12, 2005 8:07 PM
Subject: InnoDB files corrupt after copy to another disk???
--=-55yKssoEPEmA1J8GXefY
Content-Type: text/plain
Content-Transfer-Encoding:
Ian,
- Original Message -
From: Ian Grant [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, January 05, 2005 4:47 PM
Subject: Re: InnoDB: Error: tablespace size stored in header is 17024 pages,
Dear Heikki
Many thanks for your reply.
On Mon, 3 Jan 2005 20:41:22
On Thu, 6 Jan 2005 11:30:33 +0200
Heikki Tuuri [EMAIL PROTECTED] wrote:
innodb_data_file_path = ibdata2:7M;ibdata1:10M:autoextend
You have to add new data files to the end of the line, not to the
start. Please follow the instructions at
Dear Heikki
Many thanks for your reply.
On Mon, 3 Jan 2005 20:41:22 +0200
Heikki Tuuri [EMAIL PROTECTED] wrote:
are you sure that you copied the complete ibdata1 file to the new
place? It is strange how 7 MB can be missing from the file end.
I have just checked the tar file I used to do the
Ian,
are you sure that you copied the complete ibdata1 file to the new place? It
is strange how 7 MB can be missing from the file end.
What does the old .err log contain? Any message about disk space running
out?
The error below probably has not corrupted your tablespace. Best to run
CHECK
Dave,
please post the first errors in the .err log. I want to know what the
original problem was. The error below probably comes from that you have set
innodb_force_recovery=SRV_FORCE_NO_LOG_REDO
Note that Red Hat kernels 2.4.18 are suspected to cause file corruption
easily.
Best regards,
Frank,
- Original Message -
From: Frank Denis (Jedi/Sector One) [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, December 13, 2004 12:25 AM
Subject: InnoDB status: why do I see MyISAM requests?
Just curious...
While running SHOW INNODB STATUS, the list of
Depends on your disk setup. Remember a table space is a virtual
filesystem that sits on top of the OS. Having one large file and
chopping a contiguous block of the disk out enables better seeks as well
as caching if the file doesn't bust the system cache. In your case it
will. One file needs to be
Paul,
- Original Message -
From: Paul Mallach [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, December 06, 2004 4:26 PM
Subject: innodb: TRUNCATE vs. DELETE FROM
Hi!
Is TRUNCATE optimized for innodb tables in MySQL 4.1.7?
Richard,
- Original Message -
From: Richard F. Rebel [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, November 30, 2004 6:11 PM
Subject: InnoDB Log and binlog files and Solid State Disk?
--=-JDf9WlMx8c01FXMbzrGw
Content-Type: text/plain
Content-Transfer-Encoding:
' port: 3307 Source
distr
ibution
- Original Message -
From: Carlos Augusto [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, November 25, 2004 8:59 PM
Subject: Re: Innodb Corruption with error logs now.
ib_logfile is different from ibdata1.=20
Just
, 2004 6:11 PM
Aihe: Re: Innodb Corruption with error logs now.
Well look what i did: I changed innodb_log_file_size as you asked me
for 5M and then i tryed to start mysqld again then i it doesnt run.
And the output at err.log was this one:
I will remember that ibdata1 is my old corrputed data
PM
Aihe: Re: Innodb Corruption with error logs now.
Well look what i did: I changed innodb_log_file_size as you asked me
for 5M and then i tryed to start mysqld again then i it doesnt run.
And the output at err.log was this one:
I will remember that ibdata1 is my old corrputed
Carlos,
- Original Message -
From: Carlos Augusto [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, November 26, 2004 8:46 PM
Subject: Re: Innodb Corruption with error logs now.
Well Heikki i don=B4t have those .frm and i don=B4t know the 'structure'
of the corrputed
Calos,
Well i didn´t change nothing at no config file. Any suggestions?
thanks.
If you didn´t change anything, it´s supposed to be time to you
configure the my.cnf file.
A better tunning should solve your problem.
Ronan
--
MySQL General Mailing List
For list archives:
Carlos,
when filing bug reports for any software, not just MySQL, you should provide
the full information. You should not try to pick the relevant material
yourself.
What do you have in your my.cnf file? What does the '/data' directory
contain?
The errors below look like you would have at
ib_logfile is different from ibdata1.
Just because i get the database without Ib_logfiles...
I´m sorry, i´m sending now my.cnf and what is in /data directory
Dir:
11/25/2004 04:51 PMDIR .
11/25/2004 04:51 PMDIR ..
11/15/2004 11:31 AM 5,010,096,128 ibdata1
]
Newsgroups: mailing.database.myodbc
Sent: Thursday, November 25, 2004 8:59 PM
Subject: Re: Innodb Corruption with error logs now.
ib_logfile is different from ibdata1.=20
Just because i get the database without Ib_logfiles...
I=B4m sorry, i=B4m sending now my.cnf and what is in /data directory
Dir
well i´m having another problem now... I changed innodb_force_recovery
for 1 and mysql is not running due the following error:
041124 14:13:18 Innodb: fatal error: cannot allocate 2147500032 bytes of
innodb: memory with malloc! total allocated memory
innodb: by inndodb 16975556 bytes. Operating
Carlos,
041124 14:13:18 Innodb: fatal error: cannot allocate 2147500032 bytes of
innodb: memory with malloc! total allocated memory
innodb: by inndodb 16975556 bytes. Operating system errno: 8
innodb: Cannot continue operation!
innodb: check if you should increase the swap file of ulimits
Well i didn´t change nothing at no config file. Any suggestions?
thanks.
Sorry all for those lots of questions... i´m new at mysql and I need
it very much at my job.
and sorry for the english too.
On Wed, 24 Nov 2004 16:20:57 -0200, Ronan Lucio [EMAIL PROTECTED] wrote:
Carlos,
041124
Carlos,
I asked you to post the COMPLETE .err log. Do NOT cut anything off.
Regards,
Heikki
- Original Message -
From: Carlos Augusto [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, November 24, 2004 7:38 PM
Subject: Re: Innodb corrpution. Very Urgent
well i=B4m
Carlos,
- Original Message -
From: Carlos Augusto [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, November 22, 2004 10:37 PM
Subject: Innodb corrpution. Very Urgent
Hello, i=B4m having a problem with a large database...
at ibdata1.My ibdata1 is corrupted and i saw
: Thursday, November 11, 2004 9:59 PM
Subject: Re: InnoDB data files keep growing with innodb_file_per_table
John,
please zip ibdata1, which is 'only' 100 MB, and upload it when you
have shut
down mysqld.
I have been simulating your workload, but I only get 25 segments. No leak
seen.
Regards,
Heikki
MySQL technical support from https://order.mysql.com/
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, November 11, 2004 9:59 PM
Subject: Re: InnoDB data files keep growing with innodb_file_per_table
John,
please zip ibdata1
When ever you use INNODB it must create a table space, something like a
virtual file space or system for the data, that sits on top of the OS
filesystem. By default it has allocated a certain size, change the value of
innodb_data_file_path = ibdata1:500M:autoextend:max:2000M
500M back to the
Hristo,
thank you for the bug report. I broke the
:autoextend:max:2000M
feature when I added multiple tablespaces in 4.1.1.
The bug is fixed in 4.1.8.
Unfortunately, InnoDB does not automatically add 2000 MB files if you
specify the max. You have to add additional ibdata files manually, as
Ivan,
- Original Message -
From: John B. Ivski [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, November 11, 2004 4:55 AM
Subject: Re: InnoDB data files keep growing with innodb_file_per_table
Heikki,
the output shows that there are no dangling transactions
to
support.mysql.com/pub/mysql/secret
My guess is that if you rebuild the tablespace, the leak problem will go
away.
Regards,
Heikki
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, November 11, 2004 10:16 AM
Subject: Re: InnoDB data files
are there.
Anyway, if we get the ibdata files, it should be relatively easy to find out
what is wrong.
Regards,
Heikki
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 11, 2004 2:17 PM
Subject: Re: InnoDB data files keep growing
Heikki,
Heikki Tuuri wrote:
InnoDB is clearly leaking 'segments' in the system tablespace. They are
probably undo logs. For some reason, a trx commit or purge fails to free
them.
SEGMENT id 0 75994 space 0; page 82136; res 2720 used 2680; full ext 41
fragm pages 32; free extents 0; not full
Heikki Tuuri wrote:
Ivan,
hmm... could it be that segments 0 1, 0 2, 0 3, etc. were printed close
to the end of the output? The print routine first prints inode pages
that are completely used, and after that other inode pages. Since the
tablespace validation said the tablespace is ok, I guess
Heikki,
Heikki Tuuri wrote:
hmm... could it be that segments 0 1, 0 2, 0 3, etc. were printed close
to the end of the output? The print routine first prints inode pages
that are completely used, and after that other inode pages. Since the
tablespace validation said the tablespace is ok, I guess
Sasha,
- Original Message -
From: Sasha Pachev [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, November 11, 2004 8:05 PM
Subject: Re: InnoDB data files keep growing with innodb_file_per_table
Heikki Tuuri wrote:
Ivan,
hmm... could it be that segments 0 1, 0 2, 0 3
: mailing.database.myodbc
Sent: Thursday, November 11, 2004 8:17 PM
Subject: Re: InnoDB data files keep growing with innodb_file_per_table
Heikki,
Heikki Tuuri wrote:
hmm... could it be that segments 0 1, 0 2, 0 3, etc. were printed close
to the end of the output? The print routine first prints inode pages
Message -
From: John B. Ivski [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, November 10, 2004 4:25 AM
Subject: Re: InnoDB data files keep growing with innodb_file_per_table
Heikki,
Heikki Tuuri wrote:
John,
please post what SHOW INNODB STATUS says. The probable reason
: Heikki Tuuri [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, November 11, 2004 1:55 AM
Subject: Re: InnoDB data files keep growing with innodb_file_per_table
John,
the output shows that there are no dangling transactions, and purge is not
lagging behind.
If you update a secondary
Heikki,
the output shows that there are no dangling transactions, and purge is
not lagging behind.
Yes, that's what I thought... weird, huh :/
If you update a secondary index column, that requires purge to clean up
the index.
The tables have structure similar to the following:
create table
Heikki,
I can think of another explanation. Are you sure that all your tables
really are in .ibd files? Maybe some older tables are actually in the
ibdata files?
Yes I'm sure they're all in .ibd files (and I've just checked just in case
- they are indeed).
Please use the
John,
please post what SHOW INNODB STATUS says. The probable reason is that there
are long transactions, or that purge is falling behind.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also
Heikki,
Heikki Tuuri wrote:
John,
please post what SHOW INNODB STATUS says. The probable reason is that
there are long transactions, or that purge is falling behind.
Best regards,
Heikki Tuuri
Actually, I have no idea why purge was falling behind, since no row has ever been deleted from
In article [EMAIL PROTECTED],
James Green [EMAIL PROTECTED] writes:
Unfortunately when we repeated on the live server, whilst we got a
200% performance boost (estimate) again, we failed to notice that
innodb is in DISABLED state, and yet alter table returned ok.
It's one of the ugliest
You can determine table type with
SHOW CREATE TABLE table_name
or
SHOW TABLE STATUS LIKE 'table_name';
From the manual http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html, If
a storage engine is specified that is not available, MySQL uses MyISAM
instead. That applies to ALTER as well as to
Check out this section in the manual on innodb log files.
http://dev.mysql.com/doc/mysql/en/Adding_and_removing.html
-Eric
On Thu, 28 Oct 2004 15:47:27 -0500, Oropeza Querejeta, Alejandro
[EMAIL PROTECTED] wrote:
Hi,
How can i increase the size of the log file and log buffer size?
i
On Tue, 2004-10-26 at 10:00, Jason Davis wrote:
hello,
my co-worker just tryed to create a InnoDB table on our running db and
then all the sudden the db hangs for a minute then INNODB TABLE MONITOR
comes on and starts writing to db.err file is this normal for the
table monitor to
Hello Heikki,
you have to use a fairly recent 4.0 or 4.1 version of MySQL.
Does a newer version allow you to change/set the names yourself?
you can give the name yourself in new versions. Please look at the InnoDB
manual section.
A constraint name can be given as of MySQL 4.0.18
Ah, by
Martijn,
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, October 20, 2004 10:08 AM
Subject: Re: Innodb foreign keys names
Hello Heikki,
you have to use a fairly recent 4.0 or 4.1 version of MySQL.
Does a newer version
Hello Heikki,
you have to use a fairly recent 4.0 or 4.1 version of MySQL.
Does a newer version allow you to change/set the names yourself?
you can give the name yourself in new versions. Please look at the
InnoDB
manual section.
A constraint name can be given as of MySQL
: www.cedricom.com
Heikki Tuuri [EMAIL PROTECTED] a écrit dans le message news:
[EMAIL PROTECTED]
Martijn,
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, October 20, 2004 10:08 AM
Subject: Re: Innodb foreign keys names
Martijn,
- Alkuperinen viesti -
Lhettj: Martijn Tonies [EMAIL PROTECTED]
Vastaanottaja: [EMAIL PROTECTED]
Kopio: [EMAIL PROTECTED]
Lhetetty: Wednesday, October 20, 2004 11:34 AM
Aihe: Re: Innodb foreign keys names
Hello Heikki,
...
Thank you for your reply.
One quick question
Richard,
you have to use a fairly recent 4.0 or 4.1 version of MySQL.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL
Heikki,
you have to use a fairly recent 4.0 or 4.1 version of MySQL.
Does a newer version allow you to change/set the names yourself?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server.
Upscene Productions
http://www.upscene.com
backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL support from http://www.mysql.com/support/index.html
...
From: David Edwards ([EMAIL PROTECTED])
Subject: Re: InnoDB deadlock problem
View: Complete Thread (3 articles)
Original Format
Martijn,
List: mysql
Subject:Re: Innodb foreign keys names
From: Martijn Tonies m.tonies () upscene ! com
Date: 2004-10-19 9:53:28
Message-ID: 01ad01c4b5c1$7c1e69a0$0a02a8c0 () martijn
[Download message RAW]
Heikki,
you have to use a fairly recent 4.0 or 4.1 version
Boyd,
sorry, only the output of innodb_monitor can be accessed through an SQL
statement. The other monitors contain information mostly for special error
situations.
But it is in the TODO to implement
SHOW LOCKS ...
That would be useful for application developers.
Best regards,
Heikki
501 - 600 of 1574 matches
Mail list logo