Re: mysql select query

es is very large,such as 800(about 1000 record 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 qu

Re: mysql select query

eed to return all of the > columns in that table or just COL1, COL2, COL5 for example. Only grab > the columns you are actually going to use. > > On Mon, Jul 13, 2009 at 12:23 AM, TianJing > wrote: > > thanks for reply, > > > > i hava an index on the start_position

Re: mysql select query

u min and max values. Do an ALTER > TABLE on any column only hold numeric values and switch them to int > or mediumint. > > On Mon, Jul 13, 2009 at 12:36 AM, TianJing > wrote: > > sorry fo that, but i really need all cols in the table, i think the > problem > > mayb

Re: mysql select query

> > > On Mon, Jul 13, 2009 at 12:04 AM, TianJing wrote: > >> 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 >> >> > Numeri

Re: mysql select query

left-most > column, REF_ID. I'm not sure why 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

Re: mysql select query

faster. > > > > On Mon, Jul 13, 2009 at 9:45 AM, TianJing wrote: > >> 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 5.1.35 Segmentation fault

ome 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 > jing, > Please modify your my.cnf file. > > > > 在 2009-7-16，下午2:56， TianJing 写道： > > > Hi all, >> >>

mysql server optimization

ache = 1024 log-bin=mysql-bin binlog_format=mixed -- Tianjing

Re: mysql server optimization

r of factors which causes MySQL to use on disk temporary > tables instead of in memory tables. (If there a BLOB or TEXT columns in the > table for example). > > As a starting point you could (if you have the memory in your box) try > increasing the values for tmp_table_size and max_hea

Re: mysql server optimization

; Inspired Gaming Group Plc > > Direct Dial +44 (0)1283 519244 > Telephone +44 (0)1283 512777 ext 2244 > Mobile +44 (0)7812 451238 > > Email john.dais...@llg.co.uk > > www.inspiredgaminggroup.com > > > -Original Message- > From: TianJing > Sent: 15 Dec

Re: mysql server optimization

> > John Daisley > > Business Intelligence Developer - MySQL Database Administrator > Inspired Gaming Group Plc > > Direct Dial +44 (0)1283 519244 > Telephone +44 (0)1283 512777 ext 2244 > Mobile +44 (0)7812 451238 > > > -- >