One Column in fulltext or more
hi all I want to know if adding 14 fulltext indexes on 14 columns would be faster , or adding all the words in the 14 fields to one big text column and then fulltext index it is better ? i dont know how mysql keeps the fulltext indexes, but if each index is kept on a file then 1 big column is better ,as only one file is opened . On the other side , if MySQL considers covered queries ,then 14 full text indexes are gona be better . Thats my opinion , but i wanna hear yours . _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Select your own custom email address for FREE! Get [EMAIL PROTECTED] w/No Ads, 6MB, POP & more! http://www.everyone.net/selectmail?campaign=tag - 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: Profiler for windows
there is a Profiler similar to SQL server Profiler ,only for windows i wrote it myself , availiable at http://amr.activechannel.net/myprofiler.htm so sorry its not free :( Amr Salah --- "Iago Sineiro" <[EMAIL PROTECTED]> wrote: >Hi Alexander. > >If you specify option log in section mysqld of my.cnf configuration file you >get a log file of all queries >and sql operations (inserts, updates, deletes) executed in the MySQL server. > >This log file is created by default at $DATADIR/$HOSTNAME.log. > >Iago. > >> -Mensaje original- >> De: Alexander Burbello [mailto:burbello@;yahoo.com.br] >> Enviado el: jueves, 07 de noviembre de 2002 21:30 >> Para: [EMAIL PROTECTED] >> Asunto: Profiler >> >> >> I would like to know if the MySQL has any command where I get the queries >> requested by the application. >> >> SQL Server has Profiler. >> Oracle has any command that I don´t know >> >> With Delphi I run SQLMonitor. >> >> Regards >> >> >> Alexander >> >> >> >> sql,query >> >> ___ >> >> Yahoo! Encontros >> >> O lugar certo para encontrar a sua alma gêmea. >> >> http://br.encontros.yahoo.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 >> > > > >- >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 _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Select your own custom email address for FREE! Get [EMAIL PROTECTED] w/No Ads, 6MB, POP & more! http://www.everyone.net/selectmail?campaign=tag - 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: MYSQL newbie :-)
the manual is a very good place to start , its very organized , and its complete reference , better than any book . trial and error is good , but try to get a graphical user interface beter than the shell . there are many . --- [EMAIL PROTECTED] wrote: >This has probably been asked a thousand times before but only once from me. >I am able to programme in MS Access to quite a high level to which I have now >realised its limitations, where is the best place to start learning and reading up on >MYSQL, I am not really a book reader as I prefer to do things by trial and error but >have not got a clue as to how mysql works > >Regards > >Liam > >- >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 _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Select your own custom email address for FREE! Get [EMAIL PROTECTED] w/No Ads, 6MB, POP & more! http://www.everyone.net/selectmail?campaign=tag - 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
ANN : MyProfiler for windows
I would like to announce the realease of MyProfiler , a tool to monitor you mysql and log all the events occuring on your server .includes Index tuning wizard for your mysql index optimization . We hope you find it useful . http://amr.activechannel.net/MyProfiler.htm _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Select your own custom email address for FREE! Get [EMAIL PROTECTED] w/No Ads, 6MB, POP & more! http://www.everyone.net/selectmail?campaign=tag - 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
new windows Tool
Hello MYsql lovers; I wanna announce a new tool for windows users . Same interface as SQL server 2000 query analyzer but loaded with Visual Studio capabilities . SQL server users will love it . http://amr.activechannel.net http://amr.activechannel.net/setup.zip _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Run a small business? Then you need professional email like [EMAIL PROTECTED] from Everyone.net http://www.everyone.net?tag - 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: Remote connection
Dear all check this new tool at http://amr.activechannel.net http://amr.activechannel.net/setup.zip SQL server users will love it , same query analyzer but more powerful Amr Salah _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Run a small business? Then you need professional email like [EMAIL PROTECTED] from Everyone.net http://www.everyone.net?tag - 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