IN vs. OR on performance

difference between these two pieces of sql. Thank you, -Oscar

Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline

hi all, I have backup all the database files(innodb engine). Now I want to recover it as myisam engine offline. Any suggestions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

who knows the difference between INSERT and UPDATE

hi all, Someone told me that UPDATE equals DELETE old row + INSERT new row. Anybody clarify it? thanks, -Oscar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

ORDER BY favours full scan over a faster filesort

.role_id=2556 order by item0_.id desc; mysql version: 5.1.34 have you guys met this problem? thanks, -Oscar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Cannot connect to mysql through network while unix socket works

r and find the mysqld is running and functional, because I can connect to it via unix socket!!! Things not changed event restart the mysql service, so I have to reboot the server :( Anybody here has the same experience, and how this happened? Oscar Yen.

blocked database by the server

me a mail. I don't speak English well. Thanks Oscar Orellana

Re: blocked database by the server

er anymore? - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Oscar Orellana" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]> Sent: Sunday, December 14, 2003 9:07 PM Subject: Re: blocked database by the server > At 19:41 -050

Replication slave interrupted by "DROP /*!40005 TEMPORARY*/ TABLE ..."

t support under mysql 4.0.12, we have to create temporary tables :< ); I suspect that mysql will drop the temporary tables automatically when associated connection dropped unexpectedly, am I right? Has anybody encountered similar situation, and how he resolved the problem? Thanx Oscar Yen

Strange slow queries

a and b, the result is similar. Thanks you for your attention. Oscar Yen.

Similar simple query slow down dramatically, by just select one more field, why?

N¬™ë,j°jËkj{zºÞw­…«k‰©oz»"¢z ‰¦ºx†j×­˜úèDear all, I have asked the question days before, but no one seems interested in it Considering table imgstore, defined as create table a ( imgid int not null, parent int, imgtype char(3), img longtext, primary key (imgid), key searchke

Re: Similar simple query slow down dramatically, by just select one more field, why?

N¬™ë,j°jËkj{zºÞw­…«k‰©oz»"¢z ‰¦ºx†j×­˜úèThanks for reply. - Original Message - From: "Ludwig Pummer" <[EMAIL PROTECTED]> To: "Oscar Yen" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, February 19, 2004 8:39 AM Subject: Re: Simi

MAX in a SubSelect

here is other way to do that ??? Thanks, Oscar PS. Above the sample script to create the tables needed to run this example query. DROP TABLE VERSOES; CREATE TABLE VERSOES ( IDVERSAO CHAR(4), DATA DATE ) ; DROP TABLE AUDITORIAS; CREATE TABLE AUDITORIAS ( PROGRAMA CHAR(10), AVALIACAO CHAR

Running two MySQL Servers (4.0.x & 4.1.x) in Same Machine

, ===José Oscar de Souza EduardoCoordenador de Projetostel: 3047-4541fax: 3047-4550[EMAIL PROTECTED]===    

1000 rows in MySQLcc

Title: Mensagem Hi, everybody,   I'm using MySQLcc version 0.9.2-beta... I want to recover more than 1000 rows in a select statement... What is the command to alter this setting ???   Thanks,   ===José Oscar de Souza EduardoCoordenad

starting another server

option. Would I need to create different datadirectories? Version is 3.23.40 Regards Oscar === De informatie opgenomen in dit bericht kan vertrouwelijk zijn en is alleen bestemd voor de geadresseerde. Indien u dit bericht onterecht ontvangt

Datawarehousing

ena, where no referential integrity is needed ... (why should we need triggeres and so on , they will slow down the queries), but there is key lack - support for partitioning Cheers Oscar _ Chat with friends online, try MSN Messen

Datawarehousing

Anybody out there using Mysql as a Datawarehouse? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check:

Re: Datawarehousing

what is the size of the warehouse? how do you handle partitioning logic on the database? >From: "Gelu" <[EMAIL PROTECTED]> >To: "Oscar Colino" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> >Subject: Re: Datawarehousing >Date: Fri, 8 Mar 2002

Re: Datawarehousing

MySql scan the full fact_merge table (basically all partitions) This is the way most of the RDBMS systems supporting partitioning work, otherwise you would have to set the partitioning logic on the application side. thanks. >From: "Gelu" <[EMAIL PROTECTED]> >

mysql.sock

how to fix that? Thank you Oscar Mena - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTE

Re: mysql.sock

is not in /etc how do I put that soft link? - Original Message - From: "adam" <[EMAIL PROTECTED]> To: "Oscar Mena" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, June 08, 2002 1:47 PM Subject: Re: mysql.sock > Oscar Mena wrote:

MySQL Troubles, temporary tables

. The temporary files created in /tmp/ “only” become 2-5 Mb, and with a tmp_table_size of 64Mb, that *really* shouldn’t be an issue IMO.   Has anyone bumped into this problem before, or does anyone have any suggestions as to what might be causing the problem?   / Oscar Rylin

RE: Server Error

http://www.geocrawler.com/archives/3/8/2002/6/0/9054036/ / Oscar Rylin -Original Message- From: James Kelty [mailto:[EMAIL PROTECTED]] Sent: den 16 augusti 2002 22:57 To: [EMAIL PROTECTED] Subject: Server Error Hello, Does anyone know, off the top of their head, what server_errno

removing 4 character limit for full text searches

Full text searches in MySQL are limited to 4 characters or more. Is there any simple work around to lower this limit to three characters or more? If there is not, does anyone have any pointers as to where I should start poking around in the code? Thanks, Oscar Nelson

Re: removing 4 character limit for full text searches

At 09:40 PM 10/26/2001 +0200, Sergei Golubchik wrote: >Hi! > >On Oct 26, Oscar Nelson wrote: > > Full text searches in MySQL are limited to 4 characters or more. Is there > > any simple > > work around to lower this limit to three characters or more? If there is &g

urgent respnse

SOS Oscar Malaba oscarmalabaxyahoo.com Bamako Mali Dear sir I know this will come to you out of the blue as a surprise. I write this crucial mail to solicit your assistance in a transaction that will be very beneficial to you, with hope that you will never let me down either now or in

Re: Cant login as a user I thought I created

El Wed, 13 Aug 2003 12:24:58 -0700 (PDT) "Mark Healey" <[EMAIL PROTECTED]> escribio: > I'm trying to learn to use mysql. I don't want to mess with the > system databases so I decided create a database and user to play > with but I can't seem to do it right. > > I logged in as root and created a

Mysql and RHAS

Hello: I have just installed a Linux RHAS 3.0 with mysql-3.23.58-1, mysql-devel-3.23.58-1 and mysql-server-3.23.58-1.9. When mysql starts, there is just listening one mysql-daemon. When I had this configuration running in Redhat 7.3, mysql started 4 daemons. Could someone explain me this be

Mysql and RHAS

Hello: I have just installed a Linux RHAS 3.0 with mysql-3.23.58-1, mysql-devel-3.23.58-1 and mysql-server-3.23.58-1.9. When mysql starts, there is just listening one mysql-daemon. When I had this configuration running in Redhat 7.3, mysql started 4 daemons. Could someone explain me this beha

MySQL + Linux

Hi! Does anybody know how do i change the 'root' password for mysql server? I installation guide they say that it's done by typing '/usr/local/bin/mysqladmin -u root -p password new-password', but how would i know the old passsword? Am i mising anything? Thanks for helping! By the way, i'm fre

Re: Host "" is not allowed to connect to this MySQL Server

I guess if you are updating user columns directly, you need to restart mysqld in order for changes to take effect... I think, that was a case with me... - Original Message - From: "Juan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 27, 2001 5:24 PM Subject: Host "" is

forgot manager password

some kind of recovery procedure? Or can i reinstall without affecting already present databases? thanks to all, oscar -- PGP Key fingerprint = 87 83 5F D3 8D D4 B9 DC 4F 15 B1 68 4E FE 2D AE - Before posting, please check