RE: Re: Replication Circle

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

multithreading and libmysqlclient.so on solaris - need help

2002-06-02 Thread Oren Zeev-Ben-Mordehai
main -> libmyodbc3.so -> libmysqlclient.so.10 -> libmyodbc3.so Any 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-9

core dump, multithreading using MyODBC on Solaris

2002-06-01 Thread Oren Zeev Ben Mordehai
e you seen this also? 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

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 (in

innodb tables problem

2002-05-07 Thread Oren Zeev-Ben-Mordehai
arts, trying to roll back 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-B

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 I