Re: where do i get an authcode from ? - PLEASE GET ME UNSUBSCRIBED OFF THIS LIST....
nothing at all i'm afraid.. i think this requires a little shouting ... PLEASE GET ME UNSUBSCRIBED OFF THIS LIST thanks anna - Original Message - From: "Brian McDonough" [EMAIL PROTECTED] To: "anna soobrattee" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 10:42 PM Subject: Re: where do i get an authcode from ? I am having trouble too! The AutoResponder/SubScriber seems to be not working Did you hear anything positive on how to unsubscribe??? 120 emails per day while Traveling on Business is Tooo Much At 03:12 PM 3/21/01 -, anna soobrattee wrote: please tell how to get an auth code - i want to unsubscribe but i can't without an authcode. emailing the unsubscribe address doesn't work...i've been trying for weeks! thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Replication does not continue after removal/replace of network cable.
Jean-Luc Fontaine wrote: On Thursday 22 March 2001 16:46, Johan Vanroose wrote: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Replication does not continue after removal/replace of network cable. Description: Configuration. Two servers (PCs) running mysql, both are master and slave to each other. Replication using binary log. Updates done (from the mysql console) on either server are replicated to the other. (The application (I) takes care that the updates are not conflicting.) So far so good. Now the problem. I remove a network cable from one of the servers. I do an update (insert into table) on server 1. I do a second update (again insert) on server 2. Of course the updates aren't replicated (no communication possible). However... when I replace the cable, the replication is not done for the previous two inserts. I waited 4 minutes... Still no replication. Hmmm. The same thing happened to me with the 3.23.35 rpm on Linux Redaht 7.0. I had to do a 'slave stop/start' for the slave to recover. Did you get any further with this problem? I tried MySQL support. But since we have no support contract I did not get anything usefull back (yet). They say it's an NT problem but your situation seems to prove different. Also the whole system runs happy - even MySQL (without its replication). Since all looks OK (i.e. the log files and master/slave status) I assume that MySQL just *forgets* to replicate. Kind regards, Johan. -- Jean-Luc Fontaine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
http://lists.mysql.com/php/unsubscribe.php
I can't unsubscribe either - I do not receive an auth code from this page http://lists.mysql.com/php/unsubscribe.php after I've entered my email address, so I cannot unsubscribe myself. If someone can fix this page, then perhaps, people will stop sending "unsubscribe me" emails to this list... anna - Original Message - From: "Phillip Vamplew" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: "Arne Claassen" [EMAIL PROTECTED]; "Heikki Tuuri" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 26, 2001 11:48 AM Subject: RE: Signal 11 on Innobase table range queries Please unsubscribe me from the list. -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 10:35 AM To: [EMAIL PROTECTED] Cc: Arne Claassen; Heikki Tuuri; [EMAIL PROTECTED] Subject: Re: Signal 11 on Innobase table range queries Hi! "Jeremy" == Jeremy D Zawodny [EMAIL PROTECTED] writes: Jeremy On Sun, Mar 25, 2001 at 09:52:22PM -0800, Arne Claassen wrote: I've got a reproducable signal 11 death in mysqld using Innobase tables and range queries (at least reproducable on my machine, Redhat 6.2, mysql 3.23.35). Here's how it manifests itself: Create a table with at least 32 columns. Then load a row or two into the table and try to do any query using a range (, , between, in) on the primary key and i get this: mysql select * from foo where id 1 limit 1; Jeremy [snip] Let me know if anyone can reproduce this, as it's quite the nuisance... Jeremy Yep. I've got a similar result here. Jeremy To reproduce you only need one row in the table: cut Thanks for the test case; We will fix this shortly and then release 3.23.36 that will contain the fix for this. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: GUI
Jack Ince writes: Why is the table of columns off by 1 ? The registration seems to bypass the privileges column. Thanks ~~~jci~~~ Sorry, but your question is hard to understand. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Signal 11 on Innobase table range queries
Hello All of you , can you please tell me how to configure WEBLOGIC server with MYSQL database . It is giving findByPrimaryKey error on my CMPs Thanks in adcance Neelesh - Original Message - From: "Michael Widenius" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: "Arne Claassen" [EMAIL PROTECTED]; "Heikki Tuuri" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 26, 2001 4:05 PM Subject: Re: Signal 11 on Innobase table range queries Hi! "Jeremy" == Jeremy D Zawodny [EMAIL PROTECTED] writes: Jeremy On Sun, Mar 25, 2001 at 09:52:22PM -0800, Arne Claassen wrote: I've got a reproducable signal 11 death in mysqld using Innobase tables and range queries (at least reproducable on my machine, Redhat 6.2, mysql 3.23.35). Here's how it manifests itself: Create a table with at least 32 columns. Then load a row or two into the table and try to do any query using a range (, , between, in) on the primary key and i get this: mysql select * from foo where id 1 limit 1; Jeremy [snip] Let me know if anyone can reproduce this, as it's quite the nuisance... Jeremy Yep. I've got a similar result here. Jeremy To reproduce you only need one row in the table: cut Thanks for the test case; We will fix this shortly and then release 3.23.36 that will contain the fix for this. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Any ideas on how to optimise this ?
Hi peeps, I've got a table which is basically a log of traffic on one of my websites - I have a seperate table per month, all of which are MERGED for queries which need access to more than a month's worth of data. select count(distinct cookie) as c,dayofmonth(event_time) as d from tbl_webevents where event_time = '2001-02-01 00:00:00' and event_time '2001-03-01 00:00:00' group by d; This query currently takes in excess of 20 seconds to return a result (tbl_webevents is the merge table, consisting of 6 x 250,000 row table). Does anyone have any suggestions as to whether this could be sped up ? All ideas welcome! Thanks, P - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I N S T A L L
Greetings ! I am using Windows2K and have php in it. I want to install MySQL also in my computer. How can I do this? I am using IIS. Looking forward to hearing from you. Warm Regards, Deependra B. Tandukar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SELECT... ORDER BY RAND() LIMIT x FAILS
[EMAIL PROTECTED] writes: Description: The documentation says that I can do: select * from table order by rand() limit 10 as an example, however it fails and there is no error message. I *can* do: select * from table order by rand() which works fine. It just seems that adding the limit clause causes something to break. How-To-Repeat: Easy way: mysql mysql select * from users order by rand() limit 10 On my database machine using the latest stable binray release it fails. Fix: None known Submitter-Id: submitter ID Originator: Shawn Wallace Organization: Justweb Inc. MySQL support: [none | licence | email support | extended email support ] Synopsis: Problem combining order by rand() with limit Severity: serious Priority: medium Category: mysql Class: sw-bug Release:mysql-3.23.35 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.18 Distrib 3.23.35, 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.35 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 5 hours 56 min 1 sec Threads: 3 Questions: 160022 Slow queries: 0 Opens: 106 Flush tables: 1 Open tables: 100 Queries per second avg: 7.491 Environment: System: Linux darthvader 2.2.18pre21-RAID #2 Wed Feb 14 17:21:03 EST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs gcc version 2.95.2 2220 (Debian GNU/Linux) Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Mar 12 13:22 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 887712 Jan 15 15:06 /lib/libc-2.1.3.so -rw-r--r--1 root root 2089496 Jan 15 15:07 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 15 15:07 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db --without-innobase '--with-comment=Official MySQL RPM' Perl: This is perl, version 5.005_03 built for i386-linux Hi! I tested the above and it worked just fine for me. What exactly did not work. Please check that your table is not corrupt. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: http://lists.mysql.com/php/unsubscribe.php
In a message dated 26/03/2001 12:14:36 GMT Daylight Time, [EMAIL PROTECTED] writes: I can't unsubscribe either - I do not receive an auth code from this page http://lists.mysql.com/php/unsubscribe.php after I've entered my email address, so I cannot unsubscribe myself. If someone can fix this page, then perhaps, people will stop sending "unsubscribe me" emails to this list... anna This page DOES work, I changed my email address two days ago and so had to unsubscribe and then subcribe. It does take a while for the page to actually send you the code, but it does work if your patient. Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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[32]: Warning: Got signal 14 from thread X
BAUMEISTER Alexandre writes: Heikki, If I run Mysql without having any client connected nor doing any "mysqladmin xxx" command, the is no Warning messages. Only : 010326 11:43:29 mysqld started Innobase: Started /usr/local/mysql/libexec/mysqld: ready for connections If I do "mysqladmin ping" , "mysqladmin status" ... no problems. As soon as I run my daemons : 010326 11:47:28 Warning: Got signal 14 from thread 4 010326 11:47:30 Warning: Got signal 14 from thread 4 010326 11:47:32 Warning: Got signal 14 from thread 4 010326 11:47:34 Warning: Got signal 14 from thread 4 another thing really interesting is that if I do a lot of "mysqladmin proc", then the Warning messages are paused. I explain. I'm doing a "tail -f myserver.err" on a console. Then I see that about each 2 seconds I got a "Warning ... message". On another console I do "mysqladmin proc" and as soons as I get the result I do another "mysqladmin proc" and so on ... Then I noticed that while I'm doing "mysqladmin proc", the "Warning" messages are no more send to error log. A soon as I stop doing "mysqladmin proc", the "Warning" messages are coming back :( This seems very incomprehensible to me, but I though maybe this could be a clue for you. NB: I did the test with "mysqladmin ping" , "mysqladmin status" and it's the same than with "mysqladmin proc". Regards, Alex. Hi! Seems like Innobase has introduced some timeout ( I do not see how) on the sleeping connections. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication does not continue after removal/replace of network cable.
On Monday 26 March 2001 12:19, Johan Vanroose wrote: Jean-Luc Fontaine wrote: On Thursday 22 March 2001 16:46, Johan Vanroose wrote: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Replication does not continue after removal/replace of network cable. Description: Configuration. Two servers (PCs) running mysql, both are master and slave to each other. Replication using binary log. Updates done (from the mysql console) on either server are replicated to the other. (The application (I) takes care that the updates are not conflicting.) So far so good. Now the problem. I remove a network cable from one of the servers. I do an update (insert into table) on server 1. I do a second update (again insert) on server 2. Of course the updates aren't replicated (no communication possible). However... when I replace the cable, the replication is not done for the previous two inserts. I waited 4 minutes... Still no replication. Hmmm. The same thing happened to me with the 3.23.35 rpm on Linux Redaht 7.0. I had to do a 'slave stop/start' for the slave to recover. Did you get any further with this problem? I tried MySQL support. But since we have no support contract I did not get anything usefull back (yet). This mailing list provides plenty of great support, and I take this opportunity to thank the MySQL people once more (and they deserve much more than that). They say it's an NT problem but your situation seems to prove different. Also the whole system runs happy - even MySQL (without its replication). Since all looks OK (i.e. the log files and master/slave status) I assume that MySQL just *forgets* to replicate. Since I am running a production system, I am not touching anything till the 3.23.36 release. -- Jean-Luc Fontaine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Any ideas on how to optimise this ?
Hi Peter, On Mon, Mar 26, 2001 at 12:20:14PM +0100, Peter Skipworth wrote: I've got a table which is basically a log of traffic on one of my websites - I have a seperate table per month, all of which are MERGED for queries which need access to more than a month's worth of data. select count(distinct cookie) as c,dayofmonth(event_time) as d from tbl_webevents where event_time = '2001-02-01 00:00:00' and event_time '2001-03-01 00:00:00' group by d; Could you post an EXPLAIN SELECT ... for this? This query currently takes in excess of 20 seconds to return a result (tbl_webevents is the merge table, consisting of 6 x 250,000 row table). How long does the query take on the unmerged table for februari? Just for comparison of course. The optimizer doesn't work as well on MERGE tables as it does on regular tables. You might need to explicitly tell it to use a certain index with SELECT ... FROM tbl_webevents USE INDEX (...) WHERE ... Could you post an EXPLAIN SELECT ... for this single table as well? Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
importing data from FileMaker Pro to MySQL
Hi, I have to import Datas From FileMaker Pro to MySQL . Unfortunately, the FileMaker web site is speaking about plugins to export databases, but the access page gives error 500 (!). Then, I try this mailling list, and there is my question : is there any defined tool to import datas into MySQL Databases, that may also read the FileMakerPro Format, or any standard CSV format ? I thought about developping something myself, in Perl (quite easy to use ...), but there is also no Perl module avaliable for FileMaker ... Thanks, Fred
RE: Default Date value
I tried before writing you and wasn't able to. Maybe someone else can figure out how but it looks like default will only take a constant as a parameter. Cal http://www.calevans.com -Original Message- From: Michael Blood [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 25, 2001 11:48 PM To: Cal Evans; MYSQL Subject: RE: Default Date value Is it possible to set a function as a default value for a column at all. I apologize if I come off a bit dumb about this but I come from an MSSQL background where you can set a default to a function. Thanks Again -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 25, 2001 4:06 PM To: Michael Blood; MYSQL Subject: RE: Default Date value BlankI don't think you can do that with a default value. You will need to include the current date in your insert statement. Cal http://www.calevans.com -Original Message- From: Michael Blood [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 25, 2001 5:30 PM To: MYSQL Subject: Default Date value I am trying to set the default value in a date field to be the time that it was created However I do not want the field to be a timestamp because I want to update it to a different value later. I have looked through the mysql documentation and I can not seem to find anywhere that explains how to set the default value of a column = to a function. Anyone have any help? Thanks in advance Michael Blood Matraex Technologies [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: Another MSSQl to mysql question.
It doesn't currently. Currently, you can't use subselects. Cal http://www.calevans.com -Original Message- From: Michael Blood [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 5:12 AM To: MYSQL Subject: Another MSSQl to mysql question. does any one know how mysql can handle an exists query. for example select xcolumn from ytable where exists (select 1 from ztable where ytable.id = ztable.id) I realize that in this particular example I can rearrange my query but there are lots of other queries where I find it necessary. Thanks Michael Blood Matraex Technologies [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: size limitation
Hi, the database I would like to managed is constitued by one table. This table is made of 3 columns, with no primary key mysql CREATE TABLE test ( id1 int(8) unsigned, id2 int(4) unsigned, id3 int(4) unsigned ); mysql CREATE INDEX idx_id1 ON test (id1); mysql CREATE INDEX idx_id2 ON test (id2); mysql CREATE INDEX idx_id3 ON test (id3); We use 3 indexes because our benchmark shown that it's better than an index on the 3 columns for our application. mysql desc test; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+ | id1 | int(8) unsigned | | MUL | 0 | | | id2 | int(4) unsigned | | MUL | 0 | | | id3 | int(4) unsigned | | MUL | 0 | | +-+-+--+-+-+---+ Here are the request we make on this table : SELECT COUNT(*) FROM test WHERE id1=? AND id2=?; SELECT COUNT(*) FROM test WHERE id1=? AND id=2=? AND id3=?; INSERT INTO test (USER_ID, FLIGHT_ID, FLIGHTOBJECT_ID) values (?,?,?); The row size is 16 bytes. So we'll get 16 gigabytes of datas per day (it will be around 10 gigabyte in reality because only 66% of the request need an insert). The table is going to grow until we'll drop it (because of storage limitations). 10 days of lifetime for our datas will be enough :) We make no update in order to be very quick. -Message d'origine- De: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Date: samedi 24 mars 2001 15:31 : [EMAIL PROTECTED]; [EMAIL PROTECTED] Objet: Re: size limitation Pascal, could you describe what indexes you should have on the data, and how you will add to it and delete from it? In order to choose a DBMS, i've to check to MySQL is able to support our requirements. I've got to manage one database. This database is made of one table. This table will grow very quickly (we evaluate that we'll have to make arround 1.000.000.000 inserts per day). Do you really mean one billion inserts per day? 1000 million inserts? If the row size is 100 bytes, you will get new data 100 gigabytes per day. If you have a terabyte of disk, you can only fit 10 days' data in it. I want to be sure that MySQL is able to manage table bigger than 1 TeraOctet. Does anyone have already use in similar condition ? I read that innobase table allows to store a table on several oracle-like "tablespace" that can be created on several disks. I think we can put the indexes on other disk too (using symbolic links). An Innobase tablespace can span 4 billion database pages, that is, 64 terabytes with the default page size of 16 kB. A single file of a tablespace can currently hold 2 GB or 4 GB depending on your OS. You would need some 500 data files in your tablespace. You cannot currently instruct Innobase where to put your data and index trees (all go into the same tablespace). But, if your table is so huge, both the data and the indexes will lie on several disks, since a single disk can store max 80 GB of data today, I think. If you have 1 billion insertions per day, that is 12 000 inserts per second around the clock. The CPU usage of Innobase would allow you to do this many insertions. The problem can be the communications overhead between your client process and the MySQL server. It might use even 100 microseconds per insert. You can reduce this overhead by using the multiple INSERT INTO ... VALUES (...), (...), (...) insertion syntax of MySQL. Another problem is the number of disks you need: if you have to make 12 000 random insertions per second, you need a disk farm of some 200-500 separate disks. The operating system will use some CPU for each disk i/o. If you have to read and write 12 000 16 kB pages each second, you need a bandwidth of 400 MB/second in your disk channel. These numbers are similar to the largest TPC-C benchmarks run today. The hardware will be expensive. You can look at www.tcp.org, where you find descriptions of the benchmark systems and their prices. I would like to know what are the requirement to store so much records. Does anyome have reference of site that manage a table bigger than 1 tera ? The largest databases in the world are of the order 4 - 40 TB. I think many of them use Teradata database machines. Some use Oracle. Did someone try that ? I hope it's possible. Otherwise, i'll to choose Oracle :( and Oracle is not cheap. Regards,-- MySQL/Innobase may be able to do what you need, but we should have a real-world test of using a big disk farm. I do not know if any MySQL user uses a disk farm. Maybe Jeremy Zawodny knows? Regards, Heikki Pascal ThiventGroupe SQLIWeb : http://www.sqli.com/ http://www.sqli.com Mail : mailto:[EMAIL
RE: size limitation
Hi, For our benchmarks, we use for the MySQL Server a Sun Enterprise 3500 with 4 UltraSPARC processors, 6 Go of RAM, 3 disks of 40 Go... MySQL runs under Solaris 7. -Message d'origine- De: Jeremy D . Zawodny [mailto:[EMAIL PROTECTED]] Date: vendredi 23 mars 2001 19:11 : Pascal THIVENT Cc: [EMAIL PROTECTED] Objet: Re: size limitation On Fri, Mar 23, 2001 at 11:33:42AM +0100, Pascal THIVENT wrote: I've got to manage one database. This database is made of one table. This table will grow very quickly (we evaluate that we'll have to make arround 1.000.000.000 inserts per day). What sort of hardware are you planning to use? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [OT] SQL syntax qestion
Thanks, I tried the latter, but it didn't work. I'll try you're suggestion. curtis - Original Message - From: "Quentin Bennett" [EMAIL PROTECTED] To: "'Curtis Maurand'" [EMAIL PROTECTED]; "MySQL List" [EMAIL PROTECTED] Sent: Monday, March 19, 2001 11:44 PM Subject: RE: [OT] SQL syntax qestion Hi, Yes, in MySQL you can go select handle, sum(total) as t group by handle order by t; in ANSI (?) you can go select handle, sum(total) group by handle order by 2; 2 being the column number of the result. Regards Quentin -Original Message- From: Curtis Maurand [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 20 March 2001 4:28 p.m. To: MySQL List Subject: [OT] SQL syntax qestion Hi, Just a quick quesiton, I have a table that contains difined as create table picks( handle char(30) primary key, ... total int unsigned); there is a user table that has a list of handles and other user info. handle is the primary key. If I issue the command "select handle, sum(total) group by handle;" I get the information that I'm looking for, however I'd like to sort it by the sum that I get. Is there a way of accomplishing this? Curtis The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
nested selects
Is mySQL able to perform nested selects? If so can anyone provide me with an example If not can you provide an alternate solution Thanks Philip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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[34]: Warning: Got signal 14 from thread X
Bonjour, SM Seems like Innobase has introduced some timeout ( I do not see how) on SM the sleeping connections. I've been trying a few other things. When I run Mysql with Innobase, if no client connects, no "Warning signal 14" messages in the error log. Then I run a client which only logs on the server (no other queries). I then have to wait a few seconds (not always the same delay) before inevitably having some "Warning signal 14" messages. One message each 2 seconds : 010326 15:09:16 Warning: Got signal 14 from thread 4 Always thread 4 (even if thread 4 doesn't exist, but I've seen that while there actually was a thread Id 4). So, 1 message each 2 seconds. If I do "mysqladmin xxx" (ping, status, processlist) , there is a pause in the writing of "Warning signal 14 messages" of about 4 seconds and then ... messages are back. Then if I stop the client (so no more opened connections to Mysql), error log still receives "Warning signal 14" messages, one each two seconds. If then I do a "mysqladmin ping or status or ..." , the "Warning signal 14 messages" stop being sent to error log ... and don't come back. If I run 30 clients connecting (but doing no queries), I still have messages about signal 14 and thread 4. If I make my daemons start working (doing some update/insert queries) then I receive Warning messages but not only from thread 4, from other threads too. Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: importing data from FileMaker Pro to MySQL
Hi, I have to import Datas From FileMaker Pro to MySQL . Unfortunately, the FileMaker web site is speaking about plugins to export databases, but the access page gives error 500 (!). Plug-ins? You don't need any plug-ins to export data to MySQL. The only plug-in for Filemaker I've ever heard of concerning MySQL is one that allowed you to access MySQL data through Filemaker. Then, I try this mailling list, and there is my question : is there any defined tool to import datas into MySQL Databases, that may also read the FileMakerPro Format, or any standard CSV format ? MySQL will import data from CSV format quite happily, with no extras required. I thought about developping something myself, in Perl (quite easy to use ...), but there is also no Perl module avaliable for FileMaker ... I would be extremely surprised if there was! I think you're getting into extremely muddy waters here. What you're trying to do is very simple. Just open your Filemaker database, export the fields you want to a tab-seperated text file, transfer that file to your MySQL server (make sure you convert Mac line breaks to UNIX too) and import the file using the LOAD DATA statement in the MySQL command-line client. Regards, Basil Hussain ([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 vs ....
[EMAIL PROTECTED] wrote: The biggest reason to avoid Microsoft products when I choose platforms and tools for projects is missing freedom. I never know why but maybe I really like MSSQL but I have some reason to drop NT - I can't do this. MSSQL runs only on NT. In own projects I always try to keep myself free from any limits to be ready to migrate in case of emergency. Let me play devils advocate here. (Remember this is _not my_ opinion!) If I were to say something like that at my work, I'd get the following response: "Why would we EVER consider dropping something like NT. Yeah, I know you like UNIX systems, Yeah, I know they are more reliable, Yeah, I know they are faster, non-bloated, etc. Yeah, I know its more expensive to maintain, But I don't want to sell a UNIX solution to our customers." Unfortunately, this is a widly held attitude. My rebuttal always is: "We are not in the OS business, we don't sell operating systems... we sell solutions... vertical solutions. 'No user serviceable parts inside.' Our customers never even see the OS, when they use the product." "Oson, Chris M." [EMAIL PROTECTED] wrote: Not only that, but mySQL "forces" you to learn SQL. Not by wizards that build the SQL statement for you. Again, the MS proponents (and my people) would say that: "'wizards' are a good thing... A _great_ thing, and any software that doesn't have wizards, is a backwards, antiquated software that isn't user friendly..." Sorry, If I sound cynical here, but I go through these arguments every day. But having said all that, I still only develop non-MS solutions, using open-source (and as license free as possible). Much to the envy of my cohorts, who are _forced_ to develop on MS platforms with MS tools, who patiently tolerate those un-friendly tools, anomolous behaviour, and fairly slow development cycles. --- Fulko Hew, Voice: 905-333-6000 x 6010 Senior Engineering Designer, Direct: 905-333-6010 Northrop Grumman-Canada, Ltd.Fax:905-333-6050 777 Walkers Line,Email [EMAIL PROTECTED] Burlington, Ontario, Canada, L7N 2G1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Signal 11 on Innobase table range queries
Hi! I found the bug: memory was written over in the function which estimates the number of rows in ha_innobase.cc. The bug is fixed in version 3.23.36, which may be out today. You can also fix the bug by editing ha_innobase.cc, about line 2460. The last argument in the two calls to dict_index_copy_types should be key-key_parts: . range_start = dtuple_create_for_mysql(heap1, key-key_parts); dict_index_copy_types(range_start, index, key-key_parts); range_end = dtuple_create_for_mysql(heap2, key-key_parts); dict_index_copy_types(range_end, index, key-key_parts); . In the buggy version the last argument was the number of fields in the clustered index, and when the table had many columns this caused some overwrite of memory. I will run sql-bench with memory debugging switched on to check if there are similar errors. It has been a while since I last time switched memory debugging on in the tests, and that is maybe the reason the bug got past the tests. Regards, Heikki At 10:01 PM 3/25/01 -0800, you wrote: On Sun, Mar 25, 2001 at 09:52:22PM -0800, Arne Claassen wrote: I've got a reproducable signal 11 death in mysqld using Innobase tables and range queries (at least reproducable on my machine, Redhat 6.2, mysql 3.23.35). Here's how it manifests itself: Create a table with at least 32 columns. Then load a row or two into the table and try to do any query using a range (, , between, in) on the primary key and i get this: mysql select * from foo where id 1 limit 1; [snip] Let me know if anyone can reproduce this, as it's quite the nuisance... Yep. I've got a similar result here. To reproduce you only need one row in the table: ---snip--- create table in_crash ( aint primary key, bint, cint, dint, eint, fint, gint, hint, iint, jint, kint, lint, mint, nint, oint, pint, qint, rint, sint, tint, uint, vint, wint, xint, yint, zint, a1 int, a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int, b1 int, b2 int, b3 int, b4 int, b5 int, b6 int ) type = Innobase; insert into in_crash values (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 ,1,1,1); explain select * from in_crash where a 0 and a 50; *boom* ---snip--- Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: nested selects
If you mean: Select * from table where tableID in (Select tableID from table2); Then no, MySQL does not support them. They mythical version 4.0 might. :) Cal http://www.calevans.com -Original Message- From: Philip Traynor [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 7:06 AM To: '[EMAIL PROTECTED]' Subject: nested selects Is mySQL able to perform nested selects? If so can anyone provide me with an example If not can you provide an alternate solution Thanks Philip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: nested selects
Sinisa, Is there a published list of features for 4.0? Cal http://www.calevans.com -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 8:06 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: nested selects Cal Evans writes: If you mean: Select * from table where tableID in (Select tableID from table2); Then no, MySQL does not support them. They mythical version 4.0 might. :) Cal http://www.calevans.com Actually, they will be in 4.1. And the above query does not need subselects. Try it : Select table.* from table, table2 where table.tableID = table2.tableID; Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql Server Client Myodbc Silent Install
Is there any spesification for Installing Mysql Server Clients Myodbc. I mean if i try to install binaries in my own installation script what else i need to do? What registry keys required. Which dll's need to be copy to Windows , Windows/System etc Regards Yusuf Incekara Avukatpro Limited Sirketi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
alter table error
Can anyone tell me what this means and how to fix it? I ran the below query to simple add another index and this is what i got. Thank you. mysql alter table message add index subject2 (subject(10)); ERROR 1034: 126 for record at pos 176850808 - Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Unix Q? timezone file?
At 7:59 -0800 26/3/01, Ashish Shah wrote: What is the string that you would use to set "AST" time zone file ? Use GMT+4 for AST. This file has no daylight component and will hold a static 4 hour difference as you want. # zdump GMT GMT Mon Mar 26 16:18:17 2001 GMT # zdump GMT+4 GMT+4 Mon Mar 26 12:18:21 2001 GMT You could always make a symlink from GMT+4 to AST and use that... Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.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
MySQL Approach97
Hi All! I'm new in the mailing list just want to know about the data transfer from Approach97 to MySQL. In my company we are running Approach97 for fullfil our database need but now my boss want to make this database online. I'v heard a lot about MySQL ( Speed / Stability etc. ) but want to know that is it possible to export data from Approach97 to MySQL or Import in MySQL from Approach97 or anyother option to do this?? Awaiting helpful reply. Thanks Regards / Sulman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_FILE and replication
On Mon, 26 Mar 2001, Maros Klempa wrote: Hi, I have two servers with MySQL 3.23.24-beta. One as master and one as slave. Replication between this two servers work fine. Now I want store pictures to table. On master server I use command INSERT INTO PICTURES (ID, PICT) VALUES (1, LOAD_FILE( '/images/image.jpg')). It work o.k. MySQL save file image.jpg to table PICTURES. But when I look to table PICTURES on slave server in field ID is value 1 but field PICT is empty. Why? Work function LOAD_FILE with replication correctly? I'll just guess here: at the slave side, the command is ran excactly the same way. This means that the slave will try to do a LOAD_FILE('/imag...') looking for the image at its local fs. Of course will fail because the image doesn't reside on its filesystem. I think something similar was mentioned some weeks ago with regard to a LOAD DATA INFILE... at the master side, in which case again the input_file didn't resize on the slave filesystem and so the call failed. Correct me if i'm wrong. regards, thalis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ISP
Hi! Who knows any good ISP giving root access to Mysql? Get free email and a permanent address at http://www.netaddress.com/?N=1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: alter table error
Well, I wanted to limit the size of the index so it wouldn't take up a lot of space. The message table is about 500mb right now and is going to get a lot bigger. Well not limiting the size of the index get rid of the error? Original Message On 3/26/01, 11:35:19 AM, "LIBASOV IOANNIS" [EMAIL PROTECTED] wrote regarding Re: alter table error: It's better like this: alter table message add index subject2 (subject); - Original Message - From: "Daniel Adams" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 26, 2001 7:19 PM Subject: alter table error Can anyone tell me what this means and how to fix it? I ran the below query to simple add another index and this is what i got. Thank you. mysql alter table message add index subject2 (subject(10)); ERROR 1034: 126 for record at pos 176850808 - Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Replication troubles
Just a follow up- I got replication working, the error was (as usual) simple... in the MySQL Replication HOWTO, it says 'Add the following to my.cnf on the slave(s): I of course (:P) put them at the end of the file, they must go under [mysqld]. But hey, it works! Thanks -Original Message- From: Jeremy D . Zawodny [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 25, 2001 3:30 AM To: Bryan Coon Cc: [EMAIL PROTECTED] Subject: Re: Replication troubles On Fri, Mar 23, 2001 at 10:45:00AM -0800, Bryan Coon wrote: I have two machines which I am trying to set up replication on. I followed the howto as describe in the manual, and everything seemed to be okay (i.e. no errors), but it simply doesn't work. Heres what I did on the master: 1. Copied /usr/share/my-large.cnf to /etc/my.cnf 2. my.cnf already had log-bin, server-id=1, so I didnt touch anything else 3. Granted file to user repl as in howto 4. Shut down master 5. Tarred data dir, copied it to slave 6. Restarted master Heres what I did on the slave: 1. Copied /usr/share/my-large.cnf to /etc/my.cnf 2. Added following info: master-host = 172.34.123.34 # IP of master master-user = repl master-password = repl master-port = 3306 server-id = 2 3. Untarred data directories to /var/lib/mysql 4. Verified permissions on directories/files untarred 5. Restarted slave The my.cnf file appears to be read okay, because on both machines began generating the binary log files immediately. Both machines report everything normal and happy, with no entries in the .err log files. Users can connect to each machine independently and its business as usual. There is no file 'master.info' generated on the slave (I even checked on the master too)... That's sort of strange... Does "SHOW SLAVE STATUS" on the slave say anything interesting? What if you do a "SLAVE START" on the slave? You're sure that there is literally nothing related in the *.err file on the slave? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: alter table error
On Mon, 26 Mar 2001, Daniel Adams wrote: Well, I wanted to limit the size of the index so it wouldn't take up a lot of space. The message table is about 500mb right now and is going to get a lot bigger. Well not limiting the size of the index get rid of the error? Actually you should be able to do that, and it is quite advisable. I assume/guess that the error code returned with your error message is actually '126'. Looking it up with perror, I get: 126 = Index file is crashed / Wrong file format If this is correct, it would be nice to ran a myisamchk to check on your indeces and then try again. regards, thalis Original Message On 3/26/01, 11:35:19 AM, "LIBASOV IOANNIS" [EMAIL PROTECTED] wrote regarding Re: alter table error: It's better like this: alter table message add index subject2 (subject); - Original Message - From: "Daniel Adams" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 26, 2001 7:19 PM Subject: alter table error Can anyone tell me what this means and how to fix it? I ran the below query to simple add another index and this is what i got. Thank you. mysql alter table message add index subject2 (subject(10)); ERROR 1034: 126 for record at pos 176850808 - Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
win BDB
Hi, I downloaded the mysql-3.23.35a-win-src.zip. I can't find in the documentation if: - BDB is include or not - How can I configure or install: the information seems for the unix env. Please, can you help me?
RE: Re[2]: MySQL vs Microsoft SQL
James, Gotta say that this is a bad reason to choose one product vs. another... because it lacks a GUI to build queries? Undertanding SQL is all well and good, but I can tell you that I would give anything to have a query builder that works like the one for MS SQL server. You may enjoy writing incredibly long join queries because it demonstrates your understanding of SQL syntax. Personally, I'd rather spend my time watching grass grow. What is the value of doing something in code which is inherently visual, and is a lot easier to do visually? You do make a valid point, part of the reason I like M$SQL is that you can build complex expressions with their GUI tools, but Last year, I did some work for a client and he requested that I do it in-house. Now, since I was on a deadline (2 weeks), I figured I'd use the Enterprise Manager to build my stuff and off and away I go. Well, for some strange reason I was never able to determine why, but it took 15-20 minutes to connect to a database on the East Coast. When I attempted to connect via the query analyzer, the connection was instantaneous. I learned by visual means to create tables, add triggers, yada, yada, yada... Well, this was definitely a learning experience because now I had to learn how to do everything by DML via the query analyzer if I was going to meet this deadline. Now I prefer to do all my work using a command-line tool. I recently upgraded to SQL2000 on my machine at home and have encountered the same situation again! Fortunately, I can drop out of GUI-mode and work by DML until I can figure how why this happens. I understand that every user has a right to choose how they want to work, but I often see colleauges using a GUI tool to change a datatype or some other menial task (often with several mouse clicks and waiting for the GUI tool to open up) which can cause one to lose more productivity when more often than not, to do it one simple command from a production standpoint makes no sense to me. A query builder will not make a database developer out of a novice, but it can make a professional developer's job a lot easier. True. I can spend my time writing complex code that can't be done with a tool, and not waste it doing repetitive, boring joins that take a few seconds with a visual tool. That's where I do agree with you, and one of the things I don't like about M$SQL. To a certain degree, wizards are nice, but when it lulls a user into a false sense of security about being able to build queries quickly, what do you do when it doesn't become available? It's like a cashier saying to you that they can't give you change, because they don't know how to do it without a machine??!! (Don't laugh, I've had that happen to me on many occassions) Sorry to make this so long My $0.02 Christopher Oson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ISP
On 26 Mar 2001, at 19:48, Daniel Mercury wrote: Who knows any good ISP giving root access to Mysql? Best I know of is iserver.com. http://www.iserver.com/support/virtual/mysql/install.html Peter --- "Reality is that which, when you stop believing in it, doesn't go away". -- Philip K. Dick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RTFM (was: *sigh* Re: Is it a bug? )
Cal, satire 1 I would love to see this list split into 2 lists. MySQL-Newbies and MySQL-non-newbies. Non-newbies would be either an invitation-only list or you have to pass a test to get in. (The test would contain questions that are all in the manual, we don't care if you know, we care if you will bother to look-up!) /satire 1 satire 2 One of the requirements of being on MySQL-non-newbies, other than the RTFM thing, would be that you have to help at least 1 newbie a day. If you go 5 days without getting a gold star from a newbie then you get kicked form the non-newbies club. /satire 2 Ok, so I'm being silly. Oh really? Which part? satire 1 or satire 2? When I was learning ASP, Charles Carroll runs a message list similar to this one but categorized by certain groups. ASPFreeForAll - Post anything here... ASPNotNewbie - People who ask newbie questions on this list get *slammed* as they should. I'd like to see something similar here. Any other thoughts??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: question
We are going to buy a cobalt req i4 server as a dedicated hosting server. It has MySQL software and a control panel. Do you know if this control panel can manage the MySQL or not (For creating and removing DBs and tables not more)? Prior versions of Cobalt's control panel don't--they also don't come with MySQL pre-installed either. In any case, I would recommend mysqltool for web based mysql administration: http://www.dajoba.com/projects/mysqltool/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Best way to generate laser-printed reports from mysql
I am wondering how most users generate reports from mysql that they can print on a laser printer (e.g. invoices)? HTML is fine if the report is only 1 page long. I guess some people user something like Crystal Reports via ODBC, but I wonder what most people do??? I use StarOffice. Adam -- Adam Stein @ Xerox Corporation Email: [EMAIL PROTECTED] Disclaimer: All views expressed here have been proved to be my own. [http://www.csh.rit.edu/~adam/] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: v4.0 feature list
From this feature list, it sounds like you are creating methods (multi-deletes, updates from joins) that will take the place of transactions. Is this the direction that MySQL is heading? Do you believe that these methods will be preferred over traditional rollback/commit transactions with BDB or Gemini? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, March 26, 2001 6:21 AM Subject: RE: nested selects Cal Evans writes: Sinisa, Is there a published list of features for 4.0? Cal http://www.calevans.com It is not complete yet. But, new .frm files, multi deletes and updates from joins, UNION's and many others. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Feuere Deinen Boss !!!
Wenn Sie am diesem List posten, bitten Sie nur English schreiben. Auch, ist dieses List nur fur MySQL Fragen. -Original Message- From: Job-Mobil [mailto:[EMAIL PROTECTED]] Sent: None To: [EMAIL PROTECTED] Subject: Feuere Deinen Boss ! Warum immer wieder für andere arbeiten, wenn Sie DM 2.000,- pro Woche für sich selbst haben können ! Weitere Informationen nur unter: [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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 create table with non-standard character?
Hi, In my case, some of tables are created according to people's name, e.g. when user adds new name: firstname lastname it should create table in background = firstname_lastname But problem occurs when user name contains ', e.g. firstname's lastname, I had it encoded first, java.net.URLEncoder.encode(firstname's lastname) which turn to = firstname%27s_lastname, but it still gives error because of %. Does anybody know if there is a way to work around this problem, or this is totally impossible? Thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: inserting into mysql database in linux using C
l. -Original Message- From: john lin [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 25, 2001 2:56 PM To: [EMAIL PROTECTED] Subject: inserting into mysql database in linux using C I am a senior in Polytechnic University working on my senior project. I have chosen MySQL to be database in Red Hat linux 7.0. I writing a program to insert a value into the database in c language. The data changes so i have to insert the data as a variable, but the database reports a error saying that the data is a column, the code is something like this.. int main(int argc, char **argv) { .. char* test; test="abcd"; int res; MySQL *connection; res=mysql_query(connection, "INSERT INTO tablename (userid) VALUES(test)); } I get an error saying "Insert error 1054, unknown column 'test' in 'field-list' I don't program in c myself, but if you were doing this from the mysql utility, the value of your variable test, would have to be in single quotes. (ie. INSERT INTO tablename (userid) VALUES ('data to insert') ) I am guessing that your program is trying to put the raw word test into the database, not the value of your variable. Also looks like you forgot to close the double quote. Do whatever you have to do to get your variable to interpolate inside the query string. Maybe build the query in a local variable and insert the variable into the second parameter of mysql_query? Querystring = "INSERT INTO tablename (userid) VALUES ('".test."')"; (I don't know what the c concatenation operator is,php uses the '.', but you should build your query like this to put the value of test into the query string. I also don't know the behavior of double quotes in strings, and variables within them within c) If you copied and pasted that query as is into the mysql client, you would get the same error. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Best way to generate laser-printed reports from mysql
[EMAIL PROTECTED] writes: I am wondering how most users generate reports from mysql that they can print on a laser printer (e.g. invoices)? [...] I guess some people user something like Crystal Reports via ODBC, but I wonder what most people do??? Use Crystal Reports :-)? Depends on (a) how professional you need the reports to be, and (b) how much you can afford.. But more seriously, you *could* create a layout for "tbl" (part of GNU "groff", available for all POSIX platforms and even NT via the cygwin port), and generate output using that template: .TS H page-header specs .TH other header specs. header lines body lines-- generate this using MySQL .TE And then run all this through "tbl" followed by "groff". Haven't tried this myself in this particular combination, but having used tbl in the past, I don't see any major conceptual problems with it. It's free, but needs some elbow grease to get it to work.. A "tbl" reference is at http://www.primate.wisc.edu/software/troffcvt/tbl.html. -- Shankar Unni [EMAIL PROTECTED]
Re: HELP? RE: can't find shr.o???
Jack, Mysql, Well, my thought is that I can only compile zlib as a static library. I can't compile it shared. I think this why the binary distribution of mysql doesn't work is because it is looking for shared resources of libz.a. I could go through the pain of compiling this, but the AIX freeware distribution site has a copy of mysql3.23.27 precompiled which does work fine. I know its not the very latest, but its relatively close and it works. -Thanks for your assistance! Tim Well make sure you have gcc 2.95.2 and a recent version of make (the manual suggests a version). Also, when I said "Lib paths" I meant look at the -I options for your configs. But rereading your info, it looks like a problem with the actual object file (or lack of one). I hate to say this but you may need to compile your own copy of MySQL from source. I am still rather new to this product, and my experience with aix is limited. (I did use gcc 2.95.2 to compile my copy, and had the most recent copy of glib and libc also (but they are not required), I then down loaded zlib from the link below, and then dropped the binary distro. it worked flawlessly that time (once I had the files and libs). Sorry to say this, but I am at a loss. Can any one else help? Jack -Original Message- From: Tim Tyler [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 11:13 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: can't find shr.o??? Jack, Yes, I made sure that I ran the command from the mysql home directory and not within scripts. I am not sure what to check with lib paths. I think it doesn't have a problem finding zlib.a in /usr/local/lib. I think it simply can't load it because it can't find the shr.o that is associated within it. I have no idea how to get around that. I even recompiled zlib and installed it for the heck of it. No difference. I also tried loading this on a 4.3.3 system we had and failed their as well. Something about my enviroment must be off. We don't have C libraries from AIX, but I do have the gcc libraries. Does any of this make a difference? Is their a particular path variable that needs a particular setting? General paths are set, but I don't think we have a libpath variable set. Most things compile ok for me. But since this is a binary distribution, we didn't compile this so I am not sure what I am exactly missing. Tim I would look into the Lib paths...though this is a quick sanity check...(I have to ask) when you execute the script mysql_install_db are you in some pathmysql-3.xx.xx-aix/ or in the scripts directory? I ask because that can mess the script up. since it is looking into a relative directory for the bin directory. -Original Message- From: Tim Tyler [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 4:28 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: can't find shr.o??? Jack, My AIX oslevel reports 4.3.2. The zlib package is already installed. The libz.a file is easily found in /usr/local/lib. It just won't load for some reason. I must have some library problems with shr.o. Any thoughts? Tim First off check you version of aix. Also you have to install the zlib packed, that is where you will find libz.a library I had this very problem and it took me a whie to hunt down aprpriate files. I was on aix 4.3.0 and now 4.3.3(the zlib package needs thenewer OS.) you can look: on http://www-1.ibm.com/servers/aix/products/aixos/linux/download.html for the packages. Enjoy, Jack -Original Message- From: Tim Tyler [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 3:55 PM To: [EMAIL PROTECTED] Subject: can't find shr.o??? Mysql experts, I downloaded the binary distribution for AIX on a Risc/6000 and tried to install it. However, when I get to the mysql_install_db part I get the following error which ultimately fails to complete. # scripts/mysql_install_db Could not load program ./bin/my_print_defaults: Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. Member shr.o is not found in archive What exactly does this mean? Does this imply that it was precompiled with a compiler and libraries that I don't have? Note: We don't have Xlc installed, but we do have gcc installed. If so, does this mean I have to compile from scratch with gcc? Is there a binary distribution for aix having been compiled with gcc? Or is there another solution to this problem? Any thoughts on this matter are much appreciated. -- Tim Tyler Network Manager - Beloit College [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: RTFM (was: *sigh* Re: Is it a bug? )
This list should be open to ALL questions, newbie and non-newbie. If we start filtering, or slamming, then folks will be hesitant to ask questions. We should encourage the learning process, not discourage. And where better to learn than from this list? just my 2 one-hundreths of a dollar -Original Message- From: Oson, Chris M. [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 11:53 AM To: Cal Evans; [EMAIL PROTECTED] Subject: RE: RTFM (was: *sigh* Re: Is it a bug? ) Cal, satire 1 I would love to see this list split into 2 lists. MySQL-Newbies and MySQL-non-newbies. Non-newbies would be either an invitation-only list or you have to pass a test to get in. (The test would contain questions that are all in the manual, we don't care if you know, we care if you will bother to look-up!) /satire 1 satire 2 One of the requirements of being on MySQL-non-newbies, other than the RTFM thing, would be that you have to help at least 1 newbie a day. If you go 5 days without getting a gold star from a newbie then you get kicked form the non-newbies club. /satire 2 Ok, so I'm being silly. Oh really? Which part? satire 1 or satire 2? When I was learning ASP, Charles Carroll runs a message list similar to this one but categorized by certain groups. ASPFreeForAll - Post anything here... ASPNotNewbie - People who ask newbie questions on this list get *slammed* as they should. I'd like to see something similar here. Any other thoughts??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
using ALTER TABLE to make existing column AUTO_INCREMENT ??
ive gotten along pretty well with mysql and online docs. but now i am stumped and hoping for a little kick in the right direction. i have a column in a table which is the primary key and is an int. how do i make it also be auto_increment? the table already has some data in it, so i suspect that this may be where my problem comes from. when i use ALTER TABLE (my best guess at how to do it), i get this error: mysql alter table fixtures modify column id int auto_increment; ERROR 1062: Duplicate entry '1' for key 1 perhaps i need to somehow start things up with the next highest auto increment .. or ...? thanks, -jon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RTFM (was: *sigh* Re: Is it a bug? )
The problem many of us have is not the questions. If I didn't want to answer questions when I have free time, I wouldn't be subscribed to this list. The problem most of us have is with the people who flat out refuse to read the manual or try to find answers on their own. IMHO part of the learning process is learning what sources you can turn to for information. You have to remember, all of our time is worth something, and we are giving to the community to try and support people. Those people that refuse to check the manual are not being respectful of our time. - Original Message - From: "Rick Emery" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 26, 2001 12:20 PM Subject: RE: RTFM (was: *sigh* Re: Is it a bug? ) This list should be open to ALL questions, newbie and non-newbie. If we start filtering, or slamming, then folks will be hesitant to ask questions. We should encourage the learning process, not discourage. And where better to learn than from this list? just my 2 one-hundreths of a dollar -Original Message- From: Oson, Chris M. [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 11:53 AM To: Cal Evans; [EMAIL PROTECTED] Subject: RE: RTFM (was: *sigh* Re: Is it a bug? ) Cal, satire 1 I would love to see this list split into 2 lists. MySQL-Newbies and MySQL-non-newbies. Non-newbies would be either an invitation-only list or you have to pass a test to get in. (The test would contain questions that are all in the manual, we don't care if you know, we care if you will bother to look-up!) /satire 1 satire 2 One of the requirements of being on MySQL-non-newbies, other than the RTFM thing, would be that you have to help at least 1 newbie a day. If you go 5 days without getting a gold star from a newbie then you get kicked form the non-newbies club. /satire 2 Ok, so I'm being silly. Oh really? Which part? satire 1 or satire 2? When I was learning ASP, Charles Carroll runs a message list similar to this one but categorized by certain groups. ASPFreeForAll - Post anything here... ASPNotNewbie - People who ask newbie questions on this list get *slammed* as they should. I'd like to see something similar here. Any other thoughts??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
error cropping database/table
This is my first post to this list and I am a newbie at MySQL. If my question is a FAQ, please direct me to the FAQ board. The book I have, MySQL and mSQL by O'Reilly, says almost nothing about error codes... I'm using MySQL with WinNT4.0. I've got it up and running, however I can't drop tables after they have been created and data has been inserted into them. I get the following error: "ERROR 6: Error on delete of '.\testDatabase\member.MYI' (Errcode: 13)". And then I can' t even drop the whole database?!?! When I try to do that it gives me this error: "mysqladmin: drop of 'testDatabase' failed; error: 'Error dropping database (can't delete '.\testDatabase\member.MYD', errno: 5035465)'" And then, get this, after about 5 minutes of trying to delete the table, then trying to delete the database, getting back in and out of the database, i try dropping the database again, AND IT WORKS!!! What the heck is going on? Is there some delay in deleting a database or table? I have no idea what the problem is, and any help would be greatly appreciated. Alex -- ~ Alex Lazarevich Imaging Technology Group, http://www.itg.uiuc.edu Beckman Institute, http://www.beckman.uiuc.edu 405 N. Mathews, Urbana IL 61801 USA Ph: (217)244-1565 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: using ALTER TABLE to make existing column AUTO_INCREMENT ?? [solved]
as luck might have it, i have solved my own problem. thanks for the help people have already given me. what i needed to do (it seems?) is use SET INSERT_ID *before* doing the ALTER TABLE, like this: mysql set insert_id=7; Query OK, 0 rows affected (0.00 sec) mysql alter table fixtures modify column id int auto_increment; Query OK, 7 rows affected (0.01 sec) Records: 7 Duplicates: 0 Warnings: 0 i guess what this does is lets mysql know where to start counting for the auto_increment, so it doesnt complain about the cryptic "ERROR 1062: Duplicate entry '1' for key 1" thanks again, -jon _ NOW USE: [EMAIL PROTECTED] * http://scribble.com/jon/ * sito.org * gracies.org "A talent is formed in stillness, a character in the world's torrent." -- Johann Wolfgang von Goethe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 ALTER TABLE to make existing column AUTO_INCREMENT ??
try alter table fixtures change id id int auto_increment Notice that the two references to "id" are intentional! - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 26, 2001 2:44 PM Subject: using ALTER TABLE to make existing column AUTO_INCREMENT ?? ive gotten along pretty well with mysql and online docs. but now i am stumped and hoping for a little kick in the right direction. i have a column in a table which is the primary key and is an int. how do i make it also be auto_increment? the table already has some data in it, so i suspect that this may be where my problem comes from. when i use ALTER TABLE (my best guess at how to do it), i get this error: mysql alter table fixtures modify column id int auto_increment; ERROR 1062: Duplicate entry '1' for key 1 perhaps i need to somehow start things up with the next highest auto increment .. or ...? thanks, -jon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to recreate index
I have an index file that has an error in it and so I can't add a new index and i can't seem to run myisamchk on it for some reason. In there a way that i can have it recreate the index file thus getting rid of the errors? - Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 makes connection to mysql.com WASSUP?
Hi, I entered netstat and saw among other conections this one: tcp4 0 0 deepthroat.3179 web.mysql.com.auth TIME_WAIT Deepthroat is my bsd machine. it's a pure webserver. Why is my machine making a connection to mysql.com?(and why auth) Mysql is not bound to a tcp socket.. (skip-networking). Thanks in advance, pdw - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Coredump on quickly disconnecting clients
On Sunday 25 March 2001 18:57, Voytek Lapinski wrote: On Sunday 25 March 2001 16:27, you wrote: Found the problem with your signal 11 with strange traces from inside LinuxThreads. This was a hard concurrency bug - the problem was that a memory reference passed to pthread_create was getting invalidated by the thread that pthread_create was launching before pthread_create would right to that value. Took me a while to figure this out - I have scrutinized the entire thread creation mechanism in LinuxThreads suspecting a bad mmap or munmap somewhere before I realized the problem had nothing to do with LinuxThreads internal code. I believe the problem has existed for as long as MySQL has been around - back then the machines were just not fast enough to make this condition happen frequently enough for someone to be able to create a repeatable case. I have fixed it by extending the critical region. Here is the patch: Fantastic! I take it you won't be wanting the better back trace then? As long as you stop getting them :-) -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Limitations on select statements?
Hello everyone, I have a few questions that I hope some of you might be able to answer. Is there a MAX_SIZE on a select statements and when does MySQL lose performance when the statement becomes very large? When using the 'IN' clause, how does MySQL parse the data? Does it do an inline search or a binary tree? Thanks for your help... --Dave J. --- Dave W. Juntgen [EMAIL PROTECTED] Medical Informatics Engineering, Inc. http://www.mieweb.com/ 4101 W. Jefferson Blvd. Phone: 219-459-6270 Fort Wayne, IN 46804 Fax: 219-459-6271 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Best way to generate laser-printed reports from mysql
Shankar Unni wrote: [EMAIL PROTECTED] writes: I am wondering how most users generate reports from mysql that they can print on a laser printer (e.g. invoices)? [...] I guess some people user something like Crystal Reports via ODBC, but I wonder what most people do??? Use Crystal Reports :-)? Depends on (a) how professional you need the reports to be, and (b) how much you can afford.. But more seriously, you *could* create a layout for "tbl" (part of GNU "groff", available for all POSIX platforms and even NT via the cygwin port), and generate output using that template: .TS H page-header specs .TH other header specs. header lines body lines-- generate this using MySQL .TE And then run all this through "tbl" followed by "groff". Haven't tried this myself in this particular combination, but having used tbl in the past, I don't see any major conceptual problems with it. It's free, but needs some elbow grease to get it to work.. A "tbl" reference is at http://www.primate.wisc.edu/software/troffcvt/tbl.html. This question strikes a chord with me also. I started looking to see if there is any Perl modules/Bundles/Packages for generating postscript reports. What I have found is fairly primative. Does anybody have any suggestions?? -- Alvin Starr || voice: (416)585-9971 Interlink Connectivity|| fax: (416)585-9974 [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
Database or object is read-only - Error 3027
I am brand new to MySQL, attempted to find help in documentation and archives, but to no avail. I have installed MySQL on a Windows NT platform and configured a root user and another user that will act as a client with read/write permissions to one, and only one, database. A new database (exported from Access 97 into MySQL) has been created, and is accessable, however not 'updateable' from either the root user or the client user using Visual Basics 'VisData' and MyODBC (GRANT was used as documentation states to create these users). The error message I am recieving is 'Database or object is read-only - Error 3027' when I attempt to modify or add. The 'mysql' database is fully accessable (read and write) from either user however, even though permissions have not been granted to the client user. My suspicion is that either user permissions are improper, or the is some sort of database 'read only flags'? i.e. I have to modify the table in some form. I read something in the manual about 'Named Pipes' with Windows, am I going in the right direction? Can you point me in the right direction, to documentation I should look at? Thanks ahead of time, W - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: STUPID QUESTION
In MySQL, you can create tables that have relationships but you can't create what a lot of people call "Foreign Key relationships". In reality you CAN create Foreign key (FK) relationships between tables, you just can't create constraints that enforce them automatically. Example time: Let's say I have 2 tables, person and phone. person personID PK name phoneID FK phone phoneID phoneNumber See the phoneID in the person table? In it we store the value of phone.phoneID for this person's phone number. This is a Foreign key relationship. (So named because we are storing a foreign primary key in our table.) In other implementations of SQL, you could define a constraint (rule) that says that you can't store a value in person.phoneID that does not exist in phone.phoneID. This is a Foreign Key Constraint. So, to answer your question, to create a FK relationship between 2 tables, put a field in table1 of the same type (does not have to be the same name but I always do) as the primary key of table 2. Then when you are selecting and want to gather everything together you use: Select t1.*, t2.* from table1 t1, table2 t2 where t1.t2ID = t2.t2ID Clear as mud? Cal http://www.calevans.com -Original Message- From: GERARDO GALLARDO [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 5:57 PM To: [EMAIL PROTECTED] Subject: STUPID QUESTION I'm new to MySQL and SQL in general. I have been searching and searching but I can't find an answer to a question which I know is simple. I have read a book called Teach Yourself MySQL in 21 days. It talkes about defining relationships between tables but it never actually shows you how you would create these relationships or reference data from one table in another table. How do I do this? Please help. Gerardo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ISP
On 26 Mar 2001, at 17:54, Curtis Maurand wrote: I would give you root access to your database, but not to Mysql as a whole unless you want a dedicated server. Too dangerous. I have used iserver.com for about the last 4 years. I can start mysql,create databases etc. I find the entire setup at iserver.com to be about as close to getting your own box as you can without paying for your own box. There are limitations (no imagemagick for instance) but we have about 90% of our websites there (only a few with their own box). http://www.iserver.com/support/virtual/mysql/install.html Peter __ Exercise Your Brain, Read a Book -- O Crazy Gringo, Ipanema, Brazil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 GUI question
I compiled all the required files and it seemed to work Ok. I just have one question. How do I start the mySQL GUI? Any help you can provide would be greatly appreciated. Thank, Jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql error on Win ME
I am running version 3.23.33 of mysql on Windows ME. Everything was working fine for a while and I recently started getting this error (from a php web page) when doing a select on a table: MySQL Error: 1030(Got error 127 from table handler) I get this through both the web application and through a web based (phpmyadmin) administrator. Any idea what is causing this or how to fix it? 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: STUPID QUESTION
Note that foreign keys in SQL are not used to join tables, but are used mostly for checking referential integrity (foreign key constraints). If you want to get results from multiple tables from a SELECT statement, you do this by joining tables: SELECT * from table1,table2 where table1.id = table2.id; or use alias SELECT t1.ID, t2.Name from table1 t1, table2 t2 where t1.id = t2.id ChrisB -Original Message- From: GERARDO GALLARDO [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 3:57 PM To: [EMAIL PROTECTED] Subject: STUPID QUESTION I'm new to MySQL and SQL in general. I have been searching and searching but I can't find an answer to a question which I know is simple. I have read a book called Teach Yourself MySQL in 21 days. It talkes about defining relationships between tables but it never actually shows you how you would create these relationships or reference data from one table in another table. How do I do this? Please help. Gerardo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
ADO problem with MYSQL datetime column
Hi, I'm using ADO with the MyODBC driver. I have a table that I'm querying that has 'datetime' columns. If these columns are null or 0 - "-00-00 00:00:00", I have problems reading from the ADO recordset. I have other columns - char, varchar, integer etc that are null and don't have this problem. It only seems to be the datetime columns. I was wondering if this is an ADO issue with the MYSQL column type of datetime, or perhaps an issue with the MyODBC driver and ADO ? Has anyone found a work around for this problem? The only work around I've got is to actually format the field when I select it, but this creates an issue for me when I'm trying to retrieve all columns from a table that has 100+ columns. I wanted to avoid having to type out all column names in the query. Thanks, 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
parse error
can anybody help? I get this error Parse error: parse error in mypath to file\Default.php on line 18 I am just learning right now so if you could help me with what I did wrong her I'd apreciate it. Thanx Petra [EMAIL PROTECTED] HTML HEAD TITLE Our List of Historic Products /TITLE HEAD BODY ?php // Connect to the database server $dbcnx = @mysql_connect("localhost", "root", ""); if (!$dbcnx) { echo( "PUnable to connect to the " . "database server at this time./P" ); exit(); } // Select the jokes database if (! @mysql_select_db("JShistbau") ) { echo( "PUnable to locate the historic products " . "database at this time./P" ); exit(); } ? P Here are all the products in our database: /P BLOCKQUOTE ?php // Request the text of all the products $result = mysql_query( "SELECT catdescription FROM categories"); if (!$result) { echo("PError performing query: " . mysql_error() . "/P"); exit(); } // Display the text of each product in a paragraph while ( $row = mysql_fetch_array($result) ) {echo("P" . $row["catdescription"] . "/P"); } ? /BLOCKQUOTE/BODY/HTML - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
parse error
can anybody help? I get this error Parse error: parse error in mypath to file\Default.php on line 18 I am just learning right now so if you could help me with what I did wrong her I'd apreciate it. Thanx Petra [EMAIL PROTECTED] HTML HEAD TITLE Our List of Historic Products /TITLE HEAD BODY ?php // Connect to the database server $dbcnx = @mysql_connect("localhost", "root", ""); if (!$dbcnx) { echo( "PUnable to connect to the " . "database server at this time./P" ); exit(); } // Select the jokes database if (! @mysql_select_db("JShistbau") ) { echo( "PUnable to locate the historic products " . "database at this time./P" ); exit(); } ? P Here are all the products in our database: /P BLOCKQUOTE ?php // Request the text of all the products $result = mysql_query( "SELECT catdescription FROM categories"); if (!$result) { echo("PError performing query: " . mysql_error() . "/P"); exit(); } // Display the text of each product in a paragraph while ( $row = mysql_fetch_array($result) ) {echo("P" . $row["catdescription"] . "/P"); } ? /BLOCKQUOTE/BODY/HTML - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
explain on merge table versus underlying table:
Note the difference: mysql explain select * from syslogs_main where host='openview.cc.umr.edu' and msg like '%IPACCESS%'; +--+--+---++-+---+---++ | table| type | possible_keys | key| key_len | ref | rows | Extra | +--+--+---++-+---+---++ | syslogs_main | ref | sl_hsp| sl_hsp | 50 | const | 20487 | where used | +--+--+---++-+---+---++ 1 row in set (0.00 sec) mysql explain select * from syslogs where host='openview.cc.umr.edu' and msg like '%IPACCESS%'; +-+--+---+--+-+--+++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+--+++ | syslogs | ALL | NULL | NULL |NULL | NULL | 754049 | where used | +-+--+---+--+-+--+++ 1 row in set (0.57 sec) Syslogs is a merge table over syslogs_main (and several others). Appears the output is wrong, cause the queries take about the same time. I'm not sure if it would be the ideal approach, but I'd be happy with explain on a merge table generating a row in the response for each table in the merge. ie: ++--+---++-+---+---++ | table | type | possible_keys | key| key_len | ref | rows | Extra | ++--+---++-+---+---++ | syslogs_main | ref | sl_hsp| sl_hsp | 50 | const | 20487 | where used | | syslogs_mail | ref | sl_hsp| sl_hsp | 50 | const | 20487 | where used | | syslogs_dhcp | ref | sl_hsp| sl_hsp | 50 | const | 20487 | where used | | syslogs_mredir | ref | sl_hsp| sl_hsp | 50 | const | 20487 | where used | ++--+---++-+---+---++ -- Nathan Nathan Neulinger EMail: [EMAIL PROTECTED] University of Missouri - Rolla Phone: (573) 341-4841 CIS - Systems ProgrammingFax: (573) 341-4216 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: STUPID QUESTION
Quite simple, you can't. Please read the manuals more thoroughly. You can't just read a general book on SQL by itself without reading the manual for your particular flavour of SQL. Each type of database may have added extra features or have removed some from the standard SQL. - Original Message - From: "GERARDO GALLARDO" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 7:56 Subject: STUPID QUESTION I'm new to MySQL and SQL in general. I have been searching and searching but I can't find an answer to a question which I know is simple. I have read a book called Teach Yourself MySQL in 21 days. It talkes about defining relationships between tables but it never actually shows you how you would create these relationships or reference data from one table in another table. How do I do this? Please help. Gerardo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: parse error
Petra, You have a close '}' with no open '{'. Maybe you should move the If statement to the next line, then it won't be commented out. len. -Original Message- From: Petra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 27 March 2001 13:21 To: [EMAIL PROTECTED] Subject: parse error can anybody help? I get this error Parse error: parse error in mypath to file\Default.php on line 18 I am just learning right now so if you could help me with what I did wrong her I'd apreciate it. Thanx Petra [EMAIL PROTECTED] HTML HEAD TITLE Our List of Historic Products /TITLE HEAD BODY ?php // Connect to the database server $dbcnx = @mysql_connect("localhost", "root", ""); if (!$dbcnx) { echo( "PUnable to connect to the " . "database server at this time./P" ); exit(); } // Select the jokes database if (! @mysql_select_db("JShistbau") ) { echo( "PUnable to locate the historic products " . "database at this time./P" ); exit(); } ? P Here are all the products in our database: /P BLOCKQUOTE ?php // Request the text of all the products $result = mysql_query( "SELECT catdescription FROM categories"); if (!$result) { echo("PError performing query: " . mysql_error() . "/P"); exit(); } // Display the text of each product in a paragraph while ( $row = mysql_fetch_array($result) ) {echo("P" . $row["catdescription"] . "/P"); } ? /BLOCKQUOTE/BODY/HTML - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New MySQL install Help Please
Surely you jest. Start it (MySQL) from DOS? Which file name do I type into the DOS box command line to start it. I have not yet installed any of the GUI's I heard about because until I overcame the MyODBC problem I wasn't sure I would get it installed. Can I assume one of the GUI's will start it from inside windows? John Jackson [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: New MySQL install Help Please
Please include the original message so that others may know what the original problem was. Surely you jest. No, I'm not. Please read the fine manual. Start it (MySQL) from DOS? There is still a lot of decent DOS software still floating about and some are faster than their Windoze counter parts. You could say MySQL is such an example if you're using a GUI tool. Which file name do I type into the DOS box command line to start it. Please RTFM. I have not yet installed any of the GUI's I heard about because until I overcame the MyODBC problem I wasn't sure I would get it installed. Can I assume one of the GUI's will start it from inside windows? It should but I've never tried. Cheers Rolf, Your mouse has moved. Windows must be restarted for the change to take effect. Reboot now? [OK] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: speed problems
Hello. Sorry about the delay, but I was side-tracked by a server crash at the end of last week. The EXPLAIN for the 3.23 MySQL is at least as good as for 3.22, (in fact, it is better). As one fact, 996*1*1264=1258944 rows are less than 986*1*1470=1449420 rows, but at least in the same magnitude and therefore, at least in theory, the query shouldn't differ much regarding speed. I just reread the thread and saw that you compiled the newer MySQL yourself. That could make part of the speed difference, because TcX' precompiled binaries are using are well tuned (and use pgcc, which is optimized for Pentiums). Could you try a binary from www.mysql.com at least for one of the slow machines and see if it makes a difference? To be true, I am running out of ideas. On the other hand, the test environments have too much differences to easily guess which difference causes the performance hit. :-/ Were all your test cases on different machines, or did some use the same hardware, just with upgraded MySQL? Just to be sure: the machines were not used in another way during the tests, were they? Bye, Benjamin. On Wed, Mar 21, 2001 at 01:10:54PM +0200, [EMAIL PROTECTED] wrote: Okay, that means, memory is no problem. And disks shouldn't be a problem either, because the table fits into memory. (Sorry, don't remember the test case anymore. Did it contain INSERTs/UPDATEs?) No, only one SELECT with 3 joins. Just in case i send this query again: SELECT f.foto_id, f.imgname, f.path FROM foto f, indeks k1, indeks k2 WHERE f.foto_id = k1.foto_id AND k1.word = 'mati' AND f.foto_id = k2.foto_id AND k2.word = 'kose' GROUP BY f.foto_id; This implies, they are not the same for different versions of MySQL? Then, as I said, this is the probably cause for the speed difference. Could you post the output of both, please? Ok, here we go (it didn't fit on one line, sorry): 3.22.32 (old and fast) EXPLAIN: +---++---+-+-++--+---+ | table | type | possible_keys | key | key_len | ref| rows | Extra | +---++---+-+-++--+---+ | k1| ref| idx2 | idx2| 100 | mati | 986 | | | f | eq_ref | PRIMARY | PRIMARY | 4 | k1.foto_id |1 | | | k2| range | idx2 | idx2|NULL | NULL | 1470 | | +---++---+-+-++--+---+ 3.23.32 (new and slow) EXPLAIN: +---++---+-+-++--+-+ | table | type | possible_keys | key | key_len | ref| rows | Extra | +---++---+-+-++--+-+ | k1| ref| idx2 | idx2| 101 | const | 996 | where used; Using temporary | | f | eq_ref | PRIMARY | PRIMARY | 4 | k1.foto_id |1 | | | k2| ref| idx2 | idx2| 101 | const | 1264 | where used | +---++---+-+-++--+-+ Newer 3.23.xx have same EXPLAIN Rgds, Viljo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Speed:: mysql 3.23.35 vs mysql 3.23.33
Hello, We have dual PIII Xeon 700MB memory box for mysql database running Solaris8 x86 + mu3. After upgrading from 3.23.33 to 3.23.35 *average* speed downed ~ 50% -60%. Output from "sar" command shows heavy stress of I/O system. I use word "average", because we have more than 30 databases with different structure and lot of different kind of sql queries. Mysql used for web projects (Queries per second avg: 35.859). Both mysql-3.23.35 and mysql-3.23.33 compiled from sources using gcc-2.95.2 and configured with: -- #!/usr/bin/sh CC=gcc CFLAGS="-O6" \ CXX=gcc CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti" \ ./configure --prefix=/vol3/mysql \ --with-charset=cp1251 \ --without-debug \ --with-tcp-port=3306 \ --with-unix-socket-path=/tmp/mysql.sock \ --with-named-z-libs=z -- From /etc/my.cnf: -- [mysqld] socket = /tmp/mysql.sock tmpdir = /tmp/ port = 3306 skip-name-resolve skip-locking skip-grant-tables low-priority-updates delay-key-write-for-all-tables log-slow-queries set-variable = long_query_time=5 set-variable = thread_concurrency=8 set-variable = back_log=50 set-variable = key_buffer=256M set-variable = max_allowed_packet=1M set-variable = table_cache=256 set-variable = sort_buffer=8M set-variable = record_buffer=1M set-variable = thread_cache=4 set-variable = myisam_sort_buffer_size=64M set-variable = tmp_table_size=16M -- PS Thanks for Mysql team, great project. Alexander. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 127
Hi, could anyone of you please take a look at this message: 'MySQL said: Got error 127 from table handler' This occurs when trying to access a specific table, like 'select * from someTab', but it works when appending ' limit 0, X'. Of what type is this error? Any comments highly appreciated. -- Sascha Eversmeier Web Developer MAGIX Entertainment Products GmbH Rotherstrae 19 10245 Berlin fon: +49 (0)30 29392-325 fax: +49 (0)30 29392-400 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: How to index this properly (to make it go faster) ?
Hello. On Sun, Mar 25, 2001 at 01:17:12AM -, [EMAIL PROTECTED] wrote: -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] [...] Here's from the real one : mysql show index from proc; +---++-+--+-+--- +-+--++-+ | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---++-+--+-+--- +-+--++-+ | proc | 1 | timecode|1 | timecode| A |4220 | NULL | NULL | | | proc | 1 | system_id |1 | system_id | A | 1 | NULL | NULL | | | proc | 1 | processname |1 | processname | A | 88 | NULL | NULL | | +---++-+--+-+--- +-+--++-+ A good index would probably be (system_id,username,processname,timecode). The users hardly use 'username' in their where clause. Then you could use (system_id, processname, timecode, username), of course. That's why it's left out (the index started to get rather big also). Well, that's an argument. You may want to consider a partial index on username anyhow. Maybe even (system_id,username,processname,timecode,usertime,systemtime), which should enable "using index" only. Why that, usertime systemtime are data values, they are never used in any where clause. As far as I can see it's complete waste to put index on those. If all columns of the SELECT clause are part of the index, MySQL will solve the query only with reading from the index file and never touch the data file itself. Since the index is quite big already and usertime+systemtime only add 8 bytes per row, this may pay off regarding the speed win / size increase. You may want to use partial keys in order to reduce space consumption, e.g. Maybe even (system_id,username(5),processname(5),timecode), This is a no go since alot of processes are identical on the first 5 characters. The username could be used, but I decided not to, since Oracle (which the solution also has to be compatible with) is smart enough to only store the characters in use. I actually think MySQL does the same. MySQL only stores the bytes you use, but restricting it to 5 bytes (or whatever you want), will never use more than 5 bytes. For example, I have 291383 email addresses in one database with an avarage length of 20.2 characters. Regarding the left hand characters, they are different as follows: 1 47 2 1392 320791 478516 5 142787 6 191976 7 228078 and so on. This means, a key on only 5 keys, has only to values per index entry (i.e. only half as good as a unique index) and needs 4.99 :-) characters in avarages (just measured), i.e. one save about 5MB space (out of 7MB) and now scale that up to some million rows. Okay, emails are an extreme example. :-) Depending on the Cardinality of the different columns you may want to change the order to (username,processname,system_id,timecode) or alike. Aha, I'll have to test more with the individual order of combined indexes to see what I can get from it. Well, normally that is not really important, but in your case, processname has a low cardinality and therefore one value has a lot of matches in the index and it is worth a try to put it to the right. [...] No index is chosen, because you obviouly SELECTed a major part of the table. This probably won't happen, if you got these 100 million rows are talking about below (because you won't select about 20.000.000 rows, will you?). Well, that's the problem. I will ;-( Well, in that case, no index will really help you (except the one I cited above, which should avoid reading the data file, it could help a bit). Selecting as much rows, just will take its time. :-/ [...] [clip] I have tried to combine the indexes, but then MySQL fails using them properly, Would you please elaborate on this? This is IMHO the main point of your problem. You need these indexes. Problem is that MySQL seems to do a full table scan as soon as I start to combine the indexes, even after running optimize, analyze sort after index. Normally, this means, that the index did not really fit the query, but without more information, I cannot say. Did you keep the indexes you already have now? In that case, it should use the other indexes, if it cannot use the combined index. This is my experience after looking at explain decisions and the time it takes to execute. May I bother you to add the following indexes and post the EXPLAIN after adding them:. (system_id,