Better option then polling ?

Hello, I am fairly new to mysql and have a strange request I am not sure if "stored procedures" will solve this. I have a table in a database that is constantly being updated with new information. I would like to be notified if certain information gets committed. Lets say for example the

RE: Optimizing a big query...

At 07:01 PM 3/10/2005, Chris W. Parker wrote: Homam S.A. on Wednesday, March 09, 2005 5:09 PM said: > If your tables are mostly read-only, you could > pre-generate page numbers on a periodic basis and > select only specific ranges WHERE row_number BETWEEN > page_start

RE: Optimizing a big query...

Homam S.A. on Wednesday, March 09, 2005 5:09 PM said: > If your tables are mostly read-only, you could > pre-generate page numbers on a periodic basis and > select only specific ranges WHERE row_number BETWEEN > page_start AND page_finish. How about just getting the

Re: remove trailing character

How about UPDATE table set email = TRIM(TRAILING '>' FROM email) http://dev.mysql.com/doc/mysql/en/string-functions.html Greg Fortune On Thursday 10 March 2005 03:29 pm, Scott Haneda wrote: > I managed to mess up and email storage addresses are in the format of > [EMAIL PROTECTED]> > > How I c

RE: remove trailing character

try updating the table like this... update TABLE set COLUMN = replace(COLUMN, >,); -Original Message- From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 3:30 PM To: MySql Subject: remove trailing character I managed to mess up and email storage addresses are in t

remove trailing character

I managed to mess up and email storage addresses are in the format of [EMAIL PROTECTED]> How I can strip off the ">", it does not exist on all, only some. thanks -- - Scott HanedaTel: 415.898.2602

Re: replication errors

Irek Słonina wrote: I was thinking that master is executing the same queries that slave does - if an error exists on slave then it first comes up on the master and master is not executing it either. You prove that I was wrong... now I must check the integrity of the data on my slaves, which all a

Re: replication errors

So there's already data missing on the slave *shrugs* Yep, you told it to SKIP ERRORS. That means that if any query generates an error, for any reason, it's just going to skip over it and move on. So data was missing on your slave the moment you restarted replication -- it skipped the UPDATE

Re: replication errors

Hi Chris, OK, I can't take this anymore. :) Now, I've been running for not even 1 hour with the skip-errors enabled A quick check, on ONE table... So there's already data missing on the slave *shrugs* Yep, you told it to SKIP ERRORS. That means that if any query generates an error, for a

RE: Slow queries only the first time

The key to your question is InnoDB. InnoDB keeps data and indexes in its buffer using LRU to flush. So the 2nd time your data was already in memory. Depending on your buffer size and database size you have all of the advantages of a memory resident database for frequently used data without the dis

Re: replication errors

- Original Message - From: "Richard Lynch" <[EMAIL PROTECTED]> To: "Chris Knipe" <[EMAIL PROTECTED]> Cc: Sent: Friday, March 11, 2005 12:08 AM Subject: Re: replication errors mysql> SELECT COUNT(RadAcctId) FROM RadiusAccounting; +--+ | COUNT(RadAcctId) | +---

Multiple 1-1 tables better performance

Apologies if this comes through twice... I *think* I fargled the To: the first time... My boss is claiming that having multiple 1-1 tables, with an index on the keys, is better performance. Example of his claim: table_1: person_id, name, phone table_2: person_id, address, city, state, zip, count

Re: replication errors

> mysql> SELECT COUNT(RadAcctId) FROM RadiusAccounting; > +--+ > | COUNT(RadAcctId) | > +--+ > |1144320 | > +--+ > 1 row in set (1.69 sec) > > [EMAIL PROTECTED]:~# mysql --host=mysqldb02 --database=DB -p > mysql> SELECT COUNT(RadAcctId) FR

Re: MAX_JOIN_SIZE error. 4.0 v 4.1

Hi! On Mar 10, Brett Harvey wrote: > I have a query that worked just fine in Mysql 3.x and 4.0. It no > longer works in 4.1. I receive the "The SELECT would examine more > than MAX_JOIN_SIZE rows; check your WHERE and use SET > SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay"

Re: where to get a mysql licence

At 08:48 AM 3/10/2005, Bungarz, Kai wrote: Hi! I wonder, where i can get answers about mysql licences. Does anybody know an adress to contact to? Best regards, Kai http://www.wido.de I might be wrong, but shouldn't the first place you look be the mysql.com site? Sounds logical to me anyway. Stev

Re: MAX_JOIN_SIZE error. 4.0 v 4.1

Brett Harvey <[EMAIL PROTECTED]> wrote on 03/10/2005 01:24:54 PM: > I have a query that worked just fine in Mysql 3.x and 4.0. It no > longer works in 4.1. I receive the "The SELECT would examine more > than MAX_JOIN_SIZE rows; check your WHERE and use SET > SQL_BIG_SELECTS=1 or SET SQL_MAX_JOI

Re: Slow queries only the first time

On Mar 10, 2005, at 11:20 AM, Bob O'Neill wrote: Hello. I am wondering why some of my queries are slow on the first run, but speedy on subsequent runs. They are not being query cached, as I have query_cache_type set to DEMAND. Is it something as simple as pulling the data into RAM from disk,

