RE: can you see an index
On 29-Jun-01 Tom Beidler wrote: Newbie question. I recently altered a table by adding an index. I then DESCRIBEd it and it didn't show an index. Is this correct and if so, how do I know it's there? mysql show keys from da_table Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
UPDATE QUERY
Can anyone give me a pointer as to whether an update query, similar to below, is possible - and if so how? (I've put it in caps since that's the way it is typed in mysql) UPDATE SUBCATEGORY SET CATID=CATEGORY.CATID WHERE SUBCATEGORY.ORGID=CATEGORY.ORGID SUBCATEGORY and CATEGORY are table names Thanks in advance! Regards Elizabeth
mysql and multiproz
Hi, mysql under FreeBSD has apparantly problems to distribute threads on serveral processors. So does it make sense to install several instances of the mysql-server on one machine, which perform different tasks, but use one database? In other words, is the access to the database the performance bottleneck or the handling of the data, stored or to be stored in the database?? In the latter case one could profit from several mysql-servers on one machine, filling one database, using the different prozessors better than one server. thanx for hints Dr. Karl Prinz Senior Project Manager freshnet GmbH Tel.: +49 89 552988 15 Arnulfstrasse 27Fax: +49 89 552988 88 D-80335 Muenchen http://www.freshnet.de Germany mailto:[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
Repeatable error compiling 3.23.39 and --with-libwrap on RH 7.1
I am having a problem under RedHat 7.1 that I didn't see under 6.2. When trying to compile --with-libwrap the code errors with: mysqld.cc: In function `void *handle_connections_sockets (void *)': /usr/include/tcpd.h:131: too many arguments to function `void sock_host ()' mysqld.cc:2252: at this point in file /usr/include/tcpd.h:69: too many arguments to function `int hosts_access ()' mysqld.cc:2253: at this point in file /usr/include/tcpd.h:124: too many arguments to function `char *eval_client ()' mysqld.cc:2258: at this point in file mysqld.cc: In function `void *handle_connections_sockets (void *)': /usr/include/tcpd.h:131: too many arguments to function `void sock_host ()' mysqld.cc:2252: at this point in file /usr/include/tcpd.h:69: too many arguments to function `int hosts_access ()' mysqld.cc:2253: at this point in file /usr/include/tcpd.h:124: too many arguments to function `char *eval_client ()' mysqld.cc:2258: at this point in file Is there a work around for this? I have found I can get it to compile w/o libwrap, since I can use ipchains/iptables it is not a big deal... but I like the added wrappers. Thanks. Paul Wiechman [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
Problem with count() with left join
HI guys ! I have some problem. Let's go ! I have 3 tables. Fields are describe below: 1) table1 | id (int 3) | comment (text) | t (timestamp 14) | she holds: | 1 | there is my comment1 | 200010606123456 | | 2 | there is my comment2 | 200010606123456 | | 3 | there is my comment3 | 200010606123456 | | 4 | there is my comment4 | 200010606123456 | 2) table2 | id (int 3) | id_tab1 (int 3) | img_path (varchar 10) | t (timestamp 14) | she holds: | 1 | 1 | /tmp/1.jpg | 200010606123456 | | 2 | 1 | /tmp/12jpg | 200010606123456 | | 3 | 1 | /tmp/21.jpg | 200010606123456 | | 4 | 2 | /tmp/4.jpg | 200010606123456 | | 5 | 2 | /tmp/45.jpg | 200010606123456 | | 6 | 3 | /tmp/6.jpg | 200010606123456 | | 7 | 3 | /tmp/7.jpg | 200010606123456 | 3) table3 | id (int 3) | id_tab1 (int 3) | story (text) | t (timestamp 14) | she holds: | 1 | 1 | ble ble ble | 200010606123456 | | 2 | 1 | ble ble ble| 200010606123456 | | 3 | 1 | ble ble ble | 200010606123456 | | 4 | 1 | ble ble ble| 200010606123456 | | 5 | 2 | ble ble ble | 200010606123456 | | 6 | 3 | ble ble ble | 200010606123456 | | 7 | 4 | ble ble ble | 200010606123456 | I would like to count, how many rows in table2 and table3 coresponding to table1 and i made this query: select table1.id,count(table2.id_tab1),count(table3.id_tab1) from table1 left join table2 on table2.id_tab1=table1.id left join table3 on table3.id_tab1=table1.id group by table1.id order by table1.id; But i wonder, the results in count columns aren't truth. So, what is the correct query Please, any answer could you send me at email below too. Regards. Ireneusz Piasecki webmaster www.b-c.pl KomNet s.c [EMAIL PROTECTED] tel: 0 606 356 235 [EMAIL PROTECTED] [EMAIL PROTECTED]
big-tables option = Your help
Hi everybody, your help please I meet the well-known problem with 3.22 mysql on a 6.1 redhat linux platform. Database error: Invalid SQL: select ..blabla MySQL Error: 1114 (The table 'SQL54_0' is full) Session halted. I put the option big-tables in all the following groups in the .my.cnf file: [mysql] [mysqld] [mysql.server] This file is read correctly, with the print default I can see, the different groups have the --big-files option to start First I start with [mysql] the following and finally all... But I've always the table full default, no progress... Your help please ? ### Marcel Bariou = [EMAIL PROTECTED] Thank for your interest -- Merci pour votre attention ###
RE: Connecting to MySQL w/VB
Give MyODBC a try, its on the mysql.com site and its given my no problems at all in vb. Sean -Original Message- From: Robert Skinner [mailto:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 3:45 AM To: [EMAIL PROTECTED] Subject: Connecting to MySQL w/VB I am trying to connect to MySQL using a connection string using VB6. The read part is great but I don't seem to be able to add records. Can anyone steer me in the right direction? [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
OT status of MySQL++
Hi friends! Sorry for being off topic..but what's the status of mysql++, is it in active development? Greetings! -- Greger Haga Finland ICQ 120338800 HTTP://www.geocities.com/gregerhaga http://counter.li.org/ _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Whoops, 4GB limit
I have a table in a MySQL database on a Solaris system which contains log entries and have stupidly overflowed Solaris' 4GB file limit. The table is unusable. isamchk reports: error: 'log.ISD' is not a ISAM-table I have tried making a truncated copy of the file and isamchk'ing the shorted file. The message is still the same. Based on the amount of time isamchk takes to determine the file is not it's domain ( 1/10sec) the problem must be something simple like a missing header or start of record mark. Any ideas? Is the ISAM format documented anywhere? Nigel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Connecting to MySQL w/VB
I am using a DLL called MYVBQL.dll which is also on the mysql web site and it works like a dream. Don't need no ODBC driver, and all that stuff. Similar to ADO but also quite different. Some bugs but if you stick to SQL statements to insert/update/delete info it works like a dream and is very fast. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of [EMAIL PROTECTED] Sent: 29 June 2001 10:41 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Connecting to MySQL w/VB Give MyODBC a try, its on the mysql.com site and its given my no problems at all in vb. Sean -Original Message- From: Robert Skinner [mailto:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 3:45 AM To: [EMAIL PROTECTED] Subject: Connecting to MySQL w/VB I am trying to connect to MySQL using a connection string using VB6. The read part is great but I don't seem to be able to add records. Can anyone steer me in the right direction? [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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
win32 oledb
Hi, has anyone used the OLEDB driver instead of ODBC for MySQL Win32? Are there performance improvements? Are there any Win32 specific install/performance tweaks? regards Joel Hughes [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
Loading Textfile into DB
Hi I'm trying to load data from a tab deliminated textfile into my table named blick_test: load data local infile public_html/DB2.txt into table blick_test ignore 1 lines; this works pretty fine, except I only get the first 256 records instead of all 503! message: Query OK, 256 rows affected (0.01 sec) Records: 503 Deleted: 0 Skipped: 247 Warnings: 741 how can I turn on the warnings? is there any limit in importing records from a textfile? thanks dominic dominic brander - snowflake productions gmbh - http://www.snowflake.ch 01 772 80 21 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HELP! Hard Disk Space limition and Symbolic link
Dear all, I installed mysql version 3.22.32 on Red Hat 6.2 using the rpm package. Since mysql data directory is stay in /var/lib/, plus my database is growing bigger day by day, my problem now is that the '/var' partition running short of free hard disk space. What I'm trying to do is to transfer the data directory to a new partition '/home' which had bigger space. Is there any way to solve this without reinstall back mysql server? Will the symbolic link solve this problem? If so, how? Thank you in advance. Emanduel Chan Tain Por System Engineer DotCom Consulting Sdn Bhd DID : 603-62763230 ext. 112 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SELECT CASE doesn't work?
Hi! The CASE statement doesn't seem to work, even the three examples given in the docs (7.4.8 Control Flow Functions) return errors: mysql select case 1 when 1 then one when 2 then two else more end; ERROR 1064: You have an error in your SQL syntax near '1 when 1 then one when 2 then two else more end' at line 1 I tried it with my local copy (Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686), Debian distribution), as well as with the one installed at my ISP. What's happening here? soenk.e -- Der Hamburger Kino-Fahrplan: http://kino-fahrplan.de [pgp-key on request or at http://kino-fahrplan.de/soenke/soenke.pgp] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 status of MySQL++
Greger Haga writes: Hi friends! Sorry for being off topic..but what's the status of mysql++, is it in active development? Greetings! -- Greger Haga Finland ICQ 120338800 HTTP://www.geocities.com/gregerhaga http://counter.li.org/ Thanks for asking a question. MySQL++ is alive and kicking. Main development goes into integration of various compiler versions into the main tree. Currently, for 1.7.9 there is only one minor bug reported. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: win32 oledb
Joel, I have used the MySQL.OLEDB Provider, but haven't been able to get it to work on anything except 'localhost'. So, I use the OLEDB provider for ODBC drivers, and then use a MySQL DSN. I did mail the people who built the provider a month or two ago, but no response. If you, or anyone else, for that matter have been able to make it work across machines, please let me know: HOW?!? I've tried all manner of different connection string options, including using the MS UDL file property editor, with no joy. Good luck, Bruce. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Ynt: Connecting to MySQL w/VB
see this : About mysql vb6 http://www.avukatpro.com/mysql.html - Original Message - From: Dennis Salguero [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 29, 2001 6:03 AM Subject: Re: Connecting to MySQL w/VB - Original Message - From: Robert Skinner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 7:44 PM Subject: Connecting to MySQL w/VB I am trying to connect to MySQL using a connection string using VB6. The read part is great but I don't seem to be able to add records. Can anyone steer me in the right direction? A bit more information might help us help you. If you the db reads work fine, then you at least have the connection made - that's already half-way there! I have done extensive work with MySQL and VB/VBScript, but if you can execute a SELECT query (as your e-mail indicates) I don't see how you would have problems executing an INSERT query (assuming the SQL statement is valid). What exactly seems to be the problem? Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql compilation on solaris8
Hi, I am facing problems while compiling mysql server on solaris 8. I am using the mysql source code. The problem is as folows: ./configure loading cache ./config.cache checking host system type... sparc-sun-solaris2.8 checking target system type... sparc-sun-solaris2.8 checking build system type... sparc-sun-solaris2.8 checking for a BSD compatible install... ./install-sh -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for working aclocal... found checking for working autoconf... found checking for working automake... found checking for working autoheader... found checking for working makeinfo... missing checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for gawk... (cached) nawk checking for gcc... (cached) gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... (cached) yes checking whether gcc accepts -g... (cached) yes checking for c++... (cached) c++ checking whether the C++ compiler (c++ ) works... yes checking whether the C++ compiler (c++ ) is a cross-compiler... yes checking whether we are using GNU C++... (cached) yes checking whether c++ accepts -g... (cached) yes checking how to run the C preprocessor... (cached) gcc -E checking for ranlib... (cached) : checking for ld used by GCC... (cached) /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... (cached) no checking for BSD-compatible nm... (cached) /usr/ccs/bin/nm -p checking whether ln -s works... (cached) yes checking for object suffix... o checking for executable suffix... no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions ... yes checking if gcc static flag -static works... -static checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking whether the linker (/usr/ccs/bin/ld) supports shared libraries... yes checking command to parse /usr/ccs/bin/nm -p output... ok checking how to hardcode library paths into programs... immediate checking for /usr/ccs/bin/ld option to reload object files... -r checking dynamic linker characteristics... solaris2.8 ld.so checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for objdir... .libs creating libtool loading cache ./config.cache checking for a BSD compatible install... ./install-sh -c checking for bison... no checking for byacc... no checking for pdftex... no checking return type of sprintf... configure: error: can not run test program while cross compiling kapil _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
automatic granting of rights for new tables
Hi, I've come up with an interesting problem and reading the MySQL book from DuBois hasn't helped me. I have the following scenario. A user can log in over the web to our site. Use the internet pages he can carry out functions that are provided by the pages. The user has access to three tables: students, courses and st_course with the select, update, insert and delete privileges. This works fine. Here comes the trick. Everytime the user enters a new course, I want to create a new table for this course and the user has his normal rights to this table - but how?! I have devloped this using roots priviliges so I know everything works. But how do I do this for the user? I have given him create, drop and alter priviliges for the database (he can't type in theses words so it is safe to do this). This means he can create, alter and drop the table but he can't look at what is in the table! I'm busy writing a function that will use root's privileges to automatically grant him the privileges afterwards but this is not hte desired way, ie the user creates the table and automatically has his priviliges for this new table (the function does check that the table is unique so no security issue I believe). I hope someone understands what I'm trying to say and knows the solution, Thanks a lot in advance, Pete PS. I'm avoiding the easy but incorrect solution of giving select, etc. priviliges to the entire database - this is not hte desired behaviour. __ Fast alle Fluege koennen Ihnen egal sein. Einer nicht: Ihrer! Flug.de hat ihn: http://flug.de/sb/?PP=0-0-100-105-3 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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[2]: message traffic
BTW, it has developed into a standard on those list companies who have developed techniques along the lines of To unsubscribe, e-mail [EMAIL PROTECTED] and I assume that it has proven useful in the long run (i.e. eGroups, OneList, now YahooGroups, ListBot and others). Personally, I don't care, I can filter either way. As an aside: spammers have started to disguise their messages with that kind of tag to fool people, so you can guess that most are familiar with the convention. I do aggree with dave's point. Could we do that, please would be possible to put a [MySQL] tag in the subject line? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Must use '#' in fieldnames
This is probably not the best recommendation but if you are compiling from the source distribution, you might locate where the comment character is defined and change it to some other character and recompile. I have no idea of the potential ramifications in doing this and you would need to be very careful as to the replacement character you choose. -Original Message- From: Dirk Ostertag [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 9:09 AM To: [EMAIL PROTECTED] Subject: Must use '#' in fieldnames Hello everybody, I have to create a table on a MySQL-Server with fieldnames like a35#70. if I ty it that way create table test ( a35#70 char (70)); on the mysql - prompt, the creation fails. Even brackets like in MsSQL or '`' doesn't help. Can anybody tell me what to do? thank Dirk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Frequent server side crash on FreeBSD
Hi Katy, The problem you are having is related to a bug in the Fbsd4.2 release. There was a bug in the compiler and several in the threads packages. I would suggest upgrading to Fbsd 4.3 ASAP, which is excellent. There were some patches that could be applied to Fbsd 4.2, you can look in the archives at freebsd.org or if you can't find them, e-mail me and I'll try to find them in my old mail. But the best answer is upgrade, either to freebsd-stable or best RELEASE_4_3 using cvsup or to 4.3 using CD's. Ken - Original Message - From: Katy Agnor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 2:30 PM Subject: Frequent server side crash on FreeBSD I am running mysql version 3.22.32 on freebsd version 4.2 I am running a high traffic BBS on an Apache web server (PERL) that connects to the database server through DBI. MySQL is crashing every two minutes or so. - My file descriptors and max files are set high, per process and for the system. - It looks like there is a lot of system memory free. - It doesn't look like there is any complex query. We ran a few traces. There's no particular pattern. I also noticed a lot of errnum: 35 errors. What can we do to shoot this problem? What traces would be helpful? -ka -- Katy Agnor aka LonghornGirlie [EMAIL PROTECTED] (512) 762-5883 (voice) (512) 474-7881 (fax) http://www.hornfans.com Hook 'em Horns! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql and multiproz
Hi Karl, native threads on FreeBSD does not yet support multi processor, however you can try using the ports collection, cvsup the latest ports, then cd /usr/ports/databases/mysql323-server DB_DIR=/usr/local/var WITH_LINUXTHREADS=yes make make install Change the DB_DIR to where you want you database to be. There are some quirks to this build so try it on a test machine first, but once build and installed it seems to run fine. Ken - Original Message - From: Karl Prinz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, June 29, 2001 3:27 AM Subject: mysql and multiproz Hi, mysql under FreeBSD has apparantly problems to distribute threads on serveral processors. So does it make sense to install several instances of the mysql-server on one machine, which perform different tasks, but use one database? In other words, is the access to the database the performance bottleneck or the handling of the data, stored or to be stored in the database?? In the latter case one could profit from several mysql-servers on one machine, filling one database, using the different prozessors better than one server. thanx for hints Dr. Karl Prinz Senior Project Manager freshnet GmbH Tel.: +49 89 552988 15 Arnulfstrasse 27 Fax: +49 89 552988 88 D-80335 Muenchen http://www.freshnet.de Germany mailto:[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
Re: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete as shown (a correction)
MySQL doen not yet support nested queries. Jawad Khan wrote: server version 3.23.35 -Original Message- From:Khan, Jawad [COLE:6S34:EXCH] Sent:Thursday, June 28, 2001 1:13 PM To: '[EMAIL PROTECTED]' Subject: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete as shown Hope you can find the problem in the following SQL command: delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms) limit 1 ; raiseTime is of type BIGINT. -- Gerald L. Clark [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: Loading Textfile into DB
Right now, you pretty much have to compare the input to your loaded table and see which records are missing. Check the input file to see what is wrong with them. Dominic Brander wrote: Hi I'm trying to load data from a tab deliminated textfile into my table named blick_test: load data local infile public_html/DB2.txt into table blick_test ignore 1 lines; this works pretty fine, except I only get the first 256 records instead of all 503! message: Query OK, 256 rows affected (0.01 sec) Records: 503 Deleted: 0 Skipped: 247 Warnings: 741 how can I turn on the warnings? is there any limit in importing records from a textfile? thanks dominic dominic brander - snowflake productions gmbh - http://www.snowflake.ch 01 772 80 21 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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
BerkleyDB and mysql and COMMIT
Hi, I have the following configuration I have Linux I have compile mysql with the following configure parameters: ./configure --enable-shared --with-berkeley-db --with-mysqld-ldflags='-all-static' I have created a BerkleyDB-table. After that I have set autocommit=0 and I have inserted one row in the one client and I tried to look with select on the same table in another client. Now I found, that the whole table is locked. But I want only row-locking. Knows someone a solution. After commit I can see all records. Thanks Gerlinde BLITZ Internet Service GmbH Kronacher Strasse 41 D-96052 Bamberg, Germany Tel. +49/951/9685160, Fax +49/951/9685164 http://www.blitz.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Linking more than one table
Hi, I'm a new user, and I have question: I have 2 tables info (table1) - id | data | naglowek | kto | link news (table2) - id | data | naglowek | kto | link | email | tresc | inne and I want to generate one big tabele contains those 2 (table1 and table2). It's something like this: "SELECT * FROM table1,table2" but this wan't work. Thanks for help. Krzysiek --- Jagged Alliance 2,5 Unfinished Business PL ju w sprzeday! Kliknij http://gry.wp.pl/opisy/jagged_alliance_2.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
Query
I have this table definition: table_1 +--+-+--+-+-++ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-++ | id | int(15) | | PRI | NULL| auto_increment | | Contrato | int(11) | | MUL | 0 || | UserName | varchar(30) | | MUL | || +--+-+--+-+-++ table_2 +--+-+--+-+-++ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-++ | id | int(11) | | PRI | NULL| auto_increment | | Contrato | int(11) | | | 0 || | Nombre | varchar(50) | | | || | UserName | varchar(15) | | MUL | || +--+-+--+-+-++ table_3 +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | | +-+--+--+-+-++ | id | bigint(21) | | PRI | NULL| auto_increment | | UserName| varchar(32) | | MUL | | | | | Saldo | float|| | | | | +-+--+--+-+-++ I need to retrieve the column Saldo from table 3 for each Contrato (could in table 1 and table 2), so i executed this select... SELECT Contrato, Saldo FROM table_3, table_2, table_1 WHERE (table_1.UserName = table_3.UserName) OR (table_2.UserName = table_3.UserName) This select return an error that Contrato is ambiguous. I can not do 2 queries, so the only solution to this is an UNION, but MySQL does not support them yet.. Can someone help me?
Re: Problem in initializing mySQL on Windows Plateform
You did not put the line [mysqld] before the server options so the server knows which lines belong to it. Bhartendu Maheshwari wrote: Hello I had installing mySQL as well myODBC, but when I run mysqld it has given an error C:\mysqld error: Found option without preceding group in config file: c:\my.cnf at line: 1 Program aborted Next time I had write a file my.cnf as innodb_data_file_path = ibdata1:400M;ibdata2:400M innodb_data_home_dir = c:\mysql set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Since my harddisk have only 900MB free space. So i choose innodb_data_file_path to be 400MB each. Now when I again run mysqld, It has given again error as C:\mysqld Can't initialize InnoDB as 'innodb_data_file_path' is not set Now Please tell me what to do? Thank you -- Gerald L. Clark [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: Loading Textfile into DB
maybe you got the id-field as tinyint?? - Original Message - From: Gerald Clark [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, June 29, 2001 3:13 PM Subject: Re: Loading Textfile into DB Right now, you pretty much have to compare the input to your loaded table and see which records are missing. Check the input file to see what is wrong with them. Dominic Brander wrote: Hi I'm trying to load data from a tab deliminated textfile into my table named blick_test: load data local infile public_html/DB2.txt into table blick_test ignore 1 lines; this works pretty fine, except I only get the first 256 records instead of all 503! message: Query OK, 256 rows affected (0.01 sec) Records: 503 Deleted: 0 Skipped: 247 Warnings: 741 how can I turn on the warnings? is there any limit in importing records from a textfile? thanks dominic dominic brander - snowflake productions gmbh - http://www.snowflake.ch 01 772 80 21 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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
Re: SELECT using and limit not optimized.
First of all, there is no NEXT record without an ORDER BY. LIMIT returns a subset of the selected rows of the result set. The result set must be selected and ordered before it can be limited. you probably want: SELECT * from wk004.slsf01 where ___RecNo 3000 order by ___RecNo limit 1; [EMAIL PROTECTED] wrote: Description: I am trying to get the next record given a key (numeric or string), What is the best way to do this. I am currently using: SELECT * from wk004.slsf01 where ___RecNo 3000 limit 1; table typepossible_keys key key_len ref rowsExtra slsf01range PRIMARY PRIMARY 4 NULL349 where used The explain result for this command show's rows accessed as 349, there are 3349 records in the file. If I use: SELECT * from wk004.slsf01 where ___RecNo 0 limit 1; explain shows 3349 rows. table typepossible_keys key key_len ref rowsExtra slsf01range PRIMARY PRIMARY 4 NULL3349where used To me this indicates that the more records in the file the slower this statement will be. Timing results with 3000 vs 10 records verify this. Why is rows not 1 in this case? Is there a different SELECT command I should be using? ___RecNo is an AUTO-INCREMENT BIGINT field, and is the only member of the PRIMARY key, sorted ASCENDING. The problem occurs on any index I use (string or INT), single or multiple keys. Occurs on Linux and SCO Unix. How-To-Repeat: EXPLAIN SELECT * from wk004.slsf01 where ___RecNo 3000 limit 1; EXPLAIN SELECT * from wk004.slsf01 where ___RecNo 0 limit 1; Fix: Submitter-Id:jwythe Originator: jww Organization: Silk Systems Inc. MySQL support: none Synopsis:SELECT using and limit not optimized. Severity:serious Priority:medium Category:mysql Class: support Release: mysql-3.23.37 (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.19 Distrib 3.23.37, for pc-sco3.2v5.0.4 on i386 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 version3.23.37 Protocol version 10 ConnectionLocalhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 11 min 1 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 5 Flush tables: 1 Open tables: 0 Queries per second avg: 0.002 Environment: Touch Intel PII-300Mhz, Redhat 6.2 Linux/SCO Openserver 5, same System: SCO_SV sysdev 3.2 2 i386 Some paths: /bin/make /usr/local/bin/gcc /bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-sco3.2v5.0.5/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS=' ' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root sys 36 May 19 1998 /lib/libc.a - /opt/K/SCO/unixds/5.1.0Ha/lib/libc.a lrwxrwxrwx 1 root sys 37 May 19 1998 /lib/libc.so - /opt/K/SCO/unixds/5.1.0Ha/lib/libc.so lrwxrwxrwx 1 root sys 40 May 19 1998 /usr/lib/libc.a - /opt/K/SCO/unixds/5.1.0Ha/usr/lib/libc.a lrwxrwxrwx 1 root sys 41 May 19 1998 /usr/lib/libc.so - /opt/K/SCO/unixds/5.1.0Ha/usr/lib/libc.so lrwxrwxrwx 1 root root 41 May 13 1998 /usr/lib/libc.so.1 - /opt/K/SCO/Unix/5.0.4Eb/usr/lib/libc.so.1 Configure command: ./configure --with-low-memory - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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: Linking more than one table
On Fri, 29 Jun 2001, Krzysztof Kowalski wrote: Hi, I'm a new user, and I have question: I have 2 tables info (table1) - id | data | naglowek | kto | link news (table2) - id | data | naglowek | kto | link | email | tresc | inne and I want to generate one big tabele contains those 2 (table1 and table2). It's something like this: SELECT * FROM table1,table2 but this wan't work. Thanks for help. Krzysiek select i.*,n.* from info i, news n where i.id=n.id; a. --- Jagged Alliance 2,5 Unfinished Business PL ju¿ w sprzeda¿y! Kliknij http://gry.wp.pl/opisy/jagged_alliance_2.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 --- Dr Arek Kasprzyk EMBL-European Bioinformatics Institute. Wellcome Trust Genome Campus, Hinxton, Cambridge CB10 1SD, UK. Tel: +44-(0)1223-494606 Fax: +44-(0)1223-494468 --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BerkleyDB and mysql and COMMIT
I believe BDB uses page locking, so you will likely need more than one record before you can avoid the lock. Gerlinde Fischer wrote: Hi, I have the following configuration I have Linux I have compile mysql with the following configure parameters: ./configure --enable-shared --with-berkeley-db --with-mysqld-ldflags='-all-static' I have created a BerkleyDB-table. After that I have set autocommit=0 and I have inserted one row in the one client and I tried to look with select on the same table in another client. Now I found, that the whole table is locked. But I want only row-locking. Knows someone a solution. After commit I can see all records. Thanks Gerlinde BLITZ Internet Service GmbH Kronacher Strasse 41 D-96052 Bamberg, Germany Tel. +49/951/9685160, Fax +49/951/9685164 http://www.blitz.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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: BerkleyDB and mysql and COMMIT
On Fri, 29 Jun 2001 15:29:08 +0200, Gerlinde Fischer [EMAIL PROTECTED] wrote: I don't believe BDB table handler support row-locking. I suggest looking at using Innobase tables handlers. Hi, I have the following configuration I have Linux I have compile mysql with the following configure parameters: ./configure --enable-shared --with-berkeley-db --with-mysqld-ldflags='-all-static' I have created a BerkleyDB-table. After that I have set autocommit=0 and I have inserted one row in the one client and I tried to look with select on the same table in another client. Now I found, that the whole table is locked. But I want only row-locking. Knows someone a solution. After commit I can see all records. Thanks Gerlinde BLITZ Internet Service GmbH Kronacher Strasse 41 D-96052 Bamberg, Germany Tel. +49/951/9685160, Fax +49/951/9685164 http://www.blitz.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multiplle update by key
I have a table with an autoincrement primary key, and a I hold list of the keys of a number of records which I want to UPDATE. How can I most efficiently write an UPDATE command which will update all the record whose keys are on my list? I thought I could put the keys I have into a temporary ram table and use some sort of SELECT like statement to join the temporary table to the real one, but I can't see any syntax for it. Is there no way to so it other than to issue an individual update for every record? Alec Cawley -- This e-mail is intended for the named addressees only. Its contents may be privileged or confidential and should be treated as such. If you are not an intended recipient please notify the sender immediately; do not copy, distribute, or take any action based on this e-mail; and then delete it. In the pursuit of its legitimate business activities and its conformance with relevant legislation, Quantel Ltd. may access any e-mail (including attachments) it originates and receives, for potential scrutiny. To learn more about Quantel's Clipbox Studio, go to http://www.quantel.com/clipboxstudio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Slow Solaris 8 results with sql-becnh
Hi, I have a PIII 800MHz 2GB RAM Linux (Suse 6.4) server running mysql version 3.23.28 I also have 2 Solaris machines a E440R with 2x450MHz CPUs and 512MB of RAM (this is results 2 3) and a E4500 with 4x450MHz 4MB cache CPUs and 2GB of RAM with a 12 disk SCSI array connected via fibre. But but using sql-bench that came with mysql the solaris boxes perform bad.. :( Even my application seems very sluggish on the Solaris boxes. I have tried a pre-compiled binary and compling my own all still very slow. So two things I guess 1) Are Ultra SPARC 450MHz 4MB cache CPUs no match for a single 800MHz PIII? 2) is there a problem with the Solaris port? I am using the huge my.cnf for all test. Thanks Nigel snip from sql-bench The test was run with limits from: mysql,pg,solid The result logs which where found and the options: 1 mysql-Linux_2.4.0_i686 : MySQL 3.23.38 2 mysql-SunOS_5.8_sun4u : MySQL 3.23.38 log 3 mysql-SunOS_5.8_sun4u29fresh: MySQL 3.23.39 log 4 mysql-SunOS_5.8_sun4um : MySQL 3.23.38 log = Operation | 1| 2| 3| 4| |mysql-L|mysql-S|mysql-S|mysql-S| - Results per test in seconds:| - ATIS| 39.00| 84.00| 85.00| 121.00| alter-table | 204.00| 641.00| 628.00| 581.00| big-tables | 33.00| 77.00| 76.00| 96.00| connect | 59.00| 90.00| 89.00| 142.00| create | |1683.00|1936.00|1093.00| insert |2789.00|5244.00|5268.00|5429.00| select |1382.00|2238.00|+2334.00|+2982.00| wisconsin | 14.00| 36.00| 35.00| 51.00| - The results per operation: | - alter_table_add (992) | 195.00| 625.00| 613.00| 562.00| connect (1) | 16.00| 23.00| 23.00| 36.00| connect+select_1_row (1)| 19.00| 30.00| 30.00| 47.00| count (100) | 57.00| 52.00| 51.00| 80.00| count_distinct (1000) | 71.00| 110.00| 125.00| 132.00| count_distinct_2 (1000) | 59.00| 128.00| 123.00| 152.00| count_distinct_big (120)| 107.00| 189.00| 188.00| 288.00| count_distinct_group (1000) | 62.00| 199.00| 196.00| 384.00| count_distinct_group_on_key (1000) | 59.00| 93.00| 107.00| 111.00| count_distinct_group_on_key_parts (1| 78.00| 200.00| 196.00| 386.00| count_distinct_key_prefix (1000)| 47.00| 85.00| 98.00| 102.00| count_group_on_key_parts (1000) | 62.00| 77.00| 77.00| 90.00| count_on_key (50100)| 498.00| 668.00|+705.00|+794.00| create+drop () | |*563.00|*680.00|*403.00| create_MANY_tables () | |*349.00|*359.00|*159.00| create_index (8)| 4.00| 8.00| 7.00| 9.00| create_key+drop () | |*566.00|*687.00|*420.00| create_table (31) | 0.00| 3.00| 1.00| 2.00| delete_all (12) | 14.00| 24.00| 24.00| 34.00| delete_all_many_keys (1)| 601.00| 534.00| 545.00| 120.00| delete_big (1) | 0.00| 1.00| 1.00| 1.00| delete_big_many_keys (128) | 601.00| 534.00| 545.00| 120.00| delete_key (1) | 5.00| 9.00| 9.00| 11.00| drop_index (8) | 5.00| 7.00| 7.00| 9.00| drop_table (28) | 0.00| 1.00| 2.00| 1.00| drop_table_when_MANY_tables () | |*199.00|*204.00| *99.00| insert (350768) | 121.00| 322.00| 323.00| 423.00| insert_duplicates (10) | 30.00| 57.00| 57.00| 101.00| insert_key (10) | 225.00|1003.00|1022.00| 282.00| insert_many_fields (2000) | 10.00| 20.00| 18.00| 24.00| insert_select_1_key (1) | 8.00| 11.00| 12.00| 13.00| insert_select_2_keys (1)| 10.00| 14.00| 13.00| 17.00| min_max (60)| 27.00| 39.00| 42.00| 52.00| min_max_on_key (85000) | 200.00| 283.00| 291.00| 357.00| order_by_big (10) | 42.00| 98.00| 98.00| 128.00| order_by_big_key (10) | 33.00| 86.00| 86.00| 97.00| order_by_big_key2 (10) | 29.00| 84.00| 83.00| 94.00| order_by_big_key_desc (10) | 34.00| 87.00| 86.00| 97.00|
distinct / limit optimization
Hi, I've tried the folowing query: SELECT DISTINCT column1 FROM table1 LIMIT 10; and got the result for 0.23 sec. Then I've tried the same query without limit: SELECT DISTINCT column1 FROM table1; and got the result for 0.01 sec. which is some 23 times faster. There are about 1 rows in table1 and column1 has an index. I've read in the manual that MySQL uses optimization when you combine DISTINCT with LIMIT n that would make it stop as soon as it finds n unique rows. Why then the first query that uses LIMIT is considerably slower? George Áåçïëàòíà ïîùåíñêà ñëóæáà http://mail.Rambler.bg/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 : Problem in initializing mySQL on Windows Plateform
From: Bhartendu Maheshwari Date: Saturday, June 30, 2001 07:21:08 AM To: [EMAIL PROTECTED] Subject: Re: Problem in initializing mySQL on Windows Plateform Thanx for yr help but now One more problem comes, that is descibed below C:\mysqldInnoDB: operating system error number 3 in a file operation.InnoDB: operating system error number 3 in a file operation.InnoDB: Error in creating or opening c:\iblogs\ib_logfile0010629 19:50:14 Can't init databases C:\mysqldInnoDB: Log file .\ib_logfile0 did not exist: new to be createdInnoDB: Setting log file .\ib_logfile0 size to 5242880InnoDB: Log file .\ib_logfile1 did not exist: new to be createdInnoDB: Setting log file .\ib_logfile1 size to 5242880InnoDB: Cannot initialize created log files becauseInnoDB: data files are corrupt, or new data files wereInnoDB: created when the database was started previousInnoDB: time but the database was not shut downInnoDB: normally after that.010629 19:53:46 Can't init databases How can I remove these errors? Can u plz give me a my.cnf file? thanx byee ---Original Message--- From: Gerald Clark Date: Saturday, June 30, 2001 06:26:40 AM To: Bhartendu Maheshwari Cc: [EMAIL PROTECTED] Subject: Re: Problem in initializing mySQL on Windows Plateform You did not put the line[mysqld]before the server options so the server knows which lines belong to it.Bhartendu Maheshwari wrote: Hello I had installing mySQL as well myODBC, but when I run mysqld it has given an error C:\mysqld error: Found option without preceding group in config file: c:\my.cnf at line: 1 Program aborted Next time I had write a file my.cnf as innodb_data_file_path = ibdata1:400M;ibdata2:400M innodb_data_home_dir = c:\mysql set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Since my harddisk have only 900MB free space. So i choose innodb_data_file_path to be 400MB each. Now when I again run mysqld, It has given again error as C:\mysqld Can't initialize InnoDB as 'innodb_data_file_path' is not set Now Please tell me what to do? Thank you-- Gerald L. Clark[EMAIL PROTECTED] _IncrediMail - Email has finally evolved - Click Here
RE: BerkleyDB and mysql and COMMIT
Hi Also Nusphere have just released GEMINI tables which support row locking.Been on their beta team since day one and the commercial product is very good. Easy to setup with their install procedure and all round worth every penny. Their support staff have been fantastic, never once letting me down.! ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of MikemickaloBlezien Sent: 29 June 2001 15:49 To: Gerlinde Fischer Cc: [EMAIL PROTECTED] Subject: Re: BerkleyDB and mysql and COMMIT On Fri, 29 Jun 2001 15:29:08 +0200, Gerlinde Fischer [EMAIL PROTECTED] wrote: I don't believe BDB table handler support row-locking. I suggest looking at using Innobase tables handlers. Hi, I have the following configuration I have Linux I have compile mysql with the following configure parameters: ./configure --enable-shared --with-berkeley-db --with-mysqld-ldflags='-all-static' I have created a BerkleyDB-table. After that I have set autocommit=0 and I have inserted one row in the one client and I tried to look with select on the same table in another client. Now I found, that the whole table is locked. But I want only row-locking. Knows someone a solution. After commit I can see all records. Thanks Gerlinde BLITZ Internet Service GmbH Kronacher Strasse 41 D-96052 Bamberg, Germany Tel. +49/951/9685160, Fax +49/951/9685164 http://www.blitz.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
UPDATE/REPLACE command
Hi! Was UPDATE/REPLACE command implemented? I mean, a command which does update and if it updated to record to match an already existing unique index then the old record is killed and the new stays. Example ( UPPLACE - UPDATE/REPLACE command): table: ids ID (primary key) NAME 1 a 2 b 3 c 4 d UPPLACE ids set id=4, name='z' where id=2; after this table has: 1 a 4 z 3 c Artem - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 : Problem in initializing mySQL on Windows Plateform
Hi! Error number 3 in Windows is 3 The system cannot find the path specified. ERROR_PATH_NOT_FOUND Did you create a directory for log files before starting MySQL? In the second printout you probably have created the directory. But because database creation failed the first time, you have to delete all data and log files of InnoDB and start MySQL again. Hope this helps, Heikki http://www.innodb.com . From: Bhartendu MaheshwariDate: Saturday, June 30, 2001 07:21:08 AM To: gerald [EMAIL PROTECTED] Subject: Re: Problem in initializing mySQL on Windows Plateform Thanx for yr helpbut now One more problem comes, that is descibed below C:\mysqld InnoDB: operating system error number 3 in a file operation. InnoDB: operating system error number 3 in a file operation. InnoDB: Error in creating or opening c:\iblogs\ib logfile0 010629 19:50:14 Can't init databases C:\mysqld InnoDB: Log file .\ib logfile0 did not exist: new to be created InnoDB: Setting log file .\ib logfile0 size to 5242880 InnoDB: Log file .\ib logfile1 did not exist: new to be created InnoDB: Setting log file .\ib logfile1 size to 5242880 InnoDB: Cannot initialize created log files because InnoDB: data files are corrupt, or new data files were InnoDB: created when the database was started previous InnoDB: time but the database was not shut downInnoDB: normally after that. 010629 19:53:46 Can't init databasesHow can I remove these errors? Can u plz give me a my.cnf file?thanxbyee - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in Win32 stop after 5 minutes.
I am use the MySQl Win 32 in win98 version 3.23.27-beta and too in 3.23.39. After 5 minutes the server stop, but MySqlAdmin don't show it stopped, then I stop it in MySqlAdmin and restart, again I have more 5 minutes. This is only for developer, no my server, but this problem is annoying. This in an AMD Durom 700 Mhz with 128 of ram and in an Athlon 850 with 128 of ram. I saw the my.ini and is all ok. Tanks..
rebuilding ISM files
Hi, I have radacct.ISD and radacct.frm files, but I don't have radacct.ISM file. How can I rebuild this file ? Thanks Mucahit
SQL optimization
Hi, MySQL seems to really under perform when using joins. Am I doing something wrong? I have the following query: SELECT DISTINCT Product.ProductID, Product.Title, ProductFormat.Price, ProductFormat.TradePrice, ProductFormat.ProductCode, ProductFormat.Format, ShoppingCart.Quantity FROM Product LEFT JOIN ProductFormat ON ProductFormat.ProductID = Product.ProductID LEFT JOIN ShoppingCart ON ProductFormat.ProductCode = ShoppingCart.ProductCode WHERE ShoppingCart.PersonID = 13; Product has about 1000 rows ProductFormat has about 2000 rows ShoppingCart has about 20 rows Thing is, this query takes on average 3 seconds to return about 4 records!! my other queries seem to be in the tens of milliseconds. Thing is, all my queries with JOINS in them exhibit this poor performance. PersonID is the primary key in ShoppingCart and the big table Product. ProductFormat has ProductCode as its primary key. Is there anything I can do about this? Thanks in advance Dean Ware Web Developer http://www.readingroom.com Winner : Best Business to Business Website 2000-01 (Internet Business Awards sponsored by ntl) Reading Room Ltd. 77 Dean Street Soho London W1D 3SH UK Tel: +44 (0) 20 7734 9499 Fax: +44 (0) 20 7439 4190 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, re-transmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Trouble with Grant command
When I create a database for a customer I normally just use the following command grant all on database.* to user; And this works fine... But one customer on one of his databases can't use the alter command... So I went in and did a grant alter on database.* to user and that didn't fix it... I did a select on the db table and the user has the alter_priv bit set... I'm using 3.23.32 on this server, any help would be appreciated. Julia -- [ Julia Anne Case ] [Ships are safe inside the harbor, ] [Programmer at large] [ but is that what ships are really for.] [ Admining Linux ] [ To thine own self be true. ] [ Windows/WindowsNT ] [ Fair is where you take your cows to be judged. ] PGP signature
Re: MySql in Win32 stop after 5 minutes.
At 12:08 29/06/2001 -0300, Marcio - ProgMar wrote: Hi! Are you using PHP or Apache ? Because this behavior was already reported only for Win98 and until now I wasn't be able to repeat the same behavior on my machine. The possible cause should be an environment situation that make MySQL to loss, maybe the correct paths. Some users fixed the problem with a new installation of Windows, however a detailed description of your environment is useful for me to try to repeat the problem and find the cause. Regards, Miguel I am use the MySQl Win 32 in win98 version 3.23.27-beta and too in 3.23.39. After 5 minutes the server stop, but MySqlAdmin don't show it stopped, then I stop it in MySqlAdmin and restart, again I have more 5 minutes. This is only for developer, no my server, but this problem is annoying. This in an AMD Durom 700 Mhz with 128 of ram and in an Athlon 850 with 128 of ram. I saw the my.ini and is all ok. Tanks.. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: distinct / limit optimization
Because it wasn't in system cache yet? X Gogo wrote: Hi, I've tried the folowing query: SELECT DISTINCT column1 FROM table1 LIMIT 10; and got the result for 0.23 sec. Then I've tried the same query without limit: SELECT DISTINCT column1 FROM table1; and got the result for 0.01 sec. which is some 23 times faster. There are about 1 rows in table1 and column1 has an index. I've read in the manual that MySQL uses optimization when you combine DISTINCT with LIMIT n that would make it stop as soon as it finds n unique rows. Why then the first query that uses LIMIT is considerably slower? George Áåçïëàòíà ïîùåíñêà ñëóæáà http://mail.Rambler.bg/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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
MySQL on NFS?
I'm sure this is been covered before but I couldn't find any list archives. I've just aquired a pair of clustered NetApp 740's for a steal of a deal and now I'm trying to figure out what I can migrate to them. The thought occured to me that since Oracle performs so well on NetApps over NFS that perhaps I could move my MySQL databases. The documentation has the expected warnings against NFS and file locking, but doesn't really get into any details. Are people running MySQL with a NFS backend? Any comments? -- Kelsey Cummings - [EMAIL PROTECTED] sonic.net System Administrator300 B Street, Ste 101 707.522.1000 (Voice)Santa Rosa, CA 95404 707.547.2199 (Fax) http://www.sonic.net/ Fingerprint = 7F 59 43 1B 44 8A 0D 57 91 08 73 73 7A 48 90 C5 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on NFS?
Hi, everybody here, Anybody can help with telnet to Linux and login to mySQL, show information about current mysql setting, create new DB, and table? Since, I am using MSSQL under NT platform, it is pretty much different.. Thanks lot Amy - Original Message - From: Kelsey Cummings [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 29, 2001 3:21 PM Subject: MySQL on NFS? I'm sure this is been covered before but I couldn't find any list archives. I've just aquired a pair of clustered NetApp 740's for a steal of a deal and now I'm trying to figure out what I can migrate to them. The thought occured to me that since Oracle performs so well on NetApps over NFS that perhaps I could move my MySQL databases. The documentation has the expected warnings against NFS and file locking, but doesn't really get into any details. Are people running MySQL with a NFS backend? Any comments? -- Kelsey Cummings - [EMAIL PROTECTED] sonic.net System Administrator300 B Street, Ste 101 707.522.1000 (Voice)Santa Rosa, CA 95404 707.547.2199 (Fax) http://www.sonic.net/ Fingerprint = 7F 59 43 1B 44 8A 0D 57 91 08 73 73 7A 48 90 C5 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Please help with this!
Hi, everybody here, Anybody can help with telnet to Linux and login to mySQL, show information about current mysql setting, create new DB, and table? Since, I am using MSSQL under NT platform, it is pretty much different.. Thanks lot Amy
RE: SELECT CASE doesn't work?
On 29-Jun-01 Sönke Tesch wrote: Hi! The CASE statement doesn't seem to work, even the three examples given in the docs (7.4.8 Control Flow Functions) return errors: mysql select case 1 when 1 then one when 2 then two else more end; ERROR 1064: You have an error in your SQL syntax near '1 when 1 then one when 2 then two else more end' at line 1 I tried it with my local copy (Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686), Debian distribution), as well as with the one installed at my ISP. What's happening here? CASE didn't show up till 3.23.3 Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Trouble with Grant command
flush privileges. Julia A. Case wrote: When I create a database for a customer I normally just use the following command grant all on database.* to user; And this works fine... But one customer on one of his databases can't use the alter command... So I went in and did a grant alter on database.* to user and that didn't fix it... I did a select on the db table and the user has the alter_priv bit set... I'm using 3.23.32 on this server, any help would be appreciated. Julia -- Gerald L. Clark [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
bug please help
I was trying to install Mysql in win 98 and after several attempts all I got was: (using mysqld command) (I also send you the my.cnf file I had to edit several times) Please help InnoDB: a new database to be created! InnoDB: Setting file c:\ibdata\ibdata1 size to 20971520 InnoDB: Database physically writes the file full: wait... InnoDB: Data file c:\ibdata\ibdata2 did not exist: new to be created InnoDB: Setting file c:\ibdata\ibdata2 size to 20971520 InnoDB: Database physically writes the file full: wait... InnoDB: Log file c:\iblogs\ib_logfile0 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile0 size to 3145728 InnoDB: Log file c:\iblogs\ib_logfile1 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile1 size to 3145728 InnoDB: Log file c:\iblogs\ib_logfile2 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile2 size to 3145728 Innobase: Assertion failure in thread 4294055337 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010629 14:51:37 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010629 14:51:37 Aborting InnoDB: Warning: shutting down not properly started database 010629 14:52:12 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete my.cnf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
About PHP with MYSQL
Greetings to all. I am new in the list. I need to know like I can consent with Code PHP to a database in MYSQL. Thank you for the Help that you can offer me. Amaury - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
About PHP with MYSQL
Greetings to all. I am new in the list. I need to know like I can consent with Code PHP to a database in MYSQL. Thank you for the Help that you can offer me. Amaury - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please help with this!
At 3:40 PM -0400 6/29/01, Web Mailing List wrote: Hi, everybody here, Anybody can help with telnet to Linux and login to mySQL, show information about current mysql setting, create new DB, and table? Since, I am using MSSQL under NT platform, it is pretty much different.. Why? You can run the mysql client on both platforms and do any of those things you mention. Thanks lot Amy -- Paul DuBois, [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
Create Table with password
Hi All.. I created a table .. create table A ( A1 int(4) auto_increment, A2 varchar(16), primary key (A1)) password='password'; 'mysql --vesion' returns the following line on my system: mysql Ver 11.15 Distrib 3.23.39, for pc-linux-gnu (i686) My question is ... How the password option work on a table... Anybody .. Drop few lines... Please -- Mohammad H. Khan Web Architect Legal Computer Solutions, Inc Boston, MA 02109 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Fwd: Re: message traffic]
This was sent to me, and it should've gone to the list instead. Original Message Subject: Re: message traffic Date: Fri, 29 Jun 2001 11:17:57 -0700 From: Michael Tam [EMAIL PROTECTED] To: Ashley M. Kirchner [EMAIL PROTECTED] References: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Hi I strongly agreed with Ashley there. I am using hotmail but I can't screen the list and direct them to a folder which I can decdicate to store the list responses. This would be a big PLUS, if we can do that in the subject line such that webbase mail service users can have an option to screen the list responses. Regards, Michael - Original Message - From: Ashley M. Kirchner [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 7:57 PM Subject: Re: message traffic All of the suggested methods for filtering mail from MySQL list is great...for those using an actual mailer program. For people sitting on web based email services, they don't have that capability (except for maybe sorting based on subject, receive date, or something like that), and having subject tags helps a great deal. It's great being able to determine emails at first glance, instead of having to open them one by one because you have no clue what list they belong to, or what they're about. Just my 2 cents worth. -- H | Hi, I'm currently out of my mind. Please leave a message. BP! + Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave, #6 http://www.pcraft.com . . .. Boulder, CO 80303, U.S.A. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HELP! Please help me
My host has set the max_allowed_packet to only 16384, so I'm unable to do large queries, such as submitting large text files into the database. Is there a way to increase the max_allowed_packet? Keeping in mind I'm on a shared host. Thanks in advance! Jez _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Fwd: SELECT using and limit not optimized.]
John Wythe/SCO:sysdev:root wrote: Thanks for the Reply Gerald. I tried your suggestion, but it does not make any difference. Should there not be an implied ORDER BY when using an index? John Gerald Clark wrote: First of all, there is no NEXT record without an ORDER BY. LIMIT returns a subset of the selected rows of the result set. The result set must be selected and ordered before it can be limited. you probably want: SELECT * from wk004.slsf01 where ___RecNo 3000 order by ___RecNo limit 1; [EMAIL PROTECTED] wrote: Description: I am trying to get the next record given a key (numeric or string), What is the best way to do this. I am currently using: SELECT * from wk004.slsf01 where ___RecNo 3000 limit 1; table typepossible_keys key key_len ref rowsExtra slsf01range PRIMARY PRIMARY 4 NULL349 where used The explain result for this command show's rows accessed as 349, there are 3349 records in the file. If I use: SELECT * from wk004.slsf01 where ___RecNo 0 limit 1; explain shows 3349 rows. table typepossible_keys key key_len ref rowsExtra slsf01range PRIMARY PRIMARY 4 NULL3349where used To me this indicates that the more records in the file the slower this statement will be. Timing results with 3000 vs 10 records verify this. Why is rows not 1 in this case? Is there a different SELECT command I should be using? ___RecNo is an AUTO-INCREMENT BIGINT field, and is the only member of the PRIMARY key, sorted ASCENDING. The problem occurs on any index I use (string or INT), single or multiple keys. Occurs on Linux and SCO Unix. How-To-Repeat: EXPLAIN SELECT * from wk004.slsf01 where ___RecNo 3000 limit 1; EXPLAIN SELECT * from wk004.slsf01 where ___RecNo 0 limit 1; Fix: Submitter-Id:jwythe Originator: jww Organization: Silk Systems Inc. MySQL support: none Synopsis:SELECT using and limit not optimized. Severity:serious Priority:medium Category:mysql Class: support Release: mysql-3.23.37 (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.19 Distrib 3.23.37, for pc-sco3.2v5.0.4 on i386 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 version3.23.37 Protocol version 10 ConnectionLocalhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 11 min 1 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 5 Flush tables: 1 Open tables: 0 Queries per second avg: 0.002 Environment: Touch Intel PII-300Mhz, Redhat 6.2 Linux/SCO Openserver 5, same System: SCO_SV sysdev 3.2 2 i386 Some paths: /bin/make /usr/local/bin/gcc /bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-sco3.2v5.0.5/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS=' ' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root sys 36 May 19 1998 /lib/libc.a - /opt/K/SCO/unixds/5.1.0Ha/lib/libc.a lrwxrwxrwx 1 root sys 37 May 19 1998 /lib/libc.so - /opt/K/SCO/unixds/5.1.0Ha/lib/libc.so lrwxrwxrwx 1 root sys 40 May 19 1998 /usr/lib/libc.a - /opt/K/SCO/unixds/5.1.0Ha/usr/lib/libc.a lrwxrwxrwx 1 root sys 41 May 19 1998 /usr/lib/libc.so - /opt/K/SCO/unixds/5.1.0Ha/usr/lib/libc.so lrwxrwxrwx 1 root root 41 May 13 1998 /usr/lib/libc.so.1 - /opt/K/SCO/Unix/5.0.4Eb/usr/lib/libc.so.1 Configure command: ./configure --with-low-memory - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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
ERROR 1062 at line 46: Duplicate entry '4' for key 1
Hi; I'm trying to learn MySQL, having some difficulties: mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) for pc-linux-gnu (i686) Getting the following error: ERROR 1062 at line 46: Duplicate entry '4' for key 1 What I did was: mysqldump -u jimjones -p XxXJimmy lovingdata-Db-test.txt Deleted all the Db files in /var/lib/mysql/lovingdata mysql --user=jimjones --password=XxXJimmy lovingdata lovingdata-Db-test.txt So there must be an error in the database. So how do I fix the error? How do I figure out which line is #46? How do I use the isamchk utility for an entire database, not just tables? Where is the documentation (besides man pages) for mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) Joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Copy Record command
Actually I'm not trying to create a table I'm trying to create a record in that table and instead of having to type in all 49 fields into the insert into table command I was hoping you could copy a record that already exists and just change the necessary fields. -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: June 26, 2001 5:59 PM To: Klein, Tracy ISTA:EX; [EMAIL PROTECTED] Subject: Re: Copy Record command Don't know what a COPY RECORD command is but my best guess is that you are looking for a create table with a select clause. - Original Message - From: Klein, Tracy ISTA:EX [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 27, 2001 0:11 Subject: Copy Record command Hello, I cannot find a COPY RECORD command in www.mysql.com - is it to be found under another name? I have a 49 field record I have to create this morning. Ugh. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1062 at line 46: Duplicate entry '4' for key 1
Duplicate entry for 'x' for key y means that there exists a unique key (key 1) on a certain column that already contains the entry '4'.. You are trying to insert something with '4' and hence it complains since that key says it must be unique. In order to find out what line is #46... its the 46th line from the top of the file. ryan Hi; I'm trying to learn MySQL, having some difficulties: mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) for pc-linux-gnu (i686) Getting the following error: ERROR 1062 at line 46: Duplicate entry '4' for key 1 What I did was: mysqldump -u jimjones -p XxXJimmy lovingdata-Db-test.txt Deleted all the Db files in /var/lib/mysql/lovingdata mysql --user=jimjones --password=XxXJimmy lovingdata lovingdata-Db-test.txt So there must be an error in the database. So how do I fix the error? How do I figure out which line is #46? How do I use the isamchk utility for an entire database, not just tables? Where is the documentation (besides man pages) for mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) Joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: About PHP with MYSQL
On Fri, 29 Jun 2001, @maury wrote: Greetings to all. I am new in the list. I need to know like I can consent with Code PHP to a database in MYSQL. Thank you for the Help that you can offer me. Amaury there are many mysql function in php, mysql_query, mysql_connect, etc. PHP manual will answer this. come to www.php.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
system error 1067
Hello everyone, I have mysql-3.23.39 installed on a Win2k Pro box (not sure why!). It had been running just fine, then all of a sudden stopped working. When I try a 'NET START mysql', I get the below error: ---Begin Error The MySql service is starting. The MySql service could not be start A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly. ---End Error Has this happened to anyone else? Or am I just the unlucky one? Tyler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 transaction related question
MySQL provides three transaction-safe tables including Berkeley_DB, GEMINI and InnoDB Tables, I have some queries on them: 1. What are the differences between these three type of transaction-safe table types? 2. Which type should be used for the E-Commerce web site? 3. Is true that BDB is free while the other two are not free? 4. In MySQL, we can use transaction as the following: BEGIN; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summmary=@A WHERE type=1; COMMIT; (or ROLLBACK) but how to apply it in the E-Commerce web site with PHP programming? Thank you very much!
RE: system error 1067
Try looking in mysql\data\mysql.err or running mysqld --standalone, it may provide more information. Hello everyone, I have mysql-3.23.39 installed on a Win2k Pro box (not sure why!). It had been running just fine, then all of a sudden stopped working. When I try a 'NET START mysql', I get the below error: ---Begin Error The MySql service is starting. The MySql service could not be start A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly. ---End Error Has this happened to anyone else? Or am I just the unlucky one? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php