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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: link under Win32 for udf
Thank you very much for your answer. I am sorry to have misled you by my incomplete question. I asked you about build MySql from src earlier and that message was mistakingly associated with the previous one. I meant building not dll containing UDF, but MYSQL itself. I built it as specified in http://www.mysql.com/doc/en/Windows_source_build.html. However it doesn't find dll with UDF. One should run a script to create Makefile with a flag --with-mysqld-ldflags=-rdynamic for Unix. ... when building MYSQL under Win32, MYSQL should be built with enabled UDF. Nick here instructions how to use udf_example.cc on VC++. Assuming that the user has VC++ 6.0, the Windows MySQL source and running a MySQL server with the same version. - Open the mysqld.dsw workspace. - Add New project to the workspace - Project name: udf_example - Select Win32 Dynamic-Link Library - Click OK - Select An Empty DLL project - Click Finish - Click OK - Right click over the new project and select Add Files to Project - Add \sql\udf_example.cpp - Type Ctrl+N for to create a new file. - Select text type - File name: udf_example.def - Edit the above file with the below contents: LIBRARY UDF_EXAMPLE DESCRIPTION 'Example Using UDF with VC++' VERSION 1.0 EXPORTS metaphon myfunc_double myfunc_int avgcost - Right Click the udf_example project and select Settings - Click the C/C++ tab - Select General in the Category Combo - Add the macro HAVE_DLOPEN to the PreProcessor definition - Select Preprocessor in the Category Combo - Add the include path to the text box: Additional Include directories e.g: ../include - Click Menu Project/Dependencies and add the strings library - Press F7 for to build the DLL. Note: the above instructions should be made for both release/debug version -Configuration: udf_example - Win32 Debug- Linking... Creating library Debug/udf_example.lib and object Debug/udf_example.exp udf_example.dll - 0 error(s), 0 warning(s) - Copy the udf_example.dll to the environment path directory: \winnt\system32 for example. - Start the mysql client and issue: C:\mysql\binmysql mysql CREATE FUNCTION metaphon RETURNS STRING SONAME udf_example.dll; Query OK, 0 rows affected (0.01 sec) mysql CREATE FUNCTION myfunc_double RETURNS REAL SONAME udf_example.dll; 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 affected (0.00 sec) -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 in advance. Nick. mysql - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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.bat' is not recognized as an internal or external command, operable program or batch file. Error executing c:\winnt\system32\cmd.exe. strings.lib - 1 error(s), 0 warning(s) I have Windows NT 6SP and VC6. what does it matter? Best, Nick. - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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.bat' is not recognized as an internal or external command, operable program or batch file. Error executing c:\winnt\system32\cmd.exe. strings.lib - 1 error(s), 0 warning(s) I have Windows NT 6SP and VC6. what does it matter? Best, Nick. Sql, mysql, 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 option export; ignored Dump of file udf_example.so File Type: DLL Summary 1000 .data 1000 .rdata 1000 .reloc 3000 .text Best, 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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] Cc: mysql [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 11:24 AM Subject: Re: Unlock tables when process has killed. On Thu, Jul 05, 2001 at 10:55:33AM +0300, Nick Kostirya wrote: 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? If that's what happened, you've found a bug in MySQL. Can you reliably reproduce it? What version are you using? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 18 days, processed 141,137,801 queries (86/sec. avg) - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unlock tables when process has killed.
Thanks, Miguel. I understand. If after killing a process, program of this process come to the end incorrectly (fail), then the table remains locked. Something like have than mysql.exe after killing process don't touch. Other mysql.exe will wait for this process killed, but it doesn't 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 row to the table. The client was put down without to close the connection ? E:\mysql\binmysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 3.23.39-max-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql lock tables mm1 read; Query OK, 0 rows affected (0.00 sec) mysql insert into mm1 values ('',more one test); ERROR 1099: Table 'mm1' was locked with a READ lock and can't be updated mysql show processlist; +++---+--+-+--+---+- -+ | Id | User | Host | db | Command | Time | State | Info | +++---+--+-+--+---+- -+ | 1 | miguel | localhost | test | Sleep | 0| | NULL | | 7 | ODBC | localhost | test | Query | 0| NULL | show processlist | +++---+--+-+--+---+- -+ 2 rows in set (0.00 sec) mysql kill 7; Query OK, 0 rows affected (0.00 sec) mysql unlock tables; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:8 Current database: test Query OK, 0 rows affected (0.22 sec) mysql insert into mm1 values ('',more one test); Query OK, 1 row affected (0.05 sec) mysql Regards, Miguel 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: Thursday, July 05, 2001 11:24 AM Subject: Re: Unlock tables when process has killed. On Thu, Jul 05, 2001 at 10:55:33AM +0300, Nick Kostirya wrote: 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? If that's what happened, you've found a bug in MySQL. Can you reliably reproduce it? What version are you using? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 18 days, processed 141,137,801 queries (86/sec. avg) - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 process has killed. At 14:09 05/07/2001 +0300, Nick Kostirya wrote: Hi Nick, One more thing: the client application is running locally in the same computer of the MySQL server or remotely connected ?. What type of table you are using: MyISAM, BDB or InnoDB. Regards, Miguel Thanks, Miguel. I understand. If after killing a process, program of this process come to the end incorrectly (fail), then the table remains locked. Something like have than mysql.exe after killing process don't touch. Other mysql.exe will wait for this process killed, but it doesn't 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 row to the table. The client was put down without to close the connection ? E:\mysql\binmysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 3.23.39-max-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql lock tables mm1 read; Query OK, 0 rows affected (0.00 sec) mysql insert into mm1 values ('',more one test); ERROR 1099: Table 'mm1' was locked with a READ lock and can't be updated mysql show processlist; +++---+--+-+--+---+ - -+ | Id | User | Host | db | Command | Time | State | Info | +++---+--+-+--+---+ - -+ | 1 | miguel | localhost | test | Sleep | 0| | NULL | | 7 | ODBC | localhost | test | Query | 0| NULL | show processlist | +++---+--+-+--+---+ - -+ 2 rows in set (0.00 sec) mysql kill 7; Query OK, 0 rows affected (0.00 sec) mysql unlock tables; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:8 Current database: test Query OK, 0 rows affected (0.22 sec) mysql insert into mm1 values ('',more one test); Query OK, 1 row affected (0.05 sec) mysql Regards, Miguel 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: Thursday, July 05, 2001 11:24 AM Subject: Re: Unlock tables when process has killed. On Thu, Jul 05, 2001 at 10:55:33AM +0300, Nick Kostirya wrote: 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? If that's what happened, you've found a bug in MySQL. Can you reliably reproduce it? What version are you using? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 18 days, processed 141,137,801 queries (86/sec. avg) - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http
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') AS dt, Count(DISTINCT visits_1.id_visitor) AS cnt, visits_1.id_visitor, visits_1.id_visit, visits_2.id_visitor, visits_2.id_visit, visits_1.visit_number, visits_2.visit_number FROM visits AS visits_1 INNER JOIN visits AS visits_2 USING(id_visitor) WHERE visits_1.id_visitor=visits_2.id_visitor AND visits_1.date_time_visit BETWEEN '2001-05-01' AND '2001-06-30' AND visits_2.date_time_visit BETWEEN '2001-05-01' AND '2001-06-30' AND visits_1.visit_number=1 AND visits_2.visit_number=2 AND UNIX_TIMESTAMP(visits_2.date_time_visit)-UNIX_TIMESTAMP(visits_1.date_time_visit) = 3600 GROUP BY dt LIMIT 0,50 The latter: SELECT DATE_FORMAT(visits_1.date_time_visit, '%Y-%m-%d') AS dt, Count(DISTINCT visits_1.id_visitor) AS cnt, visits_1.id_visitor, visits_1.id_visit, visits_2.id_visitor, visits_2.id_visit, visits_1.visit_number, visits_2.visit_number FROM visits AS visits_1 INNER JOIN visits AS visits_2 USING(id_visitor) WHERE visits_1.date_time_visit BETWEEN '2001-05-01' AND '2001-06-30' AND visits_2.date_time_visit BETWEEN '2001-05-01' AND '2001-06-30' AND visits_1.visit_number=1 AND visits_2.visit_number=2 AND UNIX_TIMESTAMP(visits_2.date_time_visit)-UNIX_TIMESTAMP(visits_1.date_time_visit) = 3600 GROUP BY dt LIMIT 0,50 Best Regards. Nick.
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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 for it: MySQL, PostgreSQL or Oracle. Help us!!! Sinks in advance. Nick. - Original Message - From: Christian Rabe [EMAIL PROTECTED] To: Eric Anderson [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, January 23, 2001 2:27 AM Subject: Re: AW: mySQL vs Oracle Sorry, but our mailserver is down again (Exchange ;), so I had to read via web and search my list-archiv for your mailadress. We tested the system on a Dual-P3-800Mhz-1GB while developing. Now it's running on a E4500 with 6x400Mhz and 8 Slaves (P3-800). Our site generates currently 1,5-2 Million PI's per day with rather many queries to the db's. At the moment we store only european stockdata but in february (I hope) we will add US-Stocks (about 2 times as much additional inserts). I'm confident that mysql will keep running easily. We will see ;) The main problem is I/O. We had to outsource some tables to extra discarrays to take some load from the machine. Regards - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php