What's the MySQL error log have to say?
- Original Message -
From: Luis H. Forchesatto luisforchesa...@gmail.com
To: Johan De Meersman vegiv...@tuxera.be
Sent: Tuesday, 23 July, 2013 3:39:55 PM
Subject: Re: InnoDB problem.
Yep, I do backup of /home/mysql/ib* files too :D
What
-
From: Luis H. Forchesatto luisforchesa...@gmail.com
To: Johan De Meersman vegiv...@tuxera.be
Sent: Tuesday, 23 July, 2013 6:34:47 PM
Subject: Re: InnoDB problem.
The error log:
130723 10:04:23 [ERROR] Plugin 'InnoDB' init function returned error.
130723 10:04:23 [ERROR] Plugin 'InnoDB
Did you change innodb_log_file_size?
-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be]
Sent: Tuesday, July 23, 2013 9:57 AM
To: Luis H. Forchesatto; mysql list
Subject: Re: InnoDB problem.
Eek.
No immediate clue here, but maybe someone else does - so please
-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be]
Sent: Tuesday, July 23, 2013 9:57 AM
To: Luis H. Forchesatto; mysql list
Subject: Re: InnoDB problem.
Eek.
No immediate clue here, but maybe someone else does - so please keep the
list in CC at all times
: Re: InnoDB problem.
2013/7/23 Rick James rja...@yahoo-inc.commailto:rja...@yahoo-inc.com
Did you change innodb_log_file_size?
innodb_log_file_size error always appears in the logs...he only posted a few
lines of his log...but I guess (or I want to believe) he's gone through the
whole log
Greetings.
I've restored an MySQL backup from our MySQL server into another server.
The backup includes InnoDB tables. After the import, MySQL recognized the
innodb tables fine but when I try to do a check table ir returns that the
table doesn't exists.
Permission and owner of the table files
- Original Message -
From: Luis H. Forchesatto luisforchesa...@gmail.com
Subject: InnoDB problem.
Permission and owner of the table files (.frm files) are ok, since it
recognizes MyISAM tables (they have the same permission).
Oops. You should always read the fine manual.
You took
,
(ulong)page_number, file_name);
return(0);
}
- Original Message -
From: James Green [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, February 18, 2005 5:53 PM
Subject: InnoDB: Problem with innobackup
Hi,
On running the hot backup tool we
Hi,
On running the hot backup tool we receive:
ibbackup: Re-reading page at offset 0 366297088 in /var/lib/mysql/data/ibdata1
ibbackup: Re-reading page at offset 0 366297088 in /var/lib/mysql/data/ibdata1
050218 15:18:01 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex
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),
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 mysql innodb
table. Every day my application creates a new table, write data
and drop table oldest than 15 days.
After the drop table execution command the disk space
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
Hi
Recently we performed an 'alter table' on a dev box to change from
myisam to innodb, and it resulted in considerable speed improvement. in
the lab setting.
Unfortunately when we repeated on the live server, whilst we got a 200%
performance boost (estimate) again, we failed to notice that
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
Matt Chatterley [EMAIL PROTECTED] wrote:
Hi folks. I have a problem creating a foreign key constraint which I just
don't seem to be able to figure out.
There are three tables, for which the 'show create' output is given below:
CREATE TABLE `users` (
`UserID` int(11) unsigned NOT NULL
Hi folks. I have a problem creating a foreign key constraint which I just
don't seem to be able to figure out.
There are three tables, for which the 'show create' output is given below:
CREATE TABLE `users` (
`UserID` int(11) unsigned NOT NULL auto_increment,
`ContactID` int(10) unsigned NOT
On Tuesday 18 March 2003 02:26, Custódio de Matos Lima wrote:
Im having some troubles when creating the foreign key
constraints in a InnoDB database. The problem is, i
can create the InnoDB table, but im having a little
difficult to make the connections with other tables.
The error that
Hello,
I´m having some troubles when creating the foreign key
constraints in a InnoDB database. The problem is, i
can create the InnoDB table, but i´m having a little
difficult to make the connections with other tables.
The error that apears is like that:
Erro
Comando SQL :
alter table
I am a new user of mysql
I installed 3.23.51 on my nt
this is my my.ini files.
[mysqld]
innodb_data_home_dir =
innodb_data_file_path = ibdata1:30M:autoextend
default-table-type=innodb
[WinMySQLAdmin]
Server=C:/mysql/bin/mysqld-max-nt.exe
When I use the winmysqladmin it report in HAVE_INNODB
Massimo,
Tuesday, July 16, 2002, 1:02:15 PM, you wrote:
MP I am a new user of mysql
MP I installed 3.23.51 on my nt
MP this is my my.ini files.
MP [mysqld]
MP innodb_data_home_dir =
MP innodb_data_file_path = ibdata1:30M:autoextend
MP default-table-type=innodb
MP [WinMySQLAdmin]
MP
Hi,
We are currently facing the same problem (Deadlock found when trying to
get lock; Try restarting transaction)
in our production environnement. We are using InnoDB tables (mysqk
3.23.48-max) with
Jboss 2.4.4 and JDBC driver mm.mysql-2.0.11-bin.jar / RedHat 7.1.
Could you please tell me how to
Maciek,
At 12:20 PM 11/9/01 +0100, you wrote:
please show us the CREATE TABLE statements and what EXPLIN SELECT ... says
about both table types.
CREATE TABLE `stats_InnoDB` (
`id` int(10) unsigned NOT NULL auto_increment,
`ident` char(100) NOT NULL default '',
`class` int(2) unsigned
,
Heikki
http://www.innodb.com
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 19, 2001 3:11 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: innodb problem (with JDBC/transactions)
Erik,
run the MySQL server mysqld from a command prompt
Erik,
run the MySQL server mysqld from a command prompt and do with
the mysql client:
mysqlcreate table innodb_lock_monitor(a int) type = innodb;
(assuming you run a recent version).
Then mysqld will print lock information to the standard output
and you see what is happening.
Regards,
: innodb problem
Nope, it's not the SHOW TABLE STATUS that return the error but the java
program
that is doing the insert.
For the ouput of the innodb monitor i'll see it tomorrow when i'll be back
to the office.
Thanks
Jean-Philippe
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED
Jamie,
really strange. Now I start to suspect the file system. InnoDB should create
and write a file of size 2000 MB like you specified in my.cnf.
InnoDB does the initial file write in 1 MB chunks using pwrite,
calling fsync in between.
When you restart MySQL, InnoDB checks if the data file is
-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 11:24 AM
To: Jamie Krasnoo; [EMAIL PROTECTED]
Subject: RE: InnoDB problem
Jamie,
really strange. Now I start to suspect the file system. InnoDB should create
and write a file of size 2000 MB like you specified
29 matches
Mail list logo