Re: Slow queries only the first time

Most likely it's the OS cache caching all those disk segments in memory. Also in InnoDB, MySQL uses the Buffer Pool Size to cache data pages in addition to the OS cache. If you're running ona Windows machine, you can easily tell what's going on by opening up Performance Monitor and watching Pages/

MySQL coredumps on FreeBSD if the SQL query contains a regexp expression

>Description: I am using MySQL 5.x on FreeBSD 5.4-PRE together with libpthread. These are the knobs I did provide to make (to compile the actual FreeBSD port): FORCE_PKG_REGISTER=yes \ WITH_OPENSSL=yes \ BUILD_OPTIMIZED=yes \ WITH_PROC_SCOPE_PTH=yes If executing the following SQL query, mysqld w

Re: What does the "my" mean in "MySQL"

At 19:45 +0100 3/10/05, Dr. Winter wrote: Hello, I have a question, which nobody could answer me yet: What does the "my" stand for in "MySQL"? http://dev.mysql.com/doc/mysql/en/history.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mai

What does the "my" mean in "MySQL"

Hello, I have a question, which nobody could answer me yet: What does the "my" stand for in "MySQL"? Kind regards Soeren -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MAX_JOIN_SIZE error. 4.0 v 4.1

I have a query that worked just fine in Mysql 3.x and 4.0. It no longer works in 4.1. I receive the "The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay" error My max_join_size is set at the defa

Re: replication errors

Chris Knipe wrote: Now, I've been running for not even 1 hour with the skip-errors enabled A quick check, on ONE table... [EMAIL PROTECTED]:~# mysql --host=mysqldb01 --database=DB -p Enter password: Reading table information for completion of table and column names You can turn off this featu

Slow queries only the first time

Hello. I am wondering why some of my queries are slow on the first run, but speedy on subsequent runs. They are not being query cached, as I have query_cache_type set to DEMAND. Is it something as simple as pulling the data into RAM from disk, or is there something else going on? Here's a simpl

How does one choose between MySQL and MaxDB?

Hello, I am planning to port some systems that are currently using proprietary database management to an SQL environment. In looking at the MySQL web site it appears that they have two different SQL database servers. I am trying to determine how to choose between the two. It doesn't appear to be

Re: Revoke all privileges on *.* doesn't work

Caron, Christian wrote: mysql> show grants for user3; +---+ | Grants for [EMAIL PROTECTED]| +---+ | GRANT USAGE ON *.* TO 'user3'@'%' | +---+ 1 row in set (0.00 sec) what am I doing wrong

Re: replication errors

Chris Knipe wrote: [..] Sure, there is a syntax error in the query - yes. But why does the master not put the complete query in the bin log? This is the second time in 3 days that it has happened now. Whilst we are on this, how do I tell the slave to skip the query and proceed with th

RE: Revoke all privileges on *.* doesn't work

At 11:01 -0500 3/10/05, Caron, Christian wrote: > > mysql> show grants for user3; > +---+ > | Grants for [EMAIL PROTECTED]| > +---+ > | GRANT USAGE ON *.* TO 'user3'@'%' | > +---+

RE: Revoke all privileges on *.* doesn't work

> > mysql> show grants for user3; > > +---+ > > | Grants for [EMAIL PROTECTED]| > > +---+ > > | GRANT USAGE ON *.* TO 'user3'@'%' | > > +---+ > > 1 row in set (0.00 sec) > > > > what am

Re: Revoke all privileges on *.* doesn't work

Nico Sabbi <[EMAIL PROTECTED]> wrote on 03/10/2005 10:46:37 AM: > Hi, > the documentation reads: > > REVOKE /|priv_type|/ [(/|column_list|/)] [, /|priv_type|/ > [(/|column_list|/)]] ... > ON {/|tbl_name|/ | * | *.* | /|db_name|/.*} > FROM /|user|/ [, /|user|/] ... > REVOKE ALL PRIVILEGES

migrate from one machine to another

Hi there. I'm an Oracle DBA who know very little about MySQL. I need to migrate MySQL from one box to another. Can anybody point me to some documentation? The platform is Solaris 8, MySQL 4.0. Thanks for any pointers, it's greatly appreciated!

Re: replication errors

Chris Knipe wrote: [..] Sure, there is a syntax error in the query - yes. But why does the master not put the complete query in the bin log? This is the second time in 3 days that it has happened now. Whilst we are on this, how do I tell the slave to skip the query and proceed with th

Re: Revoke all privileges on *.* doesn't work

From: "Nico Sabbi" > mysql> show grants for user3; > +---+ > | Grants for [EMAIL PROTECTED]| > +---+ > | GRANT USAGE ON *.* TO 'user3'@'%' | > +---+ > 1 row in set (0.00 sec) > > what am

Re: replication errors

Chris Knipe wrote: [..] Sure, there is a syntax error in the query - yes. But why does the master not put the complete query in the bin log? This is the second time in 3 days that it has happened now. Whilst we are on this, how do I tell the slave to skip the query and proceed with th

