performance of heterogeneous joins
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 unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
select from otherdb.table question?
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 then querying. I'm using webware DBUtils for connection pooling. Would these connections also be taken into account? Thank you so much, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there any determined date for mysql 6 release?
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 MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Where can I get mysql.so?
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 I need to add extension=mysql.so in CLI's php.ini file (separate php.ini file that works for CLI only). The problem is my PHP configured with MySQL support and MySQL library doesn't load as dynamic library. I've searched for mysql.so on my server (find / -name mysql.so), but found only this: /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread- multi/auto/DBD/mysql/mysql.so I guess it's mysql.so from another installation, but I've copied it to extension directory and added extension=mysql.so to the CLI's php.ini file. Now, when I run my script with CLI, I get message: Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non- zts-20060613/mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/mysql.so: undefined symbol: PL_memory_wrap in Unknown on line 0 Fatal error: Call to undefined function mysql_connect() in /home/re/videoEncode.php on line 3 So, I guess I was right, it's mysql.so from another installation. I wonder, where can I get proper mysql.so? Can I download it somewhere? PS: My distro is Fedora 6. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ANNOUNCE: Nagios Plugin for MySQL performance
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 (Check for 'Slave io running: Yes') slave-sql-running (Check for 'Slave sql running: Yes') threads-connected (Check 'Threads connected') threadcache-hitrate (Check 'Thread cache hitrate') querycache-hitrate(Check 'Query cache hitrate') keycache-hitrate (Check 'MyISAM Key cache hitrate') bufferpool-hitrate(Check 'InnoDB Buffer pool hitrate') tablecache-hitrate(Check 'Table cache hitrate') table-lock-contention (Check 'Table lock contention') temp-disk-tables (Check 'Percent of temp tables created on disk') connection-time (Check 'Seconds to get a connection') slow-queries (Check 'Slow queries'*) qcache-lowmem-prunes (Check 'Query cache entries pruned because of low memory'*) bufferpool-wait-free (Check 'InnoDB Buffer pool waits for clean page available'*) log-waits (Check 'InnoDB log waits because of a too small log buffer'*) Example: check_mysql_perf -m qcache-hitrate OK - Query Cache Hitrate at 93.93%|qcache_hitrate=93.93%;90:;80: check_mysql_perf -m qcache-hitrate -w 95: -c 90: WARNING - Query Cache Hitrate at 93.93%|qcache_hitrate=93.93%;95:;90: Please take into account that you need also the nagios-plugins package (i recommend 1.4.11) for a successful build. The steps are: - tar zxvf nagios-plugins-1.4.11.tar.gz - cd nagios-plugins-1.4.11; ./configure; make - cd .. - tar zxvf check_mysql-perf-1.1.tar.gz - cd check_mysql-perf-1.1 - ./configure --with-officialplugins=/absolute/path/to/nagios-plugins-1.4.11 - make Of course a mysql-dev installation has to be found (or provided with --with-mysql) either in step 2 or step 6. You can find more documentation and the download link at http://www.consol.com/opensource/nagios/check-mysql-perf or if you like the german language http://www.consol.de/opensource/nagios/check-mysql-perf Greetings from Munich, Gerhard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Where can I get mysql.so?
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] Subject: Where can I get mysql.so? To: mysql@lists.mysql.com Date: Sunday, January 20, 2008, 1:32 AM 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 I need to add extension=mysql.so in CLI's php.ini file (separate php.ini file that works for CLI only). The problem is my PHP configured with MySQL support and MySQL library doesn't load as dynamic library. I've searched for mysql.so on my server (find / -name mysql.so), but found only this: /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread- multi/auto/DBD/mysql/mysql.so I guess it's mysql.so from another installation, but I've copied it to extension directory and added extension=mysql.so to the CLI's php.ini file. Now, when I run my script with CLI, I get message: Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non- zts-20060613/mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/mysql.so: undefined symbol: PL_memory_wrap in Unknown on line 0 Fatal error: Call to undefined function mysql_connect() in /home/re/videoEncode.php on line 3 So, I guess I was right, it's mysql.so from another installation. I wonder, where can I get proper mysql.so? Can I download it somewhere? PS: My distro is Fedora 6. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Handling Special Characters
-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 PROTECTED] wrote: I am having trouble inserting special characters into a table. I am using the MySQL client. I put the following commands into a text file (I'm on WinXP, using Notepad), copy them, and paste them into the MySQL command line client. SET NAMES utf8; CREATE TEMPORARY TABLE `giiexpr_db`.`eo_name_table` ( `eo_name` VARCHAR( 255 ) NOT NULL ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; INSERT INTO eo_name_table (eo_name) VALUES (Associated British Foods Plc (Abf) - Hot Drinks - World); SELECT * FROM eo_name_table; +-+ | eo_name | +-+ | Associated British Foods Plc (Abf) - Hot Drinks - World | +-+ 1 row in set (0.04 sec) That symbol before World is an N-dash, 0x96. This works perfectly. Here's where things go wrong. If instead of pasting these commands into the client, I source the exact same file, I get this: +-+ | eo_name | +-+ | Associated British Foods Plc (Abf) - Hot Drinks | +-+ 1 row in set (0.04 sec) It seems that special characters are treated differently when they are in a sourced file. It isn't just the N-dash, French accented characters cause the same problem. These are all single-byte characters. Just to be sure, I checked the length of the string in the field, and it accurately reflected the difference. That proves, to my satisfaction, that the problem is on the input side. I'm using version 4.1.22 community server on a Linux platform. I'm using version 5.0.45 of the CLI client. Anyone have any ideas? I was trying to avoid having to write a program to do this. After you get the data you want into the table via copy/paste, can you dump and reload it correctly with mysqldump dump.sql and mysql dump.sql? If so, try peeking into the dump file and see how it's written there. [JS] Just to make things more complicated, I've discovered that pasting in 0x96 works fine, pasting in an e-acute does not. I'll try your suggestion. This has been driving me nuts. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]