Re: SATA vs SCSI

2005-05-13 Thread Daniel Whitener
I've had this debate with myself a hundred times over the past 5 years since SATA started becoming more popular. I've come to a few simple conclusions... I've also been dissapointed with the performance of some of the SATA raid controllers (*cough* 3ware *cough*). I've got old dual p3 servers wi

Re: error 2013 : Lost connection to MySQL server during query

2004-06-07 Thread Daniel Whitener
queries on the same connection. Anybody writing server-side applications using the C api, please beware of this issue. I can suggest a few workarounds if anybody else out there is having the same problem with their C program. Daniel Daniel Whitener wrote: Hello all, I'm getting the erro

error 2013 : Lost connection to MySQL server during query

2004-06-03 Thread Daniel Whitener
affic to the MySQL database. The source is available if anybody thinks my poor coding is the problem. Any help or ideas will be greatly appreciated. Thanks in advance! Daniel Whitener basic config info is below. I can provide more details if needed... I'm using suse 9.1 uranus:~ # uname -a

Re: fulltext indexing of alphanumeric strings?

2003-06-27 Thread Daniel Whitener
l Keith C. Ivey wrote: On 27 Jun 2003 at 16:30, Daniel Whitener wrote: an example of this string is V00021 - they all start with v000 [snip] mysql> select ID from emails where body like '%v000%'; [snip] mysql> SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAIN

fulltext indexing of alphanumeric strings?

2003-06-27 Thread Daniel Whitener
Hello MySQL folks, I'm searching through my database (version 4.0.13) looking for certain strings that start with - v000 - but the fulltext index doesn't seem to be indexing that string of letters/numbers. If I do a normal WHERE LIKE, it shows me what I need, but when I try and use the fulltext i