mysqlgui about
Dear Sirs and Madams, I have installed mysqlgui-static on my PC. Please let me know how to start it, so that I can use it. 2. Have you or anyone else developed any utility to make it easy to populate the tables? The default method is too cumbersome. If so, kindly direct me to the links etc. 3. One book on Mysql talks of a /contrib page on your website where third party utilities for mysql are listed. when I try to search it it get the message page not found. Has it been removed or moved? Pl. let me know. From whatever little I have seen of it, Mysql is superb!! Pl. keep up the good work. Best luck to all of you in all your noble endeavours. R C Kathale, Bhavnagar, India. Download NeoPlanet at http://www.neoplanet.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: tunneling mysql client connections with ssh
On Sun, Jan 20, 2002 at 12:01:29AM +0100, Henning Sprang wrote: Hy all, i am just trying to tunnel a mysql client connection via ssh. i am behind a firewall that doesn't let mysql connections through to the outer world. But i can do ssh to the host i want connect to. Tunneling http port 80 with the command ssh [EMAIL PROTECTED] -L 8:localhost:80 gives me access to the http port of the remote machine via port 8 on my local machine. so fra , so good. Then doing # ssh [EMAIL PROTECTED] -L 8:localhost:3306 and connecting to port 8 on my machine with telnet gives me something like Trying ::1... Connected to localhost. Escape character is '^]'. , 3.23.47-log$jhbjhb%kj which i suppose is a prompt from the remote mysql service Yes, that means it's working. but then trying to connect to that port with the mysql client i get: # mysql -u username -p -h my.local.hostname -P 8 Enter password: ERROR 2003: Can't connect to MySQL server on 'my.local.hostname' (111) could it be that the mysql client does some extra checks, so maybe the server sends his real hostname or ip address in binary form (thats the signs at the end of the telnet prompt?) and the client realizes that he is not connected to that machine, but to another and breaks up? can i, if this is so, disable that check? I saw some information which said that forwarding mysql connections is possible, but cannot get this to work properly. Try using localhost instead of my.local.hostname. Since you didn't use the `-g' option for SSH, I wouldn't expect what you're doing to work. See the SSH docs for why. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 17 days, processed 409,667,052 queries (273/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: Version 4 Schedule RE: Roadmap
Hello Jeremy, Thank you for keeping correspondence. Kind regards Emmanuel -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: 20 January 2002 08:22 To: Emmanuel van der Meulen Cc: [EMAIL PROTECTED] Subject: Re: Version 4 Schedule RE: Roadmap On Sat, Jan 19, 2002 at 09:51:39AM +0200, Emmanuel van der Meulen wrote: Hello all, On 19 January 2002 09:28, Jeremy Zawodny wrote; On Sat, Jan 19, 2002 at 09:22:38AM +0200, Emmanuel van der Meulen wrote: Hello all, To both above topics there have been answers, thank you, but these answers are not clear at all. That's because preicting the future is rather difficult. It's a fuzzy system, so there are few clear answers. Jeremy Then let me phrase my question differently; Version 4.1 is earmarked to have 'stored procedures'. So I'm keen to know when that version is planned for release. Some indication based on previous timings would suffice, and I understand this to be a difficult question, thus in the spirit of all of above, I would not hold such timing indication against anyone if it turns out before or later. Would MySQL consider to publish something like the following as found at Netbeans; http://www.netbeans.org/articles/roadmap.html and even though their roadmap is not specific, some indication of timing is derive-able? Hey, that's pretty cool. There's a more low-tech version for MySQL here, I guess: http://www.mysql.com/doc/T/O/TODO.html It's the same idea. If MySQL policy is to refrain from getting into timing questimates, it is 100% understandable and acceptable, then please merely state it as such. Well, I can say that they've given dates in the past, but Murpy's Law tends to get in the way. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 17 days, processed 406,765,826 queries (272/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
Fw: Porting from MS SQL to MySQL
- Original Message - From: Richard Burgmann [EMAIL PROTECTED] To: Markus Lervik [EMAIL PROTECTED] Sent: Sunday, January 20, 2002 9:53 PM Subject: Re: Porting from MS SQL to MySQL Hi Markus, I'm an IT Consultant by trade and have been involved in lots of green fields projects and conversion projects over the years. Without knowing the details of your situation I will risk giving an opinion. 1. If the company has a developed/deployed product DESIGNED to run on MS SQL you can pretty much guarantee they are using every proprietary 'feature' of it and the actual industry standard SQL code is in the minority. 2. Given (1), It will be a major effort to undertake a conversion. This is the whole point of adding extra 'features' to data base servers, and every vendor does it. 3. Given (12), I think 18K euros wouldn't even cover the scoping and design phases. So why quote a low ball figure? In my experience I have found this is often done to get the work in the first place. Once you have committed to their product, you will find that the price of conversion just keeps going up until you eventually capitulate and accept their product as is. Alternatively they naively believe they can do the work and go broke trying to do the conversion on a fixed price contract (I have actually seen one software development company go broke this way). - Kind Regards Richard Burgmann Consultant E-Mail: [EMAIL PROTECTED] - Original Message - From: Markus Lervik [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 19, 2002 12:16 AM Subject: Porting from MS SQL to MySQL Hello all! We've requested a database from different companies, and specifically said we wanted MySQL or PostgreSQL because of the open source angle and we're a library. One company offered MS SQL as the platform and said that they can later on port it to MySQL. For this they wanted 18 000 euro. Now, what I want to know is, how easy is it to port a (fairly complicated) database from MS SQL to MySQL? It can't be work worth 18 000 euro, now can it? Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Understanding throughput with JDBC
Hello Mark, Thank you for the note and feedback. BTW, it was not over a network. Both on local PC. So all the time went into building the resultset in memory. I'm surprised at the time that takes. Further to why I'm desirous to do this query, twofold. One I get the record count (rows in the table); since realised there are other ways to get he number of rows. For the second requirement I cannot see an alternative. Not on this table, but on another where I keep a timestamp, I'd like to get the 50 most recent inserts. So what I do is; (SELECT * FROM MEMBERSHIPSTRACKING ORDER BY ACTIVITYTIMESTAMP DESC) thus get all the rows, ordered desc on timestamp and then I have the most recent 50 inserts. If anyone could assist me with this, I'd use other means, rather than retrieving the full resultset. Kind regards Emmanuel -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: 19 January 2002 16:25 To: Emmanuel van der Meulen Cc: [EMAIL PROTECTED] Subject: Re: Understanding throughput with JDBC - Original Message - From: Emmanuel van der Meulen [EMAIL PROTECTED] To: MySQL Java List [EMAIL PROTECTED]; MySQL General List [EMAIL PROTECTED] Sent: Saturday, January 19, 2002 7:43 AM Subject: Understanding throughput with JDBC Hello all, Could anyone please assist me to understand this. I want to understand where the time is going to and whether there is something I can do about it, with the following query when using JDBC; Here is the table declaration; CREATE TABLE Memberships (EMAIL CHAR(60) NOT NULL, NAME CHAR(50) NOT NULL, MIDDLEINITIAL CHAR(1) NULL, SURNAME CHAR(50) NOT NULL, NEWSLETTER CHAR(1) NOT NULL, USERNAME CHAR(15) NOT NULL, PASSWORD CHAR(15) NOT NULL, COUNTRY CHAR(50) NOT NULL, PRIMARY KEY (EMAIL)) TYPE=InnoDB MySQL table memberships has 110080 rows. Here is the select statement I use with JDBC; SELECT * FROM memberships ORDER BY EMAIL Same select statement I use from the MySQL 'commandline'; mysql select * into outfile 'mysql20.txt' from memberships order by email limit 20; My observations; A. When running the SQL from the MySQL 'commandline' with above statement this is the response; mysql select * into outfile 'mysql20.txt' from memberships order by email l imit 20; Query OK, 110080 rows affected (1.27 sec) B. When running the exact same select as stated above in a java program using JDBC, from when issuing, ResultSet rs = stmt.executeQuery(query) until the java program gets control back, to create the resultset, takes 23-25 seconds; I ran program several times. Please advise whether this is to be expected, or whether I could alter anything to get comparable results via JDBC as with MySQL 'commandline'? No network traffic in the first case, always network traffic in the second. No memory allocation in the first case, needing to allocate space for the entire result set in the second (the MySQL protocol doesn't mesh really well with the JDBC spec's requirements at this point in time, so the JDBC driver is required to read the entire result set in to memory to allow things like thread safety and multiple concurrent queries without being overly complex). With JDBC, it is usually not a good idea (with any driver) to select a whole slew of rows, because you won't get the performance you desire. In most cases it isn't necessary, and isn't the most efficient way of doing things either. When developing client server applications, you should use the database for what it's good for, manipulating, aggregating and transforming large amounts of data, and then look at the results (which will hopefully be smaller). Only in very special cases do you need to return large result sets (like OLAP for example). I guess it comes down to, what exactly are you trying to do selecing 110,000 rows, and do you need to return the whole result set at once...If you're just trying to dump it to a file, why are you doing that with Java when MySQL can do it directly? -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Understanding throughput with JDBC
Hello Mark, Thank you for the note and feedback. BTW, it was not over a network. Both on local PC. So all the time went into building the resultset in memory. I'm surprised at the time that takes. Further to why I'm desirous to do this query, twofold. One I get the record count (rows in the table); since realised there are other ways to get he number of rows. For the second requirement I cannot see an alternative. Not on this table, but on another where I keep a timestamp, I'd like to get the 50 most recent inserts. So what I do is; (SELECT * FROM MEMBERSHIPSTRACKING ORDER BY ACTIVITYTIMESTAMP DESC) thus get all the rows, ordered desc on timestamp and then I have the most recent 50 inserts. If anyone could assist me with this, I'd use other means, rather than retrieving the full resultset. Kind regards Emmanuel -Original Message- From: Mark Robson [mailto:[EMAIL PROTECTED]] Sent: 19 January 2002 16:49 To: MySQL Java List Subject: Re: Understanding throughput with JDBC B. When running the exact same select as stated above in a java program using JDBC, from when issuing, ResultSet rs = stmt.executeQuery(query) until the java program gets control back, to create the resultset, takes 23-25 seconds; I ran program several times. 23-25 seconds sounds like quite a reasonable time for selecting 110,000 records - remember that they need to be transferred over the network and allocated in local memory. Mark - 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: tunneling mysql client connections with ssh
Jeremy Zawodny wrote: On Sun, Jan 20, 2002 at 12:01:29AM +0100, Henning Sprang wrote: [...] so fra , so good. Then doing # ssh [EMAIL PROTECTED] -L 8:localhost:3306 and connecting to port 8 on my machine with telnet gives me something like Trying ::1... Connected to localhost. Escape character is '^]'. , 3.23.47-log$jhbjhb%kj which i suppose is a prompt from the remote mysql service Yes, that means it's working. but then trying to connect to that port with the mysql client i get: # mysql -u username -p -h my.local.hostname -P 8 Enter password: ERROR 2003: Can't connect to MySQL server on 'my.local.hostname' (111) Try using localhost instead of my.local.hostname. Since you didn't use the `-g' option for SSH, I wouldn't expect what you're doing to work. See the SSH docs for why. hmm, that won't work at all, as there is a real mysql server runnning on the same machine, using localhost or no hostname will result in the local unix socket configured with the mysql client will be used, ignoring the port number given on the command line, and only connecting me to the locally running daemon, as far as my exoerience goes. hmm, seems that is to be ethereal'ed when i have some more time to spend on this... henning - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [OT] Re: Understanding throughput with JDBC
Hello Nick, Does ROWNUM exist in MySQL? Kind reagrds Emmanuel -Original Message- From: Nick [mailto:[EMAIL PROTECTED]] Sent: 19 January 2002 20:41 To: Shankar Unni Cc: [EMAIL PROTECTED] Subject: [OT] Re: Understanding throughput with JDBC With Oracle, the *only* solution is to issue a query for the whole resultset and scroll through it - it doesn't support anything *like* the LIMIT concept, though I suppose you *could* imitate it with WHERE ROWNUM blah. With Oracle, you can retrieve a part of a result set by using inline views: SQL select d.c1,d.c2,d.c3 2 from (select c1,c2,c3,rownum c4 from foo order by c3) d 3 where d.c4 =15 and d.c4 = 19 4 / C1 C2 C3 115 30 15 116 32 16 117 34 17 118 36 18 119 38 19 Not as elegant as I would like, but it works. -- Nick Email: [EMAIL PROTECTED] - 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: Understanding throughput with JDBC
Hello Dave, Thank you. This works. Kind regards Emmanuel -Original Message- From: Adrian Monea [mailto:[EMAIL PROTECTED]] Sent: 20 January 2002 15:08 To: 'Emmanuel van der Meulen' Cc: [EMAIL PROTECTED] Subject: RE: Understanding throughput with JDBC Why not try to use SELECT * FROM MEMBERSHIPSTRACKING ORDER BY ACTIVITYTIMESTAMP DESC LIMIT 0,50 It will have the same effect, and only the 50 results you need will be built into memory. Regards, Adrian. -Original Message- From: Emmanuel van der Meulen [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 20, 2002 1:31 PM To: MySQL General List; MySQL Java List Subject: RE: Understanding throughput with JDBC Hello Mark, Thank you for the note and feedback. BTW, it was not over a network. Both on local PC. So all the time went into building the resultset in memory. I'm surprised at the time that takes. Further to why I'm desirous to do this query, twofold. One I get the record count (rows in the table); since realised there are other ways to get he number of rows. For the second requirement I cannot see an alternative. Not on this table, but on another where I keep a timestamp, I'd like to get the 50 most recent inserts. So what I do is; (SELECT * FROM MEMBERSHIPSTRACKING ORDER BY ACTIVITYTIMESTAMP DESC) thus get all the rows, ordered desc on timestamp and then I have the most recent 50 inserts. If anyone could assist me with this, I'd use other means, rather than retrieving the full resultset. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't install mysql on Solaris-2.5.1.
Dear sir, I used mysql-4.0.1 running on Solaris-2.5.1 and compile with Gcc-2.95.3. (package from www.sunfreeware.com) I used command below. CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler \ --with-charset=tis620 And then when I used command make, it has error messages below. ft_dump.o: In function `main': ft_dump.o(.text+0x26c): undefined reference to `snprintf' collect2: ld returned 1 exit status *** Error code 1 make: Fatal error: Command failed for target `ft_dump' Current working directory /misc/mysql/mysql-4.0.1-alpha/myisam *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /misc/mysql/mysql-4.0.1-alpha *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' Please let me know how to solve this problem. thank you very much. regards, Somsak. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: permission to lock tables
Jeremy Zawodny wrote: On Sun, Jan 20, 2002 at 03:46:14AM +, Arne Mueller wrote: Hi All, I've just migrated from mysql-3.12 to 4.0.1 and despite a mysqld crash a few minutes ago there is a strange problem I've never had in mysql version 3: mysql lock table .develop.Pseq read; ERROR 1064: You have an error in your SQL syntax near '.Pseq read' at line 1 Any idea what's wrong here? How about LOCK TABLES: http://www.mysql.com/doc/L/O/LOCK_TABLES.html Jeremy Hello, Sorry, I realy did read this section in the manual, but somehow the answer must be in between the lines ... I cannot find it :-( . So, please be patient with the simple users and let me know the answer if you know it. Also sorry for the above (quoted) syntax error of the command. Here comes my problem: mysql lock table develop.Pseq write; ERROR 1142: select command denied to user: 'bmm@localhost' for table 'Pseq' User 'bmm' is allowed to connect to from localhost but only has 'process' and 'reload' privileges in the ,ysql.user table, the db table then allows this user everything with the 'develop' db. Root (who has all privileges in the mysql.user table is alowed to lock tables). thanks alot, Arne -- Arne Mueller Biomolecular Modelling Laboratory Imperial Cancer Research Fund 44 Lincoln's Inn Fields London WC2A 3PX, U.K. phone : +44-(0)207 2693405 | fax :+44-(0)207-269-3534 email : [EMAIL PROTECTED] | http://www.bmm.icnet.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [OT] Re: Understanding throughput with JDBC
Rownum exists of a sort with the limit clause. Rowid does not exist all at. Tony - Original Message - From: Emmanuel van der Meulen [EMAIL PROTECTED] To: MySQL Java List [EMAIL PROTECTED]; MySQL General List [EMAIL PROTECTED]; Nick [EMAIL PROTECTED] Sent: Sunday, January 20, 2002 12:46 PM Subject: RE: [OT] Re: Understanding throughput with JDBC Hello Nick, Does ROWNUM exist in MySQL? Kind reagrds Emmanuel -Original Message- From: Nick [mailto:[EMAIL PROTECTED]] Sent: 19 January 2002 20:41 To: Shankar Unni Cc: [EMAIL PROTECTED] Subject: [OT] Re: Understanding throughput with JDBC With Oracle, the *only* solution is to issue a query for the whole resultset and scroll through it - it doesn't support anything *like* the LIMIT concept, though I suppose you *could* imitate it with WHERE ROWNUM blah. With Oracle, you can retrieve a part of a result set by using inline views: SQL select d.c1,d.c2,d.c3 2 from (select c1,c2,c3,rownum c4 from foo order by c3) d 3 where d.c4 =15 and d.c4 = 19 4 / C1 C2 C3 115 30 15 116 32 16 117 34 17 118 36 18 119 38 19 Not as elegant as I would like, but it works. -- Nick Email: [EMAIL PROTECTED] - 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
mysql-4.0.1 crash
Hi All, Mysql-4.0.1-alpha crashes when updating privileges. mysql select * from user where user = 'bmm'; ++--+--+-+-+-+-+-+---+-+---+--+---++-+++ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | ++--+--+-+-+-+-+-+---+-+---+--+---++-+++ | localhost | bmm | 006d987861784d38 | N | N | N | N | N | N | Y | N | Y| Y | N | N | N | N | | %.lif.icnet.uk | bmm | 006d987861784d38 | N | N | N | N | N | N | Y | N | Y| Y | N | N | N | N | | %.mimcluster | bmm | 006d987861784d38 | N | N | N | N | N | N | Y | N | N| N | N | N | N | N | ++--+--+-+-+-+-+-+---+-+---+--+---++-+++ 3 rows in set (0.00 sec) mysql update user set Select_priv='Y' where User = 'bmm'; Query OK, 3 rows affected (0.01 sec) Rows matched: 3 Changed: 3 Warnings: 0 mysql flush privileges; Query OK, 0 rows affected (0.00 sec) THEN FROM A CLIENT ... mueller@holly:~ mysql -u bmm -p -h acacia develop Enter password: ERROR 2013: Lost connection to MySQL server during query ... and the server crahsed. This is mys system: Linux version 2.4.9-13 ([EMAIL PROTECTED]) (gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)) I wonder whether other people have come across this problem, too. If you want I can (try) investigate the problem further, but maybe someone elese has already done this ... ;-) Arne -- Arne Mueller Biomolecular Modelling Laboratory Imperial Cancer Research Fund 44 Lincoln's Inn Fields London WC2A 3PX, U.K. phone : +44-(0)207 2693405 | fax :+44-(0)207-269-3534 email : [EMAIL PROTECTED] | http://www.bmm.icnet.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: permission to lock tables
I believe the correct command is LOCK TABLES with an 'S' at the end. your quoted command says LOCK TABLE without the 'S'. HTH At 04:15 PM 1/20/2002 +, Arne Mueller wrote: Jeremy Zawodny wrote: On Sun, Jan 20, 2002 at 03:46:14AM +, Arne Mueller wrote: Hi All, I've just migrated from mysql-3.12 to 4.0.1 and despite a mysqld crash a few minutes ago there is a strange problem I've never had in mysql version 3: mysql lock table .develop.Pseq read; ERROR 1064: You have an error in your SQL syntax near '.Pseq read' at line 1 Any idea what's wrong here? How about LOCK TABLES: http://www.mysql.com/doc/L/O/LOCK_TABLES.html Jeremy Hello, Sorry, I realy did read this section in the manual, but somehow the answer must be in between the lines ... I cannot find it :-( . So, please be patient with the simple users and let me know the answer if you know it. Also sorry for the above (quoted) syntax error of the command. Here comes my problem: mysql lock table develop.Pseq write; ERROR 1142: select command denied to user: 'bmm@localhost' for table 'Pseq' User 'bmm' is allowed to connect to from localhost but only has 'process' and 'reload' privileges in the ,ysql.user table, the db table then allows this user everything with the 'develop' db. Root (who has all privileges in the mysql.user table is alowed to lock tables). thanks alot, Arne -- Arne Mueller Biomolecular Modelling Laboratory Imperial Cancer Research Fund 44 Lincoln's Inn Fields London WC2A 3PX, U.K. phone : +44-(0)207 2693405 | fax :+44-(0)207-269-3534 email : [EMAIL PROTECTED] | http://www.bmm.icnet.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Joseph Roth ( JB ) [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Echoing Values Inside Single Quotes for an Insert (PHP)
Hi, I have a while loop pulling information into an editing form. It labels variables dynamically as so: name=schooling?php echo $counter? Where $counter is augmented each time through the loop. In order to then insert these, I need to do an insert of $schooling$counter. Below is the statement I've been trying to use, but doesn't work, it instead inserts the value of $i (another counter in a while starting at zero where $i $counter) How can I make it insert $schooling$i instead? $result = mysql_query(INSERT INTO skills (member_id, name, schooling, certifications, description) VALUES ('$member_id','$skill_name + $i','$schooling+ $i','$certifications + $i','$skill_description$i')); Thanks a bunch. - 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
'edit_member.php' script - not working as expected!
I have been reading 'MySQL' by Paul DuBois for some time now and have finally managed to de-bug (or so I thought) the script called edit_member.php on page 378 - 385. When I view the page in a browser I get the 'Member ID' 'Password' fields displayed as expected, however, nothing works even though I have the password db setup and I am typing the correct 'Member ID' 'password'. No error messages at all are displayed. Has anyone had similar problems. Is anyone able to steer me in the right direction! TIA -- Mike C - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: tunneling mysql client connections with ssh
On Sun, Jan 20, 2002 at 01:08:04PM +0100, Henning Sprang wrote: Try using localhost instead of my.local.hostname. Since you didn't use the `-g' option for SSH, I wouldn't expect what you're doing to work. See the SSH docs for why. hmm, that won't work at all, as there is a real mysql server runnning on the same machine, using localhost or no hostname will result in the local unix socket configured with the mysql client will be used, ignoring the port number given on the command line, and only connecting me to the locally running daemon, as far as my exoerience goes. Okay, how about using 127.0.0.1 then? Or inventing an alias which points to 127.0.0.1 and using it? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 17 days, processed 416,224,689 queries (269/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
how to create a table with column name 'key'?
I hope you can answer the following question. I am wondering how to create a table with a column named key. I have RTFMed and that didn't help. I'm using 3.23.47-max-debug. The following fails (after selecting a database): mysql create table test (key varchar(255), value varchar(255)); With the following error: ERROR 1064: You have an error in your SQL syntax near 'varchar(255), value varch ar(255))' at line 1 Any suggestions? Many thanks, Dominique __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 create a table with column name 'key'?
Dominique, On Sun, Jan 20, 2002 at 12:18:45PM -0800, Dominique Plante wrote: The following fails (after selecting a database): mysql create table test (key varchar(255), value varchar(255)); You should be able to do this by using back-quotes around the column name: create table test (`key` varchar(255), value varchar(255)); You might want to reconsider using reserved names like this because you will need to use the back-quotes in all your queries. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ODBC Error
I'm writing an application in VB6 (SP5/ADO 2.1) using MyODBC 2.50.39. When selecting more then 9 fields out of a specific table I get: Runtime Error -2147467259 (80004005), ODBC Driver Manager: Function Sequence Error. Can someone give me a clue or a direction where to look for. Thanks in advance. -=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=* Frans Streur - 's-Hertogenbosch - The Netherlands 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
ODBC Error
Soory the last message wasn't explicit enough: I'm writing an application in VB6 (SP5/ADO 2.1) using MyODBC 2.50.39. When selecting more then 9 fields out of a specific table I get: Runtime Error -2147467259 (80004005), ODBC Driver Manager: Function Sequence Error. It happens on the .Movefirst statement. The SQL statement is ok. I tried it directly (via MySQL) Can someone give me a clue or a direction where to look for. Thanks in advance. -=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=* Frans Streur - 's-Hertogenbosch - The Netherlands 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
mysql and BSDI 4.1 seg fault
Hi! I have forwarded your questions to the MySQL public email list, so that other people can benefit from my answer. If you have any more questions about MySQL, please send them to [EMAIL PROTECTED] instead directly to a MySQL developer or MySQL user. If you want to have guaranteed MySQL support, you can always order that from https://order.mysql.com. Brett == Brett Wynkoop [EMAIL PROTECTED] writes: Brett Greeting- Brett The distributed mysql binary for BSD/OS wants libz.so when BSDI 4.1 only Brett has libz.a! To get around this problem I have tried to build it myself, but it always Brett segfaults on startup during make test . Any ideas or pointers would be appreciated. As we don't have access to a BSDI system anymore, we have not been able to build MySQL binaries for BSDI since 3.23.32. The easyest way to solve this problem is to download the MySQL source distribution and follow the instructions in the MySQL manual of how to compile MySQL for your platform. In most cases this should only take 30 minutes of your time to get a working MySQL server... Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Understanding throughput with JDBC
Hi! Emmanuel == Emmanuel van der Meulen [EMAIL PROTECTED] writes: Emmanuel Hello Mark, Emmanuel Thank you for the note and feedback. BTW, it was not over a network. Both Emmanuel on local PC. So all the time went into building the resultset in memory. Emmanuel I'm surprised at the time that takes. Emmanuel Further to why I'm desirous to do this query, twofold. One I get the record Emmanuel count (rows in the table); since realised there are other ways to get he Emmanuel number of rows. For the second requirement I cannot see an alternative. Emmanuel Not on this table, but on another where I keep a timestamp, I'd like to get Emmanuel the 50 most recent inserts. So what I do is; (SELECT * FROM Emmanuel MEMBERSHIPSTRACKING ORDER BY ACTIVITYTIMESTAMP DESC) thus get all the rows, Emmanuel ordered desc on timestamp and then I have the most recent 50 inserts. If Emmanuel anyone could assist me with this, I'd use other means, rather than Emmanuel retrieving the full resultset. Why can't you use 'LIMIT 50' to get the latest 50 rows ? (As Mark asked, why do you have to use LIMIT 1) You can also use SQL_CALC_FOUND_ROW option to avoid to do two queries, if you want to know how many rows the WHERE statement actually matched (see the MySQL manual for more information about this topic). Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to create a table with column name 'key'?
Perhaps you read the wrong part(s) of the manual: http://www.mysql.com/doc/R/e/Reserved_words.html On Sun, 20 Jan 2002 12:18:45 -0800 (PST), Dominique Plante wrote: I hope you can answer the following question. I am wondering how to create a table with a column named key. I have RTFMed and that didn't help. I'm using 3.23.47-max-debug. The following fails (after selecting a database): mysql create table test (key varchar(255), value varchar(255)); With the following error: ERROR 1064: You have an error in your SQL syntax near 'varchar(255), value varch ar(255))' at line 1 Any suggestions? Many thanks, Dominique __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Fulltext build 2 days and counting...
Okay, does anyone know how long this will take? 22 million records, fulltext index on a single field, first 40 chars. record length 768 chars, variable. It's been running for 2 days, processlist quotes time at around 10. Index file still growing occasionally, up to 3Gb. Should I let it continue or give up? Will this take another 2 days? another week? Anyone else with experience to get a rule of thumb? I'm using mysql 3.23.37 on a dual processor intel Redhat, 700Mhz, 1G ram. -- Steve Rapaport still at large - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Fw: Porting from MS SQL to MySQL
A couple of reasons why they might go this route is, one they might already have something similar to your needs based on mssql that they can customize quick and easy for a fast delivery ( hows their time table their bid in comparison ). Or two they just don't have the mysql expertise in which case I wouldn't trust a port to them anyway. It isn't uncommon to offer a different way of doing things in a proposal just to catch the eye of the client. Not that I would personally do anything like that myself. From: Markus Lervik [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 19, 2002 12:16 AM Subject: Porting from MS SQL to MySQL Hello all! We've requested a database from different companies, and specifically said we wanted MySQL or PostgreSQL because of the open source angle and we're a library. One company offered MS SQL as the platform and said that they can later 0n port it to MySQL. For this they wanted 18 000 euro. Now, what I want to know is, how easy is it to port a (fairly complicated) database from MS SQL to MySQL? It can't be work worth 18 000 euro, now can it? Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Disclaimer: Its early and I haven't had my coffee yet. Joseph Roth ( JB ) [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How do you limit the maximun database size for a group of users?
Pretty much as the subject states, I am not a member of this list yet, as I am sure my mail server cant handle the amont of messeges that come through so please reply directly at [EMAIL PROTECTED] I need to limit the max size of a database in MySql that is created for a user on a few levels... Unlimited 50megs 20megs 10megs 5megs 2megs how can I setup groups and/or what command can I insert when my program creates a new DB that will limit the DB size? _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question regarding tables sql, foriegn keys
So far I have successful set up tables in mysql InnoDB with primary and foriegn keys. Unfortunately I am having some difficulty in getting the proper results as I am new to sql and databases. I would be most grateful if someone took a minute and explained or helped with the following : Assume three tables were created in mysql innodb with the following: Table A:one to many:type will have many reg(Table C) type primary key not null, type_id auto_increment not null Table B:one to many:pn datep will have many reg(Table C) pnprimary key, datep ** note for every pn their is a corresponding datep ** pn_idauto increment Table C: cite , reg blob not null primary key, type_idrefernces Table A foreign key, pn_idreferences Table B (pn) foriegn key, pn_idreferences Table B(datep) forieng key, ** Note that the syntax is not proper, but this is a theory type question ** My problem is how to get a query result with the following columns from above tables : type (table A)cite (Table C)reg (Table C)pn (Table B)datep (Table B) Do you only query Table C or do you structure the query to get info from all three tables? Thankyou for your time and consideration of this problem senario ! = Regards, Investorclb __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ = Regards, Investorclb __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql and BSDI 4.1 seg fault
Hi! I have forwarded your questions to the MySQL public email list, so that other people can benefit from my answer. If you have any more questions about MySQL, please send them to [EMAIL PROTECTED] instead directly to a MySQL developer or MySQL user. If you want to have guaranteed MySQL support, you can always order that from https://order.mysql.com. Brett == Brett Wynkoop [EMAIL PROTECTED] writes: Brett Greeting- Brett The distributed mysql binary for BSD/OS wants libz.so when BSDI 4.1 only Brett has libz.a! To get around this problem I have tried to build it myself, but it always Brett segfaults on startup during make test . Any ideas or pointers would be appreciated. As we don't have access to a BSDI system anymore, we have not been able to build MySQL binaries for BSDI since 3.23.32. The easyest way to solve this problem is to download the MySQL source distribution and follow the instructions in the MySQL manual of how to compile MySQL for your platform. In most cases this should only take 30 minutes of your time to get a working MySQL server... Regards, Monty -- Been there, done that..Which is why I asked if you had a clue as to why it was seg faulting on startup. -Brett -- A computer needs Microsoft like a fish needs a bicycle! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Theory question regarding tables sql, foriegn keys
So far I have successful set up tables in mysql InnoDB with primary and foriegn keys. Unfortunately I am having some difficulty in getting the proper results as I am new to sql and databases. I would be most grateful if someone took a minute and explained or helped with the following : Assume three tables were created in mysql innodb with the following: Table A:one to many:type will have many reg(Table C) type primary key not null, type_id auto_increment not null Table B:one to many:pn datep will have many reg(Table C) pnprimary key, datep ** note for every pn their is a corresponding datep ** pn_idauto increment Table C: cite , reg blob not null primary key, type_idrefernces Table A foreign key, pn_idreferences Table B (pn) foriegn key, pn_idreferences Table B(datep) forieng key, ** Note that the syntax is not proper, but this is a theory type question ** My problem is how to get a query result with the following columns from above tables : type (table A)cite (Table C)reg (Table C)pn (Table B)datep (Table B) Do you only query Table C or do you structure the query to get info from all three tables? Thankyou for your time and consideration of this problem senario ! = Regards, Investorclb __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 system requirements
All, I have searched the online manual in vain for mySQL system requirements. Can anyone give me the precise URL? Is there one? I want to play around with converting an existing FoxPro data base (about 65mb in all tables, 55mb in the largest table) to mySQL. And learning PHP from square 1, and learning more about Linux, where I know only a little. The machine that is available without additional cost is a dual Pentium classic 166 with 128mb memory, 1.2G hard drive. Memory slots are fully stuffed. I could add another hard drive that's on the shelf. Will that setup be adequate for a single-user learning experience, or will I need to start with a new machine? TIA. --Erv - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 system requirements
that's no problem! -- Zu Zhihui [EMAIL PROTECTED] - Original Message - From: Erv Young [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 21, 2002 11:56 AM Subject: MySQL system requirements All, I have searched the online manual in vain for mySQL system requirements. Can anyone give me the precise URL? Is there one? I want to play around with converting an existing FoxPro data base (about 65mb in all tables, 55mb in the largest table) to mySQL. And learning PHP from square 1, and learning more about Linux, where I know only a little. The machine that is available without additional cost is a dual Pentium classic 166 with 128mb memory, 1.2G hard drive. Memory slots are fully stuffed. I could add another hard drive that's on the shelf. Will that setup be adequate for a single-user learning experience, or will I need to start with a new machine? TIA. --Erv - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 system requirements
The machine that is available without additional cost is a dual Pentium classic 166 with 128mb memory, 1.2G hard drive. For a single user system for learning this will be MORE than enough. More disk space is nice to install more optional packags in addition to the MySQL-- that way you will have a lot of other cool Linux tools to learn and play with, but you can easily get going with this. c -- Chris Lott http://www.chrislott.org/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Understanding throughput with JDBC
Hello Monty, Thank you for your note and feedback. After getting excellent assistance, I'm using JDBC setMaxRows rather than LIMIT, which gives me portability. I'll investigate SQL_CALC_FOUND_ROW option further. I notice I would need to first upgrade to MySQL 4.x, though and then find / work out how to use it with JDBC. It would be great to do only one query, which means the processing would be reduced from approx. 25 to 4 seconds. I'd say, that is a great reduction. Kind regards Emmanuel -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: 21 January 2002 00:44 To: Emmanuel van der Meulen Cc: MySQL General List; MySQL Java List Subject: RE: Understanding throughput with JDBC Hi! Emmanuel == Emmanuel van der Meulen [EMAIL PROTECTED] writes: Emmanuel Hello Mark, Emmanuel Thank you for the note and feedback. BTW, it was not over a network. Both Emmanuel on local PC. So all the time went into building the resultset in memory. Emmanuel I'm surprised at the time that takes. Emmanuel Further to why I'm desirous to do this query, twofold. One I get the record Emmanuel count (rows in the table); since realised there are other ways to get he Emmanuel number of rows. For the second requirement I cannot see an alternative. Emmanuel Not on this table, but on another where I keep a timestamp, I'd like to get Emmanuel the 50 most recent inserts. So what I do is; (SELECT * FROM Emmanuel MEMBERSHIPSTRACKING ORDER BY ACTIVITYTIMESTAMP DESC) thus get all the rows, Emmanuel ordered desc on timestamp and then I have the most recent 50 inserts. If Emmanuel anyone could assist me with this, I'd use other means, rather than Emmanuel retrieving the full resultset. Why can't you use 'LIMIT 50' to get the latest 50 rows ? (As Mark asked, why do you have to use LIMIT 1) You can also use SQL_CALC_FOUND_ROW option to avoid to do two queries, if you want to know how many rows the WHERE statement actually matched (see the MySQL manual for more information about this topic). Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why does DISTINCT take so long time ??
Hi, Surely, the having clause is not redundant ( I misread it as 0). Is it not the compound index (on mot,date,numresponse) which would make the query fast instead of three single column indexes? Thanks, Anvar. At 01:40 PM 19/01/2002 -0500, you wrote: Anvar had some very good explanations about the time it takes to run the queries. ##Here are some work arounds: ##If you need to have these columns (mot, date, numresponse) in the group by clause, ##try putting an index on each of them to speed it up. mysqlalter table searchhardwarefr3 add index idx_mot(mot); ##... etc. ##this should speed up the 1st query for sure. ##if the second query is still slow, (i'm not sure about the exact details of mysql, so this might or might not make a difference) ## put the results from your first query into a temporary table (mytemp): mysqlcreate temporary table mytemp SELECT COUNT(*) as count, numreponse FROM searchhardwarefr3 GROUP BY mot,date,numreponse HAVING count1 LIMIT 100; ## then explicitly index both columns mysql alter table mytemp add index idx_count(count); mysql alter table mytemp add index idx_numresponse(numresponse) ##and then run the following query mysqlselect distinct count, numresponse from temp (mytemp) ##by the way, I don't think the HAVING clause is redundant. Good Luck. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
overhead problem
hello! i'm with problem when i delete something from mysql, the table overhead a few bytes i'm running a sql query from a php page: if($DEl $cid $sid $did) { $d0-query(SELECT id FROM crd_favorites WHERE did='$did' AND uid='$uid'); if($d0-num_rows()1) { $favMessage=Cartao #$did nao estao no seu favoritos.; } else { $d0-query(DELETE FROM crd_favorites WHERE uid='$uid' AND did='$did'); $favMessage=Cartao #$did deletado do seu favoritos.; } } my table structure: CREATE TABLE crd_favorites ( id int(11) NOT NULL auto_increment, uid int(11) NOT NULL default '0', cid int(11) NOT NULL default '0', sid int(11) NOT NULL default '0', did int(11) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM COMMENT='[Cartoes] Relacionamento entre cat, sub e dat'; and mysql my function query in mysql class: function query($query=) { $action = @mysql_query($query, $this-DBCONN); if(!$action) { $this-error(query;#01;[$query]); return 0; } $this-DBQRID=$action; return 1; } my mysqld: [root@dev ton]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2165 to server version: 3.23.47-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql status -- mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686) Connection id: 2165 Current database: Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.47-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/var/lib/mysql/mysql.sock Uptime: 36 min 0 sec Threads: 1 Questions: 13068 Slow queries: 0 Opens: 27 Flush tables: 1 Open tables: 19 Queries per second avg: 6.050 -- mysql if hope someone can help me because i'm with serius problem with delete and updates queries this commands are overheading my tables... ;( thanks.. Everton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Fulltext build 2 days and counting...
My experience (atleast with the 3.23 series) is that full text indexing is not worth the hassle if you have an existing HUGE database... I let mysql run for about a day or two on a 20gb database (dont remember exactly how many rows it had) before giving up (note this was using 3.23.39). I found on such a large dataset the full text indexing didnt do very well (queries took 15-20 seconds on a pIII 700mghz 512megs of ram dedicated to mysql). Anyhow... good luck, hope things turn out better for you than they did for me. ryan - Original Message - From: Steve Rapaport [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Sunday, January 20, 2002 5:25 PM Subject: Fulltext build 2 days and counting... Okay, does anyone know how long this will take? 22 million records, fulltext index on a single field, first 40 chars. record length 768 chars, variable. It's been running for 2 days, processlist quotes time at around 10. Index file still growing occasionally, up to 3Gb. Should I let it continue or give up? Will this take another 2 days? another week? Anyone else with experience to get a rule of thumb? I'm using mysql 3.23.37 on a dual processor intel Redhat, 700Mhz, 1G ram. -- Steve Rapaport still at large - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Porting from MS SQL to MySQL
On Friday 18 January 2002 17:30, you wrote: We've requested a database from different companies, and specifically said we wanted MySQL or PostgreSQL because of the open source angle and we're a library. One company offered MS SQL as the platform and said that they can later on port it to MySQL. For this they wanted 18 000 euro. Now, what I want to know is, how easy is it to port a (fairly complicated) database from MS SQL to MySQL? It can't be work worth 18 000 euro, now can it? 2) If you want MySQL or PostgreSQL, why exactly would you want to install MSSQL, and then upgrade later? Both PostgreSQL and MySQL will run on Windows (although again, I'm not sure why you would want to do that if you have a choice). That's the point. I have no idea whatsoever as to why this company wants to FIRST do the database on MS SQL and THEN port it to MySQL. Unless they've got an ready made database that they think will fit our needs and then after a while port that to MySQL. But concidering the number of planning and workhours they put in to the offer, it really can't be true, because other companies had the same amount (or less) work hours for making it directly MySQL. Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 DISTINCT take so long time ??
Hi, In fact I have a compound index on (mot,date,numreponse,topic), so I assume (mot,date,numreponse) is also optimised if I correctly understand how indexs work ;) Anyway, I just wanted to run this query once, so it's not really my priority to make speed faster on this particular query (moreover putting a specific index on a table with more than 2M table will take a big amount of time, probably as long as my query without DISTINCT ;)) Jocelyn - Original Message - From: Anvar Hussain K.M. [EMAIL PROTECTED] To: Kalok Lo [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, January 21, 2002 5:57 AM Subject: Re: Why does DISTINCT take so long time ?? Hi, Surely, the having clause is not redundant ( I misread it as 0). Is it not the compound index (on mot,date,numresponse) which would make the query fast instead of three single column indexes? Thanks, Anvar. At 01:40 PM 19/01/2002 -0500, you wrote: Anvar had some very good explanations about the time it takes to run the queries. ##Here are some work arounds: ##If you need to have these columns (mot, date, numresponse) in the group by clause, ##try putting an index on each of them to speed it up. mysqlalter table searchhardwarefr3 add index idx_mot(mot); ##... etc. ##this should speed up the 1st query for sure. ##if the second query is still slow, (i'm not sure about the exact details of mysql, so this might or might not make a difference) ## put the results from your first query into a temporary table (mytemp): mysqlcreate temporary table mytemp SELECT COUNT(*) as count, numreponse FROM searchhardwarefr3 GROUP BY mot,date,numreponse HAVING count1 LIMIT 100; ## then explicitly index both columns mysql alter table mytemp add index idx_count(count); mysql alter table mytemp add index idx_numresponse(numresponse) ##and then run the following query mysqlselect distinct count, numresponse from temp (mytemp) ##by the way, I don't think the HAVING clause is redundant. Good Luck. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL - JAVA driver
hi 2 all! does anybody knows an good ODBC like mysql driver for an java application on an win2k proffessiona OS? thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Porting from MS SQL to MySQL
(food for ill-working-anti-spam-filters : database,sql,query,table) Just wanted to thank everyone who got involved in this (at times rather heated) discussion. You've given me quite a few pointers to think about and stuff to concider and take up with our project manager. Cheers mates! Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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/Php Help?
I really suggest you do a little homework and read the tutorials in both the php and mysql manuals. They are really valuable and should give you the examples you need. Maintainer IPPlan (https://sourceforge.net/projects/iptrack/) sql Gary Lefko wrote: Can someone writ eme an example of getting a field name form my Mysql database? I have a table with fields A, B, C I query the database then ask: if field A == 1 then print field name else do nothing. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Overwhelmed with MySQL People
Hello all, I've been with MySQL for approx. a month now and have asked assistance with several things, and; I'm overwhelmed and acknowledge MySQl and the people of the mailing lists. Thank you. Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: 3.23.40 overload
Saturday, January 19, 2002, 9:21:04 AM, Jeremy Zawodny wrote: On Fri, Jan 18, 2002 at 10:38:43AM +0200, Dmitry Alyabyev wrote: Hello Time to time I see strange overload of MySQL on dedicated server. The server is powerful enough to handle ~ 500 req/s. MySQL version is 3.23.40 and runs on Linux 2.4.16-SMP. The overload which I mean leds to stop answering to queries and looks like: 6:24pm up 6 days, 2:34, 2 users, load average: 164.18, 91.07, 39.56 270 processes: 73 sleeping, 197 running, 0 zombie, 0 stopped CPU0 states: 99.23% user, 0.15% system, 0.0% nice, 0.1% idle CPU1 states: 97.17% user, 2.21% system, 0.0% nice, 0.0% idle Mem: 513504K av, 50K used, 13504K free, 0K shrd, 22892K buff Swap: 1036184K av,7540K used, 1028644K free 305928K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 30453 mysql 14 0 19204 18M 2224 R 6.9 3.7 0:02 mysqld 30454 mysql 14 0 19204 18M 2224 R 6.9 3.7 0:02 mysqld [skip] 30460 mysql 16 0 19204 18M 2224 R 6.9 3.7 0:02 mysqld On the other hand I see Slow_launch_threads counter equal to 2 that means there were a problem with thread create (took more then 2 sec). Others thread-related counters: Can you get a SHOW FULL PROCESSLIST out of the server? Unfortunately I can't - server operates very slowly at the moment. -- Dimitry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php