Tuning MySQL Full-text Search

2002-11-27 Thread Nick Kostirya
Hi, All. How can I add additional characters (Ukrainian alphabet) to the source code for parse? Thanks, Nick. database,sql,query,table,handler,compile,ChangeSet - Before posting, please check:

Re: link under Win32 for udf

2002-09-06 Thread Nick Kostirya
) -Original Message- From: Nick Kostirya [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 4:37 PM To: [EMAIL PROTECTED] Subject: link under Win32 for udf Hello. It's anew me. And how linking under Win32 with --with-mysqld-ldflags=-rdynamic? I need UDF. Thanks

Re: build under Win32 - thanks

2002-09-03 Thread Nick Kostirya
Thank you very much for help. Nick. sql,query - 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

link under Win32 for udf

2002-09-03 Thread Nick Kostirya
Hello. It's anew me. And how linking under Win32 with --with-mysqld-ldflags=-rdynamic? I need UDF. Thanks in advance. Nick. mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual)

build under Win32

2002-09-02 Thread Nick Kostirya
Hi, All. I cannot build mysql mysql-3.23.52-win-src.zip (and mysql-3.23.51-win-src.zip, and mysql-max-4.0.1-alpha-win.zip). Error arise when I build string.lib. Configuration: strings - Win32 Debug Performing Custom Build Step on .\Strxmov.asm '

build under Win32

2002-09-02 Thread Nick Kostirya
Hi, All. I cannot build mysql mysql-3.23.52-win-src.zip (and mysql-3.23.51-win-src.zip, and mysql-max-4.0.1-alpha-win.zip). Error arise when I build string.lib. Configuration: strings - Win32 Debug Performing Custom Build Step on .\Strxmov.asm '

How to compile a UDF under win32?

2002-06-18 Thread Nick Kostirya
Hi, All. Please, tell my how to compile a UDF under win32. For example, udf_example.cc cl /GX /TP /nologo /c udf_example.cc link /nologo /dll /out:udf_example.so udf_example.obj It do not export the functions :-( dumpbin /export udf_example.so DUMPBIN : warning LNK4044: unrecognized

Unlock tables when process has killed.

2001-07-05 Thread Nick Kostirya
Hello, All. Help me. One process locks a table. Then it has been killed. The table remains locked. How unlock the table if the process is not exist? Thanks in advance. Nick. - Before posting, please check:

Re: Unlock tables when process has killed.

2001-07-05 Thread Nick Kostirya
Sorry. It's possibly a bug under WinNT (version 3.23.39). For Linux (debian) is OK (version 3.23.39).! Now KILL id_process executed and executed hitherto. - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Nick Kostirya [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent

Re: Unlock tables when process has killed.

2001-07-05 Thread Nick Kostirya
mysql.exe executed. Sorry for my English. Nick. At 12:26 05/07/2001 +0300, Nick Kostirya wrote: Hi! Nick I have interest how you did the lock and how the table remains locked on NT. Below I show you a sequence on Win2k machine and how you see after a kill I was able to insert a new row

Re: Unlock tables when process has killed.

2001-07-05 Thread Nick Kostirya
locally and MyISAM - Original Message - From: Miguel Angel Solórzano [EMAIL PROTECTED] To: Nick Kostirya [EMAIL PROTECTED]; [EMAIL PROTECTED]; Miguel Angel Solórzano [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 3:35 PM Subject: Re: Unlock tables when process has killed. At 14:09 05

Join mysticism

2001-06-26 Thread Nick Kostirya
Hi, All. Help me to understand why such different speed of two queries. These queries do the same and differ only in superfluous information (marked by red). Speed of the first is 0.37 second. Speed of the latter is 3.95 second. The first: SELECT DATE_FORMAT(visits_1.date_time_visit,

sorry, it's a test

2001-06-13 Thread Nick Kostirya
sorry, it's a test database,sql,query,table - 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

UNIQUE multiple-column index

2001-03-02 Thread Nick Kostirya
Hi, All! Please, give me an opinion about multiple-column index. May I create the UNIQUE multiple-column index, which the index of each column is not UNIQUE in? If yes than how do it? Best. Nick. - Before posting, please

Who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT.

2001-01-26 Thread Nick Kostirya
Hi. You would tell me who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT. I need to quicken DB to the maximum and to keep minimum size of the DB. Thanks. Nick. - Before posting, please check: http://www.mysql.com/manual.php

Re: AW: mySQL vs Oracle

2001-01-23 Thread Nick Kostirya
Hi. We plan to make a project that designed for collection and analysis of statistic information. We should use some servers that should place approximately 100 databases on. The databases have identical structure but have designed for various carouses. We do not solve which database is the best