Testing the Server Load
Dear All, we have developed a web-based application for a client and now in its testing phase by next week... It uses Linux/PHP 4/MySQL 3.23 As the volume of user will be more, we are very much concerned about the server efficiency and our application efficiency/performance... Following are the one we need to database server... 1. server performance 2. the database load 3. efficiency query 4. execution time 5. how many inserts/updates taking place 6. volume of data involved and so on... Is there any tools available for this? Any idea about testing the mysql server? Thanks a lot. Shankar __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Re: Can MySQL handle 120 million records?
On Fri, Dec 20, 2002 at 09:01:21PM -0800, JamesD wrote: Jeremy, mySql has no brand recognition compared to Oracle, Sybase, MS, IBM. Well, it doesn't have as much, that's for sure. But to say it has none is an over-simplification. that is why there is not enough confidence. people buy things because they trust and have confidence in the brand. It's a sad day when confidence is built by a company's PR budget rather than the product's track record. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 7 days, processed 265,533,509 queries (430/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: How long is my piece of string?
. But that is my question! *When* do they provide a performance difference? Obviously my (fairly simple) question (...and beyond what number of records might indices provide faster extraction/presentation?... ) has not been understood. Can anyone else help, please? At 11:22 22/12/02 +1100, Alan McDonald wrote: You need indexes as soon as (or rather just before) they provide a performance difference. Alan -Original Message- From: Iain Lang [mailto:[EMAIL PROTECTED]] Sent: Sunday, 22 December 2002 11:15 AM To: [EMAIL PROTECTED] Subject: How long is my piece of string? . Dear List, I'm using php MySQL for a cycling club website, results, guest-book, events and so on. I've just started and have faithfully created indices all over the place. At present, we have less than 400 records, be they of members, of image URLs, whatever. Each year will, I expect, create an additional 400 records. Am I gilding the lily adding indices for such a small database? Does such a small database really *need* indices, and beyond what number of records might indices provide faster extraction/presentation? I realise how vague a question it is, hence the subject title. Yooors, Iain. - Most progress has been the result of the actions of unreasonable men. G.B.Shaw. http://www.johnstone-wheelers.co.uk Johnstone-Wheelers - the friendliest cycling club in Scotland! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Most progress has been the result of the actions of unreasonable men. G.B.Shaw. http://www.johnstone-wheelers.co.uk Johnstone-Wheelers - the friendliest cycling club in Scotland! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 long is my piece of string?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Iain Lang wrote: . But that is my question! *When* do they provide a performance difference? Obviously my (fairly simple) question (...and beyond what number of records might indices provide faster extraction/presentation?... ) has not been understood. Can anyone else help, please? At 11:22 22/12/02 +1100, Alan McDonald wrote: You need indexes as soon as (or rather just before) they provide a performance difference. From http://www.mysql.com/doc/en/Where_optimisations.html : Each table index is queried, and the best index that spans fewer than 30% of the rows is used. If no such index can be found, a quick table scan is used.. So if you can't create an index that will have values that will cause MySQL to look at less that 30% of the rows, it will not be used. For example if you have a column that contains the value 'foo' 90% of the time, queries looking for 'foo' in that column will not use an index. Indexes almost _always_ slow down data _modification_. You can tell when/if they speed-up data retrieval by using the 'EXPLAIN' command in MySQL, see: http://www.mysql.com/doc/en/EXPLAIN.html -Mark -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+BcGPtvXNTca6JD8RAjAmAKC/OlCFFx7iLZN57AMIRO5cV4wfyACgrLjU OHViqL0GR0Hf4lLoS50uTXU= =veUT -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Return every Nth row in a result set
I really don't want to do this client side (I'd have to execute approximately 10 queries for every page load just for this small task). Selecting the entire table into a temp table to number the rows also seems rather inefficient. I was reading in a book at Barnes and Noble yesterday which said to use a query that looked something like this: SELECT a.id FROM documents as a, documents as b WHERE a.id = b.id GROUP BY a.id HAVING MOD(a.id,:n); I'm nearly positive that that isn't exactly what it said, but it was something like that. If anyone can come up with a way to do this without a temporary table and only one or two queries (using 3.x or 4.0) that'd be great. Thanks for the help guys. -Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 database Design
Hi, I'm having problems trying to figure which is the best way to solve a design : I'm designing a delivery program with php and mysql, and I'm having troubles with some tables, my problem is with the recipes, the recipes are divided into two tables one with a recipe id and description the other detailing the ingredients, of each particular recipe, that's where my problem starts because each ingredient is not unique and even it appears in many recipes, and another thing is every time and item is ordered their correspondent recipe ingredients are added , ie. pizza has a code 11, recipe has code 01 then all the ingredients in the recipe table have different ingredient code each, and are related by the recipe code 01, then each separate item must be counted, and added to the ingredients general daily totals, I mean pizza uses 2 tomatoes then the general total will show two tomatoes and each other ingredient. There are also some combined recipes : Pizza with a special sauce, then this item has to query two parts of the same table, say code 12 is Pizza with a combined sauce of mushrooms and milk, and pineapples, so each ingredient must be added to the general total. I need help with the design because I don't want to have database anomalies. Thank you all, Merry Xmas Rick __ Omni ICQ#: 37031810 Current ICQ status: + More ways to contact me __ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Return every Nth row in a result set
Hello. On Sun 2002-12-22 at 08:56:43 -0500, [EMAIL PROTECTED] wrote: I really don't want to do this client side (I'd have to execute approximately 10 queries for every page load just for this small task). Selecting the entire table into a temp table to number the rows also seems rather inefficient. I was reading in a book at Barnes and Noble yesterday which said to use a query that looked something like this: SELECT a.id FROM documents as a, documents as b WHERE a.id = b.id GROUP BY a.id HAVING MOD(a.id,:n); I'm nearly positive that that isn't exactly what it said, but it was something like that. If anyone can come up with a way to do this without a temporary table and only one or two queries (using 3.x or 4.0) that'd be great. Thanks for the help guys. Well, the solution is already in there: they suggest using a HAVING clause to reduce the rows after the complete result set has been determined. And to use MOD(id, number) to select which rows to keep. MOD(id,10) will return 0 for multiples of 10. So, if you want every 10th rows, you would use SELECT * FROM your_table WHERE some_condition HAVING NOT MOD(id,10) If you still encounter problems, please elaborate. And include a real example of what you tried. HTH, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help with database Design
Ricardo, you're asking how to normalise your database. There are links to some good intro tutorials at http://www.artfulsoftware.com/dbresources.html PB - Hi, I'm having problems trying to figure which is the best way to solve a design : I'm designing a delivery program with php and mysql, and I'm having troubles with some tables, my problem is with the recipes, the recipes are divided into two tables one with a recipe id and description the other detailing the ingredients, of each particular recipe, that's where my problem starts because each ingredient is not unique and even it appears in many recipes, and another thing is every time and item is ordered their correspondent recipe ingredients are added , ie. pizza has a code 11, recipe has code 01 then all the ingredients in the recipe table have different ingredient code each, and are related by the recipe code 01, then each separate item must be counted, and added to the ingredients general daily totals, I mean pizza uses 2 tomatoes then the general total will show two tomatoes and each other ingredient. There are also some combined recipes : Pizza with a special sauce, then this item has to query two parts of the same table, say code 12 is Pizza with a combined sauce of mushrooms and milk, and pineapples, so each ingredient must be added to the general total. I need help with the design because I don't want to have database anomalies. Thank you all, Merry Xmas Rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help with database Design
Ricardo, you're asking how to normalise your database. There are links to some good intro tutorials at http://www.artfulsoftware.com/dbresources.html PB - [filter fodder: sql, mysql] Hi, I'm having problems trying to figure which is the best way to solve a design : I'm designing a delivery program with php and mysql, and I'm having troubles with some tables, my problem is with the recipes, the recipes are divided into two tables one with a recipe id and description the other detailing the ingredients, of each particular recipe, that's where my problem starts because each ingredient is not unique and even it appears in many recipes, and another thing is every time and item is ordered their correspondent recipe ingredients are added , ie. pizza has a code 11, recipe has code 01 then all the ingredients in the recipe table have different ingredient code each, and are related by the recipe code 01, then each separate item must be counted, and added to the ingredients general daily totals, I mean pizza uses 2 tomatoes then the general total will show two tomatoes and each other ingredient. There are also some combined recipes : Pizza with a special sauce, then this item has to query two parts of the same table, say code 12 is Pizza with a combined sauce of mushrooms and milk, and pineapples, so each ingredient must be added to the general total. I need help with the design because I don't want to have database anomalies. Thank you all, Merry Xmas Rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help with database Design
-Original Message- From: Ricardo Fitzgerald [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 22, 2002 11:22 AM To: [EMAIL PROTECTED] Subject: Help with database Design create table recipes( rid int not null primary key, rname ) ; create table ingredient( iid int not null, rid int not null, # references recipe.rid ridorder int not null, # order of this ingredient in recipe PRIMARY KEY(iid,rid,ridorder), iname ...) ; HTH, Adolfo Hi, I'm having problems trying to figure which is the best way to solve a design : I'm designing a delivery program with php and mysql, and I'm having troubles with some tables, my problem is with the recipes, the recipes are divided into two tables one with a recipe id and description the other detailing the ingredients, of each particular recipe, that's where my problem starts because each ingredient is not unique and even it appears in many recipes, and another thing is every time and item is ordered their correspondent recipe ingredients are added , ie. pizza has a code 11, recipe has code 01 then all the ingredients in the recipe table have different ingredient code each, and are related by the recipe code 01, then each separate item must be counted, and added to the ingredients general daily totals, I mean pizza uses 2 tomatoes then the general total will show two tomatoes and each other ingredient. There are also some combined recipes : Pizza with a special sauce, then this item has to query two parts of the same table, say code 12 is Pizza with a combined sauce of mushrooms and milk, and pineapples, so each ingredient must be added to the general total. I need help with the design because I don't want to have database anomalies. Thank you all, Merry Xmas Rick __ Omni ICQ#: 37031810 Current ICQ status: + More ways to contact me __ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How long is my piece of string?
Create 2 tables with identical columns definition, one with index and the other without. Start adding records to the two tables and querying them. This way you'll find out the number of recors for which the performance is about the same. After that, you can decide wich way to go. Adolfo -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 22, 2002 9:44 AM To: Iain Lang Cc: Alan McDonald; [EMAIL PROTECTED] Subject: Re: How long is my piece of string? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Iain Lang wrote: . But that is my question! *When* do they provide a performance difference? Obviously my (fairly simple) question (...and beyond what number of records might indices provide faster extraction/presentation?... ) has not been understood. Can anyone else help, please? At 11:22 22/12/02 +1100, Alan McDonald wrote: You need indexes as soon as (or rather just before) they provide a performance difference. From http://www.mysql.com/doc/en/Where_optimisations.html : Each table index is queried, and the best index that spans fewer than 30% of the rows is used. If no such index can be found, a quick table scan is used.. So if you can't create an index that will have values that will cause MySQL to look at less that 30% of the rows, it will not be used. For example if you have a column that contains the value 'foo' 90% of the time, queries looking for 'foo' in that column will not use an index. Indexes almost _always_ slow down data _modification_. You can tell when/if they speed-up data retrieval by using the 'EXPLAIN' command in MySQL, see: http://www.mysql.com/doc/en/EXPLAIN.html -Mark -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+BcGPtvXNTca6JD8RAjAmAKC/OlCFFx7iLZN57AMIRO5cV4wfyACgrLjU OHViqL0GR0Hf4lLoS50uTXU= =veUT -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Return every Nth row in a result set
I can't do it by ID because what if a row in the middle somewhere gets deleted? I need to do it by the position in the table, and a static numbering column won't work. This is a solution someone on EFNet came up with: SET @rowcount=0; select docid,@rowcount:=@rowcount+1 as num FROM documents HAVING (num+1)%6=0 It works. However, if I do: SET @rowcount=0; SELECT docid,@rowcount:=@rowcount+1 as num FROM documents; The num associated with each docid is different than the ones that return from the first query. This seems weird, possibly a bug? Here are the results for you guys to chew on. As you will see, in the first result set, when docid=55, num=25 (25th record in the table). However, on the second result set, when docid=55, num=30. I can prove that docid=55 is actually the 25th record in the table because: SELECT docid FROM documents LIMIT 24,1 Returns docid=55. I'd love to hear what you guys think. Here's the result I promised: mysql select docid,@rowcount:=@rowcount+1 as num from documents limit 40; +---+--+ | docid | num | +---+--+ | 2 |1 | | 4 |2 | | 5 |3 | | 6 |4 | | 7 |5 | | 8 |6 | | 9 |7 | |10 |8 | |11 |9 | |12 | 10 | |13 | 11 | |14 | 12 | |15 | 13 | |16 | 14 | |17 | 15 | |20 | 16 | |21 | 17 | |34 | 18 | |35 | 19 | |36 | 20 | |37 | 21 | |39 | 22 | |40 | 23 | |41 | 24 | |55 | 25 | |56 | 26 | |59 | 27 | |61 | 28 | |77 | 29 | |80 | 30 | |81 | 31 | |82 | 32 | |83 | 33 | |84 | 34 | |85 | 35 | |86 | 36 | |88 | 37 | |93 | 38 | | 106 | 39 | | 109 | 40 | +---+--+ 40 rows in set (0.00 sec) mysql select docid,@rowcount:=@rowcount+1 as num FROM documents HAVING (num+1)%6=0 LIMIT 30; +---+--+ | docid | num | +---+--+ | 7 |6 | |12 | 12 | |17 | 18 | |36 | 24 | |55 | 30 | |80 | 36 | |85 | 42 | | 109 | 48 | | 119 | 54 | | 125 | 60 | | 136 | 66 | | 147 | 72 | | 152 | 78 | | 160 | 84 | | 166 | 90 | | 171 | 96 | | 178 | 102 | | 185 | 108 | | 191 | 114 | | 207 | 120 | | 213 | 126 | | 218 | 132 | +---+--+ 22 rows in set (0.00 sec) -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 22, 2002 10:41 AM To: SpamSucks86 Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Return every Nth row in a result set Hello. On Sun 2002-12-22 at 08:56:43 -0500, [EMAIL PROTECTED] wrote: I really don't want to do this client side (I'd have to execute approximately 10 queries for every page load just for this small task). Selecting the entire table into a temp table to number the rows also seems rather inefficient. I was reading in a book at Barnes and Noble yesterday which said to use a query that looked something like this: SELECT a.id FROM documents as a, documents as b WHERE a.id = b.id GROUP BY a.id HAVING MOD(a.id,:n); I'm nearly positive that that isn't exactly what it said, but it was something like that. If anyone can come up with a way to do this without a temporary table and only one or two queries (using 3.x or 4.0) that'd be great. Thanks for the help guys. Well, the solution is already in there: they suggest using a HAVING clause to reduce the rows after the complete result set has been determined. And to use MOD(id, number) to select which rows to keep. MOD(id,10) will return 0 for multiples of 10. So, if you want every 10th rows, you would use SELECT * FROM your_table WHERE some_condition HAVING NOT MOD(id,10) If you still encounter problems, please elaborate. And include a real example of what you tried. HTH, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.sock
Hi how can I do to restore mysql.sock? Thank in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.sock
Bruno, Restart mysqld. Peter. - Original Message - From: bruno peracchio [EMAIL PROTECTED] To: mysql-list [EMAIL PROTECTED] Sent: Sunday, December 22, 2002 4:40 PM Subject: mysql.sock Hi how can I do to restore mysql.sock? Thank in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Return every Nth row in a result set
. I can't do it by ID because what if a row in the middle somewhere gets deleted? I need to do it by the position in the table, and a static numbering column won't work. This is a solution someone on EFNet came up with: SET @rowcount=0; select docid,@rowcount:=@rowcount+1 as num FROM documents HAVING (num+1)%6=0 It works. However, if I do: No it doesn't. [snip] mysql select docid,@rowcount:=@rowcount+1 as num from documents limit 40; +---+--+ | docid | num | +---+--+ | 2 |1 | | 4 |2 | | 5 |3 | | 6 |4 | | 7 |5 | | 8 |6 | | 9 |7 | |10 |8 | [snip] mysql select docid,@rowcount:=@rowcount+1 as num FROM documents HAVING (num+1)%6=0 LIMIT 30; +---+--+ | docid | num | +---+--+ | 7 |6 | |12 | 12 | [snip] How is 7 the 6th element? Looks like it should be 8 to me. Shouldn't the first element, 2, be included in the result set also? If you don't include the first element in the result of give me every nth element then its never going to appear in the result set. Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Return every Nth row in a result set
. I can't do it by ID because what if a row in the middle somewhere gets deleted? I need to do it by the position in the table, and a static numbering column won't work. This is a solution someone on EFNet came up with: SET @rowcount=0; select docid,@rowcount:=@rowcount+1 as num FROM documents HAVING (num+1)%6=0 It works. However, if I do: No it doesn't. [snip] mysql select docid,@rowcount:=@rowcount+1 as num from documents limit 40; +---+--+ | docid | num | +---+--+ | 2 |1 | | 4 |2 | | 5 |3 | | 6 |4 | | 7 |5 | | 8 |6 | | 9 |7 | |10 |8 | [snip] mysql select docid,@rowcount:=@rowcount+1 as num FROM documents HAVING (num+1)%6=0 LIMIT 30; +---+--+ | docid | num | +---+--+ | 7 |6 | |12 | 12 | [snip] How is 7 the 6th element? Looks like it should be 8 to me. Shouldn't the first element, 2, be included in the result set also? If you don't include the first element in the result of give me every nth element then its never going to appear in the result set. Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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! Converting varchar to List
Sorry to be a bother, but I've been working on this problem for three days with no succcess. I store the result(s) of a multiple select listbox in a MySQL version 4.0.2 varchar field i.e. 2,3,4,5,6 as a selection example. - these results are stored in the table category under the field name category_common. What I'm trying to do is to use the the the above results in a query such as follows: The column content.content_common has the values of 2 and 3 and 4 in different rows. I've enclosed category.category_common in parentheses () which as I understand should treat category.category_common as a list. My question is the following query something that MySQL can render regarding the content.content_common IN (category.category_common) statement or am I doing something very wrong? Once again, when I manually type in (2,3,4) in place of (category.category_common), I get the right answer. How can I convert (category.category_common) into a list MySQL can understand? * Select content_title, content_category, content_order, content_name1 from content, category where category.category_id = 'Intbk' AND content.content_common IN (category.category_common) Order by content.content_order My platform is as follows: W2k professional, tomcat 4.1.12, J2SDK 1.4.1, MySQL 4.0.2, mysql-connector-java-3.0.0 Once again, Thanks for any help. Happy Holidays, Lenny Sorey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: update mysql
On Friday 20 December 2002 22:08, John Chang wrote: I e-mailed the list but haven't received a response. I have win2k w/ 3.23.53 and need to update it to 54. Is there a patch or do I have to do a reinstall or install on top of it? You can just install 3.23.54 over 3.23.53, but backup of the databases is recommended. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: (In addition...) mysqldump user prive
On Sunday 22 December 2002 05:16, Dr. Poo wrote: On Friday 20 December 2002 08:42 am, Victoria Reznichenko wrote: On Thursday 19 December 2002 21:29, Arun kumar R wrote: I want to run mysqldump through a batch process, in order to do that what prive do i need to give to the user. It will be running as a cron job, i don't want to give any creation or deletion authorization. Your help will be greatly appreciated. You should have SELECT privileges. I'm chris, HI! After reading this thread, i got the question of: What privileges would a user need to have for mysqlhotcopy to work correctly. What about checking the MySQL manual? http://www.mysql.com/doc/en/mysqlhotcopy.html To be able to execute mysqlhotcopy you need write access to the backup directory, the SELECT privilege for the tables you are about to copy and the MySQL RELOAD privilege (to be able to execute FLUSH TABLES). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: crash if etc/hosts misconfigured
On Friday 20 December 2002 11:01, azerbinati at libero dot it wrote: I'd a /etc/hosts misconfigured, it told that the machine name was linux200 with IP 192.168.0.3 but eth0 was configured to use IP 192.168.0.16. In this enviroment executing this command mysql -h 192.168.0.16 cause a mysqld crash. Correcting /etc/hosts to report the correct name to ip now mysql -h 192.168.0.16 responds with ERROR 1130: Host 'linux200' is not allowed to connect to this MySQL server Maybe the problem is when it try to resolve the hostname. Could you test it with binary distribution? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql.sock
service mysql start -Original Message- From: bruno peracchio [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 22, 2002 12:41 PM To: mysql-list Subject: mysql.sock Hi how can I do to restore mysql.sock? Thank in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Crash within libmysqlclient when connection dies.
Hi, I hope this is the right place to post this. I have a simple C program that uses libmysqlclient and it works great, up to the moment a connection with my remote mysqld breaks, for whatever networking related reason, then I can see that such errors are not handled softly within the mysqlclient lib, instead it crashes deep inside, for example the following backtrace should show this; Program terminated with signal 11, Segmentation fault. #0 0x08082210 in net_safe_read () (gdb) bt #0 0x08082210 in net_safe_read () #1 0x08082d08 in read_one_row () #2 0x08085473 in mysql_fetch_row () #3 0x080497be in main (argc=1, argv=0xb075d804) at crawl.c:705 (gdb) q I'm using what appears to be a very recent version taken from the unstable tree in debian, libmysqlclient10_3.23.54a-1_i386.deb Any comments on this? should I be doing something differently or use different API that handles these sort of things ? Please CC me as I'm not subscribed. Thanks, Marc. -- marc @ corky.net fingerprint = D1F0 5689 967F B87A 98EB C64D 256A D6BF 80DE 6D3C /\ \ / ASCII Ribbon Campaign X Against HTML Mail / \ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 database Design
I'm designing a delivery program with php and mysql, and I'm having troubles with some tables, my problem is with the recipes, the recipes are divided into two tables one with a recipe id and description the other detailing the ingredients, of each particular recipe, that's where my problem starts because each ingredient is not unique and even it appears in many recipes, and another thing is every time and item is ordered their correspondent recipe ingredients are added , ie. pizza has a code 11, recipe has code 01 then all the ingredients in the recipe table have different ingredient code each, and are related by the recipe code 01, then each separate item must be counted, and added to the ingredients general daily totals, I mean pizza uses 2 tomatoes then the general total will show two tomatoes and each other ingredient. There are also some combined recipes : Pizza with a special sauce, then this item has to query two parts of the same table, say code 12 is Pizza with a combined sauce of mushrooms and milk, and pineapples, so each ingredient must be added to the general total. I need help with the design because I don't want to have database anomalies. -Original Message- From: Ricardo Fitzgerald [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 22, 2002 11:22 AM To: [EMAIL PROTECTED] Subject: Help with database Design create table recipes( rid int not null primary key, rname ) ; create table ingredient( iid int not null, rid int not null, # references recipe.rid ridorder int not null, # order of this ingredient in recipe PRIMARY KEY(iid,rid,ridorder), iname ...) ; Your solution means a repetition of ingredients in the ingredients table. Then, if the unit cost of an ingredient changed you'd have to change every occurance of the ingredient... and where would you store info like the source manufacturer, tel and address etc etc. How about: table meals( m_id primary, m_name, etc etc ) table ingredients( i_id primary, i_name, i_price, etc etc ) table recipes( r_id primary, m_id, #(the meal ident) referencess meals, there will be multiples of these ) OR a really nasty way to do it with 2 tables.. table meals( m_id primary, m_name, m_ingredients, # a comma separated list of ingredient ID's in a text field ) table ingredients( as above ) so then you can read in a list of ingredient id's for each recipe, then 'look up' the ingredients. Jeff Snoxell Aetherweb Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug using truncation in 4.0.4-beta
Hello Victoria, Is there any plan to make operators work with phrase searches. something like: against ('comput* scie*') in boolean mode I have tested 4.0.6-gamma and I can see that the bug is fixed: Empty set is returned when truncation operator is used :-) Regards Salam Victoria Reznichenko wrote: sbs, Tuesday, October 29, 2002, 7:31:03 AM, you wrote: samdldlds Description: samdldlds Special case: using SELECT with truncation doesn't return some records samdldlds when the searched query appears at the end of the line. Note that the last record will samdldlds be matched and returned because there is a space character at the end. samdldlds I am using ft_min_word_len = 1; Currently phrase search doesn't work with operators. If they work for somebody, it's a bug, too :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqladmin access denied error
On Friday 20 December 2002 15:31, Imran Khan wrote: I'm using solaris 8 with mysql v 3.23.54. I want to enable a solaris user - 'user1', to use the mysqlimport command without using a password. I've run, as root, the following sql command: mysqlgrant all on db1.* to user1@localhost -this appears to work fine. However as user1 in the solaris shell, when I run: $:/usr/local/mysql/bin/mysqlimport db1 table1.txt I get : /usr/local/mysql/bin/mysqlimport: Error: Access denied for user: 'user1@localhost' (Using password: NO), when using table: table1 So how can I allow a user to run mysqlimport to my db1 database, and without a password? To use mysqlimport you must have FILE privilege. It's not a database privilege, it's a global privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: mysqldump user prive
On Thursday 19 December 2002 21:29, Arun kumar R wrote: I want to run mysqldump through a batch process, in order to do that what prive do i need to give to the user. It will be running as a cron job, i don't want to give any creation or deletion authorization. Your help will be greatly appreciated. You should have SELECT privileges. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 database Design
You're right. I have already posted a 3 tables solution: recipes, ingredients and recipeingredients. Adolfo On Sun, 2002-12-22 at 14:10, Jeff Snoxell wrote: I'm designing a delivery program with php and mysql, and I'm having troubles with some tables, my problem is with the recipes, the recipes are divided into two tables one with a recipe id and description the other detailing the ingredients, of each particular recipe, that's where my problem starts because each ingredient is not unique and even it appears in many recipes, and another thing is every time and item is ordered their correspondent recipe ingredients are added , ie. pizza has a code 11, recipe has code 01 then all the ingredients in the recipe table have different ingredient code each, and are related by the recipe code 01, then each separate item must be counted, and added to the ingredients general daily totals, I mean pizza uses 2 tomatoes then the general total will show two tomatoes and each other ingredient. There are also some combined recipes : Pizza with a special sauce, then this item has to query two parts of the same table, say code 12 is Pizza with a combined sauce of mushrooms and milk, and pineapples, so each ingredient must be added to the general total. I need help with the design because I don't want to have database anomalies. -Original Message- From: Ricardo Fitzgerald [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 22, 2002 11:22 AM To: [EMAIL PROTECTED] Subject: Help with database Design create table recipes( rid int not null primary key, rname ) ; create table ingredient( iid int not null, rid int not null, # references recipe.rid ridorder int not null, # order of this ingredient in recipe PRIMARY KEY(iid,rid,ridorder), iname ...) ; Your solution means a repetition of ingredients in the ingredients table. Then, if the unit cost of an ingredient changed you'd have to change every occurance of the ingredient... and where would you store info like the source manufacturer, tel and address etc etc. How about: table meals( m_id primary, m_name, etc etc ) table ingredients( i_id primary, i_name, i_price, etc etc ) table recipes( r_id primary, m_id, #(the meal ident) referencess meals, there will be multiples of these ) OR a really nasty way to do it with 2 tables.. table meals( m_id primary, m_name, m_ingredients, # a comma separated list of ingredient ID's in a text field ) table ingredients( as above ) so then you can read in a list of ingredient id's for each recipe, then 'look up' the ingredients. Jeff Snoxell Aetherweb Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Adolfo Bello [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
Docs make wrong statement about Debians init scripts
Description: http://www.mysql.com/doc/en/Linux-x86.html says what to do to start MySQL on system boot in Debian GNU/Linux. I don't know if this holds true for some of your binary packages under Debian, but the official Debian package is configure by debconf. So this text is misleading for Debian users and should be removed completely. How-To-Repeat: Fix: remove the note Submitter-Id: submitter ID Originator:Christian Hammers (Debian maintainer of MySQL) Organization: The Debian Project MySQL support: none Synopsis: Wrong statement about Debian init scripts Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
[patch] Error in Makefile prevents complete distclean
Description: The unpacked source differs from the source tree after a ./configure make make distclean. This should be considered as Makefile bug, as e.g. package maintainers like me depends on a souce that cleans up it self so that we can easyly produce diffs containing only our own modifications. How-To-Repeat: ./configure make make clean; diff -u --recursive ../orig . Fix: Some diffs: # # Cleans up the vio_* and ctype-* symlinks that are created by link_source # $ diff -u mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared --- mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared2002-12-16 10:11:57.0 +0100 +++ mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared 2002-12-21 01:56:07.0 ++0100 @@ -84,6 +84,8 @@ rm -f `echo $(mystringsobjects) | sed s;\.lo;.c;g` \ `echo $(dbugobjects) | sed s;\.lo;.c;g` \ `echo $(mysysobjects) | sed s;\.lo;.c;g` \ + `echo $(vio_objects) | sed s;\.lo;.c;g` \ + $(CHARSET_SRCS) $(CHARSET_OBJS) \ $(mystringsextra) $(mystringsgen) $(mysysheaders) \ ctype_extra_sources.c net.c ../linked_client_sources There are some others.. maybe I search them later. Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: distclean target misses some files Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: 4.0.6 and probably mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Missing -lwrap on mysqld/mysqltest?
Description: gcc -O3 -DDBUG_OFF -rdynamic -o mysqltest mysqltest.o -lstdc++ ../libmysqld.a -lrt -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread ../libmysqld.a(lib_sql.o)(.text+0x2736): In function `handle_connections_sockets': : undefined reference to `request_init' ... make[4]: Leaving directory `/home/ch/debian/mysql-dfsg-4.0.6.gamma/libmysqld/examples' How-To-Repeat: Build with --embedded-server Fix: Makefile.in: add -lwrap to mysqltest_LDFLAGS or in your case defined this variable in Makefile.am. Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: Missing -lwrap to libmysqld/mysqltest Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to enter data in MySQLCC
Please someone email me at [EMAIL PROTECTED] how to do this as well...I am lost on how to ad data to MYSQLCC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 sporadic crashes in find_item_in_list
Description: Sometimes my hosting mysql server segfaulting typical backtrace follows 0x80be1f8 handle_segfault + 424 0x4011e8d5 _end + 938550201 0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417 0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 + 248 0x80ef531 setup_order__FP3THDP13st_table_listRt4List1Z4ItemT2P8st_order + 49 0x80e0431 mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UlP13select_result + 421 0x80ee8ec handle_select__FP3THDP6st_lexP13select_result + 92 0x80c760a mysql_execute_command__Fv + 934 0x80cac91 mysql_parse__FP3THDPcUi + 349 0x80c69a8 dispatch_command__F19enum_server_commandP3THDPcUi + 1280 0x80cc210 do_command__FP3THD + 92 0x80c5e38 handle_one_connection + 608 0x4011bb9c _end + 938538624 0x402ce1ea _end + 940317902 some queries from errorlog: thd-query at 0x8236fd0 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% ÃÎÐÎÄÑÊÎÅ %') AND LOWER(keywords) LIKE LOWE R('% ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(keywords) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(keywords) LIKE LOWER('% %')) OR (LOWER(CONCAT(' ',ti tle,' ')) LIKE LOWER('% ÃÎÐÎÄÑÊÎÅ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% %')) ORDER BY lm DESC thd-query at 0x8733a08 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% ËÅÍÈÍ %')) OR (LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ËÅÍÈÍ %')) ORDER BY lm DESC thd-query at 0x87409a8 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% ÀÍÀËÈÇ %') AND LOWER(keywords) LIKE LOWER(' % ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(keywords) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %')) OR (LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÀÍÀËÈÇ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %') ) ORDER BY lm DESC How-To-Repeat: Not researched yet Fix: Not known yet Submitter-Id: submitter ID Originator: Organization: MySQL support: none Synopsis: pseudprandom mysqld segfaults in find_item_in_list Severity: serious Category: mysql Class: sw-bug Release: mysql-4.0.5, mysql-4.0-1.1482 (cset 1.1482 as from bk://work.mysql.com:7001) Environment: System: Linux netstat 2.4.20-s7 #2 SMP ðÔÎ äÅË 13 18:51:21 MSK 2002 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 áÐÒ 25 2002 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1282588 óÅÎ 4 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 óÅÎ 4 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 óÅÎ 4 2001 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr/local/mysql' '--enable-static=no' '--with-server-suffix' '--enable-thread-safe-client' '--enable-assembler' '--with-raid' '--with-mysqld-user=mysql' '--without-debug' '--with-comment' '--with-mysqlfs' '--with-vio' '--with-openssl' '--with-charset=cp1251' '--with-extra-charsets=all' '--without-innodb' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqladmin access denied error
On Friday 20 December 2002 15:31, Imran Khan wrote: I'm using solaris 8 with mysql v 3.23.54. I want to enable a solaris user - 'user1', to use the mysqlimport command without using a password. I've run, as root, the following sql command: mysqlgrant all on db1.* to user1@localhost -this appears to work fine. However as user1 in the solaris shell, when I run: $:/usr/local/mysql/bin/mysqlimport db1 table1.txt I get : /usr/local/mysql/bin/mysqlimport: Error: Access denied for user: 'user1@localhost' (Using password: NO), when using table: table1 So how can I allow a user to run mysqlimport to my db1 database, and without a password? To use mysqlimport you must have FILE privilege. It's not a database privilege, it's a global privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: mysqldump user prive
On Thursday 19 December 2002 21:29, Arun kumar R wrote: I want to run mysqldump through a batch process, in order to do that what prive do i need to give to the user. It will be running as a cron job, i don't want to give any creation or deletion authorization. Your help will be greatly appreciated. You should have SELECT privileges. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Docs make wrong statement about Debians init scripts
Description: http://www.mysql.com/doc/en/Linux-x86.html says what to do to start MySQL on system boot in Debian GNU/Linux. I don't know if this holds true for some of your binary packages under Debian, but the official Debian package is configure by debconf. So this text is misleading for Debian users and should be removed completely. How-To-Repeat: Fix: remove the note Submitter-Id: submitter ID Originator:Christian Hammers (Debian maintainer of MySQL) Organization: The Debian Project MySQL support: none Synopsis: Wrong statement about Debian init scripts Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Missing -lwrap on mysqld/mysqltest?
Description: gcc -O3 -DDBUG_OFF -rdynamic -o mysqltest mysqltest.o -lstdc++ ../libmysqld.a -lrt -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread ../libmysqld.a(lib_sql.o)(.text+0x2736): In function `handle_connections_sockets': : undefined reference to `request_init' ... make[4]: Leaving directory `/home/ch/debian/mysql-dfsg-4.0.6.gamma/libmysqld/examples' How-To-Repeat: Build with --embedded-server Fix: Makefile.in: add -lwrap to mysqltest_LDFLAGS or in your case defined this variable in Makefile.am. Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: Missing -lwrap to libmysqld/mysqltest Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
[patch] Error in Makefile prevents complete distclean
Description: The unpacked source differs from the source tree after a ./configure make make distclean. This should be considered as Makefile bug, as e.g. package maintainers like me depends on a souce that cleans up it self so that we can easyly produce diffs containing only our own modifications. How-To-Repeat: ./configure make make clean; diff -u --recursive ../orig . Fix: Some diffs: # # Cleans up the vio_* and ctype-* symlinks that are created by link_source # $ diff -u mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared --- mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared2002-12-16 10:11:57.0 +0100 +++ mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared 2002-12-21 01:56:07.0 ++0100 @@ -84,6 +84,8 @@ rm -f `echo $(mystringsobjects) | sed s;\.lo;.c;g` \ `echo $(dbugobjects) | sed s;\.lo;.c;g` \ `echo $(mysysobjects) | sed s;\.lo;.c;g` \ + `echo $(vio_objects) | sed s;\.lo;.c;g` \ + $(CHARSET_SRCS) $(CHARSET_OBJS) \ $(mystringsextra) $(mystringsgen) $(mysysheaders) \ ctype_extra_sources.c net.c ../linked_client_sources There are some others.. maybe I search them later. Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: distclean target misses some files Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: 4.0.6 and probably mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How long is my piece of string?
Iain Lang wrote: . But that is my question! *When* do they provide a performance difference? Obviously my (fairly simple) question (...and beyond what number of records might indices provide faster extraction/presentation?... ) has not been understood. Can anyone else help, please? Its not that it hasn't been understood. Its not a simple question. It depends on a lot of things you didn't bring up. What is the ration of reads to writes? What is the key of values? What do the queries look like? What hardware are you running on? The best answer is, try it and see. If your tables are small. Adding and removing indices is very quick. And testing queries is also very quick. At 11:22 22/12/02 +1100, Alan McDonald wrote: You need indexes as soon as (or rather just before) they provide a performance difference. Alan -Original Message- From: Iain Lang [mailto:[EMAIL PROTECTED]] Sent: Sunday, 22 December 2002 11:15 AM To: [EMAIL PROTECTED] Subject: How long is my piece of string? . Dear List, I'm using php MySQL for a cycling club website, results, guest-book, events and so on. I've just started and have faithfully created indices all over the place. At present, we have less than 400 records, be they of members, of image URLs, whatever. Each year will, I expect, create an additional 400 records. Am I gilding the lily adding indices for such a small database? Does such a small database really *need* indices, and beyond what number of records might indices provide faster extraction/presentation? I realise how vague a question it is, hence the subject title. Yooors, Iain. - Most progress has been the result of the actions of unreasonable men. G.B.Shaw. http://www.johnstone-wheelers.co.uk Johnstone-Wheelers - the friendliest cycling club in Scotland! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Most progress has been the result of the actions of unreasonable men. G.B.Shaw. http://www.johnstone-wheelers.co.uk Johnstone-Wheelers - the friendliest cycling club in Scotland! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How long is my piece of string?
. With about 400 records total - as I said in my original post - , I should imagine that any elapsed time will be more a function of my connection speed than a true measure of database/query speed. At 11:56 22/12/02 -0400, Adolfo Bello wrote: Create 2 tables with identical columns definition, one with index and the other without. Start adding records to the two tables and querying them. This way you'll find out the number of recors for which the performance is about the same. After that, you can decide wich way to go. Adolfo -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 22, 2002 9:44 AM To: Iain Lang Cc: Alan McDonald; [EMAIL PROTECTED] Subject: Re: How long is my piece of string? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Iain Lang wrote: . But that is my question! *When* do they provide a performance difference? Obviously my (fairly simple) question (...and beyond what number of records might indices provide faster extraction/presentation?... ) has not been understood. Can anyone else help, please? At 11:22 22/12/02 +1100, Alan McDonald wrote: You need indexes as soon as (or rather just before) they provide a performance difference. From http://www.mysql.com/doc/en/Where_optimisations.html : Each table index is queried, and the best index that spans fewer than 30% of the rows is used. If no such index can be found, a quick table scan is used.. So if you can't create an index that will have values that will cause MySQL to look at less that 30% of the rows, it will not be used. For example if you have a column that contains the value 'foo' 90% of the time, queries looking for 'foo' in that column will not use an index. Indexes almost _always_ slow down data _modification_. You can tell when/if they speed-up data retrieval by using the 'EXPLAIN' command in MySQL, see: http://www.mysql.com/doc/en/EXPLAIN.html -Mark -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+BcGPtvXNTca6JD8RAjAmAKC/OlCFFx7iLZN57AMIRO5cV4wfyACgrLjU OHViqL0GR0Hf4lLoS50uTXU= =veUT -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Most progress has been the result of the actions of unreasonable men. G.B.Shaw. http://www.johnstone-wheelers.co.uk Johnstone-Wheelers - the friendliest cycling club in Scotland! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DB CRASH
Hi all ... our db server is attackt by a root kit, from our old db server the only thing we have are the log files knows someone a little script or app to filter all the querys out of the standard log format of the mysld.log file ..?!? thx a lot 4 all kind of support best regards andreas PS: Some snapshots of the log format: 349586 Connect root@localhost on 349586 Init DB adspot 349586 Query insert into event (even_sess_id, even_camp_code, even_timestamp, even_text) values (812102, 'ANNA1',sysdate(), 'mouseMove event occured') 349586 Quit select, update etc. also needed ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need help connecting to local database with mysql
Hi all: I am sending a perl program I am trying to run which doesn't connect to the database. The error message is at the bottom of the e-mail. I think the program is going to the sock file and not TCP/IP and I don't know how to change this, but I'm not sure whether this is the error, so any help is much appreciated. Happy holidays. MVS. #!/usr/bin/perl -w package DBD::mysqlPP; use CGI':standard','-noDebug'; #feo4.pl my @row; $event=($row[0]); $location=($row[1]); $time=param($row[2]); $price=param($row[3]); $description=param($row[4]); $contact=param($row[5]); $day=param($row[6]); use DBI; my $dbh= DBI-connect ('DBI:mysqlPP:myd', 'umvs', 'umvs') ||die Could not connect to database: .DBI-errstr; print hello; my $sth = $dbh-prepare($sql) or die Can't prepare $sql: $dbh-errstr\n; my $sql=INSERT INTO event VALUES ('$location', '$time', '$description', '$price', '$day', '$event', '$contact'); $sth-execute(); if (my $sth-SQL($sql)){ print SQL failed; exit(); } #my @row; while(@row = my $sth-fetchrow_array()) { print qw($row[0]\t$row[1]\t$row[2]\n\t$row[3]\n\t$row[4]\n\t$row[5]\n\t$row[6]\n); } $sth-close(); $sth-finish(); $dbh-disconnect(); This is the error message I get when I compile the program: DBI-connect(myd) failed: Couldn't connect to /tmp/mysql.sock: at C:/Perl/site/ lib/DBD/mysqlPP.pm line 109 at feo4.pl line 19 Could not connect to database: Couldn't connect to /tmp/mysql.sock: at C:/Perl/ site/lib/DBD/mysqlPP.pm line 109 (in cleanup) Can't call method close on an undefined value at C:/Perl/ site/lib/DBD/mysqlPP.pm line 274. Thanks again. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
read-only... even after myisamchk -ru
I had used MySQL's myisampack utility to pack my tables, which makes them read-only, but now I want them to be write-able again. I have used myisamchk --recover --unpack (tried -ru as well) and the table is still read-only. What is the actual incantation one must use here? I can backup and re-create the table, but that seems unnecessary, if the documentation on myisamchk is correct thanx - ray - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 + ADO + ODBC
Hi all, Does MySQL's ODBC v2.50 driver support Bookmarks? I can only get ADO bookmarks to work with a Client Side Cursor. Here is some sample code: strSQL = SELECT * FROM IMAGES WHERE `CATID` = CatID rs.CursorLocation = 3 'Client Side Cursor rs.open strSQL, objConn rs.PageSize = 1 rs.absolutepage = LocationCount -- This line dies with the error message: Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype. If I do not use a Client side cursor. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: MySQL + ADO + ODBC
On Sun, 2002-12-22 at 17:25, Michael She wrote: Hi all, Does MySQL's ODBC v2.50 driver support Bookmarks? MySQL doesn't support bookmarks, so no means that the drivers will support this either :) -- Regards, Venu For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306, USA ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Search Help!
Hello, I have FULLTEXT Indexes on 2 columns, Entry and EntryCountry. ( See Below ) mysql show index from entries\g +-++-+--+---+--- +-+--++--+ | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +-++-+--+---+--- +-+--++--+ | entries | 1 | entries_idx |1 | Entry | A |NULL | NULL | NULL | | | entries | 1 | entries_idx |2 | EntryCountry | A |NULL | NULL | NULL | | | entries | 1 | Entry |1 | Entry | A |NULL |1 | NULL | FULLTEXT | | entries | 1 | Entry |2 | EntryCountry | A |NULL | NULL | NULL | FULLTEXT | +-++-+--+---+--- +-+--++--+ 8 rows in set (0.02 sec) ... but when I run a search I get: mysql SELECT ID, MATCH ( Entry ) AGAINST ( 'peace corps' ) AS Score FROM entries WHERE MATCH ( Entry ) AGAINST ( 'peace corps' ) 0 AND UID != 'demo' HAVING Score 0 ORDER BY Score DESC\g ERROR 1191: Can't find FULLTEXT index matching the column list Why!?!?!?! Help! Luc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Search problems... help!
Hello, I have FULLTEXT Indexes on 2 columns, Entry and EntryCountry. ( See Below ) mysql show index from entries\g +-++-+--+---+--- +-+--++--+ | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +-++-+--+---+--- +-+--++--+ | entries | 1 | entries_idx |1 | Entry | A |NULL | NULL | NULL | | | entries | 1 | entries_idx |2 | EntryCountry | A |NULL | NULL | NULL | | | entries | 1 | Entry |1 | Entry | A |NULL |1 | NULL | FULLTEXT | | entries | 1 | Entry |2 | EntryCountry | A |NULL | NULL | NULL | FULLTEXT | +-++-+--+---+--- +-+--++--+ 8 rows in set (0.02 sec) ... but when I run a search I get: mysql SELECT ID, MATCH ( Entry ) AGAINST ( 'peace corps' ) AS Score FROM entries WHERE MATCH ( Entry ) AGAINST ( 'peace corps' ) 0 AND UID != 'demo' HAVING Score 0 ORDER BY Score DESC\g ERROR 1191: Can't find FULLTEXT index matching the column list Why!?!?!?! Help! Luc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 I can get a handle for controlling longblob field?
hi: I will use Mysql 4.0 to store RTP data stream. How I can get a handle for controlling longblob field? I will put the received real-time data into the longblob field by the handle continually.Would you like to write a demo for me? Thanks for you help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Trouble after installing MySQL
I am having problems getting mysql working. I used the rpm packages to install the mysql and mysql-max. It seems like they are running because when I use telnet to try to connect to the port 3306 all I get is a message saying E Host 'ip' is not allowed to connect to this MySQL server. However, when I try to run bin/mysqladmin it gives me errors saying that it cannot connect to localhost. I have installed this through ssh to my linux box, could it be that because I am not physically at my computer, but using ssh that it is not working? Please any help would be great. Thanks, Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems with larger database
Good day, We're having difficulties with a database table of one varchar column that has 130,000,000 records. It is around 3.3gbs. We want to select unique results from the table and have been using a variety of commands to attempt to do so (ideally we'll insert results into a table but I started trying a file to see if it would make a different) These are the last few commands I tried: insert into unique_table (field) select distinct field from table ; insert into unique_tablel (field) select SQL_BIG_RESULT distinct field from table ; select SQL_BIG_RESULT distinct field from table into outfile '/home/fred/output/outfile'; Without SQL_BIG_RESULT it takes around 20 hours to fill all the free space on the hard drive (25GBs!) with it's temp file without ever writing to the table or to the outfile. With SQL_BIG_RESULT it takes it under an hour to fill the hard drive. There are no primary keys in any of these tables. Any ideas what the problem could be or how to resolve this? This is on a RedHat Linux 8.0 server with the 3.23.52-3 rpms. This does work on postgresql on this server, though it takes around 4-5 hours and uses somewhere between 11-19gbs of space for temp work. With a different drive this server also boots into windows2000 with MSSQL it takes it 38 minutes to complete. So it really seems like there must be something odd that's causing a problem. Thanks in advance for any assistance offered, Bryan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Can MySQL handle 120 million records?
Michael She wrote: The gravity is a great analogy. It works with databases too. People are confident in gravity because it is an observable fact of our planet. For millennia people have experienced gravity and have grown accustomed to it. The same can be said of DB2 and Oracle. People have been using it for years, hence the comfort level with these products. People have been using databases for years. Some of them were produced by Oracle Corp or IBM. However, many people have _not_ directly used Oracle or IBM DB2 that are entering or currently in the database market. They have used products built on those engines and have certain levels of faith in those engines but have to consider the DBA's involvement as well as any support contracts with Oracle or IBM that kept the software running as it was, as well as Oracle and IBM's tendancies to recommend specific (very high-end and fault-tolerant) hardware. MySQL is another iteration of the database engine by another group of people. This group of people may or may not be 'new' to database design, just as the people currently working on Oracle 10 (or X?) may be freshmen in college (for all I know, but I highly doubt it). People have faith in Oracle or IBM because they have chosen to have that faith, often on the basis of their high marketing profiles, not on the basis of hard facts or evidence. I'm not saying that Oracle and IBM don't make good DB products. They certainly make some of the best software in the world, but don't have faith in any software product just because you've heard its name a lot. OpenBSD and Linux were helping run the majority of the Internet long before most people had heard either name. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can MySQL handle 120 million records?
Jeremy Zawodny wrote: It's a sad day when confidence is built by a company's PR budget rather than the product's track record. You mean like Microsoft? Oh, sorry to bring that up ... :-) -- Michael T. Babcock C.T.O., FibreSpeed Ltd. ... sql ... for this one :) http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: i have given up -- bug
Joseph Dietz wrote: I think I'll throw in the towel. Here is the slow performance I'm getting when joining 13 tables. The query simply takes too long. Did you E-mail the MySQL staff to ask how much it would cost to have them look at this problem? Or perhaps one of the other paid consultants available on this list? I don't often analyze 13 SQL table queries for free. PS, you've got several tables not using indexes. Fix it :) -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can MySQL handle 120 million records?
On Sun, Dec 22, 2002 at 10:43:49PM -0500, Michael T. Babcock wrote: Jeremy Zawodny wrote: It's a sad day when confidence is built by a company's PR budget rather than the product's track record. You mean like Microsoft? Yeah, they are one of the worst offenders. :-) Oh, sorry to bring that up ... :-) Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 7 days, processed 294,584,169 queries (427/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
Innodb querry optimizer suddenly making TERRIBLE choices? Urgent, Please help!
I'm in a bit of a tough spot -- My innodb table of WebActionLogs (which has 1 million rows spread out over the last year and a half) has suddenly stopped using 'TimeInitiated' to select only the last 24 hours of data (usually less than 7,500 rows), and now wants to copy all 1 million rows to a temporary table no matter what I do!I tried adding a 'USE INDEX (TimeInitiated_ind)', it STILL does the longest possible query by copying everything to a temporary table first. Suddenly hundreds of queries that were working fine yesterday and ran under 0.1 seconds are taking 40 to 50 seconds and ending up in the slow query log. This has been working fine for months. Is there a way to FORCE innodb to use the index whethere it thinks it's faster or not? I know it will be 400x faster if it does but USE INDEX apparently has no effect. I ran a 'check table WebActionLogs' which sait it was OK. I had a similar problem when this table was Myisam that was fixed by 'Analyze'ing it but that's not an available option for Innodb. mysql explain SELECT DISTINCT UserName FROM WebActionLogs USE INDEX (TimeInitiated_ind) WHERE TimeInitiated NOW() - INTERVAL 24 HOUR AND TimeInitiated NOW() + INTERVAL 300 SECOND AND Id = 'xx.xx.44.17_3338_1039529682539_1248'; +--+---+---+--+-+--+ -++ | table| type | possible_keys | key | key_len | ref | rows| Extra | +--+---+---+--+-+--+ -++ | WebActionLogs| index | TimeInitiated_ind | UserName_idx | 31 | NULL | 1026114 | where used | If I remove the DISTINCT, no index is used!!! mysql explain SELECT UserTelephoneNumber FROM CallMeBackLogs - USE INDEX (TimeInitiated_ind) - WHERE TimeInitiated NOW() - INTERVAL 24 HOUR - AND TimeInitiated NOW() + INTERVAL 300 SECOND - AND Guid = 'xx.xx.44.17_3338_1039529682539_1248'; +--+--+---+--+-+--+- ++ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+--+---+--+-+--+- ++ | WebActionLogs| ALL | TimeInitiated_ind | NULL |NULL | NULL | 1081857 | where used | +-+ | VERSION() | +-+ | 3.23.51-log | +-+ Thanks in advance for any clues! Joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: i have given up -- bug
Joseph D wrote: Is it possible for you to tell me where I should add my indexes? I have read the manual but can't figure out where I must add them to my tables. If you have lots of disk space, add them to every column that is in your query(ies). Then see what the EXPLAIN output says, and delete the indexes that aren't used (except primary keys and UNIQUE indexes used for integrity). -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Delimited Characters (\)
Hi, Is the \ character a delimited in MySQL? I noticed in text inserts I have to double slash even if it is enclosed in single quotes. I find this behaviour a bit odd. Are there other delimited characters I should be aware of? Thanks. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: Delimited Characters (\)
On Mon, Dec 23, 2002 at 02:41:03AM -0500, Michael She wrote: Hi, Is the \ character a delimited in MySQL? I noticed in text inserts I have to double slash even if it is enclosed in single quotes. I find this behaviour a bit odd. Are there other delimited characters I should be aware of? The manual has all the answers: http://www.mysql.com/doc/en/String_syntax.html :-) -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 8 days, processed 298,338,567 queries (425/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