FW:
-Original Message- From: Jonas Norrman [mailto:[EMAIL PROTECTED]] Sent: 15 March 2001 01:23 To: Andy Smith Cc: [EMAIL PROTECTED] Subject: Andy Smith [EMAIL PROTECTED] writes: Can you use a mysql database with drumbeat2000 a smith - 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
ARCHIVING UNDER HEAVY LOAD
Hello! There's a need to design a system (something like online forum) that will be storing huge amount of small messages in database. There must be fast access only to messages for the last 3 days (guess this means that main table with indexes on it must be kept small?), while other messages can be stored in rarely accessed archive (different table?). What's the best practice for implementing archiving in MySQL? In Oracle there's an ability to "switch off" part of the table and then move it to archive in background mode. What about MySQL? Thanks in advance, Alex - 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
ARCHIVING UNDER HEAVY LOAD
Hello! There's a need to design a system (something like online forum) that will be storing huge amount of small messages in database. There must be fast access only to messages for the last 3 days (guess this means that main table with indexes on it must be kept small?), while other messages can be stored in rarely accessed archive (different table?). What's the best practice for implementing archiving in MySQL? In Oracle there's an ability to "switch off" part of the table and then move it to archive in background mode. What about MySQL? Thanks in advance, Alex - 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: Columns named with the # character
Erling and MySQL guys, On Fri, Mar 16, 2001 at 02:18:55AM +0100, Erling Paulsen wrote: I just exported (via myodbc) an old access database for my sportsclub to mysql (the tables). The ms-access database application still works nicely on the new linked tables in mysql. However, I'm now also writing a php based client to use the database over the web and the problem is as follows: They guy that developed the access database used `#' (comment character) characters to name certain columns. i.e. "Person#". How can manually select such a column in a mysql query (ex. via the mysql client)? - since it seems whatever i enclose the column name in, the rest of the query is interpreted as a comment! The mysql client doesn't know about backticks and therefore handles the # (and '-- ') as the beginning of a comment. It wouldn't do that for quoted and double-quoted strings. I see no workaround other than to change the client/mysql.cc source and recompile. Line 983 of client/mysql.cc (in the add_line function) should be changed from: else if (!*in_string (inchar == '\'' || inchar == '"')) to else if (!*in_string (inchar == '\'' || inchar == '"' || inchar == '`')) This is for version 3.23.33. The line number may be different for other versions. If you want to see the correct continuation character for multi-line backticks, you would change a few occurrances in read_lines of: tee_fputs(glob_buffer.is_empty() ? "mysql " : !in_string ? "- " : in_string == '\'' ? "' " : "\" ",stdout); to tee_fputs(glob_buffer.is_empty() ? "mysql " : !in_string ? "- " : in_string == '\`' ? "` " : in_string == '\'' ? "' " : "\" ",stdout); I cc'ed this to the bugs mailing list, so it may be fixed in a next release. Looking at the sources, the MySQL server will handle this just fine, so your PHP scripts should run unless PHP does its own parsing of SQL. (I never use PHP, but I guess it does no such thing). Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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: ARCHIVING UNDER HEAVY LOAD
On Fri, Mar 16, 2001 at 12:17:41PM +0300, wrote: Hello! There's a need to design a system (something like online forum) that will be storing huge amount of small messages in database. There must be fast access only to messages for the last 3 days (guess this means that main table with indexes on it must be kept small?), while other messages can be stored in rarely accessed archive (different table?). What's the best practice for implementing archiving in MySQL? In Oracle there's an ability to "switch off" part of the table and then move it to archive in background mode. What about MySQL? Take a look at MERGE tables in the manual. With some Perl or other scripting, you can create a table for each day which you use to INSERT new messages. Create a MERGE table on the tables for the last three days which you use for your SELECTs. You can keep a separate MERGE table on the older tables. You might want to combine some per-day tables into a larger (per week or month) table before creating a MERGE table on them, because MySQL will have less tables to open then, which makes it faster. You also may want to optimize the older tables to speed things up. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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: Columns named with the # character
On Fri, Mar 16, 2001 at 10:33:05AM +0100, Fred van Engen wrote: The mysql client doesn't know about backticks and therefore handles the # (and '-- ') as the beginning of a comment. It wouldn't do that for quoted and double-quoted strings. I see no workaround other than to change the client/mysql.cc source and recompile. Oh yes, note that I didn't test these source changes, but they seem simple enough. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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 on NetApp Filer - Urgent Problem
Hi there, i dont want to start a thread about MySQL over NFS, i did it and it runs pretty good, but now there is a problem i could not solve. the cpu on the filer goes up and up (15% per day) and i have no idea why. At the moment it hit 70% in peak time (5 min average) Seems to be the database cause everything else stays the same, but not more traffic on the db + if i switch the db of the cpu goes down to 1-5%. any ideas about this? MySQL server: FreeBSD 4-Stable regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - 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 on NetApp Filer - Urgent Problem
Am 11:22 16.03.2001 schrieben Sie: *This message was transferred with a trial version of CommuniGate(tm) Pro* Hi there, i dont want to start a thread about MySQL over NFS, i did it and it runs pretty good, but now there is a problem i could not solve. the cpu on the filer goes up and up (15% per day) and i have no idea why. At the moment it hit 70% in peak time (5 min average) Seems to be the database cause everything else stays the same, but not more traffic on the db + if i switch the db of the cpu goes down to 1-5%. any ideas about this? MySQL server: FreeBSD 4-Stable regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - 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 i forgot: nfs ops and network traffic for the filer stayed the same Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - 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
Distributed Database
Hi, This maybe a recurring question, but can MySQL be configured to work as a distributed database? As a distributed database, I mean having the database spanning several servers. For example: Server 1 has 30 gb of free disk Server 2 has 50 gb of free disk Server 3 has 90 gb of free disk My database will be 140Gb, and has to be spanned over Server1, server2 and server3. Preferably, I would like to use Windows NT Server / 2000 Advanced Server, as we do not have the time to learn Linux at this time (and the company in question does not believe in free software, but that will change :) - a Linux or FreeBSD solution could be envisaged if needed - Would the installation of the database on an NFS volume be a solution? I no very little about NFS but it sounds interesting. Any and all input welcome! Cordially, Daniel Page - 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
Primary Key
Hi, Can i add the Primary key for a table after i created a table? and if this column is not null and auto_increment will there occur an error? t.i.a. regards denis - 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
mysqldump problem?
Short version: mysqldump seems to produce a "KEY mid(mid)" statement, which mysql does not understand. Using KEY (mid) instead of KEY mid(mid) works, though. Is this a known problem? Is this an oversight by me? Long version: kk@lenz ~ $ cat /etc/SuSE-release SuSE Linux 7.1 (i386) VERSION = 7.1 including all updates from ftp.suse.com, running mysql select version() as version; +-+ | version | +-+ | 3.23.32-log | +-+ 1 row in set (0.01 sec) kk@lenz ~ $ mysqldump test_passwd dokumentation # MySQL dump 8.12 # # Host: localhostDatabase: test_passwd # # Server version3.23.32-log # # Table structure for table 'dokumentation' # CREATE TABLE dokumentation ( did int(11) NOT NULL default '0', mid int(11) NOT NULL default '0', beschreibung text, filename varchar(255) NOT NULL default '', mimetype varchar(255) NOT NULL default '', changed timestamp(14) NOT NULL, PRIMARY KEY (did), KEY mid(mid) ) TYPE=MyISAM; # # Dumping data for table 'dokumentation' # kk@lenz ~ $ mysql test_passwd Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 35 to server version: 3.23.32-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql drop table dokumentation; Query OK, 0 rows affected (0.00 sec) mysql CREATE TABLE dokumentation ( - did int(11) NOT NULL default '0', - mid int(11) NOT NULL default '0', - beschreibung text, - filename varchar(255) NOT NULL default '', - mimetype varchar(255) NOT NULL default '', - changed timestamp(14) NOT NULL, - PRIMARY KEY (did), - KEY mid(mid) - ) TYPE=MyISAM; ERROR 1064: You have an error in your SQL syntax near 'mid(mid) ) TYPE=MyISAM' at line 9 but mysql CREATE TABLE dokumentation ( - did int(11) NOT NULL default '0', - mid int(11) NOT NULL default '0', - beschreibung text, - filename varchar(255) NOT NULL default '', - mimetype varchar(255) NOT NULL default '', - changed timestamp(14) NOT NULL, - PRIMARY KEY (did), - KEY (mid) - ) TYPE=MyISAM; Query OK, 0 rows affected (0.01 sec) Kristian -- Kristian Khntopp, NetUSE AG Siemenswall, D-24107 Kiel Tel: +49 431 386 436 00, Fax: +49 431 386 435 99 - 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: mysqldump problem?
Kristian Khntopp wrote: Short version: mysqldump seems to produce a "KEY mid(mid)" statement, which mysql does not understand. Using KEY (mid) instead of KEY mid(mid) works, though. Is this a known problem? Is this an oversight by me? Ultrashort resolution: kris is stupid and mid is a reserved word in MySQL. Thanks, Kristian -- Kristian Khntopp, NetUSE AG Siemenswall, D-24107 Kiel Tel: +49 431 386 436 00, Fax: +49 431 386 435 99 - 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: mysqldump problem?
This seems to be a competability feater, so you can load it into db2, oracle etc. "Kristian Khntopp" [EMAIL PROTECTED]@mail.netuse.de on 03/16/2001 01:06:30 PM Sent by: [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: mysqldump problem? Short version: mysqldump seems to produce a "KEY mid(mid)" statement, which mysql does not understand. Using KEY (mid) instead of KEY mid(mid) works, though. Is this a known problem? Is this an oversight by me? Long version: kk@lenz ~ $ cat /etc/SuSE-release SuSE Linux 7.1 (i386) VERSION = 7.1 including all updates from ftp.suse.com, running mysql select version() as version; +-+ | version | +-+ | 3.23.32-log | +-+ 1 row in set (0.01 sec) kk@lenz ~ $ mysqldump test_passwd dokumentation # MySQL dump 8.12 # # Host: localhostDatabase: test_passwd # # Server version3.23.32-log # # Table structure for table 'dokumentation' # CREATE TABLE dokumentation ( did int(11) NOT NULL default '0', mid int(11) NOT NULL default '0', beschreibung text, filename varchar(255) NOT NULL default '', mimetype varchar(255) NOT NULL default '', changed timestamp(14) NOT NULL, PRIMARY KEY (did), KEY mid(mid) ) TYPE=MyISAM; # # Dumping data for table 'dokumentation' # kk@lenz ~ $ mysql test_passwd Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 35 to server version: 3.23.32-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql drop table dokumentation; Query OK, 0 rows affected (0.00 sec) mysql CREATE TABLE dokumentation ( - did int(11) NOT NULL default '0', - mid int(11) NOT NULL default '0', - beschreibung text, - filename varchar(255) NOT NULL default '', - mimetype varchar(255) NOT NULL default '', - changed timestamp(14) NOT NULL, - PRIMARY KEY (did), - KEY mid(mid) - ) TYPE=MyISAM; ERROR 1064: You have an error in your SQL syntax near 'mid(mid) ) TYPE=MyISAM' at line 9 but mysql CREATE TABLE dokumentation ( - did int(11) NOT NULL default '0', - mid int(11) NOT NULL default '0', - beschreibung text, - filename varchar(255) NOT NULL default '', - mimetype varchar(255) NOT NULL default '', - changed timestamp(14) NOT NULL, - PRIMARY KEY (did), - KEY (mid) - ) TYPE=MyISAM; Query OK, 0 rows affected (0.01 sec) Kristian -- Kristian Khntopp, NetUSE AG Siemenswall, D-24107 Kiel Tel: +49 431 386 436 00, Fax: +49 431 386 435 99 - 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: mysqldump problem?
It is a known problem, I saw a bug report go through about it a day or so ago. One workaround I found is to rename the key. I think the problem may have something to do with the name of the key also being column name or a special token. In my case, I had: int User, key User(User) and I changed it to int USer, key UserKey(User) ...and it fixed the problem. So, you might try key midkey(mid) -bill At 01:06 PM 3/16/2001 +0100, Kristian Khntopp wrote: Short version: mysqldump seems to produce a "KEY mid(mid)" statement, which mysql does not understand. Using KEY (mid) instead of KEY mid(mid) works, though. Is this a known problem? Is this an oversight by me? Long version: kk@lenz ~ $ cat /etc/SuSE-release SuSE Linux 7.1 (i386) VERSION = 7.1 including all updates from ftp.suse.com, running mysql select version() as version; +-+ | version | +-+ | 3.23.32-log | +-+ 1 row in set (0.01 sec) kk@lenz ~ $ mysqldump test_passwd dokumentation # MySQL dump 8.12 # # Host: localhostDatabase: test_passwd # # Server version3.23.32-log # # Table structure for table 'dokumentation' # CREATE TABLE dokumentation ( did int(11) NOT NULL default '0', mid int(11) NOT NULL default '0', beschreibung text, filename varchar(255) NOT NULL default '', mimetype varchar(255) NOT NULL default '', changed timestamp(14) NOT NULL, PRIMARY KEY (did), KEY mid(mid) ) TYPE=MyISAM; # # Dumping data for table 'dokumentation' # kk@lenz ~ $ mysql test_passwd Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 35 to server version: 3.23.32-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql drop table dokumentation; Query OK, 0 rows affected (0.00 sec) mysql CREATE TABLE dokumentation ( - did int(11) NOT NULL default '0', - mid int(11) NOT NULL default '0', - beschreibung text, - filename varchar(255) NOT NULL default '', - mimetype varchar(255) NOT NULL default '', - changed timestamp(14) NOT NULL, - PRIMARY KEY (did), - KEY mid(mid) - ) TYPE=MyISAM; ERROR 1064: You have an error in your SQL syntax near 'mid(mid) ) TYPE=MyISAM' at line 9 but mysql CREATE TABLE dokumentation ( - did int(11) NOT NULL default '0', - mid int(11) NOT NULL default '0', - beschreibung text, - filename varchar(255) NOT NULL default '', - mimetype varchar(255) NOT NULL default '', - changed timestamp(14) NOT NULL, - PRIMARY KEY (did), - KEY (mid) - ) TYPE=MyISAM; Query OK, 0 rows affected (0.01 sec) Kristian -- Kristian Khntopp, NetUSE AG Siemenswall, D-24107 Kiel Tel: +49 431 386 436 00, Fax: +49 431 386 435 99 - 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++ binary RPM broken
Jerome Abela writes: I encountered a few problems with the genuine 1.7.8-1 binary RPM for mysql++. - If I compile: Connection con("temp","localhost","root","temp",3306,0,60,1,"",0); The linker complains: undefined reference to `MysqlConnection::MysqlConnection(char const *, char const *, char const *, char const *, unsigned int, char, unsigned int, bool, char const *, unsigned int)' - It seems the constructor is in the header, but not in the lib. - If I choose another constructor (like Connection con("temp")), I get a segfault: 406 result = *my_free_list; Current language: auto; currently c++ (gdb) where #0 mysql_ti_sql_type_info_lookup::mysql_ti_sql_type_info_lookup (this=0x40089e6 0, types=0x40089e80, size=62) at /usr/include/g++-2/stl_alloc.h:406 #1 0x40040356 in global constructors keyed to mysql_ti_sql_type_info_lookup::mysql_ti_sql_type_info_lookup () at type_info.cc:82 #2 0x4005ae44 in __do_global_ctors_aux () at null1.hh:16 #3 0x400342fe in ?? () at /usr/include/g++-2/std/bastring.cc:177 from /usr/lib/libsqlplus.so.1 However, if I compile it myself from the tarball, everything works fine... (My compiler is gcc-2.95.2) Jerome. HI! I am glad that when compiling from tarball works fine. Regarding the errors in RPM's we shall investigate. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
having problems with the Linux/IMP/Horde/Apache/PHP and MySql setup
Dear All, I am trying to build up a web based email setup on RedHat linux platform. And for that purpose I am using a solution comprising of IMP2.2/Horde1.2/PHP4/Sendmail/Apache Server and MySql. The problem is that although the MySql server is running, the PHP script cant connect to the server. When i tried to figure out the problem i came to know that the fuction "mysql_pconnect" cant seem to connect. Wonder what might be wrong. Abid Ghufran. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.35 is released
Michael Widenius wrote: Hi! The 3.23.35 mainly fixes a critical bug in 3.23.34 with ORDER BY. We don't know how the ORDER BY bug slipped through our testing suite or how fatal it's really is, but as we have got a couple of reports about core dumps regarding this, we recommend 3.23.34 users to upgrade as soon as possible. Sorry for the inconvenience. Changes in release 3.23.35 -- * Fixed newly introduce bug in `ORDER BY'. * Fixed wrong define `CLIENT_TRANSACTIONS'. * Fixed bug in `SHOW VARIABLES' when using INNOBASE tables. * Setting and using user variables in `SELECT DISTINCT' didn't work. * Tuned `SHOW ANALYZE' for small tables. * Fixed handling of arguments in the benchmark script `run-all-tests'. Hi All Thanks for this Monty - its a bit odd for me as only a few minutes ago I put off upgrading to 3.23.34a as I thought you would be releasing 3.23.35 soon - que twilight zone music On a more serious note, am I right in thinking the .35 release with the Gemini Table handler is moved to a .3x release as would seem the case ? On the off chance any ideas when this (A Gemini THandler) 3.23.x release may be and when we might see a public 4.x alpha. I know the answer will probably be "When its ready" but a small clue would be nice :-) Thanks for all your work. Greg Regards, Monty - 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: mysqldump problem?
[EMAIL PROTECTED] wrote: This seems to be a competability feater, so you can load it into db2, oracle etc. But not into MySQL - great idea. :-) Kristian -- Kristian Khntopp, NetUSE AG Siemenswall, D-24107 Kiel Tel: +49 431 386 436 00, Fax: +49 431 386 435 99 - 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: table + index repartition
Pascal THIVENT writes: Hi, I have to mananage a very big table (about 20 Go) A database correspond to a directory. A table correspond to a file. Is it possible to distribute the table on several physical partition (like with Oracle that can use several table space to store one table) ? Thanks, -- Pascal Thivent Hi! Did you say 20 Gb ?? How big is data file and how big is index file ?? If data file is a problem, you can use our RAID option. Anyway, if you would use SCSI RAID 10 (1 + 0), with many hard disks, you would not have to worry about speed. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: mysqldump problem?
"Kristian Khntopp" [EMAIL PROTECTED]@mail.netuse.de on 03/16/2001 02:02:28 PM ?Sent by: [EMAIL PROTECTED] ?To: [EMAIL PROTECTED] ?cc: [EMAIL PROTECTED] ?Subject: Re: mysqldump problem? ? ? ?[EMAIL PROTECTED] wrote: ? This seems to be a competability feater, so you can load it into db2, ? oracle etc. ? ?"Kristian Khntopp" [EMAIL PROTECTED] ?But not into MySQL - great idea. :-) ? ?Kristian ? ?-- ?Kristian Khntopp, NetUSE AG Siemenswall, D-24107 Kiel ?Tel: +49 431 386 436 00, Fax: +49 431 386 435 99 It's not an idea it is reality if IBM or ORACLE find a bug (wanze) (: -( cj - 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: SQLxxxx.ISM/ISD files in /tmp
Justin writes: For some reason I cannot figure, mysqld is now leaving loads of SQL.ISD/ISM files in /tmp/ .. perhaps 10 a minute.. there are no errors reported in the mysqld log file, other than one or two connection aborted every hour. the files are all owned by root, group root. /tmp is rwx word with t bit on. As far as I can guess this started with a linux kernel upgrade to 2.4.1 There seems to be no other ill effects from this -Justin Hi! What version of MySQL are you using and if it is 3.23, why don't you set MyISAM type as default ?? Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Can't connect to local MySQL server through socket '' (111)
CAL T. DEMIER writes: I get the subject error when running the static or semi-static linux builds on Mandrake 7.2. My database is working fine and I am able to use another client, KMySQLAdmin, without problems. Cal hi! You are probably referring to mysqlgui. In that case, please follow the following instructions from README that comes with any distro: When you start it for the first time, click on ``Options'' button, fill up all entries correctly and click on ``Save'' button. From then on, you will logon automatically to the running server on every mysqlgui startup. Take care to put the right value in ``Ask for password'' button. Also, if you have problems with location of socket files on *nix, enter a full path of the socket file in the ``SQL command on the start-up''. This input field is used on Windoze if you wish to specify that named pipe option. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: 3.23.33-3.23.34a crashing with panic from BDB handler
Scott McCool writes: I'm experiencing a problem where mysqld is crashing every time I run a particular query. The specific error from the client is: ERROR 1015: Can't lock file (errno: -30989) ERROR 2013: Lost connection to MySQL server during query The server error log is reporting: bdb: transaction has active cursors bdb: PANIC: Invalid argument mysqld got signal 11 At that point it either dumps core and dies (3.23.33) or restarts itself (3.23.34a), sometimes reporting errors on startup again in 3.23.34a. For the time being I have downgraded to 3.23.32, but before I fill out a bug report or send my whole database structure and query (basically the query that crashes things is working on bdb tables, but not as part of a transaction, it joins a total of 4 tables, all on a primary key column), I wanted to find out if anyone else has experienced a similar problem or could point me in the right direction. -Scott -- Scott McCool [EMAIL PROTECTED] (571)633-5749 -- Hi! We do need a repeatable test case in order to be able to fix problems like the above one. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
query speed issues
Hi, I have some huge databases generated from text file of a dictionary. I would like to know if I make a query based on a field which was not metion as a key at the creation of the table. Is the speed of the query affected by the size of the records and by the number of fields a record has? best regards, dacian - 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
Table Full Error
I tried to query below, "select src_ip, byte, packet from table group by src_ip order by bytes desc limit 10" Then DB said, "ERROR 1114: The table 'SQL2997368_0' is full." What is problem?
Re: shared library libz.a
Rudolf Schwaiger writes: Hallo MySQLers I have problems installing MySQL Version 3.23.33 on RS/6000 AIX4.3.3 Description: exec(): 0509-036 Cannot load program ../bin/mysqld because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive Where can i find a shared library with this module? I have searched the mail Archive, but in the suggested addresses i couldn't find it. best regards Schwaiger [EMAIL PROTECTED] Hi! libz.a is a static library, but you can find it on ftp.gnu.org. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: query speed issues
If you are repeatedly querying tables on non-key fields you can improve query speeds by implementing indexes on those fields... For instance, if you had a personnel table with the following fields: id, lastname, firstname, etc Where id was an auto-increment,primary key you could index the lastname field to aid queries based upon last names. Dacian Herbei [EMAIL PROTECTED] wrote: Hi, I have some huge databases generated from text file of a dictionary. I would like to know if I make a query based on a field which was not metion as a key at the creation of the table. Is the speed of the query affected by the size of the records and by the number of fields a record has? best regards, dacian - 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 -- === "If you put three drops of poison into a 100 percent pure Java, you get - Windows. If you put a few drops of Java into Windows, you still have Windows." -- Sun Microsystems CEO, Scott McNealy __ Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.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
problem
Hello, I'm running into the problem below when I run configure. Thanks, Hani Akil loading cache ./config.cache checking for a BSD compatible install... ./install-sh -c checking for bison... no checking for byacc... no checking for pdftex... no checking return type of sprintf... configure: error: can not run test program while cross compiling - 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
Acces And IP Problemes
I have a question about MySQL acces: In order to give access to any user on my server I have to give them "localhost', 'myserverName' and 'MyUserIP' entry in both user and db table, I thought I only had to set '%' in the user.Host columns and db.host = '192.168.111.%' to give access to my user for any computer on my network. If I do so, I have an error Access denied for user: 'le2k@'myserverName' (Using password: YES) then, I had a row with the same right except host that is 'myserverName' and then I have the same access denied exception with 'localhot' (Access denied for user: 'le2k@'localhost' (Using password: YES)) and if I had a row with 'localhost' then it work. This means that I have to add 3 row for one user where I though I could only set the IP branch. Could any one explain me, if I have to set 3 times the same right, is it a bug or do I mistake myself. My version is 3.22.32 Linux Red Hat 6.2 PII 400 256Mo Ram and 9 Go of Hard Drive. - 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
Mac OS X Binary libmysqlclient.a problem
I installed 3.23.27 for Mac OS X from the binaries. When installing PHP, I ran into problems with duplicate symbol names between libmysqlclient.a and System.framework. I also got a similar error building DBD::mysql. In both cases, the duplicate symbols were strto* functions. I built PHP with built-in mysql support to resolve it. When I built DBD::mysql and the problem came up again, I decided to try fixing it. I removed strto.o from libmysqlclient.a (along with a few other modules that ranlib complained were empty) and it built properly, tested successfully and seems to work properly. Is this a problem with the binary distribution, or am I missing something? Thanks, Geoff - 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
Error: MYSQL Connection failed
Hi there, First i have the mysql db on linux in /usr/local/ then i installed new on /var now i get the message: Warning: MYSQL Connection failed: Can't connect to local MYSQL Server through Socket '/var/lib/mysql/mysql.sock' (111) in /usr/local/httpd/htdocs/dbopen.php3 on line 8. This is the text from dbopen.php3: ? $server = "localhost"; // MySQL-Server $user = "root"; // MySQL-Nutzer $pass = "secret"; // MySQL-Kennwort // $conn = mysql_connect($server, $user, $pass); if($conn) { echo "BYes, we're open!/B Handle: $conn"; } else { echo "BOops, something goes wrong"; exit; } $select = mysql_select_db("name_of_db",$conn); ? Any Ideas? Thanks in advance Regards from cologne denis - 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: Table Full Error
On Fri, Mar 16, 2001 at 10:48:59PM +0900, Cho Bum Rae wrote: I tried to query below, "select src_ip, byte, packet from table group by src_ip order by bytes desc limit 10" Then DB said, "ERROR 1114: The table 'SQL2997368_0' is full." What is problem? It really helps to search the list archives. Below is a reply I sent to someone who asked the exact same question: I've seen this when MySQL uses an internal table for temporary data. There is a limit on the size of these tables. You can force MySQL to use a file in its temporary directory to store the results: set SQL_BIG_TABLES = 1; An alternative is to do a SELECT SQL_BIG_RESULT ... instead of SELECT ... . Note that SELECT SQL_BIG_RESULT doesn't work in 3.22.x, though it is accepted by the parser. You don't mention which version you use. 'set SQL_BIG_TABLES' works fine in 3.22.x. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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
What does this mean
Found this message from mysql in my root mailbox. What does it mean? "errors occured while rotating /var/lib/mysql/mysqld.log { ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' error running postrotate script" -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - 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
AW: Table Full Error
I tried to query below, "select src_ip, byte, packet from table group by src_ip order by bytes desc limit 10" Then DB said, "ERROR 1114: The table 'SQL2997368_0' is full." MySQL tries to create a temporary table to handle your "order by" command. These tables are usually created in /tmp (please correct me if i'm wrong). So check if /tmp is not null and writeable on your server. Jens - 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: question about NOT IN
On Fri, 16 Mar 2001, Jason Landry wrote: Subqueries like that won't work until version 4.0. for now it's rather ugly and inefficient, but one way you could do it would be like this: select table1.*, ifnull(table2.column2,-1) as marked from table1 left join table2 on table1.column1=table2.column2 having marked=-1 First when I read this I thought that you probably wanted 'where marked=-1' rather than 'having marked=-1' but yo are right ? I tried it with 'where marked=-1' and I got an error that it didn't know which one column 'marked' is. Strange... Anyway, some questions/comments: I tried doing a bulk load (load data infile...) of 1M rows in a single table with 100 columns. It took ~13mins. Then I tried doing an insert...select from a source table to my destination table, and it was over in ~1min. I though things would have been the other way around (seems everything I 'think of' today, us wrong :-) The other thing is that if a user has a password with spaces in the end of it, mysql trims of the trailing spaces before validating. So if my passwd is abcd and I give abdc[space], I still get granted access. I didn't like that :-( Would rather like to have trailing spaces. regards, thalis I've done something similar before, and it worked ok. Of course having subqueries will be nice. - Original Message - From: "Carl Karsten" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, March 16, 2001 12:13 AM Subject: Re: question about NOT IN select * from table1 where column1 not in (select column2 from table2) - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 7:13 PM Subject: question about NOT IN Please I would want how I can get the list of records from a table1 that do not appears on a table2, supossing a column e.g code is used as connector or joiner present at both tables; Thanks Ernesto - Este mensaje fue enviado a través de Qnet http://www.qnet.com.pe - 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
mysqldump bug?
Hi all, I don't know if this is a bug in mysqldump but it behaves in a strange way. I tried to use mysqldump to dump out the data and structure of a small database in order to populate another database but not all records are dumped. I tried to flush the tables from mysql server using FLUSH TABLES and also use mysqlamdin to refresh the database(by flushing tables the log files) but records are still missing from the dumped file. I have tried to shutdown and restart the database server but that didn't help. Is this a bug in mysqldump or there is some other things I have to do to get mysqldump dumps out the entire database with DDL DML statements? Thank you very much for your help. --Regards, Huy. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.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: What does this mean
On Fri, 16 Mar 2001 13:35:18 -0500, Hardy Merrill ([EMAIL PROTECTED]) wrote: Sure it's easier, but which is safer? I don't have Charles first message on this topic, but I believe his error message was from logrotate which is a cron job. If Charles put mysqladmin -uuser -ppassword into a cron job, then the user's(root?) password would be in open view to anybody who could view the crontab - granted, you would have to be root to view the root crontab, but putting the password to the MySQL user right in the cron command is just a little too "loose" for me. A safer method would be to "hide" the user/pw in the Unix user's home directory in the ..my.cnf file, as I outlined below. Uh... root can read those too. If you're imagining a situation where someone just rooted you in order to get access to MySQL, I guess it's possible that doing it this way will slow him down by about 5 minutes, but I don't really think it's an issue. - 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
Null pointer exception
Hi, I am using Resin-1.2.3 engine to run my servlet and mysql database with mysql-jdbc driverto connect to my database thru servlet ..but it shows following error message when I run my servlet 500 SERVLET EXCEPTION: java.lang.NullPointerException at Firstdb.doGet(Firstdb.java:52) at javax.servlet.http.HttpServlet.service(HttpServlet.java:102) at javax.servlet.http.HttpServlet.service(HttpServlet.java:83) at com.caucho.server.http.Invocation.service(Invocation.java:296) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:121) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:238) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:157) at com.caucho.server.TcpConnection.run(TcpConnection.java:140) at java.lang.Thread.run(Thread.java:484) My servlet engine is running all other servlets without database connectivity I hope many of you might have face this problem.please help me in fixing this prolbem... I am copying my servlet here public class Firstdb extends HttpServlet { public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException { Connection con = null; Statement stmt = null; ResultSet rs = null; res.setContentType("text/html"); PrintWriter out= res.getWriter(); try { //load driver Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //get connection con = DriverManager.getConnection("jdbc:mysql://localhost:8080/test"); //create statement stmt = con.createStatement(); //execute an sql query rs = stmt.executeQuery("SELECT * FROM employee"); out.println("HTMLHEADTITLEPHONE BOOK/TITLE/HEAD"); out.println("BODY"); out.println("UL"); while(rs.next()) { out.println("LI"+rs.getString(1)+" " + rs.getString(2) + " " +rs.getString(3)); } out.println("/UL"); out.println("/BODY/HTML"); } catch(ClassNotFoundException e) { out.println("couldn't load database driver:" +e.getMessage()); } catch(SQLException e) { out.println("SQLException caught:"+e.getMessage()); } catch(Exception e) { out.println("unable to load driver"); } try { // rs.close(); // stmt.close(); con.close(); } catch (SQLException ignored) { } } } Thanks Scott Decosta
Re[2]: [#Deleted] records in Access
Hello, CL Okay, the Access 97 vs. Access 2000 might have something to do with my CL particular problem now. I will check it using Access 97 later today. I CL know for a fact, however, that when I first found this problem, I was CL using Access 97 and the only thing that I changed was the MySQL version. Didn't you change Windoze version? (MDAC components maybe) Another thing I've found is a new article from M$ which describe this same problem not with M$SQL, but with Oracle... just guess what they say... "Cause: you have installed Office97 SP2 or Access 2000"!! This might mean that (if we're talking about the same problem) that you have applied SP2 to Access97? We had a computer with W95 Off97SR1 and it never failed. We setup W98 and Off97SP2 and the it began show #deleted. We didn't upgrade MySQL (3.22.32) CL I suppose if it still doesn't work right, I will just have to install CL some 3.22 version of MySQL. I didn't try to go back to Off97SP1. I'll post if I success. -- Roberto - 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
Problem with scripts/mysql_install_db
Description: When i tried to run scripts/mysql_install_db i received the error: ./bin/my_print_defaults: not found WARNING: The host 'wave.seachange.com' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! How-To-Repeat: scripts/mysql_install_db Fix: Submitter-Id: submitter ID Originator:msilva Organization: Sea Change Corporation MySQL support: [none | licence | email support | extended email support ] Synopsis: problem with mysql_install_db Severity: Priority: Category: mysql Class: Release: mysql-3.23.34 (Official MySQL binary) Environment: System: BSD/OS wave.seachange.com 4.0 BSDI BSD/OS 4.0 Kernel #0: Tue Jul 28 15:56:54 MDT 1998 [EMAIL PROTECTED]:/rel/proto/4.0-i386/usr/src/sys/compile/GENERIC i386 Some paths: /usr/bin/perl /usr/bin/make /usr/contrib/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: gcc version 2.7.2.1 Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -r--r--r-- 1 bin bin 1121298 Jul 29 1998 /usr/lib/libc.a -r--r--r-- 1 bin bin 31 Jul 29 1998 /usr/lib/libc.const -r--r--r-- 1 bin bin 1544 Jul 29 1998 /usr/lib/libc.except Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-named-z-libs=not-used --disable-shared Perl: This is perl, version 5.005_02 built for i386-bsdos - 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: Simple Multi-Master/Slave Fail-Over Set Up {Was Re: parallel Mysql ?}
You might want to take a look at this site: http://www.phpbuilder.com/columns/tanoviceanu2912.php3 --Patrick -Original Message- From: Van [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 15, 2001 8:02 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Simple Multi-Master/Slave Fail-Over Set Up {Was Re: parallel Mysql ?} Michael Widenius wrote: We plan to use the following algorithm on top of our current replication code to achieve this: http://www.fault-tolerant.org/recall/ Regards, Monty Greetings All: 2 Parts... Part 1: I reference the above because the Recall project hasn't had any activity since September 2000 and, after wasting 2 1/2 hours building the ACE and Pth dependencies want to know if MySQL still has interests in the Recall project, or just the algorithm, and, if so, what is the algorithm? This might seem a brain-dead question, but, what the Screenshots on the Recall web-site display looks promising and could have viable uses for a multi-node application; specifically a fail-over multi-node; multi-master/slave MySQL implementation. Unfortunately, recall-0.8 cannot be built on any of my systems. Part 2: Specifically, I'm building the following high availability configuration. I have two networks, and potentially others once the proof of concept is in place. The primary site runs several stand-alone MySQL applications for several domains on one server. Mostly web-server logging. So, this server needs to update itself. The second network will have 5 IP addresses and each will run a fully mirrored Apache/MySQL application server. Each will track it's own traffic. Additionally, I'd like it to update all other nodes with traffic activity. Unique ID's on auto-increment fields aren't a consideration. Each server will simply log the hit and notify each slave that it should update itself. Each node should be a master and a slave. If one slave goes down, it will be notified by the nearest (network distance; that is) master of the updates it needs. Since this slave is also a master, it will need to notify the nearest slave to replicate any data that was saved to the server that just came back up, if any. On paper it looks simple. Reading the master/slave implementation currently available, I don't see that the current state of replication can support this, but, perhaps the above algorithm is similar to the Recall algorithm. If so, what's necessary to do this, and, what are the complications in having each node be a slave and master and all nodes listen to each node for updates as well as notifying other nodes when updates are needed? Thanks for any useful thoughts. Best Regards, Van -- = Linux rocks!!! http://www.dedserius.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
Write conflict
Hello, all, I wonder if you guys can help me to solve this problem. In MS Access 2000, I get external data from a mysql database ,but I found I can't change the data in Access. Every time I try to change the data in Access, I got the following error message : This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made--- but the point is : I can't save the change. The "Save Record" button is blurred and does not function at all, and no one except me was using that DB at that time. Does anybody have any idea on this? Thanks a lot, Andrew CHEN
Re: Data modeling tool
On Wed, 14 Feb 2001, Dario Brignardello wrote: Hey! That's exactly what I'm working in... is your dia's parser GPLed ?? :-) It could help me a lot... Thanks in advance :-) I told folks at our local perl mongers ( http://norfolk.pm.org ) that I was working on packaging up what I had to send to you and someone pointed out that a dia to sql perl script already exists! http://www.karyopse.de/dia2sql/ I haven't tried it at all yet. I'd love to hear how people find it. -- /chris Those who cannot remember the past are doomed to buy Microsoft products. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to have a table very very big?
Thank you for your response (I said right?!? sorry for my little english!) what you say is very interesting!!! Where can I read more about RAID_TYPE ecc... (the 3 solution you said?)? Now I'm writing the program in C and I have not meet this problem but I will :-( Just for curiosity: I have to study the flow of data in a net : I'm working in a network desing. If somebody is doing that or is interested we can exchange experiences and suggestions. Thank you again. Mario. Il 16:51, gioved 15 marzo 2001, scrivesti: Hi Mario, I think I had the same problem as you, and got som help... You have three ways of doing this: 1. Switch to a FileSystem that supports bigger Files 2. Use MERGE, create a lot of small tables and use MERGE in you select Querys, The manual is quit god at explaining how to do this, but I'll think you will find the limitations about INSERT as irritating as I 3. Use the --with-raid option. This is what I do. You need to recompile the mysqld using --with-raid when configuering it. This way you can create tables Using: RAID_TYPE=1 RAID_CHUNKS=XX RAID_CHUNKSIZE=YY The RAID_CHUNKS tells the mysql how many separate files it will split the DB into. IE. RAID_CHUNKS=100 will create 100 datafiles, wich each can be 2GB = 2 000 GB. More about this in CREATE TABLE. The problem with this is the indexfile, wich now is the problem (max 2GB) But I'll will reach that in about 2 weeks so ill figure something out by then. /roger I have to store data for Internet desining (10-20 Gb at Day) so I have to use a data base very fast: MySql is fast? I have to put 10-20 Gb of data every day: but I can have a table only of 2Gb (I know that reading manual of Mysql). How to do a table so big? Thank you in advance, Rino. - 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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
Error with mysql configuration.
Dear All, I am trying to setup a web based email setup on RedHat Linux 7 platform. I am using Horde 2.2, Imp 1.2, Php 4, Apache 1.3 alongwith the following rpms required for the MySql setup: (I am running the entire setup on my single host for test purposes) 1) mysqlclient9-3.23.22-3 2) php-mysql-4.0.3pl1-1 3) mysql-server-3.23.22-6 4) horde-mysql-1.2.4-1rh7 5) mysql-3.23.22-6 Although the required version was 3.23.24 for mysql and mysql-server, these are not available at all the three ftp sites within my reach and mentioned in the "horde-latest.README": (ftp.horde.org, ftp.sunsite.org.net and ftp.sourceforge.net) Now the problem is as follows: When i try to check the test.php3 i get the following status of the installed modules (alongwith other information): IMAP Support: Yes. LDAP Support: No. MySql Support: Yes. PostgreSQL Support: No. (I have not yet configured LDAP and PostgreSQL.) But when i access "Click here to test PHPLIB for Horde" link i get this warning: Warning: Cant connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/horde-phplib/db_mysql.inc on line 73 I checked this code (at line 73) and found mysql_pconnect() thus i assume (on the basis of my limited knowledge) that the problem might be with the database server connection. The mysql.sock file exists. MySql server is running. I have also checked the error log file and there i found nothing except the usual start/stop entires. But I am unable to trace the update and binary log files. Imp: I have yet to configure the Imp setup through the setup.php3 file at my web site. I have all the db tables for the horde-phplib and imp (thru the mysql_create.sql command). I have intentionally put this much detail in this mail to give u a hint of the setup. All kind of thoughts are appreciated and anticapted. I am grateful to you for your concern and time. Thank you. Abid Ghufran. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: How to have a table very very big?
Hi again, Theres not much written in the manual about RAID_X but you'll find it under CREATE TABLE Thank you for your response (I said right?!? sorry for my little english!) what you say is very interesting!!! Where can I read more about RAID_TYPE ecc... (the 3° solution you said?)? Now I'm writing the program in C and I have not meet this problem but I will :-( Just for curiosity: I have to study the flow of data in a net : I'm working in a network desing. If somebody is doing that or is interested we can exchange experiences and suggestions. Thank you again. Mario. Il 16:51, giovedì 15 marzo 2001, scrivesti: Hi Mario, I think I had the same problem as you, and got som help... You have three ways of doing this: 1. Switch to a FileSystem that supports bigger Files 2. Use MERGE, create a lot of small tables and use MERGE in you select Querys, The manual is quit god at explaining how to do this, but I'll think you will find the limitations about INSERT as irritating as I 3. Use the --with-raid option. This is what I do. You need to recompile the mysqld using --with-raid when configuering it. This way you can create tables Using: RAID_TYPE=1 RAID_CHUNKS=XX RAID_CHUNKSIZE=YY The RAID_CHUNKS tells the mysql how many separate files it will split the DB into. IE. RAID_CHUNKS=100 will create 100 datafiles, wich each can be 2GB = 2 000 GB. More about this in CREATE TABLE. The problem with this is the indexfile, wich now is the problem (max 2GB) But I'll will reach that in about 2 weeks so ill figure something out by then. /roger I have to store data for Internet desining (10-20 Gb at Day) so I have to use a data base very fast: MySql is fast? I have to put 10-20 Gb of data every day: but I can have a table only of 2Gb (I know that reading manual of Mysql). How to do a table so big? Thank you in advance, Rino. - 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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
test
test - 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[3]: Innobase in MySQL
Hi! "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes: cyt Peter Well probably. But The problem is I can't backup database comfortable Peter way doing this (I can write a script of couse but there is one which Peter is doing almost the same thing and it's mysqldump) Peter so it looks like it wold be nice or for mysqldump to be able to Peter operate with load data infile format (you'll nead a number of files to Peter backup a database) or special format in which ou at first create Peter table without keys, then do all inserts into it and then do alter Peter table to add keys indeed. Try: mysqldump --tab=directory This does basicly what you want. After that, it's up to Heikki to fix Innobase to do delayed creation of indexes. Peter At least it would be a standart way to quickly backup data and recover Peter it for all table handlers (backup probably does not work for all tablr Peter types yet) Regards, Monty - 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
INNOBASE
Other than the (sparse) documentation in the manual, is there any other documentation available for INNOBASE files? Cal http://www.calevans.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.35 is released
Hi! "Greg" == Greg Cope [EMAIL PROTECTED] writes: Greg Michael Widenius wrote: Hi! The 3.23.35 mainly fixes a critical bug in 3.23.34 with ORDER BY. We don't know how the ORDER BY bug slipped through our testing suite or how fatal it's really is, but as we have got a couple of reports about core dumps regarding this, we recommend 3.23.34 users to upgrade as soon as possible. Sorry for the inconvenience. Changes in release 3.23.35 -- * Fixed newly introduce bug in `ORDER BY'. * Fixed wrong define `CLIENT_TRANSACTIONS'. * Fixed bug in `SHOW VARIABLES' when using INNOBASE tables. * Setting and using user variables in `SELECT DISTINCT' didn't work. * Tuned `SHOW ANALYZE' for small tables. * Fixed handling of arguments in the benchmark script `run-all-tests'. Greg Hi All Greg Thanks for this Monty - its a bit odd for me as only a few minutes ago I Greg put off upgrading to 3.23.34a as I thought you would be releasing Greg 3.23.35 soon - que twilight zone music Greg On a more serious note, am I right in thinking the .35 release with the Greg Gemini Table handler is moved to a .3x release as would seem the case Greg ? It's extremely likely that GEMINI tables will be in 3.23.36. I am going next week to meet the GEMINI developers to go through the GEMINI code and then we will push it into the 3.23 branch. Greg On the off chance any ideas when this (A Gemini THandler) 3.23.x release Greg may be and when we might see a public 4.x alpha. I know the answer will Greg probably be "When its ready" but a small clue would be nice :-) Lets guess a bit :) 3.23.36 with GEMINI should happen within 2 weeks. 4.0-alpha should happen within 2 months. Regards, Monty - 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
Netstat
Can anyone confirm that this is correct from a query of netstat? Should the sock be 'connected' instead of 'connecting'? I ask because although mysql is running in the proc list, it is not responding to any commands. unix 0 [ ACC ] STREAM LISTENING 87380 /var/lib/mysql/mysql.sock unix 0 [ ] STREAM CONNECTING0 /var/lib/mysql/mysql.sock Thanks, Jeff - 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: Simple Multi-Master/Slave Fail-Over Set Up {Was Re: parallel Mysql ?}
Patrick Calkins wrote: You might want to take a look at this site: http://www.phpbuilder.com/columns/tanoviceanu2912.php3 --Patrick Patrick: Thanks. Read through the whole howto. It looks like that's what I need. Hope it works with 5 master/slaves. :) Best Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on NetApp Filer - Urgent Problem
Am 17:21 16.03.2001 schrieb Jeremy D. Zawodny: *This message was transferred with a trial version of CommuniGate(tm) Pro* On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote: Am 11:22 16.03.2001 schrieben Sie: *This message was transferred with a trial version of CommuniGate(tm) Pro* Hi there, i dont want to start a thread about MySQL over NFS, i did it and it runs pretty good, but now there is a problem i could not solve. the cpu on the filer goes up and up (15% per day) and i have no idea why. At the moment it hit 70% in peak time (5 min average) Seems to be the database cause everything else stays the same, but not more traffic on the db + if i switch the db of the cpu goes down to 1-5%. any ideas about this? i forgot: nfs ops and network traffic for the filer stayed the same Then it would seem to be a problem with the netapp, wouldn't it? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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 Jeremy, Finally you where right. I refused to believe it but the filer itself was the problem. it was running out of inodes. damn, sorry for bothering you Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - 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
several problems
Why the user interface of MySQL is very difficult? Why is not more friendly like MS SQL Server user interface? I tried to use and configure MySQL and I get nothing.
MySQl // Access // ODBC
Hi, i read the manual. but i don't know what to do. I have a table. only 2 columns without a primary key. so i made the following: alter table 'tablename' add id auto_increment primary key; and alter table 'tablename' add Misc timestamp; But all fields are filled with #deleted. i don't have fields with float and i have the new mdac from microsoft. So, i don't know why this happens any ideas??? regards denis - 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: Failover and Replication [HOWTO]
Hi all , I recived few positive messages form the list , so I decided to make a public port of the whole thing . Why it could be used ? Before you start playing with all this game , you have to understand the limitations of my implementation . All this only allow you to have a sort of sql cluster for an web cluster for example where you can loose a server without any down time in your web cluster. So it give you all time you need to repair the broken server and bring it back on line . It does not provide any failover to the web part for that I recommend if you have few bucks to by an alteon or foundry loadbalancer , and it will do this kind of job very well , if you dont have any bucks go to the LVS . (i can help with exact alteon or foundry configurations) I'll build a step by step guide on what you need : 1) Dynamic Dns conf . all bind conf , and dyn updates 2) Mysql replication conf there is a lot of docs around :=) 3) Watch dog and failover update scripts I'll clean my code to make it more frindly for evry body . 4) Wrappers . Yes to use this kind of cluster you need a wrapper that will separate select querys and send them to the slave . I have wrappers in : Perl ( mod_perl friendly version ) (using apache::dbi) Java . Php . C/C++ (not finished yet ) 5) Set of scripts witch you should use to resync a server after a crash . With all this it should be good for you to wait for mysql team to release all this in a real cluster . (like sun oracle) I'll do all this as soon as possible . Very best Constantin Bogomolnyi - Original Message - From: [EMAIL PROTECTED] To: "Bogomolnyi Constantin" [EMAIL PROTECTED] Sent: Friday, March 16, 2001 1:50 PM Subject: Re: Failover and Replication [HOWTO] Hi Bogomolnyi, I would be interested in your scripts. I have been watching this conversation with interest. I have an application for exactly the same thing. I am going to have 3 mysql servers, which I would like to use as master and slaves. I also would like to know if it would work with web servers also? Edward 3/15/2001 12:14:21 AM, "Bogomolnyi Constantin" [EMAIL PROTECTED] wrote: Hi , I posted a few considerations about fialover implementation , to the list , but i don't recived any feed back , well lets see what we have : But i write a bunch of perl scripts and now I use them in production and very happy with the result . Here what I have : Baiscly what I want is an sql cluster (composed of min 2 servers ) that can survive a crash and still working . (we all want this ) so i set up a very simple replication between a master and a slave and I use an dynamic dns to locate slave master . like this : master.sql.corp.com192.168.1.100 slave1.sql.corp.com 192.168.1.101 slaveN.sql.corp.com 192.168.1.10N I have a wrapper that send all selects to the slaves and updates to the master i have an advanced watchdog that check if all sqls are up , and if : SLAVE FAIL : I simply updater the DNS to slave-1 and all applications still working the dns update is very quick (1sec) . MASTER FAIL : I simply update the DNS to the NEXT slave for the master and next slave for the slave (to avoid all selects on the master) I run change master to on all slaves , and the party keep going this works from 2 to N servers , I can setup an opensource project , and put all watchdog/dns update /setup stuff in it if any body is intrestead in this . I run this for 2 month and all goes very very well i'm very happy with this . My cluster is : 5 pc , and I use it for a web cluster (10 pc) so I use 1 slave for 2 httpds . For the moment after an server fail , i sync it back using a simple script , the watch dog don't do it because i dont want a buggy server coming in and out the party . I would be very happy to release all implementation . Very best Constantin Bogomolnyi - Original Message - From: "Bryan Coon" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 6:10 PM Subject: Failover and Replication Hi, We are implementing a linux cluster, and rather than get gouged by oracle (in performance and licensing) would much rather use MySQL. I searched through the archives and found several references to failover and replication but still have some questions. If I understand correctly, replication creates a working copy of mysql on another server, but it looks like the algorithm to automatically change slave to master if the master dies will not be added until mysql 4.x (from 11.4 in the manual). Is this still the case? Im not sure when that was written, perhaps there is news on this front? I also did not find a expected release date Does anyone have any stories/suggestions/experiences in regards to rolling our own monitoring script? Thanks! Bryan - Before
Re: INSERT records into multiple tables
Well, there's a few things. First, I think you need to do a few things to better normalize your data. You need a table to join a person with a job. It would look like this: create table peoplejob (people_id int not null, job_id not null) Then remove the job column from people. Then when you create a new person record, you'd do this: insert into people (4,Bob,'Teacher') insert into peoplejob (4,2) This will allow you to have people who have more than one job. If the job wasn't listed, you'd insert it and get the new id. From PHP, you'd do something like this ($link_id is the reference to you database connection) $person = "Jon" $jobsearch = "Doctor"; $result=mysql_query("select job_id from job where title='$jobsearch'",$link_id) or die(mysql_error()); if($row=mysql_fetch_array($result)) $job_id = $row["job_id"]; else { $result=mysql_query("insert into job values (null,'$jobsearch') or die(mysql_error());// assumes auto_increment $job_id = mysql_insert_id($link_id); } $result=mysql_query("insert into people (name) values ('$person')",$link_id) or die(mysql_error());// assumes auto_increment I just typed this in without trying it in any way, so don't tryo to run it as is -- but it should give you an idea. - Original Message - From: "Bryan Wheelock" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 16, 2001 3:46 PM Subject: INSERT records into multiple tables I'm just learning how to use MySQL and I am searching for a more simple way of doing an INSERT query into multiple tables simultaneously. I have done my best to nominalize my DB but that creates but I'm confused as to how to insert data into the DB and have all the related table be updated. I think that I can work out some way using conditional statements in PHP to insert the data into all the records, but I'm thinking there must be a more elegant and faster way of doing this. e.g. table people 1Bryanstudent 2Jill teacher 3 Bob student table job 1student 2teacher If I want to insert a record to table PEOPLE : insert into people values('4', 'Jon', doctor) How can I do this without having to also do a separate insert into table JOB? You need to Understand the rules so you can break them intelligently," the Dalai Lama - 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: INSERT records into multiple tables
you can't. You have to do 2 seperate inserts. (Sorry) Cal http://www.calevans.com -Original Message- From: Bryan Wheelock [mailto:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 3:47 PM To: [EMAIL PROTECTED] Subject: INSERT records into multiple tables I'm just learning how to use MySQL and I am searching for a more simple way of doing an INSERT query into multiple tables simultaneously. I have done my best to nominalize my DB but that creates but I'm confused as to how to insert data into the DB and have all the related table be updated. I think that I can work out some way using conditional statements in PHP to insert the data into all the records, but I'm thinking there must be a more elegant and faster way of doing this. e.g. table people 1Bryanstudent 2Jill teacher 3 Bob student table job 1student 2teacher If I want to insert a record to table PEOPLE : insert into people values('4', 'Jon', doctor) How can I do this without having to also do a separate insert into table JOB? You need to Understand the rules so you can break them intelligently," the Dalai Lama - 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 3.23.35 is released
Michael Widenius wrote: Hi! Greg On the off chance any ideas when this (A Gemini THandler) 3.23.x release Greg may be and when we might see a public 4.x alpha. I know the answer will Greg probably be "When its ready" but a small clue would be nice :-) Lets guess a bit :) 3.23.36 with GEMINI should happen within 2 weeks. 4.0-alpha should happen within 2 months. Regards, Monty Thanks Monty, your work is much appreciated by me and many others. I'm looking forward to a GEMINI 3.23.X and especially 4.0-alpha (when thier ready) Thanks again. Greg - 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: Innobase in MySQL
Michael Widenius wrote: Hi! Try: mysqldump --tab=directory This does basicly what you want. After that, it's up to Heikki to fix Innobase to do delayed creation of indexes. It would be very handy if Innobase (and the GEMINI when it comes along) where to support mysqldump in the standard way, as I assume it works as such and I and many others would have to change thier backup scripts. Delayed index creation is very usefull (in saving time) in larger DB loads via a mysqldump - Hiekki is this difficult ? Thanks all for your work. Greg Peter At least it would be a standart way to quickly backup data and recover Peter it for all table handlers (backup probably does not work for all tablr Peter types yet) Regards, Monty - 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: Please help me finding a sql-statement
HI, If I understand your question, you need two queries: select count(*) as count, ip, value from log group by ip select count(*) as count, ip, value from log group by ip,value that leads to the right direction! thanks! It shows me a the ips with their values and how many times they are in the table. That brings me somehow nearer to the solution but I am still getting mad about not finding exactly what I need (you know that feeling? its like having jam in the head!) I want to get the number of rows which have the same ip and same/different value. The questions are: 1. How many rows have same values for field x and y? 2. How many ips have different values for field x (and same field y)? (more interesting) Lets have a test-table: id value timestamp 1 a 1 a 2 a 2 b 3 a 3 a 3 b The queries should return in this case: 1. 4 rows (have same id/value) 2. 2 (ids have different values for for field 'value') As I am seeking differences here, after this it will be interesting to see a list of this 2 ids and their values: id val 2 a 2 b 3 a 3 b So I could make it to: There are 2 different values for id "2" : a,b There are 2 different values for id "3" : a,b Maybe you got an idea? Many thanks for your attention! A small table for testing: CREATE TABLE test ( id tinyint(1) DEFAULT '0' NOT NULL, value char(1) NOT NULL ); # # Dumping data for table 'test' # INSERT INTO test VALUES ( '1', 'a'); INSERT INTO test VALUES ( '1', 'a'); INSERT INTO test VALUES ( '2', 'a'); INSERT INTO test VALUES ( '2', 'b'); INSERT INTO test VALUES ( '3', 'a'); INSERT INTO test VALUES ( '3', 'a'); INSERT INTO test VALUES ( '3', 'b'); - 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
Problem: (54)Connection reset by peer: getsockname
Hello, I keep getting this error in my Apache error log: (54)Connection reset by peer: getsockname And in the MySQL error log I get: Aborted connection 78830 to db: 'paintballforum2' user: 'dojo' host: `10.10.1.2' (Got an error reading communication packets) I am running a web server and a DB server and using local IP's to connect between the two. I'm kind of stuck here. Anyone know what's causing the problem? Thanks for your time. Jim Murray PaintballDojo.com
Re: Please help me finding a sql-statement
Hi, something, that gets quite near to what I want is: select a.id, a.value, b.value from test as a left join test as b on a.id=b.id group by a.id, a.value having a.valueb.value; It spits out the right data, but not the way I want... ++---+---+ | id | value | value | ++---+---+ | 2 | b | a | | 3 | b | a | | 3 | c | a | | 3 | d | a | ++---+---+ Just a little bit closer... Have a nice thread, Peter - 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: Please help me finding a sql-statement
Hi, sometimes one has to have the feeling, that somebody wants to help to get it done better! :) I think I got it: select a.id, a.value from test as a left join test as b on a.id=b.id where a.value b.value group by a.id,a.value; Its good to check logtables! Of course I would appreciate suggestions of doing this better! Thanks for your help! Have a nice thread, Peter - 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: forwarded message from Van
Ok, I supposed Monty forwarded this to me so I could comment on it. Michael Widenius wrote: We plan to use the following algorithm on top of our current replication code to achieve this: http://www.fault-tolerant.org/recall/ Regards, Monty Greetings All: 2 Parts... Part 1: I reference the above because the Recall project hasn't had any activity since September 2000 and, after wasting 2 1/2 hours building the ACE and Pth dependencies want to know if MySQL still has interests in the Recall project, or just the algorithm, and, if so, what is the algorithm? This might seem a brain-dead question, but, what the Screenshots on the Recall web-site display looks promising and could have viable uses for a multi-node application; specifically a fail-over multi-node; multi-master/slave MySQL implementation. Unfortunately, recall-0.8 cannot be built on any of my systems. When I started to work on replication I had similar struggles with recall - I finally got it to work on its own and started to think about how it could work with MySQL when Monty called me and suggested that we first need to make it work a simple way - the master keeps the binary log while the slave connects, reads it, and does the updates. We still plan to use recall in 4.0, but we will just write an external agent that will issue SQL commands to elect the master and synchronize the slaves. Part 2: Specifically, I'm building the following high availability configuration. I have two networks, and potentially others once the proof of concept is in place. The primary site runs several stand-alone MySQL applications for several domains on one server. Mostly web-server logging. So, this server needs to update itself. The second network will have 5 IP addresses and each will run a fully mirrored Apache/MySQL application server. Each will track it's own traffic. Additionally, I'd like it to update all other nodes with traffic activity. Unique ID's on auto-increment fields aren't a consideration. Each server will simply log the hit and notify each slave that it should update itself. Each node should be a master and a slave. If one slave goes down, it will be notified by the nearest (network distance; that is) master of the updates it needs. Since this slave is also a master, it will need to notify the nearest slave to replicate any data that was saved to the server that just came back up, if any. On paper it looks simple. Reading the master/slave implementation currently available, I don't see that the current state of replication can support this, but, perhaps the above algorithm is similar to the Recall algorithm. If so, what's necessary to do this, and, what are the complications in having each node be a slave and master and all nodes listen to each node for updates as well as notifying other nodes when updates are needed? Thanks for any useful thoughts. Here is what you can do: server1 - server2- server3 - server4 - server5 - ^ | | | --- Arrows indicate master-slave relationships One "gotcha" is that you will have to generate record id yourself - auto-increment will not work - but this is not very hard - server 1 starts with 1, for example, server 2 with 2, ..., server 5 with 5, and each time you add 5 to the sequence number. You can accomplish this with a table that you *do not* replicate on each server called sequence: update sequence set id = last_insert_id(id + 5); insert into log (id, ...) values (last_insert_id(), ...); To do failover, use CHANGE MASTER TO on the slave of the failed master to point it to the next machine. The difficult part here is to decide which log/offset to start at and how to properly insert a recovered server into the chain - these problems are solvable, I just cannot solve them as I am composing the e-mail - need some time to think. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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: forwarded message from Van
On Fri, Mar 16, 2001 at 07:39:01PM -0700, Sasha Pachev wrote: Here is what you can do: server1 - server2- server3 - server4 - server5 - ^ | | | --- Arrows indicate master-slave relationships I tested a setup like that recently (with 3 servers) as a proof of concept for a project we're thinking about and found that it didn't quite work. But I didn't spend a lot of time debugging it, either... Was there a bug related to this sort of a setup that was fixed in a VERY recent version of MySQL? I noted a change in the logs for .33 or .34 but it wasn't very specific. Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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
logs of warnings
When I populate a table with a LOAD DATA LOCAL INFILE file, it says there are some warnings... where can I find these warnings? Are they in a log file? Thanks. Additional info, I'm using 3.23.32 on Redhat Linux 7.0. safe_mysql starts my server... Phil -- Insanity Palace of Metallica http://www.ipom.com [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
import out of MS SQL Server into mysql
Title: Blank Has any one heard of a good way to import from MS SQL Server into a new mysql database. I have a small (120 MB) database that I would like to convert to mysql and I was hoping that there was some sort of tool that will allow me to do it while maintaining the DDL Any suggestions are greatly appreciated Michael BloodMatraex Technologies[EMAIL PROTECTED]
Re: forwarded message from Van
On Friday 16 March 2001 19:46, Jeremy D. Zawodny wrote: On Fri, Mar 16, 2001 at 07:39:01PM -0700, Sasha Pachev wrote: Here is what you can do: server1 - server2- server3 - server4 - server5 - ^ | | | --- Arrows indicate master-slave relationships I tested a setup like that recently (with 3 servers) as a proof of concept for a project we're thinking about and found that it didn't quite work. But I didn't spend a lot of time debugging it, either... Was there a bug related to this sort of a setup that was fixed in a VERY recent version of MySQL? I noted a change in the logs for .33 or .34 but it wasn't very specific. There was a bug, actually - fixed in 3.23.33. When you have time to try it again, let us know how it went - in theory, everything should work, so if something does not, it is a bug. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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
error with mysql configuration.
Dear All, I am trying to setup a web based email setup on RedHat Linux 7 platform. I am using Horde 2.2, Imp 1.2, Php 4, Apache 1.3 alongwith the following rpms required for the MySql setup: (I am running the entire setup on my single host for test purposes) 1) mysqlclient9-3.23.22-3 2) php-mysql-4.0.3pl1-1 3) mysql-server-3.23.22-6 4) horde-mysql-1.2.4-1rh7 5) mysql-3.23.22-6 Although the required version was 3.23.24 for mysql and mysql-server, these are not available at all the three ftp sites within my reach and mentioned in the "horde-latest.README": (ftp.horde.org, ftp.sunsite.org.net and ftp.sourceforge.net) Now the problem is as follows: 1) When i try to check the test.php3 i get the following status of the installed modules (alongwith other information): IMAP Support: Yes. LDAP Support: No. MySql Support: Yes. PostgreSQL Support: No. (I have not yet configured LDAP and PostgreSQL.) But when i access "Click here to test PHPLIB for Horde" link i get this warning: Warning: Cant connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/horde-phplib/db_mysql.inc on line 73 I checked this code (at line 73) and found mysql_pconnect() thus i assume (on the basis of my limited knowledge) that the problem might be with the database server connection. The MySql server is running. File mysql.sock exists. The database for the horde-phplib and imp is created. The command "mysql mysql_create.sql" runs. I have the entire setup on a single machine for test purposes (i.e. MySql server, Apache Server and etc.). I have yet to run the cinfiguration file "setup.php3" on the horde directory of my web site. When i run "mysqladmin version" in the output i get that the localhost is connected via Unix sock, and when i run "mysqladmin -h `hostname` version variables" i get that the localhost is connected via TCP/IP port. I think that either the socket or the TCP/PI port should have been used, as given with the mysql configuration. I have given all the details intentionally to give you an idea of the the entire setup. All kind of thoughts are appreciated and anticipated. Thank you very much. Abid Ghufran. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
mysql on redhat 7.0
Dear Sir, We have installed redhat 7.0 server on one machine and want to run mysql server on that. The installation is default. After that only the root is allowed to connect to the server and if login as different user i am getting the error as error 111 connection refused. If anybody has started it then plese let me know. Waiting for the reply. Thank you, sanjeev - 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