RE: unix_timestamp doesn't understand year 2038
According to Bruce Perens (who came to speak at my office), the 2038 Bug is cured by redefining time_t as a 64 bit value and recompilingthen we'll be all set until the heat death of the universe :)) Regards, Gary Huntress Code 4113 Naval Undersea Warfare Center Newport, RI 02841 1-800-669-6892 x28990 -Original Message- From: Dinkler, Fred [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 1:14 PM To: Michael Meltzer Cc: Mysql List (E-mail) Subject: RE: unix_timestamp doesn't understand year 2038 UNIX version of Y2K problem... \\|// (@ @) ---oOO---(_)---OOo || | Fred Dinkler | | SVP Technology | | DFII Atlanta | | Office: 01.770.596.1443| || -- |__|__| || || ooO Ooo -Original Message- From: Michael Meltzer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 4:15 PM To: Theo Van Dinter; [EMAIL PROTECTED] Subject: Re: unix_timestamp doesn't understand year 2038 it not a bug, it is a feature, complain to Tomas Riche, 68 years (2038-1970) is all the seconds that fit in 2^31 or a signed long number, which is how the timestamp was defined a long time ago, it was always figured that some would change the base year sooner or later. Or the programmer view ;-) that I will be retired by then so it will be the next person problem, or better yet The software will last that long ha ha ha :-). I subspect someone with refine it to a 64 bit number one of these days. But this is not a bug. MJM - Original Message - From: Theo Van Dinter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 3:59 PM Subject: unix_timestamp doesn't understand year 2038 Description: unix_timestamp doesn't understand year 2038. How-To-Repeat: this works: select unix_timestamp(2037-12-31 23:59:59); this doesn't: select unix_timestamp(2038-01-01 00:00:00); Fix: unknown. everything through Jan 19 03:14:07 2038 GMT should be valid. Submitter-Id: submitter ID Originator: Theo Van Dinter Organization: Kluge.Net - WWW Access and Internet Education Network MySQL support: [none | licence | email support | extended email support ] Synopsis: unix_timestamp not handling year 2038 Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.39 (Official MySQL RPM) Environment: System: Linux eclectic 2.2.19 #1 Mon Apr 9 15:10:02 EDT 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/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-ex ceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Oct 6 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4101836 Jan 15 10:49 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20273324 Jan 15 10:49 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jan 15 10:49 /usr/lib/libc.so lrwxrwxrwx 1 root root 10 Nov 17 2000 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-clien t-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assemb ler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.so ck --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir= /usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/my sql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' Perl: This is perl, version 5.005_03 built for i386-linux - 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
RE: Re[2]: Reporting Tool : Linux?
It's not just the calculation of the reports, but also the presentation. PHP is certainly capable of producing nice reports. But tools like Crystal Reports have their place. If you can find me another tool that can easily produce publication quality reports (headers, footers, proper page breaks and page numbering etc) I'd like to hear about it! Regards, Gary Huntress Code 4113 Naval Undersea Warfare Center Newport, RI 02841 1-800-669-6892 x28990 -Original Message- From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 10:09 AM To: Mazur Cc: [EMAIL PROTECTED] Subject: Re[2]: Reporting Tool : Linux? I just figured I can't be the first guy on the block that wants to design reports out of MySQL without using Windows. I mean, I recall MySQL boasting that NASA uses MySQL...what the heck do they use for reporting? Of course, I suppose if you have MySQL on an NT machine, you can add Crystal Reports. I would never get the idea to use a tool for that. Why? First, you have to master the tool. Next, if you do, you can only do what the tool allows you to do. It is much easier to do your own reporting with php (or Perl, if you prefer that). It's a snap, and you can do anything you like. I guess, that's the way all the experts do it. Read the entertaining and instructive article at http://www.mysql.com/articles/wizard/ -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 ยท Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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 Problem
If you are truly getting 10k queries per second, that would imply to me a roughly comparable number of webserver connections (maybe within a factor of 2). If this is the case, I'd be amazed that it would work at all when hosted on a single box with "only" 256M of ram. I believe your problem is with the overall architecture of your system, not mysql specifically. I think that the first thing I would do is either add ram or move mysql to a dedicated server to try and distribute the load. Then I would consult some apache (I'm assuming thats what your running) performance and tuning guides. Also, I would examine the ratio of insert/updates to selects along with your use of indexing. Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 12:08 PM To: [EMAIL PROTECTED] Subject: MYSQL Problem Hi Everybody, We have a very popular greetings card site at http://gcards.com We recently switched to MYSQL as our backend database.. But recently we noticed that MYSQL cannot handle high load under normal installation. In our system we get more than 10,000 insert/update/delete/select queries per second sometime. And this creates the problem. Under this circumstances MYSQL failed to respond or get hanged. We have to restart MYSQL then. We are on a dedicated server with 256 MB of RAM and 10 GB disk space. We are trying to figure out the problem but if anybody could help on this that could be gr8. We've a good offer also for this. Whoever will solve this problem will get the source code of our card program FREE. Only dedicated and sound developer/engineer are need to be contacted in the following email address [EMAIL PROTECTED] Best Wishes, The Development Team http://www.gcards.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
RE: IT Inventory database needed.
There are quite a few hits here: http://freshmeat.net/search/?q=inventory Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org -Original Message- From: Sanborn, Ed [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 10, 2001 3:44 PM To: '[EMAIL PROTECTED]' Subject: IT Inventory database needed. Does anyone out there have a good inventory solution? I'm in search of a web-based inventory database that will be used by our internal IS department. Utilizing MySQL, Perl and/or PHP I'm trying to build a database that will allow us to track our IT equipment. I'd like the following features: Web-based - Solaris/Apache webserver / SQL backend database Multiple user w/authentication Ability to have multiple fields tracked (location, assett #, OS type, lease info, etc.) I want to have some fields filled in via pull-down menus. For example, If we have two popular manufacturers (Dell, Sun) I want to have the ability from the web browser to click on "Edit Manufacturers" and "edit my manufacturers list". After adding, say, Compaq to the list of manufacturers then Compaq now appears in the list of Manufacturers when I add a record. It is selectable now as well as the already defined Dell and Sun from the pull-down menu. Also, other fields (like popular cpu speeds, amounts of ram, location, OS versions, etc) will be similarly utilized. Add to this, I want to be able to run canned queries like: Give me all of the assetts in Andover. Giveme all the assetts in Andover that have WinNT 4.0 Workstation loaded. Give me all of the assetts in Andover whose maintenance agreement will expire in the next 3 months...etc. Does anyone have work in progress they would like to share? I have found a vendor that will sell me such a system but the price is hefty ($25,000+). -Ed Ed Sanborn(978) 691-6496 Manager of IT, Andover Alcatel fax (509) 277-3056 5 Corporate Drive Andover, MA. 01923 http://www.alcatel.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