Re: key_buffer_size vs innodb_buffer_pool_size

The difference in recommendation size comes from the different techniques each storage engine uses for caching data. myisam (key_buffer_size) only stores indexes where innodb_buffer_pool_size stores both indexes and data. mysiam relies on the operating system to cache data in ram which is why you d

ERROR 1114 (HY000): The table is full converting a big table from MyISAM to InnoDB on 5.0.18

Hello! I have a database with a big table (Data File 45 GB, Index File 30 GB). Since I have some performance troubles with "table-locking" in a multi-user environment (when one of them performs a complex query all the other have to wait up to 1 minute, which is not very nice...), I would like to c

pam_mysql + Cyrus IMAP + MySQL 5.0

Dear All, I have a table like this, please do attentiion on password field +--+--+++ | username | password | prefix | domain_name| +--+--+

Re: ERROR 1114 (HY000): The table is full converting a big table from MyISAM to InnoDB on 5.0.18

Hi, I think you should change the tmpdir variable value to a directory which have enough room to create your temp big table (by default, it points to /tmp dir). Regards, Jocelyn Patrick Herber a écrit : Hello! I have a database with a big table (Data File 45 GB, Index File 30 GB). Since

RE: ERROR 1114 (HY000): The table is full converting a big table from MyISAM to InnoDB on 5.0.18

Thanks a lot for your answer! However, when I used the option innodb_file_per_table I saw that the temp file (#sql...) was created in my DB directory and on this partition I still have plenty of space (more than 200GB). Do you think I CAN'T use this option for such a big table and I have to use inn

A difficult query- urgent for me

Dear Friends, I have a problm, try to solve that. Actually there is a table with columns a and b . So i want if a contains a particular word than a's value should return else 'b' value should return. And there must be one and only one column returning. I have mysql 4.x and i think the logic will be

Re: A difficult query- urgent for me

On 1/15/06, [EMAIL PROTECTED] wrote: > > Actually there is a table with columns a and b . > So i want if a contains a particular word than a's value should return else > 'b' value should return. SELECT CASE WHEN a = 'Good' THEN a ELSE b END FROM table Jochem

Help with SQL DELETE issue

Hi, We are using MySQL 4.1.16, recently upgraded from 4.0.18. On the old server we tried not to delete records, as their is a common belief that deleting records will corrupt the table's index and we will have to call repair table. I couldn't find any documentation on that. Unfortunately he

Re: A difficult query- urgent for me

An example of the _data_ would be very helpful here. For example, let's say this is your data: Col_ACol_B ----- aceexpert doghound hungryravenous If you are searching for the word "ace", you should find it. You then want the SQL to return "ace", right? If

Re: Help with SQL DELETE issue

Hi, Excepted if he found a bug in an older version of MySQL, it's of course false ! (it would be a major issue which would make MySQL just unusable) Regards, Jocelyn David Rabinowitz a écrit : Hi, We are using MySQL 4.1.16, recently upgraded from 4.0.18. On the old server we tried not t

Re: MySQL 5.0.15 in Linux OS

Reynier Perez Mira wrote: Hi list: Recently I download MySQL source from MySQL.com site for install it in my Linux Server. I follow the standard procedure for it, means: shell> ./configure shell> make shell> make install That's not what the documentation says to do. Have a look at the INS

Weird behaviour of Load Data

I'm getting some odd behaviour from the 'load data' command which I can't resolve. For some reason, 'load data' is putting a quotation at the end of the first column of the table Here is my table definition: create table if not exists Ref (ref_name varchar(30) not null, ref_org varchar(30) not

Re: Weird behaviour of Load Data

- Original Message - From: "John Doe" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]> Sent: Sunday, January 15, 2006 6:15 PM Subject: Re: Weird behaviour of Load Data Rhino am Sonntag, 15. Januar 2006 23.53: I'm getting some odd behaviour from the 'load data' command which I can

Suse Version 10 Documentation for MYSQL.

Hi MYSQL users. I have just install SuSE Version 10 and need to start working with MYSQL could someone help me out regarding Documentation . Don't seem to be able to find any in the help files. Andrew

Re: Suse Version 10 Documentation for MYSQL.

Andrew, did you install mysql when you installed suse? you might have to fire up YaST and install the rpms. this is a little old... but shoudl help: http://www.novell.com/coolsolutions/feature/595.html this is for 9.1, but the procedure should have remained pretty much the same with suse 10.