RE: Newbie Question - Query works in access but not MySQL
Do you have a space between PartNumber and Like? Also there's not need to ORDER BY - the GROUP BY does that anyway (I know that's the case elsewhere) and finally, I have to guess that it's objecting to Obsolete not being in the main select.. have you tried including it and grouping by it? you can ignore the obsolete in the main select when it's returned since it will all be the same value... put it first. Alan -Original Message- From: Ed Reed [mailto:ereed;nearfield.com] Sent: Tuesday, 12 November 2002 18:54 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Newbie Question - Query works in access but not MySQL UPDATE: Still trying to solve this and I think I have something that's a little easier to understand. If I run the following query against MySQL it returns Unknown column 'Obsolete' in 'having clause'. If I run the query using MSAccess as a frontend to MySQL the query runs correctly (it returns a recordset with 9 records). If I remove the Obsolete column from the Having clause the MySQL server appears to hang up while it processes the query but it never returns even if left for an hour. Please, has anyone got any ideas? SELECT Products.PartNumber, Sum(tblInvTransaction.Qty) AS SumOfQty FROM Products LEFT JOIN tblInvTransaction ON Products.ProductID = tblInvTransaction.ProductID GROUP BY Products.PartNumber HAVING ((Products.PartNumberLike %A-000%) AND (Products.Obsolete-1)) ORDER BY Products.PartNumber; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: why is this slow?
On Tue, 12 Nov 2002 10:24:34 +0800 Jaime Teng [EMAIL PROTECTED] wrote: At 04:47 PM 11/11/2002 +0800, Thomas Seifert wrote: Are you using MySQL-3.23.x? AFAIK it doesn't use a key for ORDER BY (MySQL-4.x does). Maybe thats the cause? Hi, Yes. Im using 3.23.52(nt). I just upgraded it from 3.23.27. You mean, if I have ORDER BY as part of the query statement, MySQL doesnot use index/keys? Does this mean, that there is absolutely no way to improve my query? Not sure, I'm no pro on all the ways to optimize queries, maybe someone other on the list has some more ideas? Hmm.. I read lots of good stuffs with MySQL 4.x; is this already safe to use? I'm using it in production on myphorum.de for some months already, works without a hitch so far. Thomas regards, jaime Thomas On Mon, 11 Nov 2002 16:41:50 +0800 Jaime Teng [EMAIL PROTECTED] wrote: Hi, I have a mysql table: mysql describe eventlog; +-+--+ | Field | Type | +-+--+ | id | int(10) unsigned | | time| datetime | | source | varchar(10) | | description | varchar(255) | +-+--+ id is a unique auto_increment key. the way data is entered, this key is always sorted. and most importantly, it is a KEY index too. Currently, this table has about 400,000 entries occupying about 30MB of hard disk space. Whenever I try to perform: SELECT * FROM eventlog where id number ORDER BY id DESC limit 20; The result is very slow, taking 5~10 seconds WHEN number is almost at the very top of the list: example, if max(id) is 300, then doing the above search with number being 290, will be very slow. the performance ONLY increases when number is very low OR when select count(*) from eventlog where id number; would give a small number. Is there a way to increase the performance of my table/search? jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Bug? mysql 4.0.4 wouldn't look for my.cnf in the right location.
Pada Tue, 12 Nov 2002 14:43:34 +0900 Chung Ha-nyung [EMAIL PROTECTED] menulis: I compiled mysql 4.0.4 with option --prefix=/local/mysql -- datadir=/mnt/data but it is likely that mysql still look for my.cnf file in $prefix/var directory not in /mnt/data Is it a bug? add --defaults-file=/mnt/data/my.cnf inline option when running mysqld, or just edit your safe_mysqld file, you'll find why it's always search in $prefix/var -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Where can I get innodb monitoring tools?
innodb manual (http://www.innodb.com/ibman.html) mentions about innodb monitoring tools, e.g. innodb_tablespace_monitor. But they don't seem to be included in mysql 4.0.4. Should I buy them or can get somewhere else, like innodb homepage? -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql_install_db hangs
Hello, One of my custommers use mysql database and a few days ago he asked me to solve the strange problem with it. I don't know the history of server so I am unable to feed you with information like what has been changed before problem occured, but below is the describtion of problem itself and maybe someone can tell what can be the reason. facts: ps ax doesn't show any mysql process running netstat -lnp shows that tcp/3306 port is in listening state but application doesn't present ('-' instead). pid file still exsists but process with pid listed in pid file doesn't present. mysql is unable to start because socket is already in use... I have uninstalled mysql rpm-s and rebooted, after system booted up 3306 port became finally closed so I tried to install new rpm-s. First I tried to install MySQL-VERSION.i386.rpm and after some time I saw: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables after that it hangs and there is no message until I terminate it from shell using CTRL+c. After termination: #ps ax | grep mysql 5736 pts/2S 0:00 sh /usr/bin/mysql_install_db -IN-RPM 5741 pts/2S 0:00 /usr/sbin/mysqld --bootstrap --skip-grant-tables --basedir=/ --datadir=/var/lib/mysql --skip-innodb --skip-gemini --skip-bdb #netstat -lnp | grep 3306 tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN - # I have tried to install mysql from source and installation finished successfully but problem still exsist when I run mysql_install_db Any ideas? -- George Chelidze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 compiling mysqlgui 1.7.5
Hi, I try to compile mysqlgui-src-1.7.5 on my GNU/Linux system with gcc-3.2 but with the make I got this : # gmake gmake: *** No rule to make target `edfile.o', needed by `mysqlgui'. Stop. It would be great if you could help me with this ! Best regards, Pierre. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on installing mysql from mysql-3.23.52-sun-solaris2.8-sparc.tar
Hi, I faced a problem while installing Mysql mysql-3.23.52-sun-solaris2.8-sparc.tar I followd the instructions on INSTALL-BINARY then when I tryed to run mysql it gave my the following error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) the following what I have got from running mysqlbug: System: SunOS nwpsrv 5.8 Generic_108528-13 sun4u sparc SUNW,Ultra-4 Architecture: sun4 Some paths: /usr/bin/perl /usr/ccs/bin/make /opt/SUNWspro/bin/cc Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1768408 Mar 13 2002 /lib/libc.a lrwxrwxrwx 1 root root 11 Mar 16 2002 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1146296 Mar 13 2002 /lib/libc.so.1 -rw-r--r-- 1 root bin 1768408 Mar 13 2002 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Mar 16 2002 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1146296 Mar 13 2002 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-ser ver-suffix= --enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared CC=gcc 'CFLAGS=-O3 -fno-omit-frame-poi nter' 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' CXX=gcc Perl: This is perl, version 5.005_03 built for sun4-solaris please help Sultan AL-Yahyai Ministry Of Trasportation and Telecomunication Directorate General of Civil Aviation and Meteology Office Phon: (00968) 519611 Fax: : (00968) 519363 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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....UNION SELECT.....
Hallo my friends I am writing a database application program with PHP and MySQL. I have two tables that I want to query in the same time with SELECT...UNION SELECT ... syntax. Too many errors encountered; the rest of the message is ignored: The 2 tables are APPOINTMENT table (APP) and SALESREPORT table (SR). The APPOINTMENT Table has these 8 columns : No_Appointment, SalesID, CustID, Date, Time, ToDo, Done, TimeStamp. And the SALESREPORT Table has these 4 columns : SalesID, CustID, Report, TimeStamp. I want to display the information from these 2 tables in the same time, like this under below : SalesID CustID Status TimeStamp -- 1 1 Not Yet 2002195428 --- from APP 1 2 Not Yet 200220 --- from APP 2 3 TOL 2002090010 --- from SR ... ... ... ... ... ... ... ... I did so : SELECT SalesID, CustID, Done AS Status, TimeStamp FROM Appointment Where Done='Not Yet' UNION SELECT SalesID, CustID, Report AS Status, TimeStamp FROM SalesReport WHERE Report LIKE 'TOL%' I got this error message : mysql SELECT SalesID, CustID, Done AS Status, TimeStamp FROM Appointment Where Done='Not Yet' UNION SELECT SalesID, CustID, Report AS Status, TimeStamp FROM SalesReport WHERE Report LIKE 'TOL%'; ERROR 1064: You have an error in your SQL syntax near 'UNION SELECT SalesID, CustID, Report AS Status, TimeStamp FROM SalesReport WHERE' at line 1 mysql How should I do this select query ? Thank you very much in advance. __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SELECT....UNION SELECT.....
On Tue, 12 Nov 2002 12:02:04 +0100 [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: SELECT SalesID, CustID, Done AS Status, TimeStamp FROM Appointment Where Done='Not Yet' UNION SELECT SalesID, CustID, Report AS Status, TimeStamp FROM SalesReport WHERE Report LIKE 'TOL%' You have to use version 4.x for unions to work. In 3.23.x you have to use temporary tables. -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 port MS Access to MySQL ??
MyODBC works fine, but what to do if you have hundreds of tables?=20 its painful job, maybe theres some easier way to do that ? regards, terry sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to port MS Access to MySQL ??
MySQLFront will create the tables and pump the data with one button press Alan -Original Message- From: Terry [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 12 November 2002 22:02 To: [EMAIL PROTECTED] Subject: RE: How to port MS Access to MySQL ?? MyODBC works fine, but what to do if you have hundreds of tables?=20 its painful job, maybe theres some easier way to do that ? regards, terry sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: update tablename
- Original Message - From: [EMAIL PROTECTED] To: Rodrigo San Martin [EMAIL PROTECTED] Sent: Tuesday, November 12, 2002 3:33 AM Subject: Re: update tablename Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi. I want to change a tablename in my database. How do i do that? I want to do it from a webpage so i need to use php. -- Rodrigo San Martin Institutt for datateknologi og informatikk http://www.idi.ntnu.no/~rodrigo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Reference Integrity - MySQL 4
Hi, Any idea when MySQL will support thi feature? Any idea when MySQL 4 will be available? Thanks a lot. Hernán Seivane TacticaSoft Transformando sus Datos en Activos [EMAIL PROTECTED] http://www.tacticasoft.com 54-11-5238-0014 54-11-5238-0015 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 queries
mysql,query Hi List I have a couple of slow queries listed in my slow log, but I don't know what to do from here to make them fast. Here is an EXPLAIN table: mysql explain w3t_Users; ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-++ | U_Username | varchar(30) | | MUL | || | U_Password | varchar(32) | | | || | U_Email| varchar(50) | YES | | NULL || | U_Fakeemail| varchar(50) | YES | | NULL || | U_Name | varchar(100) | YES | | NULL || | U_Totalposts | int(9) unsigned | YES | | NULL || | U_Laston | int(11) unsigned | YES | | NULL || | U_Signature| text | YES | | NULL || | U_Homepage | varchar(150) | YES | | NULL || | U_Occupation | varchar(150) | YES | | NULL || | U_Hobbies | varchar(200) | YES | | NULL || | U_Location | varchar(200) | YES | | NULL || | U_Bio | text | YES | | NULL || | U_Status | varchar(15) | | MUL | User || | U_Sort | int(4) unsigned | YES | | NULL || | U_Display | varchar(10) | | | || | U_View | varchar(10) | | | || | U_PostsPer | int(11) unsigned | YES | | NULL || | U_Number | int(9) unsigned | | PRI | NULL| auto_increment | | U_EReplies | char(3) | | | || | U_Notify | char(3) | | | || | U_TextCols | char(3) | YES | | NULL || | U_TextRows | char(3) | YES | | NULL || | U_Extra1 | varchar(200) | YES | | NULL || | U_Extra2 | varchar(200) | YES | | NULL || | U_Extra3 | varchar(200) | YES | | NULL || | U_Extra4 | varchar(200) | YES | | NULL || | U_Extra5 | varchar(200) | YES | | NULL || | U_Post_Format | varchar(5) | | | || | U_Registered | int(11) unsigned | YES | | NULL || | U_Preview | varchar(5) | YES | | NULL || | U_Picture | varchar(150) | YES | | NULL || | U_PictureView | char(3) | YES | | NULL || | U_Visible | char(3) | YES | | yes || | U_PicturePosts | char(3) | YES | | NULL || | U_AcceptPriv | char(3) | YES | | yes || | U_RegEmail | varchar(50) | YES | | NULL || | U_RegIP| varchar(15) | YES | | NULL || | U_Groups | varchar(250) | YES | | -1- || | U_Language | varchar(20) | YES | | NULL || | U_Title| varchar(100) | YES | | NULL || | U_FlatPosts| char(2) | YES | | NULL || | U_TempPass | varchar(32) | YES | | NULL || | U_Color| varchar(15) | YES | | NULL || | U_TempRead | text | YES | | NULL || | U_StyleSheet | varchar(50) | YES | | NULL || | U_TimeOffset | varchar(10) | YES | | NULL || | U_Privates | int(4) unsigned | YES | | 0 || | U_FrontPage| varchar(20) | YES | | NULL || | U_ActiveThread | int(4) unsigned | YES | | NULL || | U_StartPage| char(2) | YES | | cp || | U_Favorites| varchar(250) | YES | | - || | U_ShowSigs | char(3) | YES | | NULL || | U_OnlineFormat | char(3) | YES | | NULL || | U_Rating | varchar(5) | YES | | 0 || | U_Rates| int(4) unsigned | YES | | 0 || | U_RealRating | int(1) unsigned | YES | | NULL || | U_PicWidth | int(4) unsigned | YES | | NULL || | U_PicHeight| int(4) unsigned | YES | |
Re: Reference Integrity - MySQL 4
4.0 can be downloaded now and supports RI -- if your tables are InnoDB tables, and you create indexes on the fk columns. The online mysql manual has a lot of information on how to setup InnoDB tables -- chapter 7. Greg. - Original Message - From: Hernan Seivane [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 12, 2002 11:11 PM Subject: Reference Integrity - MySQL 4 Hi, Any idea when MySQL will support thi feature? Any idea when MySQL 4 will be available? Thanks a lot. Hernán Seivane TacticaSoft Transformando sus Datos en Activos [EMAIL PROTECTED] http://www.tacticasoft.com 54-11-5238-0014 54-11-5238-0015 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
installed mysql
*This message was transferred with a trial version of CommuniGate(tm) Pro* I have recently loaded mysql on macosx 10.2 It has loaded it in the directroy /library/mysql presently I have my user prompt on the terminal screen. I know that I need the sql prompt in order to be able to issue sql commands. How can I get to the sql prompt. Please help Bhavul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
last_insert_id()
Hi, I am using C# with ODBC.Net to communicate with MySQL. I want to determine the last ID of an auto_increment field in the database. When I manually perform the insert using the MySQL command window I can then follow up with select last_insert_id() and I get the correct value, however, when using ODBC to perform the insert (via a .Net DataAdapter) the last_insert_id() returns 0. Can anyone provide some insight into this? Best Regards, Cain O'Sullivan [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
wait_timeout doesnt get set
Hi It seems I cannot set wait_timeout variable. I set it up in /etc/my.cnf with this line: set-variable= wait_timeout=15 under [mysqld] section. I tried MySQL 3.23.48 and 3.23.49a (binary, linux i686 distributions, we cannot use newer ones as they have serious problems under heavy load). When I do mysql --help at the end it will give me a list of default values, in which it will show wait_timeout as 15 (as set in my.cnf) but when I do show variables on mysql console it shows wait_timeout as 30. This is very strange as I run exactly the same config (3.23.48) on another server and there it shows wait_timeout as set in my.cnf. Where else should I look ? Thanks Mihai RUSU Disclaimer: Any views or opinions presented within this e-mail are solely those of the author and do not necessarily represent those of any company, unless otherwise specifically stated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Solaris 2.6
Is there any version of MySQL with a binary distribution available that supports InnoDb for Sun OS 5.6? I cannot build one from source because I do not have a compiler installed (cc) on the box. Jim Sobeck [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
Scrolling Databases
Hi, I have created a contact database using Mysql and want to be able to scroll back and forth through the database. Even after I have done a search and found a record, I want to be able to scroll back or forth from that point on. I am using PHP4 to display the results. This may be something easy to do, but I have not found any documentation on it, and with my newbie skills at both Mysql and PHP, I haven't been able to put it together. Can someone point me in the right direction. TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Scrolling Databases
select * from table_name limit 1; or limit 2,1; I hope this helps a bit? Simon -Original Message- From: Beauford [mailto:beauford.2003;rogers.com] Sent: 12 November 2002 15:04 To: [EMAIL PROTECTED] Subject: Scrolling Databases Hi, I have created a contact database using Mysql and want to be able to scroll back and forth through the database. Even after I have done a search and found a record, I want to be able to scroll back or forth from that point on. I am using PHP4 to display the results. This may be something easy to do, but I have not found any documentation on it, and with my newbie skills at both Mysql and PHP, I haven't been able to put it together. Can someone point me in the right direction. TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Installation Help
I'm trying to install MySQL under RedHat 8. I installed the MySQL 3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs. Per the instructions at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm l#Post-installation, I started the server with /usr/bin/safe_mysqld and it appears to have started. When I try to test it, I get this: [root@web01 bin]# mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I'm kinda stuck. Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 query error
Hi All, I have a table in mysql as Attributes, which has 10 recordsin it. If I run the query as select * from Attributes, it gives me 10 records, but if i run the query as Select Attribute from Attributes it gives me 9 records. But this error does not occur every time. It comes very rarely. I am using mysql 3.23.49. Please let of what could be wrong. Regards Amit Lonkar __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installation Help
Scott Pippin [EMAIL PROTECTED] Phil Iovino [EMAIL PROTECTED] 11/12/02 08:13AM I'm trying to install MySQL under RedHat 8. I installed the MySQL 3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs. Per the instructions at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm l#Post-installation, I started the server with /usr/bin/safe_mysqld and it appears to have started. When I try to test it, I get this: [root@web01 bin]# mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I'm kinda stuck. Any ideas? Did you set up root as a user? If you did, try /usr/bin/safe_mysqld -u root If not set up a user. http://www.mysql.com/doc/en/Adding_users.html hope this helps. (sql, mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newbie Question - Query works in access but not MySQL
How about if you rewrite the statement to: SELECT Products.PartNumber, Sum(tblInvTransaction.Qty) AS SumOfQty FROM Products LEFT JOIN tblInvTransaction ON Products.ProductID = tblInvTransaction.ProductID Where ((Products.PartNumberLike %A-000%) AND (Products.Obsolete-1)) GROUP BY Products.PartNumber; Mark -Original Message- From: Alan McDonald [mailto:alan;meta.com.au] Sent: Tuesday, November 12, 2002 02:05 To: Ed Reed; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Newbie Question - Query works in access but not MySQL Do you have a space between PartNumber and Like? Also there's not need to ORDER BY - the GROUP BY does that anyway (I know that's the case elsewhere) and finally, I have to guess that it's objecting to Obsolete not being in the main select.. have you tried including it and grouping by it? you can ignore the obsolete in the main select when it's returned since it will all be the same value... put it first. Alan -Original Message- From: Ed Reed [mailto:ereed;nearfield.com] Sent: Tuesday, 12 November 2002 18:54 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Newbie Question - Query works in access but not MySQL UPDATE: Still trying to solve this and I think I have something that's a little easier to understand. If I run the following query against MySQL it returns Unknown column 'Obsolete' in 'having clause'. If I run the query using MSAccess as a frontend to MySQL the query runs correctly (it returns a recordset with 9 records). If I remove the Obsolete column from the Having clause the MySQL server appears to hang up while it processes the query but it never returns even if left for an hour. Please, has anyone got any ideas? SELECT Products.PartNumber, Sum(tblInvTransaction.Qty) AS SumOfQty FROM Products LEFT JOIN tblInvTransaction ON Products.ProductID = tblInvTransaction.ProductID GROUP BY Products.PartNumber HAVING ((Products.PartNumberLike %A-000%) AND (Products.Obsolete-1)) ORDER BY Products.PartNumber; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installation Help
I believe root has all permissions. I'm using Webmin to verify it. I started it with -u root but still got the same error. Since I installed with the RPM didn't it give root permission? -Original Message- From: Scott Pippin [mailto:spippin;mtctrains.com] Sent: Tuesday, November 12, 2002 10:43 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Installation Help Scott Pippin [EMAIL PROTECTED] Phil Iovino [EMAIL PROTECTED] 11/12/02 08:13AM I'm trying to install MySQL under RedHat 8. I installed the MySQL 3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs. Per the instructions at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.ht m l#Post-installation, I started the server with /usr/bin/safe_mysqld and it appears to have started. When I try to test it, I get this: [root@web01 bin]# mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I'm kinda stuck. Any ideas? Did you set up root as a user? If you did, try /usr/bin/safe_mysqld -u root If not set up a user. http://www.mysql.com/doc/en/Adding_users.html hope this helps. (sql, mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SunOS 5.6
Hi, I am looking to install MySQL on SunOS 5.6 (SunOS 5.6 Generic_105181-23 sun4u sparc SUNW,Ultra-4) can anyone tell me which version will work and which binary to download. Thanks. Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: access denied
Inbal, Monday, November 11, 2002, 7:10:49 PM, you wrote: IO I am working with mysql, in windows, visual c++. IO I am trying to run this query from c++ program: IO select * into outfile 'table_name.txt' FIELDS TERMINATED BY '\t' ESCAPED BY IO '\0' LINES TERMINATED BY '\r' from table_name IO And i get exception with this error: access is denied for user IO (If i run this query from the data base client, i am success) IO How can i solve this problem? You must have SELECT privilege on the table and FILE privileges to use SELECT ..INTO OUTFILE command. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Installation Help
Did you set up root as a user inside of MYSQL? Eventhough root has permission it must be set up as a user inside of MySQL. Phil Iovino [EMAIL PROTECTED] 11/12/02 09:13AM I believe root has all permissions. I'm using Webmin to verify it. I started it with -u root but still got the same error. Since I installed with the RPM didn't it give root permission? -Original Message- From: Scott Pippin [mailto:spippin;mtctrains.com] Sent: Tuesday, November 12, 2002 10:43 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Installation Help Scott Pippin [EMAIL PROTECTED] Phil Iovino [EMAIL PROTECTED] 11/12/02 08:13AM I'm trying to install MySQL under RedHat 8. I installed the MySQL 3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs. Per the instructions at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.ht m l#Post-installation, I started the server with /usr/bin/safe_mysqld and it appears to have started. When I try to test it, I get this: [root@web01 bin]# mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I'm kinda stuck. Any ideas? Did you set up root as a user? If you did, try /usr/bin/safe_mysqld -u root If not set up a user. http://www.mysql.com/doc/en/Adding_users.html hope this helps. (sql, mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: query crushes server
Eugene, Monday, November 11, 2002, 9:40:20 PM, you wrote: EB mysqld-nt.exe has genrated errors and will be closed by Windows. EB You will need to restart the program. EB An error log is being created. EB select distinct a.* from gnrlasoc a, tasks b where a.row_key_1 = b.prim_key; EB The number of records this query would produce is tiny. I tested your example and it worked fine on 4.0.4. (on 4.0.3 I also got a crash). So, this bug was fixed. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how do i savely delete replication bin-logs ?
(This is a repost of an ealier answer): Here's one which takes log rotation a step further than mysql provides for. It is run on the slaves to keep track of their position and then run on the master to purge up to the earliest slave position. This is useful because you can't reliably get all the slaves' latest position by looking at a master. If a slave is down temporarily, it will not show up on the master. http://www.chelsea.net/~mprewitt/mtop/utils/purge_replication_log Andreas wrote: Hi, I'm trying to figure out a viable two site configuration. Currently I got as far as to a ultra-early stage 2 box test system in a LAN which does 2-way replication. One runs LINUX and the other one Win2K. I have MySQL 4.0.4 on both. Now the bin-logs are piling up on both machines. Well, sort of ;) If I eventually get the whole thing going, the boxes will be in two different places and talk via dial-up InterNet but not more often than 1 or 2 times a day. How can I ensure that MySQL's logs won't fill up my HDDs ? AFAIK the relevant commands SHOW SLAVE STATUS and SHOW MASTER LOGS depend on a working connection between the boxes. How can I figure out in a script which bin-log can be purged when the slave that needed it temporalily isn't reachable ? I wouldn't dare to purge on each ip-down. --- And by the way ... what is this replication client privilege, I saw in the user table on MySQL.com's Linux binary 4.0.4 ? And by another way ... the Win-Binary has neither REPLICATION SLAVE nor REPLICATION CLIENT privilege in the user table. So the replicant-user must have REPLICATION SLAVE on Linux but oviously has to get FILE on Win. Otherwise 2-way won't work. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Granting rights to more hosts, etc
Hi all, I've seen the following command line in a MySQL book, but it doesn't work on my computer running MySQL 3.2 on Windows 2000: grant all on database.* to user@% identified by 'password'; It tells me that there is an error in this command. How can I use a wildcard in this command? Can I give access for more users with a single command? Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [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 stable is MySQL 4.x vs 3.23.x?
I have been using the MySql 4.x MAX with absolutely NO problems. It's being used on heavily operated servers, and I upgraded to 4.x for it's incredible index speeds and it's VERY reliable to me. In fact, in our local benchmarks it's kicking the living crap out of Oracle on sql, query. :) ~Kelly W. Black -Original Message- From: Jaime Teng [mailto:jaime;qinet.net] Sent: Monday, November 11, 2002 7:11 PM To: [EMAIL PROTECTED] Subject: How stable is MySQL 4.x vs 3.23.x? Hi, How stable is the new MySQL 4.x? I've read some really nice and powerful stuffs with MySQL 4. x and surely like to use them. Is this still in the 'use at your own risk' stage? or is it stable enough for use already? regards, Jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_install_db hangs
Make sure some previous version of MySql isn't running. I have seen this on systems which had the OS installed version of MySql, and I had to issue shell /sbin/service mysql stop shell cd /usr/local/mysqlversion shell ./bin/mysqld_safe -user=theuserid Hope this helps... ~Kelly W. Black -Original Message- From: George Chelidze [mailto:wrath;geo.net.ge] Sent: Tuesday, November 12, 2002 1:39 AM To: [EMAIL PROTECTED] Subject: mysql_install_db hangs Hello, One of my custommers use mysql database and a few days ago he asked me to solve the strange problem with it. I don't know the history of server so I am unable to feed you with information like what has been changed before problem occured, but below is the describtion of problem itself and maybe someone can tell what can be the reason. facts: ps ax doesn't show any mysql process running netstat -lnp shows that tcp/3306 port is in listening state but application doesn't present ('-' instead). pid file still exsists but process with pid listed in pid file doesn't present. mysql is unable to start because socket is already in use... I have uninstalled mysql rpm-s and rebooted, after system booted up 3306 port became finally closed so I tried to install new rpm-s. First I tried to install MySQL-VERSION.i386.rpm and after some time I saw: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables after that it hangs and there is no message until I terminate it from shell using CTRL+c. After termination: #ps ax | grep mysql 5736 pts/2S 0:00 sh /usr/bin/mysql_install_db -IN-RPM 5741 pts/2S 0:00 /usr/sbin/mysqld --bootstrap --skip-grant-tables --basedir=/ --datadir=/var/lib/mysql --skip-innodb --skip-gemini --skip-bdb #netstat -lnp | grep 3306 tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN - # I have tried to install mysql from source and installation finished successfully but problem still exsist when I run mysql_install_db Any ideas? -- George Chelidze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Solaris 2.6
You don't have a compiler installed? Hmmm. This seems tough to believe. Try issuing 'which cc' ~K Black -Original Message- From: leaddog1 [mailto:jsobeck;lead-dog.net] Sent: Tuesday, November 12, 2002 6:44 AM To: [EMAIL PROTECTED] Subject: Solaris 2.6 Is there any version of MySQL with a binary distribution available that supports InnoDb for Sun OS 5.6? I cannot build one from source because I do not have a compiler installed (cc) on the box. Jim Sobeck [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: slow queries
Make sure when you are creating the database that U_Number | int(9) unsigned | | PRI | NULL is U_Number | numeric() | | PRI | NULL -Original Message- From: Petre Agenbag [mailto:internet;boesmanland.com] Sent: Tuesday, November 12, 2002 4:27 AM To: [EMAIL PROTECTED] Subject: slow queries mysql,query Hi List I have a couple of slow queries listed in my slow log, but I don't know what to do from here to make them fast. Here is an EXPLAIN table: mysql explain w3t_Users; ++--+--+-+-+ + | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+ + | U_Username | varchar(30) | | MUL | || | U_Password | varchar(32) | | | || | U_Email| varchar(50) | YES | | NULL || | U_Fakeemail| varchar(50) | YES | | NULL || | U_Name | varchar(100) | YES | | NULL || | U_Totalposts | int(9) unsigned | YES | | NULL || | U_Laston | int(11) unsigned | YES | | NULL || | U_Signature| text | YES | | NULL || | U_Homepage | varchar(150) | YES | | NULL || | U_Occupation | varchar(150) | YES | | NULL || | U_Hobbies | varchar(200) | YES | | NULL || | U_Location | varchar(200) | YES | | NULL || | U_Bio | text | YES | | NULL || | U_Status | varchar(15) | | MUL | User || | U_Sort | int(4) unsigned | YES | | NULL || | U_Display | varchar(10) | | | || | U_View | varchar(10) | | | || | U_PostsPer | int(11) unsigned | YES | | NULL || | U_Number | int(9) unsigned | | PRI | NULL| auto_increment | | U_EReplies | char(3) | | | || | U_Notify | char(3) | | | || | U_TextCols | char(3) | YES | | NULL || | U_TextRows | char(3) | YES | | NULL || | U_Extra1 | varchar(200) | YES | | NULL || | U_Extra2 | varchar(200) | YES | | NULL || | U_Extra3 | varchar(200) | YES | | NULL || | U_Extra4 | varchar(200) | YES | | NULL || | U_Extra5 | varchar(200) | YES | | NULL || | U_Post_Format | varchar(5) | | | || | U_Registered | int(11) unsigned | YES | | NULL || | U_Preview | varchar(5) | YES | | NULL || | U_Picture | varchar(150) | YES | | NULL || | U_PictureView | char(3) | YES | | NULL || | U_Visible | char(3) | YES | | yes || | U_PicturePosts | char(3) | YES | | NULL || | U_AcceptPriv | char(3) | YES | | yes || | U_RegEmail | varchar(50) | YES | | NULL || | U_RegIP| varchar(15) | YES | | NULL || | U_Groups | varchar(250) | YES | | -1- || | U_Language | varchar(20) | YES | | NULL || | U_Title| varchar(100) | YES | | NULL || | U_FlatPosts| char(2) | YES | | NULL || | U_TempPass | varchar(32) | YES | | NULL || | U_Color| varchar(15) | YES | | NULL || | U_TempRead | text | YES | | NULL || | U_StyleSheet | varchar(50) | YES | | NULL || | U_TimeOffset | varchar(10) | YES | | NULL || | U_Privates | int(4) unsigned | YES | | 0 || | U_FrontPage| varchar(20) | YES | | NULL || | U_ActiveThread | int(4) unsigned | YES | | NULL || | U_StartPage| char(2) | YES | | cp || | U_Favorites| varchar(250) | YES | | - || | U_ShowSigs | char(3) | YES | | NULL || | U_OnlineFormat | char(3) | YES | | NULL || | U_Rating |
RE: unable to start mysql
Don't re-install.. Fix the problem Try issuing shellcd /usr/local/mysqlversion shell./configure ~K Black -Original Message- From: mod_perl [mailto:shine_perl;spectrum.net.in] Sent: Monday, November 11, 2002 10:23 PM To: [EMAIL PROTECTED] Subject: unable to start mysql hi all, when i try to start mysql using safe_mysqld i get following message [mysql@inemrtest2 mysql]$ safe_mysqld [1] 3644 [mysql@inemrtest2 mysql]$ Starting mysqld daemon with databases from /opt/mysql/data 021112 11:59:15 mysqld ended if mysqld is crashed how can i reinstall thanks in advance shine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How to port MS Access to MySQL ??
I used MyAccess and it worked very well. One thing I didn't like was that in any table/field name that contained a space, the space was converted to an underscore. I would've rathered it just removed the space so I wrote some VBA to remove all the spaces from field and table names then let MyAccess convert everything to MySQL and it worked great. - Ed Alan McDonald [EMAIL PROTECTED] 11/12/02 3:26:15 AM MySQLFront will create the tables and pump the data with one button press Alan -Original Message- From: Terry [mailto:kewl;compfort.pl] Sent: Tuesday, 12 November 2002 22:02 To: [EMAIL PROTECTED] Subject: RE: How to port MS Access to MySQL ?? MyODBC works fine, but what to do if you have hundreds of tables?=20 its painful job, maybe theres some easier way to do that ? regards, terry sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installation Help
Make sure you issued the correct GRANT statements at the sql, query. mysqluse mysql; Database Changed mysql GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword'; #note that will give FULL access...see the docs to restrict this. mysql FLUSH PRIVILEGES; 0 Rows Affected. ~Kelly W. Black -Original Message- From: Phil Iovino [mailto:phil;nxtek.net] Sent: Tuesday, November 12, 2002 8:14 AM To: 'Scott Pippin' Cc: [EMAIL PROTECTED] Subject: RE: Installation Help I believe root has all permissions. I'm using Webmin to verify it. I started it with -u root but still got the same error. Since I installed with the RPM didn't it give root permission? -Original Message- From: Scott Pippin [mailto:spippin;mtctrains.com] Sent: Tuesday, November 12, 2002 10:43 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Installation Help Scott Pippin [EMAIL PROTECTED] Phil Iovino [EMAIL PROTECTED] 11/12/02 08:13AM I'm trying to install MySQL under RedHat 8. I installed the MySQL 3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs. Per the instructions at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.ht m l#Post-installation, I started the server with /usr/bin/safe_mysqld and it appears to have started. When I try to test it, I get this: [root@web01 bin]# mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I'm kinda stuck. Any ideas? Did you set up root as a user? If you did, try /usr/bin/safe_mysqld -u root If not set up a user. http://www.mysql.com/doc/en/Adding_users.html hope this helps. (sql, mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Problem compiling mysqlgui 1.7.5
See the file INSTALL_BINARY ~KB -Original Message- From: Pierre [mailto:pierre;epinetworx.com] Sent: Tuesday, November 12, 2002 1:45 AM To: [EMAIL PROTECTED] Subject: Problem compiling mysqlgui 1.7.5 Hi, I try to compile mysqlgui-src-1.7.5 on my GNU/Linux system with gcc-3.2 but with the make I got this : # gmake gmake: *** No rule to make target `edfile.o', needed by `mysqlgui'. Stop. It would be great if you could help me with this ! Best regards, Pierre. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Insert many records
Hi, How can I insert many records (for instance: 1.000.000) without to do this by application? Are there a loop sintax like PL/SQL? Regards sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: why is this slow?
Hi. On Tue 2002-11-12 at 10:24:34 +0800, [EMAIL PROTECTED] wrote: At 04:47 PM 11/11/2002 +0800, Thomas Seifert wrote: Are you using MySQL-3.23.x? AFAIK it doesn't use a key for ORDER BY (MySQL-4.x does). Maybe thats the cause? Yes. Im using 3.23.52(nt). I just upgraded it from 3.23.27. You mean, if I have ORDER BY as part of the query statement, MySQL doesnot use index/keys? That is not completely correct. MySQL does use indexes with ORDER BY, just not in all cases. One of these cases is ORDER BY ... DESC. That is only optimized from the 4.0 version on. You have a further obstacle, namely asking for almost all values, which normally uses no indexes. Use of indexes makes sense in your case, because you limit the result to 20 rows. I have no 4.0 version here for testing. The 3.23.x version does the right thing for the ascending case: SELECT * FROM eventlog WHERE id number ORDER BY id limit 20 So there is reason to believe that 4.0 does the right thing for the descending case. Does this mean, that there is absolutely no way to improve my query? I had a similar case in which I was able to rewrite the query to ORDER BY (ASC) and did the sorting on application site. Don't know if that is possible in your case. I read lots of good stuffs with MySQL 4.x; is this already safe to use? You have to judge for yourself. MySQL 4.0 is declared beta since end of August. From what I read on this list, it is considered quite safe when you use old features (i.e. those which existed in 3.23.x already). If you use features new in 4.0 you should do reasonable testing before using them on a production machine. Regards, Benjamin. [...] Whenever I try to perform: SELECT * FROM eventlog where id number ORDER BY id DESC limit 20; The result is very slow, taking 5~10 seconds WHEN number is almost at the very top of the list: example, if max(id) is 300, then doing the above search with number being 290, will be very slow. the performance ONLY increases when number is very low OR when select count(*) from eventlog where id number; would give a small number. Is there a way to increase the performance of my table/search? [...] -- [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: Newbie Question - Query works in access but not MySQL
That did it. Thank you very much. - Ed Mark Armer [EMAIL PROTECTED] 11/12/02 9:12:15 AM How about if you rewrite the statement to: SELECT Products.PartNumber, Sum(tblInvTransaction.Qty) AS SumOfQty FROM Products LEFT JOIN tblInvTransaction ON Products.ProductID = tblInvTransaction.ProductID Where ((Products.PartNumberLike %A-000%) AND (Products.Obsolete-1)) GROUP BY Products.PartNumber; Mark -Original Message- From: Alan McDonald [mailto:alan;meta.com.au] Sent: Tuesday, November 12, 2002 02:05 To: Ed Reed; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Newbie Question - Query works in access but not MySQL Do you have a space between PartNumber and Like? Also there's not need to ORDER BY - the GROUP BY does that anyway (I know that's the case elsewhere) and finally, I have to guess that it's objecting to Obsolete not being in the main select.. have you tried including it and grouping by it? you can ignore the obsolete in the main select when it's returned since it will all be the same value... put it first. Alan -Original Message- From: Ed Reed [mailto:ereed;nearfield.com] Sent: Tuesday, 12 November 2002 18:54 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Newbie Question - Query works in access but not MySQL UPDATE: Still trying to solve this and I think I have something that's a little easier to understand. If I run the following query against MySQL it returns Unknown column 'Obsolete' in 'having clause'. If I run the query using MSAccess as a frontend to MySQL the query runs correctly (it returns a recordset with 9 records). If I remove the Obsolete column from the Having clause the MySQL server appears to hang up while it processes the query but it never returns even if left for an hour. Please, has anyone got any ideas? SELECT Products.PartNumber, Sum(tblInvTransaction.Qty) AS SumOfQty FROM Products LEFT JOIN tblInvTransaction ON Products.ProductID = tblInvTransaction.ProductID GROUP BY Products.PartNumber HAVING ((Products.PartNumberLike %A-000%) AND (Products.Obsolete-1)) ORDER BY Products.PartNumber; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Column aliasing
I would like to add a column in one of my tables that is an exact copy of (or alias) for another column, except that it has a different name. Why? I'm joining two tables that were previously separate and I want to use 1 main idexing column (e.g. the same numbering scheme). However a whole lot of scripts and webpages (PHP and Perl) from these previously separate tables like to use their own index column (e.g. one table previously used column name id and the other used job_num). I'm combining these to keep the numbering in sync. Ideally this would all take place within the mysql table itself (e.g. add an entry and both columns get the same autoindex number). E.g. from first table: Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | job_num | int(5) unsigned zerofill | | PRI | NULL | auto_increment | From my other table: +-+--+--+-+--++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+--++ | id | int(11) | | PRI | NULL | auto_increment | Thanks in advance. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Insert many records
You could pu tmany records in a file and use mysql -u user -p infile.sql to load in al the records in the file. Or try http://www.mysql.com/doc/en/LOAD_DATA.html -Corey Tisdale The Grill Store More --- Alexander Burbello [EMAIL PROTECTED] wrote: Hi, How can I insert many records (for instance: 1.000.000) without to do this by application? Are there a loop sintax like PL/SQL? Regards sql, query - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in using MySQLGUI 1.7.5-2
Hi, I'm Edison Xavier. I have installed the MySQL 3.23.52 on an RedHat 8.0. In the local client (running on the same machine as the server) I can connect using any registered user like this: mysql -u xavier -p This connection occours perfectly. I have installed the MySQLGUI 1.7.5-2 on my workstation running Win2000 Professional. I have setting on the Options the user xavier on the Client parameters and the IP and port of the server running the mysqld in the Server parameters. When I select the Connect button and I write my password (for xavier), the message appears on the bottom: Lost connection to MySQL server during query The log of the firewall betwen this connection show-me this deny packets: packet TCP from client to port 139 server packet TCP from client to port 445 server Is this correct?? The port 3306 is free for forwarding and don´t denied. Thanks a lot Edison Xavier [EMAIL PROTECTED] ___ Yahoo! GeoCities Tudo para criar o seu site: ferramentas fáceis de usar, espaço de sobra e acessórios. http://br.geocities.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
yo
Hola: Yo no sé como trabaja mysql, lo instalé pero necesito un manual o un tutorial en Castellano (español), que me indique como usarlo, como crear tablas,etc. muchas gracias. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
yo
Hola: Yo no sé como trabaja mysql, lo instalé pero necesito un manual o un tutorial en Castellano (español), que me indique como usarlo, como crear tablas,etc. muchas gracias. Pd. la versión que instalé es par windows. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Waiting on cond?
I was wondering if someone could tell me what Waiting on cond meant in a process state. We have a build system that is continuously running our unit test suite over new checkins. Earlier today I got an alert that steps were beginning to timeout. I looked into it and in each case it (the build step) was hanging while trying to drop our database. I did a mysqladmin process and got the following: ++--+--++-+--+-- ---+---+ | Id | User | Host | db | Command | Time | State | Info | ++--+--++-+--+-- ---+---+ | 3 | ODBC | localhost|| Query | 2397 | Waiting on cond | drop database `ebxml` | | 11 | root | ltbhuddleston.betweenmarkets.com || Query | 443 | | drop database `ebxml` | | 12 | root | 10.66.77.105 || Query | 0| | show processlist | ++--+--++-+--+-- ---+---+ This Waiting on cond is a new one on me. It will stay in this state for about an hour (at which point our build software kills everything and goes on to the next module). -Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
limited queries to one returned row
Hi all, is it possible to limit a result so that only the first record in a query can be returned for a specific user? I want to do this so that someone who does not have intimate knowledge of a large (10 records) table cannot issue commands to grab *all* of the data. Thanks ahead of time for any info! --Raj - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: yo
Hi, Maybe on IRC(UNDERNET) is possible to have chance to find MySQL tutorials in spanish. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Roberto Ramos [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 12, 2002 9:15 PM Subject: yo Hola: Yo no sé como trabaja mysql, lo instalé pero necesito un manual o un tutorial en Castellano (español), que me indique como usarlo, como crear tablas,etc. muchas gracias. Pd. la versión que instalé es par windows. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
RES: Insert many records
Try to use AccessDump. It generate multiples INSERT, one for each row. It´s so good. http://www.intranet2internet.com/public/default.asp Lucky Jacob -Mensagem original- De: Alexander Burbello [mailto:burbello;pop.com.br] Enviada em: terça-feira, 12 de novembro de 2002 16:29 Para: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Assunto: Insert many records Hi, How can I insert many records (for instance: 1.000.000) without to do this by application? Are there a loop sintax like PL/SQL? Regards sql, query - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Why does safe_mysqld runs as root?
Im curious as to why safe_mysqld runs as root? I have changed the owenership and group to mysql and my my.cnf file looks like: [mysqld] user=mysql port=3306 socket=/var/lib/mysql/mysql.sock [mysql_server] user=mysql port=3306 socket=/var/lib/mysql/mysql.sock Any thoughts are welcome. Thanks much, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Why does safe_mysqld runs as root?
On Tue, Nov 12, 2002 at 12:06:36PM -0800, David Kramer wrote: Im curious as to why safe_mysqld runs as root? I have changed the owenership and group to mysql and my my.cnf file looks like: Because you start it as root, maybe? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 98 days, processed 2,067,789,644 queries (242/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: yo
Hola Roberto, Si tu vas a http://www.free-translator.com/ y le ponse http://www.mysql.com/documentation/mysql/full/ en Systran, traducira la documentacion de MySQL a la lengua que seleciones. Entonces asi lo puedes grabar en to computadora y ya vas a tener por donde empezar. Se va a demorar un poco porque es toda la documentacion en una sola pagina. Si quiere puede ver el Ingles en partes y luego ir a free-translator y poner la direccion de solamente esa pagina. Espero que esto the ayude. JFernando ** sql *** -Original Message- From: Roberto Ramos [mailto:rramos;almagro-norte.ucentral.cl] Sent: November 12, 2002 14:16 To: [EMAIL PROTECTED] Subject: yo Hola: Yo no sé como trabaja mysql, lo instalé pero necesito un manual o un tutorial en Castellano (español), que me indique como usarlo, como crear tablas,etc. muchas gracias. Pd. la versión que instalé es par windows. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
mysqldump performance
Hi, all sql, query. Does anyone of you know the performance of mysqldump to backup tables? Thank you, Jing _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Windows cnf file location
Where is the config file for MySQL on windows? Is that where I tell it to use a log file? By default is it off? Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Why does safe_mysqld runs as root?
Thats what stumps me, I guess I am, but I have changed the ownership of all mysql files to mysql and set the user to mysql in my my.cnf file. By your comment below I guess I need to change it somewhere else? where? Thanks, DK -Original Message- From: Jeremy Zawodny [mailto:Jeremy;Zawodny.com] Sent: Tuesday, November 12, 2002 12:06 PM To: David Kramer Cc: [EMAIL PROTECTED] Subject: Re: Why does safe_mysqld runs as root? On Tue, Nov 12, 2002 at 12:06:36PM -0800, David Kramer wrote: Im curious as to why safe_mysqld runs as root? I have changed the owenership and group to mysql and my my.cnf file looks like: Because you start it as root, maybe? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 98 days, processed 2,067,789,644 queries (242/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Windows cnf file location
Hi! On Tue, 12 Nov 2002, John Chang wrote: Where is the config file for MySQL on windows? Is that where I tell it to use a log file? By default is it off? Thank you. For example, in c:\winnt\my.ini or in c:\my.cnf You can specify a custom config file location to mysqld with the --defaults-file=c:\blah.cnf parameter. You can configure mysqld to use a log file by adding a line log into my.cnf. Query logging is off by default, indeed. Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to link tables in MySQL
1 - any way to search archives of MySQL list? 2 - In MS Access you have to graphically connect the table id fields to tell Access how the tables relate. How do you do this In MySQL... from the command line I'm sure... just a code snippit or reference to one would be nice... Thanks for any help - tmb __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie to the list ...no [MYSQL] in the subject sql query not problem.???
- Original Message - From: [EMAIL PROTECTED] To: working4aliving [EMAIL PROTECTED] Sent: Tuesday, November 12, 2002 12:29 PM Subject: Re: Newbie to the list ...no [MYSQL] in the subject??? Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Is this what I have to live with? all my other lists have [TOPIC], which is cool and very easy to get used to. It helps in getting past all the junk mail. If this can't be done, I'll just put it on my list for santa. thanx. Bob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Impossible SQL ???
I can't seem to come up with a solution to the following SQL query, and have a project dependent on a solution. I'd rather not load the whole database and then parse it in the code. With the following Database structure: Field0 Integer Autonumber Field1 Integer Unique Field2 Integer not unique where the starting record would be selected by Field1 (an indexed field of unique values). The ending record required would be the first succeeding record where the value of Field2 is equal to the value of Field2 in the 'starting' record. Field2 is NOT unique and not ordered. The result would be ordered by Field0 (the autonumber field) Is this possible? MySQL Query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Granting rights to more hosts, etc
Octavian Rasnita wrote: Hi all, I've seen the following command line in a MySQL book, but it doesn't work on my computer running MySQL 3.2 on Windows 2000: grant all on database.* to user@% identified by 'password'; grant all on database.* to 'user'@'%' identified by 'password'; It tells me that there is an error in this command. How can I use a wildcard in this command? Can I give access for more users with a single command? Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [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: Insert many records
I know I can do it by application. But I would like to know if are there other way to do the same. sql, query [EMAIL PROTECTED] escreve: In a message dated 12/11/2002 18:46:08 GMT Standard Time, [EMAIL PROTECTED] writes: Hi, How can I insert many records (for instance: 1.000.000) without to do this by application? Are there a loop sintax like PL/SQL? Regards sql, query either use BatchUpdate or a transaction. Are you using ADO. ? 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
password MYSQL
I just changed the root password for MYSQL from the default and now it gives me the error Access is denied when I try to connect using phpMyadmin. It doesn't even ask for a password. How can I login in? Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Windows cnf file location
Hi, John, my.cnf is used as config file on windows. By default it is at, e.g. c:\winnt your boot system directory. It's not a log file. From: John Chang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Windows cnf file location Date: Tue, 12 Nov 2002 15:27:05 -0500 Where is the config file for MySQL on windows? Is that where I tell it to use a log file? By default is it off? Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Windows cnf file location
Where is the config file for MySQL on windows? Is that where I tell it to use a log file? By default is it off? Thank you. Under Linux, MySQL server executables and eight MySQL utulities read options from /etc/my.cnf, and under Windows they read from c:\windows\my.ini and c:\my.cnf, in that order. You can also use command line arguments to tell these programs which configuration file(s) to read, or to read no configuration file at all: --defaults-file=fileName This tells the utility to read options from fileName. --defaults-extra-file=fileName This tells the utility to read fileName after reading the global option file(s). --no-defaults This tells the utility to read no option file. They read from the [client] section of these files, and in addition from an options file section named after themselves, so for example mysqld* reads frm a [mysqld] section, mysqladmin reads from a [mysqladmin] section, if present, and so on. Program options that are settable in my.cnf/ini are commands or settings that are single words, for example check, or hyphenated word sequences, for example update-state. If the option sets a variable, the syntax is: [set-variable=]varName=value In general, server executables and utilities that can read settings and commands from option files also accept command-line arguments which are simply those same options prefixed with a double hyphen, for example --check, --update-state. In many cases the program also recognises single-character abbreviations of such commands, for example -c for --check, -U for --update-state, and -O for --set-variable=, and these abbreviations can be concatenated, for example -cU. hth PB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 link tables in MySQL
On 11/12/02 12:41 PM, tmb [EMAIL PROTECTED] wrote: 2 - In MS Access you have to graphically connect the table id fields to tell Access how the tables relate. How do you do this In MySQL... from the command line I'm sure... just a code snippit or reference to one would be nice... You join the tables using : WHERE fieldA.table1 = fieldB.table2 So check out the join syntax in the manual. /h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 link tables in MySQL
You can still use Access to build your queries then click the SQL button and you'll have the the code for the command line. Access SQL is a little different but you should still be able to get an idea on how to do it. - Ed tmb [EMAIL PROTECTED] 11/12/02 12:41:49 PM 1 - any way to search archives of MySQL list? 2 - In MS Access you have to graphically connect the table id fields to tell Access how the tables relate. How do you do this In MySQL... from the command line I'm sure... just a code snippit or reference to one would be nice... Thanks for any help - tmb __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Why does safe_mysqld runs as root?
David Kramer wrote: Thats what stumps me, I guess I am, but I have changed the ownership of all mysql files to mysql and set the user to mysql in my my.cnf file. By your comment below I guess I need to change it somewhere else? where? Where is mysql being started from? Are you familiar with your computer's boot sequence? If not, don't touch it. The my.cnf file doesn't change how your platform launches safe_mysqld. Wherever your computer runs safe_mysqld, make sure it does it as the user you want it to run as. Again, if you're unsure how to do this, consider buying someone's time (or a book) for how to do it. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump performance
Jannie Qu wrote: Does anyone of you know the performance of mysqldump to backup tables? Depends on locking, of course, but pretty similar to select * on * ... (if such were possible). -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: password MYSQL
Hi! First, try connecting from the command-line mysql client. mysql -u root -p -h ser.ver.ip.addr Then enter your password (if you don't have a root password you can dismiss -p) Also, if that works, try resetting cookies from your browser, as phpMyAdmin relies on cookie authentication. Iikka On Tue, 12 Nov 2002, John Chang wrote: I just changed the root password for MYSQL from the default and now it gives me the error Access is denied when I try to connect using phpMyadmin. It doesn't even ask for a password. How can I login in? Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: last_insert_id()
The .Neta Adapter.. does it make a persistent connection? If the connection drops between the first insert and the call to select, then the return would be zero Alan -Original Message- From: Cain O'Sullivan [mailto:cos;iinet.net.au] Sent: Wednesday, 13 November 2002 16:13 To: [EMAIL PROTECTED] Subject: last_insert_id() Hi, I am using C# with ODBC.Net to communicate with MySQL. I want to determine the last ID of an auto_increment field in the database. When I manually perform the insert using the MySQL command window I can then follow up with select last_insert_id() and I get the correct value, however, when using ODBC to perform the insert (via a .Net DataAdapter) the last_insert_id() returns 0. Can anyone provide some insight into this? Best Regards, Cain O'Sullivan [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: Impossible SQL ???
On 11/12/02 12:43 PM, Charlie [EMAIL PROTECTED] wrote: I can't seem to come up with a solution to the following SQL query, and have a project dependent on a solution. I'd rather not load the whole database and then parse it in the code. With the following Database structure: Field0 Integer Autonumber Field1 Integer Unique Field2 Integer not unique where the starting record would be selected by Field1 (an indexed field of unique values). The ending record required would be the first succeeding record where the value of Field2 is equal to the value of Field2 in the 'starting' record. Field2 is NOT unique and not ordered. The result would be ordered by Field0 (the autonumber field) Is this possible? I am not sure if I understood your mail correctly but you can try this: If you've not already done it, create an UNIQUE index for field1 and an INDEX for field2 and then try the query with a self-join on your table. SELECT foo1.* FROM yourtable foo1, yourtable foo2 WHERE foo1.field0 = foo2.field0 AND foo1.field2 = foo2.field2 AND foo1.field1 = your_starting_value ORDER BY foo1.field0 ASC /h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 link tables in MySQL
AFAIK, MySQL doesn't have any sort of referential integrity checks with fields. conceptually, you can do it, and write your program to force it, but the database itself doesn't have it. John Meyer P.S. shouldn't it be table1.fieldA -Original Message- From: R. Hannes Niedner [mailto:hannes.niedner;gmx.net] Sent: Tuesday, November 12, 2002 1:55 PM To: MySQL Mailinglist Subject: Re: How to link tables in MySQL On 11/12/02 12:41 PM, tmb [EMAIL PROTECTED] wrote: 2 - In MS Access you have to graphically connect the table id fields to tell Access how the tables relate. How do you do this In MySQL... from the command line I'm sure... just a code snippit or reference to one would be nice... You join the tables using : WHERE fieldA.table1 = fieldB.table2 So check out the join syntax in the manual. /h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: last_insert_id()
This looks like the same problem I have with MS Access. It seems MS Access uses the SELECT id FROM table_name WHERE is IS NULL, and this syntax clears the last insert ID field. My solution is here: --- One Line URL, might wrap --- http://groups.google.com/groups?hl=ensafe=offthreadm=9ehc8i%2428sa%241%40FreeBSD.csie.NCTU.edu.twrnum=5prev=/groups%3Fq%3Dodbc%2Blast_insert_id%2Baccess%26hl%3Den%26lr%3D%26safe%3Doff%26btnG%3DGoogle%2BSearch%26site%3Dgroup --- One Line URL, might wrap --- On Tuesday 12 November 2002 12:04, Alan McDonald wrote: The .Neta Adapter.. does it make a persistent connection? If the connection drops between the first insert and the call to select, then the return would be zero Alan -Original Message- From: Cain O'Sullivan [mailto:cos;iinet.net.au] Sent: Wednesday, 13 November 2002 16:13 To: [EMAIL PROTECTED] Subject: last_insert_id() Hi, I am using C# with ODBC.Net to communicate with MySQL. I want to determine the last ID of an auto_increment field in the database. When I manually perform the insert using the MySQL command window I can then follow up with select last_insert_id() and I get the correct value, however, when using ODBC to perform the insert (via a .Net DataAdapter) the last_insert_id() returns 0. Can anyone provide some insight into this? Best Regards, Cain O'Sullivan [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 -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 link tables in MySQL
FROM table1 t1 LEFT JOIN table2 t2 ON t1.field=t2.field -Original Message- From: John Meyer [mailto:johnmeyer_1978;yahoo.com] Sent: Wednesday, November 13, 2002 8:14 AM To: MySQL Mailinglist Subject: RE: How to link tables in MySQL AFAIK, MySQL doesn't have any sort of referential integrity checks with fields. conceptually, you can do it, and write your program to force it, but the database itself doesn't have it. John Meyer P.S. shouldn't it be table1.fieldA -Original Message- From: R. Hannes Niedner [mailto:hannes.niedner;gmx.net] Sent: Tuesday, November 12, 2002 1:55 PM To: MySQL Mailinglist Subject: Re: How to link tables in MySQL On 11/12/02 12:41 PM, tmb [EMAIL PROTECTED] wrote: 2 - In MS Access you have to graphically connect the table id fields to tell Access how the tables relate. How do you do this In MySQL... from the command line I'm sure... just a code snippit or reference to one would be nice... You join the tables using : WHERE fieldA.table1 = fieldB.table2 So check out the join syntax in the manual. /h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
delayed inserts and messages in the host.err log
This is just a should I be concerned question. I am getting a few messages in the mysql error log about delayed inserts and the database not being able to obtain a lock. The database is averaging about 250 queries per second. We are using delayed inserts for most every insert and the data is read about every 5 seconds or so. I am not getting that many errors considering the amount of inserts taking place (very heavy on the inserts), I think, I'm just not sure what this really means... is data being lost? I've looked at the data and it doesn't appear to be *losing* it. some specifics: -- the delayed_writes increases by about 200 every second or two. The delayed_errors increases about every 20 minutes or so. | Delayed_insert_threads | 48| | Delayed_writes | 180619| | Delayed_errors | 8 | | Not_flushed_delayed_rows | 5 | -- I recently restarted it to get a better handle on the time frame of the errors. Uptime: 5661 Threads: 61 Questions: 1502915 Slow queries: 56 Opens: 11009 Flush tables: 1 Open tables: 159 Queries per second avg: 265.486 -- From the hostname.err log after my recent restart: 021112 15:32:12 mysqld started /usr/local/mysql-3.23.51-sun-solaris2.8-sparc/bin/mysqld: ready for connections 021112 16:04:31 Delayed insert thread couldn't get requested lock for table app_nc_snmppoll 021112 16:04:45 Delayed insert thread couldn't get requested lock for table app_sems_snmppoll 021112 16:36:01 Delayed insert thread couldn't get requested lock for table unix_ds 021112 16:52:15 Delayed insert thread couldn't get requested lock for table unix_ds -- This is binary distribution of MySQL for Solaris and I have changed some values in the /etc/my.cnf per the mysql documentation. I am not extremely proficient with mysql and solaris. But, I did notice the log and was wondering if I should be concerned. Any input will be greatly appreciated. Thank you guys and gals :-) matt -- m@ Like a cloud dropping rain, I'm discarding all thought. - Eddie Vedder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: delayed inserts and messages in the host.err log
On Tue, Nov 12, 2002 at 02:18:44PM -0800, [EMAIL PROTECTED] wrote: This is just a should I be concerned question. I am getting a few messages in the mysql error log about delayed inserts and the database not being able to obtain a lock. The database is averaging about 250 queries per second. We are using delayed inserts for most every insert and the data is read about every 5 seconds or so. I am not getting that many errors considering the amount of inserts taking place (very heavy on the inserts), I think, I'm just not sure what this really means... is data being lost? I've looked at the data and it doesn't appear to be *losing* it. [snip] 021112 15:32:12 mysqld started /usr/local/mysql-3.23.51-sun-solaris2.8-sparc/bin/mysqld: ready for connections 021112 16:04:31 Delayed insert thread couldn't get requested lock for table app_nc_snmppoll That's odd. There seem to be two places in the code where MySQL generates that error. One is preceded by this comment: /* This should never happen */ And the other by this one: /* This can only happen if thread is killed by shutdown */ So I'm a bit suspicious. In one of those cases, it jumps to error handler that flushes the delayed inert queue for that table, so you'd lose data. In the other, it does not. Hmm. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 98 days, processed 2,070,154,310 queries (242/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Windows cnf file location
Is there a good or bad reason to create the config file in the MySQL folder? On production servers which logs do you turn on? Typically what things do you set on in the config file on a production server? Thank you. At 10:37 PM 11/12/2002 +0200, you wrote: Hi! On Tue, 12 Nov 2002, John Chang wrote: Where is the config file for MySQL on windows? Is that where I tell it to use a log file? By default is it off? Thank you. For example, in c:\winnt\my.ini or in c:\my.cnf You can specify a custom config file location to mysqld with the --defaults-file=c:\blah.cnf parameter. You can configure mysqld to use a log file by adding a line log into my.cnf. Query logging is off by default, indeed. Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Windows cnf file location
At 20:51 + 11/12/02, Jannie Qu wrote: Hi, John, my.cnf is used as config file on windows. By default it is at, e.g. c:\winnt your boot system directory. Not quite. In the Windows system directory, the filename is my.ini. In C:\, the filename is my.cnf. In the MySQL data directory, the filename is my.cnf. That is also the order in which MySQL programs look for option (config) files. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Why does safe_mysqld runs as root?
By boot sequence Im guessing you mean my different run levels? rcX.d? Im guessing that I need to set the user value within the start-up script it self rather than my.cnf??? I thought my.cnf was the config file that the start-up scripts reference, by me setting a the attribute user=mysql under [mysqld], mysql should start under the user mysql? Thanks much, DK -Original Message- From: Michael T. Babcock [mailto:mbabcock;fibrespeed.net] Sent: Tuesday, November 12, 2002 12:58 PM To: David Kramer Cc: '[EMAIL PROTECTED]' Subject: Re: Why does safe_mysqld runs as root? David Kramer wrote: Thats what stumps me, I guess I am, but I have changed the ownership of all mysql files to mysql and set the user to mysql in my my.cnf file. By your comment below I guess I need to change it somewhere else? where? Where is mysql being started from? Are you familiar with your computer's boot sequence? If not, don't touch it. The my.cnf file doesn't change how your platform launches safe_mysqld. Wherever your computer runs safe_mysqld, make sure it does it as the user you want it to run as. Again, if you're unsure how to do this, consider buying someone's time (or a book) for how to do it. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: delayed inserts and messages in the host.err log
Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space, If it persists, use vmstat 1 ~Kelly W Black -Original Message- From: Jeremy Zawodny [mailto:Jeremy;Zawodny.com] Sent: Tuesday, November 12, 2002 2:31 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: delayed inserts and messages in the host.err log On Tue, Nov 12, 2002 at 02:18:44PM -0800, [EMAIL PROTECTED] wrote: This is just a should I be concerned question. I am getting a few messages in the mysql error log about delayed inserts and the database not being able to obtain a lock. The database is averaging about 250 queries per second. We are using delayed inserts for most every insert and the data is read about every 5 seconds or so. I am not getting that many errors considering the amount of inserts taking place (very heavy on the inserts), I think, I'm just not sure what this really means... is data being lost? I've looked at the data and it doesn't appear to be *losing* it. [snip] 021112 15:32:12 mysqld started /usr/local/mysql-3.23.51-sun-solaris2.8-sparc/bin/mysqld: ready for connections 021112 16:04:31 Delayed insert thread couldn't get requested lock for table app_nc_snmppoll That's odd. There seem to be two places in the code where MySQL generates that error. One is preceded by this comment: /* This should never happen */ And the other by this one: /* This can only happen if thread is killed by shutdown */ So I'm a bit suspicious. In one of those cases, it jumps to error handler that flushes the delayed inert queue for that table, so you'd lose data. In the other, it does not. Hmm. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 98 days, processed 2,070,154,310 queries (242/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Impossible SQL ???
Hi. On Tue 2002-11-12 at 13:43:09 -0700, [EMAIL PROTECTED] wrote: I can't seem to come up with a solution to the following SQL query, and have a project dependent on a solution. I'd rather not load the whole database and then parse it in the code. With the following Database structure: Field0 Integer Autonumber Field1 Integer Unique Field2 Integer not unique where the starting record would be selected by Field1 (an indexed field of unique values). The ending record required would be the first succeeding record where the value of Field2 is equal to the value of Field2 in the 'starting' record. succeeding record implies an order. SQL tables have not implicit order. Do you mean when ordered by Field0? Field2 is NOT unique and not ordered. The result would be ordered by Field0 (the autonumber field) Presuming you mean next when ordered by Field0, I see no easy way to do it in one query. But you can do SELECT Field0, Field2 FROM yourtable WHEREField1 == somefoo Remember Field0 as startf0 and Field2 as startf2. SELECT Field0 FROM yourtable WHEREField0 startf0 AND Field2 == startf2 ORDER BY Field0 LIMIT1 Remember Field0 as stopf0. SELECT * FROM yourtable WHEREField0 BETWEEN startf0 AND endf0 ORDER BY Field0 (Where startf0 does not mean that you shall write it as string. I just wanted to differenciate it from column names.) The reason it is not possible to write that as one query (in MySQL) is due to the ORDER BY ... LIMIT 1 trick. You could omit the first query, by using a self-join on each of the following two, but speed-wise, that is probably not an improvement. HTH, Benjamin. -- [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: Why does safe_mysqld runs as root?
At 12:36 -0800 11/12/02, David Kramer wrote: Thats what stumps me, I guess I am, but I have changed the ownership of all mysql files to mysql and set the user to mysql in my my.cnf file. By your In *your* my.cnf file? Which file is that? /etc/my.cnf or something else? You may be placing the user line in a file that the server isn't reading. comment below I guess I need to change it somewhere else? where? Thanks, DK -Original Message- From: Jeremy Zawodny [mailto:Jeremy;Zawodny.com] Sent: Tuesday, November 12, 2002 12:06 PM To: David Kramer Cc: [EMAIL PROTECTED] Subject: Re: Why does safe_mysqld runs as root? On Tue, Nov 12, 2002 at 12:06:36PM -0800, David Kramer wrote: Im curious as to why safe_mysqld runs as root? I have changed the owenership and group to mysql and my my.cnf file looks like: Because you start it as root, maybe? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 98 days, processed 2,067,789,644 queries (242/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why does safe_mysqld runs as root?
David Kramer wrote: By boot sequence Im guessing you mean my different run levels? rcX.d? Im guessing that I need to set the user value within the start-up script it self rather than my.cnf??? I thought my.cnf was the config file that the start-up scripts reference, by me setting a the attribute user=mysql under [mysqld], mysql should start under the user mysql? I'm going to say this again: - The user that mysqld runs as is configured in my.cnf as per the online documentation at http://www.mysql.com/doc/en (great stuff; read it lots). - The user that launches safe_mysqld is just that; the user that launches safe_mysqld. Most boot scripts run as root, making root the user that launches safe_mysqld; don't try to make it more complicated than it is. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to link tables in MySQL
John Meyer wrote: AFAIK, MySQL doesn't have any sort of referential integrity checks with fields. conceptually, you can do it, and write your program to force it, but the database itself doesn't have it. Or you can use REFERENCES with InnoDB tables; http://www.mysql.com/doc/en ... search for innodb referential integrity. ... this has nothing to do with your SELECT queries though; just inserts, updates and deletes. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Impossible SQL ???
Thanks for the reply, but it isn't quite what is needed. The problem is that I need all the records between the two occurances of identical values in field 2, with no records which occur before or after those two occurances. For example, the following table with 3 fields: 11 10 24 99 32 99 41 98 54 88 62 97 If the parameter for the second column is 4, I would need to retrieve records 2, 3, and 4. If the query needs, for simplicity, to return record 5, that could be handled by the program. Thanks for your thoughts!! Charlie I can't seem to come up with a solution to the following SQL query, and have a project dependent on a solution. I'd rather not load the whole database and then parse it in the code. With the following Database structure: Field0 Integer Autonumber Field1 Integer Unique Field2 Integer not unique where the starting record would be selected by Field1 (an indexed field of unique values). The ending record required would be the first succeeding record where the value of Field2 is equal to the value of Field2 in the 'starting' record. Field2 is NOT unique and not ordered. The result would be ordered by Field0 (the autonumber field) Is this possible? I am not sure if I understood your mail correctly but you can try this: If you've not already done it, create an UNIQUE index for field1 and an INDEX for field2 and then try the query with a self-join on your table. SELECT foo1.* FROM yourtable foo1, yourtable foo2 WHERE foo1.field0 = foo2.field0 AND foo1.field2 = foo2.field2 AND foo1.field1 = your_starting_value ORDER BY foo1.field0 ASC /h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-charlie=strategicworldwide [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: Why does safe_mysqld runs as root?
Get on out there with your bad self Michael !! :) ~KB -Original Message- From: Michael T. Babcock [mailto:mbabcock;fibrespeed.net] Sent: Tuesday, November 12, 2002 3:23 PM To: David Kramer Cc: '[EMAIL PROTECTED]' Subject: Re: Why does safe_mysqld runs as root? David Kramer wrote: By boot sequence Im guessing you mean my different run levels? rcX.d? Im guessing that I need to set the user value within the start-up script it self rather than my.cnf??? I thought my.cnf was the config file that the start-up scripts reference, by me setting a the attribute user=mysql under [mysqld], mysql should start under the user mysql? I'm going to say this again: - The user that mysqld runs as is configured in my.cnf as per the online documentation at http://www.mysql.com/doc/en (great stuff; read it lots). - The user that launches safe_mysqld is just that; the user that launches safe_mysqld. Most boot scripts run as root, making root the user that launches safe_mysqld; don't try to make it more complicated than it is. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why does safe_mysqld runs as root?
Black, Kelly W [PCS] wrote: Get on out there with your bad self Michael !! Oh yeah :-) Long day, mind you, http://www.tuxedo.org/~esr/faqs/smart-questions.html came to mind, but I refrained myself (the first time). SQL ... QUERY ... KEYWORD ... STUPID ... SPAM ... SYSTEM ... SUICIDE ... HEHEH -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Impossible SQL ???
Hello. What you wrote does not obviously fit to your previous description. On Tue 2002-11-12 at 16:25:40 -0700, [EMAIL PROTECTED] wrote: The problem is that I need all the records between the two occurances of identical values in field 2, with no records which occur before or after those two occurances. With field 2 you seem to refer to the middle column below? For example, the following table with 3 fields: If I understood the problem correctly, the following table must, with regard to the previous mail, be labeled: Field0 Field2 Field1 11 10 24 99 32 99 41 98 54 88 62 97 If the parameter for the second column is 4, I would need to retrieve records 2, 3, and 4. If the query needs, for simplicity, to return record 5, that could be handled by the program. You never mentioned before that the last column should not be contained in the result set. You can change the suggestion from my other mail by replacing BETWEEN with the appropriate comparisons operators (= and ). HTH, Benjamin. [...] With the following Database structure: Field0 Integer Autonumber Field1 Integer Unique Field2 Integer not unique where the starting record would be selected by Field1 (an indexed field of unique values). The ending record required would be the first succeeding record where the value of Field2 is equal to the value of Field2 in the 'starting' record. Field2 is NOT unique and not ordered. The result would be ordered by Field0 (the autonumber field) [...] -- [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: Where can I get innodb monitoring tools?
At 18:11 +0900 11/12/02, Chung Ha-nyung wrote: innodb manual (http://www.innodb.com/ibman.html) mentions about innodb monitoring tools, e.g. innodb_tablespace_monitor. But they don't seem to be included in mysql 4.0.4. Should I buy them or can get somewhere else, like innodb homepage? Section 9.1 of the InnoDB manual describes how to create the general InnoDB monitor, and indicates that the other monitors are created similarly. For the tablespace monitor, the statement looks like this: mysql create table innodb_tablespace_monitor (a int) type = innodb; Then monitor the error log to see the result. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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: Granting rights to more hosts, etc
At 17:46 +0200 11/12/02, Octavian Rasnita wrote: Hi all, I've seen the following command line in a MySQL book, but it doesn't work on my computer running MySQL 3.2 on Windows 2000: grant all on database.* to user@% identified by 'password'; It tells me that there is an error in this command. What error? Try placing the % character in quotes: grant all on database.* to user@'%' identified by 'password'; How can I use a wildcard in this command? Can I give access for more users with a single command? Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [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: Impossible SQL ???
Hello, It seems to me that there is a fundamental reason why this can not be accomplished with a single SQL query. The process requires that the search algorithm maintains state between rows. i.e. the decision to keep or discard rows from the table as the algorithm descends down the table is not made based on the content of the current row. rather it is made based on whether the search process has encountered the start row (with the desired field1) and has not yet encountered the end row (with the matching field2). As far as I know it is not possible for a single SQL query to maintain state between rows. hence this has to be accomplished by multiple SQL queries. one to establish the start and end row indices. and then another that would take the row indices as constants and extracts the desired portion of the table. so in fact this might be appropriately labeled as an 'impossible' SQL query! in any event, I am still new to SQL. please correct me if I'm wrong. Murad Nayal Charlie wrote: Thanks for the reply, but it isn't quite what is needed. The problem is that I need all the records between the two occurances of identical values in field 2, with no records which occur before or after those two occurances. For example, the following table with 3 fields: 11 10 24 99 32 99 41 98 54 88 62 97 If the parameter for the second column is 4, I would need to retrieve records 2, 3, and 4. If the query needs, for simplicity, to return record 5, that could be handled by the program. Thanks for your thoughts!! Charlie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installation Help
At 11:45 -0600 11/12/02, Black, Kelly W [PCS] wrote: Make sure you issued the correct GRANT statements at the sql, query. mysqluse mysql; Database Changed mysql GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword'; That's not quite right. - GRANT * is not legal, I suspect you mean GRANT ALL. - '[EMAIL PROTECTED]' is quoted incorrectly. That is equivalent to '[EMAIL PROTECTED]'@'%'. I suspect you mean 'userid'@'hostname.com'. (user and host parts should be quoted separately.) #note that will give FULL access...see the docs to restrict this. mysql FLUSH PRIVILEGES; 0 Rows Affected. ~Kelly W. Black - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Count Rows in two tables
Hello all, Does anybody have a SQL string to count the rows in two different tables and give you a total number of rows? I have been trying to find an answer for a couple of days and seems like a simple string. Thank you Rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Count Rows in two tables
You can't count the join? Alan -Original Message- From: Rick Baranowski [mailto:rickb;baranconsulting.com] Sent: Wednesday, 13 November 2002 12:10 To: [EMAIL PROTECTED] Subject: Count Rows in two tables Hello all, Does anybody have a SQL string to count the rows in two different tables and give you a total number of rows? I have been trying to find an answer for a couple of days and seems like a simple string. Thank you Rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Count Rows in two tables
On 11/12/02 5:36 PM, Alan McDonald [EMAIL PROTECTED] wrote: You can't count the join? Alan Hello all, Does anybody have a SQL string to count the rows in two different tables and give you a total number of rows? I have been trying to find an answer for a couple of days and seems like a simple string. Thank you Rick I guess he wants something like: SELECT SUM(COUNT(t1.*) , COUNT(t2.*)) FROM table1 t1, table2; Which obviously doesn't work. Maybe once we have subselects we can do it in one query: /h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Count Rows in two tables
Does it have to be in a single query. You could use a Union query and then total the results in your program. Select Count(Field1) From Table1 Union Select Count(Field1) From Table2; Rick Baranowski [EMAIL PROTECTED] 11/12/02 5:10:14 PM Hello all, Does anybody have a SQL string to count the rows in two different tables and give you a total number of rows? I have been trying to find an answer for a couple of days and seems like a simple string. Thank you Rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Count Rows in two tables
Alan McDonald wrote: You can't count the join? Alan if you count the (unqualified) join you'll end up with the product of the two table counts. Murad -Original Message- From: Rick Baranowski [mailto:rickb;baranconsulting.com] Sent: Wednesday, 13 November 2002 12:10 To: [EMAIL PROTECTED] Subject: Count Rows in two tables Hello all, Does anybody have a SQL string to count the rows in two different tables and give you a total number of rows? I have been trying to find an answer for a couple of days and seems like a simple string. Thank you Rick - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php