RE: Re: Replication Circle

2002-08-04 Thread Oren Zeev-Ben-Mordehai
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

multithreading and libmysqlclient.so on solaris - need help

2002-06-02 Thread Oren Zeev-Ben-Mordehai
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

core dump, multithreading using MyODBC on Solaris

2002-06-01 Thread Oren Zeev Ben Mordehai
? 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

RE: instead of subquery?

2002-05-07 Thread Oren Zeev-Ben-Mordehai
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

innodb tables problem

2002-05-07 Thread Oren Zeev-Ben-Mordehai
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

newbie question (can I build on MySQL/InnoDB for my project)

2002-05-07 Thread Oren Zeev-Ben-Mordehai
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