Re: mysql server optimization

: +44(0)7812 451238 Email: john.dais...@butterflysystems.co.uk === Sent via HP IPAQ mobile device -Original Message- From: TianJing jingtian.seu...@gmail.com Sent: 15 December 2009 03:08 To: mysql@lists.mysql.com Subject: mysql server optimization Dear all, i am

Re: mysql server optimization

john.dais...@llg.co.uk www.inspiredgaminggroup.com -Original Message- From: TianJing tianj...@genomics.org.cn Sent: 15 December 2009 10:28 To: mg_s...@hotmail.com Cc: mysql@lists.mysql.com Subject: Re: mysql server optimization i use MyISAM storage,the MYI file is more than 500Gb

Re: mysql server optimization

)1283 519244 Telephone +44 (0)1283 512777 ext 2244 Mobile +44 (0)7812 451238 -- *From:* jingtian.seu...@gmail.com [mailto:jingtian.seu...@gmail.com] *On Behalf Of *TianJing *Sent:* 15 December 2009 12:43 *To:* Daisley, John (Burton) *Cc:* mysql@lists.mysql.com

mysql server optimization

=mixed -- Tianjing

MYSQL 5.1.35 Segmentation fault

suggestions? thanks very much! -- Tianjing

Re: MYSQL 5.1.35 Segmentation fault

=mysql [mysqld_safe] log-error=/export/data1/apps/local/mysql/logs/mysqld.log pid-file=/export/data1/apps/local/mysql/logs/mysqld.pid 2009/7/16 fire9 fire9di...@gmail.com jing, Please modify your my.cnf file. 在 2009-7-16，下午2:56， TianJing 写道： Hi all, i am trying to install mysql

Re: mysql select query

, TianJing tianj...@genomics.org.cnwrote: i do not use text for start_postion,i use int for it. the only col which defined to text is characters such as ABTGDSDFSGFDG etc. 2009/7/13 Darryle Steplight dstepli...@gmail.com Numeric indexing is a lot faster. You definitely shouldn't use text

Re: mysql select query

it says 5 and not 4, maybe someone else can explain this. I'd redefine the index to only use the a single column, then define a new index on REF_ID if you use that in JOINs. On Mon, Jul 13, 2009 at 9:07 AM, TianJing tianj...@genomics.org.cn wrote: the REF_SEQ is defined below, the col

Re: mysql select query

, 2009 at 9:45 AM, TianJing tianj...@genomics.org.cnwrote: sorry for my careless,the sql should be select * from REF_SEQ where REF_ID = 3 and START_POSITION between 3 and 803; the explain output is : mysql explain select * from REF_SEQ where REF_ID = 3 and START_POSITION between 3

Re: mysql select query

in it), the query is so slow, when i use mysql administrator i find that traffic is higher when the query is begin, could you please give me some advice on how to optimization the query? thanks, -- Tianjing -- A: It reverses the normal flow of conversation. Q: What's wrong with top

Re: mysql select query

, when i use mysql administrator i find that traffic is higher when the query is begin, could you please give me some advice on how to optimization the query? thanks, -- Tianjing -- A: It reverses the normal flow of conversation. Q: What's wrong with top

Re: mysql select query

i find that traffic is higher when the query is begin, could you please give me some advice on how to optimization the query? thanks, -- Tianjing -- A: It reverses the normal flow of conversation. Q: What's wrong with top-posting