MySQL On ipv6

2009-11-29 Thread pramod tk
loopback address) it doesnt start. Thanks in advance. Regards, Pramod TK

[OT} How to pronounce GIF (was: Re: How to pronounce MyISAM and InnoDB)

2007-01-07 Thread TK
tors of the GIF format (CompuServe, 1987) have always defined the pronunciation to be like "JIF." So, that has always been the "correct" pronunciation. - TK >On Jan 7, 2007, at 7:16 AM, Michael Stearne wrote: >> >>I just say >> >>"My, I, Sam&

Re: Undelete a droped table

2006-11-07 Thread TK
e) tool that will do this automatically, too. - TK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Slow query log: "administrator command: quit" ?

2006-07-31 Thread TK
t would be trying to quit, and why would it be taking 67 seconds? Thanks in advance for any help, TK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Slow query: Getting first initials from an entire table's data

2004-06-12 Thread TK
lready tried that it had no effect at all. MySQL still scans the whole table, still doesn't use any indexes, and takes forever at it. Thanks, TK >In article <[EMAIL PROTECTED]>, >TK <[EMAIL PROTECTED]> writes: > >> I'm still trying to come up with an effi

Slow query: Getting first initials from an entire table's data

2004-06-12 Thread TK
ndex; Distinct | +---+--+---+---+-+-+---+---+ Is there any way to do this, or an efficient way to query the table 26+ times with a list of first initials? (My actual query examines 166,000 rows and takes 12 seconds to run, all to give me a list of most of the alphabet!) Thanks

Getting first initials from an entire table's data (Slow query)

2004-05-30 Thread TK
--+ Is there any way to do this, or an efficient way to query the table 26+ times with a list of first initials? (My actual query examines 166,000 rows and takes 12 seconds to run, all to give me a list of most of the alphabet!) Thanks in advance, TK -- MySQL General Mailing List Fo

startup problems with linux

2004-05-12 Thread TK Banks
The startup script provided with Fedora linux uses the mysqladmin ping command to verify that the server is up after the safe_mysqld command has been issued; however, once I changed the password for the root account, this no longer works: it sits there and tries this command 10 times on one sec

Re: Problem with .NET applications

2004-01-22 Thread tk
Hello Marco, > When I'm trying to do an insert I got the following > error > "Error [07006][MySQL][ODBC 3.51 > Driver][mysqld-4.0.17-nt] Restricted > data type attribute violation Could you please provide the code you use to do the insert. TK __

Re: FULLTEXT Search and Hyphens

2003-12-31 Thread tk
p) > > AGAINST ('"kk-4835"' IN BOOLEAN MODE ) Put things in quotes not question marks. TK __ Do you Yahoo!? Find out what made the Top Yahoo! Searches of 2003 http://search.yahoo.com/top2003 -- MySQL General Mailing List For list archives: h

Re: FULLTEXT Search and Hyphens

2003-12-31 Thread tk
o type in "KK-4835", "KK4835", or > even "KK 4835) To be able to search for the variations you described above I would just parse the search and insert a hyphen where it is missing and then perform the same search above. Hope this helps, TK __

Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS

2003-12-15 Thread tk
he TODO) Once again, thanks for the response. Could you give an estimation (even if rough) of how soon this optimization will be implemented? Thanks, TK > Regards, > Sergei > > -- >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ / Sergei Golubchik > <[

Re: Production problem porting from PHP to ASP

2003-12-10 Thread tk
h php-... regards, tk --- Terence <[EMAIL PROTECTED]> wrote: > We just developed and re-wrote applications on PHP > from a previous ASP > environment. > The performance improvement from ASP-ODBC-MySQL to > PHP-MYSQL ranged > from 20-50% in some cases, so it's prett

Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS

2003-12-05 Thread tk
code certainly must know how many total results there are. Could one not store the total while using the index and use "select FOUND_ROWS()" without SQL_CALC_FOUND_ROWS to retrieve the total? Thanks and regards, TK --- Sergei Golubchik <[EMAIL PROTECTED]> wrote: > Hi! >

Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS

2003-12-04 Thread tk
r without the SQL_CALC_FOUND_ROWS keyword, so why would there be such a huge difference in time. Thanks, TK --- Matt W <[EMAIL PROTECTED]> wrote: > Hi, > > Yes, you would have similar results with any query > that uses > SQL_CALC_FOUND_ROWS. That's because MySQL has to