Possible in sql, or just move it to a language

This is a one off I need to do Table1 has email addresses in it, table two also has email addresses in it. table1 represents bounced emails that need to be purged from the database. What I would like to do, is mark a field in table2, called "needs_purging" to true, when there is a match from tabl

processlist

Hi All, I have some doudts in db connections. Please clarify if u know. I am using MySQL 5 version, while my program(Java Program with threads) is running, some times i won't get DB connection with in expected time. When ever i type "show processlist" on mysql prompt, it is showing 180+ connecti

回复： Re: Innodb corruption help needed !?=

hi, I had already meet this situation: after I unpluggin the power cable, then start OS(redhat9.0, ext3 fs), start mysql, but innodb recovery was failed! but, I also test this case on another os(RHEL4,ext3 fs), there is no any problem. I think there maybe different to handle filesys

Segmentation Fault - core dumped

>Description: ./mysql_install_db --user=mysql Installing all prepared tables Segmentation Fault - core dumped Installation of system tables failed! >How-To-Repeat: run ./mysql_install_db --user=mysql >Fix: please suggest. >Submitter-Id: >Originator: >Organization: >MySQL support:

Plot UDF

Hi, Is there an aggregate UDF that would produce a simple plot (as a BLOB, e.g. in PNG format) from two columns of data? I'm pretty sure it's possible to write, but I don't want to do it if it's available somewhere. I realize that it normally should be done on the client side, in fact I've a

Re: Transaction/locking confusion

The difference here, is that any row locked via the SELECT .. FOR UPDATE will not even allows readers access to that record until, so you will not have processes concurrently trrying to process. This means that, for each row, any processes acting on it are force to be seqential each each subseque

Re: Transaction/locking confusion

On 14 Mar 2007, at 18:02, Michael Dykman wrote: SELECT * from process WHERE WHERE id = 123 AND status = 'init' FOR UPDATE; -- do a bunch of other stuff ... UPDATE process SET status = 'ready' WHERE id = 123 AND status = 'init'; I get what you're doing here, but I don't see why it's nece

Re: Don't have libmysqlclient.so

try find on your system find / -name '*lib*mysql*client*' -type f them link one to /usr/lib/libmysqlclient.so.10 and try it again until you find one that can solve the problem.. :) On 3/14/07, POON Ben <[EMAIL PROTECTED]> wrote: Hi everyone, I've just installed MySQL 5.0.37 from source.

Don't have libmysqlclient.so

Hi everyone, I've just installed MySQL 5.0.37 from source. One of my other programs require libmysqlclient.so.10 I was under the impression that if I installed MySQL from source, it will be made. I looked at /usr/local/lib and there is no libmysqlclient.so.10 or even a MySQL folder... Can an

Re: getting a " Duplicate entry" error when inserting a new record - but there is no duplicate record

thanks for the suggestions. doing the insert in the commandline gives the same error. i deleted all the other indexes except the one in question (just to see if it changed anything)...same error. did a check table (and a repair table and an optimize table) - no change. is it possible the

MySQL Benchmarking

Guys, System Configuration: Sun Microsystems sun4u Sun Fire E2900 System clock frequency: 150 MHZ Memory size: 65536 Megabytes CPU: 12 @ 1200 MHz I'm looking for a tool that will allow us to determine the max number of databases that can run in a single instance of MySQL on a pretty beefy ser

Re: Default root password not blank?

On 3/13/07, Merlin <[EMAIL PROTECTED]> wrote: I just compiled mysql4.1.22 on a suse 9.3 machine. All went fine, but when I try to change the password I get prompted for one. So I hit return as it is supposed to be blank, right? But it seems to be not: /usr/local/mysql/bin # ./mysqladmin -u root

Re: Innodb corruption help needed!

On 3/11/07, Jean-Sebastien Pilon <[EMAIL PROTECTED]> wrote: I am running a mysql database server and we experienced a power failure. The mysql server does not want to restart because innodb is corrupted. Version info: Mysql version 4.1.11-Debian_4sarge7-log Debian sarge Reiserfs filesystem Wha

Re: Performance - one integrated LAMP vs. seperate web, DB Server

Hi Merlin, It depends where most of the current load is being generated. If the majority of the load is coming from the processing of the website you would be better having the database and web server on different boxes - this will reduce the load on both servers and compensate for the lag yo

Re: Transaction/locking confusion

On 13 Mar 2007, at 13:44, JamesDR wrote: With what you've provided us: You can not prevent this. You are running in a transaction which is isolated from any others. But doesn't that isolation provide atomicity, i.e. the first transaction to commit will act as if all of its component querie

Re: Repair query overloading server

On 3/8/07, Gary Sewell <[EMAIL PROTECTED]> wrote: I'm having a problem with a single repair query seemingly taking over the whole server. I'll try and explain…. Large table or 1.2m rows, running a repair on this causes the query queue to grow and grow and finally max out. The problem isn't tabl

Re: how would mysqld restart affect dynamically set global variables?

dude try put it on var/my.cf set-variable = max_connections = 1024 set-variable = max_user_connections = 128 set-variable = table_cache=1200 :wq! i have this working with a mysql3x should be similar to mysql4/5x On 3/14/07, Bing Du <[EMAIL PROTECTED]> wrote: Hi, We're running mysql 4

MySQL Conference & Expo Early Registration closes today

Dear MySQL Users, The early registration of the MySQL Conference & Expo 23-26 April 2007 closes today, 14 March 2007. So if you want to cut your attendance costs by 200 US dollars, register now! Registration: http://www.mysqlconf.com/pub/w/54/register.html Here is a quick compilation of some we

