MySQL Cluster/Cluster Carrier Grade Changelogs Have Moved
Hi, The changelogs for MySQL Cluster have been consolidated and can now be found here: http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news.html They're now arranged by NDB version number: http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news-6-3.html http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news-6-2.html http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news-6-1.html Changelogs for individual releases can be found by converting all the . characters in the version string to - characters, appending this to http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news- and tacking on .html to the end. This sounds complicated, so here's an example: The changelog for MySQL 5.1.23-ndb-6.2.14 can be found at http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news-5-1-23-ndb-6-2-14.html cheers jon. -- Jon Stephens - [EMAIL PROTECTED] Technical Writer - MySQL Documentation Team Sun Microsystems AB - Database Technology Group Liljeholmen, Stockholm, Sweden (GMT +01.00) Mobile: +46 (0) 736 773 993 Skype: plastic-fish MySQL: www.mysql.com Sun: www.sun.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 5.1.14 Release - Change in Cluster System Tables
Hi, The following information is important to all MySQL Cluster 5.1 users, and especially to those using MySQL Cluster Replication. It was not included in the 5.1.14 release announcement, so I'm quoting the relevant update to the 5.1.14 changelog ( http://dev.mysql.com/doc/refman/5.1/en/news-5-1-14.html ) here: [begin] Two major changes have taken place with regard to the MySQL Cluster system tables. These are: 1. Incompatible change: The cluster database is no longer used. The tables formerly found in the cluster database are now in the mysql database, and have been renamed as ndb_binlog_index, ndb_apply_status, and ndb_schema. 2. The mysql.ndb_apply_status and mysql.ndb_schema tables (formerly cluster.apply_status and cluster.schema are now created by ndb_restore in the event that they do not already exist on the slave cluster. (Bug#14612: http://bugs.mysql.com/14612) Note: When upgrading from versions of MySQL previous to 5.1.14 to 5.1.14 or later, mysql_fix_privilege_tables merely creates a new mysql.ndb_binlog_index table, but does not remove the existing cluster database (or, if upgrading from MySQL 5.1.7 or earlier, the existing cluster_replication database), nor any of the tables in it. For more information, see Section 15.10.4, “Replication Schema and Tables”: http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication-schema.html [end] The fact that news of this non-trivial change for MySQL Cluster 5.1 did not make it into the official 5.1.14 release announcement is entirely my fault, and I hope you will accept my deepest apologies for the omission. cheers, j. -- Jon Stephens - [EMAIL PROTECTED] Technical Writer - MySQL Documentation Team ___ Brisbane, Australia (GMT +10.00) _x_ Bangkok, Thailand (GMT +07.00) ___ Office: +61 (7) 3209 1394 _x_ Office: +66 0 2740 3691 5 ext. #201 Mobile: +61 402 635 784 MySQL AB: www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Partition Help
Date: Mon, 02 Oct 2006 13:22:37 -0400 To: mysql@lists.mysql.com From: Michael Gargiullo [EMAIL PROTECTED] Subject: RE: Partition Help Message-id: [EMAIL PROTECTED] snip/ Daily partitions are created then sub partitioned across 6 data disks and 6 index disks. We attempted to build a new table per hour, and merge them after 3 hours. We killed the processes after 2 hours. 1 hour of data is approx 18GB. The server only has 12GB of RAM. I wish we could partition down to TO_HOUR instead of TO_DAY There's some discussion of this issue on the Partitioning Forum - http://forums.mysql.com/list.php?106 - and you're more likely to get topic-specific attention there from users and MySQL developers working with partitioning than you are here on the General list. Also, have you checked out the recent articles on partitioning available from our DevZone? These include: http://dev.mysql.com/tech-resources/articles/mysql_5.1_partitioning_with_dates.html http://dev.mysql.com/tech-resources/articles/mysql_5.1_partitions.html - both of which discuss date-based partitioning techniques that you might find useful. cheers jon. -- Jon Stephens - [EMAIL PROTECTED] Technical Writer - MySQL Documentation Team ___ Brisbane, Australia (GMT +10.00) _x_ Bangkok, Thailand (GMT +07.00) ___ Office: +61 (7) 3209 1394 _x_ Office: +66 0 2740 3691 5 ext. #201 Mobile: +61 402 635 784 MySQL AB: www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Number of connections to a database
Date: Mon, 29 Nov 2004 14:03:32 +0100 To: [EMAIL PROTECTED] From: Philippe de Rochambeau [EMAIL PROTECTED] Subject: Number of connections to a database Message-Id: [EMAIL PROTECTED] Hello, is there any way to tell the number of simultaneous connections to a mysql database at a given time, using SQL or a scripting language such as php, perl, etc. ? Many thanks. Philippe Perhaps this will help. mysql SHOW STATUS LIKE 'threads_connected'; +---+---+ | Variable_name | Value | +---+---+ | Threads_connected | 5 | +---+---+ 1 row in set (0.00 sec) mysql SHOW STATUS LIKE '%connect%'; +--+---+ | Variable_name| Value | +--+---+ | Aborted_connects | 2 | | Connections | 74| | Max_used_connections | 27| | Threads_connected| 5 | +--+---+ 4 rows in set (0.00 sec) Connections: Total number of connections made since the MySQL server was last restarted. Max_used_conections: Maximum number of simultaneous connections since the MySQL server was last restarted. Threads_connected: Current number of connections. -- Jon Stephens, Technical Writer MySQL AB www.mysql.com Office: +61 (7) 3388 2228 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: IF() problem
Date: Wed, 17 Nov 2004 12:50:47 +0100 To: [EMAIL PROTECTED] From: Przemyslaw Popielarski [EMAIL PROTECTED] Subject: IF() problem Message-ID: [EMAIL PROTECTED] select IF(BOOK1PL,BOOK1PL,BOOK1EN) from tBooksextra where ksi='id' - (content of BOOK1EN) select BOOK1PL from tBooksextra WHERE BOOK1PL IS NOT NULL AND BOOK1PL!='' AND ksi='id' - (content of BOOK1PL). Why didn't I get the content of BOOK1PL in 1st query? (checked in 4.0.21 and 4.1.7) Observe: mysql SELECT 'something' = 0, '' = 0; +-++ | 'something' = 0 | '' = 0 | +-++ | 1 | 1 | +-++ 1 row in set (0.02 sec) *Any* string value evaluates as 0 (FALSE), not just the empty string. You want If BOOK1PL is not empty, return BOOK1PL, otherwise return BOOK1EN, correct? Then try this instead: SELECT IF(BOOK1PL '', BOOK1PL, BOOK1EN) FROM tBooksextra WHERE ksi = 'id'; -- Jon Stephens, Technical Writer MySQL AB www.mysql.com Office: +61 (07) 3388 2228 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: IF() problem
A clarification. If a string value begins with a digit, MySQL does not convert it to zero (FALSE), but rather to an integer made up of the leading digits in the value (until a non-digit is reached). This can be shown by using the CAST() function. mysql SELECT '21b' = 0, CAST('21b' AS SIGNED); +---+---+ | '21b' = 0 | CAST('21b' AS SIGNED) | +---+---+ | 0 |21 | +---+---+ 1 row in set (0.00 sec) However, if the string value begins with a non-digit, then it is coerced or cast to zero: mysql SELECT 'b21' = 0, CAST('b21' AS SIGNED); +---+---+ | 'b21' = 0 | CAST('b21' AS SIGNED) | +---+---+ | 1 | 0 | +---+---+ 1 row in set (0.00 sec) It is still true that Przemyslaw was assuming that a non-empty string would always evaluate as TRUE, and this isn't necessarily the case. So the best strategy is to compare directly with the empty string, as already discussed. Thanks to Paul DuBois for reminding me of this. My apologies to anyone whom I might have misled. -- Jon Stephens, Technical Writer MySQL AB www.mysql.com Office: +61 (07) 3388 2228 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql NOT operator
Your question is a bit confusing. Here are the possibilities using AND: SELECT id FROM table WHERE col1 = a AND col2 = b; SELECT id FROM table WHERE col1 = a AND col2 b; SELECT id FROM table WHERE col1 a AND col2 = b; SELECT id FROM table WHERE col1 a AND col2 b; [ BTW, you can also write the last one as: SELECT id FROM table WHERE NOT (col1 = a OR col2 = b); ] Basically, what you want to do is to use in place of = if you want to test for the negative of a condition. Date: Sat, 06 Nov 2004 20:34:47 -0800 To: [EMAIL PROTECTED] From: L a n a [EMAIL PROTECTED] Subject: mysql NOT operator Message-ID: [EMAIL PROTECTED] Hello, Could you please tell me how I can write an sql statement in php when I'd llike to select boolean search in one field like except or NOT result. What I mean here is that I can execute the following: 1. SELECT data_id from table WHERE keyword = a AND keyword =b 2. SELECT data_id from table WHERE keyword = a OR keyword =b However, NOT operator gives an error: 3. SELECT data_id from table WHERE keyword = a NOT keyword =b ( returns sql error) Could you please help? Thank you, Lana -- Jon Stephens, Technical Writer MySQL AB www.mysql.com Office: +61 (07) 3388 2228 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL functions
In MySQL versions before 5.0, you can write a user-defined function in C and compile it as a shared object. Beginning with MySQL 5.0, you can write stored routines. See these sections of the MySQL Manual: http://dev.mysql.com/doc/mysql/en/Adding_functions.html http://dev.mysql.com/doc/mysql/en/Adding_procedures.html Date: Sat, 30 Oct 2004 23:13:42 +0200 To: [EMAIL PROTECTED] From: Ferhat BINGOL [EMAIL PROTECTED] Subject: MySQL functions Message-ID: [EMAIL PROTECTED] Hi, How do I add a new function to MySQL SQL statement list. What I mean is AVG(), MIN() or MAX() is a ready function isnt it? Is there a way to add new functions without compiling all server? Regards... -- Jon Stephens, Technical Writer MySQL AB www.mysql.com Office: +61 (07) 3388 2228 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]