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 adarsh.sha...@orkash.com
To:
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 ,size of
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,
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
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
; 20111219 03:42 PM -0800, Jim McNeely
Not if you are using innoDB tables. For these, you use INSERT and UPDATE
triggers.
Jim McNeely
On Dec 19, 2011, at 11:58 AM, Halász Sándor wrote:
2011/12/19 11:30 -0800, Jim McNeely
In the MySQL documentation, we find this tantalizing statement:
It
hey. this list used to be pretty active. did anything change? is there
another place to ask questions like these?
thanks...
On 1/23/12 5:02 PM, kalin m wrote:
hi all..
i started a repair on a table that has an MYD file of 9.2 gigs. the MYI
file is 7.7 gigs. the TMD file, which i'm
This is still the list although more quiet than it used to be.
Repairing a table is already a fragile process.. I would not try to
interrupt it if the data has no backup.
- michael dykman
On Mon, Jan 23, 2012 at 11:04 PM, kalin m ka...@el.net wrote:
hey. this list used to be pretty active.
ok. thanks. i thought so. it's been about 8 hrs so far. and the TMD file
is about half the MYD/MYI file. although MYI is about a gig smaller than
the MYD. which one has the TDM to reach in size in order for the repair
to be complete?
thanks.
On 1/23/12 11:27 PM, Michael Dykman wrote:
This is
I couldn't say. I have not had particularly good luck doing MyISAM repairs.
- md
On Mon, Jan 23, 2012 at 11:49 PM, kalin m ka...@el.net wrote:
ok. thanks. i thought so. it's been about 8 hrs so far. and the TMD file
is about half the MYD/MYI file. although MYI is about a gig smaller than