Re: datetime issue on MySQL 4.x
Willy wrote:
Hello,
I have a MyISAM table:
CREATE TABLE `dlr` (
`msisdn` varchar(20) NOT NULL default '',
`source` varchar(20) NOT NULL default '',
`operator_id` varchar(20) NOT NULL default '',
`sms_message` longtext NOT NULL,
`smsc_id` varchar(20) NOT NULL default '',
`sms_id` varchar(250) NOT NULL default '',
`dlr_smsc` text NOT NULL,
`dlr` tinyint(4) NOT NULL default '0',
`date_time` datetime NOT NULL default '-00-00 00:00:00'
) TYPE=MyISAM
I have a case here, on July 7 I imported some data into the table with this
query:
INSERT INTO dlr (source, msisdn, operator_id, sms_message, smsc_id, sms_id, dlr_smsc, dlr, date_time)
VALUES
('366508', '1234', 4, '', 'IM33665', MD5(RAND()), 'RE:', '2', NOW()),
('366508', '1234', 4, 'id:0943381383 sub:001 dlvrd:000 submit date:0606280317
done date:0606290317 stat:EXPIRED err:999 text:, 'IM33665', MD5(RAND()),
'RE:id:0943381383 sub:001 dlvrd:000 submit date:0606280317 done date:0606290317
stat:EXPIRED err:999 text:', '2', '2006-06-28 03:17:00'),
('366508', '1234', 4, 'id:1226442088 sub:001 dlvrd:000 submit date:0606280317
done date:0606290317 stat:EXPIRED err:999 text:', 'IM33665', MD5(RAND()),
'RE:id:1226442088 sub:001 dlvrd:000 submit date:0606280317 done date:0606290317
stat:EXPIRED err:999 text:Silahkan tawar: XDA ', '2', '2006-06-28 03:17:00'),
('366508', '1234', 4, 'id:1861980498 sub:001 dlvrd:000 submit date:0606280317
done date:0606290317 stat:EXPIRED err:999 text:', 'IM33665', MD5(RAND()),
'RE:id:1861980498 sub:001 dlvrd:000 submit date:0606280317 done date:0606290317
stat:EXPIRED err:999 text:', '2', '2006-06-28 03:17:00'),
('366508', '1234', 4, '', 'IM33665', MD5(RAND()), 'RE:', '2', NOW())...
And when I try to fetch the data using PHP with this query:
SELECT operator_id, DATE_FORMAT(date_time,'%d-%m-%Y') AS tanggal, COUNT(*) AS
TOTAL FROM dlr WHERE 1=1 AND dlr = 8 AND MONTH(date_time) = MONTH(NOW()) GROUP
BY tanggal, operator_id ORDER BY date_time
The weird thing happened. Why does all the rows are shown or treated as July
7th data? If we see the imported data, there should be June 28, June
29.until July 7. Please help and many thanks for any reply.
Regards
Willy
Because you specified only for the month of July.
AND MONTH(date_time) = MONTH(NOW())
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
datetime issue on MySQL 4.x
Hello,
I have a MyISAM table:
CREATE TABLE `dlr` (
`msisdn` varchar(20) NOT NULL default '',
`source` varchar(20) NOT NULL default '',
`operator_id` varchar(20) NOT NULL default '',
`sms_message` longtext NOT NULL,
`smsc_id` varchar(20) NOT NULL default '',
`sms_id` varchar(250) NOT NULL default '',
`dlr_smsc` text NOT NULL,
`dlr` tinyint(4) NOT NULL default '0',
`date_time` datetime NOT NULL default '-00-00 00:00:00'
) TYPE=MyISAM
I have a case here, on July 7 I imported some data into the table with this
query:
INSERT INTO dlr (source, msisdn, operator_id, sms_message, smsc_id, sms_id,
dlr_smsc, dlr, date_time)
VALUES
('366508', '1234', 4, '', 'IM33665', MD5(RAND()), 'RE:', '2', NOW()),
('366508', '1234', 4, 'id:0943381383 sub:001 dlvrd:000 submit date:0606280317
done date:0606290317 stat:EXPIRED err:999 text:, 'IM33665', MD5(RAND()),
'RE:id:0943381383 sub:001 dlvrd:000 submit date:0606280317 done date:0606290317
stat:EXPIRED err:999 text:', '2', '2006-06-28 03:17:00'),
('366508', '1234', 4, 'id:1226442088 sub:001 dlvrd:000 submit date:0606280317
done date:0606290317 stat:EXPIRED err:999 text:', 'IM33665', MD5(RAND()),
'RE:id:1226442088 sub:001 dlvrd:000 submit date:0606280317 done date:0606290317
stat:EXPIRED err:999 text:Silahkan tawar: XDA ', '2', '2006-06-28 03:17:00'),
('366508', '1234', 4, 'id:1861980498 sub:001 dlvrd:000 submit date:0606280317
done date:0606290317 stat:EXPIRED err:999 text:', 'IM33665', MD5(RAND()),
'RE:id:1861980498 sub:001 dlvrd:000 submit date:0606280317 done date:0606290317
stat:EXPIRED err:999 text:', '2', '2006-06-28 03:17:00'),
('366508', '1234', 4, '', 'IM33665', MD5(RAND()), 'RE:', '2', NOW())...
And when I try to fetch the data using PHP with this query:
SELECT operator_id, DATE_FORMAT(date_time,'%d-%m-%Y') AS tanggal, COUNT(*) AS
TOTAL FROM dlr WHERE 1=1 AND dlr = 8 AND MONTH(date_time) = MONTH(NOW()) GROUP
BY tanggal, operator_id ORDER BY date_time
The weird thing happened. Why does all the rows are shown or treated as July
7th data? If we see the imported data, there should be June 28, June
29.until July 7. Please help and many thanks for any reply.
Regards
Willy
Re: datetime issue on MySQL 4.x (SOLVED)
Hello,
I have solved this problem, thanks.
Regards
Willy
- Original Message -
From: Willy
To: mysql@lists.mysql.com
Sent: Wednesday, July 12, 2006 8:55 AM
Subject: datetime issue on MySQL 4.x
Hello,
I have a MyISAM table:
CREATE TABLE `dlr` (
`msisdn` varchar(20) NOT NULL default '',
`source` varchar(20) NOT NULL default '',
`operator_id` varchar(20) NOT NULL default '',
`sms_message` longtext NOT NULL,
`smsc_id` varchar(20) NOT NULL default '',
`sms_id` varchar(250) NOT NULL default '',
`dlr_smsc` text NOT NULL,
`dlr` tinyint(4) NOT NULL default '0',
`date_time` datetime NOT NULL default '-00-00 00:00:00'
) TYPE=MyISAM
I have a case here, on July 7 I imported some data into the table with this
query:
INSERT INTO dlr (source, msisdn, operator_id, sms_message, smsc_id, sms_id,
dlr_smsc, dlr, date_time)
VALUES
('366508', '1234', 4, '', 'IM33665', MD5(RAND()), 'RE:', '2', NOW()),
('366508', '1234', 4, 'id:0943381383 sub:001 dlvrd:000 submit date:0606280317
done date:0606290317 stat:EXPIRED err:999 text:, 'IM33665', MD5(RAND()),
'RE:id:0943381383 sub:001 dlvrd:000 submit date:0606280317 done date:0606290317
stat:EXPIRED err:999 text:', '2', '2006-06-28 03:17:00'),
('366508', '1234', 4, 'id:1226442088 sub:001 dlvrd:000 submit date:0606280317
done date:0606290317 stat:EXPIRED err:999 text:', 'IM33665', MD5(RAND()),
'RE:id:1226442088 sub:001 dlvrd:000 submit date:0606280317 done date:0606290317
stat:EXPIRED err:999 text:Silahkan tawar: XDA ', '2', '2006-06-28 03:17:00'),
('366508', '1234', 4, 'id:1861980498 sub:001 dlvrd:000 submit date:0606280317
done date:0606290317 stat:EXPIRED err:999 text:', 'IM33665', MD5(RAND()),
'RE:id:1861980498 sub:001 dlvrd:000 submit date:0606280317 done date:0606290317
stat:EXPIRED err:999 text:', '2', '2006-06-28 03:17:00'),
('366508', '1234', 4, '', 'IM33665', MD5(RAND()), 'RE:', '2', NOW())...
And when I try to fetch the data using PHP with this query:
SELECT operator_id, DATE_FORMAT(date_time,'%d-%m-%Y') AS tanggal, COUNT(*) AS
TOTAL FROM dlr WHERE 1=1 AND dlr = 8 AND MONTH(date_time) = MONTH(NOW()) GROUP
BY tanggal, operator_id ORDER BY date_time
The weird thing happened. Why does all the rows are shown or treated as July
7th data? If we see the imported data, there should be June 28, June
29.until July 7. Please help and many thanks for any reply.
Regards
Willy
About union sql Mysql 4.x
Hi, I am trying to run an sql query such as below to list items=x randomly and then items != x randomly.. mysql (select * from tablea where item=1 order by rand()) union all (select * from tablea where item != 1 order by rand()); but the result is not as expected. rand() seems not to be working... What can be the problem? or what can be the difference between my will and the exact result of the query? Thanks.. Halil Demirezen System Support Engineer/ Sistem Destek Muhendisi Mobile Tel/Cep Tel: +90(543) 502 04 42 E-Mail/E-Posta: [EMAIL PROTECTED] ---
Re: About union sql Mysql 4.x
Hello. From http://dev.mysql.com/doc/refman/5.0/en/union.html: ORDER BY for individual SELECT statements within parentheses has an effect only when combined with LIMIT. Otherwise, the ORDER BY is optimized away. Therefore you're getting the same results, because ORDER BY doen't work for your query. HALIL DEMIREZEN wrote: Hi, I am trying to run an sql query such as below to list items=x randomly and then items != x randomly.. mysql (select * from tablea where item=1 order by rand()) union all (select * from tablea where item != 1 order by rand()); but the result is not as expected. rand() seems not to be working... What can be the problem? or what can be the difference between my will and the exact result of the query? Thanks.. Halil Demirezen System Support Engineer/ Sistem Destek Muhendisi Mobile Tel/Cep Tel: +90(543) 502 04 42 E-Mail/E-Posta: [EMAIL PROTECTED] --- -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: About union sql Mysql 4.x
What if i want to list all the records not limiting them to a constant? Halil Demirezen System Support Engineer/ Sistem Destek Muhendisi Mobile Tel/Cep Tel: +90(543) 502 04 42 E-Mail/E-Posta: [EMAIL PROTECTED] --- Gleb Paharenko [EMAIL PROTECTED] 05.12.2005 12:19 To mysql@lists.mysql.com cc Subject Re: About union sql Mysql 4.x Hello. From http://dev.mysql.com/doc/refman/5.0/en/union.html: ORDER BY for individual SELECT statements within parentheses has an effect only when combined with LIMIT. Otherwise, the ORDER BY is optimized away. Therefore you're getting the same results, because ORDER BY doen't work for your query. HALIL DEMIREZEN wrote: Hi, I am trying to run an sql query such as below to list items=x randomly and then items != x randomly.. mysql (select * from tablea where item=1 order by rand()) union all (select * from tablea where item != 1 order by rand()); but the result is not as expected. rand() seems not to be working... What can be the problem? or what can be the difference between my will and the exact result of the query? Thanks.. Halil Demirezen System Support Engineer/ Sistem Destek Muhendisi Mobile Tel/Cep Tel: +90(543) 502 04 42 E-Mail/E-Posta: [EMAIL PROTECTED] --- -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: About union sql Mysql 4.x
HALIL DEMIREZEN wrote: Hi, I am trying to run an sql query such as below to list items=x randomly and then items != x randomly.. mysql (select * from tablea where item=1 order by rand()) union all (select * from tablea where item != 1 order by rand()); but the result is not as expected. rand() seems not to be working... What can be the problem? or what can be the difference between my will and the exact result of the query? Gleb Paharenko wrote: Hello. From http://dev.mysql.com/doc/refman/5.0/en/union.html: ORDER BY for individual SELECT statements within parentheses has an effect only when combined with LIMIT. Otherwise, the ORDER BY is optimized away. Therefore you're getting the same results, because ORDER BY doen't work for your query. HALIL DEMIREZEN wrote: What if i want to list all the records not limiting them to a constant? How about SELECT * FROM tablea ORDER BY (item != 1), RAND(); Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: About union sql Mysql 4.x
Michael, Thank you and all for effort to help.. I solved the problem by giving high limit numbers such as; (select * from tablea where item=1 order by rand() limit 0, 1) union all (select * from tablea where item != 1 order by rand() limit 0, 1); Halil Demirezen System Support Engineer/ Sistem Destek Muhendisi Mobile Tel/Cep Tel: +90(543) 502 04 42 E-Mail/E-Posta: [EMAIL PROTECTED] --- Michael Stassen [EMAIL PROTECTED] 05.12.2005 15:46 To HALIL DEMIREZEN [EMAIL PROTECTED] cc Gleb Paharenko [EMAIL PROTECTED], mysql@lists.mysql.com Subject Re: About union sql Mysql 4.x HALIL DEMIREZEN wrote: Hi, I am trying to run an sql query such as below to list items=x randomly and then items != x randomly.. mysql (select * from tablea where item=1 order by rand()) union all (select * from tablea where item != 1 order by rand()); but the result is not as expected. rand() seems not to be working... What can be the problem? or what can be the difference between my will and the exact result of the query? Gleb Paharenko wrote: Hello. From http://dev.mysql.com/doc/refman/5.0/en/union.html: ORDER BY for individual SELECT statements within parentheses has an effect only when combined with LIMIT. Otherwise, the ORDER BY is optimized away. Therefore you're getting the same results, because ORDER BY doen't work for your query. HALIL DEMIREZEN wrote: What if i want to list all the records not limiting them to a constant? How about SELECT * FROM tablea ORDER BY (item != 1), RAND(); Michael
Re: About union sql Mysql 4.x
Hello. If you want all records with item=1 to be at the beginning and sorted in a random order you can use this query: select * from tablea order by if(item=1,0,1), rand(); HALIL DEMIREZEN wrote: What if i want to list all the records not limiting them to a constant? Halil Demirezen System Support Engineer/ Sistem Destek Muhendisi Mobile Tel/Cep Tel: +90(543) 502 04 42 E-Mail/E-Posta: [EMAIL PROTECTED] --- Gleb Paharenko [EMAIL PROTECTED] 05.12.2005 12:19 To mysql@lists.mysql.com cc Subject Re: About union sql Mysql 4.x Hello. From http://dev.mysql.com/doc/refman/5.0/en/union.html: ORDER BY for individual SELECT statements within parentheses has an effect only when combined with LIMIT. Otherwise, the ORDER BY is optimized away. Therefore you're getting the same results, because ORDER BY doen't work for your query. HALIL DEMIREZEN wrote: Hi, I am trying to run an sql query such as below to list items=x randomly and then items != x randomly.. mysql (select * from tablea where item=1 order by rand()) union all (select * from tablea where item != 1 order by rand()); but the result is not as expected. rand() seems not to be working... What can be the problem? or what can be the difference between my will and the exact result of the query? Thanks.. Halil Demirezen System Support Engineer/ Sistem Destek Muhendisi Mobile Tel/Cep Tel: +90(543) 502 04 42 E-Mail/E-Posta: [EMAIL PROTECTED] --- -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: About union sql Mysql 4.x
HALIL DEMIREZEN wrote: Michael, Thank you and all for effort to help.. I solved the problem by giving high limit numbers such as; (select * from tablea where item=1 order by rand() limit 0, 1) union all (select * from tablea where item != 1 order by rand() limit 0, 1); I think this is not so much a solution as a temporary work-around. It will stop working correctly, without giving any errors, as soon as your table gets to a certain size. Perhaps that will never happen in this particular case, but I think this sort of thing is a bad idea, in general. Your desire is to sort the rows of tablea. You want all the rows with item = 1 first, then all the rest. Within each group (item = 1, item != 1), you want the rows in random order. You should see that this is simply a two step ordering. Instead of trying to fake that with unioned queries, you should solve it directly in your ORDER BY clause. Both the query Gleb sent, SELECT * FROM tablea ORDER BY IF(item=1,0,1), RAND(); and the one I sent, SELECT * FROM tablea ORDER BY (item != 1), RAND(); do just that. Both will provide the results you asked for, and neither will break when the table reaches some particular size. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
compat RPM for MySQL 4.x on RHEL3 [PRESS RELEASE]
PD Inc. http://www.pdinc.us 156 Briarvista Way North East Atlanta, Georgia 30329-3615 +1(443)269-1555 EIN:52-2351863 August 1, 2005 Document#20050801P00 References#--- PRESS RELEASE: For immediate release. Contact:Ning Li [EMAIL PROTECTED] (443) 921-0381 PD Inc. has open-sourced their compatibility RPM that enables system administrators to install MySQL 4.x on Red Hat Enterprise Linux (RHEL3) Operating System with minimal impact. Baltimore -- August 1, 2005 -- PD Inc. today announced the release of their MySQL-shared compat RPMs for RHEL3. With these compatibility RPMs a system administrator can now upgrade to MySQL 4.x whilst keeping legacy libmysqlclient.so.10 and libmysqlclient.so.12 client libraries as provided by the RPMs and maintaining maximum Red Hat support compliance. Red Hat Enterprise Linux (RHEL) Operating System is one of the most commonly used open-source operating systems. More than 1/3 of the server market uses RHEL, including all Linux servers from IBM, and Dell. There are current limitations on RHEL support, limiting system administrators from reasonable deviations in application selection on the system. MySQL greater than 3.23 is not supported by Red Hat, Inc. on RHEL3. Normally to upgrade to MySQL 4.x many other applications on the system need to be upgraded and/or recompiled including Apache, PHP, and Perl. In doing so, Red Hat, Inc. no longer will support these system modifications. To solve this problem, PD Inc. has now released two compatibility RPM solutions. One for MySQL 4.0 and the other for MySQL 4.1. This open-source software allows system administrator to upgrade MySQL 4.x without upgrading other applications. With the a compat RPM, an IT department can minimize the non compliant applications installed, reduce the workload on staff, and ensure a smoother transition. These RPMs can be downloaded from: http://public.pdinc.us/rpms/mysql About Red Hat, Inc. Red Hat, the world's leading open source and Linux provider, is headquartered in Raleigh, NC with satellite offices spanning the globe. Red Hat is leading Linux and open source solutions into the mainstream by making high quality, low cost technology accessible. Red Hat provides operating system software along with middleware, applications and management solutions. Red Hat also offers support, training and consulting services to its customers worldwide and through top-tier partnerships. Red Hat's open source strategy offers customers a long term plan for building infrastructures that are based on and leverage open source technologies with focus on security and ease of management. Learn more: http://www.redhat.com About MySQL AB MySQL AB develops and supports a family of high performance, affordable database products -- including MySQL Network, a comprehensive set of certified software and premium support services. The company's flagship product is MySQL, the world's most popular open source database, with more than six million active installations. Many of the world's largest organizations, including Yahoo!, Sabre Holdings, The Associated Press, Suzuki and NASA are realizing significant cost savings by using MySQL to power high-volume Web sites, business-critical enterprise applications and packaged software. http://www.mysql.com About PD Inc. PD Inc is a business solutions provider. The company provides expert solutions for tailored consulting projects on an enterprise-wide scale. PD Inc. uses an applied think tank structure to integrate business solutions, create a clear well-defined architecture, and target horizontal markets for it's customers. Because each of the company's consultants have strong backgrounds in their specific field, PD Inc. is able to focus on vertical markets as well. PD Inc provides solutions in general engineering, electrical computer engineering, e-commerce, software development, business method analysis, and procurement. It's customer base draws from federal and municipal governments, IT firms, biotech corporations, and Fortune 500 companies. For more information see http://www.pdinc.us ### -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Ning Li PD Inc. http://www.pdinc.us - - Marketing Trade Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com
Mysql 4.x Error
Hi, Im using : mysqlclient10-3.23.58-6 ,mysql-server-4.1.11-2,mysql-4.1.11-2 On fedora 3. when i run the following command its gives Error: [EMAIL PROTECTED] etc]$ /etc/init.d/mysqld start touch: cannot touch `/var/log/mysqld.log': Permission denied chmod: changing permissions of `/var/log/mysqld.log': Operation not permitted Initializing MySQL database: mkdir: cannot create directory `/var/lib/mysql/mysql': Permission denied chmod: cannot access `/var/lib/mysql/mysql': No such file or directory mkdir: cannot create directory `/var/lib/mysql/test': Permission denied chmod: cannot access `/var/lib/mysql/test': No such file or directory Installing all prepared tables /usr/libexec/mysqld: error while loading shared libraries: libssl.so.5: cannot open shared object file: No such file or directory Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. You can also try to start the mysqld daemon with: /usr/libexec/mysqld --skip-grant You can use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/bin/mysqlbug script! [FAILED] why ? the above error is comming..? When i try to remove libssl.so.4 from my system and install libssl.so.5 in the system ,the system does not start.As libssl.so.4 is required. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql 4.x Error
Hello. You have several problems and they're should be resolved step by step. First fix the problems with permissions. Usually they're solved by changing the owner of mysql database to mysql user. Check what's wrong with /var/log/mysqld.log. It might be necessery to create it manually. Why are you removing libssl.so.4. I think these libraries could exists both in the system. plaza c [EMAIL PROTECTED] wrote: Hi, Im using : mysqlclient10-3.23.58-6 ,mysql-server-4.1.11-2,mysql-4.1.11-2 On fedora 3. when i run the following command its gives Error: [EMAIL PROTECTED] etc]$ /etc/init.d/mysqld start touch: cannot touch `/var/log/mysqld.log': Permission denied chmod: changing permissions of `/var/log/mysqld.log': Operation not permitt= ed Initializing MySQL database: mkdir: cannot create directory `/var/lib/mysql/mysql': Permission denied chmod: cannot access `/var/lib/mysql/mysql': No such file or directory mkdir: cannot create directory `/var/lib/mysql/test': Permission denied chmod: cannot access `/var/lib/mysql/test': No such file or directory Installing all prepared tables /usr/libexec/mysqld: error while loading shared libraries: libssl.so.5: cannot open shared object file: No such file or directory Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. You can also try to start the mysqld daemon with: /usr/libexec/mysqld --skip-grant You can use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db= ', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/bin/mysqlbug script! [FAILED] ---= - why ? the above error is comming..? When i try to remove libssl.so.4 from my system and install=20 libssl.so.5 in the system ,the system does not start.As libssl.so.4 is required. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.x performance tuning
Hi all I have a MySQL installation running on a Pentium3 based system with 2GB RAM... The database primarily uses MyISAM tables with 60% SELECT statements. The database is used as a backend for a PHP web application. Do the following values make any sense? set-variable= key_buffer=200M set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=12 set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=10M set-variable= join_buffer_size=8M set-variable= record_buffer=5M set-variable= long_query_time=4 set-variable= query_cache_limit=2M set-variable= query_cache_size=50M set-variable= query_cache_type=2 set-variable= max_connections=200 Is there a way to see if the key buffer size was ever reached? The SHOW STATUS says the following about the Keys: Key blocks used 125400 Key read requests 3518220013 Key reads 94807 Key write requests 17079943 Key writes 8323850 It's interesting to see, that SHOW STATUS shows a lot of generated temporary tables: Created tmp disk tables 28814 Created tmp tables 716581 Created tmp files 506757 Are these values too high? Thanks a lot for your help reto
MySQL 4.x: Access denied for users when password is set...
Hi gang as subject says ... I've got a pretty weird situation. For all users I create in the 'user' table in 'mysql' DB, if I set a password, that user becomes unable to access any DBs ... it doesn't matter if I set the pw as ASCII or password, still won't allow access... I've tried making new users and copying all settings of the default root user (which I've not set a PW for cuz I loose access to the main DB when I do that) ... nomatter what, all users can access the DBs fine when no pw is set, but if a pw is set, MySQL reports access denied... and yes, it actually also does this when using the MySQL command line tools which makes it even weirder... This is a single-user test setup for development use only ... I run MySQL 4.0.14b on Windows XP Pro SP1 ... with Apache 2.0.48 and PHP 4.2.3 on CGI. Doesn't matter what kind of DB access I try; the MySQL binaries, PHPMyAdmin, custom made PHP/MySQL apps, or PHPBB ... if I set a PW for a user, that user becomes unable of accessing the DBs ... I've tried opening up the firewall for the MySQL server modules to access the Internet, but does not make a change ... hostname is set to 'localhost' in the mysql table (since all it has to work with are connections from the same windows session anyways)... is there any other place in the mysql table that I have to add/change stuff than 'user' to get this to work??? so lost here ... any help appreciated (and as far as I can tell, I've done every step in all MySQL install guides I could find ... atm I'm running on a restored version of the default mysql DB with the % users set ... since the firewall locks out remote access, I didn't think it's a big deal)... n00b at SQL TIA Rene -- Rene Brehmer aka Metalbunny http://metalbunny.net/ References, tools, and other useful stuff... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Anyone using MySQL 4.x on Apple's G5?
On Wed, Oct 15, 2003 at 06:35:03PM -0400, Gabriel Ricard wrote: On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote: I'd be interested to know if you can get a test running that uses either a key_buffer or an innodb_buffer_pool in the 3.5GB range. Interestingly enough, I can't seem to get MySQL to use more than 2GB of RAM. I get errors like this: *** malloc: vm_allocate(size=2042925056) failed with 3 *** malloc[489]: error: Can't allocate region Hmm. That's not promising. I wrote a small C program to test malloc() and see just how much I could allocate, and I was able to get up to 3.5GB before being cut off by the OS, which leads me to believe that I should be able to use that much RAM for MySQL. Yes. I wonder why you got cut off at 3.5GB. I'd have expected OS X on 64bit hardware not to have the weird limitations that, say, FreeBSD or Linux with kernel reserved memory. Something is wonky here... Thanks for the info. I'd love to hear if you're successful getting MySQL to use more than 2GB. I'm gonna hunt around a bit more to see what others may know. Thanks, Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 32 days, processed 1,219,926,177 queries (431/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Anyone using MySQL 4.x on Apple's G5?
If memory serves, adjustments to the OS need to be made to take advantage of the 64-bit memory addressing. I know some changes have been made to OS X to run on a 64-bit chip, but I'm not certain they've made enough modifications to take advantage of the memory addressing. I'd be interested to see how this works on Panther. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] To: Gabriel Ricard I wrote a small C program to test malloc() and see just how much I could allocate, and I was able to get up to 3.5GB before being cut off by the OS, which leads me to believe that I should be able to use that much RAM for MySQL. Yes. I wonder why you got cut off at 3.5GB. I'd have expected OS X on 64bit hardware not to have the weird limitations that, say, FreeBSD or Linux with kernel reserved memory. Something is wonky here... Thanks for the info. I'd love to hear if you're successful getting MySQL to use more than 2GB. I'm gonna hunt around a bit more to see what others may know. Thanks, Jeremy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Anyone using MySQL 4.x on Apple's G5?
On Thursday, October 16, 2003, at 01:36 PM, Jeremy Zawodny wrote: On Wed, Oct 15, 2003 at 06:35:03PM -0400, Gabriel Ricard wrote: On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote: I'd be interested to know if you can get a test running that uses either a key_buffer or an innodb_buffer_pool in the 3.5GB range. Interestingly enough, I can't seem to get MySQL to use more than 2GB of RAM. I get errors like this: *** malloc: vm_allocate(size=2042925056) failed with 3 *** malloc[489]: error: Can't allocate region Hmm. That's not promising. I wrote a small C program to test malloc() and see just how much I could allocate, and I was able to get up to 3.5GB before being cut off by the OS, which leads me to believe that I should be able to use that much RAM for MySQL. Yes. I wonder why you got cut off at 3.5GB. I'd have expected OS X on 64bit hardware not to have the weird limitations that, say, FreeBSD or Linux with kernel reserved memory. Something is wonky here... Thanks for the info. I'd love to hear if you're successful getting MySQL to use more than 2GB. I'm gonna hunt around a bit more to see what others may know. Thanks, Success! Sort of... I installed the dev seed for Panther 7B85 and tested that... and now it loves RAM. I got it up to about 3GB with the following config: query_cache_size=1024M bulk_insert_buffer_size=256M tmp_table_size=128M sort_buffer=8M read_rnd_buffer_size=8M key_buffer=768M record_buffer=32M myisam_sort_buffer_size=512M innodb_buffer_pool_size=1024M innodb_additional_mem_pool_size=32M However, for some reason, when I swapped the values key_buffer and query_cache_size to try and give key_buffer 1GB, it failed. I swapped the values back and it worked fine... odd. - Gabriel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Anyone using MySQL 4.x on Apple's G5?
If so, how is it working out? Are you taking advantage of the 64bit memory space? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 31 days, processed 1,151,820,403 queries (426/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Anyone using MySQL 4.x on Apple's G5?
I am currently testing this on a new dual 2GHz G5 with 4GB of RAM. Seems pretty nice so far. I've loaded up a copy of our production database (4GB of data for real estate web sites) and moderate property search queries of ours run much faster than on our dual G4 MDD PowerMac. I guess we're really not taking advantage of the 64 bit memory space as we've only got 4GB of RAM in it currently, heh. I've been running the sql-bench/run-all-tests benchmark and trying to figure out why insert_key is taking 2440 wall clock seconds. Everything else is damn zippy. Anything specific you'd like to see numbers for? This box isn't going to be in production use for a few weeks anyways. - Gabriel On Wednesday, October 15, 2003, at 02:13 AM, Jeremy Zawodny wrote: If so, how is it working out? Are you taking advantage of the 64bit memory space? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 31 days, processed 1,151,820,403 queries (426/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Anyone using MySQL 4.x on Apple's G5?
Wow, new dual processor G5... behaviordrool/behavior How are the bulk operations performing? -Original Message- From: Gabriel Ricard [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 11:05 AM To: [EMAIL PROTECTED] Subject: Re: Anyone using MySQL 4.x on Apple's G5? I am currently testing this on a new dual 2GHz G5 with 4GB of RAM. Seems pretty nice so far. I've loaded up a copy of our production database (4GB of data for real estate web sites) and moderate property search queries of ours run much faster than on our dual G4 MDD PowerMac. I guess we're really not taking advantage of the 64 bit memory space as we've only got 4GB of RAM in it currently, heh. I've been running the sql-bench/run-all-tests benchmark and trying to figure out why insert_key is taking 2440 wall clock seconds. Everything else is damn zippy. Anything specific you'd like to see numbers for? This box isn't going to be in production use for a few weeks anyways. - Gabriel On Wednesday, October 15, 2003, at 02:13 AM, Jeremy Zawodny wrote: If so, how is it working out? Are you taking advantage of the 64bit memory space? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 31 days, processed 1,151,820,403 queries (426/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Anyone using MySQL 4.x on Apple's G5?
I just loaded (LOAD DATA INFILE ...) the main property table (MyISAM type) for our database, which contains about 412,000 records. It took 167.79 seconds to load the data at about 2,456 records per second. The table has 124 fields and 16 single-column keys. The records are around 900B - 1KB each on average (of actual data) and the actual storage space per record is 1,487B (variable length records). bulk_insert_buffer_size = 256MB myisam_sort_buffer_size = 512MB I haven't tried out InnoDB tables yet. I will be soon. - Gabriel On Wednesday, October 15, 2003, at 11:23 AM, Fortuno, Adam wrote: Wow, new dual processor G5... behaviordrool/behavior How are the bulk operations performing? -Original Message- From: Gabriel Ricard [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 11:05 AM To: [EMAIL PROTECTED] Subject: Re: Anyone using MySQL 4.x on Apple's G5? I am currently testing this on a new dual 2GHz G5 with 4GB of RAM. Seems pretty nice so far. I've loaded up a copy of our production database (4GB of data for real estate web sites) and moderate property search queries of ours run much faster than on our dual G4 MDD PowerMac. I guess we're really not taking advantage of the 64 bit memory space as we've only got 4GB of RAM in it currently, heh. I've been running the sql-bench/run-all-tests benchmark and trying to figure out why insert_key is taking 2440 wall clock seconds. Everything else is damn zippy. Anything specific you'd like to see numbers for? This box isn't going to be in production use for a few weeks anyways. - Gabriel On Wednesday, October 15, 2003, at 02:13 AM, Jeremy Zawodny wrote: If so, how is it working out? Are you taking advantage of the 64bit memory space? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 31 days, processed 1,151,820,403 queries (426/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Anyone using MySQL 4.x on Apple's G5?
Wouldn't code need to be added for mySQL to take advantage of memory mapping in a 64 bit system? I was under the impression that mysql in its current form has specific code to emulate the behavior thus the problem of memory mapping at high levels. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] --Sent: Tuesday, October 14, 2003 11:13 PM --To: [EMAIL PROTECTED] --Subject: Anyone using MySQL 4.x on Apple's G5? -- --If so, how is it working out? Are you taking advantage of the --64bit memory space? -- --Jeremy --Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! --[EMAIL PROTECTED] | http://jeremy.zawodny.com/ -- --MySQL 4.0.15-Yahoo-SMP: up 31 days, processed 1,151,820,403 queries --(426/sec. avg) -- --MySQL General Mailing List --For list archives: http://lists.mysql.com/mysql --To unsubscribe: --http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Anyone using MySQL 4.x on Apple's G5?
On Wed, Oct 15, 2003 at 11:02:12AM -0700, Dathan Vance Pattishall wrote: Wouldn't code need to be added for mySQL to take advantage of memory mapping in a 64 bit system? I was under the impression that mysql in its current form has specific code to emulate the behavior thus the problem of memory mapping at high levels. I doubt it. MySQL already runs on several 64-bit platforms, including Sparc Solaris and AMD's Opteron. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 31 days, processed 1,183,622,059 queries (430/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Anyone using MySQL 4.x on Apple's G5?
On Wed, Oct 15, 2003 at 11:04:47AM -0400, Gabriel Ricard wrote: I am currently testing this on a new dual 2GHz G5 with 4GB of RAM. Seems pretty nice so far. I've loaded up a copy of our production database (4GB of data for real estate web sites) and moderate property search queries of ours run much faster than on our dual G4 MDD PowerMac. I guess we're really not taking advantage of the 64 bit memory space as we've only got 4GB of RAM in it currently, heh. What sort of disks are you using? IDE? SCSI? I've been running the sql-bench/run-all-tests benchmark and trying to figure out why insert_key is taking 2440 wall clock seconds. Everything else is damn zippy. Is it CPU or I/O bound at that point? Anything specific you'd like to see numbers for? This box isn't going to be in production use for a few weeks anyways. I'd be interested to know if you can get a test running that uses either a key_buffer or an innodb_buffer_pool in the 3.5GB range. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 31 days, processed 1,183,880,635 queries (431/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Anyone using MySQL 4.x on Apple's G5?
On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote: I'd be interested to know if you can get a test running that uses either a key_buffer or an innodb_buffer_pool in the 3.5GB range. Interestingly enough, I can't seem to get MySQL to use more than 2GB of RAM. I get errors like this: *** malloc: vm_allocate(size=2042925056) failed with 3 *** malloc[489]: error: Can't allocate region I wrote a small C program to test malloc() and see just how much I could allocate, and I was able to get up to 3.5GB before being cut off by the OS, which leads me to believe that I should be able to use that much RAM for MySQL. I just can't seem to get it to do so. I even tuned down all of the other configuration options so that MySQL was only using about 30MB of RAM with a key_buffer of 0MB. Then I bumped up the key_buffer to 3.5GB: no go, 3GB: no go, 2.75GB: no go, 2.5GB: nope, 2250MB: yes! 'top' reports mysql to be using 255MB at that level. So, yeah, I can run some benchmarks on that... But I don't see how useful they'd be since all of the other parameters are tuned way down. (none are over 8MB) InnoDB benchmarks may be useful since it uses the buffer to cache records as well as keys. - Gabriel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Anyone using MySQL 4.x on Apple's G5?
Gabriel Ricard wrote: On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote: I'd be interested to know if you can get a test running that uses either a key_buffer or an innodb_buffer_pool in the 3.5GB range. Interestingly enough, I can't seem to get MySQL to use more than 2GB of RAM. I get errors like this: *** malloc: vm_allocate(size=2042925056) failed with 3 *** malloc[489]: error: Can't allocate region I wrote a small C program to test malloc() and see just how much I could allocate, and I was able to get up to 3.5GB before being cut off by the OS, which leads me to believe that I should be able to use that much RAM for MySQL. I just can't seem to get it to do so. I even tuned down all of the other configuration options so that MySQL was only using about 30MB of RAM with a key_buffer of 0MB. Then I bumped up the key_buffer to 3.5GB: no go, 3GB: no go, 2.75GB: no go, 2.5GB: nope, 2250MB: yes! 'top' reports mysql to be using 255MB at that level. So, yeah, I can run some benchmarks on that... But I don't see how useful they'd be since all of the other parameters are tuned way down. (none are over 8MB) InnoDB benchmarks may be useful since it uses the buffer to cache records as well as keys. Have you tried setting innodb_buffer_pool_size to a number over 2GB? Thanks, Ware Adams - Gabriel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql 4.x week function fails
Hi all,
I think there is a bug in mysql 4:
select week(2003-08-15) from po.orders limit 1;
produces: 32
after:
set session default_week_format=3;
it produces: 33 (which is correct in the Netherlands)
The documentation states:
set global default_week_format=3; (As root!)
This command should set the default_week_format. This command fails:
mysql set global default_week_format=3;
Query OK, 0 rows affected (0.00 sec)
mysql select week('2003-08-14');
++
| week('2003-08-14') |
++
| 32 |
++
1 row in set (0.00 sec)
This result is incorrect. It should be 33.
If I use:
mysql set session default_week_format=3;
Query OK, 0 rows affected (0.00 sec)
mysql select week('2003-08-14');
++
| week('2003-08-14') |
++
| 33 |
++
1 row in set (0.00 sec)
This is result is correct...
I use mysql 4.0.14. I also did the same test on mysql 4.1 alpha, which has
the same results.
Can somebody help?
Thanks,
Harm de Laat
Informatiefabriek
The Netherlands
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 4.x week function fails
[EMAIL PROTECTED] wrote:
I think there is a bug in mysql 4:
select week(2003-08-15) from po.orders limit 1;
produces: 32
after:
set session default_week_format=3;
it produces: 33 (which is correct in the Netherlands)
The documentation states:
set global default_week_format=3; (As root!)
This command should set the default_week_format. This command fails:
mysql set global default_week_format=3;
Query OK, 0 rows affected (0.00 sec)
mysql select week('2003-08-14');
++
| week('2003-08-14') |
++
| 32 |
++
1 row in set (0.00 sec)
This result is incorrect. It should be 33.
If I use:
mysql set session default_week_format=3;
Query OK, 0 rows affected (0.00 sec)
mysql select week('2003-08-14');
++
| week('2003-08-14') |
++
| 33 |
++
1 row in set (0.00 sec)
This is result is correct...
I use mysql 4.0.14. I also did the same test on mysql 4.1 alpha, which has
the same results.
1. You can set up default_week_format only sice 4.1
2. SET GLOBAL default_week_format=3 does not affect the session variable of the
current connection. Open new connection after SET GLOBAL and your SELECT query should
give you correct result.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Import Database from MySQL3.x to MySQL 4.x
Hello! I want to import a MySQL 3.x Databse to my new shiny MySQL4.x. I did a backup with /usr/local/mysql-standard-4.0.14-pc-linux-i686/bin/mysqldump -u root -p --opt -A mysql_lamp_backup.`date '+%Y.%m.%d'`.sql And i tried to import it to MySQL4.x with: /usr/local/mysql/bin/mysql -u root -p mysqlbak The error: ERROR 1064 at line 598: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-en' at line 1 This is teh line 598: CREATE DATABASE /*!32312 IF NOT EXISTS*/ blabla-en; IF i change the name to blabla_en, it works fine. Another issue: ERROR 1064 at line 830: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '! ,'poll','Questions','','',10,'r',11.61,11,10,0011,'','A'), ANd this 830 line ist just far to long to post it :) So do i have a general problem or what did i do wrong so far? Cheers, Mario -- COMPUTERBILD 15/03: Premium-e-mail-Dienste im Test -- 1. GMX TopMail - Platz 1 und Testsieger! 2. GMX ProMail - Platz 2 und Preis-Qualitätssieger! 3. Arcor - 4. web.de - 5. T-Online - 6. freenet.de - 7. daybyday - 8. e-Post -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Import Database from MySQL3.x to MySQL 4.x
Mario Ohnewald [EMAIL PROTECTED] wrote: I want to import a MySQL 3.x Databse to my new shiny MySQL4.x. I did a backup with /usr/local/mysql-standard-4.0.14-pc-linux-i686/bin/mysqldump -u root -p --opt -A mysql_lamp_backup.`date '+%Y.%m.%d'`.sql And i tried to import it to MySQL4.x with: /usr/local/mysql/bin/mysql -u root -p mysqlbak The error: ERROR 1064 at line 598: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-en' at line 1 This is teh line 598: CREATE DATABASE /*!32312 IF NOT EXISTS*/ blabla-en; IF i change the name to blabla_en, it works fine. Use -Q option of the mysqldump. Another issue: ERROR 1064 at line 830: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '! ,'poll','Questions','','',10,'r',11.61,11,10,0011,'','A'), ANd this 830 line ist just far to long to post it :) So do i have a general problem or what did i do wrong so far? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
question about mysql-4.x escaping with USE_MB
quoted from mysql-4.1/libmysql/libmysql.c
=
static ulong
mysql_sub_escape_string(CHARSET_INFO *charset_info, char *to,
const char *from, ulong length)
{
const char *to_start=to;
const char *end;
#ifdef USE_MB
my_bool use_mb_flag=use_mb(charset_info);
#endif
for (end=from+length; from != end ; from++)
{
#ifdef USE_MB
int l;
if (use_mb_flag (l = my_ismbchar(charset_info, from, end)))
{
while (l--)
*to++ = *from++;
from--;
continue;
}
#endif
=
notice that USE_MB(it exists in older version, all mysql 4.x)
it use connection CHARSET to escape string differently
but it is said mysql-4.1 can have different charset on
column,table,database
how can the client know which table it's querying on?
i guess this is why it failed to insert blob data to GBK mysql servers.
so do anyone use multibyte mysql server?
do mysql developers tested insert blob data under UTF-8 Mysql server?
_
MSN Messenger: http://messenger.msn.com/cn
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How stable is MySQL 4.x vs 3.23.x?
I have been using the MySql 4.x MAX with absolutely NO problems. It's being used on heavily operated servers, and I upgraded to 4.x for it's incredible index speeds and it's VERY reliable to me. In fact, in our local benchmarks it's kicking the living crap out of Oracle on sql, query. :) ~Kelly W. Black -Original Message- From: Jaime Teng [mailto:jaime;qinet.net] Sent: Monday, November 11, 2002 7:11 PM To: [EMAIL PROTECTED] Subject: How stable is MySQL 4.x vs 3.23.x? Hi, How stable is the new MySQL 4.x? I've read some really nice and powerful stuffs with MySQL 4. x and surely like to use them. Is this still in the 'use at your own risk' stage? or is it stable enough for use already? regards, Jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How stable is MySQL 4.x vs 3.23.x?
Hi, How stable is the new MySQL 4.x? I've read some really nice and powerful stuffs with MySQL 4. x and surely like to use them. Is this still in the 'use at your own risk' stage? or is it stable enough for use already? regards, Jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How stable is MySQL 4.x vs 3.23.x?
On Tue, Nov 12, 2002 at 11:11:26AM +0800, Jaime Teng wrote: Hi, How stable is the new MySQL 4.x? I've read some really nice and powerful stuffs with MySQL 4. x and surely like to use them. Is this still in the 'use at your own risk' stage? or is it stable enough for use already? We've been running it on all our slaves quite happily for months now. Just haven't had the chance to take down the master and upgrade it. Maybe when it hits 4 billion queries. :-) Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 97 days, processed 2,051,280,064 queries (242/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql 4.x for debian?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 06 November 2002 20:48, Jeremy Zawodny wrote: Actually, you should work with the current mysql maintainer for Debian. I'm sure he'd be thrilled to have official help from MySQL AB. Of course I would not mind helping and assisting the Debian folks as well as all other people maintaining packages or distributions of MySQL in some way. For this purpose I've now requested the creation of a new mailing list [EMAIL PROTECTED] However, we of course would like to be able to provide DEBs on our website for downloading - I have to get in contact with Christian Hammers about this. But this is a task after 4.0.5 is done and released... Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE9zDJBSVDhKrJykfIRArC5AJ0eBzj8HjTmPNF59pcVmYl8Eocb4QCePMLU 8WVhOM1mPji3fEORvfUgIKs= =b8de -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql 4.x for debian?
Hello, what is the status of MySQL 4.x for debian? Does MySQL AB plan to release deb paketes or will MySQL AB support or encourage the debian pakete maintainers? Best regards Gunnar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql 4.x for debian?
On Wed, 6 Nov 2002, von Boehn, Gunnar wrote: Hello, what is the status of MySQL 4.x for debian? Does MySQL AB plan to release deb paketes or will MySQL AB support or encourage the debian pakete maintainers? I think MySQL policy is to support generic packaging formats applicable to all platforms. Proprietary packaging formats such as those used by Debian, Red Hat, etc are not directly supported but contributed by others. regards, Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql 4.x for debian?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 06 November 2002 11:20, andy thomas wrote: Does MySQL AB plan to release deb paketes or will MySQL AB support or encourage the debian pakete maintainers? I think MySQL policy is to support generic packaging formats applicable to all platforms. Proprietary packaging formats such as those used by Debian, Red Hat, etc are not directly supported but contributed by others. Actually, this is not a case - it's more a question of manpower and knowledge :) Yes, we plan to add more package formats apart from tarballs in the future, it's on my TODO. Debian packages are quite high on the priority list there, but I don't know, when I will be able to start with it - I have a lot of RPM background, but I need to read up on how to build DEBs. Do I need to have Debian installed? Or is it sufficient to install the required tools on another distribution? Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE9yPJzSVDhKrJykfIRAkXQAJkBqudCfsQAymAZ1+JFY+QGIh54rwCeIvHW LM5S9IQwqVfnxLMsS7BaHl0= =2Hwz -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql 4.x for debian?
On Wed, Nov 06, 2002 at 11:44:03AM +0100, Lenz Grimmer wrote: Yes, we plan to add more package formats apart from tarballs in the future, it's on my TODO. Debian packages are quite high on the priority list there, but I don't know, when I will be able to start with it - I have a lot of RPM background, but I need to read up on how to build DEBs. Do I need to have Debian installed? Or is it sufficient to install the required tools on another distribution? Actually, you should work with the current mysql maintainer for Debian. I'm sure he'd be thrilled to have official help from MySQL AB. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 92 days, processed 1,930,683,020 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL-4.x GBK Problem with Binary Data
re-posting multibyte problem. does anyone have problem with binary data in MySQL-4.x using GBK charset or any other multibyte charset? inserting/updating/replacing the full description is in mysql mailing list archive, sent by me will not repost full desc until someone have or care this problem thx _ ÓëÁª»úµÄÅóÓѽøÐн»Á÷£¬ÇëʹÓà MSN Messenger: http://messenger.microsoft.com/cn/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-4.x GBK Problem with Binary Data
Binary data is binary data. It doesn't mattrer whether it is GBK or and audio file, or a jpeg. If you escape the data properly before inserting it you will get back the same data you stored. Your application must display it properly. xuefer tinys wrote: re-posting multibyte problem. does anyone have problem with binary data in MySQL-4.x using GBK charset or any other multibyte charset? inserting/updating/replacing the full description is in mysql mailing list archive, sent by me will not repost full desc until someone have or care this problem thx _ ÓëÁª»úµÄÅóÓѽøÐн»Á÷£¬ÇëʹÓà MSN Messenger: http://messenger.microsoft.com/cn/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-4.x GBK Problem with Binary Data
it's true that mysql-4.x process binary data well when not using multi-byte charset but mysql-4.x process it differently when using multi-byte it's only for GBK text escaping, which is not suitable for binary data that's the key point if u don't use multi-byte, and mysql-4.x, u will never have such problem From: Gerald Clark [EMAIL PROTECTED] To: xuefer tinys [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: MySQL-4.x GBK Problem with Binary Data Date: Fri, 20 Sep 2002 15:35:20 -0500 Binary data is binary data. It doesn't mattrer whether it is GBK or and audio file, or a jpeg. If you escape the data properly before inserting it you will get back the same data you stored. Your application must display it properly. xuefer tinys wrote: re-posting multibyte problem. does anyone have problem with binary data in MySQL-4.x using GBK charset or any other multibyte charset? inserting/updating/replacing the full description is in mysql mailing list archive, sent by me will not repost full desc until someone have or care this problem thx _ ÓëÁª»úµÄÅóÓѽøÐн»Á÷£¬ÇëʹÓà MSN Messenger: http://messenger.microsoft.com/cn/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ ÏíÓÃÊÀ½çÉÏ×î´óµÄµç×ÓÓʼþϵͳ¡ª MSN Hotmail¡£http://www.hotmail.com/cn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.x Timeline
On Fri, Feb 22, 2002 at 08:29:03AM -0500, Anthony W. Marino wrote: On Friday 22 February 2002 02:15 am, Jeremy Zawodny wrote: On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote: Is there a timeline/status for 4.x functionality available? No. It'll be ready when it's ready. :-) There are folks using 4.0.x in production and/or testing now. This helps test the code and get folks comfortable enough with it to go from alpha to beta to gamma to stable. Well, any idea on a date for beta? If I was *forced to guess*, I'd expect it in April or May. But I might be pleasantly surprised (and proven wrong). I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. I've heard that there's now a developer working on sub-selects. But I've not heard the same triggers and stored procedures. That doesn't mean a whole lot, since I have no claim to know what's going on at MySQL central... Any advantages, featurewise, to using MySQL 3.x at this point? Stability. The 4.0 codebase is still undergoing changes that cause some things (like replication) to break in interesting ways. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 17 days, processed 555,777,468 queries (358/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.x Timeline
On Fri, Feb 22, 2002 at 08:59:41AM +, [EMAIL PROTECTED] wrote: I would like to second this request. I *really* want the replication failover functionality targeted for 4.x. In fact, if it isn't going to arrive by, say, midsummer, I will have to develop my own failover solutions. Well, the good news is that Sasha asked for folks to help test the new replication code and he got several volunteers. In fact, I've got a MySQL 4.0.2 slave running (sort of broken) right now. So it is being worked on, tested, and debugged. Which, obviously, I don't want to do - I have this aversion to reinventing wheels, and I have this nasty feeling that the MySQL teams wheels would be rounder than mine. I know what you mean. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 17 days, processed 555,820,789 queries (358/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.x Timeline
On Sunday 24 February 2002 06:26 pm, Arjen Lentz wrote: Hi Anthony, On Fri, 2002-02-22 at 23:43, Anthony W. Marino wrote: On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote: Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. There certainly is a general timeline... have a look at various points in the online manual (http://www.mysql.com/doc/) to see what the priorities are and will be. As for exact dates: it will be ready when it's ready. Some may not like that response, but it's honest. As you know, with MySQL we prefer to do a solid implementation rather than a quick hack. This is the excerpt I found from the docs and Im having difficulty trying to figure out what within a couple of months is relative to. I was wondering if there is some clearer date with regards to the upcoming beta: The rollout of MySQL Server 4.0 will come in several steps, with the first version labelled 4.0.0 already containing most of the new features. Additional features will be incorporated into MySQL 4.0.1, 4.0.2 onwards; very probably within a couple of months, MySQL 4.0 will be labelled beta. Further new features will then be added in MySQL 4.1, which is targeted for alpha release in early 2002. For MySQL Server, an alpha becomes a beta when 1) all features scheduled for that version have been added and 2) no disastrous new bugs are being reported (generally regarding the new features, but of course it is possible that new code also inadvertantly affects the behaviour of old code). So, it is not a completely new separate version or anything like that, it just signifies the development status. It is very dependent on the feedback we get (i.e. the problems that may be found) and therefore there can't be an absolute timeline. The within a few months is just a ballpark figure, relative to the initial alpha release of a sub-version (like 4.0.0). If you keep an eye on the mailing list and the change log for 4.0.x, you can decide for yourself if the server is stable enough for you. I hope this clarifies the issue a bit? I am a bit unsure about exactly what you are looking for... if you want solid code, there can't be an absolute timeline with fixed release dates. I am sure everybody prefers good code. Yet people also keep asking about specific dates for version releases... I suppose it's natural, we're all eager and curious, but maybe you can give me an additional explanation? I DO understand that the BETA becomes available when ALL slated features have made it into the alpha and with some certainity of stability. My concern is in knowing when some of these features (ie; subselects, triggers, sp's and etc) will make it into the alpha so that I can coordinate my coding efforts around them. Don't forget, the db isn't the only part of many software projects. And the more uncertainity that we have about the timing of features/functionality availability which our (my) progam and/or code might need to rely on, it's quite possible that almost everything will be ready for nothing or nothing will be ready for everything. I DO appreciate the GREAT work that's going on with MySQL, however, I'm also looking at other products that already have the above such as PostgreSQL and Firebird (InterBase Opensource) and trying to measure the pros/cons of all three, however, it would make things ALOT easier if I new when the above features would be available. Regards and Thank You, Anthony Regards, Arjen. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.x Timeline
Hi Anthony, On Fri, 2002-02-22 at 23:43, Anthony W. Marino wrote: On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote: Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. There certainly is a general timeline... have a look at various points in the online manual (http://www.mysql.com/doc/) to see what the priorities are and will be. As for exact dates: it will be ready when it's ready. Some may not like that response, but it's honest. As you know, with MySQL we prefer to do a solid implementation rather than a quick hack. This is the excerpt I found from the docs and Im having difficulty trying to figure out what within a couple of months is relative to. I was wondering if there is some clearer date with regards to the upcoming beta: The rollout of MySQL Server 4.0 will come in several steps, with the first version labelled 4.0.0 already containing most of the new features. Additional features will be incorporated into MySQL 4.0.1, 4.0.2 onwards; very probably within a couple of months, MySQL 4.0 will be labelled beta. Further new features will then be added in MySQL 4.1, which is targeted for alpha release in early 2002. For MySQL Server, an alpha becomes a beta when 1) all features scheduled for that version have been added and 2) no disastrous new bugs are being reported (generally regarding the new features, but of course it is possible that new code also inadvertantly affects the behaviour of old code). So, it is not a completely new separate version or anything like that, it just signifies the development status. It is very dependent on the feedback we get (i.e. the problems that may be found) and therefore there can't be an absolute timeline. The within a few months is just a ballpark figure, relative to the initial alpha release of a sub-version (like 4.0.0). If you keep an eye on the mailing list and the change log for 4.0.x, you can decide for yourself if the server is stable enough for you. I hope this clarifies the issue a bit? I am a bit unsure about exactly what you are looking for... if you want solid code, there can't be an absolute timeline with fixed release dates. I am sure everybody prefers good code. Yet people also keep asking about specific dates for version releases... I suppose it's natural, we're all eager and curious, but maybe you can give me an additional explanation? Regards, Arjen. -- MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.x Timeline
Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. I would like to second this request. I *really* want the replication failover functionality targeted for 4.x. In fact, if it isn't going to arrive by, say, midsummer, I will have to develop my own failover solutions. Which, obviously, I don't want to do - I have this aversion to reinventing wheels, and I have this nasty feeling that the MySQL teams wheels would be rounder than mine. So some indication of the timescales would be really useful. I certainly don't need exact dates, and I know all about the delays in development - but some indiciation would be really helpful and could save me a lot of work. Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.x Timeline
Hi Alec, On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote: Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. There certainly is a general timeline... have a look at various points in the online manual (http://www.mysql.com/doc/) to see what the priorities are and will be. As for exact dates: it will be ready when it's ready. Some may not like that response, but it's honest. As you know, with MySQL we prefer to do a solid implementation rather than a quick hack. I would like to second this request. I *really* want the replication failover functionality targeted for 4.x. In fact, if it isn't going to arrive by, say, midsummer, I will have to develop my own failover solutions. Which, obviously, I don't want to do - I have this aversion to reinventing wheels, and I have this nasty feeling that the MySQL teams wheels would be rounder than mine. So some indication of the timescales would be really useful. I certainly don't need exact dates, and I know all about the delays in development - but some indiciation would be really helpful and could save me a lot of work. If you have a commercial interest in speeding up a particular part of our planned development, this is certainly something that can be talked about. As you may know, the original replication was done as a 'sponsored' project. One company needed it, and provided the funds to allow us to allocate manpower for doing it. Now, it benefits many more! MySQL's development path is not for sale, but like any company we have to accept certains limit in our human and financial resources. Sponsoring a particular part can in cases such as these allow for faster development, provided of course that technical prerequisites are met; naturally the rule about solid implementations still applies. To get you (and others) thinking along an interesting track sponsoring need not be limited to a single company making a large targeted contribution. It could very well be multiple small(er) companies that have a similar need. The question is simply how fast you need a certain feature, and what it will save you to have it that fast, and/or gain you by having it help your business. That knowledge would allow you to invest (part of) those savings into making sure that it does happen. Regards, Arjen. -- MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.x Timeline
On Friday 22 February 2002 02:15 am, Jeremy Zawodny wrote: On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote: Is there a timeline/status for 4.x functionality available? No. It'll be ready when it's ready. :-) There are folks using 4.0.x in production and/or testing now. This helps test the code and get folks comfortable enough with it to go from alpha to beta to gamma to stable. Well, any idea on a date for beta? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. I've heard that there's now a developer working on sub-selects. But I've not heard the same triggers and stored procedures. That doesn't mean a whole lot, since I have no claim to know what's going on at MySQL central... Jeremy Any advantages, featurewise, to using MySQL 3.x at this point? Thanks, Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.x Timeline
On Friday 22 February 2002 06:26 am, Arjen Lentz wrote: Hi Alec, On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote: Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. There certainly is a general timeline... have a look at various points in the online manual (http://www.mysql.com/doc/) to see what the priorities are and will be. As for exact dates: it will be ready when it's ready. Some may not like that response, but it's honest. As you know, with MySQL we prefer to do a solid implementation rather than a quick hack. This is the excerpt I found from the docs and Im having difficulty trying to figure out what within a couple of months is relative to. I was wondering if there is some clearer date with regards to the upcoming beta: The rollout of MySQL Server 4.0 will come in several steps, with the first version labelled 4.0.0 already containing most of the new features. Additional features will be incorporated into MySQL 4.0.1, 4.0.2 onwards; very probably within a couple of months, MySQL 4.0 will be labelled beta. Further new features will then be added in MySQL 4.1, which is targeted for alpha release in early 2002. I would like to second this request. I *really* want the replication failover functionality targeted for 4.x. In fact, if it isn't going to arrive by, say, midsummer, I will have to develop my own failover solutions. Which, obviously, I don't want to do - I have this aversion to reinventing wheels, and I have this nasty feeling that the MySQL teams wheels would be rounder than mine. So some indication of the timescales would be really useful. I certainly don't need exact dates, and I know all about the delays in development - but some indiciation would be really helpful and could save me a lot of work. If you have a commercial interest in speeding up a particular part of our planned development, this is certainly something that can be talked about. As you may know, the original replication was done as a 'sponsored' project. One company needed it, and provided the funds to allow us to allocate manpower for doing it. Now, it benefits many more! MySQL's development path is not for sale, but like any company we have to accept certains limit in our human and financial resources. Sponsoring a particular part can in cases such as these allow for faster development, provided of course that technical prerequisites are met; naturally the rule about solid implementations still applies. To get you (and others) thinking along an interesting track sponsoring need not be limited to a single company making a large targeted contribution. It could very well be multiple small(er) companies that have a similar need. The question is simply how fast you need a certain feature, and what it will save you to have it that fast, and/or gain you by having it help your business. That knowledge would allow you to invest (part of) those savings into making sure that it does happen. Regards, Arjen. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4.x Timeline
Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. Thanks, Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4.X
Hi. I have been awayv for a while. I see that 3.23 is still listed as the current distribution version. When might one expect that 4.X will be released as a production version? MySQL, versions - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
