>>>
>>> For many days, I am struggling with the problem of increasing history
>>> list
>>> length on mysql 5.6.29. Application that this server is running IOT
>>> based.
>>> Also, this server has so many threads running in sleeping mode. SHOW
&
>
>> Hi to all,
>>
>> For many days, I am struggling with the problem of increasing history
>> list
>> length on mysql 5.6.29. Application that this server is running IOT based.
>> Also, this server has so many threads running in sleeping mode. SHOW
>> ENG
On 4/2/2016 10:36 AM, geetanjali mehra wrote:
Hi to all,
For many days, I am struggling with the problem of increasing history list
length on mysql 5.6.29. Application that this server is running IOT based.
Also, this server has so many threads running in sleeping mode. SHOW ENGINE
INNODB
, I am struggling with the problem of increasing history list
length on mysql 5.6.29. Application that this server is running IOT based.
Also, this server has so many threads running in sleeping mode. SHOW ENGINE
INNODB STATUS shows all these threads in *cleaning up* mode.
I tried all the options to
Hi to all,
For many days, I am struggling with the problem of increasing history list
length on mysql 5.6.29. Application that this server is running IOT based.
Also, this server has so many threads running in sleeping mode. SHOW ENGINE
INNODB STATUS shows all these threads in *cleaning up* mode
Hello friends
I'm back to MySQL programming using the C API... it works fine when I
compile using the RELEASE mode and C:\Program Files (x86)\MySQL\MySQL
Server 5.5\lib but if I choose the DEBUG mode and C:\Program Files
(x86)\MySQL\MySQL Server 5.5\lib\debug it fails at link time
symbol __CrtDumpMemoryLeaks referenced in function _my_end
1mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external
symbol __CrtCheckMemory referenced in function _my_end
Do I have to include an aditional library so the symbols are resolved
correctly? The release mode works perfect
*.dll
Saludos Cordiales (desde EEUU)
Martin
__
Porfavor no altere esta communicacion..Gracias
Date: Tue, 19 Jun 2012 10:24:48 -0400
Subject: Re: Unresolved symbols with mysqlclient in DEBUG mode using VC++
2010 Express
From: chamael...@gmail.com
On Tue, Jun 19, 2012 at 10:47 AM, Martin Gainty mgai...@hotmail.com wrote:
Miguel..
i do not have VC2010 but as my memory recalls the
C runtime library (MSVCRT*.dll) would be the first library on %PATH% .. and
all missing functions *should* be located inside the dll (e.g.
__CrtSetReportFile
Hello Lars
After hours of testing different project configurations, finally I was
able to compile with debug mode... still pending the test of
debugging, but just created the DLL (it was a library that I'm
developing) without errors...
The configurations I used (VC++ 2010 Express) were:
RELEASE
? If compiling in
debug mode it works with both ...\mysql\lib and
...\mysql\lib\debug in DEBUG mode... maybe running the debugger will
not work with the lib, still have to test, but at least it compiles
with no errors... can you comment something about this?
In general, you'd want to ensure every object
Hi All,
InnoDB repeatedly prints this message in the error log:
# InnoDB: Error: unlock row could not find a 4 mode lock on the record
Im not sure if the error message is critical or not, but its definitely not
nice to have in the error log.
After some exploration, I found this error
I couldn't find much information on innodb_autoinc_lock_mode and
implications on mixed mode replication. Does the same caution for
innodb_autoinc_lock_mode=2 and statement-based replication apply to
mixed mode replication?
Kyong
--
MySQL General Mailing List
For list archives: http
this is solved and this post helped me:
http://www.buildcms.com/cms_knowledgebase/how_to_recover_mysql_data_from_innodb
On Fri, Jul 23, 2010 at 8:39 PM, Norman Khine nor...@khine.net wrote:
Hello,
I have a server which has been booted in rescue mode, i have copied
the /mnt/var/lib/mysql/blog
Hello,
I have a server which has been booted in rescue mode, i have copied
the /mnt/var/lib/mysql/blog folder to another server running MySQL and
copied this folder to /var/lib/mysql
when i connect to the mysql cli, i get this:
http://pastie.org/1057117
but my source server is 64bit where
(“interleaved” lock mode) is *not safe* when using statement-based
replication or recovery scenarios when SQL statements are replayed from the
binary log, but If you are using row-based replication, all of the
auto-increment lock modes are safe.
Quite clear, but I had to switch an (unrelated
is as follows :
SELECT Name MATCH (Name) AGAINST ('51*') as Relevance
FROM Products
WHERE MATCH (Name) AGAINST ('51*' IN BOOLEAN MODE)
ORDER BY Relevance DESC
Any ideas what the problem might be ?
Thanks,
Neil
it returns the 51 Blue Widget result. My
query is as follows :
SELECT Name MATCH (Name) AGAINST ('51*') as Relevance
FROM Products
WHERE MATCH (Name) AGAINST ('51*' IN BOOLEAN MODE)
ORDER BY Relevance DESC
Any ideas what the problem might be ?
51 is too short to be included in the index by default
is as follows :
SELECT Name MATCH (Name) AGAINST ('51*') as Relevance
FROM Products
WHERE MATCH (Name) AGAINST ('51*' IN BOOLEAN MODE)
ORDER BY Relevance DESC
Any ideas what the problem might be ?
51 is too short to be included in the index by default, so will never
match. Blue, on the other hand
of the string
name like 51 Blue Widget in the table it doesn't return any results.
However if I search like bl it returns the 51 Blue Widget result. My
query is as follows :
SELECT Name MATCH (Name) AGAINST ('51*') as Relevance
FROM Products
WHERE MATCH (Name) AGAINST ('51*' IN BOOLEAN MODE
Devart
Email: i...@devart.com
Web: http://www.devart.com
FOR IMMEDIATE RELEASE
CONTACT INFORMATION:
Julia Samarska
jul...@devart.com
26-Feb-10
Schema and Data Comparison and Synchronization Tools for MySQL Offer Command
Line Mode and Comparison Reports
MySQL database
How do I start MySQL in maintenance/single user mode so I can create
indexes on a table that is being updated often?
I prefer for the update transactions to fail immediately with a
connection error rather than to wait for a lock to be released.
In Oracle you can startup nomount. What
Subject: Starting MySQL in Maintenance mode
How do I start MySQL in maintenance/single user mode so I can create
indexes on a table that is being updated often?
I prefer for the update transactions to fail immediately with a
connection error rather than to wait for a lock to be released
...@logicworks.net]
Sent: Wednesday, May 20, 2009 4:13 PM
To: TETTERTON George; mysql@lists.mysql.com
Subject: RE: Starting MySQL in Maintenance mode
Do 'service mysql restart --skip-networking'
This prevents all TCP/IP connections
You can login as r...@localhost and the client program will use the
socket file
... |
++---+-+
But the expansion mode is explained as follows.
mysql *SELECT * FROM articles*
- *WHERE MATCH (title,body)*
- *AGAINST ('database' IN NATURAL LANGUAGE MODE);*
++---+--+
| id | title
('+fernandez' IN BOOLEAN MODE) ORDER BY firstname, lastname
If mytable is in latin1, it works fine. But if mytable is in utf8
(it's the case) it doesn't work. How can I change my SQL query to
match 'Fernández' in UTF8 within the table?
Thank you very much.
--
MySQL General Mailing List
a
string containing acute vowels.
mytable:
- item1:
--- firstname: Antonio
--- lastname: Fernández
--- comments: he's from Spain
My SQL query:
--
SELECT id FROM mytable WHERE MATCH(firstname, lastname, comments)
AGAINST ('+fernandez' IN BOOLEAN MODE) ORDER BY firstname, lastname
--- lastname: Fernández
--- comments: he's from Spain
My SQL query:
--
SELECT id FROM mytable WHERE MATCH(firstname, lastname, comments)
AGAINST ('+fernandez' IN BOOLEAN MODE) ORDER BY firstname, lastname
If mytable is in latin1, it works fine. But if mytable is in utf8
(it's
)
AGAINST ('+fernandez' IN BOOLEAN MODE) ORDER BY firstname, lastname
If mytable is in latin1, it works fine. But if mytable is in utf8
(it's the case) it doesn't work. How can I change my SQL query to
match 'Fernández' in UTF8 within the table?
If the data in the UTF-8 table consists
SQL query:
--
SELECT id FROM mytable WHERE MATCH(firstname, lastname, comments)
AGAINST ('+fernandez' IN BOOLEAN MODE) ORDER BY firstname, lastname
If mytable is in latin1, it works fine. But if mytable is in utf8
(it's the case) it doesn't work. How can I change my SQL
Clyde Lewis - DBA a écrit :
The idea here is to perform this change without restarting the server.
Is that possible? I know that by updating the config file, then
restarting will allow the database to be in read-only mode, but need to
know if it is possible without restarting.
Thanks,
CL
Before posting this as a bug report, I seek help on the list, also in
order to produce a more complete test case in the event this is
effectively a bug.
My configuration:
- a master server running in NO_BACKSLASH_ESCAPES sql mode
- a slave server also running in NO_BACKSLASH_ESCAPES sql mode
Is this possible with MYSQL using the innodb engine? If so, what is
the command/process to make this happen.
Thanks in advance,
~
Clyde Lewis
Database Administrator
-Original Message-
From: Clyde Lewis - DBA [mailto:[EMAIL PROTECTED]
Sent: 03 August 2007 16:55
To: MySQL List
Subject: Re: MySQL in read-only mode
The idea here is to perform this change without restarting the
server. Is that possible? I know that by updating the config file
The idea here is to perform this change without restarting the
server. Is that possible? I know that by updating the config file,
then restarting will allow the database to be in read-only mode, but
need to know if it is possible without restarting.
Thanks,
CL
At 11:46 AM 8/3/2007, Clyde
List
Subject: Re: MySQL in read-only mode
The idea here is to perform this change without restarting the
server. Is that possible? I know that by updating the config file,
then restarting will allow the database to be in read-only mode, but
need to know if it is possible without restarting
Hi,
What does exactly happens when the AUTOINC lock is
happening ?
Why is it not a problem on our amd (quadcore) machine
with the data sitting on a raid10 partition, we have
never seen this problem before, its apparently
happening so fast that it doesn't matter.
With the intel machine
lock
mysql tables in use 1, locked 1
LOCK WAIT 1 lock struct(s), heap size 368
MySQL thread id 634392, query id 3774951
NSERT INTO t2 VALUES ('')
--- TRX HAS BEEN WAITING 3 SEC FOR THIS LOCK TO BE
GRANTED:
TABLE LOCK table `t2` trx id 0 3667440 lock mode
AUTO-INC waiting
On Tue, May 1, 2007 22:15, Brown, Charles wrote:
Because I am running on batch mode therefore I'm trying to direct my
session output to a file -- meaning stdout. But I'm having a problem.
For instance this input: use test_db gave me no output but this input
show tables gave me an output
On Wed, May 2, 2007 08:55, Mogens Melander wrote:
On Tue, May 1, 2007 22:15, Brown, Charles wrote:
Because I am running on batch mode therefore I'm trying to direct my
session output to a file -- meaning stdout. But I'm having a problem.
For instance this input: use test_db gave me
Because I am running on batch mode therefore I'm trying to direct my
session output to a file -- meaning stdout. But I'm having a problem.
For instance this input: use test_db gave me no output but this input
show tables gave me an output.
What is missing, what's the trick. Help me Y'all.
Thx
do two fulltext searches on this column like this:
SELECT * FROM _my_table_here WHERE MATCH(Keywords) AGAINST ('*Key*
*West*' IN BOOLEAN MODE)0;
SELECT * FROM _my_table_here WHERE MATCH(Keywords) AGAINST ('*Miami*
*Beach*' IN BOOLEAN MODE)0;
The second query returns the correct rows in spite
.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Andreas Iwanowski [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 01, 2007 12:49 PM
To: mysql@lists.mysql.com
Subject: Fulltext search dilemma (IN BOOLEAN MODE)
Hello MySQL experts,
I'm trying to do
Hi, thank you for your reply.
I have used the option ft_min_word_len=3.
If I have something like
1. Key West
in the database and I do a
SELECT * FROM my_table WHERE MATCH(Keywords) AGAINST ('Key' IN BOOLEAN
MODE)0;
then I don't get any results either.
If I leave the quotation marks away, I
PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: RE: Fulltext search dilemma (IN BOOLEAN MODE)
Hi, thank you for your reply.
I have used the option ft_min_word_len=3.
If I have something like
1. Key West
in the database and I do a
SELECT * FROM my_table WHERE MATCH(Keywords
, the server was always shut
down properly.
-Andy
-Original Message-
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 01, 2007 4:10 PM
To: Andreas Iwanowski
Cc: mysql@lists.mysql.com
Subject: RE: Fulltext search dilemma (IN BOOLEAN MODE)
Sorry, I have no idea what
before I changed to persistent mode.
Any settings in the config file for the sql-server I need to be aware of?
I'm using MyISAM tables .
mysql select version();
++
| version() |
++
| 4.1.8-standard |
++
--
Jørn Dahl-Stamnes
homepage: http
was
constant to below 10 before I changed to persistent mode.
Any settings in the config file for the sql-server I need to be aware of?
I'm using MyISAM tables .
I would have to say, this is suboptimal, and perhaps a little OT, but here
goes. If you have 50 images, you are going to make 50 selects
running. I had 50-60 mysqld running on the system. This
number was constant to below 10 before I changed to persistent mode.
Any settings in the config file for the sql-server I need to be aware of?
I'm using MyISAM tables .
I would have to say, this is suboptimal, and perhaps a little OT
What you should do, is grab the 50 images ahead of time, in one select, and
use some php to iterate them and display them.
Second, your suggestion is not an option in my case, since the image and the
thumbnails are not stored in the database. The database contain image id,
image attributes
On Thursday 21 December 2006 11:28, Scott Haneda wrote:
What you should do, is grab the 50 images ahead of time, in one select,
and use some php to iterate them and display them.
Second, your suggestion is not an option in my case, since the image and
the thumbnails are not stored in the
Is it possible for mysql to return the mathmatical mode of a record set?
(the record that occurs most often)
[snip] Is it possible for mysql to return the mathmatical mode of a
record set?
(the record that occurs most often)
[/snip]
yes
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Greetz. We have a database that is highly used, around 500 queries/s,
and doing administrative tasks can stuff up the database. Is there a
way to temporarily prevent client connections from within MySQL? Like
unix u can drop the runlevel to do administration, is there something
similar in
to live
Regards,
Mikhail Berman
-Original Message-
From: Wagner, Chris (GEAE, CBTS) [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 14, 2006 4:08 PM
To: mysql@lists.mysql.com
Subject: taking MySQL down into admin mode
Greetz. We have a database that is highly used, around 500 queries
Thanks for that but I was hoping there was a way to do it live that
didn't require restarting/reloading. Something to do at the mysql
prompt. We had to repair a table and all the backed up connections were
threatening to take down the daemon.
Mikhail Berman wrote:
Hi Chris,
In my.cnf in
Jieqi Wang wrote:
I am using WinXP, GNU Emacs 23, MySQL 5.
When I start a mysql process with `sql-mysql' in emacs, no output is
displayed in the buffer until I quit or kill the process.
After I add the following line into the initialization file of emacs,
(setq sql-mysql-options '(-C -t
Hi obed
I looked many times in the commands list and maybe I didn't wat to see it
!!!
The answer is a '\G' appended at the end of the line.
Thanks for the help
Bill
Can you remind me how to tell mysql to list vertically instead of horiz
in
text mode?
List of all MySQL commands
On 8/6/06, Bill [EMAIL PROTECTED] wrote:
Hi
Can you remind me how to tell mysql to list vertically instead of horiz in
text mode?
Ex:
select all * from a_tablesends field1 field2 .
I want
field1
field2
field...
Thanks
if you type help you can find a lot o information
mysql
Hi
Can you remind me how to tell mysql to list vertically instead of horiz in
text mode?
Ex:
select all * from a_tablesends field1 field2 .
I want
field1
field2
field...
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
All,
Does MySQL have an option where the database can startup in READ-ONLY
mode? The idea is to have the server running with users connected,
but now allowing any updates to me applied to the database. I've
looked through the documentation, but was not able to find such a
feature
Why you don´t create a user with just select right and use him?
Clyde Lewis [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
All,
Does MySQL have an option where the database can startup in READ-ONLY
mode? The idea is to have the server running with users connected, but
now
Only allow your users select rights.
--ja
On Wed, 28 Jun 2006, Clyde Lewis wrote:
All,
Does MySQL have an option where the database can startup in READ-ONLY
mode? The idea is to have the server running with users connected,
but now allowing any updates to me applied to the database
The idea is to prevent all users from applying
changes to the system. Not just a single
user. I'm trying to find something similar to
Oracle's Read-only mode option during startup.
Thanks,
CL
At 02:38 PM 6/28/2006, João Cândido de Souza Neto wrote:
Why you don´t create a user with just
. I'm trying to find something similar to
Oracle's Read-only mode option during startup.
Thanks,
CL
At 02:38 PM 6/28/2006, João Cândido de Souza Neto wrote:
Why you don´t create a user with just select right and use him?
Clyde Lewis [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED
mode AUTO-INC waiting
--
---TRANSACTION 0 452718648, ACTIVE 51 sec, process no 26304, OS thread
id 2978935232 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 1 lock struct(s), heap size 320
MySQL thread id 39364, query id 23474096 10.1.30.70 root update
INSERT
An error is only thown during an INSERT or UPDATE statement, otherwise
you just get a warning.
- ERROR_FOR_DIVISION_BY_ZERO
Produce an error in strict mode (otherwise a warning) when we encounter
a division by zero (or MOD(X,0)) during an INSERT or UPDATE. If this
mode is not given, MySQL
thanks
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Thursday, December 29, 2005 10:38 PM
Subject: (ÈðÐÇÌáʾ-´ËÓʼþ¿ÉÄÜÊÇÀ¬»øÓʼþ)RE: set sql mode
An error is only thown during an INSERT or UPDATE statement, otherwise
you just get
AS 1.7.3. Running MySQL in ANSI Mode explain:
--
Running the server in ANSI mode is the same as starting it with these options
(specify the --sql_mode value on a single line):
--transaction-isolation=SERIALIZABLE
--sql-mode
At 11:50 +0800 12/30/05, wangxu wrote:
AS 1.7.3. Running MySQL in ANSI Mode explain:
--
Running the server in ANSI mode is the same as starting it with
these options (specify the --sql_mode value on a single line
It showing REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI when i
set sql mode is ansi.
But now i wish sql mode only include REAL_AS_FLOAT,PIPES_AS_CONCAT.
Can I achieve it?
Hello.
But now i wish sql mode only include REAL_AS_FLOAT,PIPES_AS_CONCAT.
Do you want this:
mysql set @@sql_mode='REAL_AS_FLOAT,PIPES_AS_CONCAT';
Query OK, 0 rows affected (0.00 sec)
mysql select @@sql_mode;
+---+
| @@sql_mode
9:26 PM
Re: set sql mode
Hello.
But now i wish sql mode only include REAL_AS_FLOAT,PIPES_AS_CONCAT.
Do you want this:
mysql set @@sql_mode='REAL_AS_FLOAT,PIPES_AS_CONCAT';
Query OK, 0 rows affected (0.00 sec)
mysql select @@sql_mode;
+---+
| @@sql_mode
Hi,
I have a table with consumer products. I have a row product name
and brand.
If I do a full-text search in boolean mode for a term like apple
ipod I get results like:
Apple iPod (brand: Apple)
TuneDock for Apple iPod (brand: Belkin)
Since both of these terms match
Hi,
I have a table with consumer products. I have a row product name and
brand.
If I do a full-text search in boolean mode for a term like apple ipod I get
results like:
Apple iPod (brand: Apple)
TuneDock for Apple iPod (brand: Belkin)
Since both of these terms match
with
perl-cgi side (which I originally thought is the reason)
after any click, the query goes to a 90 sec - 110 sec of sleep mode and
then gets executed and I dont even see the execution of it even when I
issue this command:
mysqladmin -i1 processlist
I dont know why this going to sleep mode
to give some
extra relevance to those hits where the 'distance' between words is small.
Best regards,
Thomas Spahni
On Tue, 1 Mar 2005, Sergei Golubchik wrote:
Hi!
On Feb 26, leegold wrote:
Is there any way to make relevance when using boolean mode more useful?
If not, are there plans
Hello there,
Another Fulltext question :) Yeah, I've been working a lot on this stuff now :)
I have a request to search companies in a huge database:
SELECT CID FROM tblCompany WHERE MATCH (CompanyName) AGAINST ('Toyota
Robert' IN BOOLEAN MODE)
In boolean mode, my results are not sorted
Hi!
On Mar 02, Thomas Spahni wrote:
Hi Sergei,
I have used FT search on a collection of ~ 38'000 documents totalling 550
MB of data since 4.0.2. To my observation people have a strong tendence to
search for a few words they expect to be found close together in the text.
As far as this is
Hi!
On Feb 26, leegold wrote:
Is there any way to make relevance when using boolean mode more useful?
If not, are there plans in the future Fulltext development todo for
making it useful?
Current relevance formula is described in internals.texi (see mysqldoc
repository on mysql.bkbits.net
Is there any way to make relevance when using boolean mode more useful?
If not, are there plans in the future Fulltext development todo for
making it useful?
I'm thinking of just counting the keyword occurences in records with a
PHP script somehow and using that to order the records. Or doing
SELECT id, titel, MATCH (titel) AGAINST ('moz*' IN BOOLEAN MODE) AS
score FROM cmp_composities WHERE MATCH (titel) AGAINST ('moz*' IN
BOOLEAN MODE)
+--
+---
+---+
| id | titel
| score
hi,
a boolean mode full text search doesn't sort automaticly as stated in
the docs, but it also isn't possible to select the match value (the
score) any more. (is is always 1)
consider this query;
SELECT id, titel, MATCH (titel) AGAINST ('mozart') AS score FROM
cmp_composities WHERE MATCH
Hi All!
Does works fulltext index on utf8 columns on boolean mode
correctly on
MySql 4.1.2 ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I try to run MySQL with ansi mode but failed. This was
what I did:
mysql SET GLOBAL sql_mode='ansi';
ERROR 1064: You have an error in your SQL syntax near
'sql_mode='ansi'' at line 1
Why I can't manage to change to ansi mode?
Thanks: meileng
yau meileng [EMAIL PROTECTED] wrote:
I try to run MySQL with ansi mode but failed. This was
what I did:
mysql SET GLOBAL sql_mode='ansi';
ERROR 1064: You have an error in your SQL syntax near
'sql_mode='ansi'' at line 1
What version do you use? The above syntax is supported since 4.1.1
you try to start mysql client with --ansi option, not the server.
Run mysqld with the above option or put to the my.cnf file:
[mysqld]
ansi
ym --- Victoria Reznichenko
ym [EMAIL PROTECTED] wrote:
yau meileng [EMAIL PROTECTED] wrote:
I try to run MySQL with ansi mode but failed. This
was
what I
DEFAULT CHARSET=utf8
insert into TEST (ID,saturs) values (1, _cp1257 'pa-r par par')
insert into TEST (ID,saturs) values (2, _cp1257 'par par par')
select * from TEST:
ID saturs
1 pÄ?r par par
2 par par par
select * from TEST where match(saturs) against('par' in boolean mode) :
no rows
think you for your help,
all things work well know but the problem is when i want to use snort in
mode NIDS i must change the directory of mysql.sock in my.cnf file from
/tmp/mysql.sock to /var/lib/mysql/mysql.sock as knowing as the mysql.sock
directory file is /tmp/mysql.sock so i did a link
much memory
size for variables holding size of data types in *mysql_bind_param()*, I have reset it
with the
actual size needed for the particular data type.
I have set the server in debug mode simultaneously debug the C coding. Here I can get
the server
activity in the log file *mysqld.trace*
I
Sergei, but this is a phrase search. The original query is:
match (keywords) against ('16-bit Touch' IN BOOLEAN MODE)
So shouldn't all words that are actually searched on be present
in a particular order?
Bill
Sergei Golubchik wrote:
Hi!
On Feb 27, Haitao Jiang wrote:
Thanks
Hi!
On Mar 01, William Au wrote:
Sergei, but this is a phrase search. The original query is:
match (keywords) against ('16-bit Touch' IN BOOLEAN MODE)
So shouldn't all words that are actually searched on be present
in a particular order?
Ok, sorry.
If the original query is '16-bit Touch
~ are supposed to adjust the weight of a word to the
relevancy score, but they only work in BOOLEAN MODE
and BOOLEAN MODE doesn't care about relevancy!
In my opinion, they should be only allowed in the
regular fulltext search in which we DO compute the
relevancy.
Am I missing something?
Thanks
Could anyone explain why
match (keywords) against ('16-bit Touch' IN BOOLEAN
MODE)
returns results, but not
match (keywords) against ('16-bit' IN BOOLEAN MODE)?
Is it a known bug?
Thanks a lot!
Haitao
__
Do you Yahoo!?
Get better spam protection
.
Michael
Haitao Jiang wrote:
Could anyone explain why
match (keywords) against ('16-bit Touch' IN BOOLEAN
MODE)
returns results, but not
match (keywords) against ('16-bit' IN BOOLEAN MODE)?
Is it a known bug?
Thanks a lot!
Haitao
--
MySQL General Mailing List
For list archives: http
Jiang wrote:
Could anyone explain why
match (keywords) against ('16-bit Touch' IN
BOOLEAN
MODE)
returns results, but not
match (keywords) against ('16-bit' IN BOOLEAN
MODE)?
Is it a known bug?
Thanks a lot!
Haitao
--
MySQL General Mailing List
Hi!
On Feb 27, Haitao Jiang wrote:
Thanks! That was what I guessed. But how to explain
16-bit Touch doesn't match records with 32-bit
Touch in the keywords? It just returned all the
records with 16-bit Touch, i.e. 16-bit seems does
count.
Because the presense of 16-bit substring is
Please help me understand this:
~ are supposed to adjust the weight of a word to the
relevancy score, but they only work in BOOLEAN MODE
and BOOLEAN MODE doesn't care about relevancy!
I am really confused. Could anyone kindly explain how
they supposed to work to me?
Thanks so much!
Haitao
Joe Rhett wrote:
mysql select Notice_ID from Notices where match (Text) against
('+pollution +control' in boolean mode);
Empty set (0.00 sec)
mysql select Notice_ID from Notices where match (Text) against
('pollution control' in boolean mode);
Empty set (0.02 sec)
mysql select Notice_ID from
mysql select Notice_ID from Notices where match (Text) against
('+pollution +control' in boolean mode);
Empty set (0.00 sec)
mysql select Notice_ID from Notices where match (Text) against
('pollution control' in boolean mode);
Empty set (0.02 sec)
mysql select Notice_ID from Notices
1 - 100 of 208 matches
Mail list logo