; *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
If you have the slow query log enabled, grab some
slow queries from there and run EXPLAIN.
From there, you can figure out how the optimizer is executing the query.
I found that approach to be very useful in
optimizing individual queries and making indexing decisions.
I can't quite make out w
Dimitar,
Just looking over the server status, it looks
like you have a high rate of temp table to disk.
Created_tmp_disk_tables 5454
Created_tmp_files 1010
Created_tmp_tables 3
I would try increasing the max_heap_table_size.
Increasing the tmp_table_size alone wouldn't be enoug
Hi
I am using Mysql 4.1 on
CPU 2 Xeon 3.0 Ghz + 2 Virtual (Hyperthreads) (I think it is not using the 2nd
processor)
Memory 4GB
I think that the read from the HDD is 50mb per 1 sec, but I am not sure.
I have very big problem with performance, because there are very bad search
queries, but ev
Can you send us a copy of your my.cnf at the moment.
Also, if you can provide some reports that will help us determine the best
functionality, that would also help a lot. It is useful to know what is
getting read/writing (or which function is being requested the most...).
Table format is also impo
Hey all,
I've got a new server set up, with dual Intel quad core processors, 4 gig of
ram, OpenSuse 10.3 (64bit) and MySql 5.0.45.
The majority of the tables are MyISAM with a few InnoDB here or there. I'm
using the huge-my.cnf as the base for my config.
Can anyone suggest some tweeking to th
Hey all,
I've got a new server set up, with dual Intel quad core processors, 4 gig of
ram, OpenSuse 10.3 (64bit) and MySql 5.0.45.
The majority of the tables are MyISAM with a few InnoDB here or there. I'm
using the huge-my.cnf as the base for my config.
Can anyone suggest some tweeking
]
Sent: Friday, June 11, 2004 7:45 AM
To: [EMAIL PROTECTED]
Subject: Re: Server optimization issue
"Misao" <[EMAIL PROTECTED]> wrote:
Take a deep look at
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
But ensure that this is MySQL who takes so much memory. Watch othe
Subject: Server optimization issue
06/10/2004 12:27
"Misao" <[EMAIL PROTECTED]> wrote:
Take a deep look at http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
But ensure that this is MySQL who takes so much memory. Watch other variables
like key_buffer. MySQL probably should not take that much memory if these are
the only variables spec
Misao wrote:
I have 4 MySQL 4.0.16 servers, all with Dual 3ghz Xeons and 4GB of RAM.
They use InnoDB for all tables, and the ibdata file is 70GB.
The DBs seem to be a little slow, and the darn thing is always using a huge
chunk of swap. I've tried increasing and decreasing what it's allowed to
use,
I have 4 MySQL 4.0.16 servers, all with Dual 3ghz Xeons and 4GB of RAM.
They use InnoDB for all tables, and the ibdata file is 70GB.
The DBs seem to be a little slow, and the darn thing is always using a huge
chunk of swap. I've tried increasing and decreasing what it's allowed to
use, but this see
18 matches
Mail list logo
