2010/9/28 Jangita jang...@jangita.com:
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
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!
2010/9/28 Krishna Chandra Prajapati prajapat...@gmail.com:
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
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
2010/9/23 Johnny Withers joh...@pixelated.net
Can you show us the output of: show status like '%innodb%'
JW
Sure.
mysql show status like '%innodb%';
+---++
| Variable_name | Value |
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
. Have you changed any of
the default buffer and cache sizes as yet?
Regards
Machiel
-Original Message-
From: vokern vok...@gmail.com
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
2010/9/21 a.sm...@ukgrid.net:
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
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 machiel.richa...@gmail.com:
http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
http://www.mysql.com/why-mysql/performance/
2010/9/21 a.sm...@ukgrid.net:
Quoting vokern vok...@gmail.com:
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 disks.
Two disks
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
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 vok...@gmail.com:
This is piece of the setting in my.cnf:
set-variable = innodb_buffer_pool_size=4G
set-variable
12 matches
Mail list logo