Re: mysqld got signal 11; This could be because you hit a bug ....

2003-02-24 Thread Mariella Di Giacomo
Mariella Di Giacomo [EMAIL PROTECTED] wrote: Hello, I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 bit on Sun Solaris 2.8 and I have got the binaries form the mysql web site. The machine I am using has 32GB of RAM + 64GB of swap. Thanks in advance for your help, Mariella Hi

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-02-24 Thread Mariella Di Giacomo
:17 PM 2/24/03 +0200, you wrote: Mariella Di Giacomo writes: Hello, I have followed your suggestion. I have installed mysql-debug-4.0.10-gamma-sun-solaris2.9-sparc-64bit on the Solaris 8 (Machine with 8 cpus, 32GB of Memory and 64 of swap) server. I have started the mysqld program as root I

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-02-24 Thread Mariella Di Giacomo
Hi, I would prefer the debug version which the latest I believe is the 4.0.10. The same error I get it when I run ALTER TABLES or I try to insert data into tables. I will try and let you know. Thanks, Mariella At 06:31 PM 2/24/03 +0200, you wrote: Mariella Di Giacomo writes: Hi, I

Does MySQL store TimeZone and DayLight Saving Time changes ?

2003-02-14 Thread Mariella Di Giacomo
Hello, We are running MySQL server Ver 3.23.8 on a Linux system. We have a table that contains a field whose type is MODIFIED | timestamp(14) We would like to find out if there an easy way in MySQL to convert the date that is on the MODIFIED field (timestamp) to GMT time without an external

mysqld got signal 11; This could be because you hit a bug ....

2003-01-29 Thread Mariella Di Giacomo
Hello, I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 bit on Sun Solaris 2.8 and I have got the binaries form the mysql web site. The machine I am using has 32GB of RAM + 64GB of swap. At the certain point I got :

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-01-29 Thread Mariella Di Giacomo
/03 +0100, Mark wrote: - Original Message - From: Mariella Di Giacomo [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, January 29, 2003 1:12 AM Subject: mysqld got signal 11; This could be because you hit a bug Hello, I am running

Slow response with MRG tables.

2003-01-08 Thread Mariella Di Giacomo
Hello, I would like to ask three questions related to MySQL and MERGE tables. I have a program that reads from mysql server (4.0.5 for Solaris 2.8 on a V880 with 8 processors and 32 GB of memory), using Perl DBI MySQl driver, two tables FULLM (merge of 3 tables) and RECKM (merge of 15

Question about MySQL and lwp_mutex_lock and lwp_mutex_wakeup

2002-12-12 Thread Mariella Di Giacomo
Hello, I am running MySQL 4.0.5b 64 bits on a Solaris 2.8. The server used has 8 CPUs. MySQL DB has access (and menage) in that system 2DBs. The first DB is only is accessed only through SELECTS and the second one has been used for UPDATES and INSERTS. Initially I was running a process that

enable-assembler error and MySQL 64 bits compilation error

2002-12-06 Thread Mariella Di Giacomo
X-Sender: [EMAIL PROTECTED] X-Mailer: QUALCOMM Windows Eudora Version 5.0 Date: Fri, 06 Dec 2002 09:20:55 -0700 To: [EMAIL PROTECTED] From: Mariella Di Giacomo [EMAIL PROTECTED] Subject: --enable-assembler error and MySQL 64 bits compilation error on Solaris 2.8 Hello, I have been running

Question about MySQL replication and OPTIMIZE TABLE

2002-12-05 Thread Mariella Di Giacomo
Hello, I am running MySQL 4.0.5 64 bit on a Sun Solaris and I am using MyISAM Indices. I would like to set replication (one master and one slave). My question is: When I OPTIMIZE TABLE table1, ... on the master will the slave be updated or if I want to optimize the same tables on the slave I

Question about myisam_block_size

2002-12-02 Thread Mariella Di Giacomo
Hello, I am running MySQL 4.0.5 64 bit on a Sun Solaris and I am using MyISAM Indices. I have noticed that the myisam_block_size is set to 1K. What does it happen if I am going to change to 8K ? The reason for that is because the Solaris pagesize is set to 8K, so I was thinking that maybe I