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 f

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 difference.

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 diagnostic

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: [EMA

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 f

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: >> >>

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 Pet

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 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 rel

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 AM

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 Dayl

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 L

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 Win

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

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 Patc

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 './survey_localhost/#sq

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

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 mysq

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 n

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: H

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: 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 C+

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: 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/mysq

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 pa

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) tha

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 sa

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;

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 va

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_s

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 Ho

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 b