Re: InnoDB is better than MyISAM ?
Patrick, - Original Message - From: Patrick Hsieh [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, April 06, 2002 10:43 AM Subject: Re: InnoDB is better than MyISAM ? Hello Heikki Tuuri [EMAIL PROTECTED], Where can I find InnoDB Hot Backup product? you can join the InnoDB Hot Backup beta testing program at http://www.innodb.com/hotbackup.html Since no bugs have been reported from ibbackup-0.34 by any of the beta testers, Innobase Oy may declare ibbackup stable already during this month. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com On Sat, 6 Apr 2002 10:35:33 +0300 Heikki Tuuri [EMAIL PROTECTED] wrote: Hi! - Original Message - From: Eric S [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, April 06, 2002 2:10 AM Subject: Re: InnoDB is better than MyISAM ? On Fri, 5 Apr 2002, BD wrote: At 01:54 PM 4/5/2002, you wrote: I have seen many people saying that InnoDB is a great deal, that InnoDB rocks, etc. and I am concerced about how much better InnoDB is compared to MyISAM tables. Can someone tells me wich one is better ? I know that InnoDB have foreign keys support, but I deal very well without then since now. My interests are justified becaus eI got out of a very old struct ( DBM + Text Files ) and jumped head first into MySQL - MyISAM tables, but my site has a good deal of visitors ( about 30.000 unique visitors by day ) and speed and reliability are my primary concerns. I plan to use replication in MySQL, and I would like to know if InnoDB is better than MyISAM for this. MySQL replication works with InnoDB type tables, and is currently used at several sites. InnoDB Hot Backup (non-free software) makes it possible to set up a new slave without stopping the master or setting any locks on the master. This is a useful feature at sites requiring high availability. One note here is that transactions aren't preserved for replication with InnoDB, so you loose part of one of the major advantages of InnoDB. Rollbacks are O.K., since I don't think that goes out to the slaves until the commit, but if the master or slave goes down after part of a transaction is sent to the slave, you get a partially committed transaction on the slave. How critical this is depends on the application, and still is no worse than MyISAM which has no transactions to begin with. I think Heikki Tuuri has mentioned plans to get this fixed, though I think I remember that he said that the problem was in MySQL, not in the actual InnoDB code, which makes sense. A potential embedded license buyer is interested in getting this fixed. If the deal is closed, we may add the commit marks to the binlog rather soon. Have you ever heard the old saying, If it ain't broke, don't fix it?.bg If your website is mainly for read access to your database then you're not going to need InnoDb. Agreed 100%, but it doesn't hurt too much (except for index sizes) on readonly databases, so on our production system, we standardized on InnoDB for all tables for consistency, though we will allow for exceptions for tables that need features that aren't in InnoDB yet, such as full text searching. InnoDb inserts (for a single user) are much slower (for me it is around 10x slower) than MyISAM because InnoDb does a lot more work. This was not my experience. Without batching the commits, InnoDB lost out to MyISAM on our initial testing by about 1.5x rather than 10x. However, when I committed every 100 or so inserts, InnoDB beat out MyISAM by a small (25%) margin. This was with a single user hitting the database, a perl program that read in a text file, split it into fields, and stuffed it into the database one record at a time (identical programs except for handling the commits()). Now, this wasn't normal database activity, pure inserts into a freshly created table, but the results were still quite impressive. Also, I'm dealing with single-user activity, so there may have been some differences there as well. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://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 -- Patrick Hsieh
MySQL database changes for japanese Lang..
Dear All Could any one tell me what all the chages I have to make in order to make my existing (english version) of MySQL database compatable to the Japanese language. Thanks and Regards Aravind - 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 spanned over several systems
Hi, I would like to try to implement a MySQL server that is spanned over several machines (a sort of database cluster) - as this is only a test, I am not too woried about the end OS, but I will probably use a Mandrake 8.1 or 8.2 Linux distribution. I have found in the manual information about running several servers on the same system, but nothing on running one (or several linked) servers that can run queries on a database distributed over several systems... Any information, passed experiences, or links to ressources on the web will be greatly appreciated. Cheers, Daniel - 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: printing the database
Hi Gurhan, The tee command printed out the table perfectly to a file, Cheers, Colin tee /dir/table.txt; select * from table; --- Gurhan Ozen [EMAIL PROTECTED] wrote: Hi, Try to use tee command to log all the output into a file. It will have the column names and everything you see in the screen. See: http://www.mysql.com/doc/m/y/mysql.html Gurhan -Original Message- From: colin o [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 4:14 PM To: mysql Subject: printing the database Hi, Is it possible to print a table from the database in the same format as you can see it. I tried to export a table to an outfile, but i dont get the column names. I am using Linux so i don't have a print screen option, I think you can do using a software package called EMS MySQL Manager, but this isn't free. Is it possible? Thanks in advance, Colin __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.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 - 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 __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.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
Problems of mysql.sock
Description: While I tried to open MySQL, it showed an error message, is 'can't connect MySQL through /var/lib/mysql/mysql.sock' (Error Code=2), and I created a new one (User: root, Group: mysql, Permission: 777), the error code changed into 111. How-To-Repeat: Open MySQL. Fix: I don't know. Submitter-Id: submitter ID Originator:root Organization: MySQL support: none Synopsis: File Error Severity: critical Priority: medium Category: mysql Class: support Release: mysql-3.23.47 (Mandrake Linux MySQL RPM) Environment: System: Linux y2kcl.no-ip.org 2.4.8-26mdk #1 Sun Sep 23 17:06:39 CEST 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux-gnu/2.96/specs gcc version 2.96 2731 (Mandrake Linux 8.1 2.96-0.62mdk) Compilation info: CC='gcc' CFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math -fno-strength-reduce -fno-omit-frame-pointer' CXX='g++' CXXFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math -fno-strength-reduce -fno-omit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Feb 3 00:09 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285480 Sep 10 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27487418 Sep 10 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 10 2001 /usr/lib/libc.so -rw-r--r--1 root root 2330102 Jun 19 2001 /usr/lib/libc-client.a Configure command: ./configure --enable-shared --enable-thread-safe-client --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man --with-berkeley-db --without-innobase '--with-comment=Mandrake Linux MySQL RPM' - 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: Problems of mysql.sock
mkw, Saturday, April 06, 2002, 12:59:15 PM, you wrote: mDescription: m While I tried to open MySQL, it showed an error message, is 'can't connect MySQL through /var/lib/mysql/mysql.sock' (Error Code=2), and I created a new one (User: root, Group: mysql, m Permission: 777), the error code changed into 111. mHow-To-Repeat: m Open MySQL. mFix: m I don't know. Is your MySQL server running? Show me the contents of your 'host_name'.err file. Please, check also the following chapter of the MySQL manual: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Help! Error in editing or creating columns...
hedrickj, Friday, April 05, 2002, 9:21:14 PM, you wrote: h I am using MySQL Manager to manage a database created with the tool a week or so ago. Worked on the database last night and all was fine. Opened up mySQL Manager today and any change to the tables h (add or edit of columns) gives the error below: h Error on rename of: h '.\dbname\tablename.MYI' to '.\dbname\#SQL2-a60-4f.MYI'(Errcode 13) h The same operation worked fine in mySQL Monitorhas anyone had h experience with this error? is it caused by the GUI or is it DB based? Help! # perror 13 Error code 13: Permission denied What are the file/directory permissions on mysql data directory? Does the user have permission to read/write/execute on those directories/files? h Thanks, h James -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Enabling LOCKing on Linux Red Hat 7.1
I have a standard installation of Mysql on a red hat 7.1 box. I am confused as to where I can disable the SKIP_LOCKING feature. There is no skip_locking-option in /etc/my.cnf. I removed the string --skip_locking from /usr/bin/safe_mysqld. I can't find it anywhere, still when I do mysqladmin variables it reports sklip_locking ON. Where do I turn it off? ...Jesper _ MSN Photos är det enklaste sättet att dela ut och skriva ut foton: http://photos.msn.se/Support/WorldWide.aspx - 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
SELECT ... LIMIT n,-1
Hello, I've been looking for a way to select and access all result rows starting at a specific offset. The according select clause with LIMIT n,m comes to mind, but unfortunately the current documentation is not very explicit concerning the appropriate value for m under these circumstances. What I'm looking for is a way to specify that for a query that would return x rows when not limited, I'd like to see X-n rows, starting at row n. All this without knowing X in advance :-) Tests with mySQL 3.23.37 on Linux shows that SELECT LIMIT n,-1 will achieve the desired result. Is this a supported approach, despite the fact it isn't documented, and may I expect this to work in future versions? Is there a different approach to this? And, last but not least, could the documentation be updated to reflect this issue? Thanks in advance. With regards, Jens -- email : [EMAIL PROTECTED] - 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
Do any of your applications work?
Responsible Person, We have been asked by a client, to use your products in our intergration efforts. Your MySQL 3.23.49a [Stable version?] for Sun Solaris x86, version, 5.8, is offered without the installation file ./scripts/mysql_install_db. The ./scripts/mysql_install_db, that comes with it, is EMPTY! Your MySQL-MAX 3.23.49a, although it gets a little further along in the installation phase [in that a deamon start-up], only some of the commands are execuatble/executing. This is not a normal [nor acceptable] situation in the UNIX world, when commands in the same directory are not all executable [No PATH problems here]. None of the following commands seem to work: mysql, mysqladmin, BINDER/(anything), just to name a few. The instructions were followed to the dot [as we have previously done with REDHat Linux 7.2, of the above mentioned]. We have also come to find, that your JDBC [mm.mysql.jdbc-1.2c.tar.gz] driver currently has a problem in being recognised in the FORTE developement environment. Please know, that we are not at all new to the communal-developement environment. However, whenevr anything is posted to be working, it should be exactly that. Ommission errors of the magnitude we have found, are pure 'Microsoftish' in nature, and should have no place anywhere, integrity not withstanding. Besides our practice of believing, that sometimes bad things happen to good people/things, perhaps by us bringing these faults to your attention that some good will come of this. In the meatime, I await a prompt response. As for our client, depending upon your promptness, they may not cancel the current licensing agreement with you. H. O'Loughlin, CEO O'LOUGHLIN ASSOCIATES CORPORATIION CC:/BLIND LIST - 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: Difference between Unique Index and Primary Key?
At 1:24 -0600 4/6/02, BD wrote: Paul, Do you know if there is any performance differences between a unique index and primary key (if there are no nulls)? Is the index file format the same as the primary key? I cannot answer that with absolute certainty, but as far as I know the answers are no, and yes. Brent At 05:09 PM 4/5/2002, you wrote: Here are a few easy philosophical questions for a change: 1) For performance or storage benefits, is there a difference between a Unique Index and Primary Key? There can be only one primary key. There can be multiple unique indexes. Primary keys cannot contain NULL values. Unique indexes can allow NULL values (and in fact, NULL is the one value that can occur multiple times in a unique index). 2) Is there a reason why I should use Primary Key instead of a Unique Index? 3) Why isn't there a syntax for create primary index index_name on table_name (fieldlist) ? I know a primary key can be added with Alter table, but if I'm defining indexes for a table, it would look a lot better in the script if I was using the same syntax. TIA Brent sql, query - 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: Do any of your applications work?
Hello Mr CEO, Hmmm... go away? Ric - Original Message - From: Hugh O'Loughlin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 06, 2002 1:31 PM Subject: Do any of your applications work? Responsible Person, We have been asked by a client, to use your products in our intergration efforts. Your MySQL 3.23.49a [Stable version?] for Sun Solaris x86, version, 5.8, is offered without the installation file ./scripts/mysql_install_db. The ./scripts/mysql_install_db, that comes with it, is EMPTY! Your MySQL-MAX 3.23.49a, although it gets a little further along in the installation phase [in that a deamon start-up], only some of the commands are execuatble/executing. This is not a normal [nor acceptable] situation in the UNIX world, when commands in the same directory are not all executable [No PATH problems here]. None of the following commands seem to work: mysql, mysqladmin, BINDER/(anything), just to name a few. The instructions were followed to the dot [as we have previously done with REDHat Linux 7.2, of the above mentioned]. We have also come to find, that your JDBC [mm.mysql.jdbc-1.2c.tar.gz] driver currently has a problem in being recognised in the FORTE developement environment. Please know, that we are not at all new to the communal-developement environment. However, whenevr anything is posted to be working, it should be exactly that. Ommission errors of the magnitude we have found, are pure 'Microsoftish' in nature, and should have no place anywhere, integrity not withstanding. Besides our practice of believing, that sometimes bad things happen to good people/things, perhaps by us bringing these faults to your attention that some good will come of this. In the meatime, I await a prompt response. As for our client, depending upon your promptness, they may not cancel the current licensing agreement with you. H. O'Loughlin, CEO O'LOUGHLIN ASSOCIATES CORPORATIION CC:/BLIND LIST - 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: Do any of your applications work?
Ditto here. If you have a support contract, then this is not the channel for seeking support, since it's a free mailing list. And anybody would need more information than you provided to solve the problem. Did you try to install a binary version? Did you try to build from source? MySQL is installed on millions of servers around the world. So, yes, the applications work and work well. I am not, by any means, a guru and I have installed MySQL on my Linux box and run it for a couple of years now. Having said all of that, you are welcome to support from this list, if you want it, but you ought to provide more detailed information. This side of MySQL is a community of volunteers and not a business. It doesn't do a whole lot of good to make threats and demands here. On Sat, 2002-04-06 at 08:36, Richard Clarke wrote: Hello Mr CEO, Hmmm... go away? Ric - Original Message - From: Hugh O'Loughlin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 06, 2002 1:31 PM Subject: Do any of your applications work? Responsible Person, We have been asked by a client, to use your products in our intergration efforts. Your MySQL 3.23.49a [Stable version?] for Sun Solaris x86, version, 5.8, is offered without the installation file ./scripts/mysql_install_db. The ./scripts/mysql_install_db, that comes with it, is EMPTY! Your MySQL-MAX 3.23.49a, although it gets a little further along in the installation phase [in that a deamon start-up], only some of the commands are execuatble/executing. This is not a normal [nor acceptable] situation in the UNIX world, when commands in the same directory are not all executable [No PATH problems here]. None of the following commands seem to work: mysql, mysqladmin, BINDER/(anything), just to name a few. The instructions were followed to the dot [as we have previously done with REDHat Linux 7.2, of the above mentioned]. We have also come to find, that your JDBC [mm.mysql.jdbc-1.2c.tar.gz] driver currently has a problem in being recognised in the FORTE developement environment. Please know, that we are not at all new to the communal-developement environment. However, whenevr anything is posted to be working, it should be exactly that. Ommission errors of the magnitude we have found, are pure 'Microsoftish' in nature, and should have no place anywhere, integrity not withstanding. Besides our practice of believing, that sometimes bad things happen to good people/things, perhaps by us bringing these faults to your attention that some good will come of this. In the meatime, I await a prompt response. As for our client, depending upon your promptness, they may not cancel the current licensing agreement with you. H. O'Loughlin, CEO O'LOUGHLIN ASSOCIATES CORPORATIION CC:/BLIND LIST - 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 - 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: Do any of your applications work?
Hi...Sir, The answer on your question is Y E S.But further, perhaps,a little more experiences for your technical team is needful. - Original Message - From: Hugh O'Loughlin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 06, 2002 3:31 PM Subject: Do any of your applications work? Responsible Person, We have been asked by a client, to use your products in our intergration efforts. Your MySQL 3.23.49a [Stable version?] for Sun Solaris x86, version, 5.8, is offered without the installation file ./scripts/mysql_install_db. The ./scripts/mysql_install_db, that comes with it, is EMPTY! Your MySQL-MAX 3.23.49a, although it gets a little further along in the installation phase [in that a deamon start-up], only some of the commands are execuatble/executing. This is not a normal [nor acceptable] situation in the UNIX world, when commands in the same directory are not all executable [No PATH problems here]. None of the following commands seem to work: mysql, mysqladmin, BINDER/(anything), just to name a few. The instructions were followed to the dot [as we have previously done with REDHat Linux 7.2, of the above mentioned]. We have also come to find, that your JDBC [mm.mysql.jdbc-1.2c.tar.gz] driver currently has a problem in being recognised in the FORTE developement environment. Please know, that we are not at all new to the communal-developement environment. However, whenevr anything is posted to be working, it should be exactly that. Ommission errors of the magnitude we have found, are pure 'Microsoftish' in nature, and should have no place anywhere, integrity not withstanding. Besides our practice of believing, that sometimes bad things happen to good people/things, perhaps by us bringing these faults to your attention that some good will come of this. In the meatime, I await a prompt response. As for our client, depending upon your promptness, they may not cancel the current licensing agreement with you. H. O'Loughlin, CEO O'LOUGHLIN ASSOCIATES CORPORATIION CC:/BLIND LIST - 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: Do any of your applications work?
I agree with everyone that has responded. A vague answer that does nothing but moan about something that is more or less incompentence from your developmental team. Not only that, but you have a support contract, so why you asking a question here? Shouldn't you be calling your support for this answer? -Original Message- From: Hugh O'Loughlin [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 06, 2002 6:32 AM To: [EMAIL PROTECTED] Subject: Do any of your applications work? Responsible Person, We have been asked by a client, to use your products in our intergration efforts. Your MySQL 3.23.49a [Stable version?] for Sun Solaris x86, version, 5.8, is offered without the installation file ./scripts/mysql_install_db. The ./scripts/mysql_install_db, that comes with it, is EMPTY! Your MySQL-MAX 3.23.49a, although it gets a little further along in the installation phase [in that a deamon start-up], only some of the commands are execuatble/executing. This is not a normal [nor acceptable] situation in the UNIX world, when commands in the same directory are not all executable [No PATH problems here]. None of the following commands seem to work: mysql, mysqladmin, BINDER/(anything), just to name a few. The instructions were followed to the dot [as we have previously done with REDHat Linux 7.2, of the above mentioned]. We have also come to find, that your JDBC [mm.mysql.jdbc-1.2c.tar.gz] driver currently has a problem in being recognised in the FORTE developement environment. Please know, that we are not at all new to the communal-developement environment. However, whenevr anything is posted to be working, it should be exactly that. Ommission errors of the magnitude we have found, are pure 'Microsoftish' in nature, and should have no place anywhere, integrity not withstanding. Besides our practice of believing, that sometimes bad things happen to good people/things, perhaps by us bringing these faults to your attention that some good will come of this. In the meatime, I await a prompt response. As for our client, depending upon your promptness, they may not cancel the current licensing agreement with you. H. O'Loughlin, CEO O'LOUGHLIN ASSOCIATES CORPORATIION CC:/BLIND LIST - 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 and order in a query
* Paul DuBois At 18:03 +0200 4/6/02, David yahoo wrote: Is there any way to put a sort order different than the alpahbetical order in string. A thing like that order french,german ORDER BY ELT(language,'english','german','french'),Linkname ASC Maybe you meant FIELD(language...? From the manual: Changes in release 3.20.17 -- [...] * The `ELT()' function is renamed to `FIELD()'. The new `ELT()' function returns a value based on an index: `FIELD()' is the inverse of `ELT()' Example: `ELT(2,A,B,C)' returns `B'. `FIELD(B,A,B,C)' returns `2'. The language column is a string containing 'english', 'french' or 'german'. The order of the fields in the FIELD() should be the order of what you want as a result: 'french','german','english' will give you 'french' items first, 'english' items last. Beware that any item with a language not existing in the field list will get a zero value, and be sorted first. -- Roger query - 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: Do any of your applications work?
I sense this could be a troll, but... /* Hugh O'Loughlin [[EMAIL PROTECTED]] writes: */ We have been asked by a client, to use your products in our intergration efforts. Your MySQL 3.23.49a [Stable version?] for Sun Solaris x86, Excellent choice. ./scripts/mysql_install_db. The ./scripts/mysql_install_db, that comes with it, is EMPTY! Odd. My 3.23.49's was not empty... Consider downloading an older release to get that script if you really need it. None of the following commands seem to work: mysql, mysqladmin, BINDER/(anything), Perhaps you can clue us in ... what about them doesn't work? You mentioned that some things were not set as executable. If that is the case, you can use the UNIX chmod command with the +x option to set it to be executable. E.g. chmod +x /usr/local/mysql/bin/mysqladmin [...JDBC rant and 'Microsoftish' insults removed...] In the meatime, I await a prompt response. As for our client, depending upon your promptness, they may not cancel the current licensing agreement with you. Frankly, the agreement your client should look at cancelling is the one with your company. Your inability to install MySQL notwithstanding, jumping into a public forum whining and crying that things don't work the way you think they should, providing little to no information on what doesn't work means in your case, and finally threatening that a CLIENT may cancel a licensing agreement... Sir, other words come to mind, but for the sake of this forum I'll simply say that you are acting unprofessional. -- do svidaniya, ~mitch - 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 and order in a query
I think of a little hack I can add in where clause something like : ELT(language,'english','german','french') != 0 to avoid language not in list even if there no normally :) I try this as soon as i can. thanks. * Paul DuBois At 18:03 +0200 4/6/02, David yahoo wrote: Is there any way to put a sort order different than the alpahbetical order in string. A thing like that order french,german ORDER BY ELT(language,'english','german','french'),Linkname ASC Maybe you meant FIELD(language...? From the manual: Changes in release 3.20.17 -- [...] * The `ELT()' function is renamed to `FIELD()'. The new `ELT()' function returns a value based on an index: `FIELD()' is the inverse of `ELT()' Example: `ELT(2,A,B,C)' returns `B'. `FIELD(B,A,B,C)' returns `2'. The language column is a string containing 'english', 'french' or 'german'. The order of the fields in the FIELD() should be the order of what you want as a result: 'french','german','english' will give you 'french' items first, 'english' items last. Beware that any item with a language not existing in the field list will get a zero value, and be sorted first. -- Roger query - 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 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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: Re: Do any of your applications work?
/* Kevin Smith [[EMAIL PROTECTED]] writes: */ That has got to be the best reply I have ever seen ;) I wanted to reply with... H. O'Loughlin, CEO -- you are the weakest link. Good Bye. - Original Message - From: Richard Clarke [EMAIL PROTECTED] Sent: Saturday, April 06, 2002 2:36 PM Subject: Re: Do any of your applications work? Hello Mr CEO, Hmmm... go away? Ric -- do svidaniya, ~mitch MYSQL? MySQL? mySQL? So many choices, so little time. - 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: My.S.Q.L
Hello [EMAIL PROTECTED], It's pretty interesting! Is tere MP3 file available for this song? On Sat, 6 Apr 2002 09:35:12 -0800 (PST) [EMAIL PROTECTED] wrote: Ok... it's Saturday and I've been meaning to share this with a wider audience for years Antti, you'll probably remember this from when I sent this to you shortly after I wrote it (1999)... If anyone would like to record this, let me know! :-) My.S.Q.L (sung to Y.M.C.A by the Village People) Young man, service should not go down. I said, young man, when your data's to be found I said, young man, 'cause Larry Ellison's a clown there's no need to be unhappy. Young man, there's a place you can go. I said, young man, when you're short on your dough. You can use it, as a production database and it takes up a lot less space. It's fun to run MySQL It's fun to run MySQL It has everything for your code to enjoy You can port it to all your toys... It's fun to run MySQL It's fun to run MySQL You can download the source, it's really quite small. Bug fixes are out before the fall... Young man, do you want to pay a fee? I said, young man, this database is free. I said, young man, it helps the economy but you got to know this one thing! No man does it all by himself. I said, young man, it's not about the wealth. Freedom, is part of it of course, We like to call it the Open Source. It's fun to run MySQL It's fun to run MySQL - 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 -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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
corrupt .FRM files?
Yesterday we discovered a strange problem with our database running on MySQL version 3.23.45 on a Linux OS version 2.2.16 The MySQL database had been running perfectly with a PHP interface on the web since january 30th and records were added normaly. Now suddenly the MySQL server is brought back into the state of March 11th, which means that all data since then are not shown. It seems that there is a problem with the permission to files of DB. there a solution on how we can fix or repair DB - files? Also does anyone have ideas on what might have happened. Thank you very much in advance! Best regards, Andreas http://www.dancegrooves.com Your dance music source on the internet! Dance Grooves Draadbaan 37 A 2352 BM Leiderdorp The Netherlands Phone: (+31)-(0)71-54 23 676 Fax: (+31)-(0)71-54 23 678 - 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
InnoDB and lock wait timeout
Hi. I have a question about rollbacks and innodb. Suppose that a query begins with begin. Then a couple inserts happen but before the commit statement is executed, the client hits stop in the browser. What is going to do the rollback? If there is a persistent connection, is it going to wait for 8 hours or so and what would happen then? Is there a significant increase in speed using persistent connections in MySQL? I am using PHP and I am cuious how one would do a persistent connection example. Does php would keep a class loaded in mem like java would? It doesn't sound plausible since php is loaded with an apache thread, which gets recycled every now and then, leaving the connection open on the mysql side but never used by apache agian. What are some approaches to solving these issues? Thanks - 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: InnoDB and lock wait timeout
Hi, Generally, an apache setup will kill a PHP enabled page when it has run for 30 seconds. Also, when a php script exits, all connections to the database are closed, so somwhere you need to keep the results of your script somwhere (hidden HTML variables, URI string), otherwise, when you change pages (and scripts of course), you lose your connection... and the transaction will probably abort... IMHO, you can only use a transaction within 1 PHP program (therefore within 1 page only), and remember your 30 second execution limit). If you are implementing a PHP / HTML application, I would guide the user over PHP enabled HTML form pages, and pass the result via a post or a URI string to the next page, etc. When you have all the info that you need, you send all the information from your previous pages to 1 parser script, which inserts all info into the database, with or without a transaction. This is the price you have to pay for a stateless connection - Your script is only active when your page is active. Hope that helps ! Cheers, Daniel Page -Original Message- From: Victor [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 06, 2002 10:58 PM To: MySQL Subject: InnoDB and lock wait timeout Hi. I have a question about rollbacks and innodb. Suppose that a query begins with begin. Then a couple inserts happen but before the commit statement is executed, the client hits stop in the browser. What is going to do the rollback? If there is a persistent connection, is it going to wait for 8 hours or so and what would happen then? Is there a significant increase in speed using persistent connections in MySQL? I am using PHP and I am cuious how one would do a persistent connection example. Does php would keep a class loaded in mem like java would? It doesn't sound plausible since php is loaded with an apache thread, which gets recycled every now and then, leaving the connection open on the mysql side but never used by apache agian. What are some approaches to solving these issues? Thanks - 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: InnoDB and lock wait timeout
Hi, On Sat, Apr 06, 2002 at 03:57:39PM -0500, Victor wrote: Suppose that a query begins with begin. Then a couple inserts happen but before the commit statement is executed, the client hits stop in the browser. What is going to do the rollback? If there is a persistent connection, is it going to wait for 8 hours or so and what would happen then? When the user hits the STOP button, your script (most likely) will have no idea that the browser closed the connection until it tries to send it some output, at which point it would probably receive SIGPIPE or some kind of indicator that the client is gone. By default, applications that receive SIGPIPE will terminate (Broken pipe). The connection to the mysql server would be broken, and the mysql server would issue a rollback. If your web server does any buffering, you may not know until the entire page is sent that the client disappeared. Your environment may provide different default behavior, but you should be able to modify these things to taste if you're willing to get low-level enough. PHP (since you mention it in the next paragraph) will by default kill running scripts if a timeout value is reached. This timeout can be modified accordingly. Is there a significant increase in speed using persistent connections in MySQL? I am using PHP and I am cuious how one would do a persistent connection example. Does php would keep a class loaded in mem like java would? It doesn't sound plausible since php is loaded with an apache thread, which gets recycled every now and then, leaving the connection open on the mysql side but never used by apache agian. We don't do persistent connections at all with our sites and we don't notice a speed problem (mod_perl). PHP provides a mysql_pconnect() function which is supposed to do persistant connections according to the documentation. If you don't maintain persistent connections, you may want to take measures to ensure that each mysql connection attempt doesn't involve a DNS lookup (either put the hostname in /etc/hosts or use an IP address instead of a name) if your mysql server is not localhost.. -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [EMAIL PROTECTED] - 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: Do any of your applications work?
At 14:31 2002-04-06, Hugh O'Loughlin wrote: Ommission errors of the magnitude we have found, are pure 'Microsoftish' in nature, and should have no place anywhere, integrity not withstanding. Microsoftish? Gosh, us Microsoft users have been having problems because the software doesn't follow Windows standards... Developing cross-platform software isn't all that simple. Instead of complaining and ranting, why can't you simply ask for help? Your tone doesn't exactly invite friendly responses from experienced users. filter fodder: sql,query -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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
mysqlbinlog: Duplicate entry '1' for key 1
Hello, I am trying to restore some data from the binary log but I get the following error: Duplicate entry '1' for key 1 I understand restoring data is a two-stage process: 1. You do a source myfile.sql to restore the data saved with mysqldump 2. You restore the data logged in the binary log using mysqlbinlog I am having the above problem at the second stage and what's more, I don't understand how mysql is supposed to know from what point to start the restore from. Thanks in advance, Balteo. - 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 and order in a query
At 18:28 +0200 4/6/02, Roger Baklund wrote: * Paul DuBois At 18:03 +0200 4/6/02, David yahoo wrote: Is there any way to put a sort order different than the alpahbetical order in string. A thing like that order french,german ORDER BY ELT(language,'english','german','french'),Linkname ASC Maybe you meant FIELD(language...? Right. Thanks. From the manual: Changes in release 3.20.17 -- [...] * The `ELT()' function is renamed to `FIELD()'. The new `ELT()' function returns a value based on an index: `FIELD()' is the inverse of `ELT()' Example: `ELT(2,A,B,C)' returns `B'. `FIELD(B,A,B,C)' returns `2'. The language column is a string containing 'english', 'french' or 'german'. The order of the fields in the FIELD() should be the order of what you want as a result: 'french','german','english' will give you 'french' items first, 'english' items last. Beware that any item with a language not existing in the field list will get a zero value, and be sorted first. -- Roger query - 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: Index a primary key
On Sun, 7 Apr 2002 [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: If I index a primary key, is that considered overkill? In other words, I know that a primary key is _the_ unique identifier into the table already. Carl - 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: Index a primary key
At 18:28 -0500 4/6/02, Carl Schmidt wrote: On Sun, 7 Apr 2002 [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: If I index a primary key, is that considered overkill? In other words, I know that a primary key is _the_ unique identifier into the table already. Carl It's overkill. Out of curiousity, why are you considering doing such a thing? - 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: Index a primary key
My understanding from the mysql docs is that indexing is to be used primarily for speeding queries on often used tables. This particular table is to be queried quite a bit , but almost entirely using the priamry key. So, I assumed that making the primary key an index would speed table searches. However, it prompted me to ask the question, are primary keys already optimized for some sort of indexing and searching? So then I emailed the list. Carl On Sat, 6 Apr 2002, Paul DuBois wrote: At 18:28 -0500 4/6/02, Carl Schmidt wrote: On Sun, 7 Apr 2002 [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: If I index a primary key, is that considered overkill? In other words, I know that a primary key is _the_ unique identifier into the table already. Carl It's overkill. Out of curiousity, why are you considering doing such a thing? - 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
any better way?
Subject: any better way? From: deco [EMAIL PROTECTED] === I have a bunch of data stored on a file and organized in messages... I got a message header and depending on the message type, i'll get a sequence of values which can be double, float, long, int, char, etc... Now i want to put this info in a mysql db, and i'm following this table structure (the whole thing is a bit more complicated, but this simple structure i think gives a nice picture of what i mean): TABLE types ( value_type_codeINT; value_type_descriptionTINYTEXT ); TABLE reads ( value_type_codeINT; read_valueTINYBLOB ); So, the thing is 'read_value' can be anything from a double, float, int, etc and so has a variable length. My solution was to have it like a TINYBLOB, where i may loose some space from the header (1 byte per record) but it's not very significative for me. But from here i'll have to be able to somehow make typecasts so i can make querys where i compare this blob values, and i don't quite know how to do this!! And i don't know if this is the best way to go, but i would surely be glad to hear from you all... The only other ways i thought of was to have this field like a double for all values, but it's not good. Other way was to have a different table for each value type, but that wouldn't be nice as i wan't to easily add new types as i go along!! Thanks in advance, Ricardo Rocha - 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: Index a primary key
At 18:51 -0500 4/6/02, Carl Schmidt wrote: My understanding from the mysql docs is that indexing is to be used primarily for speeding queries on often used tables. This particular table is to be queried quite a bit , but almost entirely using the priamry key. So, I assumed that making the primary key an index would speed table searches. However, it prompted me to ask the question, are primary keys already optimized for some sort of indexing and searching? So then I emailed the list. Primary keys are a type of index, so you do get the benefits of indexing by establishing a primary key. Carl On Sat, 6 Apr 2002, Paul DuBois wrote: At 18:28 -0500 4/6/02, Carl Schmidt wrote: On Sun, 7 Apr 2002 [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: If I index a primary key, is that considered overkill? In other words, I know that a primary key is _the_ unique identifier into the table already. Carl It's overkill. Out of curiousity, why are you considering doing such a thing? - 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
VERY URGENT, possible bug. More on: What does this error message mean: InnoDB: Warning: difficult to find free blocks from the buffer pool..
I forgot to point out that this is InnoDB I've searched Google and found the following disquiteing thing: http://www.innodb.com/oldbugs.html: Closed or old bug reports: Almost all of these bugs have been fixed. There are some old bug reports where the cause of the bug was never found, but because there have been no bug reports for newer versions of InnoDB, these reports are not considered actual any more. snip August 13, 2001: The fsync problem which was fixed in 3.23.40b and .41 could cause the following warning message on some Unix flavors: Innobase: Warning: difficult to find free blocks from Innobase: the buffer pool! Consider increasing the Innobase: buffer pool size. If you encounter the above message, upgrade to 3.23.41. However, I'm already using a newer vresion than that: ccs012:~ # rpm -qa |grep mysql mysql-shared-3.23.44-5 mysql-Max-3.23.44-5 mysql-devel-3.23.44-5 mysql-navigator-1.2.3-106 mysql-client-3.23.44-5 mysql-3.23.44-5 mysql-bench-3.23.44-5 ccs012:~ # This is a mission critical DB. Am I the lucky un-fortunate to re-dicover this supposedly fixed bug? JW I'm getting this error messge constantly in my error log: JW JW 020406 18:02:50 *** JW InnoDB: Warning: difficult to find free blocks from JW InnoDB: the buffer pool (200 search iterations)! Consider JW InnoDB: increasing the buffer pool size. JW InnoDB: It is also possible that in your Unix version JW InnoDB: fsync is very slow, or completely frozen inside JW InnoDB: the OS kernel. Then upgrading to a newer version JW InnoDB: of your operating system may help. Look at the JW InnoDB: number of fsyncs in diagnostic info below. JW InnoDB: Pending flushes (fsync) log: 0; buffer pool: 0 JW InnoDB: 5703 OS file reads, 502 OS file writes, 82 OS fsyncs JW InnoDB: Starting InnoDB Monitor to print further JW InnoDB: diagnostics to the standard output. JW JW Running SuSE Linux 7.3: JW JW ccs012:/var/lib/mysql # uname -a ; df -h ; free -m JW Linux ccs012 2.4.10-64GB-SMP #1 SMP Fri Sep 28 17:26:36 GMT 2001 i686 unknown JW FilesystemSize Used Avail Use% Mounted on JW /dev/sda7 67G 59G 8.2G 88% / JW /dev/sda5 63M 36M 26M 58% /boot JW shmfs1007M 0 1006M 0% /dev/shm JW total used free sharedbuffers cached JW Mem: 2013 2008 4 0 10657 JW -/+ buffers/cache: 1340672 JW Swap: 1035 0 1035 JW JW JW TIA JW JW -- JW JW JW Jonathan Wilson JW System Administrator JW Clickpatrol.com JW Cedar Creek Software http://www.cedarcreeksoftware.com JW JW JW JW - JW Before posting, please check: JWhttp://www.mysql.com/manual.php (the manual) JWhttp://lists.mysql.com/ (the list archive) JW JW To request this thread, e-mail [EMAIL PROTECTED] JW To unsubscribe, e-mail [EMAIL PROTECTED] JW Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php JW JW JW -- Jonathan Wilson System Administrator Clickpatrol.com Cedar Creek Software http://www.cedarcreeksoftware.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: VERY URGENT, possible bug. More on: What does this error message mean: InnoDB: Warning: difficult to find free blocks from the buffer pool..
I belive I have found a bug here, possibly. The last known commands to be run on the DB that are suspicious were a join between 2 tables. This is the info I got from the user who was workign on the DB: He was joining between keyword and billing select distinct(a.customerid) from cpcustomer.customerkeyword a left join cpbilling.billdetail b on a.customerid=b.customerid where b.customerid is null and active='y'; For some reason he hit ^c to exit (it didn't seem to be responding or somethign) He logged came back on to MySQL and ran: alter table add key bdetailcid (customerid); show create billdetail; It crashed (locked up) durning the last query mentioned above. I tried to shut down the server, but it wouldn't die so I ran the init-stop script a second time. It seems that the init start/stop script gets forceful on the second try. Started it back up, it took a _very_ long time recovering (InnoDB), then started in with the error message I first posted. Any ideas? I'm currently restoring from backups we'll see how it goes. Thanks. JW I forgot to point out that this is InnoDB JW JW I've searched Google and found the following disquiteing thing: JW http://www.innodb.com/oldbugs.html: JW JW Closed or old bug reports: Almost all of these bugs have been fixed. There are some old bug reports where the cause of the bug was never found, but because there have been no bug reports for newer versions of InnoDB, these reports are not considered actual any more. JW snip JW August 13, 2001: JW The fsync problem which was fixed in 3.23.40b and .41 could cause the following warning message on some Unix flavors: JW JW Innobase: Warning: difficult to find free blocks from JW Innobase: the buffer pool! Consider increasing the JW Innobase: buffer pool size. JW JW If you encounter the above message, upgrade to 3.23.41. JW JW However, I'm already using a newer vresion than that: JW JW ccs012:~ # rpm -qa |grep mysql JW mysql-shared-3.23.44-5 JW mysql-Max-3.23.44-5 JW mysql-devel-3.23.44-5 JW mysql-navigator-1.2.3-106 JW mysql-client-3.23.44-5 JW mysql-3.23.44-5 JW mysql-bench-3.23.44-5 JW ccs012:~ # JW JW This is a mission critical DB. Am I the lucky un-fortunate to re-dicover this supposedly fixed bug? JW JW JW I'm getting this error messge constantly in my error log: JW JW JW JW 020406 18:02:50 *** JW JW InnoDB: Warning: difficult to find free blocks from JW JW InnoDB: the buffer pool (200 search iterations)! Consider JW JW InnoDB: increasing the buffer pool size. JW JW InnoDB: It is also possible that in your Unix version JW JW InnoDB: fsync is very slow, or completely frozen inside JW JW InnoDB: the OS kernel. Then upgrading to a newer version JW JW InnoDB: of your operating system may help. Look at the JW JW InnoDB: number of fsyncs in diagnostic info below. JW JW InnoDB: Pending flushes (fsync) log: 0; buffer pool: 0 JW JW InnoDB: 5703 OS file reads, 502 OS file writes, 82 OS fsyncs JW JW InnoDB: Starting InnoDB Monitor to print further JW JW InnoDB: diagnostics to the standard output. JW JW JW JW Running SuSE Linux 7.3: JW JW JW JW ccs012:/var/lib/mysql # uname -a ; df -h ; free -m JW JW Linux ccs012 2.4.10-64GB-SMP #1 SMP Fri Sep 28 17:26:36 GMT 2001 i686 unknown JW JW FilesystemSize Used Avail Use% Mounted on JW JW /dev/sda7 67G 59G 8.2G 88% / JW JW /dev/sda5 63M 36M 26M 58% /boot JW JW shmfs1007M 0 1006M 0% /dev/shm JW JW total used free sharedbuffers cached JW JW Mem: 2013 2008 4 0 10657 JW JW -/+ buffers/cache: 1340672 JW JW Swap: 1035 0 1035 JW JW JW JW JW JW TIA JW JW JW JW -- JW JW JW JW JW JW Jonathan Wilson JW JW System Administrator JW JW Clickpatrol.com JW JW Cedar Creek Software http://www.cedarcreeksoftware.com JW JW JW JW JW JW JW JW - JW JW Before posting, please check: JW JWhttp://www.mysql.com/manual.php (the manual) JW JWhttp://lists.mysql.com/ (the list archive) JW JW JW JW To request this thread, e-mail [EMAIL PROTECTED] JW JW To unsubscribe, e-mail [EMAIL PROTECTED] JW JW Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php JW JW JW JW JW JW JW JW -- JW JW JW Jonathan Wilson JW System Administrator JW Clickpatrol.com JW Cedar Creek Software http://www.cedarcreeksoftware.com JW JW JW JW - JW Before posting, please check: JWhttp://www.mysql.com/manual.php (the manual) JWhttp://lists.mysql.com/ (the list archive) JW JW To request this thread, e-mail [EMAIL PROTECTED] JW To unsubscribe, e-mail [EMAIL
mysql database privilege problems...
Hi All, After working happily for months, my MySQL (v. 3.23.48-1) database has begun displaying the following problem: Whenever I log in as mysql root and try to change privileges for my database as follows: grant insert, select on MyDB_Name to MyExistingUserName; I get the error that the database mysql is read only. Is there an easy way to re-create the mysql permissions database and rebuild the permissions from scratch? I tried renaming the mysql db to mysql.bak and then restrating mysql, but it would not start until I renamed the file as it originally was. Any suggestions appreciated. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.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
SQL Question...
Hello again, I am trying to set up a SQL statement using NOW(), what I am wanting to do is to use NOW() then do a search on any date less than 7 days. Before I get several e-mails asking why. I am trying to a news base database for the company intranet and I am wanting to only show newsitems that are 7 days or less. And I want NOW() to set today date and then go back as far as seven days. But I am not sure now to use less than in my statement with NOW(), or if it will work. | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself.- Harvey Fierstein - 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 spanned over several systems
Try linux virtual server. You can Load Balance any port on a multitude of servers. Your MySQL Servers you would load balance would have to be read-only slaves though. We are currently running two linux virtual servers to load-balance same-port services on multiple servers with multiple Unix OSes. The Linux Virtual Servers are even clustering themselves for fail-over. -RG On Sat, 6 Apr 2002, Daniel Page wrote: Hi, I would like to try to implement a MySQL server that is spanned over several machines (a sort of database cluster) - as this is only a test, I am not too woried about the end OS, but I will probably use a Mandrake 8.1 or 8.2 Linux distribution. I have found in the manual information about running several servers on the same system, but nothing on running one (or several linked) servers that can run queries on a database distributed over several systems... Any information, passed experiences, or links to ressources on the web will be greatly appreciated. Cheers, Daniel - 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
dump stats? - Re: mysql monitoring
Has anyone though about writing an internal function to have MySQL dump database statistics into a flat file or database tables? -RG On 5 Apr 2002, Jason Yates wrote: Date: 05 Apr 2002 16:04:01 -0500 From: Jason Yates [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mysql monitoring Is there any sort of mysql load monitoring tools out there? If not how can I get how many query's per/sec, users, etc, which I can log to a flat file or db, and I could run rrdtool against it to get graphs? -Jason - 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: My.S.Q.L
Very fun ! - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 06, 2002 2:35 PM Subject: My.S.Q.L Ok... it's Saturday and I've been meaning to share this with a wider audience for years Antti, you'll probably remember this from when I sent this to you shortly after I wrote it (1999)... If anyone would like to record this, let me know! :-) My.S.Q.L (sung to Y.M.C.A by the Village People) Young man, service should not go down. I said, young man, when your data's to be found I said, young man, 'cause Larry Ellison's a clown there's no need to be unhappy. Young man, there's a place you can go. I said, young man, when you're short on your dough. You can use it, as a production database and it takes up a lot less space. It's fun to run MySQL It's fun to run MySQL It has everything for your code to enjoy You can port it to all your toys... It's fun to run MySQL It's fun to run MySQL You can download the source, it's really quite small. Bug fixes are out before the fall... Young man, do you want to pay a fee? I said, young man, this database is free. I said, young man, it helps the economy but you got to know this one thing! No man does it all by himself. I said, young man, it's not about the wealth. Freedom, is part of it of course, We like to call it the Open Source. It's fun to run MySQL It's fun to run MySQL - 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: SQL Question...
On Sunday, 7. April 2002 05:56, Chuck \PUP\ Payne wrote: Hi, I am trying to set up a SQL statement using NOW(), what I am wanting to do is to use NOW() then do a search on any date less than 7 days. Before I get several e-mails asking why. I am trying to a news base database for the company intranet and I am wanting to only show newsitems that are 7 days or less. And I want NOW() to set today date and then go back as far as seven days. But I am not sure now to use less than in my statement with NOW(), or if it will work. http://www.mysql.com/doc/D/a/Date_and_time_functions.html There is a sample how to use TO_DAYS function. Regards Georg - 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: My.S.Q.L
Being the Sys Admin for the Boise Family YMCA in USA Idaho I say thanks for sharingG MySQL rocks! To bad the H. O'Loughlin CEO dud didnt hear itG Wish I knew who his client was so they could hear it to and dump him. -Original Message- From: João Paulo Vasconcellos [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 06, 2002 6:00 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: My.S.Q.L Very fun ! - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 06, 2002 2:35 PM Subject: My.S.Q.L Ok... it's Saturday and I've been meaning to share this with a wider audience for years Antti, you'll probably remember this from when I sent this to you shortly after I wrote it (1999)... If anyone would like to record this, let me know! :-) My.S.Q.L (sung to Y.M.C.A by the Village People) Young man, service should not go down. I said, young man, when your data's to be found I said, young man, 'cause Larry Ellison's a clown there's no need to be unhappy. Young man, there's a place you can go. I said, young man, when you're short on your dough. You can use it, as a production database and it takes up a lot less space. It's fun to run MySQL It's fun to run MySQL It has everything for your code to enjoy You can port it to all your toys... It's fun to run MySQL It's fun to run MySQL You can download the source, it's really quite small. Bug fixes are out before the fall... Young man, do you want to pay a fee? I said, young man, this database is free. I said, young man, it helps the economy but you got to know this one thing! No man does it all by himself. I said, young man, it's not about the wealth. Freedom, is part of it of course, We like to call it the Open Source. It's fun to run MySQL It's fun to run MySQL - 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 - 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: VERY URGENT, possible bug. More on: What does this error message mean: InnoDB: Warning: difficult to find free blocks from the buffer pool..
Hi! MySQL AB and Innobase Oy entry-level support contract costs 3770 euros annually (3250 USD). For corporations with requirements for high availability we have more expensive telephone support options. These are extremely low priced compared against your costs for proprietary database products, and are low even when compared to rates charged by other open-source vendors. So please consider investing in a MySQL/InnoDB support contract. You will be served not by a help desk, but directly by the developers who author MySQL/InnoDB's source code. Information: http://www.mysql.com/support/index.html To Purchase: https://order.mysql.com/ About the buffer pool error: a similar bug in recovery was fixed in 3.23.45: ... November 17, 2001: In recovery InnoDB may go into an infinite loop constantly printing a warning message that it cannot find free blocks from the buffer pool. Fixed in 3.23.45. ... I have also a faint recollection that I then also fixed some additional error in the buffer pool flush algorithm which could cause the error messages to be printed in normal operation, not just recovery. Regards, Heikki Tuuri Innobase Oy - Original Message - From: JW [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, April 07, 2002 5:04 AM Subject: Re: VERY URGENT, possible bug. More on: What does this error message mean: InnoDB: Warning: difficult to find free blocks from the buffer pool.. I belive I have found a bug here, possibly. The last known commands to be run on the DB that are suspicious were a join between 2 tables. This is the info I got from the user who was workign on the DB: He was joining between keyword and billing select distinct(a.customerid) from cpcustomer.customerkeyword a left join cpbilling.billdetail b on a.customerid=b.customerid where b.customerid is null and active='y'; For some reason he hit ^c to exit (it didn't seem to be responding or somethign) He logged came back on to MySQL and ran: alter table add key bdetailcid (customerid); show create billdetail; It crashed (locked up) durning the last query mentioned above. I tried to shut down the server, but it wouldn't die so I ran the init-stop script a second time. It seems that the init start/stop script gets forceful on the second try. Started it back up, it took a _very_ long time recovering (InnoDB), then started in with the error message I first posted. Any ideas? I'm currently restoring from backups we'll see how it goes. Thanks. JW I forgot to point out that this is InnoDB JW JW I've searched Google and found the following disquiteing thing: JW http://www.innodb.com/oldbugs.html: JW JW Closed or old bug reports: Almost all of these bugs have been fixed. There are some old bug reports where the cause of the bug was never found, but because there have been no bug reports for newer versions of InnoDB, these reports are not considered actual any more. JW snip JW August 13, 2001: JW The fsync problem which was fixed in 3.23.40b and .41 could cause the following warning message on some Unix flavors: JW JW Innobase: Warning: difficult to find free blocks from JW Innobase: the buffer pool! Consider increasing the JW Innobase: buffer pool size. JW JW If you encounter the above message, upgrade to 3.23.41. JW JW However, I'm already using a newer vresion than that: JW JW ccs012:~ # rpm -qa |grep mysql JW mysql-shared-3.23.44-5 JW mysql-Max-3.23.44-5 JW mysql-devel-3.23.44-5 JW mysql-navigator-1.2.3-106 JW mysql-client-3.23.44-5 JW mysql-3.23.44-5 JW mysql-bench-3.23.44-5 JW ccs012:~ # JW JW This is a mission critical DB. Am I the lucky un-fortunate to re-dicover this supposedly fixed bug? JW JW JW I'm getting this error messge constantly in my error log: JW JW JW JW 020406 18:02:50 *** JW JW InnoDB: Warning: difficult to find free blocks from JW JW InnoDB: the buffer pool (200 search iterations)! Consider JW JW InnoDB: increasing the buffer pool size. JW JW InnoDB: It is also possible that in your Unix version JW JW InnoDB: fsync is very slow, or completely frozen inside JW JW InnoDB: the OS kernel. Then upgrading to a newer version JW JW InnoDB: of your operating system may help. Look at the JW JW InnoDB: number of fsyncs in diagnostic info below. JW JW InnoDB: Pending flushes (fsync) log: 0; buffer pool: 0 JW JW InnoDB: 5703 OS file reads, 502 OS file writes, 82 OS fsyncs JW JW InnoDB: Starting InnoDB Monitor to print further JW JW InnoDB: diagnostics to the standard output. JW JW JW JW Running SuSE Linux 7.3: JW JW JW JW ccs012:/var/lib/mysql # uname -a ; df -h ; free -m JW JW Linux ccs012 2.4.10-64GB-SMP #1 SMP Fri Sep 28 17:26:36 GMT 2001 i686 unknown JW JW FilesystemSize Used Avail Use% Mounted on JW JW /dev/sda7 67G 59G 8.2G 88% / JW JW /dev/sda5 63M 36M 26M 58% /boot JW JW shmfs
Re: Do any of your applications work?
On Sat, 6 Apr 2002 [EMAIL PROTECTED] wrote: I sense this could be a troll, but... /* Hugh O'Loughlin [[EMAIL PROTECTED]] writes: */ . . Frankly, the agreement your client should look at cancelling is the one with your company. Your inability to install MySQL notwithstanding, jumping into a public forum whining and crying that things don't work the way you think they should, providing little to no information on what doesn't work means in your case, and finally threatening that a CLIENT may cancel a licensing agreement... Sir, other words come to mind, Pompous twit? ;-) 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
Is it a bug in datetime function HOUR (now()-date_created) ?
mysql select date_created from forums; +-+ | date_created| +-+ | 2002-04-04 19:27:03 | +-+ 1 row in set (0.00 sec) mysql SELECT CONCAT(HOUR(now()-date_created), 'H', MINUTE(now()-date_created), 'M', SECOND(now()-date_created), 'S') AS dated_created from forums; +---+ | dated_created | +---+ | 282H24M24S| +---+ 1 row in set (0.00 sec) mysql select now(); +-+ | now() | +-+ | 2002-04-07 01:51:38 | +-+ 1 row in set (0.00 sec) Please ignore me for the 11 second different between the select CONCAT ... statement and the select now() The thing I would like to ask is something wrong with the function HOUR(now()-date_created) Why it yielded a wrong number of hours for the subtraction function ??? Son Nguyen __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.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: SQL Question...
On Sat, 06 Apr 2002 22:56:11 -0500, Chuck \PUP\ Payne wrote: Hello again, I am trying to set up a SQL statement using NOW(), what I am wanting to do is to use NOW() then do a search on any date less than 7 days. Before I get several e-mails asking why. I am trying to a news base database for the company intranet and I am wanting to only show newsitems that are 7 days or less. And I want NOW() to set today date and then go back as far as seven days. But I am not sure now to use less than in my statement with NOW(), or if it will work. you could try select someStuff where someOtherDate date_sub(now(), interval 7 day) -z - 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