RE: ensuring that I'm getting the correct last insert ID
Thanks jeff, thats a question thats been bugging me for a while. -Original Message- From: Jeff Kilbride [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 10:24 To: Sean O'Donnell; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: ensuring that I'm getting the correct last insert ID Just make sure you call the last_insert_id() function before returning the connection to the pool. If you're using the mm.mysql driver in Java, you can cast the statement object to an org.gjt.mm.mysql.Statement object and use it's getLastInsertID() method: long lastInsertID = ((org.gjt.mm.mysql.Statement)stmt).getLastInsertID(); A connection pool of this sort can't share connections between different users simultaneously. The MySQL protocol only allows one user per connection at any instant. So, as long as you grab the last insert id before returning the connection to the pool, you will be fine. --jeff - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 8:36 AM Subject: RE: ensuring that I'm getting the correct last insert ID if you are using a connection pool the [close database connection] part of your example doesnt actually close the connection. so 1. Your code might be using several connections 2. Your code might use a different connection for each statement. 3. Even if your code only does use the one connection, someone else might be sharing it. asides from that , you dont have to close your database connection to execute multiple queries in java. You may have to create multiple statement objects though(depending on the type of query) -Original Message- From: denonymous [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 08:36 To: Sean O'Donnell; [EMAIL PROTECTED] Subject: Re: ensuring that I'm getting the correct last insert ID But would the same instance of a script drop and pick up different connections? I haven't done any Java/MySQL work, but anything I've done with PHP or Perl is based on a model of: [begin script] [open database connection(s)] [execute queries] [close database connection(s)] [end script] Is it more common in Java to do something like: [begin script] [open database connection] [execute query] [close database connection] [open database connection] [execute query] [close database connection] [etc...] [end script] ? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 11:28 AM Subject: RE: ensuring that I'm getting the correct last insert ID its used a lot by java. As setting up and closing down connections to the database is relatively expensive, you use a pool manager, when the connection is closed by your code, it gets returned to the pool of open connections and is'nt actually closed. just held open and returned next time you want a connection. So I imagine if you have 20 users on the site at once, then they could all be executing various snippets of sql over 5 connections. -Original Message- From: denonymous [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 08:27 To: Sean O'Donnell; [EMAIL PROTECTED] Subject: Re: ensuring that I'm getting the correct last insert ID Admittedly, I'm no expert. What *is* connection pooling? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 11:21 AM Subject: RE: ensuring that I'm getting the correct last insert ID what happens if you are using connection pooling though? -Original Message- From: denonymous [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 08:09 To: [EMAIL PROTECTED] Subject: Re: ensuring that I'm getting the correct last insert ID From: Jonnycattt [EMAIL PROTECTED] Hi all, I know this has been asked a bunch of times, but i need some clarity (new mySQL user). I have an app that inserts a new user into one table, then inserts some user preferences into another table. the procedure is as follows: 1) insert new user 2) query for that user's id using select max(userID) as LastUserID from .. 3) insert into user preferences table using the previous query's LastUserID. To be clear, this last insert adds mutliple rows to a table, not one row. If I were you, I'd use MySQL's LAST_INSERT_ID() function: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html So long as your ID field is AUTO_INCREMENT, this will return the last auto-generated field in the current handle. Something like this: INSERT INTO UserTable... (your first user insert) SELECT LAST_INSERT_ID() FROM UserTable (this will return the userID of the user you just inserted) INSERT INTO OtherTables (pass the userID you just got to these queries) You'd mentioned worries that a user could be added while another user was
RE: ensuring that I'm getting the correct last insert ID
what happens if you are using connection pooling though? -Original Message- From: denonymous [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 08:09 To: [EMAIL PROTECTED] Subject: Re: ensuring that I'm getting the correct last insert ID From: Jonnycattt [EMAIL PROTECTED] Hi all, I know this has been asked a bunch of times, but i need some clarity (new mySQL user). I have an app that inserts a new user into one table, then inserts some user preferences into another table. the procedure is as follows: 1) insert new user 2) query for that user's id using select max(userID) as LastUserID from .. 3) insert into user preferences table using the previous query's LastUserID. To be clear, this last insert adds mutliple rows to a table, not one row. If I were you, I'd use MySQL's LAST_INSERT_ID() function: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html So long as your ID field is AUTO_INCREMENT, this will return the last auto-generated field in the current handle. Something like this: INSERT INTO UserTable... (your first user insert) SELECT LAST_INSERT_ID() FROM UserTable (this will return the userID of the user you just inserted) INSERT INTO OtherTables (pass the userID you just got to these queries) You'd mentioned worries that a user could be added while another user was still being processed, and the result would be the wrong userID being returned. LAST_INSERT_ID() is handle-based, though, so there should be no worries with that -- the sessions will be kept separate. Hope this helps! -- denonymous . : . : . AIM: denonymous http://www.coldcircuit.net ' : ' : ' http://24.91.199.33 According to one of our readers, the new MacOS X contains another Satanic holdover from the 'BSD Unix' OS mentioned above; to open up certain locked files one has to run a program much like the DOS prompt in Microsoft Windows and type in a secret code: 'chmod 666'. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ensuring that I'm getting the correct last insert ID
its used a lot by java. As setting up and closing down connections to the database is relatively expensive, you use a pool manager, when the connection is closed by your code, it gets returned to the pool of open connections and is'nt actually closed. just held open and returned next time you want a connection. So I imagine if you have 20 users on the site at once, then they could all be executing various snippets of sql over 5 connections. -Original Message- From: denonymous [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 08:27 To: Sean O'Donnell; [EMAIL PROTECTED] Subject: Re: ensuring that I'm getting the correct last insert ID Admittedly, I'm no expert. What *is* connection pooling? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 11:21 AM Subject: RE: ensuring that I'm getting the correct last insert ID what happens if you are using connection pooling though? -Original Message- From: denonymous [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 08:09 To: [EMAIL PROTECTED] Subject: Re: ensuring that I'm getting the correct last insert ID From: Jonnycattt [EMAIL PROTECTED] Hi all, I know this has been asked a bunch of times, but i need some clarity (new mySQL user). I have an app that inserts a new user into one table, then inserts some user preferences into another table. the procedure is as follows: 1) insert new user 2) query for that user's id using select max(userID) as LastUserID from .. 3) insert into user preferences table using the previous query's LastUserID. To be clear, this last insert adds mutliple rows to a table, not one row. If I were you, I'd use MySQL's LAST_INSERT_ID() function: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html So long as your ID field is AUTO_INCREMENT, this will return the last auto-generated field in the current handle. Something like this: INSERT INTO UserTable... (your first user insert) SELECT LAST_INSERT_ID() FROM UserTable (this will return the userID of the user you just inserted) INSERT INTO OtherTables (pass the userID you just got to these queries) You'd mentioned worries that a user could be added while another user was still being processed, and the result would be the wrong userID being returned. LAST_INSERT_ID() is handle-based, though, so there should be no worries with that -- the sessions will be kept separate. Hope this helps! -- denonymous . : . : . AIM: denonymous http://www.coldcircuit.net ' : ' : ' http://24.91.199.33 According to one of our readers, the new MacOS X contains another Satanic holdover from the 'BSD Unix' OS mentioned above; to open up certain locked files one has to run a program much like the DOS prompt in Microsoft Windows and type in a secret code: 'chmod 666'. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ensuring that I'm getting the correct last insert ID
if you are using a connection pool the [close database connection] part of your example doesnt actually close the connection. so 1. Your code might be using several connections 2. Your code might use a different connection for each statement. 3. Even if your code only does use the one connection, someone else might be sharing it. asides from that , you dont have to close your database connection to execute multiple queries in java. You may have to create multiple statement objects though(depending on the type of query) -Original Message- From: denonymous [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 08:36 To: Sean O'Donnell; [EMAIL PROTECTED] Subject: Re: ensuring that I'm getting the correct last insert ID But would the same instance of a script drop and pick up different connections? I haven't done any Java/MySQL work, but anything I've done with PHP or Perl is based on a model of: [begin script] [open database connection(s)] [execute queries] [close database connection(s)] [end script] Is it more common in Java to do something like: [begin script] [open database connection] [execute query] [close database connection] [open database connection] [execute query] [close database connection] [etc...] [end script] ? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 11:28 AM Subject: RE: ensuring that I'm getting the correct last insert ID its used a lot by java. As setting up and closing down connections to the database is relatively expensive, you use a pool manager, when the connection is closed by your code, it gets returned to the pool of open connections and is'nt actually closed. just held open and returned next time you want a connection. So I imagine if you have 20 users on the site at once, then they could all be executing various snippets of sql over 5 connections. -Original Message- From: denonymous [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 08:27 To: Sean O'Donnell; [EMAIL PROTECTED] Subject: Re: ensuring that I'm getting the correct last insert ID Admittedly, I'm no expert. What *is* connection pooling? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 11:21 AM Subject: RE: ensuring that I'm getting the correct last insert ID what happens if you are using connection pooling though? -Original Message- From: denonymous [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 08:09 To: [EMAIL PROTECTED] Subject: Re: ensuring that I'm getting the correct last insert ID From: Jonnycattt [EMAIL PROTECTED] Hi all, I know this has been asked a bunch of times, but i need some clarity (new mySQL user). I have an app that inserts a new user into one table, then inserts some user preferences into another table. the procedure is as follows: 1) insert new user 2) query for that user's id using select max(userID) as LastUserID from .. 3) insert into user preferences table using the previous query's LastUserID. To be clear, this last insert adds mutliple rows to a table, not one row. If I were you, I'd use MySQL's LAST_INSERT_ID() function: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html So long as your ID field is AUTO_INCREMENT, this will return the last auto-generated field in the current handle. Something like this: INSERT INTO UserTable... (your first user insert) SELECT LAST_INSERT_ID() FROM UserTable (this will return the userID of the user you just inserted) INSERT INTO OtherTables (pass the userID you just got to these queries) You'd mentioned worries that a user could be added while another user was still being processed, and the result would be the wrong userID being returned. LAST_INSERT_ID() is handle-based, though, so there should be no worries with that -- the sessions will be kept separate. Hope this helps! -- denonymous . : . : . AIM: denonymous http://www.coldcircuit.net ' : ' : ' http://24.91.199.33 According to one of our readers, the new MacOS X contains another Satanic holdover from the 'BSD Unix' OS mentioned above; to open up certain locked files one has to run a program much like the DOS prompt in Microsoft Windows and type in a secret code: 'chmod 666'. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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/
MySQL + JBoss
Has anyone out there tried using jboss with mysql? Any luck/problems? Thanks Sean - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help with asp/mysql
this is driving me mental, I'm using asp and mysql, I'm running a query and getting back these two records when running the query manually through mysqlfront , productid 5325301445 5325301446 when the page executes the query i get back a single result 1030334149 which doesnt actually exist in the database! anyone got any ideas? I know the query is being run , and its going to the right database , as I'm writing them to the page directly before the query is run and the results are written to the page. ___ Sean O'Donnell Sentia Technologies Ltd. Sentia House 104 Coolmine Business Park Dublin 15 Ireland e-mail [EMAIL PROTECTED] web http://www.sentia.ie phone + 353 1 821 9020 fax + 353 1 821 9025 mobile + 353 86 854 3389 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: help with asp/mysql
whoops, the sql is select distinct product.productid from product,productdetails where product.productid=productdetails.productid and product.recordstatus='O' and product.recordstatus='O' and productdetails.price= 1234.673264 and productdetails.price= 0 and (product.instore = 0 or product.instore = 0) limit 0, 10 I know there are some redundant sections in the sql but the statement is being generated on the fly, and i dont think that they would account for this effect. -Original Message- From: Sean O'Donnell Sent: 08 April 2002 06:36 To: [EMAIL PROTECTED] Subject: help with asp/mysql this is driving me mental, I'm using asp and mysql, I'm running a query and getting back these two records when running the query manually through mysqlfront , productid 5325301445 5325301446 when the page executes the query i get back a single result 1030334149 which doesnt actually exist in the database! anyone got any ideas? I know the query is being run , and its going to the right database , as I'm writing them to the page directly before the query is run and the results are written to the page. ___ Sean O'Donnell Sentia Technologies Ltd. Sentia House 104 Coolmine Business Park Dublin 15 Ireland e-mail [EMAIL PROTECTED] web http://www.sentia.ie phone + 353 1 821 9020 fax + 353 1 821 9025 mobile + 353 86 854 3389 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Power ?
why do you have to pay? I was under the impression innodb was free as well... -Original Message- From: Steve Rapaport [mailto:[EMAIL PROTECTED]] Sent: 05 April 2002 08:33 To: [EMAIL PROTECTED] Subject: Re: MySQL Power ? I'm currently running MySQL for a big, fast app without problems. BUT: I'm in the middle of specifying a new application with a high load, and I'm consideing looking for alternatives to MySQL because without InnoDB, it gets really slow on tables with frequent updates and reads (no row locking). We have, for example, a session table that records all the incoming requests for holding state. Since it's constantly being updated and read, it is frequently locked, and there are often instances where 50 reads will stack up while a lock is held. This slows down the whole database. With InnoDB, I'm sure this problem goes away, but as soon as we go to InnoDB, we have to pay for backups and support, which means we start looking around at 'pay' solutions. Is there something I'm missing? Steve However, my impression is that while the answer, for the very highest volumes, is that Oracle is better, the point at which Oracle betters MySQL is *much* higher than doubters might think. So, if anybody give the reply that Oracle is best at the high end, please could they also try to quantify the point at which MySQL begins to run out of steam - and what it is it can't do and Oracle can at that point. (For example, MySQL can handle high read loads by use of replication, but would bottleneck on high write loads - I think). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: InnoDB books
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 25 March 2002 07:59 To: Sean O'Donnell Subject: Re: InnoDB books 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: does anyone know of any books that give innodb good coverage? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Java to MySQL connection
there is odbc support on linux, you can find a link the the myodbc drive for mysql on mysql.com -Original Message- From: Liyju Janardhan [mailto:[EMAIL PROTECTED]] Sent: 21 March 2002 03:30 To: Chris Stewart; [EMAIL PROTECTED] Subject: Re: Java to MySQL connection which Driver your using? which Operating system your using? If your using linux, as far as I know there is now odbc support. You have to downlaod mm.mysql driver. If your are using windows you will have to create a dsn name for the your selected driver. --- Chris Stewart [EMAIL PROTECTED] wrote: I'm trying to make a connection from a java app to a MySQL database I've created on my local PC. How can I tell the app where to look for the existing database? Code I'm working with: Class.forName(sun.jdbc.odbc.JdbcOdbcDriver).newInstance(); Connection con = DriverManager.getConnection(jdbc:odbc:Testing@localhost:3306, my username , my pass ); System.out.println(Connection Made.); As you can tell from this, my database is named Testing. All I'm trying to do right now is get a connection. Right now when I run this code I get Error: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. I'm not sure I have the odbc driver setup correctly either. I downloaded mm.mysql-2.0.11 but I'm not really sure how to bring it into the mix as far as the driver goes. Thanks for any direction. Chris Stewart [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 __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards(r) http://movies.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Licensing
i was under the impression that unless the application will 'only' run under mysql (ie uses a mysql specific feature), its perfectly legitimate to use it without a licence. For Example, if your application uses odbc to communicate with the database, and standard sql to perform database queries, then it should run quite happyly on mysql, postgres, oracle or mssql. In these circumstances I dont see why your application should require a mysql licence, am i wrong about this guys? -Original Message- From: Pål Sollie [mailto:[EMAIL PROTECTED]] Sent: 14 January 2002 05:09 To: [EMAIL PROTECTED] Subject: Re: Licensing Monday, January 14, 2002, 3:11:00 PM, you wrote: Frans Englich writes: I'm writing an adminstrative program for a hotel located in Sweden. This program uses an mysql database as backend(the implementation is not in use yet, but my intention is to use mysql). To be really sure about this: Do the hotel _have_ to get an MySql database License or will they stay legal without one? I know, mySql is released under the GPL license but I need to be really sure about this. I would love to buy an license to support the Mysql team but since the license would be drawn from my payment I'm hesitating.. 200USD is alot of money here in Sweden, atleast for me. regards, Frans Englich [EMAIL PROTECTED] If you are giving your administrative program for free, you do not require a licence. Otherwise, you do ... Even if he uses an unmodified version of MySQL? -- Pål Sollie - [EMAIL PROTECTED] I had a fortune cookie the other day and it said: 'Outlook not so good'. I said: 'Sure, but Microsoft ships it anyway' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
foxpro conversion
Anybody have any tools/tips for converting a foxpro database to mysql ___ Sean O'Donnell Sentia Technologies Ltd. Sentia House 104 Coolmine Business Park Dublin 15 Ireland e-mail [EMAIL PROTECTED] web http://www.sentia.ie phone + 353 1 821 9020 fax + 353 1 821 9025 mobile + 353 86 854 3389 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
autoincrement
When you have just inserted a record into a table that autoincrements the primary key, is there a way of retrieving the id assigned at the same time? I'm using ASP to write the code in question , and I'm trying to find a better solution that looking at the max key value just before/after in code, and praying no other query was run at the same time. Thanks Sean - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
autoincrement
When you have just inserted a record into a table that autoincrements the primary key, is there a way of retrieving the id assigned at the same time? I'm using ASP to write the code in question , and I'm trying to find a better solution that looking at the max key value just before/after in code, and praying no other query was run at the same time. Does mysql have any feature to accomadate this? Thanks Sean - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: probs in accessing the database
to give a particular user access to the database, log in as root and type grant all on databasename.* to username identified by password to restrict that user to connecting from a particular host grant all on databasename.* to username@hostname identified by password the two options above give all permissions to the user (ie read,write,drop tables,create tables), to find out more about the GRANT commands syntax take a look at the online manual on www.mysql.com. hope that helps Sean -Original Message- From: Himadri Mandal [mailto:[EMAIL PROTECTED]] Sent: 23 August 2001 01:35 To: [EMAIL PROTECTED] Subject: probs in accessing the database Dear Friend, We are a group of students experimenting with MySql. We have installed MySql version 3.2 under Red Hat Linux 6.0 We can login to MySql from all the users of Linux server, However, no users has access to the database created by root except the root itself. the text of the error is : Access denied for user '@localhost' for database 'Daiz' for information---Diaz is the name of the database created by root. help is appreciated. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mySQL and ASP
I had a similar problem before, asp would not return where any bigint types where involved in the query. The fix was to check the 'convert bigint to int' box in the myodbc settings and everything came back just fine. might be worth a try Sean -Original Message- From: Mariusz Muszalski [mailto:[EMAIL PROTECTED]] Sent: 21 August 2001 02:50 To: [EMAIL PROTECTED] Subject: mySQL and ASP I've just spotted something STRANGE in mySQL... using mySQL query from ASP (connection via mySQL ODBC driver ver 2.50.37.00). MySQL query returns normally records, but returns nothing with ASP... Code (VBscript) is here: %@ LANGUAGE=VBSCRIPT % %option explicit% % Dim MyConn Dim SQL_query Dim RS Set MyConn = Server.CreateObject(ADODB.Connection) MyConn.Open(DSN=mySQL_test;Username=root) SQL_query = SELECT Number, Count(*) as Count FROM Results WHERE GameID=1 Group by Number Set RS = MyConn.Execute(SQL_query) while not RS.eof .. wend MyConn.Close % Query is pretty simple, and normally under mysql console returns three records. Table structure is below: # # Table structure for table 'results' # CREATE TABLE results ( GameID int(10) NOT NULL default '0', Number int(10) NOT NULL default '0' ) TYPE=MyISAM; # # Dumping data for table 'results' # INSERT INTO results VALUES (1,22); INSERT INTO results VALUES (1,22); INSERT INTO results VALUES (1,23); INSERT INTO results VALUES (1,24); INSERT INTO results VALUES (1,23); Question is WHY with ASP it returns NOTHING Regards, Mariusz Muszalski - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Downsides of MySQL?
whoops, right you are, but if the average reader is like me, they'll read the main article , a comment or two , and bug out. The article itself is quite definately dated -Original Message- From: Ravi Raman [mailto:[EMAIL PROTECTED]] Sent: 16 August 2001 10:08 To: Sean O'Donnell; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Downsides of MySQL? hi. scroll down a bit. the _comments_, to which i was referring, go all the way up to July 2001, which seems fairly relevant to me. and while the article is definitely dated, transaction support in mysql is still not-quite-stable, it still lacks subqueries, stored procedures, triggers and foreign key constraints, which is important to know 1) if those things are important to you, and 2) if you're comparing it to oracle. so i'll stick by my statement that the link is a page with _a lot_ of interesting comments from both sides of the commercial-RDBMS vs. mysql-postgres. -ravi. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 12:35 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Downsides of MySQL? a page with _a lot_ of interesting comments from both sides of the commercial-RDBMS vs. mysql-postgres is here: http://openacs.org/philosophy/why-not-mysql.html; This article is a year and a half old, quite a lot of its points, while valid at the time , simply are not relevant anymore. The introduction of innodb and gemini in particular make this a dead document. -Original Message- From: Ravi Raman [mailto:[EMAIL PROTECTED]] Sent: 16 August 2001 07:59 To: Boget, Chris; [EMAIL PROTECTED] Subject: RE: Downsides of MySQL? lol. how industrial strength does this website need to be? if it's anything less than an online banking/creditcard processing site, you'll probably be okay. i know go2net, xoom, and realnetworks (among other large sites) all use mysql. admittedly, they also use oracle or db2 in the mix as well, but mysql's in there. i might agree that it lacks enterprise management functionality, but that depends on what that extremely vague term means... to refute a few more points: mysql support can be purchased, with the advantage that you can influence the future development of the software by paying mysql ab...something that you'll never get from oracle. functionality-wise, mysql is missing (as a previous post this week noted) triggers, stored procedures and referential integrity constraints although row or at least page-level locking is implemented in some of the newer table types (innoDB +), as well as replication between a master and slave db. oops. wait...missed this part: The fact that it is unsupported freeware would mean that an end user would potentially be held to ransom by a DBA with specific knowledge. The mySQL security model is also not sufficiently developed for any system that involves money. i guess this is a system that involves money. while i agree that i wouldn't use mysql for _any_ app storing financial info, it's amusing that the quoted individual says mysql would invite a situation where the end user is held ransom to a DBA...if this is not the case with oracle, i don't know what is, except oracle involves huge license fees and higher-paid DBA with even more specific knowledge. that being said, and without knowing more details about the planned website, i'm leaning towards agreeing with person you quoted (personal opinion only!) one important thing to note is that it is not necessary, as many large websites have shown, to use oracle/db2/sybase _exclusively_...i have no doubt that mysql can handle at least some of the tasks necessary in a web-based system, the question of where it fits in and whether it's worth integrating is up to you guys. a page with _a lot_ of interesting comments from both sides of the commercial-RDBMS vs. mysql-postgres is here: http://openacs.org/philosophy/why-not-mysql.html hth. -ravi. -Original Message- From: Boget, Chris [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 9:36 AM To: '[EMAIL PROTECTED]' Subject: Downsides of MySQL? Good morning. Recently, we presented MySQL as a database option for a website that we might be working on. We've used it as our database in the past and we plan on using it in the future as possible. With that said, I confess I don't have as intimate a knowledge of mySQL to address some of the things in the email that was sent to me. I'd like to hear what some of you have to say/think about this. I know some of the things said below aren't entirely correct, but I'm not 100% sure about some of the others. --Begin Quote-- MySQL - as I said at our meeting, we would not be comfortable with this as an enterprise strength solution. MySQL is unsupported freeware and lacks enterprise management functionality. It has a small limited feature set compared to ORACLE, DB/2 and is lacking the functionality to support data replication and has little
RE: mysql error
as opposed to using safe_mysqld try starting mysql using /etc/init.d/rc.d/mysql start and stopping using /etc/init.d/rc.d/mysql stop I had the same problem on a cobalt raq running a variant of red hat and that solved it. Sean -Original Message- From: Adrian D'Costa [mailto:[EMAIL PROTECTED]] Sent: 17 July 2001 08:32 To: Mysql Mailing List Subject: mysql error Hi, I just installed a new version of mysql (not the latest) 3.23.36 which came with rh 7.1 cd. I know that it is buggy but I have the following problems that have been discussed in the list. I search the archives but did not see how the problem got solved. The error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I did a ps aux | grep mysqld root 924 0.0 0.0 18560 ?SW 09:55 0:00 [safe_mysqld] mysql 974 0.0 0.0 12252 24 ?S09:55 0:00 [mysqld] mysql 986 0.0 0.0 12252 24 ?S09:55 0:00 [mysqld] mysql 987 0.0 0.0 12252 24 ?S09:55 0:00 [mysqld] When I try to restart or stop using /etc/init.d/mysqld stop Stopping MySQL:[FAILED] The log shows : 010717 12:34:42 mysqld started 010717 12:34:43 Can't start server: Bind on TCP/IP port: Address already in use010717 12:34:43 Do you already have another mysqld server running on port: 3306 ? 010717 12:34:43 Aborting 010717 12:34:43 mysqld ended 010717 12:50:02 mysqld started 010717 12:50:02 Can't start server: Bind on TCP/IP port: Address already in use010717 12:50:02 Do you already have another mysqld server running on port: 3306 ? 010717 12:50:02 Aborting 010717 12:50:02 mysqld ended 010717 12:55:26 mysqld started /usr/libexec/mysqld: ready for connections I tried to change the /etc/my.cnf socket to /tmp/mysql.sock but I still get the error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) How do I solve this as I am in the middle of a web database project TIA Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MASON GUI for Windows is it good?
They give away the previous version free (i.e if they are on 1.9 you can download 1.8 and use it free) -Original Message- From: Chris Lott [mailto:[EMAIL PROTECTED]] Sent: 13 July 2001 14:30 To: '[EMAIL PROTECTED]' Cc: MySQL List (E-mail) Subject: RE: MASON GUI for Windows is it good? I have heard that mason is pretty good , I currently us DB Tools as a windows GUI for MySQL but would consider changing to Mason it its better. Try it out... there is a 15 day trial for the whole product so you can see how you like it. I just started using it a few days ago and I am positively impressed so far. 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Parallel Databases
I've been trying to think up a system to achieve this myself, but with practically no success. I'm not using mysql long (only about 6 months), and my c/C++ is a little rusty, but if you get off the ground with this and need a grunt, give me a shout. Sean -Original Message- From: Trevor Linton [mailto:[EMAIL PROTECTED]] Sent: 12 July 2001 00:00 To: [EMAIL PROTECTED] Subject: Parallel Databases I'm writing in as to how I can contribute in the development in Parallel databasing. I understand MySQL currently supports replications which is a nice way of keeping live backups of a mysql server, however is hardly the preferred method when dealing with load-balancing and redundancy, just because it becomes a burden at application level to manage your selects to load-balance and any update,insert,alter statements to the parent server. I'm interested in implementing Parallel databasing such as the feature found in Oracle. This would involve (i imagine) some very complex algorithms and some very sophisticated monitor and checking systems however I do have a very heavy c/c++ knowledge. If someone could contact me and update me on the current status of a true parallel databasing support in mysql I'd love to hear about any progress made and how I can help. I tried to subscribe to this mailing list but it seems as if the subscribing system is broken at the moment. Please reply back to my email address, fyi. Thanks, Trevor F. Linton ([EMAIL PROTECTED]) Trevor F. Linton Systems Administrator/Web Developer Vérité Multimedia Inc. http://www.verite.com DVD * CD * Web * Print * Film * Sound Phone: 801.553.1101 x 111 Fax: 801.553.1215 [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: String Size Limit?
I hit up against something like this a while ago, but I didnt have time to debug so I used a quick hack to get by. Say you are storing a text article -- | ArticleID | INT | -- |ArticleName | TEXT | -- I just created a separate table to hold the text - Articleid | INT | - textid | INT | - text | TEXT | - When saving the text I split it up into small chuncks and then give each chuck an number in order. Each chunck gets stored in the second table and is identified by the articleid. To reassemble the text I read in all the chunks from teh second table. The my program works with the text When I need to save the edited text I drop all entries for that article from the second table , break the edited text into chunks again. And save. Its probably inefficent as hell, but for my purposes it worked. -Original Message- From: Dougherty, Sean [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 13:45 To: '[EMAIL PROTECTED]' Subject: String Size Limit? I'm running into an odd string size limitation. I've traced it down as far as I can get, and I didn't run across anything in the docs or on any searches I've run so I figured I'd try here. The field in the database is a TEXT type column. I'm appending to the front of the text field each time using: UPDATE field SET notes=CONCAT(newtext,notes) WHERE ... However the field is cutting off after 4096 bytes. With a hunch that CONCAT may have been causing the limit, I switched to doing the concatenation inside of the application and setting the full field. The same cut-off occurs in storage, however the SQL executes correctly so it's not like the query is getting cut off and not seeing the WHERE clause. Seeing as this happens in CONCAT which should be server side I suspect I'm running into a server-side limitation. My app is PHP3 over IIS on NT4.0 using MyODBC 2.50.3300 to a Linux Server running MySQL 3.22.32 precompiled (when you get 100 day 24/7 uptime no problem you don't upgrade!). What incredibly obvious piece of documentation am I missing, is this a you need to upgrade thing, or what would be a reasonable work-around in this rather abstracted environment? Thanks, Sean - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL w/VB
Give MyODBC a try, its on the mysql.com site and its given my no problems at all in vb. Sean -Original Message- From: Robert Skinner [mailto:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 3:45 AM To: [EMAIL PROTECTED] Subject: Connecting to MySQL w/VB I am trying to connect to MySQL using a connection string using VB6. The read part is great but I don't seem to be able to add records. Can anyone steer me in the right direction? [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Hello please help me out
try echo file.sql mysql -u username -p password databasename or on dos type file.sql mysql -u username -p password databasename That should execute the scripts on the db in question, or you can download a a tool like mysqlgui/mysqlfront and use it to load and run the queries. Sean -Original Message- From: Divakar [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 4:50 AM To: [EMAIL PROTECTED] Subject: Hello please help me out Hi list I am a beginner in the field of mysql I would like to know whether it is possible to run sql scripts(a .sql file) in mysql. if yes please some body tell me how do we do that,. regards Div - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hello please help me out
whoops, yip, **blush** -Original Message- From: Jack Challen [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 10:23 AM To: [EMAIL PROTECTED] Cc: Sean O'Donnell Subject: Re: Hello please help me out [EMAIL PROTECTED] wrote: try echo file.sql mysql -u username -p password databasename You mean: ^ cat file.sql | mysql -u username -p password databasename ^ Or, better: mysql -u username -p password databasename file.sql -- Jack Challen Technical Consultant OCSL http://www.ocsl.co.uk/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: lower_case_table_names issue
From my experiance, you cant, you can use all table names lowercase, but that will mean you will have to refer to them in lowercase when issuing queries. unix, unlike windows, tends to operate in a case sensitive manner on everything -Original Message- From: Rui Rosa [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 12:38 AM To: [EMAIL PROTECTED] Subject: lower_case_table_names issue Hi to all, I'm new to linux and mySql (about 5 days and nights :)), I have mandrake8.0 that provide a version of MySql which I'm trying to use from a VisualBasic application (on win2000), I connect to my database on MySQL using MySqlODBC, and everyting goes OK, except the table names wich I need to be case insensitive on queries, after reading the manual I found that I could use the variable 'lower_case_table_names=1' to this prupose. I set the variable, but when I try to select something MySQL returns a error 'database.MyTable does not exist', but she exists with name 'mytable'. If someone could help! Tankyou Rui Rosa - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 + Linux
The password starts off as nothing i.e on a fresh install you dont need to supply a password, another way to set the password is to log in , switch to the mysql database (use mysql;) and issue these queries UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; FLUSH PRIVILEGES; -Original Message- From: Oscar E. Salninch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 9:04 AM To: MySQL Discussions Subject: MySQL + Linux Hi! Does anybody know how do i change the 'root' password for mysql server? I installation guide they say that it's done by typing '/usr/local/bin/mysqladmin -u root -p password new-password', but how would i know the old passsword? Am i mising anything? Thanks for helping! By the way, i'm fresh here... :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Perl Script: MySQL Slow Query Log Parser
any idea where any sort of documentation/tutorial can be found? -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 1:45 PM To: Nathanial Hendler Cc: Mysql; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Perl Script: MySQL Slow Query Log Parser You'll find mysqldumpslow (in the mysql distribution) does all that and much much more It's a pity that it's not mentioned in the online documentation since it's a _very_ useful tool. Tim. On Mon, Jun 25, 2001 at 11:59:59PM -0700, Nathanial Hendler wrote: I wrote a perl script that will parse slow_queries logs, and output some useful information. It's kind of hard to explain, but I'll try. I wanted to see what queries were taking a lot of time, and how often they were happening. I wrote a perl script that parses the log files, ignores queries that take less than n seconds, and normalizes the queries and reports the info for each queries sorted by query occurance. 'normalize' meaning... this... SELECT * FROM ween WHERE pandy_fackler = 1; SELECT * FROM ween WHERE pandy_fackler = 15; becomes... SELECT * FROM ween WHERE pandy_fackler = XXX; this... SELECT names FROM things WHERE name LIKE '%wazoo%'; SELECT names FROM things WHERE name LIKE '%tada%'; becomes... SELECT names FROM things WHERE name LIKE 'XXX'; This has proven to be a very interesting and useful tool. You should DL it and try it on your long_queries log file. Whoever runs mysql.com should put a copy on the website. It might just be the greatest thing ever (my program, not the website). For more info, and to get a copy, you can get it at: http://www.retards.org/mysql/index.php I'd like to hear people's thought on it. I'm the only person to test it so far, so it'd be nice to know that it works for other people. Thanks, Nathan Hendler Tucson, AZ USA http://retards.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: runnning my sql with windows98 and pws
hiya, I've had exactly the setup you describe running on a laptop, (I've since switched to nt / linux ), download mysql,myodbc, and optionally mysqlfront. Just run the setup programs for mysql and myodbc (very easy), and you are all set up. If you create a odbc connection for you database you can access it from asp just like any other database. The only problem I had with win98 , was that I found the system hung if I didnt shutdown mysql before I shutdown the machine. but it was perfectly stable other than that. -Original Message- From: lipp maimone [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 2:12 AM To: [EMAIL PROTECTED] Subject: runnning my sql with windows98 and pws is someone abble to tell me how can i do for running an sql database with windows98 without crashing my systeme? Also, using asp ( activex server page ), is it possible with mysql version3,23? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Odd problem issueing commands at the console
I had the same problem last night, eventually grant all to root on *.* identified by 'yourpass' got me in I must have mucked up the permissions at (the problem was with mysqlgui not mysqlshow though) Sean -Original Message- From: Peter Matulis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 5:03 PM To: Mysql (E-mail) Subject: Odd problem issueing commands at the console Just installed 3.23.37 on Red Hat 7.0 from source. I've done this a few times but this time I encountered a mysterious problem. a) server is started and runs under my designated user (mysqladm:mysqlgrp) b) /usr/local/mysql/bin is in PATH of both root and mysqladm c) using either of these users, when I issue a mysql command (here mysqlshow): mysqlshow: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) d) when I cd to /usr/local/mysql/bin and issue the command as shown it succeeds: $ ./mysqlshow +-+ | Databases | +-+ | mysql | | test | +--+ What's going on here? Peter Matulis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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