Re: Is installation of MySQL C drive fixation?
No big deal. You can install MySQL in any directory or drive. (B (BYou just have to set path of your installation in the mySQL conf file. (B (BUnder MySQL Server Section -- Location, you point the directory to where the (BDb is installed. (B (Be.g. (B# location (Bbasedir = D:\database\mysql\ (B (BHope this helps. (B (BRegards, (B'Gbamila (B (B- Original Message - (BFrom: "Hiroyuki Iida" [EMAIL PROTECTED] (BTo: [EMAIL PROTECTED] (BSent: Thursday, November 07, 2002 8:33 AM (BSubject: Is installation of MySQL C drive fixation? (B (B (B Hi all, (B (B Although an impression which is useless is received as long as a manual is (B read, (B although he wants to install Mysql3.23.52 in Windows 98, may I install in (BD (B drive etc.? (B (B Thanks, (B (B Hiroyuki Iiida (B (B (B - (B Before posting, please check: (Bhttp://www.mysql.com/manual.php (the manual) (Bhttp://lists.mysql.com/ (the list archive) (B (B To request this thread, e-mail [EMAIL PROTECTED] (B To unsubscribe, e-mail (B[EMAIL PROTECTED] (B Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php (B (B (B (B (B- (BBefore posting, please check: (B http://www.mysql.com/manual.php (the manual) (B http://lists.mysql.com/ (the list archive) (B (BTo request this thread, e-mail [EMAIL PROTECTED] (BTo unsubscribe, e-mail [EMAIL PROTECTED] (BTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqladmin generates a segmentation error
From: jim To: [EMAIL PROTECTED] Subject: mysqladmin generates a segmentation error Description: getting segmentation error during execution of mysqladmin have recompiled using gcc3 with all the flags suggested in detail: tried to initialize with safe_mysql mysqladmin -u root -h Jungles.au --password xx error log follows: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=16773120 record_buffer=131072 sort_buffer=524280 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 80379 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x80890dc 0x8146e83 0x8169bbb 0x8166d94 0x816e83c 0x816d8bf 0x808f51f 0x808e3da :: and here are the results of resolving the stack trace 0x80890dc _Z15handle_segfaulti + 460 0x8146e83 __pthread_sighandler + 115 0x8169bbb __printf_fp + 123 0x8166d94 vfprintf + 7492 0x816e83c vsprintf + 124 0x816d8bf sprintf + 31 0x808f51f _Z10do_commandP3THD + 3055 0x808e3da _Z21handle_one_connectionPv + 842 error log continues :: Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... Number of processes running now: 1 mysqld process hanging, pid 29200 - killed 021107 10:59:44 mysqld restarted /usr/libexec/mysqld: ready for connections precise description of the problem (multiple lines) How-To-Repeat: make sure mysqld is really dead with killall safe_mysqld mysqldadmin -u root -h Jungles.au --password xx Fix: Submitter-Id: Jim Francis submitter ID Originator: as above Organization: Corus Consulting organization of PR author (multiple lines) MySQL support: none Synopsis: mysqladmin generates a segmentation error Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.53 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.53, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.53-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Lost Environment: machine, os, target, libraries (multiple lines) System: Linux Jungles.au 2.4.18 #1 Thu Sep 5 04:56:51 EST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make Compilation info: CC='gcc' CFLAGS=' -O2 ' CXX='g++' CXXFLAGS=' -O2 ' LDFLAGS=' -Wl,-rpath-link,/usr/gcc-3.2/lib' LIBC: lrwxrwxrwx1 root root 13 Oct 15 07:34 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1495992 Oct 15 07:34 /lib/libc-2.3.1.so -rw-r--r--1 root root 2543104 Oct 15 07:32 /usr/lib/libc.a -rw-r--r--1 root root 178 Oct 15 07:32 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --without-bench --enable-assembler --with-mysqld-ldflags=-all-static --localstatedir=/var/lib/mysql 'CFLAGS= -O2 ' 'CXXFLAGS= -O2 ' 'LDFLAGS= -Wl,-rpath-link,/usr/gcc-3.2/lib' - 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 dump error
ok i found the troubled table DROP TABLE IF EXISTS `activity`; CREATE TABLE `activity` ( `int_activity_id` int(11) NOT NULL auto_increment, `vch_uniqid` varchar(50) NOT NULL default '', `int_user_id` int(11) NOT NULL default '0', `ts_time` int(50) NOT NULL default '0', `vch_page_viewed` varchar(255) NOT NULL default '', PRIMARY KEY (`int_activity_id`), UNIQUE KEY `int_activity_id` (`int_activity_id`), KEY `vch_uniqid` (`vch_uniqid`) ) TYPE=MyISAM; wot could be the prob ? -Original Message- From: Dan Rossi [mailto:daniel;electroteque.org] Sent: Thursday, November 07, 2002 6:11 PM To: MySQL Mailing List Subject: Mysql dump error mysqldump: Got error: 1030: Got error 127 from table handler when retrieving data from server for some reason i get this when i dump all databases using mysqldump -p --all-databases --add-drop-table --quote-names all_databases.sql - 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: using libmysqld - can't connect to remote DB as client.
Hi, I didn't get your code but I haven't read all mails received through the night... But I these days don't find the time to analyze it. I've only once experimented with libmysqld so far and didn't enjoy it very much since the INNO-tables storing the table-linking-information, the transactions etc. are at least 20 MB. Am I wrong? Is there a configuration option making libmysqld consuming less hard-disk-space? Bernhard - Original Message - From: Steven Webb [EMAIL PROTECTED] To: Bernhard_Döbler [EMAIL PROTECTED] Cc: Mysql list [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 8:09 PM Subject: Re: using libmysqld - can't connect to remote DB as client. Did you get my code? I sent it to the list, but the list bounced it because the list didn't allow attachments. - 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
Host not allowed to connect problem
Hi, I am having a problem with Mysql 3.23.39 for solaris 2.6. I can do anything from the console command line but any connections from any other hosts causes a host xxx.xxx.xxx.xxx not allowed to connect to this mysql server. I have updated the host table to include a % for all hosts. Any suggestions Regards Tim - 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
[Newbie Q] csv file upload via php to mysql tutorial request
Hello listers My reason for emailing is this - I want to know how to upload a csv file via php to a mysql database. I have found a few examples but they are all much to advanced for my needs. I just want the bear basics so I can understand it. I can see that phpMyAdmin does this, which is great but I need it for joe public to be able to use. so I don't want them using phpMyAdmin. Just a few links to some tutorials would be marvellous. ;o) -- tia as always bfn .kristina [EMAIL PROTECTED] kfxdesign.net - 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 CPU usage skyrocketing
Hi,
I am running MySQL 3.23.41 on a FreeBSD 4.4, and I experience very high
loads of the machine, without any apparent reason. We have a new project
using this MySQL engine, with lots of inserts/deletes. But it happens that
in the mornings, when nobody makes any kind of access to the database, we
still have a MySQL daemon eating up 99% of CPU. If I log in as 'root' to
the mysql server and make a 'show processlist', the only process in the
'query' command is mine ('show processlist'), all the others are in sleep
mode (with NULL info). Is there any periodic maintanance/optimization work
that the mysql server is doing? If so, why does it take so long? Can I
schedule it sometimes during the night (and if so, how?)
Thanks,
bogdan
iCom Media AG
Kirchweg 36
Koln, 50858
Germany
Phone: +49-(0)221-485-689-16
Fax : +49-(0)221-485-689-20
Mobile:+49-(0)173-906-46-01
-
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 CPU usage skyrocketing
See links form mail list.
http://jeremy.zawodny.com/blog/archives/000203.html#000203
http://jeremy.zawodny.com/blog/archives/000264.html#000264
Simon
-Original Message-
From: Bogdan TARU [mailto:bgd;icomag.de]
Sent: 07 November 2002 10:35
To: [EMAIL PROTECTED]
Subject: MySQL CPU usage skyrocketing
Hi,
I am running MySQL 3.23.41 on a FreeBSD 4.4, and I experience very high
loads of the machine, without any apparent reason. We have a new project
using this MySQL engine, with lots of inserts/deletes. But it happens that
in the mornings, when nobody makes any kind of access to the database, we
still have a MySQL daemon eating up 99% of CPU. If I log in as 'root' to
the mysql server and make a 'show processlist', the only process in the
'query' command is mine ('show processlist'), all the others are in sleep
mode (with NULL info). Is there any periodic maintanance/optimization work
that the mysql server is doing? If so, why does it take so long? Can I
schedule it sometimes during the night (and if so, how?)
Thanks,
bogdan
iCom Media AG
Kirchweg 36
Koln, 50858
Germany
Phone: +49-(0)221-485-689-16
Fax : +49-(0)221-485-689-20
Mobile:+49-(0)173-906-46-01
-
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
Help with remote Administration
Hi - I have read extensively the MySQL database security chapter in SAMS TY MySQL - and I must be missing something. I have allowed myself to connect from any host by adding a % kev record to my users file and a 10.0.0.142 % record to my hosts file and a % % kev to my db file - when I try and telnet internally to the database I get Host '10.0.0.142 is not allowed to connect to this MySQL server. needless to say all the priv flags are set to 'Y' Is there something I need to do on setup - I can telnet to my Linux server then start mysql -p -u root no problem. I am trying to use mysql front to connect to the database on my pc and the database on the server so that I can transfer what's on my pc over to the Linux server. What have I missed. Thanks Kevin - 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 Closing Bug
CoastResearch, Thursday, November 07, 2002, 3:26:59 AM, you wrote: Caadc Description: Caadc If I launch MySQL 3.23.38, everything is fine. If I open tables, Caadc creat db, Caadc add records whatever, no problem. When I close MySQL my hard Caadc drive is ? alot and I can do nothing except a hard reboot. Caadc I have tried quitting immediatly after launching MySQLadmin and Caadc then there is no problem. but after I have connected and Caadc disconnected a few times and done stuff to my database this Caadc problem happens. 3.23.38 is a bit outdated version. Could you check it with latest version of MySQL server? (3.23.53) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: Is installation of MySQL C drive fixation?
Oluwagbamila, Thursday, November 07, 2002, 10:04:10 AM, you wrote: OO No big deal. You can install MySQL in any directory or drive. OO You just have to set path of your installation in the mySQL conf file. OO Under MySQL Server Section -- Location, you point the directory to where the OO Db is installed. OO e.g. OO # location OO basedir = D:\database\mysql\ Right, and don't forget to set up location for the data dir, too. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Mysql dump error
Dan, Thursday, November 07, 2002, 9:11:10 AM, you wrote: DR mysqldump: Got error: 1030: Got error 127 from table handler when retrieving DR data DR from server DR for some reason i get this when i dump all databases DR using mysqldump -p --all-databases --add-drop-table --quote-names DR all_databases.sql Error 127 means that record file is crashed. Repair table with myisamchk or REPAIR TABLE: http://www.mysql.com/doc/en/Repair.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Host not allowed to connect problem
Timothy, Thursday, November 07, 2002, 11:42:13 AM, you wrote: TV I am having a problem with Mysql 3.23.39 for solaris 2.6. I can do TV anything from the console command line but any connections from any TV other hosts causes a host xxx.xxx.xxx.xxx not allowed to connect to TV this mysql server. I have updated the host table to include a % for all TV hosts. You need to update table 'user' to allow user connect to from any host. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: mysql hangs, restarts on odbc connect
Sage, Wednesday, November 06, 2002, 3:31:21 PM, you wrote: S I'm running MySQL 3.23.49 on Red Hat 7.3, with the latest kernel S (2.4.18-17.7.x) installed. It is running in smp mode on a dual P3 1.0 S gHz. S MySQL works perfectly fine when connecting from the localhost. However, S I have another machine that needs to connect via ODBC. The ODBC client S can connect, but as soon as it does, the connection is suddenly closed. S The same thing happens if I try to telnet to port 3306 on the host S machine. S Every time this happens, I find the following entry in mysqld.log: S Number of processes running now: 1 S mysqld process hanging, pid 906 - killed S 021106 15:51:41 mysqld restarted S /usr/libexec/mysqld: ready for connections S I have no idea what is causing this. Does anyone have any suggestions as S to what might be the cause, or at least what I should double-check? Your problem is described here: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 You can downgrade glibc or install the patched one or install MySQL server v3.23.53a -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Host not allowed to connect problem
Hello Tim, Are you getting this regardless of what you put in user,host and db tables. If you are I am getting the same thing. Any access to my database is denied except from the console. How did you install - from the rpm's ?? I will watch this thread as I am at a complete standstill with MySQL on Linux - it runs fine on windows (not what you want to hear). Regards Kevin -Original Message- From: Timothy Venn [mailto:tim;optimus.co.za] Sent: 07 November 2002 09:42 To: [EMAIL PROTECTED] Subject: Host not allowed to connect problem Hi, I am having a problem with Mysql 3.23.39 for solaris 2.6. I can do anything from the console command line but any connections from any other hosts causes a host xxx.xxx.xxx.xxx not allowed to connect to this mysql server. I have updated the host table to include a % for all hosts. Any suggestions Regards Tim - 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
Success !!!
Hi all,
It now works
I did the following
Under the command line I did insert into user (Host) values
('192.168.8.19') and restarted mysql. I can now connect.
Thanks for the help.
Tim
-
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: Complicated (to me) query
What I want to do is display to the user a list of files that require a security level that is less than or equal to the user's security level, with formatted last name and first name and date if the file is checked out. Checked out by is a foreign key refering to username in the staff table, and the security level and required security level are also related. This is my attempt: SELECT file_name, CONCAT(last_name, ', ', first_name) AS name, DATE_FORMAT(date_checked_out,'%b %D, %Y (%r)') AS date FROM file LEFT JOIN staff ON file.checked_out_by = staff.username WHERE staff.username = 'mike' AND staff.security_level file.required_security_level; Your query won't do what you want because you are only selecting files that are checked out by mike (staff.username='mike'). You'll need two queries to do this. First, get the user's security level and store it in a user variable: select @SecLev:=security_level from staff where username='mike'; Then, you can do your left join as you've described above: SELECT file_name, CONCAT(last_name, ', ', first_name) AS name, DATE_FORMAT(date_checked_out,'%b %D, %Y (%r)') AS date FROM file LEFT JOIN staff ON file.checked_out_by = staff.username WHERE @SecLev file.required_security_level; By the way, when you're doing a left join, you should never include a column from the right table in your where clause. This is because the whole reason for doing a left join is to include rows that have no match in the right table, and any such rows will have all columns in the right table set to NULL. So, if you do a where condition on a column in the right table, you've just negated the effect of your left join (unless you're checking for IS NULL). - 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: Newbie: Intersecting entities
systems sys_nameID Abrams 202 Patriot 544 Stinger 229 ... and ... new_req proj_name ID Test Bed Alpha 344 Tracked Wheels 989 Battle Monitor 823 Shoulder Harness654 Ammo Flask 454 Spotter 773 There may be multiple new requirements for a single system. To accommodate them, I created a new table -- an intersecting entity is what I recall it being called -- to bridge the two. I can't keep the multiple references to new_req in the systems table, nor can I keep them in the new_req table. As best I can figure, I need to have a bridge table ... e.g., You mean a Many-to-Many or N-to-M join. IE, a system can be used in more than one project, and a project can have more than one system. ie_sys_req sys_id proj_name_id 202344 202989 202823 544654 544454 544773 If this seems peculiar, have patience with me I'm new at this. If it's right, let me know so I can breath a sigh of relief. And if the That is in fact how to implement an M-to-N relation in a relational database. Sigh away. :) structure is right, could someone offer some guidance on how a query that allows me to query new_req using the intersecting entity (or three-way join, whatever it's called) would be written. OK, so if you want to see all the systems involved in each project, do something like: select proj_name, sys_name from systems, new_req, ie_sys_req where new_req.ID=ie_sys_req.proj_name_id and ie_sys_req.sys_id=systems.ID If you'r going for speed, you're going to want an index on each column that contains an ID, so two indices in ie_sys_req. - 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 MySQL Works?
Unidux (S) - Han Lin wrote: I wanna know what the steps MySQL perform when we do INSERT in Database? Anyone can explain? Or anyone here have some reference about how MySQL works? The source code is freely available from the website; download it and take a read -- if you don't read C code, grab someone who does :). -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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 CPU usage skyrocketing
Ok, we know that FreeBSD has problems with its thread implementation;
however, I'd like to know if the MySql guys know exactly what causes the
problems to which Mr Zawodny refers.
I'm running FreeBSD 4.6.2, and have seen the 'rogue thread' problem before
which leads me to believe that either FreeBSD has not addressed the problem
or MySql hasn't. To be fair MySql says in its documentation that FreeBSD is
not recommended because of its threading implementation.
Furthermore, I wonder if anyone has been working with MySql and FreeBSD 5.0
DP1 and, if so, what behavior they've experienced.
Peter
^_^
-Original Message-
From: Simon Green [mailto:sgreen;eurobell.net]
Sent: Thursday, November 07, 2002 6:04 AM
To: 'Bogdan TARU'; [EMAIL PROTECTED]
Subject: RE: MySQL CPU usage skyrocketing
See links form mail list.
http://jeremy.zawodny.com/blog/archives/000203.html#000203
http://jeremy.zawodny.com/blog/archives/000264.html#000264
Simon
-Original Message-
From: Bogdan TARU [mailto:bgd;icomag.de]
Sent: 07 November 2002 10:35
To: [EMAIL PROTECTED]
Subject: MySQL CPU usage skyrocketing
Hi,
I am running MySQL 3.23.41 on a FreeBSD 4.4, and I experience very high
loads of the machine, without any apparent reason. We have a new project
using this MySQL engine, with lots of inserts/deletes. But it happens that
in the mornings, when nobody makes any kind of access to the database, we
still have a MySQL daemon eating up 99% of CPU. If I log in as 'root' to
the mysql server and make a 'show processlist', the only process in the
'query' command is mine ('show processlist'), all the others are in sleep
mode (with NULL info). Is there any periodic maintanance/optimization work
that the mysql server is doing? If so, why does it take so long? Can I
schedule it sometimes during the night (and if so, how?)
Thanks,
bogdan
iCom Media AG
Kirchweg 36
Koln, 50858
Germany
Phone: +49-(0)221-485-689-16
Fax : +49-(0)221-485-689-20
Mobile:+49-(0)173-906-46-01
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access replacement...
Brad wrote: A programming environment; Python comes to mind immediately; very easy to learn, especially compared to VB, and its even Windows compatible (MFC even). A database maintenance utility; To what end? A database query tool; Visual query tools exist for MySQL already; someone keeps posting the name of one from time to time ... A report builder Any report program that works from ODBC will work. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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 MySQL Works?
Hi Michael, Thanks for your suggestion, but I didn't read C code, and I don't think so someone in this list will:) Maybe short explanation from you also can:) Regards, Han Lin - Original Message - From: Michael T. Babcock [EMAIL PROTECTED] To: Unidux (S) - Han Lin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 9:45 PM Subject: Re: How MySQL Works? Unidux (S) - Han Lin wrote: I wanna know what the steps MySQL perform when we do INSERT in Database? Anyone can explain? Or anyone here have some reference about how MySQL works? The source code is freely available from the website; download it and take a read -- if you don't read C code, grab someone who does :). -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: load data infile syntax
If the data contains \, then database will automatically takes \ away and shift 1 byte left. My data will mass up. That is why I still need \ Does your data actually include backslash characters? If you want to import them as they are, you definitely don't want to ESCAPE BY them. Escaping is used to treat otherwise special characters as nonspecial. For example, quotes and commas have special meaning in some text files, but you can 'escape' the special interpretation by using a scheme like prefixing them with a character that's more special than they are. The prefix is usually a backslash, which means that if you really do want a backslash, you need to use two of them (the first one says to treat the next character in a different way than usual). So the moral of the story is this: If you're trying to import backslashes into an SQL table, and your text file doesn't have backslashes doubled, don't choose a backslash as your ESCAPE BY character. - 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: Character-sets
Michelle, Wednesday, November 06, 2002, 4:25:32 PM, you wrote: MdB If I want to create a database with an arabic MdB character-set, will only the data-cells be affected by MdB this or will the table names, column names etc also be MdB in arabic? You can use characters from current character set in table, column names: http://www.mysql.com/doc/en/Legal_names.html Unfortunatly MySQL doesn't have arabic character set, in this case you can use `` around table names. MdB Can I mix two character-sets (English and Arabic) in MdB the same database, or does it have to be in two MdB separate databases? You can store data in different character set, but sort order may be wrong for arabic characters. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: DateTime comparation problems
Andrew, Wednesday, November 06, 2002, 7:39:16 PM, you wrote: AS SELECT ... FROM table o WHERE o.date = 2002090100 AND o.date=2002110624 AS MySQL 3.23.xx - work (returns 0 rows) AS MySQL 4.0.4 - not work (returns 0 rows) AS P.S. also in 4.0.4 not work BETWEEN in this case (but as i can AS see it will be fixed in next release) Hi! Thank you for bug report! Seems, it also was fixed in 4.0.5. Could you test it at the next week on 4.0.5? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB recovery
Heikki Tuuri wrote: if you have on tape old images of ibdata files and ib_logfile's, you can try crash recovery from them, possibly using innodb_force_recovery=6. Unfortunately, as mentionned, I only have the data files on tape, no log files. Are the data files 'dumpable' ?? SQL -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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 table as Perl Queue
I've done a specialized, high-volume FIFO queue implementation using MySql that performs extremely well - if your concern is speed I think you'll likely do fine. Of course, speed is relative to each solution - what kind of response time for enqueue/deque operations do you require? In my situation, we enqueue in less than 1 ms on average and dequeue speed depends somewhat on queue depth (but it's not much different). regards, Rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InnoDB row level locking?
-Original Message- From: Fernando Grijalba [mailto:fernando;ggtours.on.ca] Sent: Wednesday, November 06, 2002 11:41 AM To: MySQL Help Subject: InnoDB row level locking? In the documentation it says that InnoDB supports row level locking. How can I ensure that rows are locked using ADO in a VB Applications communicating with MySQL through MyODBC? I have tried setting my Recordsets to adLockPessimistic, but that does not seam to work. Make sure you are working inside transactions. then add this text to the end of your select statments FOR UPDATE This will ensure that no one else updates after you have selected the record. But it will still let others read. Commiting your transaction will release the lock. sean. - 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: mysqld_multi
Yes, that is what I meant. Thank you for the clarification and response. Any ideas on maximizing *server* performance besides the usual db-specific optimizations like indexing? If not too much trouble, could you give me a brief explanation why I would not see a performance boost if running separate servers on the same box? My thoughts, if have one MySQL server running on one box with 10 databases, and 1 or 2 of those databases are getting the majority of the requests and tying up the processes, seems like the other 8 would suffer. - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED] Cc: Raymer, Chris [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 12:42 AM Subject: Re: mysqld_multi On Wed, 6 Nov 2002, Paul DuBois wrote: At 13:22 -0600 11/6/02, Raymer, Chris wrote: Any opinions on running mysqld_multi? Our architecture, X-serve, 2GBs RAM,Dual Procs, 480 GB stogage as Master MySQL server replicated to a less impressive server. Seems logical to separate the heavy-hitter dbs to their own servers and take more advantage of the server's resources. What's this got to do with mysqld_multi, which is used for running multiple servers on the *same* machine? Hi! Maybe Mr. Raymer means that he would get more performance when running multiple _MySQL_ servers (i.e. instances) on a same _physical_ server (i.e. box). Getting more performance this way is unfortunately a false assumption, though. More stability, perhaps, but not performance. Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Newbie: Intersecting entities
On Wed, 2002-11-06 at 23:25, Richard Forgo wrote: Sorry for being vague. I think the closest thing I can find to it is, possibly, a three-way join. I'm trying to figure out how to write the query. I've got the following tables: systems sys_nameID Abrams 202 Patriot 544 Stinger 229 ... and ... new_req proj_name ID Test Bed Alpha 344 Tracked Wheels 989 Battle Monitor 823 Shoulder Harness654 Ammo Flask 454 Spotter 773 There may be multiple new requirements for a single system. To accommodate them, I created a new table -- an intersecting entity is what I recall it being called -- to bridge the two. I can't keep the multiple references to new_req in the systems table, nor can I keep them in the new_req table. As best I can figure, I need to have a bridge table ... e.g., ie_sys_req sys_id proj_name_id 202344 202989 202823 544654 544454 544773 If this seems peculiar, have patience with me I'm new at this. If it's right, let me know so I can breath a sigh of relief. And if the structure is right, could someone offer some guidance on how a query that allows me to query new_req using the intersecting entity (or three-way join, whatever it's called) would be written. Thanks, Rik Forgo JIST3 Army Test, Training and Technology Integration Office (T3I) Diverse Technologies Corp. (c) 443.463.8571 (h) 410.859.8474 -Original Message- From: John Ragan [mailto:jragan;arkansas.net] Sent: Wednesday, November 06, 2002 6:55 PM To: [EMAIL PROTECTED]; Richard Forgo Subject: Re: Newbie: Intersecting entities if a succinct statement is possible, perhaps you could give us an idea of its nature? somebody may be familiar with the concept under a different name. I'm trying to find some documentation on creating intersecting entities in MySQL, but haven't been able to track any info down on the MySQL site or on the web. At least we called them intersecting entities while I was in Oracle training (which was some time ago). I think I remember how to set them up, but I'd love to have something to refer to quickly before I start. Can anyone point me in the right direction? There is an example and full blown script in a book by Michael Koffler called MYSQL. His Url is www,Kofler.cc If I remember it correctly he had a intersecting entity involving Authors and Publishers in his mylibrary example. John Coder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB recovery
Michael, - Original Message - From: Michael T. Babcock [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 4:36 PM Subject: Re: InnoDB recovery Heikki Tuuri wrote: if you have on tape old images of ibdata files and ib_logfile's, you can try crash recovery from them, possibly using innodb_force_recovery=6. Unfortunately, as mentionned, I only have the data files on tape, no log files. Are the data files 'dumpable' ?? log files are as important a part of a database as ibdata files. You can try using some dummy log files from another installation and set force recovery to 6 to skip the log scan. SQL -- Michael T. Babcock Regards, Heikki C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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
Snort ACID (from CERT)
Has anyone else using Snort with CERT's ACID (Analysis Console for Intrusion Databases) reporting software (PHP) done work on optimizing their tables? I've found a few instances where TEXT was used instead of VARCHAR unnecessarily and prevented indexes from being created, etc. Any other tips? http://www.cert.org/kb/aircert/ http://www.snort.org/ SQL. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB recovery
Heikki Tuuri wrote: log files are as important a part of a database as ibdata files. Trust me, I know; they didn't get backed up I've realized too late though ... You can try using some dummy log files from another installation and set force recovery to 6 to skip the log scan. ... what's the minimum configuration I need to set up to get a parallel copy of MySQL running (or on a different machine?) with those data files? If I just specify the data files with the same sizes and log directory (bringing in fake logs), will it work, or do I need additional information for MySQL to know what's going on? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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 MySQL Works?
Hi, if you dont understand the language mysql is written in you are probably not interested in how it works, technically. this perspective can only be explained by using terms from the programming language. i guess you are interested in learning more about the user-level, like how to set it up and how to do a query and this stuff. just go read the documentation at www.mysql.com. good luck, philipp - Original Message - From: Unidux (S) - Han Lin [EMAIL PROTECTED] To: Michael T. Babcock [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 3:06 PM Subject: Re: How MySQL Works? Hi Michael, Thanks for your suggestion, but I didn't read C code, and I don't think so someone in this list will:) Maybe short explanation from you also can:) Regards, Han Lin - Original Message - From: Michael T. Babcock [EMAIL PROTECTED] To: Unidux (S) - Han Lin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 9:45 PM Subject: Re: How MySQL Works? Unidux (S) - Han Lin wrote: I wanna know what the steps MySQL perform when we do INSERT in Database? Anyone can explain? Or anyone here have some reference about how MySQL works? The source code is freely available from the website; download it and take a read -- if you don't read C code, grab someone who does :). -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newbie: Intersecting entities
aha! sure. you weren't being vague. you just needed to educate me. some of us have used intersecting entities through the years, but didn't know that there was a fancy name for what we were doing. if my memory weren't so bad, i'd use it to impress people in the next interview. in this case, simply do a three way multiple join with the intersecting entity in the middle. something like this: select table1.col2, table 3.col2 from table1 left join table2 on table1.col1 = table2.col1 left join table3 on table2.col2 = table3.col1 or you could use an equal join with the intersecting entity in the middle. if you have a windows box that you can use as a front end, i strongly recommend that you download corereader because its point and click queries can make a six way join look simple. then, it'll show you the sql code. best of all is that it's free. http://corereader.com Sorry for being vague. I think the closest thing I can find to it is, possibly, a three-way join. I'm trying to figure out how to write the query. I've got the following tables: systems sys_nameID Abrams 202 Patriot 544 Stinger 229 ... and ... new_req proj_name ID Test Bed Alpha 344 Tracked Wheels 989 Battle Monitor 823 Shoulder Harness654 Ammo Flask 454 Spotter 773 There may be multiple new requirements for a single system. To accommodate them, I created a new table -- an intersecting entity is what I recall it being called -- to bridge the two. I can't keep the multiple references to new_req in the systems table, nor can I keep them in the new_req table. As best I can figure, I need to have a bridge table ... e.g., ie_sys_req sys_id proj_name_id 202344 202989 202823 544654 544454 544773 If this seems peculiar, have patience with me I'm new at this. If it's right, let me know so I can breath a sigh of relief. And if the structure is right, could someone offer some guidance on how a query that allows me to query new_req using the intersecting entity (or three-way join, whatever it's called) would be written. Thanks, Rik Forgo JIST3 Army Test, Training and Technology Integration Office (T3I) Diverse Technologies Corp. (c) 443.463.8571 (h) 410.859.8474 -Original Message- From: John Ragan [mailto:jragan;arkansas.net] Sent: Wednesday, November 06, 2002 6:55 PM To: [EMAIL PROTECTED]; Richard Forgo Subject: Re: Newbie: Intersecting entities if a succinct statement is possible, perhaps you could give us an idea of its nature? somebody may be familiar with the concept under a different name. I'm trying to find some documentation on creating intersecting entities in MySQL, but haven't been able to track any info down on the MySQL site or on the web. At least we called them intersecting entities while I was in Oracle training (which was some time ago). I think I remember how to set them up, but I'd love to have something to refer to quickly before I start. Can anyone point me in the right direction? Rik Forgo JIST3 Army Test, Training and Technology Integration Office (T3I) Diverse Technologies Corp. (c) 443.463.8571 (h) 410.859.8474 -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.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
how to Load Test Master-Slave Architecture ?
Hi, I have configured a master slave ring architecture. Can anyone suggest me how to load test this architecture ? I am using three MySQL servers in the following fashion : A -- B -- C -- A where A is the Master to B, B is the Master to C and C is the Master to A. My aim is to distribute the database load equally on the three MySQL servers. Please suggest me some way to do it. Thanks Akash Agarwal Senior Member Technical Staff, Intersolutions Pvt Ltd, NOIDA, INDIA (www.lotusinterworks.com) (www.alacre.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: Access replacement...
i've been hesitant to respond because i'm not sure that this is a head on solution for you, but take a look at http://corereader.com it's certainly easier to use than access queries. simple point and click to build complex output. however, it's not designed for the fancy formatted output to which your folks are accustomed. it'll do text, browser, schema xml, and html, but it's all (intentionally) plain vanilla. Brad wrote: A programming environment; Python comes to mind immediately; very easy to learn, especially compared to VB, and its even Windows compatible (MFC even). A database maintenance utility; To what end? A database query tool; Visual query tools exist for MySQL already; someone keeps posting the name of one from time to time ... A report builder Any report program that works from ODBC will work. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.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: Access replacement...
That looks like a windows-only solution John Ragan ([EMAIL PROTECTED]) wrote*: i've been hesitant to respond because i'm not sure that this is a head on solution for you, but take a look at http://corereader.com it's certainly easier to use than access queries. simple point and click to build complex output. however, it's not designed for the fancy formatted output to which your folks are accustomed. it'll do text, browser, schema xml, and html, but it's all (intentionally) plain vanilla. Brad wrote: A programming environment; Python comes to mind immediately; very easy to learn, especially compared to VB, and its even Windows compatible (MFC even). A database maintenance utility; To what end? A database query tool; Visual query tools exist for MySQL already; someone keeps posting the name of one from time to time ... A report builder Any report program that works from ODBC will work. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.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
mysql backup user permissions?
i want to add a user to my system that has permissions to backup all the databases using mysqlhotcopy. i don't want to use the root user. so what permissions (minium set) should i give the user in order to accomplish this. thanks in advance, shon - 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: Newbie: Intersecting entities
John, You're making sense. If you wanted to find all the systems used on project Test Bed Alpa, you'd do something like this: Select sys_name, s.id, project_name FROM systems s, new_req n,ie_sys_req i WHERE s.id = i.sys_id AND n.id = i.proj_name_id AND n.id = 344; Hope this helps, Andy mysql query -Original Message- From: John Coder [mailto:jcoder;insightbb.com] Sent: 07 November 2002 14:59 To: Richard Forgo Cc: [EMAIL PROTECTED] Subject: RE: Newbie: Intersecting entities On Wed, 2002-11-06 at 23:25, Richard Forgo wrote: Sorry for being vague. I think the closest thing I can find to it is, possibly, a three-way join. I'm trying to figure out how to write the query. I've got the following tables: systems sys_nameID Abrams 202 Patriot 544 Stinger 229 ... and ... new_req proj_name ID Test Bed Alpha 344 Tracked Wheels 989 Battle Monitor 823 Shoulder Harness654 Ammo Flask 454 Spotter 773 There may be multiple new requirements for a single system. To accommodate them, I created a new table -- an intersecting entity is what I recall it being called -- to bridge the two. I can't keep the multiple references to new_req in the systems table, nor can I keep them in the new_req table. As best I can figure, I need to have a bridge table ... e.g., ie_sys_req sys_id proj_name_id 202344 202989 202823 544654 544454 544773 If this seems peculiar, have patience with me I'm new at this. If it's right, let me know so I can breath a sigh of relief. And if the structure is right, could someone offer some guidance on how a query that allows me to query new_req using the intersecting entity (or three-way join, whatever it's called) would be written. Thanks, Rik Forgo JIST3 Army Test, Training and Technology Integration Office (T3I) Diverse Technologies Corp. (c) 443.463.8571 (h) 410.859.8474 -Original Message- From: John Ragan [mailto:jragan;arkansas.net] Sent: Wednesday, November 06, 2002 6:55 PM To: [EMAIL PROTECTED]; Richard Forgo Subject: Re: Newbie: Intersecting entities if a succinct statement is possible, perhaps you could give us an idea of its nature? somebody may be familiar with the concept under a different name. I'm trying to find some documentation on creating intersecting entities in MySQL, but haven't been able to track any info down on the MySQL site or on the web. At least we called them intersecting entities while I was in Oracle training (which was some time ago). I think I remember how to set them up, but I'd love to have something to refer to quickly before I start. Can anyone point me in the right direction? There is an example and full blown script in a book by Michael Koffler called MYSQL. His Url is www,Kofler.cc If I remember it correctly he had a intersecting entity involving Authors and Publishers in his mylibrary example. John Coder - 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: Access replacement...
Brad. Not sure if you got my last mail but did you try Omnis Studio from www.omnis.net (trial download available). It is available for MacOS Classic, OSX, Windows, Solaris and Linux. Never used the Solaris/Linux versions but I do use the Mac and Windows versions every day. HTH Kev. -- From: Brian Johnson Sent: Thursday, November 7, 2002 15:58 PM To: MySQL mailing List Subject: Re: Access replacement... That looks like a windows-only solution John Ragan ([EMAIL PROTECTED]) wrote*: i've been hesitant to respond because i'm not sure that this is a head on solution for you, but take a look at http://corereader.com it's certainly easier to use than access queries. simple point and click to build complex output. however, it's not designed for the fancy formatted output to which your folks are accustomed. it'll do text, browser, schema xml, and html, but it's all (intentionally) plain vanilla. Brad wrote: A programming environment; Python comes to mind immediately; very easy to learn, especially compared to VB, and its even Windows compatible (MFC even). A database maintenance utility; To what end? A database query tool; Visual query tools exist for MySQL already; someone keeps posting the name of one from time to time ... A report builder Any report program that works from ODBC will work. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk - 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: timestamp updated on select
Ok, here we are, in much detail. There is a table called translations and another one called poems. Their structure is given in the end. The query (given by a php script by the way) is: select poems.poem_id, language, translation_title,made_by_id from poems,translations where poems.poem_id=translations.poem_id order by date_added desc limit 0,10 and with this I intend to retrieve the 10 latest additions of translations. However, when running the script, I noticed that always, on the top of the results was the translation link I had clicked last. And this happens all the time. Now that I think of it again, the clicked link contains a mysql query which increments the translation views by one. H.maybe this does the unwanted update CREATE TABLE `poems` ( `poem_id` smallint(4) unsigned NOT NULL auto_increment, `poem_title` varchar(38) default NULL, `poet_id` smallint(4) unsigned default NULL, `comments` varchar(255) default NULL, `poem_views` smallint(5) unsigned NOT NULL default '0', `poem` text, `poem_comment` text NOT NULL, PRIMARY KEY (`poem_id`) ) TYPE=MyISAM and CREATE TABLE `translations` ( `poem_id` smallint(4) unsigned NOT NULL default '0', `language` varchar(14) NOT NULL default 'english', `translation_title` varchar(54) default NULL, `translation_text` text, `footnotes` text, `made_by_id` smallint(4) unsigned NOT NULL default '0', `contributed` varchar(70) default NULL, `translation_views` smallint(5) unsigned NOT NULL default '0', `date_added` timestamp(14) NOT NULL, PRIMARY KEY (`poem_id`,`language`,`made_by_id`), KEY `language` (`language`) ) TYPE=MyISAM Paul DuBois wrote: At 2:09 +0200 11/7/02, Galanis Nikolas wrote: Yes, that is exactly what happens. It is updated with a simple select statement. It is a select from a table which contains only one timestamp column and the order by is made by this timstamp column. And every time the value if the timestamp is updated. That seems fairly strange. Let's see an example. On Wed, 6 Nov 2002, Paul DuBois wrote: At 23:47 + 11/6/02, Nikolas Galanis wrote: Hello I have a column of type timestamp(14) and I thought it would not be updated on a query with simple select statements, though it does! I read in the manual that it shouldn't, what could be wrong? Thanks. You're saying that performing a SELECT on the table causes the TIMESTAMP column to *change*? That shouldn't happen. -- - - Nikolas Galanis - - Computer Engineering Informatics Department - - University of Patras - - http://www.ceid.upatras.gr- - 061 997707- - - 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 when compiling mysql
Description: checking size of char... configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify this by checking if you have libm.a in /lib, /usr/lib or some other standard place. If this is the problem, install the static libraries and try again. If this isn't the problem, examine config.log for possible errors. If you want to report this, use 'scripts/mysqlbug' and include at least the last 20 rows from config.log! How-to-repeat: ./configure --prefix=/opt/apache/mysql MySQL support: none Synopsis: unable to compile source code due to char type error MySQL release: mysql-3.23.51 (Source distribution) Machine/OS: Sun Solaris 2.7 Environment: System: SunOS saspcd02 5.7 Generic_106541-18 sun4u sparc SUNW,Ultra-80 Architecture: sun4 GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1711420 Jan 3 2002 /lib/libc.a lrwxrwxrwx 1 root root 11 Sep 13 2000 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1125660 Jan 3 2002 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1711420 Jan 3 2002 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Sep 13 2000 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1125660 Jan 3 2002 /usr/lib/libc.so.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --enable-local-infile --with-innodb CC=gcc CXX=gcc I have confirmed that the libm.a exist in the /lib directory. I also have zlib set in my path: echo $PATH: /home/webusr/bin:/usr/sbin:/bin:/usr/bin:/usr/local/bin:/lib:/usr/openwin/bin:/usr/dt/bin:/opt/oracl e/product/8.1.6/bin:/opt/java/jsdk/bin:/home/webusr/make_379:/tmp/SUNWspro/WS6/bin:/opt/FSFgzip/bin: /home/webusr/zlib-114/lib:/home/webusr/zlib-114/bin:/usr/ccs/bin:/home/webusr/perl-5.6.1 __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - 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
merging multiple rows results in join statement
My last post wasn't titled accurately. Sorry for the repost. I have 3 tables. Ticket Pipeline_Dept, and Ticket_Matrix. Ticket_Matrix matches tickets to pipeline depts. A ticket can be posted to multiple pipeline depts. I want to select all tickets and the pipeline departments they are posted to but only one row per ticket. So: SELECT t.ticketID, p.pipelineName FROM Ticket t LEFT JOIN Ticket_Matrix tm ON t.ticketID = tm.ticketID LEFT JOIN Pipeline_Dept p ON p.pipelineID = tm.pipelineID This is what I want: +--+--+ | ticketID | pipelineName | +--+--+ | 163 | IT, Adv.Tech, RD| | 164 | IT, RD | | 165 | Video, Multimedia| | ... | ... | +--+--+ This is what I get now: +--+--+ | ticketID | pipelineName | +--+--+ | 163 | IT | | 163 | Adv.Tech | | 163 | RD | | 164 | IT | | 164 | RD | | 165 | Video| | 165 | Multimedia | | ... | ... | +--+--+ I cannot do it with PHP because my query depends on LIMIT and returning a set number of rows. If I use PHP to do the concat-ing, the number of rows may be LIMIT and that is undesirable. I appreciate any help. - This mail sent through IMP: http://horde.org/imp/ - 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: timestamp updated on select
Nikolas Galanis wrote: and with this I intend to retrieve the 10 latest additions of translations. However, when running the script, I noticed that always, on the top of the results was the translation link I had clicked last. And this happens all the time. Now that I think of it again, the clicked link contains a mysql query which increments the translation views by one. H.maybe this does the unwanted update Any change to the record will update the timestamp; what you probably want is a seperate counting table for views instead; PoemViews ( poemid smallint unsigned not null primary key, count smallint unsigned not null default 0 ); ... Then do a REPLACE INTO PoemViews (poemid, count) SELECT 14, count FROM PoemViews WHERE poemid = 14 ... or whatever (where 14 is an arbitrary number in this case; I'd use a server-side variable, personally). You could also make a views table thats more universal to the site (which is what I do) and then point to it from your poems table (ViewsID type thing) ... your choice. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: merging multiple rows results in join statement
[EMAIL PROTECTED] wrote: This is what I want: +--+--+ | ticketID | pipelineName | +--+--+ | 163 | IT, Adv.Tech, RD| | 164 | IT, RD | | 165 | Video, Multimedia| | ... | ... | +--+--+ This is an output / formatting issue; you'll either have to do it externally (which you said you can't), use a string concat function (not sure if that'll work or not; never done it in SQL), or do two queries; SELECT ticketID LIMIT 10; SELECT pipelineName ... WHERE ticketID IN (previous response list); ... then format your output accordingly. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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 MySQL Works?
Philipp Steinkrueger wrote: if you dont understand the language mysql is written in you are probably not interested in how it works, technically. this I've actually had any number of people ask me how to do things that they think they can understand without knowing anything about programming. Like how to design a search engine (knowing nothing about programming or databases) or how NTFS works (knowing nothing about disk storage beyond the fact that there are icons to represent files and 'folders'), etc. I answered as I did, as you probably noted :-), because if the poster doesn't understand C, there's not much point in answering the intent of the question at all. FWIW (to everyone else), I'm a C/C++/PERL/Python/bah/foo/bar programmer and I probably wouldn't delve into how MySQL handles the setup for a query in the source code unless I had a pencil and paper handy and felt like using Ctrl-] a lot ... (I use vim). -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: timestamp updated on select
At 11:41 + 11/7/02, Nikolas Galanis wrote: Ok, here we are, in much detail. There is a table called translations and another one called poems. Their structure is given in the end. The query (given by a php script by the way) is: select poems.poem_id, language, translation_title,made_by_id from poems,translations where poems.poem_id=translations.poem_id order by date_added desc limit 0,10 and with this I intend to retrieve the 10 latest additions of translations. However, when running the script, I noticed that always, on the top of the results was the translation link I had clicked last. And this happens all the time. Now that I think of it again, the clicked link contains a mysql query which increments the translation views by one. H.maybe this does the unwanted update Exactly. To prevent this, you can modify your UPDATE query to set the TIMESTAMP column to its current value. That will prevent it from being updated to the current date and time automatically. I don't know what your query looks like exactly, but you can write it something like this: UPDATE translations SET date_added = date_added, translation_views = translation_views + 1 ... CREATE TABLE `poems` ( `poem_id` smallint(4) unsigned NOT NULL auto_increment, `poem_title` varchar(38) default NULL, `poet_id` smallint(4) unsigned default NULL, `comments` varchar(255) default NULL, `poem_views` smallint(5) unsigned NOT NULL default '0', `poem` text, `poem_comment` text NOT NULL, PRIMARY KEY (`poem_id`) ) TYPE=MyISAM and CREATE TABLE `translations` ( `poem_id` smallint(4) unsigned NOT NULL default '0', `language` varchar(14) NOT NULL default 'english', `translation_title` varchar(54) default NULL, `translation_text` text, `footnotes` text, `made_by_id` smallint(4) unsigned NOT NULL default '0', `contributed` varchar(70) default NULL, `translation_views` smallint(5) unsigned NOT NULL default '0', `date_added` timestamp(14) NOT NULL, PRIMARY KEY (`poem_id`,`language`,`made_by_id`), KEY `language` (`language`) ) TYPE=MyISAM Paul DuBois wrote: At 2:09 +0200 11/7/02, Galanis Nikolas wrote: Yes, that is exactly what happens. It is updated with a simple select statement. It is a select from a table which contains only one timestamp column and the order by is made by this timstamp column. And every time the value if the timestamp is updated. That seems fairly strange. Let's see an example. On Wed, 6 Nov 2002, Paul DuBois wrote: At 23:47 + 11/6/02, Nikolas Galanis wrote: Hello I have a column of type timestamp(14) and I thought it would not be updated on a query with simple select statements, though it does! I read in the manual that it shouldn't, what could be wrong? Thanks. You're saying that performing a SELECT on the table causes the TIMESTAMP column to *change*? That shouldn't happen. - 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: Newbie: Intersecting entities
John Coder wrote:
right, let me know so I can breath a sigh of relief. And if the
structure is right, could someone offer some guidance on how a query
that allows me to query new_req using the intersecting entity (or
three-way join, whatever it's called) would be written.
That looks right to me, fwiw; now have your hand at some SELECTs off it
and see how it performs. Don't forget to UNIQUE index (or primary) the
pair of values in your intersection table if you don't have repeats of
pairs (which you probably don't) and that its ok to add additional
information to that table if that information relates to the particular
pair in question ...
Customers (id, name), PhoneNumbers (id, number), CustomerPhoneNumbers
(customerid, phonenumberid, type {fax/phone}, contact {ask for who?}) ...
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
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: Host not allowed to connect problem
Make sure /etc/hosts has this line 127.0.0.1 localhost ~Kelly W. Black -Original Message- From: Kevin Passey [mailto:kpassey;kdpsoftware.co.uk] Sent: Thursday, November 07, 2002 4:38 AM To: 'Timothy Venn'; Mysql (E-mail) Subject: RE: Host not allowed to connect problem Hello Tim, Are you getting this regardless of what you put in user,host and db tables. If you are I am getting the same thing. Any access to my database is denied except from the console. How did you install - from the rpm's ?? I will watch this thread as I am at a complete standstill with MySQL on Linux - it runs fine on windows (not what you want to hear). Regards Kevin -Original Message- From: Timothy Venn [mailto:tim;optimus.co.za] Sent: 07 November 2002 09:42 To: [EMAIL PROTECTED] Subject: Host not allowed to connect problem Hi, I am having a problem with Mysql 3.23.39 for solaris 2.6. I can do anything from the console command line but any connections from any other hosts causes a host xxx.xxx.xxx.xxx not allowed to connect to this mysql server. I have updated the host table to include a % for all hosts. Any suggestions Regards Tim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Key/table cache size?
I've got a query that selects the count of distinct rows in a table; the table has 453632 rows and 24 distinct class_id's. mysql SELECT count(DISTINCT(sig_class_id)) FROM acid_event; +---+ | count(DISTINCT(sig_class_id)) | +---+ |24 | +---+ 1 row in set (4.80 sec) mysql select count(*) FROM acid_event; +--+ | count(*) | +--+ | 453632 | +--+ 1 row in set (3.12 sec) Is there any way to speed up these queries (InnoDB tables), or just put up? PS, at that number of distinct values, am I right in thinking that I should just drop the index on that column while I'm at it? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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 hangs, restarts on odbc connect
Thank you, Egor! It looks like Red Hat released an update to its glibc libraries yesterday which fix this, so if anybody else is having problems, they should be able to fix it by updating. :) Sage On Thu, 2002-11-07 at 17:46, Egor Egorov wrote: Sage, Wednesday, November 06, 2002, 3:31:21 PM, you wrote: S I'm running MySQL 3.23.49 on Red Hat 7.3, with the latest kernel S (2.4.18-17.7.x) installed. It is running in smp mode on a dual P3 1.0 S gHz. S MySQL works perfectly fine when connecting from the localhost. However, S I have another machine that needs to connect via ODBC. The ODBC client S can connect, but as soon as it does, the connection is suddenly closed. S The same thing happens if I try to telnet to port 3306 on the host S machine. S Every time this happens, I find the following entry in mysqld.log: S Number of processes running now: 1 S mysqld process hanging, pid 906 - killed S 021106 15:51:41 mysqld restarted S /usr/libexec/mysqld: ready for connections S I have no idea what is causing this. Does anyone have any suggestions as S to what might be the cause, or at least what I should double-check? Your problem is described here: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 You can downgrade glibc or install the patched one or install MySQL server v3.23.53a -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Error when compiling mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 07 November 2002 17:46, ktran wrote: Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --enable-local-infile --with-innodb CC=gcc CXX=gcc I have confirmed that the libm.a exist in the /lib directory. I also have zlib set in my path: echo $PATH: /home/webusr/bin:/usr/sbin:/bin:/usr/bin:/usr/local/bin:/lib: /usr/openwin/bin:/usr/dt/bin:/opt/oracle/product/8.1.6/bin: /opt/java/jsdk/bin:/home/webusr/make_379:/tmp/SUNWspro/WS6/bin: /opt/FSFgzip/bin:/home/webusr/zlib-114/lib: /home/webusr/zlib-114/bin:/usr/ccs/bin:/home/webusr/perl-5.6.1 It's not enough to have zlib in your $PATH - you need to tell the compiler where to find it. You can do that by using the - --with-named-z-libs=/home/webusr/zlib-114/lib configure option. Alternatively you could simply disable it by using - --with-named-z-libs=no - The dynamic linker will not find it in your path by default anyway. Bye, LenZ - -- - -- Lenz Grimmer [EMAIL PROTECTED] -o) [ICQ: 160767607 | Jabber: [EMAIL PROTECTED]]/\\ http://lenz.grimmer.com_\_v -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE9yqukSVDhKrJykfIRAt/cAJ9DiI+wYnDIH98h5HtQAf4544gN7ACeLNNX PhqHF/fop3TK7bEN2lO99hQ= =GJFt -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ActiveX error Visual Basic Integration MySQL
Either you are not referencing the correct library for the database access or you cannot doit from the Learning Edition. HTH JFernando ** sql *** -Original Message- From: Oliver Gottwald [mailto:goto1;enteract.com] Sent: November 6, 2002 22:26 To: [EMAIL PROTECTED] Subject: ActiveX error Visual Basic Integration MySQL Hi, I'm attempting to get the MySQL ODBC Drive to work with Visual Basic 6.0 Leaning version I'm getting the following error: Run-time error '429': ActiveX component can't create object On the following line cnMySql.CursorDriver = rdUseOdbc Does anyone have any idea what I might be doing wrong? Oliver - 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
MySQL AB has reached a settlement with NuSphere Corporation
Hi! MySQL AB is pleased to announce that it has settled its lawsuit with Progress Software Corporation and NuSphere Corporation. For more information, see the joint press release at http://www.mysql.com/press/release_2002_14.html Regards, Monty -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error connecting to Mysql via Apache/PHP (Newbie)
Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on
Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3.
I am trying to connect to my Mysql DB via Apache and PHP, but I get the
following error: Warning: Unknown MySQL Server Host '' (1) in
helloSql.php on line 3 Warning: MySQL Connection Failed: Unknown MySQL
Server Host '' (1) in helloSql.php on line 3 Could not connect
Here is the code I used.
?php
// Connecting, selecting database
$link = mysql_connect(localhost, root, mypassword)
or die(Could not connect);
print Connected successfully;
// Performing SQL query
$query = SELECT now();
$result = mysql_query($query)
or die(Query failed);
// Printing results in HTML
print table\n;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print \ttr\n;
foreach ($line as $col_value) {
print \t\ttd$col_value/td\n;
}
print \t/tr\n;
}
print /table\n;
// Closing connection
mysql_close($link);
?
-
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 AB has reached a settlement with NuSphere Corporation
On Thu, 7 Nov 2002, Michael Widenius wrote: MySQL AB is pleased to announce that it has settled its lawsuit with Progress Software Corporation and NuSphere Corporation. For more information, see the joint press release at http://www.mysql.com/press/release_2002_14.html The press release sounds like typical PR puffery. Is any meat going to come out beyond it's settled? -- /chris Programming is a Dark Art, and it will always be. The programmer is fighting against the two most destructive forces in the universe: entropy and human stupidity. They're not things you can always overcome with a methodology or on a schedule. -Damian Conway, Perl God - 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
Storing/retrieving long or very big double values
Hi. I have some problems to retrieve the doubles I write in my tables. I use MySQL server 4.0.3-beta-max. I have not found the solution of my problem on the mailing-lis archive. Following is the problem: mysql create table double_test (d double); mysql insert into double_test values(1.7976931348623157E308); mysql insert into double_test values(0.10012210012209899); mysql select * from double_test; +---+ | d | +---+ | 1.79769313486232e+308 | == truncation happened | 0.100122100122099 | == truncation happened +---+ The numbers are truncated. Why and how to avoid it ? I would like store and retrieve the double values without modification. In my Java program when I read back the data, 1.79769313486232e+308 is considered as 'Infinity' because after the truncation and rounding, the value becomes bigger than the maximum double value allowed (1.7976931348623157E308 under Java). When I use double(M,D) instead of double in the table creation, the insertion of 1.7976931348623157E308 leads to the value 'inf' when I read back the value by typing 'select * from ouble_test'). Any idea or experience to share. Thanks in advance, Christophe. *** Christophe DIARRA Institut de Physique Nucleaire 15, Rue Georges Clemenceau Bat 102 - S2I 91406 ORSAY Cedex Tel: (33) 1 69 15 65 60 Fax: (33) 1 69 15 45 03 (33) 1 69 15 64 70 E-mail: [EMAIL PROTECTED] *** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL AB has reached a settlement with NuSphere Corporation
Can someone post the piece of News, for the folks that cant get into the page (I dont have access to web from where I am now...) Thanks, Leo. - Original Message - From: Christopher Hicks [EMAIL PROTECTED] To: Michael Widenius [EMAIL PROTECTED] Cc: Mysql List [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 3:46 PM Subject: Re: MySQL AB has reached a settlement with NuSphere Corporation On Thu, 7 Nov 2002, Michael Widenius wrote: MySQL AB is pleased to announce that it has settled its lawsuit with Progress Software Corporation and NuSphere Corporation. For more information, see the joint press release at http://www.mysql.com/press/release_2002_14.html The press release sounds like typical PR puffery. Is any meat going to come out beyond it's settled? -- /chris Programming is a Dark Art, and it will always be. The programmer is fighting against the two most destructive forces in the universe: entropy and human stupidity. They're not things you can always overcome with a methodology or on a schedule. -Damian Conway, Perl God - 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 AB has reached a settlement with NuSphere Corporation
MySQL AB and Nusphere Corporation Announce Settlement07 Nov 2002 UPPSALA, Sweden and BEDFORD, Massachusetts, (November 7, 2002) - MySQL AB, developer of the world's most popular open source database, and NuSphere Corporation, an independent operating company of Progress Software Corporation, today announced a settlement of the dispute between the two companies regarding use of the MySQL trademarks, copyrights, and compliance with the GNU General Public License (GPL). The settlement resolves all outstanding issues between the two companies including ownership and use of trademarks and domain names and assignment to MySQL AB of copyrights for all NuSphere contributions to the MySQL program, and MySQL AB has issued a letter to NuSphere Corporation verifying GPL compliance. We are happy to resolve this dispute, said Olivier Beutels, Sales Executive, Northern Europe, MySQL AB. These past months of discussion with NuSphere regarding trademark rights and GPL issues have confirmed for us all that open source software can flourish free under the GPL license and commercially when the situation merits it. We are pleased to reach this amicable settlement and resolve the issues between the two companies, said Dmitri Dmitrienko, General Manager Europe, NuSphere Corporation. We look forward to getting back to the normal run of business and plan to continue shipping the MySQL database in the NuSphere Technology Platform, and remain focused on our flagship product. About MySQL AB MySQL AB develops, markets and supports the MySQL database server, the world's most popular open source database. With over 4 million installations and 27,000 downloads per day, MySQL is the de facto open source database leader and is quickly becoming the core of many high-volume, business-critical applications. The MySQL database is available under the free software/open source GNU General Public License (GPL) or a non-GPL commercial license. For more information about MySQL, please go to www.mysql.com. MySQL is a registered trademark of MySQL AB in Sweden and other countries. MySQL is a trademark in the United States and other countries. About NuSphere Corporation NuSphere delivers the first Internet Application Platform (IAP) based on open source components, providing an integrated foundation that allows companies to deploy reliable, cost-effective, enterprise-class applications across Windows, UNIX and Linux environments. NuSphere® PHPEd(tm) Advantage is an integrated software suite that pairs the reliability and cost-effectiveness of PHP, Apache, Perl and open source databases with PHPEd, the leading PHP development environment for building business-critical web applications and web services. Based in Bedford, Mass., the company's commercial software services include technical support, consulting and training. For more information, visit www.nusphere.com or call +1-781-280-4600. NuSphere is a registered trademark of NuSphere Corporation in the United States and other countries. PHPEd is a trademark of NuSphere Corporation in the United States and other countries. Other marks mentioned in this press release are the trademarks of their respective owners. -Original Message- From: Leonardo Javier Belén [mailto:lbelen;afip.gov.ar] Sent: Thursday, November 07, 2002 2:05 PM To: [EMAIL PROTECTED] Subject: Re: MySQL AB has reached a settlement with NuSphere Corporation Can someone post the piece of News, for the folks that cant get into the page (I dont have access to web from where I am now...) Thanks, Leo. - Original Message - From: Christopher Hicks [EMAIL PROTECTED] To: Michael Widenius [EMAIL PROTECTED] Cc: Mysql List [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 3:46 PM Subject: Re: MySQL AB has reached a settlement with NuSphere Corporation On Thu, 7 Nov 2002, Michael Widenius wrote: MySQL AB is pleased to announce that it has settled its lawsuit with Progress Software Corporation and NuSphere Corporation. For more information, see the joint press release at http://www.mysql.com/press/release_2002_14.html The press release sounds like typical PR puffery. Is any meat going to come out beyond it's settled? -- /chris Programming is a Dark Art, and it will always be. The programmer is fighting against the two most destructive forces in the universe: entropy and human stupidity. They're not things you can always overcome with a methodology or on a schedule. -Damian Conway, Perl God - 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:
Re: using libmysqld - can't connect to remote DB as client.
On that page, it says: You can't connect to the embedded server from an outside process with sockets or TCP/IP. ... not the other way around, which is what I'm trying to do. I'm trying to connect to another (remote) server from the same app as is using an embedded server. It doesn't say anything about the client-side TCP being disabled in the mysqld lib, just the server-side. This is still unclear to me since they specificially went out of their way to mention that the server-side TCP stuff was diabled, am I to just assume that the client-side stuff is also disabled? - Steve --- Paul DuBois [EMAIL PROTECTED] wrote: At 11:09 -0800 11/6/02, Steven Webb wrote: I'm using libmysqld so I can have an embedded mysql server in my application. It helps with performance because there is not socket communication and all I/O is done from the program directly to the files. Anyway, I have the need to also connect to a remote database in the same application. My code works fine with the local embedded mysql server, I can connect to the local server, create a database and manipulate the data, but when I try to connect to a remote database, it fails. The C function that I'm using is mysql_real_connect. The mysql_connect that you're talking about is just a wrapper function that I wrote. The mysql_real_connect() is down further in the code. Did you get my code? I sent it to the list, but the list bounced it because the list didn't allow attachments. Anyway, According to the docs for the mysqld library (http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#libmysqld) There is nothing that says that the mysql_real_connect should work any differently than the one in the normal library. Nothing there, perhaps. But the general description of the embedded server points out that it does no networking. You cannot use an embedded app to connect to remote servers, nor can external clients connect to the embedded server. (This is one reason the manual says embedded servers can't be used in replication.) So, I'm thinking that either the documentation is incorrect (mysql_real_connect *DOESN'T* include any socket-level capability in the mysqld lib like it does in the normal library) or I'm just doing something wrong when I try to connect to a remote database with mysql_real_connect. The man page for mysql_real_connect is here: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_connect - Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - 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
Profiler
I would like to know if the MySQL has any command where I get the queries requested by the application. SQL Server has Profiler. Oracle has any command that I don´t know With Delphi I run SQLMonitor. Regards Alexander sql,query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.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
Replication and temp tables...
Using 4.0.2 for both server and client, replicating the following query seems to have caused a crash on the client: CREATE TEMPORARY TABLE tmp1 ( day DATE NOT NULL, campaign_id INT NOT NULL, clicks INT, clicked FLOAT, approved FLOAT, users_raw INT, users_coreg INT, users_fullreg INT, visitors INT, PRIMARY KEY (day, campaign_id) ) TYPE=InnoDB; The error log (w/ symbols resolved) is: 021107 8:51:32 Slave SQL thread initialized, starting replication in log 'db1-bin.085' at position 113214771, relay log './db3-relay-bin.001' position: 25762057 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=268431360 record_buffer=2093056 sort_buffer=1048568 max_used_connections=0 max_connections=50 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 415539 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x85261b0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfe3f248, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x80722d8 init_signals__Fv + 16 0x82de908 _end + 239148 0x82cb534 _end + 160344 0x80e9a58 register_slave__FP3THDPUcUi + 228 0x80af595 exec_event__21Create_file_log_eventP17st_relay_log_info + 537 0x80b04f4 __15Query_log_eventP3THDPCcb + 160 0x80ebf71 nisam_open + 1837 0x80ece8f _nisam_search + 79 0x82dbf1c _end + 228416 0x831193a _end + 448094 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=3 Any ideas on what might be causing this? -JF - 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: Profiler
Hi Alexander. If you specify option log in section mysqld of my.cnf configuration file you get a log file of all queries and sql operations (inserts, updates, deletes) executed in the MySQL server. This log file is created by default at $DATADIR/$HOSTNAME.log. Iago. -Mensaje original- De: Alexander Burbello [mailto:burbello;yahoo.com.br] Enviado el: jueves, 07 de noviembre de 2002 21:30 Para: [EMAIL PROTECTED] Asunto: Profiler I would like to know if the MySQL has any command where I get the queries requested by the application. SQL Server has Profiler. Oracle has any command that I don´t know With Delphi I run SQLMonitor. Regards Alexander sql,query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Key/table cache size?
In the last episode (Nov 07), Michael T. Babcock said: I've got a query that selects the count of distinct rows in a table; the table has 453632 rows and 24 distinct class_id's. mysql SELECT count(DISTINCT(sig_class_id)) FROM acid_event; | count(DISTINCT(sig_class_id)) |24 | 1 row in set (4.80 sec) mysql select count(*) FROM acid_event; | count(*) | 453632 | 1 row in set (3.12 sec) Is there any way to speed up these queries (InnoDB tables), or just put up? PS, at that number of distinct values, am I right in thinking that I should just drop the index on that column while I'm at it? I haven't played with InnoDB tables much, but a select like that runs much faster with an index on MyISAM tables. Most of the server's time should be spent reading the field values, and an index scan of just that field will be faster than a table scan where it has to read the whole record. Yes, with only 24 values, MySQL will probably never use that index for paring down records in a regular SELECT. But for your count() case it should. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: getting the number of years between two dates
sql,query How do I do that? The contaxt is that I want to get somebody's age based upon the current date. - 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: using libmysqld - can't connect to remote DB as client.
At 11:14 -0800 11/7/02, Steven Webb wrote: On that page, it says: You can't connect to the embedded server from an outside process with sockets or TCP/IP. ... not the other way around, which is what I'm trying to do. I'm trying to connect to another (remote) server from the same app as is using an embedded server. It doesn't say anything about the client-side TCP being disabled in the mysqld lib, just the server-side. This is still unclear to me since they specificially went out of their way to mention that the server-side TCP stuff was diabled, am I to just assume that the client-side stuff is also disabled? The client library calls are replaced with (or mapped onto, if you will) calls that talk to the embedded server. - 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
Why can I not access your support system via the Wizard?
I am a new customer and have a question about mysqldump recovery, but cannot seem to be able to logon. My user name is probusine8359 and my support contract is 2002-1428. Would you please correct this anomaly? I need to get my questions answered. My phone number is 925.737.3458. Thanks. Ian Clark ProBusiness, Inc - 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: getting the number of years between two dates
John Meyer wrote: sql,query How do I do that? The contaxt is that I want to get somebody's age based upon the current date. There are several examples in the mailing list archives; but try subtracting the UNIX_TIMESTAMP of each date (which is the time in seconds) and then divide by the number of seconds in a year (~365*86400) ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: Key/table cache size?
Dan Nelson wrote: Yes, with only 24 values, MySQL will probably never use that index for paring down records in a regular SELECT. But for your count() case it should. According to the EXPLAIN output, it does; but its still horrifically slow. mysql explain SELECT count(DISTINCT(sig_class_id)) FROM acid_event; ++---+---+--+-+--++-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | ++---+---+--+-+--++-+ | acid_event | index | NULL | sig_class_id | 5 | NULL | 377222 | Using index | ++---+---+--+-+--++-+ Mind you, it doesn't pare it down much ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: Newby: Duplicate Records in table...
Hi everyone, How do I select a group of records in a table and automatically duplicate them into the same table while modifying 1 or 2 columns without having to re-insert each record individually? Thanks, Doug MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL Query
Hi, I have the following SQL query, that returns the correct records on Access, but when I use it with MySQL, it returns duplicate records, and it skips the required records. SearchSQL=select MarketData.CustID,Contacts.ContactID,Contacts.CustID,MarketData.Nickname,Marke tData.Occupation,MarketData.Country ,County,MarketData.Forename,MarketData.Surname,MarketData.Email FROM MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.ContactID WHERE Contacts.CustID=6115 Regards, Sam - 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: getting the number of years between two dates
Actually figured out one of my own: FLOOR(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()),EXTRACT(YEAR_MONTH FROM UserDOB))/ 12) as Age It's amazing what you can think of as soon as you ask the question. -Original Message- From: Michael T. Babcock [mailto:mbabcock;fibrespeed.net] Sent: Thursday, November 07, 2002 1:58 PM To: John Meyer Cc: [EMAIL PROTECTED] Subject: Re: getting the number of years between two dates John Meyer wrote: sql,query How do I do that? The contaxt is that I want to get somebody's age based upon the current date. There are several examples in the mailing list archives; but try subtracting the UNIX_TIMESTAMP of each date (which is the time in seconds) and then divide by the number of seconds in a year (~365*86400) ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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
MYSQL Digest
I sent this sometime ago and never got a response, so I will send it again I want to change my option to subscribe to this list as a digest, is the following command below correct, or is this list not setup has a digest? subscribe mysql-digest EMAILADDRESS END -- Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL CPU usage skyrocketing
On Thu, Nov 07, 2002 at 08:48:15AM -0500, Grigor, Peter wrote: Ok, we know that FreeBSD has problems with its thread implementation; however, I'd like to know if the MySql guys know exactly what causes the problems to which Mr Zawodny refers. The problem is the MySQL (by default) uses name resolution extensively. But the resolver calls are not thread-safe on FreeBSD. Race coniditions exist that can cause odd cicumstances which result in MySQL thrashing a bit. I'm running FreeBSD 4.6.2, and have seen the 'rogue thread' problem before which leads me to believe that either FreeBSD has not addressed the problem or MySql hasn't. To be fair MySql says in its documentation that FreeBSD is not recommended because of its threading implementation. It's not a MySQL problem--it's a FreeBSD problem. This problem doesn't exist on other platforms. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 93 days, processed 1,954,122,045 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Key/table cache size?
On Thu, Nov 07, 2002 at 12:32:58PM -0500, Michael T. Babcock wrote: I've got a query that selects the count of distinct rows in a table; the table has 453632 rows and 24 distinct class_id's. mysql SELECT count(DISTINCT(sig_class_id)) FROM acid_event; +---+ | count(DISTINCT(sig_class_id)) | +---+ |24 | +---+ 1 row in set (4.80 sec) mysql select count(*) FROM acid_event; +--+ | count(*) | +--+ | 453632 | +--+ 1 row in set (3.12 sec) Is there any way to speed up these queries (InnoDB tables), or just put up? Check if the machine is disk or CPU bound when it runs. You may need a larger innodb_buffer_pool. That'll help keep more records in memory and imporove response time. PS, at that number of distinct values, am I right in thinking that I should just drop the index on that column while I'm at it? Maybe. Depends what else it might be used for. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 93 days, processed 1,954,140,347 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Profiler for windows
there is a Profiler similar to SQL server Profiler ,only for windows i wrote it myself , availiable at http://amr.activechannel.net/myprofiler.htm so sorry its not free :( Amr Salah --- Iago Sineiro [EMAIL PROTECTED] wrote: Hi Alexander. If you specify option log in section mysqld of my.cnf configuration file you get a log file of all queries and sql operations (inserts, updates, deletes) executed in the MySQL server. This log file is created by default at $DATADIR/$HOSTNAME.log. Iago. -Mensaje original- De: Alexander Burbello [mailto:burbello;yahoo.com.br] Enviado el: jueves, 07 de noviembre de 2002 21:30 Para: [EMAIL PROTECTED] Asunto: Profiler I would like to know if the MySQL has any command where I get the queries requested by the application. SQL Server has Profiler. Oracle has any command that I don´t know With Delphi I run SQLMonitor. Regards Alexander sql,query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Select your own custom email address for FREE! Get [EMAIL PROTECTED] w/No Ads, 6MB, POP more! http://www.everyone.net/selectmail?campaign=tag - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL Query
Is this line correct? MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.ContactID WHERE Or should it be: MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.CustID WHERE JFernando ** sql ** -Original Message- From: [EMAIL PROTECTED] [mailto:Sam4Software;aol.com] Sent: November 7, 2002 16:18 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: SQL Query Hi, I have the following SQL query, that returns the correct records on Access, but when I use it with MySQL, it returns duplicate records, and it skips the required records. SearchSQL=select MarketData.CustID,Contacts.ContactID,Contacts.CustID,MarketData.Nickname,Mar ke tData.Occupation,MarketData.Country ,County,MarketData.Forename,MarketData.Surname,MarketData.Email FROM MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.ContactID WHERE Contacts.CustID=6115 Regards, Sam - 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: Key/table cache size?
I've got a query that selects the count of distinct rows in a table; the table has 453632 rows and 24 distinct class_id's. mysql SELECT count(DISTINCT(sig_class_id)) FROM acid_event; +---+ | count(DISTINCT(sig_class_id)) | +---+ |24 | +---+ 1 row in set (4.80 sec) mysql select count(*) FROM acid_event; +--+ | count(*) | +--+ | 453632 | +--+ 1 row in set (3.12 sec) Is there any way to speed up these queries (InnoDB tables), or just put up? If you are using a version of MySql that has the query cache you can turn it on and those queries will run very fast after the initial query. The query cache is cleared whenever the underlying table(s) are modified so you'll get the initial time hit again after modification...but if your table contents don't change much the query cache will make a BIG difference. 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
new user, new install
I just installed onto a solaris 8 machine. I've run mysql_install_db The script says to change the root password by doing this: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h myhost password 'new-password' When I do that I get ./bin/mysqladmin: No match. Is password the already established password? I'm totally new to mysql. I'm just trying to run the tutorial but I can't seem to do anything until I have established a root password. BTW - I can run safe_mysqld when I'm logged in as root but not as a user. I can't run ./bin/mysqld at all. If I try when logged in as root I get a message that I should read the security section of the manual about how to log in as root. If I run it as a user I get: 021107 13:39:19 ./bin/mysqld: Can't create/write to file '/usr/local/mysql-3.23.52-sun-solaris2.8-sparc/var/newpop.pid' (Errcode: 13) 021107 13:39:19 ./bin/mysqld: Table 'mysql.host' doesn't exist 021107 13:39:19 ./bin/mysqld: Error on delete of '/usr/local/mysql-3.23.52-sun-solaris2.8-sparc/var/newpop.pid' (Errcode: 2) I'm totally lost and I can't afford to sign up for the 30 day install support. Is there anyone willing to help me get this going? Thanks in advance - chris walcott - 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: Key/table cache size?
Grigor, Peter wrote: If you are using a version of MySql that has the query cache you can turn it on and those queries will run very fast after the initial query. The query cache is cleared whenever the underlying table(s) are modified so you'll get the initial time hit again after modification...but if your table contents don't change much the query cache will make a BIG difference. Unfortunately, they change a lot more often than I run the queries; its a mostly-update table for storing intrusion detection information. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: Newbie: Intersecting entities
John, Michael, Andy and James, Thanks for the informative responses. I was hoping I was on the right track. Thanks for the query help, too. It looks like this is going to work just fine. Cheers, Rik Forgo JIST3 Army Test, Training and Technology Integration Office (T3I) Diverse Technologies Corp. (c) 443.463.8571 (h) 410.859.8474 -Original Message- From: John Ragan [mailto:jragan;arkansas.net] Sent: Thursday, November 07, 2002 10:16 AM To: [EMAIL PROTECTED]; Richard Forgo Subject: RE: Newbie: Intersecting entities aha! sure. you weren't being vague. you just needed to educate me. some of us have used intersecting entities through the years, but didn't know that there was a fancy name for what we were doing. if my memory weren't so bad, i'd use it to impress people in the next interview. in this case, simply do a three way multiple join with the intersecting entity in the middle. something like this: select table1.col2, table 3.col2 from table1 left join table2 on table1.col1 = table2.col1 left join table3 on table2.col2 = table3.col1 or you could use an equal join with the intersecting entity in the middle. if you have a windows box that you can use as a front end, i strongly recommend that you download corereader because its point and click queries can make a six way join look simple. then, it'll show you the sql code. best of all is that it's free. http://corereader.com Sorry for being vague. I think the closest thing I can find to it is, possibly, a three-way join. I'm trying to figure out how to write the query. I've got the following tables: systems sys_nameID Abrams 202 Patriot 544 Stinger 229 ... and ... new_req proj_name ID Test Bed Alpha 344 Tracked Wheels 989 Battle Monitor 823 Shoulder Harness654 Ammo Flask 454 Spotter 773 There may be multiple new requirements for a single system. To accommodate them, I created a new table -- an intersecting entity is what I recall it being called -- to bridge the two. I can't keep the multiple references to new_req in the systems table, nor can I keep them in the new_req table. As best I can figure, I need to have a bridge table ... e.g., ie_sys_req sys_id proj_name_id 202344 202989 202823 544654 544454 544773 If this seems peculiar, have patience with me I'm new at this. If it's right, let me know so I can breath a sigh of relief. And if the structure is right, could someone offer some guidance on how a query that allows me to query new_req using the intersecting entity (or three-way join, whatever it's called) would be written. Thanks, Rik Forgo JIST3 Army Test, Training and Technology Integration Office (T3I) Diverse Technologies Corp. (c) 443.463.8571 (h) 410.859.8474 -Original Message- From: John Ragan [mailto:jragan;arkansas.net] Sent: Wednesday, November 06, 2002 6:55 PM To: [EMAIL PROTECTED]; Richard Forgo Subject: Re: Newbie: Intersecting entities if a succinct statement is possible, perhaps you could give us an idea of its nature? somebody may be familiar with the concept under a different name. I'm trying to find some documentation on creating intersecting entities in MySQL, but haven't been able to track any info down on the MySQL site or on the web. At least we called them intersecting entities while I was in Oracle training (which was some time ago). I think I remember how to set them up, but I'd love to have something to refer to quickly before I start. Can anyone point me in the right direction? Rik Forgo JIST3 Army Test, Training and Technology Integration Office (T3I) Diverse Technologies Corp. (c) 443.463.8571 (h) 410.859.8474 -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual)
Re: SQL Query
On Thu, 2002-11-07 at 16:17, [EMAIL PROTECTED] wrote: Hi, I have the following SQL query, that returns the correct records on Access, but when I use it with MySQL, it returns duplicate records, and it skips the required records. SearchSQL=select MarketData.CustID,Contacts.ContactID,Contacts.CustID,MarketData.Nickname,Marke tData.Occupation,MarketData.Country ,County,MarketData.Forename,MarketData.Surname,MarketData.Email FROM MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.ContactID WHERE Contacts.CustID=6115 I personally would try: SearchSQL=select MarketData.CustID,Contacts.ContactID,Contacts.CustID,MarketData.Nickname, MarketData.Occupation,MarketData.Country,County,MarketData.Forename, MarketData.Surname,MarketData.Email FROM MarketData INNER JOIN Contacts WHERE MarketData.CustID=Contacts.ContactID AND Contacts.CustID=6115 John Coder - 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: privileges when moving from mysql 3.23 to 4.0
how is there a way to retain the user privileges in the mysql table when dumping from mysql 3.23 to 4.0 ? i dont want to have to reset these individually , let me know thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: getting the number of years between two dates
Well, actually I always use the Unix date format because is easier to use with PHP... and makes easier to do this kind of calculations... ;) -Mensaje original- De: John Meyer [mailto:johnmeyer_1978;yahoo.com] Enviado el: jueves, 07 de noviembre de 2002 15:20 Para: Michael T. Babcock CC: [EMAIL PROTECTED] Asunto: RE: getting the number of years between two dates Actually figured out one of my own: FLOOR(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()),EXTRACT(YEAR_MONTH FROM UserDOB))/ 12) as Age It's amazing what you can think of as soon as you ask the question. -Original Message- From: Michael T. Babcock [mailto:mbabcock;fibrespeed.net] Sent: Thursday, November 07, 2002 1:58 PM To: John Meyer Cc: [EMAIL PROTECTED] Subject: Re: getting the number of years between two dates John Meyer wrote: sql,query How do I do that? The contaxt is that I want to get somebody's age based upon the current date. There are several examples in the mailing list archives; but try subtracting the UNIX_TIMESTAMP of each date (which is the time in seconds) and then divide by the number of seconds in a year (~365*86400) ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Using AUTO_INCREMENT like SEQUENCE - Resolved
Hi all, Sorry to jump in the middle of this thread but there is a much simpler way to generate sequence numbers: You create an auxiliary table with a one row: CREATE TABLE sequence ( code int(11) DEFAULT '0' NOT NULL ); INSERT INTO sequence VALUES (0); And, each time you need a new sequence number: UPDATE sequence SET code=LAST_INSERT_ID(code+1); SELECT LAST_INSERT_ID(); We use this method in our applications and it works well. (and I didn't invent it, it is described in Paul DuBois'book ;)) Hope this helps -- Joseph Bueno Mike Hillyer wrote: I was thinking of a similar problem as yours (having the select max(id) type query get duplicate results) and what I realized was that I could do a select max(id) and specify a where clause to a column that had the user id of the creator of the row (which I already had in place for auditing) and then there was never duplication because the odds of you yourself inserting two rows simultaneously was nil. So, that may work for you as long as each user is logged in separately, and you can accept putting a field in your row referring to the row creator. Mike Hillyer -Original Message- From: Chuck Tomasi [mailto:Chuck.Tomasi;plexus.com] Sent: Monday, October 21, 2002 7:19 AM To: [EMAIL PROTECTED] Subject: RE: Using AUTO_INCREMENT like SEQUENCE - Resolved This past weekend the solution came to me. Simple, but elegant (well not as elegant as using the auto_increment feature natively, but a lot less code to write in my case.) I'm already used to managing a separate sequence so I too the AUTO_INCREMENT feature out of the main table (ex: mytable) and created a second table Create table mytable_seq (ID int not null primary key auto_increment); To 'seed' the table I put in the highest value from mytable (ex: select max(ID) from mytable). Now when I do this: Insert into mytable_seq values (NULL); Select LAST_INSERT_ID() from mytable_seq limit 1; I get what I want, what I need to create the file, populate mytable, etc. LAST_INSERT_ID() takes care of managing contentions (which I tested to no end.) That's the basics of my GetCounter($table) routine! My only gripe now is that mytable_seq continues to grow and grow (hence the need for LIMIT 1). I know it isn't a large table, but I may consider trimming it from time to time once I've verified its usefulness. --Chuck -Original Message- From: Peter Brawley [mailto:peter.brawley;artfulsoftware.com] Sent: Friday, October 18, 2002 11:39 AM To: Chuck Tomasi; [EMAIL PROTECTED] Subject: Re: Using AUTO_INCREMENT like SEQUENCE Chuck, last_insert_id() is per-connection. How do you see two users getting the same auto_increment value? PB - - Original Message - From: Chuck Tomasi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 18, 2002 9:07 AM Subject: Using AUTO_INCREMENT like SEQUENCE General Info: OS: Mac OS X MySQL version: 3.23.52 (Jaguar) PERL: 5.6.0 DBI: 1.30 I've got an application that was written to use Oracle sequences, as such the program pulls a sequence number then creates a file based on that number and populates a database record with infomation. I've read everything I can find out AUTO_INCREMENT values, but I can't seem to reproduce the same functionality without causing some possible conflict condition where two people may get the same numbers. At the heart of the matter is a Perl sub I call GetCounter(). It accepts a sequence name, pulls a value from the sequence and returns that value. Originally I was doing this with mSQL sequences. With a minor change to the code it ran fun in Oracle also. Now I'm looking at porting my stuff to MySQL, but can't seem to match the functionality. Note, I'm importing a lot of these records from the Oracle DB to MySQL so the counter would not be starting at 0. Thoughts so far: I've thought about select MAX(ID+1) from mytable, but if two people happen to be doing this at the same time, they'll get the same number - bad. select LAST_INSERT_ID(ID+1) seems like a similar solution since two people could get the same LAST_INSERT_ID(). I'd like some way to pull the number and make sure it is not pulled again. By the time I need the number, the information has been verified. The record will be populated using this number (ID field), a file will be created using this number, etc. I'd hate to have to do something like insert into mytable (ID) values (NULL) only to go back and select LAST_INSERT_ID(ID) from mytable update mytable set LastName='blah',FirstName='foo',Phone='xxx',... where ID=LAST_INSERT_ID() --Chuck - 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:
Re: mysql quota
I think you can set a max quota for a table. Insane - Original Message - From: Henry Umansky [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 21, 2002 8:08 PM Subject: mysql quota I want to let users on my system use MySQL, but I want them to have some sort of quota. Is there anyway to create a max database size with MySQL? I could just chown the directory in /var/lib/mysql, but that means I would have to create a username for each person and set filesystem quota. I really don't want to do that, I just want them to use mysql from a remote machine or through PHP. Henry Umansky University of Pittsburgh Systems/Programmer III www.pitt.edu/~hmust2 [EMAIL PROTECTED] (412)624-4357 - 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
try again
I have a Redhat linux box which has MySQL 3.23.52 loaded on it. I have mysql front loaded on a windows xp box which I am trying to use to connect to the mysql server. The error I am getting when trying to make a connection is 2013 - lost connection to MySQL server during query. I have checked to make sure that the Mysql server is running and that users were added to the mysql list with wide open permissions set just to see if I could get it working. I have tried re-installing the mysql software with the same result. Can you help? - 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 AB has reached a settlement with NuSphere Corporation
hi, MySQL AB is pleased to announce that it has settled its lawsuit with Progress Software Corporation and NuSphere Corporation. For more information, see the joint press release at http://www.mysql.com/press/release_2002_14.html Here's some background-info on the lawsuit: http://www.mysql.com/news/article-75.html http://slashdot.org/article.pl?sid=02/11/07/1942254mode=nestedtid=123 -daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Indexes LIKE
I was reading through the docs and it says: The following SELECT statements will not use indexes: mysql SELECT * FROM tbl_name WHERE key_col LIKE %Patrick%; mysql SELECT * FROM tbl_name WHERE key_col LIKE other_col; I am using MYSQL on windows. So is that true? When I use the below statement should I not index TitleName? SELECT A.TitleName, C.ActorName FROM Titles A, ActorTitle B, Actors C Where A.TitleID=B.TitleID AND B.ActorID=C.ActorID AND A.TitleName LIKE '%PartOfName%' ORDER BY A.TitleName ASC - 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 1030: Got error 124 from table handler
Hi, What does ERROR 1030: Got error 124 from table handler mean when trying to select a single value from a table created as a UNIOn of another table ? When selecting just the primary key from a UNION table, with MySQL 3.23.53 I get the following error - however if I select the primary key and any other field I get the select to work fine ?? Any ideas - thx dave mysql mysql select userId from Collaborate; ERROR 1030: Got error 124 from table handler mysql select userId,email from Collaborate ;+-+---+ | userId | email | +-+---+ | 178 | [EMAIL PROTECTED] | | 118 | [EMAIL PROTECTED]| | 119 | [EMAIL PROTECTED] | - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1030: Got error 124 from table handler
Pada Fri, 08 Nov 2002 01:59:20 + David Herring [EMAIL PROTECTED] menulis: What does ERROR 1030: Got error 124 from table handler mean when trying to select a single value from a table created as a UNIOn of another table ? root@slimmer:~# perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed Table corrupt ... do mysql repair table tablename; or shell# mysqlcheck -r -p db table -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.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: ERROR 1030: Got error 124 from table handler
Hi, In fact, it's : joce@forum:~$ perror 124 Error code 124: Wrong medium type 124 = Wrong index given to function but the solution to resolve the problem remains the same ;) Regards, Jocelyn - Original Message - From: Dicky Wahyu Purnomo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 08, 2002 2:11 AM Subject: Re: ERROR 1030: Got error 124 from table handler Pada Fri, 08 Nov 2002 01:59:20 + David Herring [EMAIL PROTECTED] menulis: What does ERROR 1030: Got error 124 from table handler mean when trying to select a single value from a table created as a UNIOn of another table ? root@slimmer:~# perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed Table corrupt ... do mysql repair table tablename; or shell# mysqlcheck -r -p db table -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1030: Got error 124 from table handler
Dicky, Thank you for the quick response - but it appears tables created as unions do not support these repair commands:- # bin/mysqlcheck -r -p test Collaborate Enter password: test.Collaborate error: The handler for the table doesn't support check/repair # mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 43 to server version: 3.23.52-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql repair Collaborate; ERROR 1064: You have an error in your SQL syntax near 'Vodafone_Collaborate' at line 1 mysql Any other ideas ? Would trying an older version of MySQL be useful ? thx dave Dicky Wahyu Purnomo wrote: Pada Fri, 08 Nov 2002 01:59:20 + David Herring [EMAIL PROTECTED] menulis: What does ERROR 1030: Got error 124 from table handler mean when trying to select a single value from a table created as a UNIOn of another table ? root@slimmer:~# perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed Table corrupt ... do mysql repair table tablename; or shell# mysqlcheck -r -p db table - 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: ERROR 1030: Got error 124 from table handler
Pada Fri, 08 Nov 2002 02:29:49 + David Herring [EMAIL PROTECTED] menulis: Dicky, Thank you for the quick response - but it appears tables created as unions do not support these repair commands:- # bin/mysqlcheck -r -p test Collaborate Enter password: test.Collaborate error: The handler for the table doesn't support check/repair # mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 43 to server version: 3.23.52-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql repair Collaborate; ERROR 1064: You have an error in your SQL syntax near 'Vodafone_Collaborate' at line 1 mysql on syntax, your forgot to add ... table ... should be like this : mysql repair table Collaborate; but it's only working if you're using MyISAM table type. -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.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: ERROR 1030: Got error 124 from table handler
What is the handler for Collaborate ?? (What does show create table Collaborate display ?) - Original Message - From: David Herring [EMAIL PROTECTED] To: Dicky Wahyu Purnomo [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, November 08, 2002 2:29 AM Subject: Re: ERROR 1030: Got error 124 from table handler Dicky, Thank you for the quick response - but it appears tables created as unions do not support these repair commands:- # bin/mysqlcheck -r -p test Collaborate Enter password: test.Collaborate error: The handler for the table doesn't support check/repair # mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 43 to server version: 3.23.52-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql repair Collaborate; ERROR 1064: You have an error in your SQL syntax near 'Vodafone_Collaborate' at line 1 mysql Any other ideas ? Would trying an older version of MySQL be useful ? thx dave Dicky Wahyu Purnomo wrote: Pada Fri, 08 Nov 2002 01:59:20 + David Herring [EMAIL PROTECTED] menulis: What does ERROR 1030: Got error 124 from table handler mean when trying to select a single value from a table created as a UNIOn of another table ? root@slimmer:~# perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed Table corrupt ... do mysql repair table tablename; or shell# mysqlcheck -r -p db table - 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: ERROR 1030: Got error 124 from table handler
Pada Fri, 8 Nov 2002 02:20:56 - Jocelyn Fournier [EMAIL PROTECTED] menulis: Hi, In fact, it's : joce@forum:~$ perror 124 Error code 124: Wrong medium type 124 = Wrong index given to function but the solution to resolve the problem remains the same ;) ups ... sorry ... :)) my mistake :D thx jocelyn ... ;-) sql,query -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.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
Copy Records in a table...
Hi everyone, I'm still learning MySQL. I have a database of 600 items. I am still adding products. Several of these products are identical in nature, but have maybe one or two columns that are different. Is there a way to write a SQL command that selects these items and then inserts them, and then updates them respectively with one command? Thanks, Doug MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error (61)
Pada Wed, 6 Nov 2002 15:44:58 + [EMAIL PROTECTED] menulis: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) any suggestions on this check your mysqld process, is it running or not ? ps ax (-edf for solaris) | grep mysqld if it's already running, try to find location of mysql.sock file, posibility : /tmp/ /var/lib/mysql/ /usr/local/mysql/data/ you can create a symbolic link from current location to /tmp or edit your my.cnf file for mysql.sock and point it to current location... -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.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: Error connecting to Mysql via Apache/PHP (Newbie)
Pada Thu, 7 Nov 2002 12:10:21 -0500 [EMAIL PROTECTED] menulis: Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3. I am trying to connect to my Mysql DB via Apache and PHP, but I get the following error: Warning: Unknown MySQL Server Host '' (1) in helloSql.php on line 3 Warning: MySQL Connection Failed: Unknown MySQL Server Host '' (1) in helloSql.php on line 3 Could not connect Here is the code I used. ?php // Connecting, selecting database $link = mysql_connect(localhost, root, mypassword) or die(Could not connect); print Connected successfully; is your mysqld running ? how to check ? run : shell# mysql -uroot -p is this the real code ? $link = mysql_connect(localhost, root, mypassword) if it is, so you should remove the sign, and looks like this : $link = mysql_connect(localhost, root, mypassword) -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.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
