performance of heterogeneous joins

2008-01-19 Thread Alex K
Hi Guys, Is there a performance hit when joining across multiple databases as opposed to joining multiples tables in one database? Suppose the same tables are available across all databases. Thank you, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

select from otherdb.table question?

2008-01-19 Thread Alex K
Hi Guys, What does the statement select * from otherdb.table do if I haven't explicitly connected to otherdb previously? I would assume it connects to otherdb and does the select on table but does it create a new connection each time? Is it as efficient as explicitly connecting to otherdb and

Is there any determined date for mysql 6 release?

2008-01-19 Thread legolas
Hi Thank you for reading my post Is there any scheduled date mysql 6 release? I heard that it is based on falcon and can perform better... Thanks. -- View this message in context: http://www.nabble.com/Is-there-any-determined-date-for-mysql-6-release--tp14968233p14968233.html Sent from the

Where can I get mysql.so?

2008-01-19 Thread Apple7777
Hello, I have a problem running PHP scripts from PHP CLI. They work fine when I run them from my browser, but when I run same scripts from CLI, I get this error message: Fatal error: Call to undefined function mysql_connect() in /home/re/script.php on line 3 I've googled and found out that

ANNOUNCE: Nagios Plugin for MySQL performance

2008-01-19 Thread Gerhard Lausser
Hi list, i wrote a plugin for the Nagios monitoring system which allows you to check some performance related aspects of a MySQL database. The -m option tells the plugin the desired mode. Possible keywords are: slave-lag (Check 'Seconds behind master') slave-io-running

Re: Where can I get mysql.so?

2008-01-19 Thread Saravanan
Hi, Try the following link ftp://ftp.pbone.net/mirror/remi.collet.free.fr/rpms/fc6.x86_64/php-mysql-5.2.5-1.fc6.remi.x86_64.rpm if that doesn't match your need search http://rpm.pbone.net Saravanan --- On Sun, 1/20/08, Apple [EMAIL PROTECTED] wrote: From: Apple [EMAIL PROTECTED]

RE: Handling Special Characters

2008-01-19 Thread Jerry Schwartz
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baron Schwartz Sent: Friday, January 18, 2008 2:33 PM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: Handling Special Characters Jerry, On Jan 18, 2008 2:27 PM, Jerry Schwartz [EMAIL