Re: 5.0.37 hangs on startup

I've been recompiling with various options. It seems only when --with-mysql-ldflags=-all-static is included is the server unreliable. Symptoms: client will randomly hang on connecting, causing server to hang. Server cannot be stopped without kill -9 Is this a known bug or does it need reporting?

Performance - one integrated LAMP vs. seperate web, DB Server

Hi there, I do have a LAMP app that currently does run on a 1GB i686 Prozessor. The system is getting slower since traffic is raising. So I ordered another dedicated root server with an Opteron 4GB Raid System. I intended to run the second box as a pure DB Server and do the PHP and Weberserving

MySQL Conference & Expo Early Registration closes today

Dear MySQL Users, The early registration of the MySQL Conference & Expo 23-26 April 2007 closes today, 14 March 2007. So if you want to cut your attendance costs by 200 US dollars, register now! Registration: http://www.mysqlconf.com/pub/w/54/register.html Here is a quick compilation of some we

Re: how would mysqld restart affect dynamically set global variables?

We're running mysql 4.1.20. If I understand the manual correctly, I can change max_connections while mysqld is running without restart mysqld to make the change take effect Correct. But what if mysqld restarts later in some other situations, like machine reboot, would my (global) change on ma

MySQL Conference & Expo Early Registration closes today

Dear MySQL Users, The early registration of the MySQL Conference & Expo 23-26 April 2007 closes today, 14 March 2007. So if you want to cut your attendance costs by 200 US dollars, register now! Registration: http://www.mysqlconf.com/pub/w/54/register.html Here is a quick compilation of some we

Re: how would mysqld restart affect dynamically set global variables?

On Wed, March 14, 2007 9:35, Bing Du said: > Hi, > > We're running mysql 4.1.20. If I understand the manual correctly, I can > change max_connections while mysqld is running without restart mysqld to > make the change take effect. But what if mysqld restarts later in some > other situations, like

Re: how would mysqld restart affect dynamically set global variables?

I believe it would revert back to the settings in your my.cnf file. If you want the change to be permanent, then set it there. Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Bing Du wrote: Hi, We're running mysql 4.1.20. If I understand the manual correctly, I can chang

MySQL Conference & Expo Early Registration closes today

Dear MySQL Users, The early registration of the MySQL Conference & Expo 23-26 April 2007 closes today, 14 March 2007. So if you want to cut your attendance costs by 200 US dollars, register now! Registration: http://www.mysqlconf.com/pub/w/54/register.html Here is a quick compilation of some we

how would mysqld restart affect dynamically set global variables?

Hi, We're running mysql 4.1.20. If I understand the manual correctly, I can change max_connections while mysqld is running without restart mysqld to make the change take effect. But what if mysqld restarts later in some other situations, like machine reboot, would my (global) change on max_conne

Make problem

Hi, I'm trying to install mysql on solaris 10, sparc. I'm using gcc 3.4.6. I downloaded the source, and did the configure using the recommended: CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors \ -fno-exceptions -fno-rtti" ./configure \ --prefix=/usr/local/mysql

Re: using DISTINCT after the ORDER BY clause has been applied

hi bill.. thx a lot for that tip. it worked fine.. this is the final one SELECT DISTINCT t1.page_id FROM ( SELECT page_id FROM page_viewed ORDER BY ts DESC )t1 thanks. yashesh bhatia. On 3/14/07, Bill Guion <[EMAIL PROTECTED]> wrote: At 8:48 PM +0530 3/14/07, Yashesh Bhatia wrote: >On 3/14/

Re: using DISTINCT after the ORDER BY clause has been applied

On 3/14/07, Bill Guion <[EMAIL PROTECTED]> wrote: At 11:33 PM + 3/13/07, [EMAIL PROTECTED] wrote: >Date: Tue, 13 Mar 2007 20:56:08 +0530 >To: mysql@lists.mysql.com >From: "Yashesh Bhatia" <[EMAIL PROTECTED]> >Subject: using DISTINCT after the ORDER BY clause has been applied >Message-ID: <[E

Re: monitor multiple mysql servers with no 3306 access

> Hi > > Bing Du wrote: >> In our situation, we have three or four separate MySQL servers running. >> Each has 'skip-networking' configured. So mysql don't accept requests >> coming from outside via network. Each mysql server also runs as web >> server. 'Localhost' is used for communication betw

Re: monitor multiple mysql servers with no 3306 access

yes man try use Nagios or Cacti (put it on google) there is many ways that you can monitor it .. :) i think that Nagios is the best one , you can install a daemon to collect information between the [mysql service] -> Nagios NRPE (Nagios Remote Plugin Executor) on local box -> Nagios box with web

Re: Weighting searches

Hi John John Nichel wrote: The db is MySQL 4.1.20 and the column synonyms_misspellings has a FULLTEXT index on it (the db is set to index on 3 characters). Can anyone help me understand why it's not rating the one with the match three times higher than the one with the match twice, and point

Re: monitor multiple mysql servers with no 3306 access

Hi Bing Du wrote: In our situation, we have three or four separate MySQL servers running. Each has 'skip-networking' configured. So mysql don't accept requests coming from outside via network. Each mysql server also runs as web server. 'Localhost' is used for communication between web applic

5.0.37 hangs on startup

Hi, I've upgraded from 5.0.26 to 5.0.37, both compiled from same source options, and the newer release crashes on startup. 5.0.26 Appears fine on all counts. 5.0.37 Appears to start without innodb switched on, but mysql clients just hang, and you cannot stop it without several "killall -9 mysqld"