FULLTEXT feature requests
The only reason that we are unable to use a stock build of mysql is because 1) we use GWS_FREQ as our GWS_IN_USE, not GWS_PROB 2) we have a custom stopword list Is there any reason that these two settings, like FT_MIN_WORD_LENGTH, cannot be moved to runtime-configurable params? Obviously, changing either setting would require a rebuild of the FT index(es), but then, so does FT_MIN_WORD_LENGTH... TIA -- Shane Allen [EMAIL PROTECTED] http://www.emphasys.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FULLTEXT feature requests
Hi Shane, - Original Message - From: Shane Allen Sent: Wednesday, September 10, 2003 7:16 PM Subject: FULLTEXT feature requests The only reason that we are unable to use a stock build of mysql is because 1) we use GWS_FREQ as our GWS_IN_USE, not GWS_PROB Why is that exactly...? To get around the 50% threshold? Like the manual says, by doing this you *severely* decrease MySQL's ability to provide adequate relevance values for the MATCH() function. If you really need to search for such common words, it would be better to search using IN BOOLEAN MODE instead, which does not observe the 50% threshold. 2) we have a custom stopword list This is run-time configurable. :-) Look at the ft_stopword_file variable. Every word in the file is used as a stopword. Word being defined the same as the indexing parser uses. Is there any reason that these two settings, like FT_MIN_WORD_LENGTH, cannot be moved to runtime-configurable params? Obviously, changing either setting would require a rebuild of the FT index(es), but then, so does FT_MIN_WORD_LENGTH... I just wish ft_min_word_len would be 3 by *default*, so we wouldn't have to change it. :-D Matt TIA -- Shane Allen [EMAIL PROTECTED] http://www.emphasys.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Feature Requests
Mike Wexler writes: Quentin Bennett wrote: Shell escape mysql !rm /tmp/data.txt mysql select col into outfile '/tmp/data.txt' from table; mysql select col into local outfile '/tmp/data.txt' from table Would these options prove useful to others? Yes. Especially the local outfile. Regards Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 Hi! Regarding shell commands it is doable. Regarding local outfile, there are some clients that do it already, like mysqlgui. Fixing it to work in general case is also doable, but it is not a small feature. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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
Feature Requests
Hi, I would like to request the addition of the following features to the command line client: Shell escape mysql !rm /tmp/data.txt mysql select col into outfile '/tmp/data.txt' from table; The command is run on the client. It would all SQL scripts to be run more simply that constructing a shell script with the same function. Maybe there would need to be an extra user permission to avoid abuse (like FILE)? Because the command is run on the client, this leads to the second feature request: mysql select col into local outfile '/tmp/data.txt' from table Before submitting to the server, the client checks, with the server, that the user has FILE privileges, and that the user has OS level permission to create the file. The results of the query are then put in to the file in the same format as they would have been in the existing select .. into outfile command - if that is too difficult, because the client then needs all the separator and terminator options, then simply tab separated using the platform's standard end of line would be fine for me! Would these options prove useful to others? Regards Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Feature Requests
Quentin Bennett wrote: Shell escape mysql !rm /tmp/data.txt mysql select col into outfile '/tmp/data.txt' from table; mysql select col into local outfile '/tmp/data.txt' from table Would these options prove useful to others? Yes. Especially the local outfile. Regards Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Feature Requests
I'll add my voice especially on the local file. many times I have wanted to be able to skip creating the file on the server, then having to scp it to my local box. On Tuesday 11 December 2001 02:09 pm, you wrote: Hi, I would like to request the addition of the following features to the command line client: Shell escape mysql !rm /tmp/data.txt mysql select col into outfile '/tmp/data.txt' from table; The command is run on the client. It would all SQL scripts to be run more simply that constructing a shell script with the same function. Maybe there would need to be an extra user permission to avoid abuse (like FILE)? Because the command is run on the client, this leads to the second feature request: mysql select col into local outfile '/tmp/data.txt' from table Before submitting to the server, the client checks, with the server, that the user has FILE privileges, and that the user has OS level permission to create the file. The results of the query are then put in to the file in the same format as they would have been in the existing select .. into outfile command - if that is too difficult, because the client then needs all the separator and terminator options, then simply tab separated using the platform's standard end of line would be fine for me! Would these options prove useful to others? Regards Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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 -- Jayce^ - 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