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 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
> the MYD. w
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
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 wrote:
>
>
> hey. this list used to be pretty active. did anyth
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
;>>> 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 tantalizin
- 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,
