Re: FBSD 5.2.CURRENT-p4 and mysqld problems

2004-04-14 Thread Ganbold
Hi, I compiled mysql-4.0.18 from ports on CURRENT machine with BUILD_STATIC=yes option with libpthread. After installation everything seemed OK. However after few minutes it hang again. It seems mysql with libpthread is even more unstable than using linuxthreads. Ganbold At 09:30 PM

Re: FBSD 5.2.CURRENT-p4 and mysqld problems

2004-04-14 Thread Ganbold
any thread support. How can I compile it to use libpthread? thanks in advance, Ganbold At 09:30 PM 14.04.2004, you wrote: On Wed, 14 Apr 2004 20:44:30 +0900 Ganbold <[EMAIL PROTECTED]> wrote: > Can you give me some hints and tricks to compile mysql with libpthread? > What compiler op

Re: FBSD 5.2.CURRENT-p4 and mysqld problems

2004-04-14 Thread Ganbold
Hi, Can you give me some hints and tricks to compile mysql with libpthread? What compiler options should I use? thanks, Ganbold At 08:31 PM 14.04.2004, you wrote: On Wed, 14 Apr 2004 19:59:33 +0900 Ganbold <[EMAIL PROTECTED]> wrote: > So what threading library should I use with mys

Re: FBSD 5.2.CURRENT-p4 and mysqld problems

2004-04-14 Thread Ganbold
Hi, So what threading library should I use with mysql? Can somebody recommend me which to use? Because I'm bit confused. I used to use linuxthreads and it was pretty good. Now there appears some other threading libraries:) Which one is reliable and has good performance? Ganbold At 07:

Re: FBSD 5.2.CURRENT-p4 and mysqld problems

2004-04-12 Thread Ganbold
allocatre a "struct sigqueue" object, kernel behaviour in signal-passing changes, causing random hangs and segfaults in different programs. ------ Please let me know your opi

FBSD 5.2.CURRENT-p4 and mysqld problems

2004-04-11 Thread Ganbold
? Let me know if there is any solution. I know I should use FreeBSD 4.9 stable since it doesn't have any problem with this issue. However I need to solve this problem on FreeBSD-5.2-CURRENT. thanks in advance, Ganbold At 01:36 PM 05.04.2004, you wrote: yes, we resolved the issue it looks

mysql-4.0.18 build problem in FreeBSD-5.2-CURRENT

2004-03-11 Thread Ganbold
ports/databases/mysql40-server. --- What should do in this case? Is there anybody solved this problem before? tia, Ganbold -- MySQL General Mailing List For list archives: http://lists.mys

Re: How to speed up query?

2003-10-17 Thread Ganbold
rows | Extra | +-+--+---+--+-+---+--+-+ | message | ref | uid | uid | 4 | const | 2491 | Using where | +-+--+---+--+-+---+--+---------+ Ganbold At 12:54 PM 17.10.2003 +0300, you wrote: Ganbold <[EMAIL PROTECTED]> wr

How to speed up query?

2003-10-16 Thread Ganbold
= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout --------- How can I speed up this query? Can somebody help me? thanks in advance, Ganbold Ts. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql Problem in Windows 2000 advanced server

2003-09-25 Thread Ganbold
was same and I upgraded to mysql-4.0.15. Probably running mysql in Windows is not great as in Lunux/FreeBSD. It seems like it is better to switch into Linux/FreeBSD. Ganbold At 07:44 PM 9/25/2003 -0300, you wrote: At 12:33 25/9/2003 +0900, Ganbold wrote: Hi, I installed mysql-4.0.15 in Window

Mysql Problem in Windows 2000 advanced server

2003-09-24 Thread Ganbold
nt.exe user=root password=xxx - thanks in advance, Ganbold -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Help needed with MySQL C API-based client (segfault)

2003-09-18 Thread Ganbold
Here is the corrected version:) Take a look at Paul DuBois book. Don't use gets. Instead use fgets. That's safe. I didn't change your gets call:) hth, Ganbold #include #include #include #if defined(_WIN32) || defined(_WIN64) #include #endif #ifdef WIN32 #pragma comm

Re: Problem reading my.cnf

2003-08-04 Thread Ganbold
Hi, It was Ok in previous version of mysql. Why they changed ? Thanks anyway. Ganbold At 11:21 AM 8/4/2003 +0300, you wrote: Try to not use "#" if you want the password to be in my.cnf file. The "#" is for comments if my.cnf file. - Original Message - From: "G

Problem reading my.cnf

2003-08-04 Thread Ganbold
--no-auto-rehash Is this a bug of mysql command line client or it is something different? Is there anybody who solved this already? thanks in advance, Ganbold -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Replication problem

2003-08-03 Thread Ganbold
thread with "SLAVE START". We stopped at log 'backend2-bin.195' position 141630238 I checked binlog with mysqlbinnlog: mysqlbinlog -j 141630238 /var/db/mysql/backend2-bin.195 | head It showed 2 queries and both seems ok, because I tried manually insert those queries into

Re: Writing multi-threaded mysql application

2003-07-08 Thread Ganbold
Hi Loren, Thanks for quick response. The previous application is written by me in ANSI C using mysql API. I'd love to write it in Java if it was first time:) Do you have any suggestion related to MySQL C API? Ganbold At 02:28 AM 7/8/2003 -0700, you wrote: I'm not sure if there

Writing multi-threaded mysql application

2003-07-08 Thread Ganbold
tried to look at mysql.cc code but didn't find any mysql_thread_init() calls in the source. thanks in advance, Ganbold -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql 4.0.13 with Linuxthreads problem in FreeBSD 5.1-beta - SOLVED!

2003-06-09 Thread Ganbold
inuxthreads. It seems like dynamic building is not working right away. thanks anyway to all who tried to help me, Ganbold -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Big Insert query problem

2003-05-27 Thread Ganbold
e index. The query is only one insert query with 18MB of data. Can somebody suggest me the solution for this? Thanks in advance, Ganbold -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Book recomendations

2003-01-13 Thread Ganbold
MySQL from New Riders, author Paul DuBois HTH, Ganbold At 08:34 AM 1/8/2003 -0500, you wrote: I got a gift certificate for book store. I am looking for good MySql books with reference, examples, etc? Anyone have some ideas on good books to look at Chuck

Help! problem using MySQL C API

2002-11-13 Thread Ganbold
, with 512 MB RAM and 50GB HDD with 6GB of free space. MySQL version is :3.23.38 thanks in advance, Ganbold Below is my code snippets: - typedef struct user_b{ int contract_id;

Question regarding getting column value from previous record and putting in next record

2001-04-30 Thread ganbold
DailyTotal Due_balance Record 1:1 Ganbold1001010 110 Record 2:1 Ganbold11088 118 Due-balance=Total+Previous_balance Previous record's Due_balan