Re: varchar in the foodchain
On Thursday 08 November 2001 10:55 am, Paul DuBois wrote: At 10:00 AM -0500 11/8/01, Tony wrote: Does anyone know if putting (or grouping) varchar columns at the end of a table provides any performance improvements? My indices are all integers, but not have varchar columns in between several integer columns. You'll get a speed improvement only if all your columns are fixed length. Otherwise the table has variable length rows, no matter the placement of the variable length coluumns. So then is the real purpose of using varchars, to save disk space? ( I realize this is probably a general database question, just trying to learn). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: varchar in the foodchain
At 5:46 PM -0500 11/8/01, Tony wrote: On Thursday 08 November 2001 10:55 am, Paul DuBois wrote: At 10:00 AM -0500 11/8/01, Tony wrote: Does anyone know if putting (or grouping) varchar columns at the end of a table provides any performance improvements? My indices are all integers, but not have varchar columns in between several integer columns. You'll get a speed improvement only if all your columns are fixed length. Otherwise the table has variable length rows, no matter the placement of the variable length coluumns. So then is the real purpose of using varchars, to save disk space? ( I realize this is probably a general database question, just trying to learn). Right. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
String composite key vs auto_increment
Disclaimer: SQL/database newbie here. Let's say I have a table of authors with columns for last name and first name. Is there any general guideline re using a separate integer for the primary key as opposed to a combination of the last and first names as the key? I ask because by using the names, this would prevent duplicate entries into the db, right? Whereas using a separate integer key would not prevent this--you'd have to search for the author to see if it was already in the db before inserting to avoid dupes, right? Assume I am not concerned about there being two different Joe Smith authors that are different people. I only want to associate an author name with a book. (Any pointers to good resources besides advice from this list also appreciated) Many thanks. -Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: The schedule of MySQL 4.1
Hi Jaska, - Original Message - From: Jaska A [EMAIL PROTECTED] I'm interested in the subqueries, and thus interested in the schedule of the 4.1. So, even if there is not (?) any precise information, what do MySQL developers/managers think that when will it be released? The aim is around December/January for alpha release. See http://www.mysql.com/doc/N/u/Nutshell_Stepwise_Rollout.html Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ 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: varchar in the foodchain
On Thu, Nov 08, 2001 at 05:46:35PM -0500, Tony wrote: On Thursday 08 November 2001 10:55 am, Paul DuBois wrote: At 10:00 AM -0500 11/8/01, Tony wrote: Does anyone know if putting (or grouping) varchar columns at the end of a table provides any performance improvements? My indices are all integers, but not have varchar columns in between several integer columns. You'll get a speed improvement only if all your columns are fixed length. Otherwise the table has variable length rows, no matter the placement of the variable length coluumns. So then is the real purpose of using varchars, to save disk space? ( I realize this is probably a general database question, just trying to learn). + your datafile will be smaller which saves disk IO. In the end, the extra cost of the less efficient index as less than the gain from the faster access. So in the end you win speed. But, it is all explaind in the manual :) (sql, etc) -- The Moon is Waning Crescent (45% of Full) nieuw.nl - 2dehands.nl: 14523 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: String composite key vs auto_increment
That's not really true. You can use an auto_increment field as the primary key and create a seperate UNIQUE index that combines both the firstname and lastname fields that will be inforced for inserts. Usually its easier to work with integers as primary keys, especially when you reference them in other tables and such. I assume its slightly faster for MySQL to work with shorter integers than longer strings as primary keys but I could be wrong. Chris -Original Message- From: Christian Stromberger [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 5:59 PM To: Mysql Subject: String composite key vs auto_increment Disclaimer: SQL/database newbie here. Let's say I have a table of authors with columns for last name and first name. Is there any general guideline re using a separate integer for the primary key as opposed to a combination of the last and first names as the key? I ask because by using the names, this would prevent duplicate entries into the db, right? Whereas using a separate integer key would not prevent this--you'd have to search for the author to see if it was already in the db before inserting to avoid dupes, right? Assume I am not concerned about there being two different Joe Smith authors that are different people. I only want to associate an author name with a book. (Any pointers to good resources besides advice from this list also appreciated) Many thanks. -Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: String composite key vs auto_increment
Christian Stromberger wrote: Disclaimer: SQL/database newbie here. Let's say I have a table of authors with columns for last name and first name. Is there any general guideline re using a separate integer for the primary key as opposed to a combination of the last and first names as the key? I ask because by using the names, this would prevent duplicate entries into the db, right? Whereas using a separate integer key would not prevent this--you'd have to search for the author to see if it was already in the db before inserting to avoid dupes, right? Yes. Yes. On the second point, you would want to make a [non-unique] key on the first and last name columns. Assume I am not concerned about there being two different Joe Smith authors that are different people. I only want to associate an author name with a book. The column you seek is an integer column with the auto_increment flag, e.g.: CREATE TABLE authors ( last_name char(64) DEFAULT '' NOT NULL, first_name char(64) DEFAULT '' NOT NULL, author_idx integer NOT NULL AUTO_INCREMENT, PRIMARY KEY( author_idx ), KEY( last_name(20), first_name(20)), KEY( first_name(20)) ); The key on only first_name is there in case you query on just the first_name. The manual will tell you lots more about auto_increment and how keys are used. b. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: String composite key vs auto_increment
Disclaimer: SQL/database newbie here. Nothing wrong with being a newbie :-) Let's say I have a table of authors with columns for last name and first name. Is there any general guideline re using a separate integer for the primary key as opposed to a combination of the last and first names as the key? I ask because by using the names, this would prevent duplicate entries into the db, right? Whereas using a separate integer key would not prevent this--you'd have to search for the author to see if it was already in the db before inserting to avoid dupes, right? Assume I am not concerned about there being two different Joe Smith authors that are different people. I only want to associate an author name with a book. Your observations are correct -- as long as you're only concerned about that one table. But as soon as you start entering books (which I assume you do in another table), you have to link the two tables somehow. The most obvious way to do this is to carry over the primary key from the author's table, in your case first and last name -- just as you suggest. BUT - and here's why you should use an integer instead. 1) Strings generally take up more space than integers - and as you will probably be storing lots of data in your books table, the strings first and last name will be stored over and over, taking up more space than would an integer. 2) Maybe more importantly: Suppose you discover that an author's name is misspelled -- you'll only have one place to make the update, rather than every table referenced by the first/last name combo. BTW, there's nothing to stop you from adding another unique index besides the primary. See the CREATE TABLE / ALTER TABLE commands in the manual. This would prevent you from inserting any duplicates. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: varchar in the foodchain
So then is the real purpose of using varchars, to save disk space? ( I realize this is probably a general database question, just trying to learn). + your datafile will be smaller which saves disk IO. In the end, the extra cost of the less efficient index as less than the gain from the faster access. So in the end you win speed. huh? With a variable record length, there's a lot of searching to get the position of the individual record. With a set size, the file handler knows exactly where record n is stored in the file. This has nothing to do with file size -- disks are random access devices. But, it is all explaind in the manual :) Exactly where in the manual did you find that piece of information? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 optimize and put in order the row?
I mean a database is like a file. a file in which there are written the rows in sequentially way. for example: NUMBER 2 65 ... 45 5 If I tell to mysql to store these rows in order like: NUMBER 1 4 ... 55 99 NOTE: not ORDER BY but store in the database (or in file) in this way: ordered! It will be more speed for Mysql if I'll ask a query like that: SELECT... FROM WHERE 50x10; I'm not talking about index but how to say to mysql the way of storing the data ( orderly ). How can I do that? I feel a tutorial coming on. Please let me know if my English is not good for you... Usually a database.table consists of two parts. The data part, and the index part. There can be more than one index part. There can be a data part with no index part. Let's think of the data part as a bookshelf. The shelf is the home of a number of books. Think of each book as a data row or record. If you remove one book from the shelf, and later want to add a new book, it might be able to fit in the space left. If it is too wide, it will have to be placed at the end of the shelf. If we only buy thin books, and we remove a large number of fat books, pretty soon the books along the shelf will be in no particular sequence - there will be lots of empty spaces in between and the books left on the shelf will be in an almost random order. A bit of a mess! Your first question: what you would like to do, is to organise the physical arrangement of data in the data part of the database. As you say, it would make it easier to find data in the database.table. The bookshelf is the same - if we rearrange the books on the shelf so that they are in some sequence (or 'order') it becomes easier to find the one on SQL database theory. Here's the bad news: we (users and programmers) have no ability to sequence the records/rows of data in the data part of a database. Why not? Because a database is not a bookshelf that you and I can view directly and use to select books/data. We go to the database management system (DBMS), in this case MySQL, and ask it to provide us with data - in other words we go to a librarian and say please find me the book on SQL database theory. The librarian is happy to do this for us, but how the books are kept/arranged is none of our business (your database is not a public library!). Now let's talk about the index part. A database table can have no index part, one index part, or many indexes. As you know the object of an index is to make a 'lookup' of data faster. An index is made up of one or more columns from the data part - if more than one column is used, then the different fields are concatenated to make one larger single field as the index. The other half of an index is a series of 'pointers'. We can't see them. These pointers belong to the librarian (the DBMS). A pointer connects a key value in the index part to the corresponding data row in the data part. Think of the (old) catalog cards that index books in a library - or at least they used to before computers came along and spoiled a good story... Because indexes are used to retrieve data, they ARE kept in sequence - and this is possible because they take up less space (than a whole data record). If a data row is removed from the data part, the corresponding index entry must be removed too - and all the other index entries in the index part are 'moved up' to make a new sequence. Similarly if a new data row is added, whilst it can go in at the 'end of the shelf' or in any available/spare space in the data part, its corresponding index must be inserted into the sequence of index entries and the rest of the index part of the database.table is 'moved up' to make enough free space so that this can happen. Fortunately all of that is the responsibility of the librarian (DBMS), and I for one am quite glad that we don't have to worry about it. Now let's get really adventurous. Let's have two index parts for the one data part of our database.table! Let's have one index that is sequenced according to the book's title, and a second which is sequenced according to its author's name. Now when a book is removed from the shelf/the data part, the librarian/DBMS must remove not just the data row, but TWO index entries - one from the list of authors, and one from the list of book titles. Similarly when a new book is added to the shelf/data part, the librarian must make a new entry in each of the two indexes in the index part. Now we can answer the question you thought up a few paragraphs ago: why are we not able/allowed to sequence the rows in the data part? Because if your database.table has more than one index, which of the two or more sequences will you choose to use to determine that order? To add to that, imagine the effort that would be required when a new book is added or an old one removed, if the entire database.table had to be reorganised to make free-space and to close up the spaces left. It's a quick
Re: varchar in the foodchain
On Fri, Nov 09, 2001 at 12:46:33AM +0100, Carsten H. Pedersen wrote: So then is the real purpose of using varchars, to save disk space? ( I realize this is probably a general database question, just trying to learn). + your datafile will be smaller which saves disk IO. In the end, the extra cost of the less efficient index as less than the gain from the faster access. So in the end you win speed. huh? With a variable record length, there's a lot of searching to get the position of the individual record. With a set size, the file handler knows exactly where record n is stored in the file. This has nothing to do with file size -- disks are random access devices. Jep, but in the end you win speed. ( Or at least: are suppoed to, your millage will vary, etc) But, it is all explaind in the manual :) Exactly where in the manual did you find that piece of information? 5.4.2 Get Your Data as Small as Possible One of the most basic optimisation is to get your data (and indexes) to take as little space on the disk (and in memory) as possible. This can give huge improvements because disk reads are faster and normally less main memory will be used. Indexing also takes less resources if done on smaller columns. .. * Use the most efficient (smallest) types possible. MySQL has many specialised types that save disk space and memory. But i read the advise literally somewhere. I'm searching.. -- The Moon is Waning Crescent (44% of Full) nieuw.nl - 2dehands.nl: 14531 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4.0 updated?
Hi, Is MySQL 4.0 Alpha updated periodically with bugfixes? i.e. Is it worth periodically re-downloading and re-installing MySQL 4.0 to ensure I have the most stable version? tnx, ~Mark. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Database Synchronization
Hi Is it possible to synchronize databases. Let me tell you the scenario. The client lives out of town and wants to do point-of-sale at their place of business. Internet connection is not very reliable. They already have a comprehensive database that runs at an ISP in town. I would like to set them up with their own server so that they can do their point of sale and then have the two databases 'synchronize'. Is this possible. Thanks Tim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: varchar in the foodchain
On Fri, Nov 09, 2001 at 12:46:33AM +0100, Carsten H. Pedersen wrote: + your datafile will be smaller which saves disk IO. In the end, the extra cost of the less efficient index as less than the gain from the faster access. So in the end you win speed. huh? With a variable record length, there's a lot of searching to get the position of the individual record. With a set size, the file handler knows exactly where record n is stored in the file. This has nothing to do with file size -- disks are random access devices. But, it is all explaind in the manual :) Exactly where in the manual did you find that piece of information? found another little note: 6.5.3.1 Silent Column Specification Changes ... * If any column in a table has a variable length, the entire row is variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer than three characters are changed to VARCHAR columns. This doesn't affect how you use the columns in any way; in MySQL, VARCHAR is just a different way to store characters. MySQL performs this conversion because it saves space and makes table operations faster. See section 7 MySQL Table Types. Still not the advise as I rememberd it. Probably reed it on this list -- The Moon is Waning Crescent (44% of Full) nieuw.nl - 2dehands.nl: 14531 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 4.0 updated?
When a new version is available it will have a new version number. The current version is 4.0.0 but there will almost certainly be a 4.0.1 soon. If you look at the change history in the documentation, there have already been changes put into 4.0.0. If you need quicker access to changes, you can download the source code from the bitkeeper tree which changes more frequently. Mark Maunder wrote: Hi, Is MySQL 4.0 Alpha updated periodically with bugfixes? i.e. Is it worth periodically re-downloading and re-installing MySQL 4.0 to ensure I have the most stable version? tnx, ~Mark. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Update MYSQL command with PHP
Question is there something wrong with this syntax when using the MYSQL Update command in PHP , where I change the record by users editing the fields on a web form then those are extracted to update a record in a table. Here's what I have tried I don't get any syntax errors with either of these attempts $query1 = UPDATE Qusers SET $field_str WHERE UserName='$username'; $result2 = mysql_query($query1); Second Example $query1 = UPDATE Qusers SET BillAmt='$billamt' WHERE UserName='.$username.' AND Qusers.RID ='.$keyid.'; $result2 = mysql_query($query1); Kory Wheatley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
lost in the Land of Oz Parking Lot (I hope this message makes it through!)
Dear Noble X: {I tried to email you but I failed, MISERABLY!! My AOL Screen Name, Cyberbean, came with attachments, I hope this mail makes it through the border of all that is good. Please Help! Thanks!} I am lost. I am a very VERY green newbie, and I am struggling on just how to begin. Basically, I have bought a book, entitled, PHP and MYSQL Web Development . , I have downloaded mysql-3.23.43.tar.gz, the install for windows document (yes I have not even made it passed the Install! Oh I am PATHETIC!) says to use Setup.exe for windows. The problem is I can not find that file anywhere. The bigger problem is, I do not know which 'platform' to enter any code in, and once entered, how do you run it as a web site???. I have been using FrontPage for my website, mothermachine.com (which is in a state of utter chaos) and found that I really do not like FrontPage. My questionable quest began when I tried to authenticate my message base, and I discovered, after a few wrong turns and dead ends, this whole new world. Basically if any of you can help me out by pointing me in a direction for beginners, I will be ecstatic and will return the favor if I can, maybe by, once I learn, helping out another newbie. I tell you, this message is a New Hope, if not a last resort. I have been hunched over my computer for quite some time. I have Windows 98 on an older computer which I am using to experiment with code. Can you help?. Thanks!!! Jason Mintel mail2web - Check your email from the web at http://mail2web.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: varchar in the foodchain
So then is the real purpose of using varchars, to save disk space? ( I realize this is probably a general database question, just trying to learn). + your datafile will be smaller which saves disk IO. In the end, the extra cost of the less efficient index as less than the gain from the faster access. So in the end you win speed. huh? With a variable record length, there's a lot of searching to get the position of the individual record. With a set size, the file handler knows exactly where record n is stored in the file. This has nothing to do with file size -- disks are random access devices. =if the column is indexed, then doesn't the index point at the particular block in the data file and the record's exact first-byte position within that block? - in which case there is no 'searching' of records, the index is searched and the corresponding rows retrieved (directly). =if the search is un-indexed (is that a word?) then each record will have to be visited during a SELECT, and much byte-counting as part of the searching will surely result. =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: lost in the Land of Oz Parking Lot (I hope this message makes it through!)
I think there is a package on Window called PHPtriad that installs Apache/MySQL/PHP all configured and everything for normal users (your case at this level). You should be able to find it trough download.com. On Thursday 08 November 2001 04:26 pm, [EMAIL PROTECTED] wrote: Dear Noble X: {I tried to email you but I failed, MISERABLY!! My AOL Screen Name, Cyberbean, came with attachments, I hope this mail makes it through the border of all that is good. Please Help! Thanks!} I am lost. I am a very VERY green newbie, and I am struggling on just how to begin. Basically, I have bought a book, entitled, PHP and MYSQL Web Development . , I have downloaded mysql-3.23.43.tar.gz, the install for windows document (yes I have not even made it passed the Install! Oh I am PATHETIC!) says to use Setup.exe for windows. The problem is I can not find that file anywhere. The bigger problem is, I do not know which 'platform' to enter any code in, and once entered, how do you run it as a web site???. I have been using FrontPage for my website, mothermachine.com (which is in a state of utter chaos) and found that I really do not like FrontPage. My questionable quest began when I tried to authenticate my message base, and I discovered, after a few wrong turns and dead ends, this whole new world. Basically if any of you can help me out by pointing me in a direction for beginners, I will be ecstatic and will return the favor if I can, maybe by, once I learn, helping out another newbie. I tell you, this message is a New Hope, if not a last resort. I have been hunched over my computer for quite some time. I have Windows 98 on an older computer which I am using to experiment with code. Can you help?. Thanks!!! Jason Mintel mail2web - Check your email from the web at http://mail2web.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: Update MYSQL command with PHP
$query1 = UPDATE Qusers SET $field_str WHERE UserName='$username'; $result2 = mysql_query($query1); It should be: update Qusers set field_name='$field_str' where username='$username'; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 command with PHP
Question is there something wrong with this syntax when using the MYSQL Update command in PHP , where I change the record by users editing the fields on a web form then those are extracted to update a record in a table. Here's what I have tried I don't get any syntax errors with either of these attempts $query1 = UPDATE Qusers SET $field_str WHERE UserName='$username'; $result2 = mysql_query($query1); Second Example $query1 = UPDATE Qusers SET BillAmt='$billamt' WHERE UserName='.$username.' AND Qusers.RID ='.$keyid.'; $result2 = mysql_query($query1); Kory, The PHP-db list (and archive) is full of answers to this question. The first example looks a bit suspect unless $field_str holds a set clause in the form: column_name=expression, and further that expression does NOT contain double quotes, eg a string value's delimiters. You should precede these with several function calls to 'open' the db, and should follow every mysql_...() call with an error check. Prevailing wisdom suggests putting an echo between the two lines, so that you can see exactly what will be passed as the query to MySQL. Finally, if there is any question, that output can be copied-and-pasted into a command line query or a MySQL administration tool to verify/confirm the SQL syntax. Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: lost in the Land of Oz Parking Lot (I hope this message makes it through!)
Is this your email address? I can send you all the files you need. Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 6:27 PM To: [EMAIL PROTECTED] Subject: lost in the Land of Oz Parking Lot (I hope this message makes it through!) Dear Noble X: {I tried to email you but I failed, MISERABLY!! My AOL Screen Name, Cyberbean, came with attachments, I hope this mail makes it through the border of all that is good. Please Help! Thanks!} I am lost. I am a very VERY green newbie, and I am struggling on just how to begin. Basically, I have bought a book, entitled, PHP and MYSQL Web Development . , I have downloaded mysql-3.23.43.tar.gz, the install for windows document (yes I have not even made it passed the Install! Oh I am PATHETIC!) says to use Setup.exe for windows. The problem is I can not find that file anywhere. The bigger problem is, I do not know which 'platform' to enter any code in, and once entered, how do you run it as a web site???. I have been using FrontPage for my website, mothermachine.com (which is in a state of utter chaos) and found that I really do not like FrontPage. My questionable quest began when I tried to authenticate my message base, and I discovered, after a few wrong turns and dead ends, this whole new world. Basically if any of you can help me out by pointing me in a direction for beginners, I will be ecstatic and will return the favor if I can, maybe by, once I learn, helping out another newbie. I tell you, this message is a New Hope, if not a last resort. I have been hunched over my computer for quite some time. I have Windows 98 on an older computer which I am using to experiment with code. Can you help?. Thanks!!! Jason Mintel mail2web - Check your email from the web at http://mail2web.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
127.0.0.1 problem
Hello, Are there any obvious reasons why mysql -h localhost works and mysql -h 127.0.0.1 does not. It says : ERROR 2003: Can't connect to MySQL server on '127.0.0.1' (110) /etc/hosts contain : 127.0.0.1 localhost as a first line. -- Best regards, Alex mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: lost in the Land of Oz Parking Lot (I hope this message makes it through!)
I am lost. I am a very VERY green newbie, and I am struggling on just how to begin. Basically, I have bought a book, entitled, PHP and MYSQL Web Development . , I have downloaded mysql-3.23.43.tar.gz, the install for windows document (yes I have not even made it passed the Install! Oh I am PATHETIC!) says to use Setup.exe for windows. The problem is I can not find that file anywhere. =Appendix A, page 793 - use the instructions for Windows and not those for *nix 1 did you download a Windows binary (not *nix, and not source)? 2 have you used WinZip or similar to extract the files to a temporary directory? The bigger problem is, I do not know which 'platform' to enter any code in, and once entered, how do you run it as a web site???. I have Windows 98 on an older computer which I am using to experiment with code. Can you help?. Thanks!!! =the questions are a little confusing. Your platform is Win98. To run through the material in the book, you need a 'platform' consisting of a web server eg PWS or Apache, plus PHP, and MySQL. =the installation instructions are a little 'thin'. Spending some time searching the PHP sites/boards will turn up any number of others - choose one that it Windows, Windows, and only Windows (duck when you say that or the eunuchs police will get you...) (the explanations that purport to cover both *nix and Windows are often really confusing, ignore them all) =BTW: it's a good book - at least I thought so once I realised that the feminist exclusivity of she also meant me (a mere male)! =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Transaction Problem
I am writing a system that requires transactions. I understand that I need to use Transaction-safe tables, such as BDB or InnoDB, but even when I do, I get an error when I try to roll back my transaction. Here is some SQL that illustrates my problem: I create a table of type BDB (failure is the same if I use InnoDB): CREATE TABLE Episodes( EpisodeID varchar(100) NOT NULL, RecordLock varchar(25), Primary Key (EpisodeID)) TYPE=BDB ; If you issue a SHOW CREATE TABLE Episodes statement, does the output indicate that the table is indeed of type BDB? If your server wasn't compiled with support for transactional tables, the table may default to MyISAM (and you won't get a warning, alas). I put a couple of records in it to have something to work with: INSERT INTO Episodes (EpisodeID, RecordLock) VALUES ('Boychoir', ''); INSERT INTO Episodes (EpisodeID, RecordLock) VALUES ('Demo', ''); I start a transaction and look at the contents of my table: BEGIN; SELECT EpisodeID, RecordLock FROM Episodes; I change something in the table, still within the transaction and check that it is changed: UPDATE Episodes SET RecordLock = 'DavidW' WHERE EpisodeID = 'Boychoir'; SELECT EpisodeID, RecordLock FROM Episodes; I discover (programmatically) that I need to roll the transaction back, so I do: ROLLBACK; I get the following message: ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled back SELECT EpisodeID, RecordLock FROM Episodes; I check again, and indeed the data is changed and the rollback failed. What am I doing wrong? I am using version 3.23.43-nt under Windows 2000. Thanks for your help, David Woods, Ph.D. Wisconsin Center for Education Research - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Simple JDBC Question
Please forgive the simplicity of the question, but I'm having trouble reading between the lines regarding the JDBC interface.I have the following simple code, which load the bridge driver, and then attempts to connect to the driver. The system can't make the connection. My question is the address section of the url. Where would it be looking for a database my-dsn, and if I have mySql located in the C: drive, what would the syntax appear like? Thanks for your help Mike Bitzko public static void initialize() { String query = SELECT * FROM emp; String url = jdbc:odbc:my-dsn; try { // Load the jdbc-odbc bridge driver Class.forName (sun.jdbc.odbc.JdbcOdbcDriver); System.out.println(.. Loading of the system driver completed ); DriverManager.setLogStream(System.out); // Attempt to connect to a driver. Each one // of the registered drivers will be loaded until // one is found that can process this URL System.out.println(.. Attempt to connect to a driver ); Connection con = DriverManager.getConnection (url, my-user, my-passwd); System.out.println(.. Attempt to connect is successful ); checkForWarning (con.getWarnings ()); === \jdk1.3.1_01\bin\javaw -classpath D:\IntroitSys\untitled1\classes;E:\JBuilder4\lib\jbcl.jar;E:\JBuilder4\lib\dx.jar;E:\JBuilder4\lib\beandt.jar;D:\jdk1.3.1_01\demo\jfc\Java2D\Java2Demo.jar;D:\jdk1.3.1_01\jre\lib\i18n.jar;D:\jdk1.3.1_01\jre\lib\jaws.jar;D:\jdk1.3.1_01\jre\lib\rt.jar;D:\jdk1.3.1_01\jre\lib\sunrsasign.jar;D:\jdk1.3.1_01\lib\dt.jar;D:\jdk1.3.1_01\lib\htmlconverter.jar;D:\jdk1.3.1_01\lib\tools.jar untitled1.Application1 .. Loading of the system driver completed .. Attempt to connect to a driver DriverManager.getConnection(jdbc:odbc:my-dsn) trying driver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@4a8cd1] *Driver.connect (jdbc:odbc:my-dsn) JDBC to ODBC Bridge: Checking security No SecurityManager present, assuming trusted application/applet JDBC to ODBC Bridge 2.0001 Current Date/Time: Thu Nov 08 17:46:05 PST 2001 Loading JdbcOdbc library Allocating Environment handle (SQLAllocEnv) hEnv=166007376 Allocating Connection handle (SQLAllocConnect) hDbc=166007544 Connecting (SQLDriverConnect), hDbc=166007544, szConnStrIn=DSN=my-dsn;UID=my-user;PWD=my-passwd RETCODE = -1 ERROR - Generating SQLException... Closing connection (SQLFreeConnect), hDbc=166007544 Closing environment (SQLFreeEnv), hEnv=166007376 getConnection failed: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified *** SQLException caught *** SQLState: IM002 Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Vendor: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JDBC driver recommendatons
Anyone have a preferred JDBC for MySQL? I need a driver that will be reliable under heavy load. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
undo
howdy. i have a mysql backed php application. has anyone ever come up with a (however kludgy) undo functionality for mysql in a php app? based on keeping a history somewhere? based on the update log? i'm thinking of just making some innodb tables, using transactions, and forcing my users to commit after each write. please let me know if there are any other possibilities... thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: JDBC driver recommendatons
Hi, -Original Message- From: Wally Flint [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 6:01 PM To: Mysql mailing list Subject: JDBC driver recommendatons Anyone have a preferred JDBC for MySQL? I need a driver that will be reliable under heavy load. Yes. It is MM.MySQL JDBC Driver. For more information refer to http://mmmysql.sourceforge.net/ Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ 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: Simple JDBC Question
Hi Michael, -Original Message- From: Michael Bitzko [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 5:57 PM To: [EMAIL PROTECTED] Subject: Simple JDBC Question Please forgive the simplicity of the question, but I'm having trouble reading between the lines regarding the JDBC interface.I have the following simple code, which load the bridge driver, and then attempts to connect to the driver. The system can't make the connection. My question is the address section of the url. Where would it be looking for a database my-dsn, and if I have mySql located in the C: drive, what would the syntax appear like? Thanks for your help Mike Bitzko public static void initialize() { String query = SELECT * FROM emp; String url = jdbc:odbc:my-dsn; try { // Load the jdbc-odbc bridge driver Class.forName (sun.jdbc.odbc.JdbcOdbcDriver); System.out.println(.. Loading of the system driver completed ); DriverManager.setLogStream(System.out); // Attempt to connect to a driver. Each one // of the registered drivers will be loaded until // one is found that can process this URL System.out.println(.. Attempt to connect to a driver ); Connection con = DriverManager.getConnection (url, my-user, my-passwd); System.out.println(.. Attempt to connect is successful ); checkForWarning (con.getWarnings ()); === \jdk1.3.1_01\bin\javaw -classpath D:\IntroitSys\untitled1\classes;E:\JBuilder4\lib\jbcl.jar;E:\JBuilde r4\lib\dx.jar;E:\JBuilder4\lib\beandt.jar;D:\jdk1.3.1_01\demo\jfc\Jav a2D\Java2Demo.jar;D:\jdk1.3.1_01\jre\lib\i18n.jar;D:\jdk1.3.1_01\jre\ lib\jaws.jar;D:\jdk1.3.1_01\jre\lib\rt.jar;D:\jdk1.3.1_01\jre\lib\sun rsasign.jar;D:\jdk1.3.1_01\lib\dt.jar;D:\jdk1.3.1_01\lib\htmlconverte r.jar;D:\jdk1.3.1_01\lib\tools.jar untitled1.Application1 .. Loading of the system driver completed .. Attempt to connect to a driver DriverManager.getConnection(jdbc:odbc:my-dsn) trying driver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcD river@4a8cd1] *Driver.connect (jdbc:odbc:my-dsn) JDBC to ODBC Bridge: Checking security No SecurityManager present, assuming trusted application/applet JDBC to ODBC Bridge 2.0001 Current Date/Time: Thu Nov 08 17:46:05 PST 2001 Loading JdbcOdbc library Allocating Environment handle (SQLAllocEnv) hEnv=166007376 Allocating Connection handle (SQLAllocConnect) hDbc=166007544 Connecting (SQLDriverConnect), hDbc=166007544, szConnStrIn=DSN=my-dsn;UID=my-user;PWD=my-passwd RETCODE = -1 ERROR - Generating SQLException... Closing connection (SQLFreeConnect), hDbc=166007544 Closing environment (SQLFreeEnv), hEnv=166007376 getConnection failed: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified *** SQLException caught *** SQLState: IM002 Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Vendor: The above error says, you didn't configured the MyODBC DSN 'my-dsn'. When you are using JdbcOdbc Bridge driver inorder to access MySQL through JAVA applications through MyODBC driver, you need to define MyODBC DSN also. So, first define this, and then try connecting, and hopefully it will. For more information about MyODBC, refer to its online manual at www.mysql.com/doc (section 8.3) Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ 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: run-all-tests always fails under reiserfs partition
Hi~: I do use a via chipset mother board. Today I tried the option notail, it really works!!! Thanks :) Julian PS: Do you have any idea about sgi's xfs? From: George Eric R Contr AFSPC/CVYZ [EMAIL PROTECTED] To: Z Julian [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: run-all-tests always fails under reiserfs partition Date: Thu, 8 Nov 2001 16:16:15 - FWIW, I'm not convinced reiserfs is ready for prime time, at least not on all hardware (Any chance you're running a Via chipset MB?). I've had some serious stability problems when trying out reiserfs that magically disapeared when I went back to ext2 (and now ext3). One thing that I've heard helps is to set the notail option when mounting a reiserfs partition. -Original Message- From: Z Julian [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 1:16 AM To: [EMAIL PROTECTED] Subject: run-all-tests always fails under reiserfs partition Hi~: My OS is RH7.1 with kernel version 2.4.2-2. Yestoday I upgraded my kernel to 2.4.14 with configuring it to support reiserfs as build-in capability. After that I created a reiserfs partition and mounted it successfully. Everything seemed to be OK. Then I installed mysql and located the install directory to the reiserfs partition. Mysqld started. OK again. And then I entered the /reiserfs/partition/mysql/sql-bench directory to run the perl script run-all-tests, things turned to be weird. I got the following display: * [root@server sql-bench]# ./run-all-tests --server=mysql Benchmark DBD suite: 2.13 Date of test:2001-11-08 15:33:30 Running tests on:Linux 2.4.14 i686 Arguments: Comments: Limits from: Server version: MySQL 3.23.41 ATIS: Total time: 49 wallclock secs ( 7.95 usr 1.67 sys + 0.00 cusr 0.00 csys = 9.62 CPU) alter-table: unable to handle kErneL paging request ** and the machine freezed. I tries several times, every time I got different result. Sometimes the kernel infomation displayed, such as register value, stack info and etc. Sometimes the machine auto rebooted. And sometimes my machine turned to be a ambulance and made terrible noises. But there is not a single time the tests finished successfully. Once I recovered the partition to ext2 file system. All those problems vanished and tests finished successfully. What's wrong? Confused Julian _ Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-Eric.George=peterson.af.mil@lists. mysql.com 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 _ Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: OT: Default forced on MySQL;
I just got back in from a nice day in the park with my kids and my parents. All I can say to defend myself is that I'm sorry I did not bow to you thy King. And I am sorry if I have my own opinions and personality. I will try to conform asap to Big Brother's wishes. And I am sorry that my apologies were not humiliating enough for you. And if that is not enough, then please continue to extract blood... ...in the meantime, I will continue where it really matters. Good luck to all. And good luck to MySQL. It is a great tool. Thanks for giving me the chance in my last email to set the record straight on my record. The archives will speak for themselves. At 04:18 PM 11/8/2001 +, you wrote: On Thursday 08 Nov 2001 14:53, DownloadFAST.com wrote: First of all, I am going to state right now that I have not witnessed this discussion first hand (probably a good thing, too). The comments here reffer to what you said in your email, and what can be found in the archives. Personally, I thought this was definitely the most amusing thread in recent memory... It wasn't particularly amusing to me. Especially when one of you who disagrees with me, decided to add my email to a bunch of adult spam lists. Do you have any evidence to corroborate this? If so I'm impressed. Please, tell us what your sources are - maybe we can use the information to reduce the amount of spam going around. Assuming (and you should know what assume does) in this particular instance is actually a very well known logical error: Post hoc, ergo propter hoc. (IIR my Latin correctly) It means: After it, therefore because of it. From a purely logical point of view, that argument doesn't make sense. IMHO, it is far more likely that your email address has been harvested by a mail bot. Accusing people without evidence in a public forum, especially after claiming seriousness on your own part is BAD practice, and not at all good for credibility. MySQL just better hope that I continue to love the product so much, that I do not post this thread for other corporations considering the professionalism of the community. That sounds threatening. Let's not start sabre-rattling here. You might just loose credibility. Remember your list is linked from the main MySQL.com web site, and I think that means you need to be cautious with how you swoop done on new people who come here representing their corporation. In fact, they are lurking and they are not impressed, given the supportive email I received privately. Representing in what way? There are good, helpful and friendly ways. There are also others that involve shoving your (not necessarily your corporation's) views (right or wrong, let's not go into it) down other people's throats. Speaking out against open source products by generalising, ESPECIALLY on a mailing list for an open-source product (if there is any truth in what you quoted somebody to have said) is asking for trouble. Especially after criticising the documentation that you obviously haven't read properly. I make oversights myself, as far as documentation reading goes. But at least I don't go in head-long convinced that I'm 100% right. I think what you are demonstrating quite effectively is that if someone does not agree with the standard line of thinking in the group, then they will be chastized by the group. I have had several people from the list email me privately and give me their support. Frankly, after having just read through the archives, I am absolutely stunned with the patience some people, especially Sinisa have shown you, in face of blatant provocation verging on abuse. Some of your comments, e.g. There are few poeple here trying to lock out any outsider with a controversial opinion. verge on paranoid. Have you looked at the MySQL source code? From your comments, I am pretty sure you haven't. And yet you feel you know enough about it to say that a modification is simple. You don't know enough to make that call. Sinisa does. Get over it. If you think you are that good, then go and make a patch and submit it for inclusion in the source! I hate to break this to you, but that's the way open-source software development is supposed to work. There is a not-so-fine line between constructive criticism and abuse. IMHO, you have crossed it. Then you go on to say: Sure there are those people trying to use MySQL to replace Oracle, but IMO they should be the ones to have caveats, not the majority. Oracle, MySQL, PostgreSQL, etc. are all good products - and they are all good at different things. It all boils down to cost effectiveness and performance. If Oracle is good for you, and you can afford it - go for it. The whole point of there being multiple products is that you can pick the one the most closely matches your requirements. MySQL documentation has a very nicely reasoned PostgreSQL vs. MySQL section. After having read it, at least I know that MySQL is developed by
Re: IBM DB2 - to - mySQL
Jon, It seems you are still in the planning stage. First, if you have good documentation on the DB2 (i.e. ER Diagrams, schema etc.) become familiar with those for the purpose of maintaining the logic as you develop towards your MySQL sink. Know how applications that run against the DB2 database utilize it such as transactions or simply static data storage. Some of the firms I have worked with that were DB2 shops (MVS to OS/2) usually had libraries of utilities written in REXX for running jobs or everyday upkeep. If those are available to you, they might give you some ideas in your effort to migrate the tables and eventually the data. My experience with writing utilities in Java has been good. I found that writing a program for installing an application also required a utility to create the tables. Then another quick and dirty utility to insert all the static data (AMA CPT Codes) the application would use. I wrote that in Java so that the data could be retrieved from my web server and installed to workstations or laptop systems. I tested the Java program on DB2 tables and I am still in the process of testing them on MySQL and dumping the data from the tables to check for consistency or errors. As you are aware, if you change the logical or physical nature of the database even minor changes in the process of migration, work seems to grow exponentially on the application side. If you consider the DB2 - XML with Java programming and then some PHP, PERL, C++, look to reduce redundancy in your effort and plan to spend time testing to make sure you reach your goal of maintaining the table logic and data from source to sink. Regard, John Wubbel On 7 Nov 2001, at 18:16, Jon Shoberg wrote: Anyone know of method or resources for taking tables from a DB2 database and migrating them to mySQL tables? My preferred path would be from DB2 to XML docs via java programming and then mySQL migration by some API (PHP, PERL, C++). I'm writing my own programs here. What I am interested in are the steps to maintaining the table logic and data from source to sink. I'm usnig mySQL on the other end for remote web work. any thoughts ? jon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
New fork of MySQL
I have not read the MySQL license in detail. Does it allow someone or a group to start another fork of the source that is independent from the current developers? If yes, is any one else interested in starting a fork in which the primary goal would be to improve the smaller todos and performance for small sites (the majority who use MySQL)? It seems to me that the direction of MySQL is now heading more towards big sites given the features in 4.0. Since people in this list have challenged me, I have decided it would be best to rise to their challenge and create a whole other fork if possible. I also think we could create a community that is more tolerant of ideas and dissent. Again my proposal would be for a very small community of core developers, and for a very narrow focus of basically taking the stable 3.23 release and merely refining it. And try to make a product to sell for profit which would be more targetted towards the newbie user who wants to pay $100 for a database for his web site. And the core developers would share the profits. We would keep this group small so as to avoid the politics and inefficiences of large focuses. But we would maintain professional lines of communication with all users and readily accept their needs and dissent. Any one interested in trying to do something like this and make a profit while doing so?? I understand we would have to donate our work back to open source and I don't see a conflict with that. This would remove MySQL core group from the annoyance of people like me who just want a solid 3.23 with the little refinements done. For those who outgrow our product, they could easily migrate to the full MySQL 4.x and later. Let me know if you think my idea has merit. But please no personal attacks and all that other noise. Just to the point if we can. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New fork of MySQL
%% DownloadFAST.com [EMAIL PROTECTED] writes: dc I have not read the MySQL license in detail. MySQL is under the straight GPL. -- --- Paul D. Smith [EMAIL PROTECTED] HASMAT--HA Software Mthds Tools Please remain calm...I may be mad, but I am a professional. --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New fork of MySQL [wssql.com]
So far, one developer of MySQL has emailed me and said he would help. I propose we wait to see how many developers are interested, then take a vote how to structure. If we don't get enough interested developers, then I guess that means the proposal dies. I am not interested in being in control. I would just want to be a contributor. Thinking of a possible name, I start by suggesting Web Site SQL, which I think is direct to MySQL's original focus and broad base. Thus I have registered the wssql.* domains, and will donate them to the project if it happens. Once again, the exact manifesto of this proposed fork could be determined by vote, but my suggestion for the necessity of a new fork is to provide a focus on refining the stable 3.23, rather than trying to compete with Oracle (which appears to be where MySQL is headed with 4.0). If any one else has little things they would like to see improved faster in 3.23 without the need for the complexity of making huge structural changes stable, and if robustness and refinement are your credo over trying to add every database feature for big commercial sites. Then I think that is more or less what I am proposing. A MySQL for simple to medium web sites. Focus could be placed on making the refinements in both code and the interface with users, so that a larger sphere of beginners could be successful. For example, a much improved manual could be created which is more for novice users than technophytes. Again let me emphasize that this would provide a larger base for MySQL and funnel the higher end users to MySQL in their growth path. Even a seasoned developer, might use wsSQL for simple projects and MySQL for advanced ones. As always, the idea is to use the best tool for the job, and to have a tool which is focused on the needs of your job. Shelby Moore CEO DownloadFAST.com, Inc. CEO CoolPage.com (3Dize, Inc.) programmer of Cool Page, Art-o-matic, WordUp, TurboJet key contributor on DownloadFAST, FONTZ!, PhotoModeler, Painter, Dabbler, etc.. 206-374-2943 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: varchar in the foodchain
It won`t alway give you better performance. But take a table like this: (id int unsigned auto_increment, emailadress char(255) ) Suppose the average emailadress is 30 characters. If you have more than a trivial amount of entrys you are wasting a lot of space. Space which all has to be cached bij your OS. Space you will all have to read from disk if you do a like search or cannot use an index or whatever. Tables with variable length rows can get ugly if not optimized frequently. We had one which was taking 2.5 sec to do an indexed query, and when we optimized the table it dropped to .2 sec. But as long as you keep your tables optimized, variable length rows can be faster. The main efficiency concern, though, is the size of your indexes. MySQL keeps your indexes in memory, so smaller indexes are better. That is why it is best to use hash values when indexing long character strings (or even fairly short ones). A 32-bit hash value of a 20-character field takes 1/5 the space. That means five times as much key can be in memory at once. Hope that makes sense... Steve Meyers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: String composite key vs auto_increment
Let's say I have a table of authors with columns for last name and first name. Is there any general guideline re using a separate integer for the primary key as opposed to a combination of the last and first names as the key? I ask because by using the names, this would prevent duplicate entries into the db, right? Whereas using a separate integer key would not prevent this--you'd have to search for the author to see if it was already in the db before inserting to avoid dupes, right? Yes. Yes. On the second point, you would want to make a [non-unique] key on the first and last name columns. I think he actually wants a unique key here, since he wants to prevent duplicate entries. Assume I am not concerned about there being two different Joe Smith authors that are different people. I only want to associate an author name with a book. The column you seek is an integer column with the auto_increment flag, e.g.: CREATE TABLE authors ( last_name char(64) DEFAULT '' NOT NULL, first_name char(64) DEFAULT '' NOT NULL, author_idx integer NOT NULL AUTO_INCREMENT, PRIMARY KEY( author_idx ), KEY( last_name(20), first_name(20)), KEY( first_name(20)) ); The key on only first_name is there in case you query on just the first_name. The manual will tell you lots more about auto_increment and how keys are used. b. If searches will always be on exact matches, then use a hash value for the primary key -- it's an integer, will allow quick lookups on the author name, and will prevent duplicates. In essence, it gives the best of both worlds, with one exception: you can't do partial lookups or type searches. Steve Meyers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Get real mysqld hostname
I'm looking for a programatic way to obtain the real FQDN of the myqld server, not the one used to connect to the server. Here's the scenario, several servers running mysqld are behind a virtual IP so when you connect to mysqld you do not know which server you are really connected to. The get_host_info only returns the name used to connect to the virtual address. I've checked the variables table but the hostname is not there either. I can solve the problem by creating a database with the name of the host but that's not very elegant nor can I use dots for the IP or FQDN as the db name. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: String composite key vs auto_increment
That's not really true. You can use an auto_increment field as the primary key and create a seperate UNIQUE index that combines both the firstname and lastname fields that will be inforced for inserts. Usually its easier to work with integers as primary keys, especially when you reference them in other tables and such. I assume its slightly faster for MySQL to work with shorter integers than longer strings as primary keys but I could be wrong. Chris It's not just slightly faster -- it's WAY faster, especially as your tables grow larger. Steve Meyers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New fork of MySQL
I have not read the MySQL license in detail. Does it allow someone or a group to start another fork of the source that is independent from the current developers? The MySQL source is under the GPL. Any fork must also be under the GPL. You may sell your forked MySQL, but you must also provide the source code. If yes, is any one else interested in starting a fork in which the primary goal would be to improve the smaller todos and performance for small sites (the majority who use MySQL)? It seems to me that the direction of MySQL is now heading more towards big sites given the features in 4.0. Even though I run a small site, I very much like the direction MySQL 4.0 is headed. Features like foreign keys, triggers, and subselects can help small sites as much as big sites (subselects are definitely the least useful feature of those three though...). Features like replication (already in 3.23) are definitely geared more towards big sites. I understand we would have to donate our work back to open source and I don't see a conflict with that. This would remove MySQL core group from the annoyance of people like me who just want a solid 3.23 with the little refinements done. For those who outgrow our product, they could easily migrate to the full MySQL 4.x and later. Let me know if you think my idea has merit. But please no personal attacks and all that other noise. Just to the point if we can. I think it would be more useful to work on the main branch and add extra value to it, such as Heikki has done. That way all users of MySQL can benefit from your fixes, etc. Steve Meyers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New fork of MySQL
[snip] The MySQL source is under the GPL. Any fork must also be under the GPL. You may sell your forked MySQL, but you must also provide the source code. Thanks. No resistence from me about publishing source. Even though I run a small site, I very much like the direction MySQL 4.0 is headed. Features like foreign keys, triggers, and subselects can help small sites as much as big sites (subselects are definitely the least useful feature of those three though...). Features like replication (already in 3.23) are definitely geared more towards big sites. I understand and respect this point of view, and my point of view is counterintuitive. I hope you do not mind if I say there is a big difference between can and will in the above context. I may use all those features someday, but right now I am not, and beginners have other priorities and hurdles to cross first. Marketing is targetting. Effective development is focus on target. I suggest a good book to everyone. It is entitled The 80/20 Rule. It basically says that you do 20% effort for 80% result, and leave the 80% effort and 20% result for your competitor. I think it would be more useful to work on the main branch and add extra value to it, such as Heikki has done. That way all users of MySQL can benefit from your fixes, etc. I RESPECTFULLY disagree because: 1. Integrating changes in an ever more complex code base, can get more and more inefficient. 2. It will be a while before 4.x is stable. Every change we want, has to wait for the rest of MySQL's grand focus to become stable in each iteration. This is not efficient for the target. 3. It is not well focused. (Please don't attack me personally for expressing a strong opinion. I have said nothing personal here) Steve Meyers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C programming problems and borland
I have been trying to write a client using Borland C++ 5.2 running on W2000. The client needs to be text based not windows i.e. DOS!! (yeah yeah I know...but this is required to run on an older slower machine with a very large database). The problems are occuring at build time when I cannot seem to be able to link to the required libraries. I have previously built a client for MySQL in Linux using Gtk widgets which did not have any problems compiling and running. This situation is becoming frustrating and I would dearly love some assistance. I am fluent in programming with C but not C++. Cheers, Ray Brown - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New fork of MySQL
I think it would be more useful to work on the main branch and add extra value to it, such as Heikki has done. That way all users of MySQL can benefit from your fixes, etc. IMHO I think this would be best too, I know I would like both the newer/forthcoming features in the 4.x branch, but would also greatly appreciate any new features and stability that you or any other members of teh community could add. This is one of the greatest aspects of the Open Source Model. Not to disclude the ability to make your own fork, but in this case I really wouldn't see a need to keep any updates you make separate. -- Jayce^ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 coonecting mysql remotely
Dear all I have an application running in a small network where: Machine 1 is the pdc for user authentication Machine 2 is the mail Exchange server for emails/calendar/contacts Machine 3 is the database server with (LDAP,Oracle, MSSQL and MYSQL) MAchine 4 is the aplication + webserver for Development and MAchine 5 is the aplication + webserver for DEMO. Machine 4 has MYSQL installed locally also. The application runs fine. I supposed it's because the local database that is there. Machine 5 has no local database. The aplication is supposed to grab the data from machine 3. For all databases the application is doing it OK, except for MYSQL. I get a message complaining about my user root@machine5. My question is: Why MYSQL is appending the machine name to the username to do the authentication? Even if I point to machine 4 I get the same error. How can I solve this issue? Any help is welcome. Thanks Siomara PS: Besides the root that comes with the installation I created a root user with xyzxyz as password. This root/xyzxyz is the one I am trying to connect with. I have done that for both machines that have MYSQL _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Actively contributing to MySQL development
Hi Shelby, You wrote: I would just want to be a contributor. Excellent! You, and anyone else, can be a contributor to MySQL development. There is some special info in the manual about this: http://www.mysql.com/doc/M/y/MySQL_internals.html See also http://www.mysql.com/doc/I/n/Installing_source_tree.html We frequently receive very good code patches, and as the users know these are much appreciated. We also get other useful feedback such as issues for the manual. You may find a list of some of the contributors in the past at http://www.mysql.com/doc/C/o/Contributors.html With regard to the copyright and licensing of MySQL, you can find more information here: http://www.mysql.com/doc/C/o/Copyright.html Amongst other things, it is important to note that the manual is not distributed under GPL. We look forward to seeing your contributions! Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ 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: New fork of MySQL
Well I would try to leave that up to the people who want to be involved. But I would say that a good place to start might be here: http://www.mysql.com/doc/T/O/TODO_future.html Speeding up the backlog of little things as priority over the major structural changes, which IMHO are away from MySQL's original fast + simplicity focus. Also to perhaps focus more on speed and optimizations. And/or to focus on installation and usage issues for beginners (remember that # of web sites will double every year or soemthing like that). This is very inline with the focus of my other business, CoolPage.com (web page creation for beginners), so I can deliver massive traffic to such a product, and instant profitability. If coolpage.com did a wysiwyg interface to the DB then we could sell them like hot pancakes. :-) I want to see what other people want to do first. The proposal is fluid. At 10:18 PM 11/8/2001 -0800, you wrote: What specific issues are you focusing on? DownloadFAST.com wrote: More points about proposed wsSQL: 1. Another point is that any changes in a separate fork can always be integrated back into the main fork. Nothing is stopping that. I am just proposing some advantages as to why it shouldn't be the minor fork's responsibility to do that. 2. I would not decide this any way. It would be by vote of those who were interested to work on the project. 3. The ultiimate determinant of what the market wants, is to try and find out which fork becomes more popular. I lot can be learned for both forks from such an endeavor. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New fork of MySQL
Just so you know I am not blowing wind on possible speed enchancement, please let me add that one of my former talents was assembler code. Not to blow my own horn, but simply to state as fact relevant here, I was able to speed up Painter's core paint routines by perhaps 30 - 50%. So although algorithmic changes are usually the largest wins, that is an example one possible way to try to get more speed on some crucial indexing routines perhaps. I'd have to dig into the source before I could say specifically. Then again right now, my personal focus is simply to get some refinements more quickly and with less politics. At 10:18 PM 11/8/2001 -0800, you wrote: What specific issues are you focusing on? DownloadFAST.com wrote: More points about proposed wsSQL: 1. Another point is that any changes in a separate fork can always be integrated back into the main fork. Nothing is stopping that. I am just proposing some advantages as to why it shouldn't be the minor fork's responsibility to do that. 2. I would not decide this any way. It would be by vote of those who were interested to work on the project. 3. The ultiimate determinant of what the market wants, is to try and find out which fork becomes more popular. I lot can be learned for both forks from such an endeavor. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New fork of MySQL
On Thu, 2001-11-08 at 23:42, DownloadFAST.com wrote: Just so you know I am not blowing wind on possible speed enchancement, please let me add that one of my former talents was assembler code. Not to blow my own horn, but simply to state as fact relevant here, I was able to speed up Painter's core paint routines by perhaps 30 - 50%. So although algorithmic changes are usually the largest wins, that is an example one possible way to try to get more speed on some crucial indexing routines perhaps. I'd have to dig into the source before I could say specifically. Then again right now, my personal focus is simply to get some refinements more quickly and with less politics. I guess my main concern is that it seems like your main reason for forking is political disagreement with developers, and making the code better is only a secondary reason. If that's the case, I respect your decision, but I think the best solution for the end users would be to work out your differences of opinion and try to work together. If your goals are too far different from the MySQL project's goals, then of course maybe a fork is the only good solution. However, I haven't seen anything in your reasoning that would be contrary to the goals of the MySQL developers. On the other hand, MySQL is known for being fast, and for being easy to use for beginning users. I'd like to see what specific refinements you're talking about -- the main reason for version 4.0 is to allow a lot of the features that are on the TODO list. I'm not trying to be disagreeable, I'm just not quite convinced yet and would like to hear more from you about your reasoning and justification for forking the code, as opposed to contributing to the main MySQL code (even if it is in the 3.23 branch). Steve Meyers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hadware SPEC
Hai, We dont know exactly how to count spec hw (CPU+RAM) to handle big database, the manual not cover it. I mean everymonth always add complex data on several db, than 1 year maybe handle 1 GB of data, how i count a RAM and (or) CPU for speed. Any document or url where i can read. We can assumming for oracle not for MySQL/DB2. Thanks ~yusril~ -- __ (oo) / \/ \ GnuPg public information pub 1024/EBD26280 `V__V' A9A9 8F57 9E9D 14E3 05B4 3EDB C241 A313 EBD2 6280 Beware of low-flying butterflies. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New fork of MySQL
Steve I take your input very constructively and I personally will definitely reconsider and contemplate more on your point. In fact, I already emailed the developers yesterday, and asked if I could pay to have the particular feature I wanted prioritized at this time. And I don't think that was to slight any one, and I don't think that outcome would be negative for any one either. In general though, I think it sort of like Windows. Every new release is a major cost to the installed base to upgrade. Many people here may not think twice about the cost of upgrading to 4.x, because many people here may enjoy the technology. But in business, we don't like change. We like the same thing to work the same way over and over again. The more repetitions we can get, then the higher the economy of scale and thus the higher the profit (and I lot more time for me to spend with my family). So my focus is more on taking what I already thought was wonderful (3.23) and focusing on making it perfect for the needs of what most people do with a database and a typical web site. And being able to that with less noise and more directness. I tend to think no one here will be interested in that kind of focus, because he sort of flies in the face of the granduer. I may just make my own private fork, and maybe bundle it with Cool Page. I really don't know yet. I will wait to see what other people want. OFF TOP MY HEAD: But I am keeping in mind that the people on this list are developers and knowledgeable users (or at least the ones paying attention to this topic). I think this is quite different from the needs that actual users might express. I think a lot of potential users want a database on their web site, and haven't the slightest clue how to achieve it. I could close that gab with my Cool Page product (have been planning something like this for a while, e.g. drag+drop forms and database integration). And I would like to have access to a database that wasn't trying to compete with Oracle, because I just don't feel those features will do anything for this market I see. And it just adds complexity. Apologies my thoughts are not too organized here. I will stand back and listen for a while and think about this more. At 12:00 AM 11/9/2001 -0700, you wrote: On Thu, 2001-11-08 at 23:42, DownloadFAST.com wrote: Just so you know I am not blowing wind on possible speed enchancement, please let me add that one of my former talents was assembler code. Not to blow my own horn, but simply to state as fact relevant here, I was able to speed up Painter's core paint routines by perhaps 30 - 50%. So although algorithmic changes are usually the largest wins, that is an example one possible way to try to get more speed on some crucial indexing routines perhaps. I'd have to dig into the source before I could say specifically. Then again right now, my personal focus is simply to get some refinements more quickly and with less politics. I guess my main concern is that it seems like your main reason for forking is political disagreement with developers, and making the code better is only a secondary reason. If that's the case, I respect your decision, but I think the best solution for the end users would be to work out your differences of opinion and try to work together. If your goals are too far different from the MySQL project's goals, then of course maybe a fork is the only good solution. However, I haven't seen anything in your reasoning that would be contrary to the goals of the MySQL developers. On the other hand, MySQL is known for being fast, and for being easy to use for beginning users. I'd like to see what specific refinements you're talking about -- the main reason for version 4.0 is to allow a lot of the features that are on the TODO list. I'm not trying to be disagreeable, I'm just not quite convinced yet and would like to hear more from you about your reasoning and justification for forking the code, as opposed to contributing to the main MySQL code (even if it is in the 3.23 branch). Steve Meyers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 crashes on a select query from select.test
MySQL crashes, when number of entries in table is greater than some number 'X', in mf_radix.c file on execution of a select query. Optimization used: O2 Please suggest some approach to debug this crash. It works fine with O0 optimization option. __ Do You Yahoo!? Find a job, post your resume. http://careers.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