Adarsh Sharma wrote:
Thanks for the suggestions.
Last thing to close this topic :-
I create new partitions & files for ibdata files as :-
log-bin=/hdd5-1/mysql-bin
innodb_data_file_path =
/hdd2-1/innodb_data1/ibdata1:250G;/hdd3-1/innodb_data2/ibdata2:250G;/hdd4-1/innodb_data3/ibdata3:8G:aut
- Original Message -
> From: "Adarsh Sharma"
> 1. I am planning to to fix one partition /hdd2-1 for my binary logs
> for HA, rotate them monthly to extra backups.
Keeping binary and other logs on separate disks from your datafiles is a very
good plan. For backup purposes, make sure you
33 AM
Subject: Suggestions for ibdata files structure
Dear all,
I have some doubts regarding the configuration of Innodb files
structure.
As we know all myisam tables are stored in database directory and
innodb
use tablespaces ( ibdata1 ).
In My application , databases are the mixture of mysql &
> Dear all,
>
> I have some doubts regarding the configuration of Innodb files structure.
> As we know all myisam tables are stored in database directory and innodb
> use tablespaces ( ibdata1 ).
> In My application , databases are the mixture of mysql & innodb storage
> engines.
> In my database
o: "mysql"
> Sent: Monday, 23 January, 2012 10:50:33 AM
> Subject: Suggestions for ibdata files structure
>
> Dear all,
>
> I have some doubts regarding the configuration of Innodb files
> structure.
> As we know all myisam tables are stored in database d
