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
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 and inno, d, b From: js [EMAIL PROTECTED] Sorry for this silly question but I've been always had trouble pronouncing

Re: Undelete a droped table

2006-11-07 Thread TK
, and then applying the commands in the log file up to right before the undesired statement. I performed such a recovery once by hand (after accidentally leaving the WHERE off of an UPDATE), and it worked perfectly. There is at least one (free) tool that will do this automatically, too. - TK

Slow query log: administrator command: quit ?

2006-07-31 Thread TK
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]

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

2004-06-12 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

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

2004-06-12 Thread TK
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 efficient way to query my table of names for all first initials. Seems

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 For list archives

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

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 sql-c-numeric Could you please provide the code you use to do the insert. TK __ Do you

Re: FULLTEXT Search and Hyphens

2003-12-31 Thread tk
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 __ Do you Yahoo!? Find out what made the Top Yahoo! Searches of 2003 http://search.yahoo.com/top2003 -- MySQL General Mailing List

Re: FULLTEXT Search and Hyphens

2003-12-31 Thread tk
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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS

2003-12-15 Thread tk
an estimation (even if rough) of how soon this optimization will be implemented? Thanks, TK Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer

Re: Production problem porting from PHP to ASP

2003-12-10 Thread tk
-... 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 pretty normal to expect a much slower response

Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS

2003-12-05 Thread tk
, the 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! On Dec 04, tk wrote: Hello

Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS

2003-12-04 Thread tk
. 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 see how many rows would be found without the LIMIT. So in your case, it can't just abort the query after it finds 10 rows. All