From jyri@sac.sfbay.sun.com Fri Jan 30 17:01:11 2009 Received: from newsunmail1brm.central.sun.com (newsunmail1brm.Central.Sun.COM [129.147.62.245]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id n0V11B7e002751 for ; Fri, 30 Jan 2009 17:01:11 -0800 (PST) Received: from nwk-avmta-1.SFBay.Sun.COM (nwk-avmta-1.SFBay.Sun.COM [129.146.11.74]) by newsunmail1brm.central.sun.com (8.13.7+Sun/8.13.7/ENSMAIL,v2.2) with ESMTP id n0V1133v000445; Fri, 30 Jan 2009 18:01:11 -0700 (MST) Received: from pmxchannel-daemon.nwk-avmta-1.sfbay.Sun.COM by nwk-avmta-1.sfbay.Sun.COM (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0KEB0090T9HYZI00@nwk-avmta-1.sfbay.Sun.COM>; Fri, 30 Jan 2009 17:01:10 -0800 (PST) Received: from dm-sfbay-01.sfbay.sun.com ([129.145.155.118]) by nwk-avmta-1.sfbay.Sun.COM (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0KEB00I7N9HX9380@nwk-avmta-1.sfbay.Sun.COM>; Fri, 30 Jan 2009 17:01:09 -0800 (PST) Received: from sac.sfbay.sun.com (new-sac.SFBay.Sun.COM [129.146.175.65]) by dm-sfbay-01.sfbay.sun.com (8.13.8+Sun/8.13.8/ENSMAIL,v2.2) with ESMTP id n0V118lV063570; Fri, 30 Jan 2009 17:01:08 -0800 (PST) Received: from sac.sfbay.sun.com (localhost [127.0.0.1]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id n0V117fD002746; Fri, 30 Jan 2009 17:01:07 -0800 (PST) Received: (from jyri@localhost) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8/Submit) id n0V1176S002742; Fri, 30 Jan 2009 17:01:07 -0800 (PST) Date: Fri, 30 Jan 2009 17:01:07 -0800 (PST) From: Jyri Virkki Subject: Including MySQL 5.1 with Solaris [LSARC/2009/062 FastTrack timeout 02/06/2009] To: LSARC-ext@sun.com Cc: webstack-discuss@opensolaris.org Message-id: <200901310101.n0V1176S002742@sac.sfbay.sun.com> Content-transfer-encoding: 7BIT X-PMX-Version: 5.4.1.325704 Status: RO Content-Length: 21923 I am sponsoring this case for Sunanda Menon. It introduces MySQL 5.1 (incl. dtrace probes) support. Timeout set to Feb.6. Template Version: @(#)sac_nextcase %I% %G% SMI This information is Copyright 2009 Sun Microsystems 1. Introduction 1.1. Project/Component Working Name: Including MySQL 5.1 with Solaris 1.2. Name of Document Author/Supplier: Author: Sunanda Menon 1.3 Date of This Document: 30 January, 2009 4. Technical Description Including MySQL 5.1 with Solaris 15 January, 2009 1. Summary and motivation 1.1. Introduction This FastTrack delivers MySQL 5.1 as a component in OpenSolaris SFW consolidation. From the MySQL HomePage,"The MySQL Server 5.1 software is the most reliable, secure and up-to-date version of the world's most popular open source database for cost-effectively delivering E-commerce,Online Transaction Processing OLTP), and multi-terabyte data warehousing applications." MySQL Server 5.1 delivers new enterprise features, including: *Partitioning: This capability enables distributing portions of individual tables across a filesystem, according to rules which can be set when the table is created. *Row-based replication: Replication capabilities in MySQL originally were based on propagation of SQL statements from master to slave. This is called statement-based replication. As of MySQL 5.1.5, another basis for replication is available. This is called row-based replication. *Plugin API: MySQL 5.1 adds support for a very flexible plugin API that enables loading and unloading of various components at runtime, without restarting the server. *Server log tables: Before MySQL 5.1, the server writes general query log and slow query log entries to log files. As of MySQL 5.1, the server's logging capabilities for these logs are more flexible. *MySQL Cluster replication: Replication between MySQL Clusters is now supported.It is now also possible to replicate between a MySQL Cluster and a non-cluster database. *Improved backups for MySQL Cluster: A fault arising in a single data node during a Cluster backup no longer causes the entire backup to be aborted, as observed in previous versions of MySQL Cluster. This FastTrack proposes the integration of the most recent stable release of MySQL 5.1 into OpenSolaris This case seeks minor release binding. 1.2 Previous Relevant ARC cases LSARC 2007/608 - Including MySQL 5.0 with Solaris LSARC 2008/150 - Include 64-bit /Connectors ARC Case 2. Technical details 2.1 MySQL Objects MySQL objects are essentially the same as those in 5.0 with the path prefix simply changing from [/usr|/etc|/var]/mysql/5.0] to [[/usr|/etc|/var]/mysql/5.1], the only addition being a symbolic link /usr/bin/mysql -> /usr/mysql/5.1/bin/mysql to put the MySQL CLI client in the user's default search path. Users should note that the symbolic links are meant for writing scripts or such and also for the convenience of the CLI users typing in by hand. By using the symbolic links in scripts or such, the users need not change their scripts even when the underlying MySQL version changes. The detailed directory and file layout for MySQL5.1 is provided in Addendum 1. 2.2 SMF We will deliver the smf metafile and the smf startup script which is same as in MySQL 5.0. MySQL server for two different versions (5.0 and 5.1) can coexist based on the instance name (version_50 and version_51 respectively ). MySQL server by default runs on port 3306. To run another instance of the mysql server, the port number and the unix socket filename should be changed. 3. Manual Pages. MySQL provides a man page, which will be delivered in the appropriate man directory, [/usr/mysql/[.]/man]. Man page for MySQL5.1 will be suitably modified to include the addition of dtrace probes. A symbolic link will be created from the default Solaris location for the MySQL man page (mysql_51) as shown. /usr/share/man/man1/mysql_51.1 -> /usr/mysql/5.1/man/man1/mysql_51.1 4. Packaging and Delivery We will package MySQL under the following packages: SUNWmysql51u - usr Server package (including server deamon, C API, man pages,symbolic links, I18N) SUNWmysql51r - root (config,smf files and data directory) SUNWmysql51test - MySQL test packages SUNWmysql51lib - Package for MySQL libraries MySQL tests and sql-bench directories are bundled in a separate package. They are not necessary for running MySQL, but have packages for users to run a simple performance test, and also contain examples on using the client api's. They are also part of the standard MySQL distribution. The MySQL client libraries are currently separated into the SUNWmysql51lib package to allow for a smaller download size, and disk footprint for upstack products like PHP. 5. Coexistence Multiple versions can coexist, and are distinguished by the version ("5" for version 5.0 ,"51" is for version 5.1). Coexistence of different version in OpenSolaris is ensured on package level through different package names (Example SUNWmysql5u for 5.0, SUNWmysql51u for 5.1, etc.), and with different install paths for each package. To run another instance of mysql server, change the port number and the socket file name from the default 3306 and /tmp/mysql.sock respectively. For details refer http://dev.mysql.com/doc/refman/5.1/en/multiple-unix-servers.html. Coexistence of 5.0 and 5.1 in OpenSolaris has been chosen to allow users to test and migrate their applications from 5.0 to 5.1, instead of forcing an immediate upgrade. Although the changes between 5.0 and 5.1 should not cause problems for most applications, all users should ensure the compatibility of their databases and applications before performing the upgrade. 5.1 Upgrade You cannot use 5.0 DB files natively in 5.1 without running the upgrade procedure. Because of changes to the MySQL system tables, you cannot natively run MySQL 5.1 on a 5.0 database. Instead, you must test, and if necessary, update the native database files using the upgrade script provided (mysql_upgrade). Before starting the Upgrade, the user is advised to take a backup of the existing DB. Upgrade from MySQL 5.0 to 5.1 can be done in two different ways. Though Option2 is the safe and most preferred way to do the upgrade, Option1 is equally supported for small databases. Option1: Install 5.1 Stop the 5.0 server copy DB files manually from 5.0 to 5.1 datadir Run mysql_upgrade script Start the 5.1 server Option2: Install 5.1 Take a mysqldump of 5.0 datadir Restore dump onto 5.1 datadir Run mysql_upgrade Start the 5.1 server For more details on Upgrade refer http://dev.mysql.com/doc/refman/5.1/en/upgrade.html 6. MySQL Interfaces MySQL is a mature product and the interfaces are stable and has been available for a long time in the open source community as well as an established product. This section documents new interfaces introduced by this project. Other Interfaces for MySQL have been listed in previous MySQL 5.0 ARC case NAME STABILITY ------------------------------------------------------------------------------ /usr/bin/mysql symlink Volatile svc:/application/database/mysql:version_51 Committed /lib/svc/method/mysql_51 Project Private /var/svc/manifest/application/database/mysql_51.xml Project Private MySQL 5.1 Package Names Uncommitted (s.4) dTrace probes for MySQL Volatile connection-start connection-done command-start command-done query-start query-done query-parse-start(char *query) query-parse-done(char *query) query-cache-hit(char *query) query-cache-miss(char *query) query-exec-start(char *query) query-exec-done(char *query) insert-row-start insert-row-done update-row-start update-row-done delete-row-start delete-row-done handler-rdlock-start handler-rdlock-done handler-wrlock-start handler-wrlock-done handler-unlock-start handler-unlock-done filesort-start filesort-done select-start(char *query) insert-start(char *query) insert-done insert-select-start(char *query) insert-select-done update-start(char *query) update-done multi-update-start(char *query) multi-update-done delete-start(char *query) delete-done multi-delete-start(char *query) multi-delete-done net-read-start net-read-done net-write-start net-write-done The dtrace probes are labelled as "Volatile" for now because they are (a) not finalized and (b) not in the MySQL 5.1 source tree yet. They are stable and working but are not part of standard release. We are using a patch into the 5.1 source code. The dtrace documentation is a work-in-progress now and should be made available when the bits are officially released. 7. References [1] http://www.mysql.com or http://dev.mysql.com ================================================================ Addendum 1: MySQL Integration Directory and File Structure. 1. The following files are included in the MySQL integration (except the mysql-test and sql-bench files): /usr/mysql/5.1/README /usr/mysql/5.1/bin /usr/mysql/5.1/bin/innochecksum /usr/mysql/5.1/bin/msql2mysql /usr/mysql/5.1/bin/my_print_defaults /usr/mysql/5.1/bin/myisam_ftdump /usr/mysql/5.1/bin/myisamchk /usr/mysql/5.1/bin/myisamlog /usr/mysql/5.1/bin/myisampack /usr/mysql/5.1/bin/mysql /usr/mysql/5.1/bin/mysql_client_test /usr/mysql/5.1/bin/mysql_config /usr/mysql/5.1/bin/mysql_convert_table_format /usr/mysql/5.1/bin/mysql_find_rows /usr/mysql/5.1/bin/mysql_fix_extensions /usr/mysql/5.1/bin/mysql_fix_privilege_tables /usr/mysql/5.1/bin/mysql_install_db /usr/mysql/5.1/bin/mysql_secure_installation /usr/mysql/5.1/bin/mysql_setpermission /usr/mysql/5.1/bin/mysql_tzinfo_to_sql /usr/mysql/5.1/bin/mysql_upgrade /usr/mysql/5.1/bin/mysql_waitpid /usr/mysql/5.1/bin/mysql_zap /usr/mysql/5.1/bin/mysqlaccess /usr/mysql/5.1/bin/mysqladmin /usr/mysql/5.1/bin/mysqlbinlog /usr/mysql/5.1/bin/mysqlbug /usr/mysql/5.1/bin/mysqlcheck /usr/mysql/5.1/bin/mysqld /usr/mysql/5.1/bin/mysqld_multi /usr/mysql/5.1/bin/mysqld_safe /usr/mysql/5.1/bin/mysqldump /usr/mysql/5.1/bin/mysqldumpslow /usr/mysql/5.1/bin/mysqlhotcopy /usr/mysql/5.1/bin/mysqlimport /usr/mysql/5.1/bin/mysqlmanager /usr/mysql/5.1/bin/mysqlshow /usr/mysql/5.1/bin/mysqlslap /usr/mysql/5.1/bin/mysqltest /usr/mysql/5.1/bin/ndb_config /usr/mysql/5.1/bin/ndb_cpcd /usr/mysql/5.1/bin/ndb_delete_all /usr/mysql/5.1/bin/ndb_desc /usr/mysql/5.1/bin/ndb_drop_index /usr/mysql/5.1/bin/ndb_drop_table /usr/mysql/5.1/bin/ndb_error_reporter /usr/mysql/5.1/bin/ndb_mgm /usr/mysql/5.1/bin/ndb_mgmd /usr/mysql/5.1/bin/ndb_print_backup_file /usr/mysql/5.1/bin/ndb_print_schema_file /usr/mysql/5.1/bin/ndb_print_sys_file /usr/mysql/5.1/bin/ndb_restore /usr/mysql/5.1/bin/ndb_select_all /usr/mysql/5.1/bin/ndb_select_count /usr/mysql/5.1/bin/ndb_show_tables /usr/mysql/5.1/bin/ndb_size.pl /usr/mysql/5.1/bin/ndb_test_platform /usr/mysql/5.1/bin/ndb_waiter /usr/mysql/5.1/bin/ndbd /usr/mysql/5.1/bin/perror /usr/mysql/5.1/bin/replace /usr/mysql/5.1/bin/resolve_stack_dump /usr/mysql/5.1/bin/resolveip /usr/mysql/5.1/include /usr/mysql/5.1/include/mysql /usr/mysql/5.1/include/chardefs.h /usr/mysql/5.1/include/errmsg.h /usr/mysql/5.1/include/history.h /usr/mysql/5.1/include/keycache.h /usr/mysql/5.1/include/keymaps.h /usr/mysql/5.1/include/m_ctype.h /usr/mysql/5.1/include/m_string.h /usr/mysql/5.1/include/my_alloc.h /usr/mysql/5.1/include/my_config.h /usr/mysql/5.1/include/my_dbug.h /usr/mysql/5.1/include/my_dir.h /usr/mysql/5.1/include/my_getopt.h /usr/mysql/5.1/include/my_global.h /usr/mysql/5.1/include/my_list.h /usr/mysql/5.1/include/my_net.h /usr/mysql/5.1/include/my_no_pthread.h /usr/mysql/5.1/include/my_pthread.h /usr/mysql/5.1/include/my_semaphore.h /usr/mysql/5.1/include/my_sys.h /usr/mysql/5.1/include/my_xml.h /usr/mysql/5.1/include/mysql.h /usr/mysql/5.1/include/mysql_com.h /usr/mysql/5.1/include/mysql_embed.h /usr/mysql/5.1/include/raid.h /usr/mysql/5.1/include/mysql_time.h /usr/mysql/5.1/include/mysql_version.h /usr/mysql/5.1/include/mysqld_ername.h /usr/mysql/5.1/include/mysqld_error.h /usr/mysql/5.1/include/readline.h /usr/mysql/5.1/include/rlmbutil.h /usr/mysql/5.1/include/rlprivate.h /usr/mysql/5.1/include/rlshell.h /usr/mysql/5.1/include/rltypedefs.h /usr/mysql/5.1/include/sql_common.h /usr/mysql/5.1/include/sql_state.h /usr/mysql/5.1/include/sslopt-case.h /usr/mysql/5.1/include/sslopt-longopts.h /usr/mysql/5.1/include/sslopt-vars.h /usr/mysql/5.1/include/tilde.h /usr/mysql/5.1/include/typelib.h /usr/mysql/5.1/include/xmalloc.h /usr/mysql/5.1/man /usr/mysql/5.1/man/man1 /usr/mysql/5.1/man/man1/msql2mysql.1 /usr/mysql/5.1/man/man1/my_print_defaults.1 /usr/mysql/5.1/man/man1/myisam_ftdump.1 /usr/mysql/5.1/man/man1/myisamchk.1 /usr/mysql/5.1/man/man1/myisamlog.1 /usr/mysql/5.1/man/man1/myisampack.1 /usr/mysql/5.1/man/man1/mysql.1 /usr/mysql/5.1/man/man1/mysql.server.1 /usr/mysql/5.1/man/man1/mysql_config.1 /usr/mysql/5.1/man/man1/mysql_explain_log.1 /usr/mysql/5.1/man/man1/mysql_fix_privilege_tables.1 /usr/mysql/5.1/man/man1/mysql_tzinfo_to_sql.1 /usr/mysql/5.1/man/man1/mysql_upgrade.1 /usr/mysql/5.1/man/man1/mysql_zap.1 /usr/mysql/5.1/man/man1/mysqlaccess.1 /usr/mysql/5.1/man/man1/mysqladmin.1 /usr/mysql/5.1/man/man1/mysqlbinlog.1 /usr/mysql/5.1/man/man1/mysqlcheck.1 /usr/mysql/5.1/man/man1/mysqld_multi.1 /usr/mysql/5.1/man/man1/mysqldump.1 /usr/mysql/5.1/man/man1/mysqld_safe.1 /usr/mysql/5.1/man/man1/mysqlhotcopy.1 /usr/mysql/5.1/man/man1/mysqlimport.1 /usr/mysql/5.1/man/man1/mysqlman.1 /usr/mysql/5.1/man/man1/mysqlshow.1 /usr/mysql/5.1/man/man1/perror.1 /usr/mysql/5.1/man/man1/replace.1 /usr/mysql/5.1/man/man1/safe_mysqld.1 /usr/mysql/5.1/man/man8 /usr/mysql/5.1/man/man8/mysqld.8 /usr/mysql/5.1/man/man8/mysqlmanager.8 /usr/mysql/5.1/mysql-test /usr/mysql/5.1/share /usr/mysql/5.1/share/mysql /usr/mysql/5.1/share/binary-configure /usr/mysql/5.1/share/charsets /usr/mysql/5.1/share/charsets/Index.xml /usr/mysql/5.1/share/charsets/README /usr/mysql/5.1/share/charsets/armscii8.xml /usr/mysql/5.1/share/charsets/ascii.xml /usr/mysql/5.1/share/charsets/cp1250.xml /usr/mysql/5.1/share/charsets/cp1251.xml /usr/mysql/5.1/share/charsets/cp1256.xml /usr/mysql/5.1/share/charsets/cp1257.xml /usr/mysql/5.1/share/charsets/cp850.xml /usr/mysql/5.1/share/charsets/cp852.xml /usr/mysql/5.1/share/charsets/cp866.xml /usr/mysql/5.1/share/charsets/dec8.xml /usr/mysql/5.1/share/charsets/geostd8.xml /usr/mysql/5.1/share/charsets/greek.xml /usr/mysql/5.1/share/charsets/hebrew.xml /usr/mysql/5.1/share/charsets/hp8.xml /usr/mysql/5.1/share/charsets/keybcs2.xml /usr/mysql/5.1/share/charsets/koi8r.xml /usr/mysql/5.1/share/charsets/koi8u.xml /usr/mysql/5.1/share/charsets/latin1.xml /usr/mysql/5.1/share/charsets/latin2.xml /usr/mysql/5.1/share/charsets/latin5.xml /usr/mysql/5.1/share/charsets/latin7.xml /usr/mysql/5.1/share/charsets/macce.xml /usr/mysql/5.1/share/charsets/macroman.xml /usr/mysql/5.1/share/charsets/swe7.xml /usr/mysql/5.1/share/czech /usr/mysql/5.1/share/czech/errmsg.sys /usr/mysql/5.1/share/danish /usr/mysql/5.1/share/danish/errmsg.sys /usr/mysql/5.1/share/dutch /usr/mysql/5.1/share/dutch/errmsg.sys /usr/mysql/5.1/share/english /usr/mysql/5.1/share/english/errmsg.sys /usr/mysql/5.1/share/errmsg.txt /usr/mysql/5.1/share/estonian /usr/mysql/5.1/share/estonian/errmsg.sys /usr/mysql/5.1/share/fill_help_tables.sql /usr/mysql/5.1/share/french /usr/mysql/5.1/share/french/errmsg.sys /usr/mysql/5.1/share/german /usr/mysql/5.1/share/german/errmsg.sys /usr/mysql/5.1/share/greek /usr/mysql/5.1/share/greek/errmsg.sys /usr/mysql/5.1/share/hungarian /usr/mysql/5.1/share/hungarian/errmsg.sys /usr/mysql/5.1/share/italian /usr/mysql/5.1/share/italian/errmsg.sys /usr/mysql/5.1/share/japanese /usr/mysql/5.1/share/japanese/errmsg.sys /usr/mysql/5.1/share/korean /usr/mysql/5.1/share/korean/errmsg.sys /usr/mysql/5.1/share/mi_test_all /usr/mysql/5.1/share/mi_test_all.res /usr/mysql/5.1/share/my-huge.cnf /usr/mysql/5.1/share/my-innodb-heavy-4G.cnf /usr/mysql/5.1/share/my-large.cnf /usr/mysql/5.1/share/my-medium.cnf /usr/mysql/5.1/share/my-small.cnf /usr/mysql/5.1/share/polish /usr/mysql/5.1/share/polish/errmsg.sys /usr/mysql/5.1/share/mysql-log-rotate /usr/mysql/5.1/share/mysql.server /usr/mysql/5.1/share/mysql_fix_privilege_tables.sql /usr/mysql/5.1/share/ndb-config-2-node.ini /usr/mysql/5.1/share/norwegian /usr/mysql/5.1/share/norwegian/errmsg.sys /usr/mysql/5.1/share/norwegian-ny /usr/mysql/5.1/share/norwegian-ny/errmsg.sys /usr/mysql/5.1/share/portuguese /usr/mysql/5.1/share/portuguese/errmsg.sys /usr/mysql/5.1/share/romanian /usr/mysql/5.1/share/romanian/errmsg.sys /usr/mysql/5.1/share/russian /usr/mysql/5.1/share/russian/errmsg.sys /usr/mysql/5.1/share/serbian /usr/mysql/5.1/share/serbian/errmsg.sys /usr/mysql/5.1/share/slovak /usr/mysql/5.1/share/slovak/errmsg.sys /usr/mysql/5.1/share/spanish /usr/mysql/5.1/share/spanish/errmsg.sys /usr/mysql/5.1/share/swedish /usr/mysql/5.1/share/swedish/errmsg.sys /usr/mysql/5.1/share/ukrainian /usr/mysql/5.1/share/ukrainian/errmsg.sys /usr/share/man/man1/mysql_51.1 -> /usr/mysql/5.1/man/man1/mysql_51.1 /usr/bin/mysql ->/usr/mysql/5.1/bin/mysql /usr/mysql/bin ->/usr/mysql/5.1/bin /usr/mysql/docs ->/usr/mysql/5.1/docs /usr/mysql/include ->/usr/mysql/5.1/include /usr/mysql/lib ->/usr/mysql/5.1/lib /usr/mysql/man ->/usr/mysql/5.1/man /usr/mysql/mysql-test ->/usr/mysql/5.1/mysql-test /usr/mysql/share ->/usr/mysql/5.1/share /usr/mysql/sql-bench ->/usr/mysql/5.1/sql-bench /etc/mysql/5.1/my.cnf /etc/mysql/5.1/my-large.cnf /etc/mysql/5.1/my-huge.cnf /etc/mysql/5.1/my-medium.cnf /etc/mysql/5.1/my-small-cnf.cnf /etc/mysql/5.1/my.innodb-heavy-4G.cnf /etc/mysql/my.cnf ->/etc/mysql/5.1/my.cnf /var/mysql/data ->/var/mysql/5.1/data /lib/svc/method/mysql_51 /var/svc/manifest/application/database/mysql_51.xml /usr/mysql/5.1/lib/mysql/libmysqlclient.so.16.0.0 /usr/mysql/5.1/lib/mysql/libmysqlclient_r.so.16.0.0 /usr/mysql/5.1/lib/mysql/libndbclient.so.3.0.0 /usr/mysql/5.1/lib/mysql/plugin /usr/mysql/5.1/lib/mysql/plugin/ha_example.so.0.0.0 /usr/mysql/5.1/sql-bench /usr/mysql/5.1/mysql-test 64 bit files (sparcv9 listing only, exact same for amd64): /usr/mysql/5.1/bin/64 -> /usr/mysql/5.1/bin/sparcv9 /usr/mysql/5.1/bin/sparcv9/innochecksum /usr/mysql/5.1/bin/sparcv9/msql2mysql /usr/mysql/5.1/bin/sparcv9/my_print_defaults /usr/mysql/5.1/bin/sparcv9/myisam_ftdump /usr/mysql/5.1/bin/sparcv9/myisamchk /usr/mysql/5.1/bin/sparcv9/myisamlog /usr/mysql/5.1/bin/sparcv9/myisampack /usr/mysql/5.1/bin/sparcv9/mysql /usr/mysql/5.1/bin/sparcv9/mysql_client_test /usr/mysql/5.1/bin/sparcv9/mysql_config /usr/mysql/5.1/bin/sparcv9/mysql_convert_table_format /usr/mysql/5.1/bin/sparcv9/mysql_find_rows /usr/mysql/5.1/bin/sparcv9/mysql_fix_extensions /usr/mysql/5.1/bin/sparcv9/mysql_fix_privilege_tables /usr/mysql/5.1/bin/sparcv9/mysql_install_db /usr/mysql/5.1/bin/sparcv9/mysql_secure_installation /usr/mysql/5.1/bin/sparcv9/mysql_setpermission /usr/mysql/5.1/bin/sparcv9/mysql_tzinfo_to_sql /usr/mysql/5.1/bin/sparcv9/mysql_upgrade /usr/mysql/5.1/bin/sparcv9/mysql_waitpid /usr/mysql/5.1/bin/sparcv9/mysql_zap /usr/mysql/5.1/bin/sparcv9/mysqlaccess /usr/mysql/5.1/bin/sparcv9/mysqladmin /usr/mysql/5.1/bin/sparcv9/mysqlbinlog /usr/mysql/5.1/bin/sparcv9/mysqlbug /usr/mysql/5.1/bin/sparcv9/mysqlcheck /usr/mysql/5.1/bin/sparcv9/mysqld /usr/mysql/5.1/bin/sparcv9/mysqld_multi /usr/mysql/5.1/bin/sparcv9/mysqld_safe /usr/mysql/5.1/bin/sparcv9/mysqldump /usr/mysql/5.1/bin/sparcv9/mysqldumpslow /usr/mysql/5.1/bin/sparcv9/mysqlhotcopy /usr/mysql/5.1/bin/sparcv9/mysqlimport /usr/mysql/5.1/bin/sparcv9/mysqlmanager /usr/mysql/5.1/bin/sparcv9/mysqlshow /usr/mysql/5.1/bin/sparcv9/mysqlslap /usr/mysql/5.1/bin/sparcv9/mysqltest /usr/mysql/5.1/bin/sparcv9/ndb_config /usr/mysql/5.1/bin/sparcv9/ndb_cpcd /usr/mysql/5.1/bin/sparcv9/ndb_delete_all /usr/mysql/5.1/bin/sparcv9/ndb_desc /usr/mysql/5.1/bin/sparcv9/ndb_drop_index /usr/mysql/5.1/bin/sparcv9/ndb_drop_table /usr/mysql/5.1/bin/sparcv9/ndb_error_reporter /usr/mysql/5.1/bin/sparcv9/ndb_mgm /usr/mysql/5.1/bin/sparcv9/ndb_mgmd /usr/mysql/5.1/bin/sparcv9/ndb_print_backup_file /usr/mysql/5.1/bin/sparcv9/ndb_print_schema_file /usr/mysql/5.1/bin/sparcv9/ndb_print_sys_file /usr/mysql/5.1/bin/sparcv9/ndb_restore /usr/mysql/5.1/bin/sparcv9/ndb_select_all /usr/mysql/5.1/bin/sparcv9/ndb_select_count /usr/mysql/5.1/bin/sparcv9/ndb_show_tables /usr/mysql/5.1/bin/sparcv9/ndb_size.pl /usr/mysql/5.1/bin/sparcv9/ndb_test_platform /usr/mysql/5.1/bin/sparcv9/ndb_waiter /usr/mysql/5.1/bin/sparcv9/ndbd /usr/mysql/5.1/bin/sparcv9/perror /usr/mysql/5.1/bin/sparcv9/replace /usr/mysql/5.1/bin/sparcv9/resolve_stack_dump /usr/mysql/5.1/bin/sparcv9/resolveip /usr/mysql/5.1/lib/sparcv9/mysql/usrlibmysqlclient.so.16.0.0 /usr/mysql/5.1/lib/sparcv9/mysql/usrlibmysqlclient_r.so.16.0.0 /usr/mysql/5.1/lib/sparcv9/mysql/usrlibndbclient.so.3.0.0 /usr/mysql/5.1/lib/sparcv9/mysql/plugin /usr/mysql/5.1/lib/sparcv9/mysql/plugin/ha_example.so.0.0.0 6. Resources and Schedule 6.4. Steering Committee requested information 6.4.1. Consolidation C-team Name: sfw 6.5. ARC review type: FastTrack 6.6. ARC Exposure: open From peter.tribble@gmail.com Sat Jan 31 08:15:31 2009 Received: from newsunmail1brm.central.sun.com (newsunmail1brm.Central.Sun.COM [129.147.62.245]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id n0VGFV0Q026228 for ; Sat, 31 Jan 2009 08:15:31 -0800 (PST) Received: from nwk-avmta-2.sfbay.sun.com (nwk-avmta-2.SFBay.Sun.COM [129.145.155.6]) by newsunmail1brm.central.sun.com (8.13.7+Sun/8.13.7/ENSMAIL,v2.2) with ESMTP id n0VGFTZo048115 for <@sunmail2sca.sfbay.sun.com:LSARC-ext@sun.com>; Sat, 31 Jan 2009 09:15:30 -0700 (MST) Received: from pmxchannel-daemon.nwk-avmta-2.sfbay.sun.com by nwk-avmta-2.sfbay.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0KEC00017FTT5W00@nwk-avmta-2.sfbay.sun.com> for LSARC-ext@sun.com (ORCPT LSARC-ext@sun.com); Sat, 31 Jan 2009 08:15:29 -0800 (PST) Received: from sca-ea-mail-2.sun.com ([192.18.43.25]) by nwk-avmta-2.sfbay.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0KEC008KVFTT6K80@nwk-avmta-2.sfbay.sun.com> for LSARC-ext@sun.com (ORCPT LSARC-ext@sun.com); Sat, 31 Jan 2009 08:15:29 -0800 (PST) Received: from relay41i.sun.com ([192.5.209.70]) by sca-ea-mail-2.sun.com (8.13.7+Sun/8.12.9) with ESMTP id n0VGEavZ025073 for ; Sat, 31 Jan 2009 16:15:28 +0000 (GMT) Received: from mms49es.mms.us.syntegra.com ([160.41.221.232] [160.41.221.232]) by relay41i.sun.com with ESMTP id BT-MMP-164697 for LSARC-ext@sun.com; Sat, 31 Jan 2009 16:15:28 +0000 (Z) Received: from relay43i.sun.com (relay43i.sun.com [192.5.209.74]) by mms49es.mms.us.syntegra.com with ESMTP id BT-MMP-5076472 for LSARC-ext@sun.com; Sat, 31 Jan 2009 16:15:28 +0000 (Z) Received: from mail-bw0-f16.google.com ([209.85.218.16] [209.85.218.16]) by relay4i.sun.com with ESMTP id BT-MMP-2003596 for LSARC-ext@sun.com; Sat, 31 Jan 2009 16:15:28 +0000 (Z) Received: by bwz9 with SMTP id 9so550169bwz.8 for ; Sat, 31 Jan 2009 08:15:13 -0800 (PST) Received: by 10.180.246.2 with SMTP id t2mr59158bkh.161.1233418513876; Sat, 31 Jan 2009 08:15:13 -0800 (PST) Date: Sat, 31 Jan 2009 16:15:13 +0000 From: Peter Tribble Subject: Re: [webstack-discuss] Including MySQL 5.1 with Solaris [LSARC/2009/062 FastTrack timeout 02/06/2009] In-reply-to: <200901310101.n0V1176S002742@sac.sfbay.sun.com> To: Jyri Virkki Cc: LSARC-ext@sun.com, webstack-discuss@opensolaris.org Message-id: MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: 7BIT DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=+GdOugtwvrdbMMkt0f0zNlbBGoHEg7E51w0wQ5z8YVE=; b=XmZT5/F+x0Knn5cOUqLip6jmOOx4PD92c6Ye9Dz8W9hI+eYJ8ru4K6freBGFnNJq7Y pvqgRGyMMFuQaH13qssdJq54rVaFe3adpMfPUnTkYozQ2cDvLGr1fyKAqgFU60OCD+B1 0Mc5OV7Xz2qoc1jaEC0MDXarBS4Zs4zV2fLEQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=xMn45Mpg+kNbriM3rKRjEni7mfQSJE16l5JCi5oQ48DkI+6ICcKiLR9xRYb5Y066mv xlPJ+CNl92lABNh5xAm78HDYMVk0hl3XftfJfE3y2B7kJE0AGHt8fjU9yualTM49lDz0 HoCbDKuGwBPA/aHr2q25GXsfSNvYoHO5jebK8= X-PMX-Version: 5.4.1.325704 X-Brightmail-Tracker: AAAAAA== X-Antispam: No, score=0.0/5.0, scanned in 0.118sec at (localhost [127.0.0.1]) by smf-spamd v1.3.1 - http://smfs.sf.net/ References: <200901310101.n0V1176S002742@sac.sfbay.sun.com> Status: RO Content-Length: 451 On Sat, Jan 31, 2009 at 1:01 AM, Jyri Virkki wrote: > > I am sponsoring this case for Sunanda Menon. It introduces MySQL 5.1 > (incl. dtrace probes) support. Timeout set to Feb.6. > > This FastTrack proposes the integration of the most recent stable > release of MySQL 5.1 into OpenSolaris Which would be which version specifically? 5.1.30? -- -Peter Tribble http://www.petertribble.co.uk/ - http://ptribble.blogspot.com/ From Sunanda.Menon@sun.com Sun Feb 1 21:26:43 2009 Received: from sunmail2sca.sfbay.sun.com (sunmail2sca.SFBay.Sun.COM [129.145.155.234]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id n125Qh0S005484 for ; Sun, 1 Feb 2009 21:26:43 -0800 (PST) Received: from brm-avmta-1.central.sun.com (brm-avmta-1.Central.Sun.COM [129.147.4.11]) by sunmail2sca.sfbay.sun.com (8.13.7+Sun/8.13.7/ENSMAIL,v2.2) with ESMTP id n125Qgk6029999 for <@sunmail2sca.sfbay.sun.com:LSARC-ext@sun.com>; Sun, 1 Feb 2009 21:26:43 -0800 (PST) Received: from pmxchannel-daemon.brm-avmta-1.central.sun.com by brm-avmta-1.central.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0KEF00M1NB4IUQ00@brm-avmta-1.central.sun.com> for LSARC-ext@sun.com (ORCPT LSARC-ext@Sun.COM); Sun, 01 Feb 2009 22:26:42 -0700 (MST) Received: from sineb-mail-1.sun.com ([192.18.19.6]) by brm-avmta-1.central.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0KEF00AXIB4FT650@brm-avmta-1.central.sun.com> for LSARC-ext@sun.com (ORCPT LSARC-ext@Sun.COM); Sun, 01 Feb 2009 22:26:40 -0700 (MST) Received: from fe-apac-06.sun.com (fe-apac-06.sun.com [192.18.19.177] (may be forged)) by sineb-mail-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id n125QdI3021052 for ; Mon, 02 Feb 2009 05:26:39 +0000 (GMT) Received: from conversion-daemon.mail-apac.sun.com by mail-apac.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0KEF00E01B2C9T00@mail-apac.sun.com> (original mail from Sunanda.Menon@Sun.COM) for LSARC-ext@Sun.COM (ORCPT LSARC-ext@Sun.COM); Mon, 02 Feb 2009 13:26:39 +0800 (SGT) Received: from [129.150.156.3] by mail-apac.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0KEF00GTPB4AD5RT@mail-apac.sun.com>; Mon, 02 Feb 2009 13:26:39 +0800 (SGT) Date: Mon, 02 Feb 2009 10:58:15 +0530 From: sunanda menon Subject: Re: [webstack-discuss] Including MySQL 5.1 with Solaris [LSARC/2009/062 FastTrack timeout 02/06/2009] In-reply-to: Sender: Sunanda.Menon@sun.com To: Peter Tribble Cc: Jyri Virkki , LSARC-ext@sun.com, webstack-discuss@opensolaris.org Message-id: <4986846F.7050502@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT X-PMX-Version: 5.4.1.325704 References: <200901310101.n0V1176S002742@sac.sfbay.sun.com> User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) Status: RO Content-Length: 461 Peter Tribble wrote: > On Sat, Jan 31, 2009 at 1:01 AM, Jyri Virkki wrote: > >> I am sponsoring this case for Sunanda Menon. It introduces MySQL 5.1 >> (incl. dtrace probes) support. Timeout set to Feb.6. >> >> This FastTrack proposes the integration of the most recent stable >> release of MySQL 5.1 into OpenSolaris >> > > Which would be which version specifically? 5.1.30? > > That's correct .5.1.30 is the GAed version. From Jyri.Virkki@sun.com Tue Feb 10 19:53:31 2009 Received: from newsunmail1brm.central.sun.com (newsunmail1brm.Central.Sun.COM [129.147.62.245]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id n1B3rV2U029652 for ; Tue, 10 Feb 2009 19:53:31 -0800 (PST) Received: from nwk-avmta-1.SFBay.Sun.COM (nwk-avmta-1.SFBay.Sun.COM [129.146.11.74]) by newsunmail1brm.central.sun.com (8.13.7+Sun/8.13.7/ENSMAIL,v2.2) with ESMTP id n1B3rNFg061709; Tue, 10 Feb 2009 20:53:29 -0700 (MST) Received: from pmxchannel-daemon.nwk-avmta-1.sfbay.Sun.COM by nwk-avmta-1.sfbay.Sun.COM (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0KEV00F03UT0GT00@nwk-avmta-1.sfbay.Sun.COM>; Tue, 10 Feb 2009 19:53:24 -0800 (PST) Received: from brmea-mail-1.sun.com ([192.18.98.31]) by nwk-avmta-1.sfbay.Sun.COM (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0KEV005XIUSZXUC0@nwk-avmta-1.sfbay.Sun.COM>; Tue, 10 Feb 2009 19:53:24 -0800 (PST) Received: from dm-usca15-11.red.iplanet.com (host-185-56-18-192.iplanet.com [192.18.56.185] (may be forged)) by brmea-mail-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id n1B3qRec009375; Wed, 11 Feb 2009 03:52:27 +0000 (GMT) Received: from buye.red.iplanet.com (buye [192.18.65.224]) by dm-usca15-11.red.iplanet.com (8.11.7p1+Sun/8.11.7/IPLANET,v1.2) with ESMTP id n1B3qQm19265; Tue, 10 Feb 2009 19:52:27 -0800 (PST) Received: from buye.red.iplanet.com (localhost [127.0.0.1]) by buye.red.iplanet.com (8.13.7+Sun/8.13.7) with ESMTP id n1B3qQHj014189; Tue, 10 Feb 2009 19:52:26 -0800 (PST) Received: (from jyri@localhost) by buye.red.iplanet.com (8.13.7+Sun/8.13.7/Submit) id n1B3qQ0U014188; Tue, 10 Feb 2009 19:52:26 -0800 (PST) Date: Tue, 10 Feb 2009 19:52:26 -0800 From: Jyri Virkki Subject: Re: Including MySQL 5.1 with Solaris [LSARC/2009/062 FastTrack timeout 02/06/2009] In-reply-to: <200901310101.n0V1176S002742@sac.sfbay.sun.com> To: Sunanda.Menon@sun.com Cc: LSARC-ext@sun.com, webstack-discuss@opensolaris.org Message-id: <20090211035226.GA14086@sun.com> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT Content-disposition: inline X-PMX-Version: 5.4.1.325704 References: <200901310101.n0V1176S002742@sac.sfbay.sun.com> User-Agent: Mutt/1.5.11 Status: RO Content-Length: 263 > I am sponsoring this case for Sunanda Menon. It introduces MySQL 5.1 > (incl. dtrace probes) support. Timeout set to Feb.6. This case was approved in the ARC meeting today, marking accordingly. -- Jyri J. Virkki - jyri.virkki@sun.com - Sun Microsystems