RE: InnoDB problem.

2013-07-23 Thread Rick James
: Re: InnoDB problem. 2013/7/23 Rick James mailto: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 before s

Re: InnoDB problem.

2013-07-23 Thread Manuel Arostegui
; > -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, bu

RE: InnoDB problem.

2013-07-23 Thread Rick James
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,

Re: InnoDB problem.

2013-07-23 Thread Johan De Meersman
ssage - > From: "Luis H. Forchesatto" > To: "Johan De Meersman" > 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 [E

Re: InnoDB problem.

2013-07-23 Thread Johan De Meersman
What's the MySQL error log have to say? - Original Message - > From: "Luis H. Forchesatto" > To: "Johan De Meersman" > Sent: Tuesday, 23 July, 2013 3:39:55 PM > Subject: Re: InnoDB problem. > Yep, I do backup of /home/mysql/ib* files too :D &g

Re: InnoDB problem.

2013-07-22 Thread Johan De Meersman
- Original Message - > From: "Luis H. Forchesatto" > 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. Yo

InnoDB problem.

2013-07-22 Thread Luis H. Forchesatto
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 (.f

Re: InnoDB: Problem with innobackup

2005-02-19 Thread Heikki Tuuri
} close(file); printf("lsn and checksum fields of page %lu in file %s reset\n", (ulong)page_number, file_name); return(0); } - Original Message - From: "James Green" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sen

Re: InnoDB: Problem with innobackup

2005-02-18 Thread David Griffiths
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),

InnoDB: Problem with innobackup

2005-02-18 Thread James Green
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 eeaefd1a0

Re: innodb problem

2005-02-04 Thread Heikki Tuuri
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

Re: innodb problem

2005-02-04 Thread Gleb Paharenko
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 questi

innodb problem

2005-02-04 Thread matteo . pozzi
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

Re: InnoDB problem, yet performance increased!?

2004-11-02 Thread Michael Stassen
You can determine table type with SHOW CREATE TABLE table_name or SHOW TABLE STATUS LIKE 'table_name'; From the manual , "If a storage engine is specified that is not available, MySQL uses MyISAM instead." That applies to ALTER as well as

Re: InnoDB problem, yet performance increased!?

2004-11-02 Thread Harald Fuchs
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

InnoDB problem, yet performance increased!?

2004-11-02 Thread James Green
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 inn

Re: 5.0 InnoDB problem - ADD CONSTRAINT

2004-04-02 Thread Egor Egorov
"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 NO

5.0 InnoDB problem - ADD CONSTRAINT

2004-04-01 Thread Matt Chatterley
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

re: InnoDB Problem

2003-03-18 Thread Egor Egorov
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 th

InnoDB Problem

2003-03-17 Thread Custódio de Matos Lima
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 tab3

Re: innodb problem

2002-07-16 Thread Egor Egorov
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> S

innodb problem

2002-07-16 Thread Massimo Petrini
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 d

RE: innodb problem (with JDBC/transactions)

2002-04-24 Thread Jean-Baptiste Gadenne
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 f

Re: Slooow InnoDB problem

2001-11-09 Thread Heikki Tuuri
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) uns

RE: innodb problem (with JDBC/transactions)

2001-10-28 Thread Heikki Tuuri
all COMMIT to release the locks. > JDBC Driver: mm.mysql-2.0.6.1.jar > MySQL: mysql-max-3.23.42-win > >Thanks, > >Erik Regards, Heikki http://www.innodb.com >-Original Message- >From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] >Sent: Friday, October 19, 2

RE: innodb problem (with JDBC/transactions)

2001-10-27 Thread Erik
e. PLEASE HELP! JDBC Driver: mm.mysql-2.0.6.1.jar MySQL: mysql-max-3.23.42-win Thanks, Erik -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 (

Re: innodb problem (with JDBC/transactions)

2001-10-19 Thread Heikki Tuuri
Erik, run the MySQL server mysqld from a command prompt and do with the mysql client: mysql>create 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, Heikk

RE: innodb problem (with JDBC/transactions)

2001-10-18 Thread Erik
:04 PM To: [EMAIL PROTECTED] Subject: Re: 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 --

RE: InnoDB problem

2001-05-16 Thread Jamie Krasnoo
al Message- 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 sp

RE: InnoDB problem

2001-05-16 Thread Heikki Tuuri
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

InnoDB problem

2001-05-15 Thread Jamie Krasnoo
I complied MySQL as a max binary. However when I gave all the variables for InnoDB in the my.cnf startup file it seems that InnoDB gets initialized for the first time only. With mysqld going fine, I try to connect using the client and the server with it on really seems sluggish. I put in the passw