2010/9/28 Krishna Chandra Prajapati :
> Hi Vokern,
>
> I suggest to have a single ibdata1 file and use innodb_file_per_table to
> have multiple .ibd tables.
>
Can I upgrade to innodb_file_per_table smoothly?
thanks.
--
MySQL General Mailing List
For list archives: http://lists.
Yeah I have been using the latest 5.1.51 one.
# ./mysqld -V
100928 17:07:55 [Warning] '--skip-locking' is deprecated and will be
removed in a future release. Please use '--skip-external-locking'
instead.
./mysqld Ver 5.1.51-log for pc-linux-gnu on i686 (MySQL Community Server (GPL))
Thanks!
20
2010/9/28 Jangita :
>
> I do not think there is anything wrong with having one huge file is there?
> We have one innodb file of 85GB on ext3.
> Is there?
>
but how about the problem on the file has been increasing continuously?
thanks
--
MySQL General Mailing List
For list archives: http://lis
Hello,
Currently I have the setting:
innodb_data_file_path=ibdata1:10G;ibdata2:10G;ibdata3:10G;ibdata4:10G:autoextend
Because the last file of ibdata4 is very large (more than 50G), if I
want extend the data to more files, for example, ibdata5, ibdata6...
how to do it?
Thanks!
--
MySQL Gener
2010/9/23 Johnny Withers
>
> Can you show us the output of: show status like '%innodb%'
> JW
>
Sure.
mysql> show status like '%innodb%';
+---++
| Variable_name | Value |
+---+---
And this is the innodb file size, does this matter for performance?
$ du -h ibdata*
11G ibdata1
11G ibdata2
11G ibdata3
59G ibdata4
2010/9/22 vokern :
> This is piece of the setting in my.cnf:
>
> set-variable = innodb_buffer_pool_size=4G
>
This is piece of the setting in my.cnf:
set-variable = innodb_buffer_pool_size=4G
set-variable = innodb_additional_mem_pool_size=20M
set-variable = innodb_flush_log_at_trx_commit=2
set-variable =
innodb_data_file_path=ibdata1:10G;ibdata2:10G;ibdata3:10G;ibdata4:10G:autoextend
key_buffer
2010/9/21 :
> Quoting vokern :
>
>>
>> The disk is exactly Raid10.
>> The CPU is two 2.5G*4, totally 16G memory.
>>
>
> And how many disks do you have, and what type (SATA/SAS/FC etc) what RPM? To
> improve IO you can add more disks, or upgrade to faster dis
Thank you all for the kind helps.
I will check them and if still have problems I will come back.
2010/9/21 Machiel Richards :
>
> http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
>
>
> http://www.mysql.com/why-mysql/performance/
>
> http://www.debian
2010/9/21 :
> If its an IO problem the first and easiest thing to do is (probably) look at
> your disk subsystem. You can easily achieve higher disk IO by increasing the
> number of disks and implementing something like RAID1+0. What is your
> current disk configuration?
>
The disk is exactly Rai
. Have you changed any of
> the default buffer and cache sizes as yet?
>
> Regards
> Machiel
>
>
> -----Original Message-
> From: vokern
> To: mysql@lists.mysql.com
> Subject: document for mysql performance improvement
> Date: Tue, 21 Sep 2010 20:37:49 +0800
>
Hello,
We are using mysql-5.1 with innodb engine for a web 2.0 application.
But we found that the performance is not that good, i.e, the IO load
sometime is high, the query is timeout.
We run ubuntu server Linux, with apt-get for installing mysql.
So is there any good document for improving mysql
12 matches
Mail list logo
