; *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
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
server optimization
Dear all,
i am nowing having a problem with the mysql server optimization, i have 20
database on a server,each database is about 80Gb,the sql seems very
slow,almost > 5s.and the server i/o is so high,when i check the
processlist,the 'copying to tmp table' s
Dear all,
i am nowing having a problem with the mysql server optimization, i have 20
database on a server,each database is about 80Gb,the sql seems very
slow,almost > 5s.and the server i/o is so high,when i check the
processlist,the 'copying to tmp table' state takes a long time.
i
