than performance).
Whenever at least one of the servers is up it should be used
(and the other is not used even if it is also up).
Can you think of some pitfalls I need to watch out from?
Regards,
Oren.
Oren Zeev-Ben-Mordehai
Infrastructure Engineer
PhoneDo Networks
office: +972-9-951-7771
hint will be appreciated
(both regarding the workaround that I try to build and the main issue
itself).
Regards,
Oren.
Oren Zeev-Ben-Mordehai
Infrastructure Engineer
PhoneDo Networks
office: +972-9-951-7771 ext. 204
fax:+972-9-951-7772
email: [EMAIL PROTECTED]
sql,query
? Do you know any workaround?
Regards,
Oren.
Oren Zeev-Ben-Mordehai
Infrastructure Engineer
PhoneDo Networks
office: +972-9-951-7771 ext. 204
fax:+972-9-951-7772
email: [EMAIL PROTECTED]
sql,query
-
Before
Try to build the following table:
IDJOB | IDKIT | IDJOB2
4 | 19 | 4
4 | 19 | 4
4 | 19 | 4
4 | 19 | 4
4 | 19 | 2
4 | 19 | 2
2 | 19 | 4
2 | 19 | 4
2 | 19 | 2
2 | 5 | 2
(some join)
Then throw lines with
the
transaction,
and I've been wating for a long time and the database is still not
responsive.
Do I need to set some parameters?
Do you know a better way to do this?
P.S.
I'm also using log-bin (so another mysqld will be the slave of this one).
Oren Zeev-Ben-Mordehai
Infrastructure Engineer
Hi all,
I'm in the process of evaluating MySQL/InnoDB for a big project.
The data is composed from few tens millions of records with foreign keys
used between tables.
In the main table the search will be based on a string key (varchar(32)).
The scenarios in the systems are:
1. Bulk update