Google like search string to be implemented

Hi Friends, I am having a database with varchar(255) columns named title, extra_info1,extra_info2,extra_info3 . I want to search all these columns with a search string given to me via a form ,I am using PERL, the string will be like +abhishek jain -abcd "this should be exact" As you can see the

*.MYI was corrupted with OS crash when lots of rows were inserting

Hi all, when I insert many records into a myisam type table, at the same time, unplugged the power cable, the os crash, I found several *.MYI file was corrupted, but can use "repair" or "myisamchk" to repair those table. Is there any way to avoid this happen? my env: OS--->Linux-2.6.9smp f

Re: help me optimize this "ALL"

thank you - Original Message - From: "Jay Pipes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: Sent: Tuesday, March 06, 2007 4:29 AM Subject: Re: help me optimize this "ALL" > No, because you have no WHERE condition. > > wangxu wrote: >> sql: >> >> SELECT * >> FRO

Re: Replication performance questions

On Fri, Mar 02, 2007 at 12:57:25AM -0800, Gary W. Smith wrote: > Pdns? Close! bind-dlz > Anyway, did you enable the slow query logging? That still might give > you an idea if something is running slow. But I also forgot to ask > earlier, what is running slow, the inserts or the selects during

Re: List of ports which should be opened for IPTABLES

When it comes to clustering.. doesn't matter if it is MySQL, MS SQL Server, MS Exchange or a big bad Beowulf Cluster you need an independent switch for the cluster. Here is why, There is so much traffic to and from the nodes, and on the network that it will slow down your network, and the cluster.

Transaction/locking confusion

Hi, I have a simple PHP function that initialises a process definition. To prevent it happening more than once, I'm wrapping it in a transaction, however, it doesn't seem to be working and I get multiple initialisations. In pseudocode: BEGIN; UPDATE process SET status = 'ready' WHERE id =

Re: help me optimize this "ALL"

No, because you have no WHERE condition. wangxu wrote: > sql: > > SELECT * > FROM table_one INNER JOIN table_one table_one1 ON table_one1.column_one = > table_one.column_two >INNER JOIN table_one table_one2 ON table_one2.column_one = > table_one.column_three

Re: migrating 4.0 to 5.0

>> > i've still serious trouble in migrating databases createted with 4.0 to >> 5.0. >> > the problems is still the charset. i'm connecting to mysql with php and >> when >> > i try to use the 5.0 db german special chars are messed up. afaik 4.0 > > uses latin charset and 5.0 utf8 by default. can s

Specific mysql Trigger question

mysql ver 5.0.26 standard Can a trigger call a procedure that returns a result set? I am trying to get around this error msg. ERROR 1415 (0A000): Not allowed to return a result set from a trigger Thanks -winn Below is a more concise description of my issue and logic pattern when a record is

Re: Does casing of Table names matter on Linux

abhishek jain wrote: On 3/5/07, abhishek jain <[EMAIL PROTECTED]> wrote: On 3/1/07, abhishek jain <[EMAIL PROTECTED]> wrote: > > > On 2/28/07, Ow Mun Heng <[EMAIL PROTECTED] > wrote: > > > > On Wed, 2007-02-28 at 15:05 +0530, abhishek jain wrote: > > > Hi Friends, > > > I have been developin

Re: Does casing of Table names matter on Linux

On 3/5/07, abhishek jain <[EMAIL PROTECTED]> wrote: On 3/1/07, abhishek jain <[EMAIL PROTECTED]> wrote: > > > On 2/28/07, Ow Mun Heng <[EMAIL PROTECTED] > wrote: > > > > On Wed, 2007-02-28 at 15:05 +0530, abhishek jain wrote: > > > Hi Friends, > > > I have been developing one application over

Re: migrating 4.0 to 5.0

Am Montag, 5. März 2007 14:35 schrieb Martijn Tonies: > Hi, > > > i've still serious trouble in migrating databases createted with 4.0 to > 5.0. > > the problems is still the charset. i'm connecting to mysql with php and > when > > i try to use the 5.0 db german special chars are messed up. afaik 4

Transaction/locking confusion

Hi, I have a simple PHP function that initialises a process definition. To prevent it happening more than once, I'm wrapping it in a transaction, however, it doesn't seem to be working and I get multiple initialisations. In pseudocode: BEGIN; UPDATE process SET status = 'ready' WHERE id =

Re: migrating 4.0 to 5.0

Hi, > i've still serious trouble in migrating databases createted with 4.0 to 5.0. > the problems is still the charset. i'm connecting to mysql with php and when > i try to use the 5.0 db german special chars are messed up. afaik 4.0 uses > latin charset and 5.0 utf8 by default. can some one pleas

help me optimize this "ALL"

sql: SELECT * FROM table_one INNER JOIN table_one table_one1 ON table_one1.column_one = table_one.column_two INNER JOIN table_one table_one2 ON table_one2.column_one = table_one.column_three explain: *** 1. row **

Re: migrating 4.0 to 5.0

On Mon, Mar 05, 2007 at 08:30:13AM +0100, Matthias Henze wrote: > hi, > > i've still serious trouble in migrating databases createted with 4.0 to 5.0. > the problems is still the charset. i'm connecting to mysql with php and when > i try to use the 5.0 db german special chars are messed up. afai

migrating 4.0 to 5.0

hi, i've still serious trouble in migrating databases createted with 4.0 to 5.0. the problems is still the charset. i'm connecting to mysql with php and when i try to use the 5.0 db german special chars are messed up. afaik 4.0 uses latin charset and 5.0 utf8 by default. can some one please giv