Revoke all privileges on *.* doesn't work

Hi, the documentation reads: REVOKE /|priv_type|/ [(/|column_list|/)] [, /|priv_type|/ [(/|column_list|/)]] ... ON {/|tbl_name|/ | * | *.* | /|db_name|/.*} FROM /|user|/ [, /|user|/] ... REVOKE ALL PRIVILEGES, GRANT OPTION FROM /|user|/ [, /|user|/] ... but it doesn't work, as you can see be

Re: where to get a mysql licence

> I wonder, where i can get answers about mysql licences. > Does anybody know an adress to contact to? > Best regards, www.mysql.com ? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server Upscene Productions http://www.upscene.com --

Mysql Deamon Stop Automatically

Hi Team, My Server's deamon goes down automatically, what are the basic steps to root cause. Thanks Suresh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Perl DBI does not print error.

The print string you show is: "prepare: $insert_sql: $DBI::errstr" but your error message is Unable to execute query: DBI::db=HASH(0x8647df0)->errstr I think your problem is with a print line like: print "Unable to execute query: $dbh->errstr" and Perl is interpolating $dbh, but n

Re: Perl DBI does not print error.

Hi! Am Do, den 10.03.2005 schrieb sam um 14:55: > Hi, > > The perl DBI does not prints error message: > $sth = $dbh->prepare($insert_sql) >|| print ERRFILE_OUT "prepare: $insert_sql: $DBI::errstr"; > > The out of this error only does not print why the error was occurred. > eg. > Una

where to get a mysql licence

Hi! I wonder, where i can get answers about mysql licences. Does anybody know an adress to contact to? Best regards, Kai http://www.wido.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

corrupt tables und extremly slow querys

Hello, we encounter a strange behaviour in one of our Database Server. Our setup consists of a SUN V440 which has mounted a NFS Share from a Network Appliance File Server. This setup have been running a long term without complications although we knew that there are many statements concerning

Re: Retrieving only the first record in a grouped query

"Daniel Dabner" <[EMAIL PROTECTED]> wrote on 03/10/2005 08:18:31 AM: > Hi, > > I have been trying to construct an SQL query joining two tables for an image > gallery. > > I want to display all the IMAGE_CATEGORIES along with the first image in > that category from the IMAGES table. The images

replication errors

Lo again, Master and Slave server, both running 5.0.2-LOG (Exactly the same versions). On the master, everything is working fine. Data that gets inserted / updated / deleted etc goes into the bin log, and gets replicated to the slave. HOWEVER On the slave, I am getting syntax errors from the qu

Re: Help massage date import

Scott Haneda <[EMAIL PROTECTED]> wrote on 03/09/2005 08:51:43 PM: > Mysql 4, I have datetime field set of -00-00 00:00:00 > > Sampling of data I need to insert in is as follow: > 12/26/04 13:35 > 12/25/04 12:41 > 12/25/04 8:53 > > How do a massage that to the proper format YYY-MM-DD HH:MM:SS

Perl DBI does not print error.

Hi, The perl DBI does not prints error message: $sth = $dbh->prepare($insert_sql) || print ERRFILE_OUT "prepare: $insert_sql: $DBI::errstr"; The out of this error only does not print why the error was occurred. eg. Unable to execute query: DBI::db=HASH(0x8647df0)->errstr: Dan anyone pleas

Retrieving only the first record in a grouped query

Hi, I have been trying to construct an SQL query joining two tables for an image gallery. I want to display all the IMAGE_CATEGORIES along with the first image in that category from the IMAGES table. The images are ordered by an integer field called IMAGE_ORDER. Here's what I have so far:

Re: Optimizing a big query...

--- mos <[EMAIL PROTECTED]> wrote: > Correct, but the speed difference will more than > make up for it. If you > have a busy website, it is very important not to > overtax the database > server with frills, like the number of rows found. > If you want to have the > record counts, then you will h

Re: Access Denied

Hello. Right. No need to FLUSH PRIVILEGES after GRANT. My fault, sorry. Michael Stassen <[EMAIL PROTECTED]> wrote: > > Gleb Paharenko wrote: >> Hello. >> >> Execute FLUSH PRIVILEGES after granting. >> See: >> http://dev.mysql.com/doc/mysql/en/flush.html >> http://dev.mysq

Re: skip-name-resolve

Hello. You may grant some rights to 'user'@'ip-address' and then if you can connect from that host and your mysql.user table doesn't have additional entries from that host - then this option works. If your MySQL version is newer then 4.0.6, you may execute: SELECT CURRENT_USER(); t

configuring Mysql Query Browser with charset latin5

How can I configure Mysql Query Browser with charset latin5? Thanks.. - Do you Yahoo!? Yahoo! Small Business - Try our new resources site!

Re: Use MySQL with Microsoft Office

From: "Patrick Connolly" > Somewhere about Wed, 09-Mar-2005 at 03:02PM +0100 (give or take), Jigal van Hemert wrote: > > |> From: "Curtis Maurand" > |> > Using ODBC, however, you can link Access tables to MySQL tables and use > |> > Access as the front end to MySQL. It works very nicely. > |> > |>