RE: InnoDB problem.

: 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.

; > -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.

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.

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.

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.

- 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.

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

} 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

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

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

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

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

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!?

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!?

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!?

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

"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

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

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

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

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

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)

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

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)

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)

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)

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)

: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

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

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

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