Tuning MySQL Full-text Search

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: http://www.mysql.com/manu

How to compile a UDF under win32?

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 opt

build under Win32

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 ' tempfile.ba

build under Win32

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 ' tempfile.b

Re: build under Win32 - thanks

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

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) ht

Re: link under Win32 for udf

t; Query OK, 0 rows affected (0.00 sec) > mysql> CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME "udf_example.dll"; > Query OK, 0 rows affected (0.00 sec) > mysql> CREATE AGGREGATE FUNCTION avgcost RETURNS REAL SONAME > "udf_example.dll"; Query OK, 0 rows

Join mysticism

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, '%Y-%m-%d

Unlock tables when process has killed.

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: http://www.mys

Re: Unlock tables when process has killed.

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]>

Re: Unlock tables when process has killed.

kill while 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

Re: Unlock tables when process has killed.

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

UNIQUE multiple-column index

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 chec

concatenate with group by

Hi, All. Do you know how make concatenate of column values (TEXT type) with group by other column? I need do it use only SQL query!!! For clearness, please, take a look on example. I have table: idc1c2 11"apple" 21"plum" 31"vine" 42"apple" 52"pear"

sorry, it's a test

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 PRO

Re: AW: mySQL vs Oracle

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

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

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