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
Ya i know that this is absolutely wrong , but I have some questions in
my mind :-
1. I am planning to to fix one partition /hdd2-1 for my binary logs for
HA, rotate them monthly to extra backups.
2. Remaining 3 system partitions ( /hdd3-1,/hdd4-1,/hdd5-1) contains
ibdata1:250GB,ibdata2:250GB,
> 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
Gah, my eyes :-)
That seems... needlessly complex. As a general rule, it's a good idea to have
one datafile per physical disk. Putting more datafiles on a single disk doesn't
magically increase parallellism.
- Original Message -
> From: "Adarsh Sharma"
> To: "mysql"
> Sent: Monday,
