; *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
> *Subject:* Re: mysql server optimization
>
> yes,you are right,the longblob is already
ingtian.seu...@gmail.com] On
Behalf Of TianJing
Sent: 15 December 2009 12:43
To: Daisley, John (Burton)
Cc: mysql@lists.mysql.com
Subject: Re: mysql server optimization
yes,you are right,the longblob is already move to a separate table
fdna,it is about 10Gb/database the fdata is about 30Gb
; 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
244
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 December 2009 10:28
To: mg_s...@hotmail.com
Cc: mysql@lists.mysql.com
Subject: Re: mysql server optimization
i use MyISA
i use MyISAM storage,the MYI file is more than 500Gb. most of the sql is
select with many 'and','or','order by',for example:
SELECT
fref,fstart,fstop,fsource,fmethod,fscore,fstrand,fphase,gclass,gname,ftarget_start,ftarget_stop,fdata.fid,fdata.gid
FROM fdata,ftype,fgroup
WHERE fgroup.gid = fda
What kind of queries are being run and what type of data is stored?
There are a number 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
