Re: multiple instances in win 7 -- any idea
Hi Charles, it is very easy to run multiple mysql instances and of different versions as well on the same server, including windows. You just have to download the .zip version, NOT the installer. The archive you get is basically a separate independent mysql instance that can live fully in its own directory. Unzip the archive/s in separate folders and create/copy the my.ini in the root of that folder changing just two parameters: ex: c:\mysql3331 c:\mysql3332 Instance #1 - file:c:\mysql3331\my.ini [client] port = 3331 socket = /tmp/mysql3331.sock [mysqld] port = 3331 socket = /tmp/mysql3331.sock basedir = c:\mysql3331 Instance #2 - file:c:\mysql3332\my.ini [client] port = 3332 socket = /tmp/mysql3332.sock [mysqld] port = 3332 socket = /tmp/mysql3332.sock basedir = c:\mysql3332 set the right paths and enjoy. you can quickly test if the server starts normally by going into each basedir with the prompt and running bin\mysqld.exe then on different terminals bin\mysql.exe -urootto login Cheers Claudio 2012/5/14 Shawn Green shawn.l.gr...@oracle.com On 5/13/2012 6:53 PM, Brown, Charles wrote: I'm trying to install multiple instances of mysql on windows 7, 64bit. 3hrs into the job, I'm not making progress. Does anyone have an idea? 1) The installers are designed to work on single-instance installs or upgrades. 2) You only need one install to run multiple copies of the same release. The trick is to configure the necessary parts to be unique values between the instances 3) Each instance needs its own copy of unique data. No two active instances can share data. 4) The list of other items that must be unique per instance is listed here: http://dev.mysql.com/doc/**refman/5.5/en/multiple-**servers.htmlhttp://dev.mysql.com/doc/refman/5.5/en/multiple-servers.html 5) (mailing list rule) - avoid hijacking other threads 6) (general support advice) - when having a problem, try to provide descriptive details regarding what you are trying to do, any commands you are using, and what types of failures you are encountering (including any error messages you are receiving). This usually allows anyone trying to help you to respond in a more focused and less general way. Warmest regards, -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Claudio
Re: multiple instances in win 7 -- any idea
On 5/13/2012 6:53 PM, Brown, Charles wrote: I'm trying to install multiple instances of mysql on windows 7, 64bit. 3hrs into the job, I'm not making progress. Does anyone have an idea? 1) The installers are designed to work on single-instance installs or upgrades. 2) You only need one install to run multiple copies of the same release. The trick is to configure the necessary parts to be unique values between the instances 3) Each instance needs its own copy of unique data. No two active instances can share data. 4) The list of other items that must be unique per instance is listed here: http://dev.mysql.com/doc/refman/5.5/en/multiple-servers.html 5) (mailing list rule) - avoid hijacking other threads 6) (general support advice) - when having a problem, try to provide descriptive details regarding what you are trying to do, any commands you are using, and what types of failures you are encountering (including any error messages you are receiving). This usually allows anyone trying to help you to respond in a more focused and less general way. Warmest regards, -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
multiple instances in win 7 -- any idea
I'm trying to install multiple instances of mysql on windows 7, 64bit. 3hrs into the job, I'm not making progress. Does anyone have an idea? This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)
Hi Eric, At least with Maatkit, you get transparency. We make a concerted effort to update the RISKS section of each tool with each release, so there is full disclosure. Fair enough, but I still found the warnings a little too scary. A more complete explanation of the exact nature of the bugs and the exact circumstances under which I should be concerned about triggering them would have increased my comfort level. I've made a note to review these, because the ones I checked have kind of drifted from their original purity. I updated the RISKS section for mk-table-sync the other day. I checked it and agreed with you -- it didn't distinguish between cases where there is actually a risk, or cases where the tool would just refuse to work (which isn't a risk IMO). And it sounded ambiguously scary in a don't-blame-us, we're-avoiding-your-eyes kind of way because of passive voice. You can see my changes here: http://code.google.com/p/maatkit/source/detail?r=5269 I think that's a pretty realistic balanced statement of risk: you are playing with a powerful tool, so learn how to use it first. Thanks for the feedback! BTW, there's also a Maatkit mailing list that I watch closely: http://groups.google.com/group/maatkit-discuss - Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)
Hi Baron, I'm the primary author of Maatkit. Awkward... :-) What can I say -- you could go buy a commercial off-the-shelf tool and believe the song and dance they feed you about the tool being perfect. There's not a single commercial software solution in our toolbox. We're big fans of CentOS, LVS, heartbeat, ldirectord, tomcat, MySQL, Xen, pureFTP, and more. We've been happy with the performance and reliability of all of our FOSS tools. I'm definitely not a Kool-aid drinker when it comes to commercial product marketing. At least with Maatkit, you get transparency. We make a concerted effort to update the RISKS section of each tool with each release, so there is full disclosure. Fair enough, but I still found the warnings a little too scary. A more complete explanation of the exact nature of the bugs and the exact circumstances under which I should be concerned about triggering them would have increased my comfort level. I think Maatkit is by far the best solution for live master-slave sync in most real-world situations. We'll give it another look. -- Eric Robinson Disclaimer - December 9, 2009 This email and any files transmitted with it are confidential and intended solely for Baron Schwartz,Gavin Towey,Tom Worster,my...@lists.mysql.com. If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any views or opinions presented in this email are solely those of the author and might not represent those of . Warning: Although has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments. This disclaimer was added by Policy Patrol: http://www.policypatrol.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)
Eric, There are ways to resync data that don't involve all this as well: Maatkit has some tools I've looked with great interest at Maatkit, but their tools are replete with warnings about dangers, bugs, and crashes. They certainly do not inspire confidence. I'm the primary author of Maatkit. What can I say -- you could go buy a commercial off-the-shelf tool and believe the song and dance they feed you about the tool being perfect. At least with Maatkit, you get transparency. We make a concerted effort to update the RISKS section of each tool with each release, so there is full disclosure. I think Maatkit is by far the best solution for live master-slave sync in most real-world situations. - Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)
Let's face it, sometimes the master and slave get out of sync, even when 'show slave status' and 'show master status' indicate that all is well. And sometimes it is not feasible to wait until after production hours to resync them. We've been working on a method to do an emergency hot-resync during production hours with little or no user downtime. What do you guys think of this approach? It's only for Linux, though... 1. Shut down the slave and remove its replication logs (master.info and *relay* files). 2. Do an initial rsync of the master to the slave. Using rsync's bit-differential algorithm, this quickly copies most of the changed data and can be safely be done against a live database. This initial rsync is done before the next step to minimize the time during which the tables will be read-locked. 3. Do a 'flush tables with read lock;reset master' on the master server. At this point, user apps may freeze briefly during inserts or updates. 4. Do a second rsync, which goes very fast because very little data has changed between steps 2 and 3. 5. Unlock the master tables. 6. Restart the slave. When you're done, you have a 100% binary duplicate of the master database on the slave, with no worries that some queries got missed somewhere. The master was never stopped and users were not severely impacted. (Mileage may vary, of course.) We've tried this a few times and it has seemed to work well in most cases. We had once case where the slave SQL thread did not want to restart afterwards and we had to do the whole thing again, only we stopped the master the second time. Not yet sure what that was all about, but I think it may have been a race issue of some kind. We're still exploring it. Anyway, comments would be appreciated. -- Eric Robinson Disclaimer - December 4, 2009 This email and any files transmitted with it are confidential and intended solely for my...@lists.mysql.com. If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any views or opinions presented in this email are solely those of the author and might not represent those of . Warning: Although has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments. This disclaimer was added by Policy Patrol: http://www.policypatrol.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)
i have two questions. (1) innodb? (2) why delete slave logs when you can restart the slave with --skip-slave and then use CHANGE MASTER TO? tom On 12/4/09 6:34 AM, Robinson, Eric eric.robin...@psmnv.com wrote: Let's face it, sometimes the master and slave get out of sync, even when 'show slave status' and 'show master status' indicate that all is well. And sometimes it is not feasible to wait until after production hours to resync them. We've been working on a method to do an emergency hot-resync during production hours with little or no user downtime. What do you guys think of this approach? It's only for Linux, though... 1. Shut down the slave and remove its replication logs (master.info and *relay* files). 2. Do an initial rsync of the master to the slave. Using rsync's bit-differential algorithm, this quickly copies most of the changed data and can be safely be done against a live database. This initial rsync is done before the next step to minimize the time during which the tables will be read-locked. 3. Do a 'flush tables with read lock;reset master' on the master server. At this point, user apps may freeze briefly during inserts or updates. 4. Do a second rsync, which goes very fast because very little data has changed between steps 2 and 3. 5. Unlock the master tables. 6. Restart the slave. When you're done, you have a 100% binary duplicate of the master database on the slave, with no worries that some queries got missed somewhere. The master was never stopped and users were not severely impacted. (Mileage may vary, of course.) We've tried this a few times and it has seemed to work well in most cases. We had once case where the slave SQL thread did not want to restart afterwards and we had to do the whole thing again, only we stopped the master the second time. Not yet sure what that was all about, but I think it may have been a race issue of some kind. We're still exploring it. Anyway, comments would be appreciated. -- Eric Robinson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)
(1) innodb? It's an off-the-shelf application that uses MyISAM tables. It is possible to convert to innodb, but I have not been sold on innodb in terms of its performance characteristics for this particular application. Maybe I've been reading the wrong stuff. Do you have general thoughts on the differences with respect to performance? (2) why delete slave logs when you can restart the slave with --skip-slave and then use CHANGE MASTER TO? Well... I guess mainly because I didn't know about that option! I thought I needed to fake out mysql on this, but it sounds like I can just do 'flush tables with read lock;reset master;' on the master and 'change master to...;' on the slave. So cool. Thanks for the input! -- Eric Robinson Disclaimer - December 4, 2009 This email and any files transmitted with it are confidential and intended solely for Tom Worster,my...@lists.mysql.com. If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any views or opinions presented in this email are solely those of the author and might not represent those of . Warning: Although has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments. This disclaimer was added by Policy Patrol: http://www.policypatrol.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)
On 12/4/09 11:59 AM, Robinson, Eric eric.robin...@psmnv.com wrote: (2) why delete slave logs when you can restart the slave with --skip-slave and then use CHANGE MASTER TO? Well... I guess mainly because I didn't know about that option! I thought I needed to fake out mysql on this, but it sounds like I can just do 'flush tables with read lock;reset master;' on the master and 'change master to...;' on the slave. So cool. Thanks for the input! 16.1.1 is probably my favorite chapter of the manual. 16.1.1.8 is particularly worth a read. http://dev.mysql.com/doc/refman/5.0/en/replication-howto-existingdata.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)
I think he's trying to say that this method wouldn't work for innodb, unless you copied files from an LVM snapshot, or something similar. I would say that it's very important to know why data is getting out of sync between your master and slave. Fixing those root causes would eliminate the need for this. There are cases where non-deterministic queries will produce different results, but that's what row based replication is supposed to solve =) There are ways to resync data that don't involve all this as well: Maatkit has some tools that compare data between servers, and can fix them with queries. No stopping the slave or locking the master necessary. I've used them in production with good results. Regards, Gavin Towey -Original Message- From: Robinson, Eric [mailto:eric.robin...@psmnv.com] Sent: Friday, December 04, 2009 9:00 AM To: Tom Worster; mysql@lists.mysql.com Subject: RE: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much) (1) innodb? It's an off-the-shelf application that uses MyISAM tables. It is possible to convert to innodb, but I have not been sold on innodb in terms of its performance characteristics for this particular application. Maybe I've been reading the wrong stuff. Do you have general thoughts on the differences with respect to performance? (2) why delete slave logs when you can restart the slave with --skip-slave and then use CHANGE MASTER TO? Well... I guess mainly because I didn't know about that option! I thought I needed to fake out mysql on this, but it sounds like I can just do 'flush tables with read lock;reset master;' on the master and 'change master to...;' on the slave. So cool. Thanks for the input! -- Eric Robinson Disclaimer - December 4, 2009 This email and any files transmitted with it are confidential and intended solely for Tom Worster,my...@lists.mysql.com. If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any views or opinions presented in this email are solely those of the author and might not represent those of . Warning: Although has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments. This disclaimer was added by Policy Patrol: http://www.policypatrol.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you are notified that reviewing, disseminating, disclosing, copying or distributing this e-mail is strictly prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any loss or damage caused by viruses or errors or omissions in the contents of this message, which arise as a result of e-mail transmission. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089, USA, FriendFinder.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)
On 12/4/09 3:14 PM, Gavin Towey gto...@ffn.com wrote: I would say that it's very important to know why data is getting out of sync between your master and slave. Fixing those root causes would eliminate the need for this. i very much agree. the only instances of slaves getting out of whack that i've experienced was when i screwed something up administratively. There are cases where non-deterministic queries will produce different results, but that's what row based replication is supposed to solve =) 16.3.1 lists some interesting cases to consider: http://dev.mysql.com/doc/refman/5.0/en/replication-features.html There are ways to resync data that don't involve all this as well: Maatkit has some tools that compare data between servers, and can fix them with queries. No stopping the slave or locking the master necessary. I've used them in production with good results. thanks for the pointer. looks handy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)
I would say that it's very important to know why data is getting out of sync between your master and slave. Ultimately, I agree. But since it's a canned application, getting to that point might be hard, and once it is resolved, new issues might arise. I would never have any confidence that the replication is solid enough to use the slave server for backup purposes. (Which, by the way, is the real reason I'm doing this. In the middle of the night, when there are few users on the system, I want to backup the slave, but first I want to make sure I have a 100% reliable copy of the data.) There are ways to resync data that don't involve all this as well: Maatkit has some tools I've looked with great interest at Maatkit, but their tools are replete with warnings about dangers, bugs, and crashes. They certainly do not inspire confidence. -- Eric Robinson Disclaimer - December 4, 2009 This email and any files transmitted with it are confidential and intended solely for Gavin Towey,Tom Worster,my...@lists.mysql.com. If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any views or opinions presented in this email are solely those of the author and might not represent those of . Warning: Although has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments. This disclaimer was added by Policy Patrol: http://www.policypatrol.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)
I would never have any confidence that the replication is solid enough to use the slave server for backup purposes. I agree completely there. That's the other reason I like filesystem snapshots is that it allows you to take a backup from the master relatively painlessly. -Original Message- From: Robinson, Eric [mailto:eric.robin...@psmnv.com] Sent: Friday, December 04, 2009 1:24 PM To: Gavin Towey; Tom Worster; mysql@lists.mysql.com Subject: RE: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much) I would say that it's very important to know why data is getting out of sync between your master and slave. Ultimately, I agree. But since it's a canned application, getting to that point might be hard, and once it is resolved, new issues might arise. I would never have any confidence that the replication is solid enough to use the slave server for backup purposes. (Which, by the way, is the real reason I'm doing this. In the middle of the night, when there are few users on the system, I want to backup the slave, but first I want to make sure I have a 100% reliable copy of the data.) There are ways to resync data that don't involve all this as well: Maatkit has some tools I've looked with great interest at Maatkit, but their tools are replete with warnings about dangers, bugs, and crashes. They certainly do not inspire confidence. -- Eric Robinson Disclaimer - December 4, 2009 This email and any files transmitted with it are confidential and intended solely for Gavin Towey,Tom Worster,my...@lists.mysql.com. If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any views or opinions presented in this email are solely those of the author and might not represent those of . Warning: Although has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments. This disclaimer was added by Policy Patrol: http://www.policypatrol.com/ This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you are notified that reviewing, disseminating, disclosing, copying or distributing this e-mail is strictly prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any loss or damage caused by viruses or errors or omissions in the contents of this message, which arise as a result of e-mail transmission. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089, USA, FriendFinder.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)
I would never have any confidence that the replication is solid enough to use the slave server for backup purposes. I agree completely there. That's the other reason I like filesystem snapshots is that it allows you to take a backup from the master relatively painlessly. I've thought of using snapshots. Offhand, can't remember the reason that I decided they would not work for us. It'll come to me... -- Eric Robinson Disclaimer - December 4, 2009 This email and any files transmitted with it are confidential and intended solely for Gavin Towey,my...@lists.mysql.com. If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any views or opinions presented in this email are solely those of the author and might not represent those of . Warning: Although has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments. This disclaimer was added by Policy Patrol: http://www.policypatrol.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Dynamic tables--always a bad idea?
We're trying to figure out how to design a particularly critical table in our database schema. The choices are to use a single large table or a series of dynamically created small tables. This table will receive the majority of traffic (queries and updates) in the database so it's a key part of the design. The data set means we're either looking at 1 table with perhaps 10 million records or 100,000 tables each with about 100 records. Standard SQL theory seems to say we should use a single table. It's more flexible and some queries simply aren't possible across multiple tables (or at least not efficiently). But in this case we're happy to live with reduced flexibility if it gives us substantially better performance. Early empirical testing with 100,000 records suggests the single large table becomes progressively slower to access as it grows in size (average access time goes from ~4ms/transaction up to around ~80ms for our test cases--MySQL 5.0 on CentOS). The multiple dynamic tables don't seem to have this property--access remains pretty much constant as you might expect (~4ms/transaction). So the question is, even given this 20x performance benefit are we still fools to consider the dynamic table model? Are we going to run into max-tables or max-file-handle limits or other problems that will eventually bite us? Or is this speed difference just an artifact of poor indexing choices or similar? Or are dynamic tables OK sometimes? Doug P.S. Here's the table in question: CREATE TABLE one_big_table ( rank bigint not null auto_increment unique, item_id int not null, user_id int not null, countsmallintnot null default 1, addeddatetimenot null, primary key(rank, user_id) ) engine=InnoDB; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Dynamic tables--always a bad idea?
How are you going to do queries that join or merge thousands of tables? or won't that be necessary? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -Original Message- From: Douglas Pearson [mailto:[EMAIL PROTECTED] Sent: Thursday, August 23, 2007 4:35 PM To: mysql@lists.mysql.com Subject: Dynamic tables--always a bad idea? We're trying to figure out how to design a particularly critical table in our database schema. The choices are to use a single large table or a series of dynamically created small tables. This table will receive the majority of traffic (queries and updates) in the database so it's a key part of the design. The data set means we're either looking at 1 table with perhaps 10 million records or 100,000 tables each with about 100 records. Standard SQL theory seems to say we should use a single table. It's more flexible and some queries simply aren't possible across multiple tables (or at least not efficiently). But in this case we're happy to live with reduced flexibility if it gives us substantially better performance. Early empirical testing with 100,000 records suggests the single large table becomes progressively slower to access as it grows in size (average access time goes from ~4ms/transaction up to around ~80ms for our test cases--MySQL 5.0 on CentOS). The multiple dynamic tables don't seem to have this property--access remains pretty much constant as you might expect (~4ms/transaction). So the question is, even given this 20x performance benefit are we still fools to consider the dynamic table model? Are we going to run into max-tables or max-file-handle limits or other problems that will eventually bite us? Or is this speed difference just an artifact of poor indexing choices or similar? Or are dynamic tables OK sometimes? Doug P.S. Here's the table in question: CREATE TABLE one_big_table ( rank bigint not null auto_increment unique, item_idint not null, user_idint not null, count smallintnot null default 1, added datetimenot null, primary key(rank, user_id) ) engine=InnoDB; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Dynamic tables--always a bad idea?
We know that we won't need to do those sorts of queries except for statistical analysis which can happen offline (and for that we'll assemble the data back into a single table). Each table is for a specific user and there's no need to run queries across users (for this data). Doug -Original Message- From: Jerry Schwartz [mailto:[EMAIL PROTECTED] Sent: Thursday, August 23, 2007 2:02 PM To: 'Douglas Pearson'; mysql@lists.mysql.com Subject: RE: Dynamic tables--always a bad idea? How are you going to do queries that join or merge thousands of tables? or won't that be necessary? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -Original Message- From: Douglas Pearson [mailto:[EMAIL PROTECTED] Sent: Thursday, August 23, 2007 4:35 PM To: mysql@lists.mysql.com Subject: Dynamic tables--always a bad idea? We're trying to figure out how to design a particularly critical table in our database schema. The choices are to use a single large table or a series of dynamically created small tables. This table will receive the majority of traffic (queries and updates) in the database so it's a key part of the design. The data set means we're either looking at 1 table with perhaps 10 million records or 100,000 tables each with about 100 records. Standard SQL theory seems to say we should use a single table. It's more flexible and some queries simply aren't possible across multiple tables (or at least not efficiently). But in this case we're happy to live with reduced flexibility if it gives us substantially better performance. Early empirical testing with 100,000 records suggests the single large table becomes progressively slower to access as it grows in size (average access time goes from ~4ms/transaction up to around ~80ms for our test cases--MySQL 5.0 on CentOS). The multiple dynamic tables don't seem to have this property--access remains pretty much constant as you might expect (~4ms/transaction). So the question is, even given this 20x performance benefit are we still fools to consider the dynamic table model? Are we going to run into max-tables or max-file-handle limits or other problems that will eventually bite us? Or is this speed difference just an artifact of poor indexing choices or similar? Or are dynamic tables OK sometimes? Doug P.S. Here's the table in question: CREATE TABLE one_big_table ( rank bigint not null auto_increment unique, item_idint not null, user_idint not null, count smallintnot null default 1, added datetimenot null, primary key(rank, user_id) ) engine=InnoDB; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Best Idea On InnoDB Table for Pooling System
Imagine American Idol where users vote on their Idols Imagine that the system is using an innodb table... where INSERTING is very fast might be concurrent BUT inserting is done over HTTP and PHP (not enable multiple insert :(( ) Updating status for each data inserted is also very fast i mean everytime for each incoming vote we must reply the vote, so we need to update the state On the other side, we also need to count for each data real time What is the best configuration i mean from InnoDB engine it self for this High Concurrent Insert High Concurrent Update High Frequency on Select count(*) on table Thx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Slow server - any idea?
How often do you optimize/analyze your tables? Have you checked the index cardinality? What does an explain plan show? -Original Message- From: Julien Lavigne du Cadet To: [EMAIL PROTECTED] Sent: 7/25/04 4:26 PM Subject: Slow server - any idea? Hi eveybody, I've got problems since a few weeks with my mysql server. There are a lot of slow queries (about 1200 in less than 48 hours), even some that should absolutely not be slow like this one which is performing on a HEAP table : SELECT * FROM vb3_session WHERE sessionhash = '31d429cc3820a8bb141733de2cd306ba' AND lastactivity 1090778091 AND host = '65.50.5.140' AND idhash = '385f8c8da967afdd86399fb72d05'; I'm running a p4 2,4. 1Go RAM, DD IDE 80Go under FreeBSD and I've got the 4.0.20 version installed (anyway I tried to downgrade to 4.0.18 and it didn't changed anything). There are about 20 sites and a vb3 forum with 200 to 300 visitors at once. The server doesn't seem to consume much cpu as shown : 42992 mysql 2 0 226M 66256K poll 87:38 4.83% 4.83% mysqld Here is my config file : [mysqld] datadir=/var/db/mysql socket=/tmp/mysql.sock skip-locking skip-innodb query_cache_limit=1M query_cache_size=32M query_cache_type=1 max_connections=500 interactive_timeout=100 wait_timeout=100 connect_timeout=10 thread_cache_size=64 key_buffer=150M join_buffer=1M max_allowed_packet=2M table_cache=768 record_buffer=1M sort_buffer_size=1M read_buffer_size=1M #read_rnd_buffer_size=768K max_connect_errors=10 # Try number of CPU's*2 for thread_concurrency thread_concurrency=2 myisam_sort_buffer_size=64M #log-bin server-id=1 log_slow_queries=/var/log/slow-queries.log long_query_time=1 [mysql.server] user=mysql basedir=/usr/local [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/db/mysql/srv1.pid open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [mysqlhotcopy] interactive-timeout Here is the status : Created tmp disk tables 706 Created tmp tables 162301 Created tmp files 138 Delayed insert threads 0 Delayed writes 0 Delayed errors 0 Flush commands 1 Handler commit 0 Handler delete 62700 Handler read first 10465 Handler read key 53413365 Handler read next 20806399 Handler read prev 8431183 Handler read rnd 12619723 Handler read rnd next 670650172 Handler rollback 0 Handler update 2921336 Handler write 23073711 Key blocks used 108984 Key read requests 135302387 Key reads 107438 Key write requests 214624 Key writes 184195 Max used connections 41 Not flushed key blocks 0 Not flushed delayed rows 0 Open tables 768 Open files 1321 Open streams 0 Opened tables 9238 Qcache queries in cache 4900 Qcache inserts 954259 Qcache hits 1556783 Qcache lowmem prunes 143367 Qcache not cached 120513 Qcache free memory 7149624 Qcache free blocks 2438 Qcache total blocks 14367 Rpl status NULL Select full join 739 Select full range join 63 Select range 135410 Select range check 0 Select scan 415678 Slave open temp tables 0 Slave running OFF Slow launch threads 0 Slow queries 1280 Sort merge passes 69 Sort range 128597 Sort rows 13431446 Sort scan 200597 Table locks immediate 2514328 Table locks waited 7966 Threads cached 39 Threads created 42 Threads connected 3 Threads running 1 I also have got this kind of messages in mysqld.log : 040725 12:56:47 Aborted connection 250044 to db: 'mondespe_lineage2' user: 'root' host: `localhost' (Got timeout reading communication packets) 040725 12:58:40 Aborted connection 250285 to db: 'animelan' user: 'animelan' host: `localhost' (Got timeout reading communication packets) 040725 13:09:59 Aborted connection 251722 to db: 'mondespe_forums' user: 'mondespe' host: `localhost' (Got timeout reading communication packets) 040725 13:10:59 Aborted connection 251896 to db: 'unconnected' user: 'root' host: `localhost' (Got timeout reading communication packets) 040725 13:10:59 Aborted connection 251891 to db: 'vb3_fansite' user: 'root' host: `localhost' (Got timeout reading communication packets) 040725 13:11:06 Aborted connection 251914 to db: 'mysql' user: 'root' host: `localhost' (Got timeout reading communication packets) 040725 13:17:37 Aborted connection 252812 to db: 'mondespe_forums' user: 'mondespe' host: `localhost' (Got timeout reading communication packets) 040725 13:30:18 Aborted connection 254752 to db: 'mmoblogs' user: 'root' host: `localhost' (Got timeout reading communication packets) 040725 13:30:21 Aborted connection 254750 to db: 'mysql' user: 'root' host: `localhost' (Got timeout reading communication packets) 040725 13:32:37 Aborted connection 255067 to db: 'mysql' user: 'root' host: `localhost' (Got timeout reading communication packets) Any idea to solve the problem is welcome, Thanks to all, Julien. -- MySQL General Mailing List For list archives: http
Re: Slow server - any idea?
I've optimized the main tables (the forums one and a few others) a few days ago. About index cardinality, I don't know what to tell you. For a few tables it is high, like for the vbulletin postindex (higher than 11 000 000) but it's absolutely normal for such a forum. And about explain, we've got a few hundred tables so i can't tell you much :) Thanks for your help, Julien Lavigne du Cadet. - Original Message - From: Victor Pendleton [EMAIL PROTECTED] To: 'Julien Lavigne du Cadet ' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 26, 2004 3:06 PM Subject: RE: Slow server - any idea? How often do you optimize/analyze your tables? Have you checked the index cardinality? What does an explain plan show? -Original Message- From: Julien Lavigne du Cadet To: [EMAIL PROTECTED] Sent: 7/25/04 4:26 PM Subject: Slow server - any idea? Hi eveybody, I've got problems since a few weeks with my mysql server. There are a lot of slow queries (about 1200 in less than 48 hours), even some that should absolutely not be slow like this one which is performing on a HEAP table : SELECT * FROM vb3_session WHERE sessionhash = '31d429cc3820a8bb141733de2cd306ba' AND lastactivity 1090778091 AND host = '65.50.5.140' AND idhash = '385f8c8da967afdd86399fb72d05'; I'm running a p4 2,4. 1Go RAM, DD IDE 80Go under FreeBSD and I've got the 4.0.20 version installed (anyway I tried to downgrade to 4.0.18 and it didn't changed anything). There are about 20 sites and a vb3 forum with 200 to 300 visitors at once. The server doesn't seem to consume much cpu as shown : 42992 mysql 2 0 226M 66256K poll 87:38 4.83% 4.83% mysqld Here is my config file : [mysqld] datadir=/var/db/mysql socket=/tmp/mysql.sock skip-locking skip-innodb query_cache_limit=1M query_cache_size=32M query_cache_type=1 max_connections=500 interactive_timeout=100 wait_timeout=100 connect_timeout=10 thread_cache_size=64 key_buffer=150M join_buffer=1M max_allowed_packet=2M table_cache=768 record_buffer=1M sort_buffer_size=1M read_buffer_size=1M #read_rnd_buffer_size=768K max_connect_errors=10 # Try number of CPU's*2 for thread_concurrency thread_concurrency=2 myisam_sort_buffer_size=64M #log-bin server-id=1 log_slow_queries=/var/log/slow-queries.log long_query_time=1 [mysql.server] user=mysql basedir=/usr/local [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/db/mysql/srv1.pid open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [mysqlhotcopy] interactive-timeout Here is the status : Created tmp disk tables 706 Created tmp tables 162301 Created tmp files 138 Delayed insert threads 0 Delayed writes 0 Delayed errors 0 Flush commands 1 Handler commit 0 Handler delete 62700 Handler read first 10465 Handler read key 53413365 Handler read next 20806399 Handler read prev 8431183 Handler read rnd 12619723 Handler read rnd next 670650172 Handler rollback 0 Handler update 2921336 Handler write 23073711 Key blocks used 108984 Key read requests 135302387 Key reads 107438 Key write requests 214624 Key writes 184195 Max used connections 41 Not flushed key blocks 0 Not flushed delayed rows 0 Open tables 768 Open files 1321 Open streams 0 Opened tables 9238 Qcache queries in cache 4900 Qcache inserts 954259 Qcache hits 1556783 Qcache lowmem prunes 143367 Qcache not cached 120513 Qcache free memory 7149624 Qcache free blocks 2438 Qcache total blocks 14367 Rpl status NULL Select full join 739 Select full range join 63 Select range 135410 Select range check 0 Select scan 415678 Slave open temp tables 0 Slave running OFF Slow launch threads 0 Slow queries 1280 Sort merge passes 69 Sort range 128597 Sort rows 13431446 Sort scan 200597 Table locks immediate 2514328 Table locks waited 7966 Threads cached 39 Threads created 42 Threads connected 3 Threads running 1 I also have got this kind of messages in mysqld.log : 040725 12:56:47 Aborted connection 250044 to db: 'mondespe_lineage2' user: 'root' host: `localhost' (Got timeout reading communication packets) 040725 12:58:40 Aborted connection 250285 to db: 'animelan' user: 'animelan' host: `localhost' (Got timeout reading communication packets) 040725 13:09:59 Aborted connection 251722 to db: 'mondespe_forums' user: 'mondespe' host: `localhost' (Got timeout reading communication packets) 040725 13:10:59 Aborted connection 251896 to db: 'unconnected' user: 'root' host: `localhost' (Got timeout reading communication packets) 040725 13:10:59 Aborted connection 251891 to db: 'vb3_fansite' user: 'root' host: `localhost' (Got timeout reading communication packets) 040725 13:11:06 Aborted connection 251914 to db: 'mysql' user: 'root' host: `localhost' (Got
Slow server - any idea?
Hi eveybody, I've got problems since a few weeks with my mysql server. There are a lot of slow queries (about 1200 in less than 48 hours), even some that should absolutely not be slow like this one which is performing on a HEAP table : SELECT * FROM vb3_session WHERE sessionhash = '31d429cc3820a8bb141733de2cd306ba' AND lastactivity 1090778091 AND host = '65.50.5.140' AND idhash = '385f8c8da967afdd86399fb72d05'; I'm running a p4 2,4. 1Go RAM, DD IDE 80Go under FreeBSD and I've got the 4.0.20 version installed (anyway I tried to downgrade to 4.0.18 and it didn't changed anything). There are about 20 sites and a vb3 forum with 200 to 300 visitors at once. The server doesn't seem to consume much cpu as shown : 42992 mysql 2 0 226M 66256K poll 87:38 4.83% 4.83% mysqld Here is my config file : [mysqld] datadir=/var/db/mysql socket=/tmp/mysql.sock skip-locking skip-innodb query_cache_limit=1M query_cache_size=32M query_cache_type=1 max_connections=500 interactive_timeout=100 wait_timeout=100 connect_timeout=10 thread_cache_size=64 key_buffer=150M join_buffer=1M max_allowed_packet=2M table_cache=768 record_buffer=1M sort_buffer_size=1M read_buffer_size=1M #read_rnd_buffer_size=768K max_connect_errors=10 # Try number of CPU's*2 for thread_concurrency thread_concurrency=2 myisam_sort_buffer_size=64M #log-bin server-id=1 log_slow_queries=/var/log/slow-queries.log long_query_time=1 [mysql.server] user=mysql basedir=/usr/local [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/db/mysql/srv1.pid open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [mysqlhotcopy] interactive-timeout Here is the status : Created tmp disk tables 706 Created tmp tables 162301 Created tmp files 138 Delayed insert threads 0 Delayed writes 0 Delayed errors 0 Flush commands 1 Handler commit 0 Handler delete 62700 Handler read first 10465 Handler read key 53413365 Handler read next 20806399 Handler read prev 8431183 Handler read rnd 12619723 Handler read rnd next 670650172 Handler rollback 0 Handler update 2921336 Handler write 23073711 Key blocks used 108984 Key read requests 135302387 Key reads 107438 Key write requests 214624 Key writes 184195 Max used connections 41 Not flushed key blocks 0 Not flushed delayed rows 0 Open tables 768 Open files 1321 Open streams 0 Opened tables 9238 Qcache queries in cache 4900 Qcache inserts 954259 Qcache hits 1556783 Qcache lowmem prunes 143367 Qcache not cached 120513 Qcache free memory 7149624 Qcache free blocks 2438 Qcache total blocks 14367 Rpl status NULL Select full join 739 Select full range join 63 Select range 135410 Select range check 0 Select scan 415678 Slave open temp tables 0 Slave running OFF Slow launch threads 0 Slow queries 1280 Sort merge passes 69 Sort range 128597 Sort rows 13431446 Sort scan 200597 Table locks immediate 2514328 Table locks waited 7966 Threads cached 39 Threads created 42 Threads connected 3 Threads running 1 I also have got this kind of messages in mysqld.log : 040725 12:56:47 Aborted connection 250044 to db: 'mondespe_lineage2' user: 'root' host: `localhost' (Got timeout reading communication packets) 040725 12:58:40 Aborted connection 250285 to db: 'animelan' user: 'animelan' host: `localhost' (Got timeout reading communication packets) 040725 13:09:59 Aborted connection 251722 to db: 'mondespe_forums' user: 'mondespe' host: `localhost' (Got timeout reading communication packets) 040725 13:10:59 Aborted connection 251896 to db: 'unconnected' user: 'root' host: `localhost' (Got timeout reading communication packets) 040725 13:10:59 Aborted connection 251891 to db: 'vb3_fansite' user: 'root' host: `localhost' (Got timeout reading communication packets) 040725 13:11:06 Aborted connection 251914 to db: 'mysql' user: 'root' host: `localhost' (Got timeout reading communication packets) 040725 13:17:37 Aborted connection 252812 to db: 'mondespe_forums' user: 'mondespe' host: `localhost' (Got timeout reading communication packets) 040725 13:30:18 Aborted connection 254752 to db: 'mmoblogs' user: 'root' host: `localhost' (Got timeout reading communication packets) 040725 13:30:21 Aborted connection 254750 to db: 'mysql' user: 'root' host: `localhost' (Got timeout reading communication packets) 040725 13:32:37 Aborted connection 255067 to db: 'mysql' user: 'root' host: `localhost' (Got timeout reading communication packets) Any idea to solve the problem is welcome, Thanks to all, Julien.
Re: Idea to speed up multiple jdbc connections?
Marc mysqld runs on a very powerful Operton machine with 16GB memory and barely any other application process running, it is hard to believe that a simple select that runs under 2 second will utilize all the resources...that is why I tend to think there is something in the mysql set up that caused this...any idea where I should look? BTW: the numbers are in milliseconds Thanks Haitao --- Marc Slemko [EMAIL PROTECTED] wrote: On Mon, 7 Jun 2004, Haitao Jiang wrote: Yes. The time I measure like I said is purely around statement.execQuery() call. Connection creation is not a factor here at all. My database has 1.64 million rows and 4 queries are all selects, which are identical in both serial and parallel cases. In serial cases: Query 0 took 590 Query 1 took 431 Query 2 took 461 Query 3 took 440 In parallel cases: Queryer 3 query took 1552 Queryer 1 query took 1632 Queryer 2 query took 1783 Queryer 0 query took 1923 I don't understand why in 4 concurrent connection cases (already created not included in the timing) it takes more than 3 times longer to exec. a query. Umh... if your queries are limited by some bottleneck on the server (such as, for example, CPU) then why would running them in parallel make it any faster? It seems that in the sequential case they are taking a total of 1922 (whatever those units are) while in the parallel case they are taking 1923. What this is telling you is that, in this case, a single query is able to fully utilize the resources (likely CPU given these numbers, although it is possible it could be disk) on the server. If a single query can fully utilize the server, all that adding more concurrency can possibly do is slow the total throughput down. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Idea to speed up multiple jdbc connections?
On Mon, 7 Jun 2004, Haitao Jiang wrote: Marc mysqld runs on a very powerful Operton machine with 16GB memory and barely any other application process running, it is hard to believe that a simple select that runs under 2 second will utilize all the resources...that is why I tend to think there is something in the mysql set up that caused this...any idea where I should look? How many processors? If there is only one and the query is CPU bound (as it probably is if everything is cached, given 16 gigs of ram), then why shouldn't it use all the CPU? Or, to phrase the question differently: why should the query take 2 seconds to run if there are free resources? Now, on a multiprocessor box it clearly starts to get more complicated. mysql has no capability to spread one query across multiple CPUs in parallel, and while it can spread multiple queries across CPUs the scalability has its limits. The fact that is a simple query is irrelevant (some of the simplest can be the slowest if it has to do a full table scan). From the fact that it takes 2 seconds it is clear it is not an entirely trivial query. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Idea to speed up multiple jdbc connections?
Each of 4 individual query only took 0.6 seconds, there is no other clients, it hardly to believe taht mysql query performance will degrade 300% (from 0.6s to ~1.9s) if we have 4 concurrent connections... As far as I know, MySQL should be able to handle hundreds of connections on a single CPU box without degrading performance like above. Thanks HT --- Marc Slemko [EMAIL PROTECTED] wrote: On Mon, 7 Jun 2004, Haitao Jiang wrote: Marc mysqld runs on a very powerful Operton machine with 16GB memory and barely any other application process running, it is hard to believe that a simple select that runs under 2 second will utilize all the resources...that is why I tend to think there is something in the mysql set up that caused this...any idea where I should look? How many processors? If there is only one and the query is CPU bound (as it probably is if everything is cached, given 16 gigs of ram), then why shouldn't it use all the CPU? Or, to phrase the question differently: why should the query take 2 seconds to run if there are free resources? Now, on a multiprocessor box it clearly starts to get more complicated. mysql has no capability to spread one query across multiple CPUs in parallel, and while it can spread multiple queries across CPUs the scalability has its limits. The fact that is a simple query is irrelevant (some of the simplest can be the slowest if it has to do a full table scan). From the fact that it takes 2 seconds it is clear it is not an entirely trivial query. __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Idea to speed up multiple jdbc connections?
On Tue, 8 Jun 2004, Haitao Jiang wrote: Each of 4 individual query only took 0.6 seconds, there is no other clients, it hardly to believe taht mysql query performance will degrade 300% (from 0.6s to ~1.9s) if we have 4 concurrent connections... As far as I know, MySQL should be able to handle hundreds of connections on a single CPU box without degrading performance like above. You are completely missing the point. It is nothing to do with concurrent _connections_ it has to do with running concurrent _queries_. What you are saying is like well, if you can sit down and solve this equation in 10 minutes, why does it take you 40 minutes to solve 4 different equations? There is no magic way for the machine to do a hundred things at once on a single processor (assuming you don't yet have a quantum computer), they all get run for brief periods interleaved with one another. If you are running 4 at once, then each will only run 1/4 of the time. The box is working as hard as it can to process one query, do you think it should slow down how quickly it processes one concurrent query just so that number will change less if you have more than one? I'll repeat what I said before: a query that takes 600ms on such a machine is not a trivial query. If you real question is why is my query so slow then you should probably ask that instead of getting confused about why your machine can't do 4 things at once. P.S. Please do not go around reposting your same question on multiple lists, it has already been answered. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Idea to speed up multiple jdbc connections?
Hi, I would appreciate any help on this: I got approximate same timing on following two: case 1: create 1 jdbc connection and issue 4 queries sequentially case 2: create 4 jdbc connections and issue 4 queries via 4 different threads at the same time The timing is done around statement.execQuery(query), so overhead of multithreading can be ignored. I would think case 2 should be faster, but it was not. Any idea? Thanks a lot PS: the mysqld server 4.1.1a is running with 16 threads __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Idea to speed up multiple jdbc connections?
AFAIK, creation of connection from DB is expensive. This is one of the reasons why we need connection pooling. Best Regards, Jonathan Chiu OOCL Logistics Unit 1, 4/F., Sun Hung Kai Centre, 30 Harbour Road, Wanchai TEL: 852 . 2990 0174 FAX: 852 . 28249017 -Original Message- From: Haitao Jiang [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 8:14 AM To: mysql Subject: Idea to speed up multiple jdbc connections? Hi, I would appreciate any help on this: I got approximate same timing on following two: case 1: create 1 jdbc connection and issue 4 queries sequentially case 2: create 4 jdbc connections and issue 4 queries via 4 different threads at the same time The timing is done around statement.execQuery(query), so overhead of multithreading can be ignored. I would think case 2 should be faster, but it was not. Any idea? Thanks a lot PS: the mysqld server 4.1.1a is running with 16 threads __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] IMPORTANT NOTICE Email from OOCL is confidential and may be legally privileged. If it is not intended for you, please delete it immediately unread. The internet cannot guarantee that this communication is free of viruses, interception or interference and anyone who communicates with us by email is taken to accept the risks in so doing. Without limitation, OOCL and its affiliates accept no liability whatsoever and howsoever arising in connection with the use of this email. Under no circumstances shall this email constitute a binding agreement to carry or for provision of carriage services by OOCL, which is subject to the availability of carrier's equipment and vessels and the terms and conditions of OOCL's standard bill of lading which is also available at http://www.oocl.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Idea to speed up multiple jdbc connections?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: AFAIK, creation of connection from DB is expensive. This is one of the reasons why we need connection pooling. Jonathan, While that might be true for other databases, it's not true for MySQL (connections are a few ms. to create). The real reason to use connection pooling is as a resource limiter so that you do not waste MySQL server-side resources for threads that are effectively doing nothing. Haitao's issue might be due to some locking in the database server, thus effectively serializing his four connections, or he might not be actually producing enough load to actually be able to measure any difference between his two approaches. If he could post his DDL, the relative size(s) of his data set(s) and the queries, that would be somewhere to start. -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com MySQL Guide to Lower TCO http://www.mysql.com/it-resources/white-papers/tco.php -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAxRgLtvXNTca6JD8RAjiSAJ0R5b6MNW0SdY5z4eJtmfgAV0ZMtgCgtGyn 037apgXT972UAR3Khkg7ITI= =4bja -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Idea to speed up multiple jdbc connections?
Yes. The time I measure like I said is purely around statement.execQuery() call. Connection creation is not a factor here at all. My database has 1.64 million rows and 4 queries are all selects, which are identical in both serial and parallel cases. In serial cases: Query 0 took 590 Query 1 took 431 Query 2 took 461 Query 3 took 440 In parallel cases: Queryer 3 query took 1552 Queryer 1 query took 1632 Queryer 2 query took 1783 Queryer 0 query took 1923 I don't understand why in 4 concurrent connection cases (already created not included in the timing) it takes more than 3 times longer to exec. a query. Thanks Haitao --- Mark Matthews [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: AFAIK, creation of connection from DB is expensive. This is one of the reasons why we need connection pooling. Jonathan, While that might be true for other databases, it's not true for MySQL (connections are a few ms. to create). The real reason to use connection pooling is as a resource limiter so that you do not waste MySQL server-side resources for threads that are effectively doing nothing. Haitao's issue might be due to some locking in the database server, thus effectively serializing his four connections, or he might not be actually producing enough load to actually be able to measure any difference between his two approaches. If he could post his DDL, the relative size(s) of his data set(s) and the queries, that would be somewhere to start. -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com MySQL Guide to Lower TCO http://www.mysql.com/it-resources/white-papers/tco.php -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAxRgLtvXNTca6JD8RAjiSAJ0R5b6MNW0SdY5z4eJtmfgAV0ZMtgCgtGyn 037apgXT972UAR3Khkg7ITI= =4bja -END PGP SIGNATURE- __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Idea to speed up multiple jdbc connections?
Oppz! Sorry for overlooking your timing method. In this case, I believe if you run the query in four different machines at the same time, the statistics should almost the same as running four consecutive queries in the same machine. I believe the multi-threading implemented in the JVM and the OS is not parallelly the same! Best Regards, Jonathan Chiu OOCL Logistics Unit 1, 4/F., Sun Hung Kai Centre, 30 Harbour Road, Wanchai TEL: 852 . 2990 0174 FAX: 852 . 28249017 -Original Message- From: Haitao Jiang [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 12:06 PM To: Mark Matthews; JONATHAN CHIU (ISD-OLAPL/HKG) Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Idea to speed up multiple jdbc connections? Yes. The time I measure like I said is purely around statement.execQuery() call. Connection creation is not a factor here at all. My database has 1.64 million rows and 4 queries are all selects, which are identical in both serial and parallel cases. In serial cases: Query 0 took 590 Query 1 took 431 Query 2 took 461 Query 3 took 440 In parallel cases: Queryer 3 query took 1552 Queryer 1 query took 1632 Queryer 2 query took 1783 Queryer 0 query took 1923 I don't understand why in 4 concurrent connection cases (already created not included in the timing) it takes more than 3 times longer to exec. a query. Thanks Haitao --- Mark Matthews [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: AFAIK, creation of connection from DB is expensive. This is one of the reasons why we need connection pooling. Jonathan, While that might be true for other databases, it's not true for MySQL (connections are a few ms. to create). The real reason to use connection pooling is as a resource limiter so that you do not waste MySQL server-side resources for threads that are effectively doing nothing. Haitao's issue might be due to some locking in the database server, thus effectively serializing his four connections, or he might not be actually producing enough load to actually be able to measure any difference between his two approaches. If he could post his DDL, the relative size(s) of his data set(s) and the queries, that would be somewhere to start. -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com MySQL Guide to Lower TCO http://www.mysql.com/it-resources/white-papers/tco.php -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAxRgLtvXNTca6JD8RAjiSAJ0R5b6MNW0SdY5z4eJtmfgAV0ZMtgCgtGyn 037apgXT972UAR3Khkg7ITI= =4bja -END PGP SIGNATURE- __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ IMPORTANT NOTICE Email from OOCL is confidential and may be legally privileged. If it is not intended for you, please delete it immediately unread. The internet cannot guarantee that this communication is free of viruses, interception or interference and anyone who communicates with us by email is taken to accept the risks in so doing. Without limitation, OOCL and its affiliates accept no liability whatsoever and howsoever arising in connection with the use of this email. Under no circumstances shall this email constitute a binding agreement to carry or for provision of carriage services by OOCL, which is subject to the availability of carrier's equipment and vessels and the terms and conditions of OOCL's standard bill of lading which is also available at http://www.oocl.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Idea to speed up multiple jdbc connections?
On Mon, 7 Jun 2004, Haitao Jiang wrote: Yes. The time I measure like I said is purely around statement.execQuery() call. Connection creation is not a factor here at all. My database has 1.64 million rows and 4 queries are all selects, which are identical in both serial and parallel cases. In serial cases: Query 0 took 590 Query 1 took 431 Query 2 took 461 Query 3 took 440 In parallel cases: Queryer 3 query took 1552 Queryer 1 query took 1632 Queryer 2 query took 1783 Queryer 0 query took 1923 I don't understand why in 4 concurrent connection cases (already created not included in the timing) it takes more than 3 times longer to exec. a query. Umh... if your queries are limited by some bottleneck on the server (such as, for example, CPU) then why would running them in parallel make it any faster? It seems that in the sequential case they are taking a total of 1922 (whatever those units are) while in the parallel case they are taking 1923. What this is telling you is that, in this case, a single query is able to fully utilize the resources (likely CPU given these numbers, although it is possible it could be disk) on the server. If a single query can fully utilize the server, all that adding more concurrency can possibly do is slow the total throughput down. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
New Idea
Hello again, After realizing the obvious implementation flaws, I thought of a new idea and again, would appreciate some feedback on the efficiency benefits. My last post involved INSERT vs UPDATE efficiency. Neither is going to be a directly useful approach. With 48k records and growing for just one table of 2, the dump time was significantly too slow. Here is my new idea. Instead of directly communicating with MySQL, how much more efficient would it be to write the same statements to a text file, and then fork a child thread to connect to the database, and read the entire infile at once? There is some optimization for this , in addition to which writing the text file should only take a few seconds since it's a strict out stream write. Obviously this would increase performance of the client which dumps the text file, and also give an intermediary level of preventing data loss, if the import didn't go for some unpredictable reason, the file could still be imported prior to restarting the application. Has anyone used this sort of method, does it pose any issues I haven't considered? I also realized I am running 4.0.10-gamma, precompiled for FreeBSD packages. I will be compiling 4.0.13 with linuxthreads to gain any benefits there as well. Thanks, -Shane p.s. I always find a last question. Off topic, compiled properly for each machine, would MySQL run better on a quad ppro 200 (IBM PC704), or a similarily stocked 2.5ghz P4 single processor system? Curious for expected results on a new development server versus production server.
Re: New Idea
how much more efficient would it be to write the same statements to a text file, and then fork a child thread to connect to the database, and read the entire infile at once? If I understand you correctly, this is addressed in the section of the manual to which I previously referred you. From said section: When loading a table from a text file, use LOAD DATA INFILE. This is usually 20 times faster than using a lot of INSERT statements. See section 6.4.9 LOAD DATA INFILE Syntax. would MySQL run better on a quad ppro 200 (IBM PC704), or a similarily stocked 2.5ghz P4 single processor system? Most likely the P4. I don't believe Pentium Pros support hyperthreading, which would actually allow the database tasks to be split between the processors. I may be mistaken, but I'm fairly confident here. A great deal of skepticism about the multi-processor Pentium systems, especially older ones, always stemmed from the fact that neither the processor or the OS (in the case of Windows) was capable of making full use of a multi-proc architecture. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Shane Bryldt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, 16 June, 2003 17:30 Subject: New Idea Hello again, After realizing the obvious implementation flaws, I thought of a new idea and again, would appreciate some feedback on the efficiency benefits. My last post involved INSERT vs UPDATE efficiency. Neither is going to be a directly useful approach. With 48k records and growing for just one table of 2, the dump time was significantly too slow. Here is my new idea. Instead of directly communicating with MySQL, how much more efficient would it be to write the same statements to a text file, and then fork a child thread to connect to the database, and read the entire infile at once? There is some optimization for this , in addition to which writing the text file should only take a few seconds since it's a strict out stream write. Obviously this would increase performance of the client which dumps the text file, and also give an intermediary level of preventing data loss, if the import didn't go for some unpredictable reason, the file could still be imported prior to restarting the application. Has anyone used this sort of method, does it pose any issues I haven't considered? I also realized I am running 4.0.10-gamma, precompiled for FreeBSD packages. I will be compiling 4.0.13 with linuxthreads to gain any benefits there as well. Thanks, -Shane p.s. I always find a last question. Off topic, compiled properly for each machine, would MySQL run better on a quad ppro 200 (IBM PC704), or a similarily stocked 2.5ghz P4 single processor system? Curious for expected results on a new development server versus production server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Idea: Syntax help on command line
Hello I use the mysql command line tool quite often and always wondered why there's no feature that lets me quickly see the syntax of a FOREIGN KEY or GRANT command. Now while browsing the source I found the new syntax command in 4.0.12 and got the idea of implementing this syntax help of myself. What do you think of a client command: mysql syntax select; (or \S or SHOW SYNTAX OF) SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] [HIGH_PRIORITY] [DISTINCT | DISTINCTROW | ALL] select_expression,... [INTO {OUTFILE | DUMPFILE} 'file_name' export_options] [FROM table_references [WHERE where_definition] [GROUP BY {unsigned_integer | col_name | formula} [ASC | DESC], ...] [HAVING where_definition] [ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC] ,...] [LIMIT [offset,] rows | rows OFFSET offset] [PROCEDURE procedure_name(argument_list)] [FOR UPDATE | LOCK IN SHARE MODE]] Reference: 6.4.1 http://www.mysql.com/doc/en/SELECT.html I managed to hacked a working demo in less than 10 minutes which is simply a copy of the syntax function and which uses syntax() to pipe the output of an arbitrary command back to mysql (of course it could be a C function, too, but why the unnecessary burden and having it as seperate program makes it useable standalone, too!) This program could be a perl program which either has syntax definitions hardcoded or, even better, is able to extract them from the docs. A preinstalled html documentation could be prerequisite which has two comments like !-- BEGIN SYNTAX: SELECT -- ... !-- END SYNTAX -- so that the syntax is easily extractable. Something in the kind of cat /usr/share/doc/mysql/en/$1.html could be enough for the first start, too. The final stage would then be that this help command is called whenever on presses e.g. two times tab after writing a command like a command completition. Any suggestions and comments? bye, -christian- P.S.: Please CC me, I'm not subscribed. Thanks. -- The end of the human race will be that it will eventually die of civilization. -- Ralph Waldo Emerson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RE: FAQ hosting site (was Re: An Idea) (fwd)
sql,query,queries,smallint On Thu, 2 Jan 2003, Peter Lovatt wrote: I was looking for a reasonably heavyweight php application, there are some lightweight ones and some half finished ones and some perl ones, but none that were what I was looking for. Any suggestions would be appreciated, no point in reinventing the wheel. I prefer FAQ-O-Matic. http://faqomatic.sourceforge.net/faq.pl Good Luck, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ1042 East Fort Union #135, Midvale Utah 84047 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FAQ hosting site (was Re: An Idea)
Yes, you need to specify the IP address that you plan on using for this process instead of the computer name. If you use Windows, chances are your using MYODBC or some other similar driver. Case #1: You setup a DSN in the ODBC area of the OS Case #2 You setup a DSN-less connection to your db. Case #2 has actually worked much faster for me. You can just put the IP in your connection code and off you go. Either way, you need to do this because the OS cannot resolve how you want it done. Just to make sure it is two NIC's that is causing your problem, disable one in the IP configuration area and give it a try. If you still cannot connect to your db, then something else may also be wrong. Bruce - Original Message - From: Peter Lovatt [EMAIL PROTECTED] To: mnbv [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 6:25 PM Subject: RE: FAQ hosting site (was Re: An Idea) Hi Is '111' the IP it is trying to connect on? If so it is an invalid IP. If the IP is valid how are you trying to connect? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: mnbv [mailto:[EMAIL PROTECTED]] Sent: 02 January 2003 00:23 To: Peter Lovatt; Stefan Hinz, iConnect (Berlin); David T-G; mysql users Subject: RE: FAQ hosting site (was Re: An Idea) I really need your help, I installed MySQL and I can connect to it through localhost but when trying to access it from outside I get: ERROR 2003: Can't connect to MySQL server on 'IP' (111) Any suggestions? Someone suggested that the problem is because the server has 2 nics (2 ips set up). Does anyone know a solution for this? --- Peter Lovatt [EMAIL PROTECTED] wrote: Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer
Re: FAQ hosting site (was Re: An Idea)
Why not try Tek-Tips? Maybe they will sponsor something for free. They may have everything you need. Just a thought. [EMAIL PROTECTED] [EMAIL PROTECTED] Bruce - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Peter Lovatt [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; David T-G [EMAIL PROTECTED]; mysql users [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 6:36 PM Subject: Re: FAQ hosting site (was Re: An Idea) On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote: I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) Really? That's a wheel I've seen re-invented many times. I know there's stuff out there. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 17 days, processed 617,666,871 queries (401/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: An Idea
R. Hannes Niedner wrote: Isn't that funny: if I have a mysql related question and search google I end up in the mysql online documentation in 90% of cases. I find if I just use the word 'mysql' in my query on Google, I get fairly appropriate results too. Not using the word mysql often gives me generic SQL responses regarding many products (often MS SQL Server, since they decided to use the lone word 'sql' in its 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: An Idea
David, Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. I agree. Will you set it up at http://justpickone.org/? (BTW, I like your website, especially the PIX :-) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 1:35 AM Subject: Re: An Idea -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % regarding the MySQL FAQ: % % Why should it have to be there? Let anyone with a site set it up and ... % % MySQL.com would be the natural place for the FAQ. Any other place % wouldn't be half as good. Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV tC44gsIMkjgUkNtZlkpZ+Y0= =XS30 -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: An Idea
James, something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Do these tools work better that the search tool (Mnogo search) at http://lists.mysql.com/php/search.php? This thing sucks - I was looking for mysql_fix_privilege_tables, and it found nothing! Guten Rutsch Danke, Dir auch! Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: JamesD [EMAIL PROTECTED] To: David T-G [EMAIL PROTECTED]; mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 5:11 AM Subject: RE: An Idea we find people just like to ask questions, and no matter how good our FAQ's and help are, many people have circumstances that make it more efficient to push the question into the queue, and wait for an answer to pop back later. lists work, and faq's work, some like to call...etc. personally, I'd prefer a search engine style... like google, but only for mySQL topics, and with a visible list of most popular search terms. something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Guten Rutsch Jim -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 4:36 PM To: mysql users Cc: Stefan Hinz, iConnect (Berlin) Subject: Re: An Idea -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % regarding the MySQL FAQ: % % Why should it have to be there? Let anyone with a site set it up and ... % % MySQL.com would be the natural place for the FAQ. Any other place % wouldn't be half as good. Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV tC44gsIMkjgUkNtZlkpZ+Y0= =XS30 -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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FAQ hosting site (was Re: An Idea)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % see it dropped if they don't jump on it at the start. % % I agree. Will you set it up at http://justpickone.org/? (BTW, I like Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp (I wish we could sftp without then also having ssh; darn) and, meanwhile, it seems like this should be the sort of thing where we could either use CVS or a web update form or the like... Maybe a wiki will do for now, but I don't like only being able to get at it from the web :-) Anyone have any thoughts? % your website, especially the PIX :-) Thanks! :-) It needs an overhaul, but it gets the job done. % % Regards, % -- % Stefan Hinz [EMAIL PROTECTED] % Geschäftsführer / CEO iConnect GmbH http://iConnect.de % Heesestr. 6, 12169 Berlin (Germany) % Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 HTH HAND HNY :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EwVbGb7uCXufRwARAmHWAJ9j2Zd/syBro07AQ5hj0n7lAeeFMACfYch+ QFYwxXNLMvUSbTYxxp2JQOE= =g9Q2 -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: An Idea
alkaline has been around awhile. the model is similiar to mysql in that they have a commercial version that sustains them, and a free version that sustains the rest of us. there is not a doubt that its better than the php script you refer to below... http://alkaline.vestris.com/docs/alkaline-faq/af-general.html#AF-GEN-WHY its claim is very high speed searching, partial word searching, multiple remote site indexing and spidering etc. good for high speed results on a document set of 500,000 pages or so. with a list of mysql urls to spider and index, it can be setup and live, fast. Jim -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 01, 2003 5:31 AM To: JamesD; David T-G; mysql users Subject: Re: An Idea James, something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Do these tools work better that the search tool (Mnogo search) at http://lists.mysql.com/php/search.php? This thing sucks - I was looking for mysql_fix_privilege_tables, and it found nothing! Guten Rutsch Danke, Dir auch! Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: JamesD [EMAIL PROTECTED] To: David T-G [EMAIL PROTECTED]; mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 5:11 AM Subject: RE: An Idea we find people just like to ask questions, and no matter how good our FAQ's and help are, many people have circumstances that make it more efficient to push the question into the queue, and wait for an answer to pop back later. lists work, and faq's work, some like to call...etc. personally, I'd prefer a search engine style... like google, but only for mySQL topics, and with a visible list of most popular search terms. something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Guten Rutsch Jim -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 4:36 PM To: mysql users Cc: Stefan Hinz, iConnect (Berlin) Subject: Re: An Idea -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % regarding the MySQL FAQ: % % Why should it have to be there? Let anyone with a site set it up and ... % % MySQL.com would be the natural place for the FAQ. Any other place % wouldn't be half as good. Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV tC44gsIMkjgUkNtZlkpZ+Y0= =XS30 -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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Re: FAQ hosting site (was Re: An Idea)
David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want, or can give a URL to where to find it, b) maybe someone has better ideas or comments on this. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Great. We should discuss everything else via this list, then. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 4:12 PM Subject: Re: FAQ hosting site (was Re: An Idea) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % see it dropped if they don't jump on it at the start. % % I agree. Will you set it up at http://justpickone.org/? (BTW, I like Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp (I wish we could sftp without then also having ssh; darn) and, meanwhile, it seems like this should be the sort of thing where we could either use CVS or a web update form or the like... Maybe a wiki will do for now, but I don't like only being able to get at it from the web :-) Anyone have any thoughts? % your website, especially the PIX :-) Thanks! :-) It needs an overhaul, but it gets the job done. % % Regards, % -- % Stefan Hinz [EMAIL PROTECTED] % Geschäftsführer / CEO iConnect GmbH http://iConnect.de % Heesestr. 6, 12169 Berlin (Germany) % Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 HTH HAND HNY :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur
RE: FAQ hosting site (was Re: An Idea)
I'm not following this threath.. but.. Use PHP to fetch mail from a mailbox, insert all questions into a database. Create a searchtool to search the database. No need to have way to many ppl as author. If you want you could have some ppl maintaining a list of keywords per question or remove a question from the database.. If you really persist to create something of your own you shouldn't create catagories. Most ppl don't really understand under which catagory their question could be found. Those who do will probably find an answer much quicker using google. --B. -Oorspronkelijk bericht- Van: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 1 januari 2003 22:26 Aan: David T-G; mysql users Onderwerp: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want, or can give a URL to where to find it, b) maybe someone has better ideas or comments on this. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Great. We should discuss everything else via this list, then. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 4:12 PM Subject: Re: FAQ hosting site (was Re: An Idea) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % see it dropped if they don't jump on it at the start. % % I agree. Will you set it up at http://justpickone.org/? (BTW, I like Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp (I wish we could sftp without then also having ssh; darn) and, meanwhile, it seems like this should be the sort
RE: FAQ hosting site (was Re: An Idea)
Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want, or can give a URL to where to find it, b) maybe someone has better ideas or comments on this. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Great. We should discuss everything else via this list, then. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 4:12 PM Subject: Re: FAQ hosting site (was Re: An Idea) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % see it dropped if they don't jump on it at the start. % % I agree. Will you set it up at http://justpickone.org/? (BTW, I like Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Now
RE: FAQ hosting site (was Re: An Idea)
I really need your help, I installed MySQL and I can connect to it through localhost but when trying to access it from outside I get: ERROR 2003: Can't connect to MySQL server on 'IP' (111) Any suggestions? Someone suggested that the problem is because the server has 2 nics (2 ips set up). Does anyone know a solution for this? --- Peter Lovatt [EMAIL PROTECTED] wrote: Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want, or can give a URL to where to find it, b) maybe someone has better ideas or comments on this. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Great. We should discuss everything else via this list, then. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED
RE: FAQ hosting site (was Re: An Idea)
Hi Is '111' the IP it is trying to connect on? If so it is an invalid IP. If the IP is valid how are you trying to connect? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: mnbv [mailto:[EMAIL PROTECTED]] Sent: 02 January 2003 00:23 To: Peter Lovatt; Stefan Hinz, iConnect (Berlin); David T-G; mysql users Subject: RE: FAQ hosting site (was Re: An Idea) I really need your help, I installed MySQL and I can connect to it through localhost but when trying to access it from outside I get: ERROR 2003: Can't connect to MySQL server on 'IP' (111) Any suggestions? Someone suggested that the problem is because the server has 2 nics (2 ips set up). Does anyone know a solution for this? --- Peter Lovatt [EMAIL PROTECTED] wrote: Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want
Re: FAQ hosting site (was Re: An Idea)
On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote: I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) Really? That's a wheel I've seen re-invented many times. I know there's stuff out there. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 17 days, processed 617,666,871 queries (401/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: FAQ hosting site (was Re: An Idea)
Hi I was looking for a reasonably heavyweight php application, there are some lightweight ones and some half finished ones and some perl ones, but none that were what I was looking for. Any suggestions would be appreciated, no point in reinventing the wheel. Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: 02 January 2003 00:37 To: Peter Lovatt Cc: Stefan Hinz, iConnect (Berlin); David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote: I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) Really? That's a wheel I've seen re-invented many times. I know there's stuff out there. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 17 days, processed 617,666,871 queries (401/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: FAQ hosting site (was Re: An Idea)
The 111 is the error code that MySQL generates. Check if your computer has a firewall, and make sure to enable port 3306 from external IPs e.g. on redhat using ipchains-based firewall, add: -A input -s 0/0 -d 0/0 3306 -p tcp -y -j ACCEPT to your /etc/sysconfig/ipchains file (or however the box is configured for the firewall). You'll also want to replace -s 0/0 with something a little more restrictive. cheers.. Dan On Thu, 2 Jan 2003, Peter Lovatt wrote: Hi Is '111' the IP it is trying to connect on? If so it is an invalid IP. If the IP is valid how are you trying to connect? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: mnbv [mailto:[EMAIL PROTECTED]] Sent: 02 January 2003 00:23 To: Peter Lovatt; Stefan Hinz, iConnect (Berlin); David T-G; mysql users Subject: RE: FAQ hosting site (was Re: An Idea) I really need your help, I installed MySQL and I can connect to it through localhost but when trying to access it from outside I get: ERROR 2003: Can't connect to MySQL server on 'IP' (111) Any suggestions? Someone suggested that the problem is because the server has 2 nics (2 ips set up). Does anyone know a solution for this? --- Peter Lovatt [EMAIL PROTECTED] wrote: Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should
Re: An Idea
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % So (taking a deep breath !) I would be prepared to lay the foundations ... % % Thanks, I appreciate that. I've been waiting a moment before answering, % waiting for others to take a deep breath and say yes, too, but it % seems you are the only one. I'd love to contribute, but not only am I very busy but also very new. I could probably contribute a lot of *questions*, but this FAQ is probably meant to also have *answers* :-) % % [James: ] $44.99 SRP - a low cost compared to the 'deep breath below % :-) % % I know there are good books, and I especially like Paul's books on % MySQL. There are good books by German authors on MySQL, too. I'm happy to hear of it; I may have to go out and pick it up! % % But, then again, refering to books will bring up the same sort of % answers people on this list are complaing about (hey, stupid, go buy % book xyz and read it before asking silly questions). With a FAQ, this Well, it would be nice to have a listing of readers' favorite and most helpful books so that newbies know *what* to go and pick out, for one thing; I don't think that book references are all bad! % could be You will find the answer for your question at % www.mysql.com/faq/answer_xyz.html. Yes; that's very good. % % So, any thoughts? Where do we go from here? % % Nowhere, I suppose :( Wait; quite on the contrary! I think that good work can start (granted, it would probably start faster if I jumped in to contribute more, but...) right now! % % Maybe some of the folks at MySQL AB will read this and come up with a % database structure for the FAQ on MySQL.com and user accounts for you % and me (and maybe others, once this thing has started). Why should it have to be there? Let anyone with a site set it up and get it going and see if readers will even care about it, and *then* perhaps have it move to mysql.com later... % % Regards, % -- % Stefan Hinz [EMAIL PROTECTED] % Geschäftsführer / CEO iConnect GmbH http://iConnect.de % Heesestr. 6, 12169 Berlin (Germany) % Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 HTH HAND Happy Holidays mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EXu2Gb7uCXufRwARAq2QAJ49JlM22lxrMndZLWf9BFzRvlrWQgCfU/LP M/PviclU9pDOmcKXOgmSPp8= =1os1 -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: An Idea
Hi A faq without questions would be pretty empty! While you have the questions why not keep a note (or send them to me) Once we have some momentum we can put some answers and tutorials together. I thought I would email MySql to see if they like the idea, if not then I will build it. Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: 31 December 2002 11:13 To: mysql users Cc: Stefan Hinz, iConnect (Berlin) Subject: Re: An Idea -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % So (taking a deep breath !) I would be prepared to lay the foundations ... % % Thanks, I appreciate that. I've been waiting a moment before answering, % waiting for others to take a deep breath and say yes, too, but it % seems you are the only one. I'd love to contribute, but not only am I very busy but also very new. I could probably contribute a lot of *questions*, but this FAQ is probably meant to also have *answers* :-) % % [James: ] $44.99 SRP - a low cost compared to the 'deep breath below % :-) % % I know there are good books, and I especially like Paul's books on % MySQL. There are good books by German authors on MySQL, too. I'm happy to hear of it; I may have to go out and pick it up! % % But, then again, refering to books will bring up the same sort of % answers people on this list are complaing about (hey, stupid, go buy % book xyz and read it before asking silly questions). With a FAQ, this Well, it would be nice to have a listing of readers' favorite and most helpful books so that newbies know *what* to go and pick out, for one thing; I don't think that book references are all bad! % could be You will find the answer for your question at % www.mysql.com/faq/answer_xyz.html. Yes; that's very good. % % So, any thoughts? Where do we go from here? % % Nowhere, I suppose :( Wait; quite on the contrary! I think that good work can start (granted, it would probably start faster if I jumped in to contribute more, but...) right now! % % Maybe some of the folks at MySQL AB will read this and come up with a % database structure for the FAQ on MySQL.com and user accounts for you % and me (and maybe others, once this thing has started). Why should it have to be there? Let anyone with a site set it up and get it going and see if readers will even care about it, and *then* perhaps have it move to mysql.com later... % % Regards, % -- % Stefan Hinz [EMAIL PROTECTED] % Geschäftsführer / CEO iConnect GmbH http://iConnect.de % Heesestr. 6, 12169 Berlin (Germany) % Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 HTH HAND Happy Holidays mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EXu2Gb7uCXufRwARAq2QAJ49JlM22lxrMndZLWf9BFzRvlrWQgCfU/LP M/PviclU9pDOmcKXOgmSPp8= =1os1 -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: An Idea
David, regarding the MySQL FAQ: Why should it have to be there? Let anyone with a site set it up and get it going and see if readers will even care about it, and *then* perhaps have it move to mysql.com later... MySQL.com would be the natural place for the FAQ. Any other place wouldn't be half as good. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: An Idea
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % regarding the MySQL FAQ: % % Why should it have to be there? Let anyone with a site set it up and ... % % MySQL.com would be the natural place for the FAQ. Any other place % wouldn't be half as good. Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV tC44gsIMkjgUkNtZlkpZ+Y0= =XS30 -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: An Idea
we find people just like to ask questions, and no matter how good our FAQ's and help are, many people have circumstances that make it more efficient to push the question into the queue, and wait for an answer to pop back later. lists work, and faq's work, some like to call...etc. personally, I'd prefer a search engine style... like google, but only for mySQL topics, and with a visible list of most popular search terms. something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Guten Rutsch Jim -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 4:36 PM To: mysql users Cc: Stefan Hinz, iConnect (Berlin) Subject: Re: An Idea -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % regarding the MySQL FAQ: % % Why should it have to be there? Let anyone with a site set it up and ... % % MySQL.com would be the natural place for the FAQ. Any other place % wouldn't be half as good. Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV tC44gsIMkjgUkNtZlkpZ+Y0= =XS30 -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: An Idea
On 12/31/02 8:11 PM, JamesD [EMAIL PROTECTED] wrote: lists work, and faq's work, some like to call...etc. personally, I'd prefer a search engine style... like google, but only for mySQL topics, and with a visible list of most popular search terms. something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Guten Rutsch Jim Isn't that funny: if I have a mysql related question and search google I end up in the mysql online documentation in 90% of cases. JM2Cs /h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: An Idea
Peter, So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. Thanks, I appreciate that. I've been waiting a moment before answering, waiting for others to take a deep breath and say yes, too, but it seems you are the only one. [James: ] $44.99 SRP - a low cost compared to the 'deep breath below :-) I know there are good books, and I especially like Paul's books on MySQL. There are good books by German authors on MySQL, too. But, then again, refering to books will bring up the same sort of answers people on this list are complaing about (hey, stupid, go buy book xyz and read it before asking silly questions). With a FAQ, this could be You will find the answer for your question at www.mysql.com/faq/answer_xyz.html. So, any thoughts? Where do we go from here? Nowhere, I suppose :( Maybe some of the folks at MySQL AB will read this and come up with a database structure for the FAQ on MySQL.com and user accounts for you and me (and maybe others, once this thing has started). Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Peter Lovatt [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; Cal Evans [EMAIL PROTECTED]; Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, December 30, 2002 1:18 AM Subject: RE: An Idea Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 29 December 2002 22:01 To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Cal, Paul, dear list, thank you, Cal, for your wise words ... Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Go to MySQL.com and type FAQ in the search box. This will provide 71 results, some of them with valuable FAQ-like information, but no real FAQ. Instead, we have this in every list mail: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) I would keep this shorter, saying Believe in God and do not sin ;-) But seriously: Anybody here interested in setting up a FAQ on MySQL.com / MySQL.de, - with silly common questions from this list, - and with answers in small tutorial format (something like http://www.mysql.com/articles/dotnet/index.html), - well organized (one person to collect / insert the silly questions), - easy to search (only search term + search by category), - easy to maintain (e. g. with user comments, like the English manual), - even easier to use as a referer than the MySQL manual when answering questions? Flame me if there _is_ a FAQ like this. At least I didn't find it at MySQL.com, which is most probably the first place a new MySQL user would look for it. I am the German translator of the official MySQL manual, so I could offer to translate as much as I can from the FAQ into German. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Cal Evans [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 6:00 PM Subject: RE: An Idea Because that's the way that (FoxPro, Access, Paradox, insert name of favorite desktop RDBMS here) did it and I can't make the jump to a real server based RDBMS! Why do you ask? :) Seriously, I find this type of issue (not your question Paul, the original question) one of the most troubling things about this list. We
An Idea
Hello, I had a problem few days ago. I'm doing my questbook, and I were thinking what would hapen if I delete some row. Now I know, nothing. I had one column ID (auto_increment) in my table. I wanted it to be one by one even after deleting, so I changed it by myself. But then (after deleting the last ID was 17, and before 32), next ID was 33, not 18. Is there any function, which can change it? If not, mayby you'll try to do something like that. It's right, I can do it by myself not using auto_increment, and giving the ID number MAX(ID)+1, but if there is such function it would be realy fine. Greatings, MySQL user Adam Wickowski GG# :1257924 ***r-e-k-l-a-m-a** Masz do pacenia prowizji bankowi ? mBank - za konto http://epieniadze.onet.pl/mbank - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: An Idea
Hello. On Sun 2002-12-29 at 11:26:01 +0100, [EMAIL PROTECTED] wrote: Hello, I had a problem few days ago. I'm doing my questbook, and I were thinking what would hapen if I delete some row. Now I know, nothing. I had one column ID (auto_increment) in my table. I wanted it to be one by one even after deleting, so I changed it by myself. But then (after deleting the last ID was 17, and before 32), next ID was 33, not 18. Is there any function, which can change it? If not, mayby you'll try to do something like that. It's right, I can do it by myself not using auto_increment, and giving the ID number MAX(ID)+1, but if there is such function it would be realy fine. What you describe was the behaviour in older MySQL versions and it has been changed because primary keys should never be reused. Never. If you need it to have no holes, you are abusing the primary key for something which it is not intended for (visible entry numbering?). So, yes, you have to either implement it yourself, or, what I would recommend, have a seperate column for it or calculate it in your application, whatever makes most sense for your use. HTH, Benjamin. PS: AFAIK, InnoDB still has the old behaviour. Anyhow, it will change soon enough. -- [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: An Idea
On Sunday 29 December 2002 12:26, Adam Wiêckowski wrote: I had a problem few days ago. I'm doing my questbook, and I were thinking what would hapen if I delete some row. Now I know, nothing. I had one column ID (auto_increment) in my table. I wanted it to be one by one even after deleting, so I changed it by myself. But then (after deleting the last ID was 17, and before 32), next ID was 33, not 18. Is there any function, which can change it? Nope. It's expected behaviour for MyISAM and InnoDB tables. If not, mayby you'll try to do something like that. It's right, I can do it by myself not using auto_increment, and giving the ID number MAX(ID)+1, but if there is such function it would be realy fine. Sure, you can do it, but you should lock table, retrieve max id value, insert max+1 value, unlock table. -- 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: An Idea
At 11:26 +0100 12/29/02, Adam Wi´ckowski wrote: Hello, I had a problem few days ago. I'm doing my questbook, and I were thinking what would hapen if I delete some row. Now I know, nothing. I had one column ID (auto_increment) in my table. I wanted it to be one by one Why? even after deleting, so I changed it by myself. But then (after deleting the last ID was 17, and before 32), next ID was 33, not 18. Is there any function, which can change it? If not, mayby you'll try to do something like that. It's right, I can do it by myself not using auto_increment, and giving the ID number MAX(ID)+1, but if there is such function it would be realy fine. Greatings, MySQL user Adam Wi´ckowski GG# :1257924 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: An Idea
At 11:26 AM 12/29/2002 +0100, =?iso-8859-2?Q?Adam_Wi=EAckowski?= wrote: Hello, I had a problem few days ago. I'm doing my questbook, and I were thinking what would hapen if I delete some row. Now I know, nothing. I had one column ID (auto_increment) in my table. I wanted it to be one by one even after deleting, so I changed it by myself. Don't use the PK for numbering. Instead, in PHP, ASP, etc, just use a counter when looping through your guestbook entries and label them 1, 2, 3, etc. BTW, does MySQL have a RowNumber function? -- 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: An Idea
Because that's the way that (FoxPro, Access, Paradox, insert name of favorite desktop RDBMS here) did it and I can't make the jump to a real server based RDBMS! Why do you ask? :) Seriously, I find this type of issue (not your question Paul, the original question) one of the most troubling things about this list. We as a community of SQL developers (regardless of dialect) need to make a more concentrated effort to explain the differences between desktop databases and real database engines. We need to educate people making the changeover before releasing them into the wild. (Maybe the link to download MySql could ask a few basic questions to prove you know what you are doing before being allowed to download!) :) I cut my teeth on FoxPro. The first SQL I wrote was in the FoxPro (2.5/6?) dialect. I know from whence I speak because I asked these same questions many years ago. Luckily, I found people who kindly but firmly pointed me in the right direction. (You DON'T need gapless sequences for PK's. You DON'T store images in the actual database without permission from God. Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Thank you, come again.) They showed me the light and occasionally I try to share what little I know with others. I guess what I'm trying to say is to those who know something (even if you are like me and are constantly amazed at what you DON'T know) share kindly and willingly. To those seeking enlightenment...RTFM you mook! Check the !*#^ archives and use Google, this issue has been beat to death! Humbly, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 10:02 AM To: Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Why? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: An Idea
On Sun, Dec 29, 2002 at 11:43:35AM -0500, Michael She wrote: BTW, does MySQL have a RowNumber function? You can use variables: select @a := 0; select id, more, fields, @a:= @a + 1 as rownumber from whatever; But you cannot use that number in the where part. Good luck. (sql, etc) -- The Moon is Waning Crescent (21% of Full) nieuw.nl - 2dehands.nl: 58038 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: An Idea
Cal, Paul, dear list, thank you, Cal, for your wise words ... Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Go to MySQL.com and type FAQ in the search box. This will provide 71 results, some of them with valuable FAQ-like information, but no real FAQ. Instead, we have this in every list mail: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) I would keep this shorter, saying Believe in God and do not sin ;-) But seriously: Anybody here interested in setting up a FAQ on MySQL.com / MySQL.de, - with silly common questions from this list, - and with answers in small tutorial format (something like http://www.mysql.com/articles/dotnet/index.html), - well organized (one person to collect / insert the silly questions), - easy to search (only search term + search by category), - easy to maintain (e. g. with user comments, like the English manual), - even easier to use as a referer than the MySQL manual when answering questions? Flame me if there _is_ a FAQ like this. At least I didn't find it at MySQL.com, which is most probably the first place a new MySQL user would look for it. I am the German translator of the official MySQL manual, so I could offer to translate as much as I can from the FAQ into German. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Cal Evans [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 6:00 PM Subject: RE: An Idea Because that's the way that (FoxPro, Access, Paradox, insert name of favorite desktop RDBMS here) did it and I can't make the jump to a real server based RDBMS! Why do you ask? :) Seriously, I find this type of issue (not your question Paul, the original question) one of the most troubling things about this list. We as a community of SQL developers (regardless of dialect) need to make a more concentrated effort to explain the differences between desktop databases and real database engines. We need to educate people making the changeover before releasing them into the wild. (Maybe the link to download MySql could ask a few basic questions to prove you know what you are doing before being allowed to download!) :) I cut my teeth on FoxPro. The first SQL I wrote was in the FoxPro (2.5/6?) dialect. I know from whence I speak because I asked these same questions many years ago. Luckily, I found people who kindly but firmly pointed me in the right direction. (You DON'T need gapless sequences for PK's. You DON'T store images in the actual database without permission from God. Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Thank you, come again.) They showed me the light and occasionally I try to share what little I know with others. I guess what I'm trying to say is to those who know something (even if you are like me and are constantly amazed at what you DON'T know) share kindly and willingly. To those seeking enlightenment...RTFM you mook! Check the !*#^ archives and use Google, this issue has been beat to death! Humbly, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 10:02 AM To: Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Why? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: An Idea
Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 29 December 2002 22:01 To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Cal, Paul, dear list, thank you, Cal, for your wise words ... Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Go to MySQL.com and type FAQ in the search box. This will provide 71 results, some of them with valuable FAQ-like information, but no real FAQ. Instead, we have this in every list mail: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) I would keep this shorter, saying Believe in God and do not sin ;-) But seriously: Anybody here interested in setting up a FAQ on MySQL.com / MySQL.de, - with silly common questions from this list, - and with answers in small tutorial format (something like http://www.mysql.com/articles/dotnet/index.html), - well organized (one person to collect / insert the silly questions), - easy to search (only search term + search by category), - easy to maintain (e. g. with user comments, like the English manual), - even easier to use as a referer than the MySQL manual when answering questions? Flame me if there _is_ a FAQ like this. At least I didn't find it at MySQL.com, which is most probably the first place a new MySQL user would look for it. I am the German translator of the official MySQL manual, so I could offer to translate as much as I can from the FAQ into German. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Cal Evans [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 6:00 PM Subject: RE: An Idea Because that's the way that (FoxPro, Access, Paradox, insert name of favorite desktop RDBMS here) did it and I can't make the jump to a real server based RDBMS! Why do you ask? :) Seriously, I find this type of issue (not your question Paul, the original question) one of the most troubling things about this list. We as a community of SQL developers (regardless of dialect) need to make a more concentrated effort to explain the differences between desktop databases and real database engines. We need to educate people making the changeover before releasing them into the wild. (Maybe the link to download MySql could ask a few basic questions to prove you know what you are doing before being allowed to download!) :) I cut my teeth on FoxPro. The first SQL I wrote was in the FoxPro (2.5/6?) dialect. I know from whence I speak because I asked these same questions many years ago. Luckily, I found people who kindly but firmly pointed me in the right direction. (You DON'T need gapless sequences for PK's. You DON'T store images in the actual database without permission from God. Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Thank you, come again.) They showed me the light and occasionally I try to share what little I know with others. I guess what I'm trying to say is to those who know something (even if you are like me and are constantly amazed at what you DON'T know) share kindly and willingly. To those seeking enlightenment...RTFM you mook! Check the !*#^ archives and use Google, this issue has been beat to death! Humbly, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 10:02 AM To: Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Why? - Before posting, please check
RE: An Idea
while Paul probably wouldnt say it, I would: his book: MySql and Perl for the Web ISBN 0-7357-1054-6 New Riders Publishing answers the questions you are getting at below, and IMHO the book is excellent as a how do i get started... and more... $44.99 SRP - a low cost compared to the 'deep breath below :-) like any book, to drive through it all the way, inch by inch, and learn, takes some time and focus. James Danforth,COO Neovi Data Corp www.qchex.com -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 4:18 PM To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: RE: An Idea Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 29 December 2002 22:01 To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Cal, Paul, dear list, thank you, Cal, for your wise words ... Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Go to MySQL.com and type FAQ in the search box. This will provide 71 results, some of them with valuable FAQ-like information, but no real FAQ. Instead, we have this in every list mail: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) I would keep this shorter, saying Believe in God and do not sin ;-) But seriously: Anybody here interested in setting up a FAQ on MySQL.com / MySQL.de, - with silly common questions from this list, - and with answers in small tutorial format (something like http://www.mysql.com/articles/dotnet/index.html), - well organized (one person to collect / insert the silly questions), - easy to search (only search term + search by category), - easy to maintain (e. g. with user comments, like the English manual), - even easier to use as a referer than the MySQL manual when answering questions? Flame me if there _is_ a FAQ like this. At least I didn't find it at MySQL.com, which is most probably the first place a new MySQL user would look for it. I am the German translator of the official MySQL manual, so I could offer to translate as much as I can from the FAQ into German. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Cal Evans [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 6:00 PM Subject: RE: An Idea Because that's the way that (FoxPro, Access, Paradox, insert name of favorite desktop RDBMS here) did it and I can't make the jump to a real server based RDBMS! Why do you ask? :) Seriously, I find this type of issue (not your question Paul, the original question) one of the most troubling things about this list. We as a community of SQL developers (regardless of dialect) need to make a more concentrated effort to explain the differences between desktop databases and real database engines. We need to educate people making the changeover before releasing them into the wild. (Maybe the link to download MySql could ask a few basic questions to prove you know what you are doing before being allowed to download!) :) I cut my teeth on FoxPro. The first SQL I wrote was in the FoxPro (2.5/6?) dialect. I know from whence I speak because I asked these same questions many years ago. Luckily, I found people who kindly but firmly pointed me in the right direction. (You DON'T need gapless sequences for PK's. You DON'T store images in the actual database without permission from God. Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Thank you, come again.) They showed me the light and occasionally I try to share
RE: An Idea
Hi I think the two would serve different purposes. Paul's book is a best friend but. It may take 2-3 days to get a copy (unless you live in a good technical bookshop) and often people want an answer now. Although it's good value, not everyone (casual users, students, newbies making their first steps) will be able or want to pay over $40 for a book (though I agree it is good value if you do) Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: JamesD [mailto:[EMAIL PROTECTED]] Sent: 30 December 2002 01:35 To: Peter Lovatt; [EMAIL PROTECTED] Subject: RE: An Idea while Paul probably wouldnt say it, I would: his book: MySql and Perl for the Web ISBN 0-7357-1054-6 New Riders Publishing answers the questions you are getting at below, and IMHO the book is excellent as a how do i get started... and more... $44.99 SRP - a low cost compared to the 'deep breath below :-) like any book, to drive through it all the way, inch by inch, and learn, takes some time and focus. James Danforth,COO Neovi Data Corp www.qchex.com -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 4:18 PM To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: RE: An Idea Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 29 December 2002 22:01 To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Cal, Paul, dear list, thank you, Cal, for your wise words ... Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Go to MySQL.com and type FAQ in the search box. This will provide 71 results, some of them with valuable FAQ-like information, but no real FAQ. Instead, we have this in every list mail: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) I would keep this shorter, saying Believe in God and do not sin ;-) But seriously: Anybody here interested in setting up a FAQ on MySQL.com / MySQL.de, - with silly common questions from this list, - and with answers in small tutorial format (something like http://www.mysql.com/articles/dotnet/index.html), - well organized (one person to collect / insert the silly questions), - easy to search (only search term + search by category), - easy to maintain (e. g. with user comments, like the English manual), - even easier to use as a referer than the MySQL manual when answering questions? Flame me if there _is_ a FAQ like this. At least I didn't find it at MySQL.com, which is most probably the first place a new MySQL user would look for it. I am the German translator of the official MySQL manual, so I could offer to translate as much as I can from the FAQ into German. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Cal Evans [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 6:00 PM Subject: RE: An Idea Because that's the way that (FoxPro, Access, Paradox, insert name of favorite desktop RDBMS here) did it and I can't make the jump to a real server based RDBMS! Why do you ask? :) Seriously, I find this type of issue (not your question Paul, the original question) one of the most troubling things about this list. We as a community of SQL developers (regardless of dialect) need to make a more concentrated effort to explain the differences
RE: An Idea
Paul's book is an excellent one. I also recommend (to anyone who asks): http://froogle.google.com/froogle?q=%22SQL+For+Dummies%22btnG=Froogle+Searc h and http://froogle.google.com/froogle?q=%22SQL+For+Smarties%22btnG=Froogle+Sear ch 2 more excellent resources. * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: JamesD [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 7:35 PM To: Peter Lovatt; [EMAIL PROTECTED] Subject: RE: An Idea while Paul probably wouldnt say it, I would: his book: MySql and Perl for the Web ISBN 0-7357-1054-6 New Riders Publishing answers the questions you are getting at below, and IMHO the book is excellent as a how do i get started... and more... $44.99 SRP - a low cost compared to the 'deep breath below :-) like any book, to drive through it all the way, inch by inch, and learn, takes some time and focus. James Danforth,COO Neovi Data Corp www.qchex.com -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 4:18 PM To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: RE: An Idea Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 29 December 2002 22:01 To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Cal, Paul, dear list, thank you, Cal, for your wise words ... Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Go to MySQL.com and type FAQ in the search box. This will provide 71 results, some of them with valuable FAQ-like information, but no real FAQ. Instead, we have this in every list mail: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) I would keep this shorter, saying Believe in God and do not sin ;-) But seriously: Anybody here interested in setting up a FAQ on MySQL.com / MySQL.de, - with silly common questions from this list, - and with answers in small tutorial format (something like http://www.mysql.com/articles/dotnet/index.html), - well organized (one person to collect / insert the silly questions), - easy to search (only search term + search by category), - easy to maintain (e. g. with user comments, like the English manual), - even easier to use as a referer than the MySQL manual when answering questions? Flame me if there _is_ a FAQ like this. At least I didn't find it at MySQL.com, which is most probably the first place a new MySQL user would look for it. I am the German translator of the official MySQL manual, so I could offer to translate as much as I can from the FAQ into German. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Cal Evans [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 6:00 PM Subject: RE: An Idea Because that's the way that (FoxPro, Access, Paradox, insert name of favorite desktop RDBMS here) did it and I can't make the jump to a real server based RDBMS! Why do you ask? :) Seriously, I find this type of issue (not your question Paul, the original question) one of the most troubling things about this list. We as a community of SQL developers (regardless of dialect) need to make a more concentrated effort to explain the differences between desktop databases and real database engines. We need to educate people making the changeover before releasing them into the wild. (Maybe the link to download MySql could ask a few basic questions to prove you know what you are doing before being allowed to download!) :) I cut my teeth on FoxPro. The first SQL I wrote was in the FoxPro (2.5/6
RE: An Idea (really: MySQL and Perl for the Web)
we are all in sales, 24/7. :-) Jim -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 9:24 PM To: JamesD; Peter Lovatt; [EMAIL PROTECTED] Subject: RE: An Idea (really: MySQL and Perl for the Web) At 17:35 -0800 12/29/02, JamesD wrote: while Paul probably wouldnt say it, I would: Well, I *have* been known to make shameless plugs from time to time, but of course it's better if readers make them for me. :-) So, thanks, I appreciate it. his book: MySql and Perl for the Web ISBN 0-7357-1054-6 New Riders Publishing answers the questions you are getting at below, and IMHO the book is excellent as a how do i get started... and more... $44.99 SRP - a low cost compared to the 'deep breath below :-) I of course appreciate it when people purchase a copy of the book, but for those who prefer to take a look at part of it first, I will point out that there is a sample chapter available online at: http://www.kitebird.com/mysql-perl/ It's a 78-page PDF, and it deals with a number of questions that probably would come up in a FAQ, but in more detail. For example, it answers the oft-posed questions: how do I store images in MySQL? and how do I retrieve images from MySQL for display in a Web page? The sample code that implements the answers to these questions is also available at the URL above, as are some sample applications. (One of which is an e-card thing that demonstrates image retrieval and display.) I guess that's enough shameless plugging for now. :-) like any book, to drive through it all the way, inch by inch, and learn, takes some time and focus. James Danforth,COO Neovi Data Corp www.qchex.com -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 4:18 PM To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: RE: An Idea Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: An Idea (really: MySQL and Perl for the Web)
At 17:35 -0800 12/29/02, JamesD wrote: while Paul probably wouldnt say it, I would: Well, I *have* been known to make shameless plugs from time to time, but of course it's better if readers make them for me. :-) So, thanks, I appreciate it. his book: MySql and Perl for the Web ISBN 0-7357-1054-6 New Riders Publishing answers the questions you are getting at below, and IMHO the book is excellent as a how do i get started... and more... $44.99 SRP - a low cost compared to the 'deep breath below :-) I of course appreciate it when people purchase a copy of the book, but for those who prefer to take a look at part of it first, I will point out that there is a sample chapter available online at: http://www.kitebird.com/mysql-perl/ It's a 78-page PDF, and it deals with a number of questions that probably would come up in a FAQ, but in more detail. For example, it answers the oft-posed questions: how do I store images in MySQL? and how do I retrieve images from MySQL for display in a Web page? The sample code that implements the answers to these questions is also available at the URL above, as are some sample applications. (One of which is an e-card thing that demonstrates image retrieval and display.) I guess that's enough shameless plugging for now. :-) like any book, to drive through it all the way, inch by inch, and learn, takes some time and focus. James Danforth,COO Neovi Data Corp www.qchex.com -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 4:18 PM To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: RE: An Idea Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RES: SQL Select Idea [ORDER BY]
Hi Michael, Using two select's we already solved the problem. The challenge is to make the same thing using just one select. I need to know if is there an way to get the last date or the 10th index to make the WHERE part. Like the LAST_INDEX() function, that gets the last AUTO_INCREMENT...but I just saw apllacation using the update command. Well, any new ideas? Best Regards, Felipe -Mensagem original- De: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Enviada em: quinta-feira, 5 de dezembro de 2002 21:03 Para: [EMAIL PROTECTED] Assunto: Re: SQL Select Idea [ORDER BY] On Thu, Dec 05, 2002 at 08:54:29PM -0200, Felipe Moreno - MAILING LISTS wrote: Well, could you explain the behave of ORDER BY DATE,COD? Just try it (it will order by date, then cod). What I think you want is (as I originally said, but briefly): create temporary table top10 select * from ... limit 10; select * from top10 order by cod; ... SQL -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RES: RES: RES: SQL Select Idea
Hi Michael, The ten last dates appear as a default result of a Archives page. When I enter for the first time in the page, it give me the last ten Files that was uploaded. In the same page, I can ORDER BY the ten last dates results by COD, DATE, NAME or FILE. So, when I click in some os then, I need to ORDER the TEN DATES, not the entire table and give ten results, did you get it? Any idea? Regards, Felipe -Mensagem original- De: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Enviada em: quarta-feira, 4 de dezembro de 2002 17:33 Para: [EMAIL PROTECTED] Assunto: Re: RES: RES: SQL Select Idea On Wed, Dec 04, 2002 at 08:55:51AM -0200, Felipe Moreno - MAILING LISTS wrote: Well, the SQL Query you requested is exatcly the one I'm asking! :-) No; I want to know what you intended for those 10 dates to do. The LIMIT query worked, as posted by someone else, which you quoted. What do you then intend to do with that data? Since I have a link in the header of the tabel that make the ORDER BY work, when I select de COD after the result above, I should get: [ you didn't give the EXACT SQL QUERY that you're typing in; please give it ] Again, you didn't quote the when I select the COD after ... -- what is that query? And how do you expect it to behave. I'm assuming that you're forgetting a step, or misunderstanding a step involved. Are you doing anything with that data you're selecting, or just selecting it and leaving it? You might be wanting to select it into a new table or something; look up INSERT INTO ... SELECT FROM This still applies. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Select Idea [ORDER BY]
On Thu, Dec 05, 2002 at 09:41:24AM -0200, Felipe Moreno - MAILING LISTS wrote: The ten last dates appear as a default result of a Archives page. When I enter for the first time in the page, it give me the last ten Files that was uploaded. In the same page, I can ORDER BY the ten last dates results by COD, DATE, NAME or FILE. So, when I click in some os then, I need to ORDER the TEN DATES, not the entire table and give ten results, did you get it? So you want your query to have 'ORDER BY DATE,COD' ?? -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) 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
RES: SQL Select Idea [ORDER BY]
Well, could you explain the behave of ORDER BY DATE,COD? I will show you bellow what I want, graphically: 1) What I have: Table: processo_arquivos _ |Cod| Date | - |1 | 12/10 | - |2 | 13/10 | - |3 | 14/10 | - |4 | 15/10 | - |5 | 16/10 | - 2) What I get if I use the: SELECT * FROM processo_arquivos ORDER BY DATE DESC LIMIT 0,3 (considering that I only want 3) _ |Cod| Date | - |5 | 16/10 | - |4 | 15/10 | - |3 | 14/10 | - 3) The problem getting the result like this: Since I have a link in the header of the tabel that make the ORDER BY work, when I select de COD after the result above, I should get: PS: When I select the COD (order by COD) it sends the ORDER BY value to the same select above. _ |Cod (link) | Date | - |3 | 14/10 | - |4 | 15/10 | - |5 | 16/10 | - but instead of the above I get: _ |Cod| Date | - |1 | 12/10 | - |2 | 13/10 | - |3 | 14/10 | - So, the problem is when I select a new ORDER BY I make the query in the entire Table. What I want is to make the query only in the matched results. I have a php page that starts with a default search (the ten dates). So, what I really need ia an way to make a select without any data from the DB. I tried to use de LAST_INDEX() function to do this but I didn't go anywhere. Any ideas??? -Mensagem original- De: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Enviada em: quinta-feira, 5 de dezembro de 2002 16:02 Para: [EMAIL PROTECTED] Assunto: Re: SQL Select Idea [ORDER BY] On Thu, Dec 05, 2002 at 09:41:24AM -0200, Felipe Moreno - MAILING LISTS wrote: The ten last dates appear as a default result of a Archives page. When I enter for the first time in the page, it give me the last ten Files that was uploaded. In the same page, I can ORDER BY the ten last dates results by COD, DATE, NAME or FILE. So, when I click in some os then, I need to ORDER the TEN DATES, not the entire table and give ten results, did you get it? So you want your query to have 'ORDER BY DATE,COD' ?? -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Select Idea [ORDER BY]
On Thu, Dec 05, 2002 at 08:54:29PM -0200, Felipe Moreno - MAILING LISTS wrote: Well, could you explain the behave of ORDER BY DATE,COD? Just try it (it will order by date, then cod). What I think you want is (as I originally said, but briefly): create temporary table top10 select * from ... limit 10; select * from top10 order by cod; ... SQL -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) 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
RES: RES: SQL Select Idea
Hi Michael, Well, the SQL Query you requested is exatcly the one I'm asking! :-) Like I said in other message, I solved the problem using TWO queries. In the first one I get the 10th date. In the second one I use this date to LIMIT the result to what I want. But is not a question of solving the problem, but a question for a better designed query. I just want to use 1 (one) select to do the same thing that the two selects above do, if it is possible of course. Below, I will show you the actual scenary, and after, the question, how can I optimize it to use just one select?. If I can get the value of the LAST index, I can subtract 10 indexes from this value and get only this range of values, doing this I will get the last ten dates without the LIMIT 0,10 that don't give me what I want. Actual scenary: // This is the main select that give me the last ten dates. $sql = select pa.codigo,arquivo,label,tipo,DATE_FORMAT(data,'%d/%m/%Y - %H:%i') as ndata,RS,ref_wicie from processo_arquivos as pa,cliente as c,processo as p where pa.codigocliente=c.codigo and pa.codigoprocesso=p.codigo ; // This is the FIRST select that catch the LIMIT date $sql2 = select data from processo_arquivos as pa,cliente as c,processo as p where pa.codigocliente=c.codigo and pa.codigoprocesso=p.codigo order by data desc limit 0,11; $conexao-Query($sql2,$this-banco,$this-valor); $i = 0; if ($conexao-Select($this-banco)){ while (($this-valor = mysql_fetch_array($this-banco)) ($i10)){ $i++; } $dataLimite = $this-valor['data']; $sql .= and data'.$dataLimite.' ; --- Here I select the last ten dates. } What I wanted: --- ??? Just do what I'm doing above using only ONE select. Any tips? Best Regards, Felipe -Mensagem original- De: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Enviada em: quarta-feira, 4 de dezembro de 2002 02:06 Para: [EMAIL PROTECTED] Assunto: Re: RES: SQL Select Idea On Tue, Dec 03, 2002 at 07:02:02PM -0200, Felipe Moreno - MAILING LISTS wrote: 2) What I get is I use the SELECT * FROM processo_arquivos ORDER BY DATE DESC LIMIT 0,3 (considering that I only want 3) [ that worked as described ] 3) The problem getting the result like this: Since I have a link in the header of the tabel that make the ORDER BY work, when I select de COD after the result above, I should get: [ you didn't give the EXACT SQL QUERY that you're typing in; please give it ] I'm assuming that you're forgetting a step, or misunderstanding a step involved. Are you doing anything with that data you're selecting, or just selecting it and leaving it? You might be wanting to select it into a new table or something; look up INSERT INTO ... SELECT FROM -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RES: RES: SQL Select Idea
On Wed, Dec 04, 2002 at 08:55:51AM -0200, Felipe Moreno - MAILING LISTS wrote: Well, the SQL Query you requested is exatcly the one I'm asking! :-) No; I want to know what you intended for those 10 dates to do. The LIMIT query worked, as posted by someone else, which you quoted. What do you then intend to do with that data? Since I have a link in the header of the tabel that make the ORDER BY work, when I select de COD after the result above, I should get: [ you didn't give the EXACT SQL QUERY that you're typing in; please give it ] Again, you didn't quote the when I select the COD after ... -- what is that query? And how do you expect it to behave. I'm assuming that you're forgetting a step, or misunderstanding a step involved. Are you doing anything with that data you're selecting, or just selecting it and leaving it? You might be wanting to select it into a new table or something; look up INSERT INTO ... SELECT FROM This still applies. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) 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
SQL Select Idea
Hi List Users, I want to know if anyone has any idea on how can I do the SQL command below to archive a result. I have one table called processo_arquivos that have a filed called DATE and another FIELD called COD (primary key). I want to select the last TEN (10) dates from the Database, but only the last TEN. How Can I do this? Any ideia? I tried the sql bellow o archive this, but I was unable to do it. I just want to do this with ONLY one select, not with two. Thanks for any idea. Regards, Felipe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SQL Select Idea
I believe that SELECT * FROM processo_arquivos ORDER BY date DESC LIMIT 10; Should do it. Mike Hillyer -Original Message- From: Felipe Moreno - MAILING LISTS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 9:39 AM To: [EMAIL PROTECTED] Subject: SQL Select Idea Importance: High Hi List Users, I want to know if anyone has any idea on how can I do the SQL command below to archive a result. I have one table called processo_arquivos that have a filed called DATE and another FIELD called COD (primary key). I want to select the last TEN (10) dates from the Database, but only the last TEN. How Can I do this? Any ideia? I tried the sql bellow o archive this, but I was unable to do it. I just want to do this with ONLY one select, not with two. Thanks for any idea. Regards, Felipe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SQL Select Idea
Something on the order of... SELECT * FROM processo_arquivos ORDER BY DATE DESC LIMIT 0,10 Seems like that ought to do it.. Jim Jim Esten Chief Techbot WebDynamic http://www.wdynamic.com -Original Message- From: Felipe Moreno - MAILING LISTS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 10:39 AM To: [EMAIL PROTECTED] Subject: SQL Select Idea Importance: High Hi List Users, I want to know if anyone has any idea on how can I do the SQL command below to archive a result. I have one table called processo_arquivos that have a filed called DATE and another FIELD called COD (primary key). I want to select the last TEN (10) dates from the Database, but only the last TEN. How Can I do this? Any ideia? I tried the sql bellow o archive this, but I was unable to do it. I just want to do this with ONLY one select, not with two. Thanks for any idea. Regards, Felipe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RES: SQL Select Idea
Hi Jim and others that tried to help me! Thanks for any kind os answer. Well, the SQL command that you suggested don't work for me. Below, I will show What I want and what I get if I use the select command you suggested: 1) What I have: Table: processo_arquivos _ |Cod| Date | - |1 | 12/10 | - |2 | 13/10 | - |3 | 14/10 | - |4 | 15/10 | - |5 | 16/10 | - 2) What I get is I use the SELECT * FROM processo_arquivos ORDER BY DATE DESC LIMIT 0,3 (considering that I only want 3) _ |Cod| Date | - |5 | 16/10 | - |4 | 15/10 | - |3 | 14/10 | - 3) The problem getting the result like this: Since I have a link in the header of the tabel that make the ORDER BY work, when I select de COD after the result above, I should get: _ |Cod| Date | - |3 | 14/10 | - |4 | 15/10 | - |5 | 16/10 | - but instead of the above I get: _ |Cod| Date | - |1 | 12/10 | - |2 | 13/10 | - |3 | 14/10 | - So, the problem is when I select a new ORDER BY I make the query in the entire Table. What I want is to make the query only in the matched results. I have a php page that starts with a default search (the ten dates). So, what I really need ia an way to make a select without any data from the DB. I tried to use de LAST_INDEX() function to do this but I didn't go anywhere. Any ideas??? Best Regards, Felipe -Mensagem original- De: Jim Esten [mailto:[EMAIL PROTECTED]] Enviada em: terça-feira, 3 de dezembro de 2002 17:40 Para: 'Felipe Moreno - MAILING LISTS'; [EMAIL PROTECTED] Assunto: RE: SQL Select Idea Something on the order of... SELECT * FROM processo_arquivos ORDER BY DATE DESC LIMIT 0,10 Seems like that ought to do it.. Jim Jim Esten Chief Techbot WebDynamic http://www.wdynamic.com -Original Message- From: Felipe Moreno - MAILING LISTS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 10:39 AM To: [EMAIL PROTECTED] Subject: SQL Select Idea Importance: High Hi List Users, I want to know if anyone has any idea on how can I do the SQL command below to archive a result. I have one table called processo_arquivos that have a filed called DATE and another FIELD called COD (primary key). I want to select the last TEN (10) dates from the Database, but only the last TEN. How Can I do this? Any ideia? I tried the sql bellow o archive this, but I was unable to do it. I just want to do this with ONLY one select, not with two. Thanks for any idea. Regards, Felipe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SQL Select Idea
Is anyone else experiencing long delays in posts? I sent this about 5 hours before it posted. Thanks, Jim -Original Message- From: Jim Esten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 1:40 PM To: 'Felipe Moreno - MAILING LISTS'; [EMAIL PROTECTED] Subject: RE: SQL Select Idea Something on the order of... SELECT * FROM processo_arquivos ORDER BY DATE DESC LIMIT 0,10 Seems like that ought to do it.. Jim Jim Esten Chief Techbot WebDynamic http://www.wdynamic.com -Original Message- From: Felipe Moreno - MAILING LISTS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 10:39 AM To: [EMAIL PROTECTED] Subject: SQL Select Idea Importance: High Hi List Users, I want to know if anyone has any idea on how can I do the SQL command below to archive a result. I have one table called processo_arquivos that have a filed called DATE and another FIELD called COD (primary key). I want to select the last TEN (10) dates from the Database, but only the last TEN. How Can I do this? Any ideia? I tried the sql bellow o archive this, but I was unable to do it. I just want to do this with ONLY one select, not with two. Thanks for any idea. Regards, Felipe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RES: SQL Select Idea
On Tue, Dec 03, 2002 at 07:02:02PM -0200, Felipe Moreno - MAILING LISTS wrote: 2) What I get is I use the SELECT * FROM processo_arquivos ORDER BY DATE DESC LIMIT 0,3 (considering that I only want 3) [ that worked as described ] 3) The problem getting the result like this: Since I have a link in the header of the tabel that make the ORDER BY work, when I select de COD after the result above, I should get: [ you didn't give the EXACT SQL QUERY that you're typing in; please give it ] I'm assuming that you're forgetting a step, or misunderstanding a step involved. Are you doing anything with that data you're selecting, or just selecting it and leaving it? You might be wanting to select it into a new table or something; look up INSERT INTO ... SELECT FROM -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) 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: Data base driven web page idea - need help!
Grant, I need help. I am building a database for a small college that wants to be able to update their program information for each department through an web/gui program. I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my web page this way) Here's my QUESTION! Because some of the program information is large I don't want to query the data base everytime do I? =Most use LAMPs (Linux (sorry of that is not quite kosher for FreeBSD), Apache, MySQL, and PHP) to create DYNAMIC web sites. As such, every query from a user results in a back-end database interaction. Amazon, Yahoo, Google, etc have large back-end databases and thousands of (concurrent) users and every 'click' requires a database interaction. =In your case, the transaction rate will be significantly lower, even if the volume-transmitted per click may be large. =Database retrieval and PHP formatting speeds are insignificant when compared to Internet transmission speeds - and even bulk text/page downloads over a campus network. This would take up to many resources. So I've decided to write a program that will take the information from the MYSQL tables and build static pages every night and remove the old ones through a cron job? How does this sound? =caching seems like a reasonable approach, where possible. Remember though, there is a lot of effort involved in managing that overnight process! =Can I assume that the information doesn't change frequently? =You talk in terms of large. Can you quantify this? =Instead of caching, could you have your authors develop the basic program description pages as static HTML? Then your database has no need to store page-data, but only a filename: when the end-user requests information, the database chooses a file, and PHP instructs Apache to display same. Much the same as you have described above, but with fewer management headaches!? =You seem to be saying that there will only be one or two types of query that the system will face. Correct? If I'm off-base, then perhaps more description might help attune... Is this standard practice, if not what would be a better way of doing this. This college has about 1600 students? Thanks in advance, I plan on doing alot of planning and really apreciate reading this email. =Concur. It is cheaper to make planning changes/mistakes at this level, than to get an ugly surprise in the coding/testing phases! 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: Data base driven web page idea - need help!
This is correct, only two types of queries. Updating and Deleting. =Can I assume that the information doesn't change frequently? This is correct. The plan is to stream line the web site and get the information out faster and cut out the red tape. We were thinking intern's from each department, no matter how computer illiterate they are could open a GUI or Web interface to change there data. =You talk in terms of large. Can you quantify this? A normal class outline, shouldn't be no more than 9,999. That file idea of your is interesting I will have to sleep on it. Thanks for your input. I'm a one man team developing this and I've been sinful. This is the time God's going to punish me if this blows up in my face. hehe. - Original Message - From: DL Neil [EMAIL PROTECTED] To: Grant Cooper [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 27, 2002 12:55 AM Subject: Re: Data base driven web page idea - need help! Grant, I need help. I am building a database for a small college that wants to be able to update their program information for each department through an web/gui program. I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my web page this way) Here's my QUESTION! Because some of the program information is large I don't want to query the data base everytime do I? =Most use LAMPs (Linux (sorry of that is not quite kosher for FreeBSD), Apache, MySQL, and PHP) to create DYNAMIC web sites. As such, every query from a user results in a back-end database interaction. Amazon, Yahoo, Google, etc have large back-end databases and thousands of (concurrent) users and every 'click' requires a database interaction. =In your case, the transaction rate will be significantly lower, even if the volume-transmitted per click may be large. =Database retrieval and PHP formatting speeds are insignificant when compared to Internet transmission speeds - and even bulk text/page downloads over a campus network. This would take up to many resources. So I've decided to write a program that will take the information from the MYSQL tables and build static pages every night and remove the old ones through a cron job? How does this sound? =Instead of caching, could you have your authors develop the basic program description pages as static HTML? Then your database has no need to store page-data, but only a filename: when the end-user requests information, the database chooses a file, and PHP instructs Apache to display same. Much the same as you have described above, but with fewer management headaches!? =You seem to be saying that there will only be one or two types of query that the system will face. Correct? If I'm off-base, then perhaps more description might help attune... Is this standard practice, if not what would be a better way of doing this. This college has about 1600 students? Thanks in advance, I plan on doing alot of planning and really apreciate reading this email. =Concur. It is cheaper to make planning changes/mistakes at this level, than to get an ugly surprise in the coding/testing phases! 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Data base driven web page idea - need help!
Here's my QUESTION! Because some of the program information is large I don't want to query the data base everytime do I? Define large? Are we talking mixed media types (PDF/Word/PowerPoint) or plain text/HTML? As someone has already suggested, you might be better to save the files on the disk and store the filenames in the database instead. Then again, you said some of the information is large. What's the ratio? If it's small enough, fitting it in the DB might not be so bad. Depends on the hardware. Since you're pulling static pages from disk, not SQL, it would probably scale better. Always looking for a challenge, I would look at the kind of data you're dealing with. If it's of similar format, you may be able to create a SQL strucutre that would allow more flexibility with your data. Render the data in different views where applicable or at least enforce a theme on your system. Of couse, XML/XSLT is more suitable for that and I've gone way overboard... This would take up to many resources. So I've decided to write a program ... every night and remove the old ones through a cron job? If you're eager to store it all in the database, I would do so. It doesn't sound like this stuff is going to change often. Throw a reverse-proxy squid in front of apache. Even running on the same machine will help a LOT. Avoid cronjobs and nightly generated static files. That practice does NOT scale and can be very difficult to manage. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Data base driven web page idea - need help!
Grant, This is correct, only two types of queries. Updating and Deleting. =deleting is a trivial exercise, whether the data is held in a db or file. =updating is more of an exercise for the content managers than it is for you... =Can I assume that the information doesn't change frequently? This is correct. =this is both a 'win' and a 'loss': it eases the technical side, but for the user/authors the less frequently they 'do it', the more time between for any techniques, rules, standards... to be forgotten! The plan is to stream line the web site and get the information out faster and cut out the red tape. We were thinking intern's from each department, no matter how computer illiterate they are could open a GUI or Web interface to change there data. =in which case, continuing the static file theme, I would give serious thought to ascertaining which tools these people can be expected to already be familiar. There are a number of HTML-hiding editors/authoring tools 'out there', eg (R18 warning) FrontPage or even MS-Word. Don't be tempted to re-invent the editor-wheel... =another possibility would be a BB system (recently discussed on the PHP list) or a 'wiki' (specifically designed to 'get data out there quickly', but tend to be less structured/less geared to a template/'common look and feel'/marketing-brand approach/straight-jacket)... =You talk in terms of large. Can you quantify this? A normal class outline, shouldn't be no more than 9,999. =unfortunately no 'units'. If you are talking bytes or even lines; then with respect this is trivial stuff for LAMPs on even modest hardware. It sounds like a lot on paper, but web servers are fleet of foot! =although if you are talking bytes/characters you might consider splitting such pages into more than one web page - an 'average' sheet of A4/A paper is (round numbers) going to present 2KB. So you appear to be talking of 4~5 pages of data. Imagine that presented as a single screen-load and ask if it seems appropriate for the application... That file idea of your is interesting I will have to sleep on it. Thanks for your input. I'm a one man team developing this and I've been sinful. This is the time God's going to punish me if this blows up in my face. hehe. =one man...sinful??? No, I'm not going there... =dn - Original Message - From: DL Neil [EMAIL PROTECTED] To: Grant Cooper [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 27, 2002 12:55 AM Subject: Re: Data base driven web page idea - need help! Grant, I need help. I am building a database for a small college that wants to be able to update their program information for each department through an web/gui program. I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my web page this way) Here's my QUESTION! Because some of the program information is large I don't want to query the data base everytime do I? =Most use LAMPs (Linux (sorry of that is not quite kosher for FreeBSD), Apache, MySQL, and PHP) to create DYNAMIC web sites. As such, every query from a user results in a back-end database interaction. Amazon, Yahoo, Google, etc have large back-end databases and thousands of (concurrent) users and every 'click' requires a database interaction. =In your case, the transaction rate will be significantly lower, even if the volume-transmitted per click may be large. =Database retrieval and PHP formatting speeds are insignificant when compared to Internet transmission speeds - and even bulk text/page downloads over a campus network. This would take up to many resources. So I've decided to write a program that will take the information from the MYSQL tables and build static pages every night and remove the old ones through a cron job? How does this sound? =Instead of caching, could you have your authors develop the basic program description pages as static HTML? Then your database has no need to store page-data, but only a filename: when the end-user requests information, the database chooses a file, and PHP instructs Apache to display same. Much the same as you have described above, but with fewer management headaches!? =You seem to be saying that there will only be one or two types of query that the system will face. Correct? If I'm off-base, then perhaps more description might help attune... Is this standard practice, if not what would be a better way of doing this. This college has about 1600 students? Thanks in advance, I plan on doing alot of planning and really apreciate reading this email. =Concur. It is cheaper to make planning changes/mistakes at this level, than to get an ugly surprise in the coding/testing phases! Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual
Re: Data base driven web page idea - need help!
On Tue, Nov 26, 2002 at 10:38:56PM -0800, Grant Cooper wrote: Here's my QUESTION! Because some of the program information is large I don't want to query the data base everytime do I? Profile it first. You may find MySQL handles the load just fine on the hardware you're using and you don't need any such fancy tricks. You may also find that simply adding Expires: headers to your output on the cacheable pages means that you get fewer queries (and have the same effect as static pages). FWIW, I use ETag's as well which I make an MD5 hash of the latest TIMESTAMP in the tables being queried. This allows the browser to check if the ETag has changed for a page when requesting it, have the server do a very simple query to find out if it should rebuild the page or not, and let the browser use the cached page if not. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) 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: Data base driven web page idea - need help!
Hi Grant: The answer to your question depends on a lot of details. In most cases, the solution you have chosen is just fine. The real question you need to answer is, Does your solution meet your needs? If you can answer yes to this question, your solution is fine. Your solution gives you a couple of advantages: 1. As you said, fewer hits against the database. 2. Faster downloads for your user. Static HTML pages download faster than a dynamic alternative. 3. Static pages will get crawled and added to search engines; sometimes dynamic pages won't. Some disadvantages: 1. You have a delayed update to your Web page. If a faculty member notices a critical error on a Web page, they must contact you or otherwise figure out how to trigger an update. 2. There are things you can do with a dynamic page that you cannot do with a static page. Here's my QUESTION! Because some of the program information is large I don't want to query the data base everytime do I? Like I said, your solution will probably work just fine, but it is probably unnecessary. You say the program information is large, but it would have to really REALLY large for it to make much difference. With a college of 1600 students, it does not sound like your Web site is going to have much traffic. Php and MySQL are pretty efficient. My advice is to test your assumptions; does retrieving the large Web pages from the database make much difference? Good luck, Matt Matthew P Baranowski Data Manager, Office of Educational Assessment University of Washington - Original Message - From: Grant Cooper [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 10:38 PM Subject: Data base driven web page idea - need help! I need help. I am building a database for a small college that wants to be able to update their program information for each department through an web/gui program. I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my web page this way) Here's my QUESTION! Because some of the program information is large I don't want to query the data base everytime do I? This would take up to many resources. So I've decided to write a program that will take the information from the MYSQL tables and build static pages every night and remove the old ones through a cron job? How does this sound? Is this standard practice, if not what would be a better way of doing this. This college has about 1600 students? Thanks in advance, I plan on doing alot of planning and really apreciate reading this email. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Data base driven web page idea - need help!
Hi. On Tue 2002-11-26 at 22:38:56 -0800, [EMAIL PROTECTED] wrote: I need help. I am building a database for a small college that wants to be able to update their program information for each department through an web/gui program. I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my web page this way) Here's my QUESTION! Because some of the program information is large I don't want to query the data base everytime do I? This would take up to many resources. So I've decided to write a program that will take the information from the MYSQL tables and build static pages every night and remove the old ones through a cron job? How does this sound? Is this standard practice, if not what would be a better way of doing this. This college has about 1600 students? There are always several possible solutions and which one is the right for you depends on many factors you have not told us. Regardless which solution you choose in the end, try to get usage numbers from the current college program pages (hits/day) and build a test database and a minimal prototype regarding your solution and see if it is able to scale to the usage numbers you got. Do not forget to take into account special times of days (max usage is often 3 times higher than average) and special times of year (I presume there are times in school year, when the college program is accessed much more often). That said, some let's consider some possibilities: 1. As you said, one solution is to simply make dynamic PHP pages. You presume that this will be too slow, but be sure that this is indeed the case (PHP+MySQL are quite capable), because this is the solution that makes the least work. In short: least work, scales worst, always up to date. 2. As you also said, you could create static pages at night. That is the other extreme (the following points are somewhere in between). Regarding the fact that the college program probably will not change often, this sounds like a reasonable approach, should be fast enough for sure, but also means quite a bit more work, as it is not easy to get it correct all time. Most work, scales best, up to 24 hours out of date. 3. A variant of 2: Build the static pages when a database entry changes (i.e. on push). Whether this is feasible and how many work it makes depends on how many pages are affected by a change. It scales a little bit worse than 2., but should be still good enough by far and has the advantage that the pages are always up to date. If only one or two pages are affected by a change it is more reasonable than 2. for sure. Creating the static pages the first time needs some handiwork. Much work (depends on changed pages), scales almost best, always up to date. 4. This is a hybrid: Create cached pages/parts, but save them in the database (or disk, if you like more) and display them via PHP (there is a PHP to support for that, IIRC). You can see that as a variant of 1., just with the additional benefit of some caching. Cache pages would be created on request, if the page is not cached yet or outdated meanwhile (on pull). This solution fits best if the data changes often (where 2. would be a big no-no), but scales bad on restart. Medium work, scales good, always up to date. 5. Another hybrid: Do not create the cache pages yourself. Simply build the back-end as in solution 1. and put a caching proxy (e.g. squid) before it. The main drawback in comparison with. Depending on proxy, may scale bad on restart. Depending on configuration and usage may even be faster than 2. Is as out of date as you configure it to be: the more current the pages shall be, the worse it scales (because it less often hits the cache). Medium work, scales good, actuality: as configured. 6. As 1., but allow client-side caching of pages. This only has positive effects on reloads or often visited pages. Least work, scales bad, actuality: as configured (same as 5.) Since 1. allows to continue with 6., 5. and 4., I suggest to start with solution 1. and then continue as much as need arises. Bye, 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: Data base driven web page idea - need help!
On Wed, Nov 27, 2002 at 09:39:52PM +0100, Benjamin Pflugmann wrote: 5. Another hybrid: Do not create the cache pages yourself. Simply build the back-end as in solution 1. and put a caching proxy (e.g. squid) before it. The main drawback in comparison with. Depending on proxy, may scale bad on restart. Depending on configuration and usage may even be faster than 2. Is as out of date as you configure it to be: the more current the pages shall be, the worse it scales (because it less often hits the cache). Medium work, scales good, actuality: as configured. 6. As 1., but allow client-side caching of pages. This only has positive effects on reloads or often visited pages. Least work, scales bad, actuality: as configured (same as 5.) As someone who uses 5 6 together quite often (as suggested), I can tell you it works very well (and very responsively). Your point about oft-used pages is interesting, but it only applies in a special circumstance that, in my experience, doesn't happen often (although Slashdot does consider this): If a page would require significant database resources and the source information changes more rarely than the data is accessed and/or the data may be accessed when it is inconvenient to load the database server with such a query, generating the page offline and storing it makes sense (like the Slashdot archived stories). In most cases, however, doing no caching at all is sufficient and allowing client-side caching takes the load off the frequently used pages (which is all you really care about usually) and adding Squid or Apache doing caching in front of your live server takes away hits to the same data from multiple requestors. Since 1. allows to continue with 6., 5. and 4., I suggest to start with solution 1. and then continue as much as need arises. I agree with this, personally. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) 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: Data base driven web page idea - need help!
Thanks you very much for all your suggestions. I really appreciate it. Grant Cooper - Original Message - From: Matthew Baranowski [EMAIL PROTECTED] To: Grant Cooper [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 27, 2002 9:23 AM Subject: Re: Data base driven web page idea - need help! Hi Grant: The answer to your question depends on a lot of details. In most cases, the solution you have chosen is just fine. The real question you need to answer is, Does your solution meet your needs? If you can answer yes to this question, your solution is fine. Your solution gives you a couple of advantages: 1. As you said, fewer hits against the database. 2. Faster downloads for your user. Static HTML pages download faster than a dynamic alternative. 3. Static pages will get crawled and added to search engines; sometimes dynamic pages won't. Some disadvantages: 1. You have a delayed update to your Web page. If a faculty member notices a critical error on a Web page, they must contact you or otherwise figure out how to trigger an update. 2. There are things you can do with a dynamic page that you cannot do with a static page. Here's my QUESTION! Because some of the program information is large I don't want to query the data base everytime do I? Like I said, your solution will probably work just fine, but it is probably unnecessary. You say the program information is large, but it would have to really REALLY large for it to make much difference. With a college of 1600 students, it does not sound like your Web site is going to have much traffic. Php and MySQL are pretty efficient. My advice is to test your assumptions; does retrieving the large Web pages from the database make much difference? Good luck, Matt Matthew P Baranowski Data Manager, Office of Educational Assessment University of Washington - Original Message - From: Grant Cooper [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 10:38 PM Subject: Data base driven web page idea - need help! I need help. I am building a database for a small college that wants to be able to update their program information for each department through an web/gui program. I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my web page this way) Here's my QUESTION! Because some of the program information is large I don't want to query the data base everytime do I? This would take up to many resources. So I've decided to write a program that will take the information from the MYSQL tables and build static pages every night and remove the old ones through a cron job? How does this sound? Is this standard practice, if not what would be a better way of doing this. This college has about 1600 students? Thanks in advance, I plan on doing alot of planning and really apreciate reading this email. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Data base driven web page idea - need help!
I need help. I am building a database for a small college that wants to be able to update their program information for each department through an web/gui program. I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my web page this way) Here's my QUESTION! Because some of the program information is large I don't want to query the data base everytime do I? I've got a web site which takes just this approach, but there are pros and cons with it. The upside, is that if most of the information is fixed, then you're swapping database accesses and the overhead of a CGI script for a simple 'GET' request. It clearly works best when the rate of change for the raw data is relatively low, because it implies that you generate the page(s) once but server them up many times. The downside is the delay between entering new data and it being available on the site. In some applications this may be critical. The method that I used is to record a timestamp every time the database is updated, to have a script running permanently in the background looking at this timestamp. If it's greater than zero and more than 5 minutes old, the pages get regenerated and the timestamp is then set to zero again. The reason that I chose this approach is that updates are relatively rare (a dozen or so times a week), but the hit rate on the site is orders of magnitude higher. Also, it gave scalability at lower cost than tuning CGI scripts and the Apache server environment. The underlying point though, is that you need to look at the pattern of both accesses to the site and updates to the database and decide based on that. The site I'm talking about is here : www.pubfun.com if you feel a need to look round. Paul Wilson Chime Communications - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Data base driven web page idea - need help!
I need help. I am building a database for a small college that wants to be able to update their program information for each department through an web/gui program. I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my web page this way) Here's my QUESTION! Because some of the program information is large I don't want to query the data base everytime do I? This would take up to many resources. So I've decided to write a program that will take the information from the MYSQL tables and build static pages every night and remove the old ones through a cron job? How does this sound? Is this standard practice, if not what would be a better way of doing this. This college has about 1600 students? Thanks in advance, I plan on doing alot of planning and really apreciate reading this email. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: A new Idea for FULLTEXT searchs
mysql, query speed up, sql _ Sorry I may be bothering you but I was thinking (gosh! this is so bizarre on me) that may be we can make MySQL SGML compatible. I agree that MYSQL cannot be manipulated to handle jerarquical information because this is not the object and isnt mine either. May be we can add a NEW FEATURE ON INDEXING AND FULLTEXT that consists on avoiding the indexing of tags (as groups of words embrassed by and ), and support to add new rules to this one. In this case, we may use direct HTML code (for example) without worries of indexing the tags, and allow the developer to add new functionality as RTF support and TEX. Am I int the good way or I'll need to sleep more? Leonardo Javier Belén. AFIP-AR. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A new Idea for FULLTEXT searchs
mysql, query speed up _ Sorry I may be bothering you but I was thinking (gosh! this is so bizarre on me) that may be we can make MySQL SGML compatible. I agree that MYSQL cannot be manipulated to handle jerarquical information because this is not the object and isnt mine either. May be we can add a NEW FEATURE ON INDEXING AND FULLTEXT that consists on avoiding the indexing of tags (as groups of words embrassed by and ), and support to add new rules to this one. In this case, we may use direct HTML code (for example) without worries of indexing the tags, and allow the developer to add new functionality as RTF support and TEX. Am I int the good way or I'll need to sleep more? Leonardo Javier Belén. AFIP-AR. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Storing images in MySQL bad idea, performance-wise?
I'm working on a simple content management system that uses PHP and MySQL for updating a web site's text (stored in a MySQL database). (The PHP scripts that do the updating (my stuf) live on one web server, the actual DB data to be updated (my client's stuff) live on another.) So far, I've only had to he able to update the text content of a site--therefore, I've only had to bother to store textual data in the client's DB. But now the client wants to be able to upload/change/delete certain pictures on their web site--using my CMS tool--so I am faced with the following problem: Do I store all such images in the DB? (Which I understand reduces performance.) Or do I--somehow--store the images as files on the client's web server? And if so, how? (Because my PHP scripts are being executed on a different server.) ...Rene --- René Fournier, [EMAIL PROTECTED] Toll-free +1.888.886.2754 Tel +1.403.291.3601 Fax +1.403.250.5228 www.smartslitters.com SmartSlitters International #33, 1339 - 40th Ave NE Calgary AB T2E 8N6 Canada - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Storing images in MySQL bad idea, performance-wise?
Rene: I think a good deal depends on the size of the image files themselves. There are a number of apps that store small files (i.e.: icons, small gif's, etc.), which seems to make sense. Larger files may be problematic. There was quite a discussion on this issue here just last week ... do a search of the list archive for 'blob versus file' and read some informed opinions. Gerald Jensen - Original Message - From: René Fournier [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 08, 2002 5:34 PM Subject: Storing images in MySQL bad idea, performance-wise? I'm working on a simple content management system that uses PHP and MySQL for updating a web site's text (stored in a MySQL database). (The PHP scripts that do the updating (my stuf) live on one web server, the actual DB data to be updated (my client's stuff) live on another.) So far, I've only had to he able to update the text content of a site--therefore, I've only had to bother to store textual data in the client's DB. But now the client wants to be able to upload/change/delete certain pictures on their web site--using my CMS tool--so I am faced with the following problem: Do I store all such images in the DB? (Which I understand reduces performance.) Or do I--somehow--store the images as files on the client's web server? And if so, how? (Because my PHP scripts are being executed on a different server.) ...Rene --- René Fournier, [EMAIL PROTECTED] Toll-free +1.888.886.2754 Tel +1.403.291.3601 Fax +1.403.250.5228 www.smartslitters.com SmartSlitters International #33, 1339 - 40th Ave NE Calgary AB T2E 8N6 Canada - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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