i did
SELECT .. FROM table WHERE cateid=1 AND ctimexx ORDER BY ctime DESC LIMIT 10
mysql can use INDEX(cateid,ctime), with NO filesort, this is very
fast, cos LIMIT is used by optimization
but now i have to query:
cateid IN(1,2,3,4,5)
now mysql use filesort, which is bad, cos it get all
i've once noticed it
it has been 8 but i remove it now, problem still exists
From: Dathan Vance Pattishall [EMAIL PROTECTED]
To: 'xuefer tinys' [EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: RE: 1 query lock all others query
Date: Thu, 7 Aug 2003 11:39:34 -0700
Check you mysqld server veriable
you have similar problem as me
i have my search box very slow, which eating so much cpu usage
and if 1+ UPDATE wait for this query, and all other SELECT queries wait the
UPDATE to be finished
are u going to report this bug(high cpu usage) to bugs.mysql.net?
From: Cliff [EMAIL PROTECTED]
when i show processlist
1 of my queries is sending data (SELECT ...)
while others queries (SELECT/UPDATE) is locked
what's up?
_
MSN Messenger: http://messenger.msn.com/cn
--
MySQL General Mailing List
For list archives:
i've noticed that, when a thread sending data
an update is first locked then other select is locked
From: xuefer tinys [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: 1 query lock all others query
Date: Fri, 08 Aug 2003 02:31:14 +0800
i've once noticed it
it has been 8
run at the same time.
From: Dathan Vance Pattishall [EMAIL PROTECTED]
To: 'xuefer tinys' [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: 1 query lock all others query
Date: Thu, 7 Aug 2003 10:59:46 -0700
For MYISAM tables selects cause table locks while INNODB does row level
locking.
Now
often, mysql in web services, there're many situation make a mysql
connection idle
for example: after php open mysql_pconnect(), finished a request, http
start keep-alive
or service other pages/images which do not require mysql connection
however, the connection is still there, counted as
quoted from mysql-4.1/libmysql/libmysql.c
=
static ulong
mysql_sub_escape_string(CHARSET_INFO *charset_info, char *to,
const char *from, ulong length)
{
const char *to_start=to;
const char *end;
#ifdef USE_MB
my_bool use_mb_flag=use_mb(charset_info);
#endif
for (end=from+length;
i'm sure mysql4.x have wrong algorithm to escape/unescape multibyte chars
a multibyte is escaped while server read it, it maybe a pair of single byte
or a pair of single byte escaped while server read it, it appears as
multibyte
both of these two situation make server unescape incorrectly
i've
DuBois [EMAIL PROTECTED]
To: xuefer tinys [EMAIL PROTECTED],
[EMAIL PROTECTED],[EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Japanese Charset
Date: Fri, 20 Sep 2002 08:56:22 -0500
At 9:09 + 9/20/02, xuefer tinys wrote:
i'm sure mysql4.x have wrong algorithm to escape/unescape multibyte
i'm sorry that i've not read through nor understand the whole thread
From: Shashank Tripathi [EMAIL PROTECTED]
To: 'xuefer tinys'
[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: RE: Japanese Charset
Date: Sat, 21 Sep 2002 00:22:04 +0900
re-posting multibyte problem.
does anyone have problem with binary data in MySQL-4.x using GBK charset or
any other multibyte charset?
inserting/updating/replacing
the full description is in mysql mailing list archive, sent by me
will not repost full desc until someone have or care this
such problem
From: Gerald Clark [EMAIL PROTECTED]
To: xuefer tinys [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: MySQL-4.x GBK Problem with Binary Data
Date: Fri, 20 Sep 2002 15:35:20 -0500
Binary data is binary data.
It doesn't mattrer whether it is GBK or and audio file,
or a jpeg.
If you
he may want SELECT table1.* prefix t1,table2.* prefix t2
which not seems to be supported.
instead of select table1.c1 as t1c1,table1.c2 as t1c2,
table2.c1 as t2c2..
From: z [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Aliasing all fields
Date:
when will we be able to set our own word determination?
when will mysql support multibyte fulltext index
_
ÏíÓÃÊÀ½çÉÏ×î´óµÄµç×ÓÓʼþϵͳ¡ª MSN Hotmail¡£http://www.hotmail.com/cn
i'm using mysql 4.x
it is said the query result is cached by mysql for next query
i have a forum, having post table
post: postid, title, content, postdate, clickcount
and clickcount is increased when the post is viewed
and a page to search post
select * from post where title like %word to
i think it's just a length limiter in serversite (mysql server)
string longer than this limit will be cut off
allowing you to be lazy to cut it off in clientsite (mysql client)
and also a way to indicate the string length, don't have to write a txt
file for document
From: toby -
To: [EMAIL
failed to insert BLOB data on multibyte charset
i'm using GBK charset. mysql 4.01
use PHP to insert, did addslashes before insert
however, failed.
i've read the mysql_escape_string() source code. noticed that, mb char is
processed differently, but is it a must ?
yes, php+libmysql is not up to
18 matches
Mail list logo