Thanks a lot
On Tue, May 13, 2008 at 4:30 PM, Ben Clewett <[EMAIL PROTECTED]> wrote:
> Table level locking is inherent to MyIsam.
>
> Look into partitioning, as this breaks table into two or more other tables
> which will lock separately.
>
> Or use InnoDB:
>
> ALTER TABLE ... SET ENGINE=InnoDB;
Table level locking is inherent to MyIsam.
Look into partitioning, as this breaks table into two or more other
tables which will lock separately.
Or use InnoDB:
ALTER TABLE ... SET ENGINE=InnoDB; (I think)
Ben
Krishna Chandra Prajapati wrote:
Hi,
I am looking for a solution to reduce th
Hi,
I am looking for a solution to reduce the table locks as mytop shows that
table gets locked very frequently. During report generation.
Thanks,
Prajapati
On Tue, May 13, 2008 at 1:10 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> what is the reason for creating main_dup. If your thinking of t
Hi,
MyISAM is being used on production server. It applies table level locking.
>From mytop view, I see that the table gets locked very frequently for 5 to
10 seconds. Reports are generated everyday. so it scans billions of data (
1years data). Changing to innodb will be doing soon and optimising q
If you use InnoDB you should not have a problem as it used row-level
locking and isolated transitions.
Other than that you can split your tables into smaller ones using either
partitioning or the federated engine...
Ben
Krishna Chandra Prajapati wrote:
Hi,
Generally, in data modelling t
what is the reason for creating main_dup. If your thinking of taking a
backup of all the changes from main table, then the trigger also will have
to wait, till the locks on the main table are released.
This trigger would add another feather to the lock/load on the machine.
regards
anandkl
On 5
The absolute best modeling software I've seen for MySQL (and runner up
for the best modeling software I've ever used) is DBDesigner.
(http://www.fabforce.net/) It's open source, cross platform and very good.
There are a few quirks in it (mainly when editing the fields of a table,
sometimes the
Actually i installed erwin but it doesn't support mysql database directly. How do you
handle it with mysql?
Thanks for your reply.
"Fortuno, Adam" <[EMAIL PROTECTED]> wrote:
I like Erwin.
-Original Message-
From: Hardik Doshi [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 12:
