mysqld got signal 11;

Hi... i have a mysql server with: Mysql version: 4.0.14-standard-log Redhat: 7.2 Kernel: 2.4.18 (Highmem) 4 GB de ram. Well mysql dies with this in the logs: --- InnoDB: Apply batch completed InnoDB: In a MySQL replication slave the last master

Re: mysqld got signal 11;

Hi, Michael Fernández M. wrote: key_buffer_size=402653184 read_buffer_size=2093056 max_used_connections=323 max_connections=800 threads_connected=55 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 3666809 K bytes of memory

Re: mysqld got signal 11;

El mar, 20-02-2007 a las 13:16 +0100, Nils Meyer escribió: Hi, Michael Fernández M. wrote: key_buffer_size=402653184 read_buffer_size=2093056 max_used_connections=323 max_connections=800 threads_connected=55 It is possible that mysqld could use up to key_buffer_size +

Re: mysqld got signal 11;

Hi, Michael Fernández M. wrote: i use 32 Bits kernel. Remember that you have to stay under 2GB total memory allocation! I think you hit that limit. innodb_additional_mem_pool_size = 500 MB. innodb_buffer_pool_size = 8 MB Before the innodb_additional_mem_pool_size was 1 MB, (the default

Re: mysqld got signal 11;

El mar, 20-02-2007 a las 13:38 +0100, Nils Meyer escribió: Hi, Michael Fernández M. wrote: i use 32 Bits kernel. Remember that you have to stay under 2GB total memory allocation! I think you hit that limit. Sorry, but why do you say that?, because of the 32 bits kernel?

Re: mysqld got signal 11;

Michael Fernández M. wrote: Remember that you have to stay under 2GB total memory allocation! I think you hit that limit. Sorry, but why do you say that?, because of the 32 bits kernel? Yes exactly. Depending on kernel version you can allocate something between 2 or 2.7GB. Until 2GB it's

Key buffer partially unused - why

Hi, I have allocated 500MB to key_buffer_size, but only 324MB is in use (64%). Am I right to assume that this can mean one of the following: (1) all indexes have already been cached and together they are just 324 MB, (2) there is a limiting variable (open_files, inodb_open_files, for example)

Re: Borland C++ Builder 2006 DLL Woes

Thanks, Mark. We did the same thing - used the ADO Class with MyOBDC. I put a call in to the sales rep. Maybe we'll get an answer someday. David | We have settled on the ado.net connector www.mysql.com after dbExpress | pains. Although apparently dbExpress does work. | What BDS 2006 service

Re: Key buffer partially unused - why

On 2007-02-20 Martijn van den Burg wrote: Hi, I have allocated 500MB to key_buffer_size, but only 324MB is in use (64%). Am I right to assume that this can mean one of the following: (1) all indexes have already been cached and together they are just 324 MB, Do find /var/lib/mysql -name

Re: row count inconsistency

At 6:23 PM -0500 2/19/07, Marty Landman wrote: Hi, I've got a very large table set up and have defined the id as auto_increment. No rows have been added, deleted, or replaced since the initial load so I'd expect the row count to equal the max(id) since mysql describe fidcid;

Re: Borland C++ Builder 2006 DLL Woes

At 09:42 AM 2/13/2007, [EMAIL PROTECTED] wrote: We just purchased The Borland Developer Studio 2006 IDE and are having significant problems using dbExpress objects to communicate with MySQL servers (both 4 and 5). Curiously, we can perform inserts but not selects, even though identical code in

ERROR 1045 (28000): Access denied for user 'root'@'localhost'

Hi. Using mySQL 4.1.22 on Linux, I got this error message suddenly this morning (it worked ok yesterday): - [EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) -- I created a

ERROR 1045 (28000): Access denied for user 'root'@'localhost'

Hi. Using mySQL 4.1.22 on Linux, I got this error message suddenly this morning (it worked ok yesterday): - [EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) -- I created a

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost'

Fixed: []# kill `cat /usr/local/mysql/var/server.pid` []# /usr/local/mysql/bin/mysqld_safe --skip-grant-tables []# /usr/local/mysql/bin/mysql mysql update user set password = password('xxx') where user = 'root' and host='localhost'; On 2/20/07, thomas Armstrong [EMAIL PROTECTED] wrote: Hi.

Gaining statistics from MySQL

I'm looking to find a way to determine the number of transactions that a particular database is processing each min/hour/day/month/year and would like to know of a known MySQL best practices for determining this information. I'm hoping that this can be determined at the database level, but am

multiple nistances at boot with mysqld_multi or other

I am trying to get a few instances of mysql running at boot time - and I have come across the command mysqld_multi. Seems to have a lot of documentation about kicking those off via command line - but not much on setting it up to start at boot. anyone have any insight into this? Either using

RE: MySQL Daylight Savings Time Patch

Any answers for the question below ? Is there a DST patch for MySql 4.0.20? Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 09, 2007 9:30 AM To: mysql@lists.mysql.com Subject: MySQL Daylight Savings Time Patch Is there a DST patch

Alter table - adding constraints?

I really don¹t know what to do because I keep getting this error. Any ideas? SQL query: ALTER TABLE pl_reports ADD CONSTRAINT fk_region FOREIGN KEY ( region ) REFERENCES Region( id ) ON UPDATE CASCADE ON DELETE CASCADE MySQL said: Documentation #1005 - Can't create table

Re: MySQL Daylight Savings Time Patch

Sun, Jennifer wrote: Any answers for the question below ? Is there a DST patch for MySql 4.0.20? Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 09, 2007 9:30 AM To: mysql@lists.mysql.com Subject: MySQL Daylight Savings Time

Re: Alter table - adding constraints?

Jay Paulson wrote: I really don¹t know what to do because I keep getting this error. Any ideas? SQL query: ALTER TABLE pl_reports ADD CONSTRAINT fk_region FOREIGN KEY ( region ) REFERENCES Region( id ) ON UPDATE CASCADE ON DELETE CASCADE MySQL said: Documentation #1005 - Can't create table

Re: MySQL Daylight Savings Time Patch

NTP won't solve this problem for you. NTP, as well as most computer clocks, know nothing about daylight savings time, or about time zones. What they know is how many seconds have elapsed since the epoch. The epoch, in the case of most UNIX-based OSes, is midnight January 1, 1970. I think

RE: MySQL Daylight Savings Time Patch

Thanks. Below is the notes from the version 5 manual, does that mean after I patch my OS, I may need to reload the timezone tables ? How I can determine that I have to reload the timezone tables, not might need? Or will it hurt anything if I just reload the tables anyway? Thanks. Note

RE: MySQL Daylight Savings Time Patch

At 4:36 PM -0500 2/20/07, Sun, Jennifer wrote: Any answers for the question below ? Is there a DST patch for MySql 4.0.20? Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 09, 2007 9:30 AM To: mysql@lists.mysql.com Subject: MySQL

RE: MySQL Daylight Savings Time Patch

At 4:17 PM -0600 2/20/07, Paul DuBois wrote: At 4:36 PM -0500 2/20/07, Sun, Jennifer wrote: Any answers for the question below ? Is there a DST patch for MySql 4.0.20? Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 09, 2007 9:30

RE: MySQL Daylight Savings Time Patch

At 5:08 PM -0500 2/20/07, Sun, Jennifer wrote: Thanks. Below is the notes from the version 5 manual, does that mean after I patch my OS, I may need to reload the timezone tables ? How I can determine that I have to reload the timezone tables, not might need? Or will it hurt anything if I just

Re: MySQL Daylight Savings Time Patch

Is there an easy way to test to see if MySQL already has the proper tables loaded? -Ryan Paul DuBois wrote: At 4:17 PM -0600 2/20/07, Paul DuBois wrote: At 4:36 PM -0500 2/20/07, Sun, Jennifer wrote: Any answers for the question below ? Is there a DST patch for MySql 4.0.20? Thanks.

Re: MySQL Daylight Savings Time Patch

At 4:40 PM -0600 2/20/07, Ryan Stille wrote: Is there an easy way to test to see if MySQL already has the proper tables loaded? -Ryan Yes, reload them. :-) After that, they're current! If you really want a non-reload test, you can do something like this (Credits: This example comes from

Re: Alter table - adding constraints?

1) both tables are InnoDB. 2) both tables have data in them. 3) both table are the exact same data types. On 2/20/07 3:51 PM, Chris White [EMAIL PROTECTED] wrote: Jay Paulson wrote: I really don¹t know what to do because I keep getting this error. Any ideas? SQL query: ALTER TABLE

Re: Alter table - adding constraints?

Jay Paulson wrote: 2) both tables have data in them. This is most likely your issue then, depending on the table size, go through and make sure that anything in the referenced column matches the referencing column. You should also be able to use SHOW INNODB STATUS to see what's possibly

RE: Year - Field type

Thanks for the advice Its actually just a year of birth and the year type field is perfect apart from the fact that it wont work with anything pre 1900 Regards John B -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: 20 February 2007 00:19 To:

MySQL Daylight Savings Time Patch

Running 4.1.22, on windows 98, I'm having trouble getting the time zone tables to actually work. I've loaded the tables as per: http://dev.mysql.com/downloads/timezones.html, and followed the diagnostics as per: http://lists.mysql.com/mysql/205115 . It appears that my results from said

Re: MySQL Daylight Savings Time Patch

Same exact issue on v5.0.27. I installed another windows patch, that did nothing, but then changed my system clock to march 12th, and then back to present day. Now the DST shifts are correct in the future and incorrect in the past. I've destroyed the timezone tables, and they made no

Using Triggers to Maintain a Table to prevent complex join statements...

We have a statement that joins 8 different tables to pull multiple rows from each table. I have heard of people using triggers to create, update and delete records in a table based on statements in other tables. The obvious result of this would be to SPEED up results right? :) I'd love to