Re: MySQL bottleneck
Hi Wiley, I am still not sure if we are talking about 360k threats or clients, but I take your word from the first e-mail. basically I think its possible to setup a big DB (as Google, Yahoo etc. have shown already). About the hardware may I recommend 64 bit Opteron systems and scsi drives (array). Performancewise you have many options to stretch MySQLs legs. - Merge table format (for non transactions) - Raid options included in MySQL - Replication - Cluster Filesystem from MySQL - A "REAL" Cluster One thing that surprise me is that you obviously dont use transactions. Note that your data may corrupt not repairable if you dont take any precautions. Anyway, may I suggest 2 books to get you started quickly. "MySQL Certification study guide" from Paul DuBois "High Performance MySQL" from Zawodny You will probably need more info or books later, but that should get you up to speed within a few weeks. I trust that you have 2-10 boxes near you to get started and see how well that system scales. About posting: Just make Sure you create a new Subject line when starting a new threat or topic. That should do the trick and nobody gets confused. I hope that you find this information useful. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com > So is karma :) > > > >>From: sol beach <[EMAIL PROTECTED]> >>Reply-To: sol beach <[EMAIL PROTECTED]> >>To: B Wiley Snyder <[EMAIL PROTECTED]> >>Subject: Re: MySQL bottleneck >>Date: Sat, 16 Apr 2005 20:56:08 -0700 >> >>Incompetence is its own reward. >> >>Simply put, 360K is NOT a big number or DB given today's hardware. >> >>On 4/16/05, B Wiley Snyder <[EMAIL PROTECTED]> wrote: >> > Oh wait, I see what happend. I stepped on MY OWN thread. I hate when I >>do >> > that ! Sorry >> > >> > >From: [EMAIL PROTECTED] >> > >To: "B Wiley Snyder" <[EMAIL PROTECTED]> >> > >CC: mysql@lists.mysql.com >> > >Subject: Re: MySQL bottleneck >> > >Date: Sun, 17 Apr 2005 01:21:36 - (UTC) >> > > >> > >Hello there, >> > > >> > >no offence but that questions is not answerable. I wouldnt expect >> many >> > >replies. Let me try to help you out by asking YOU a few questions >> which >> > >might point you into the correct direction: >> > > >> > >1) Is the data entered once and than mostly read access or is it >> > >frequently updated ? >> > > >> > >2) Do you need transaction support ? >> > > >> > >3) Do you need the data to be EASY transferable between different OS >> > >(MAC/WIN/Unix/Linux) ? >> > > >> > >BTW: You posted into another thread (which is not good). >> > >I suggest you think about the above questions and start a new topic >>again. >> > > >> > >Best regards >> > > >> > >Nils Valentin >> > >Tokyo / Japan >> > > >> > >http://www.be-known-online.com >> > > >> > > >> > > > Hello there, let's say I have 365,000 users I need to enter their >>data, >> > > > pull >> > > > from it and modify it regularly. Is MySql the way to go ? Or do I >>need >> > >to >> > > > buy an oracle or ms server ? >> > > > >> > > > thanks in advance for a clue >> > > > >> > > >>From: [EMAIL PROTECTED] >> > > >>To: "B Wiley Snyder" <[EMAIL PROTECTED]> >> > > >>CC: mysql@lists.mysql.com >> > > >>Subject: Re: How to retain "Key" order when Deleting a Row >> > > >>Date: Tue, 12 Apr 2005 14:48:54 -0400 >> > > >> >> > > >>"B Wiley Snyder" <[EMAIL PROTECTED]> wrote on 04/11/2005 >>10:38:12 >> > > >> PM: >> > > >> >> > > >> > Hello experts, >> > > >> > >> > > >> > I just need someone to please point me in the right direction >> on >> > > >>retaining >> > > >> > my "key" or id order in my table when I delete a row. So for >>example >> > >I >> > > >>have >> > > >> > 10 rows Id 1-10 that are created automatically when the record >> is >> > > >>inserted. >> > > >> > >> > > >> > So if I delete record with id 5 my id's are not >>1,2,3,4,6,7,8,9,10 >> > >but >> > > >> > 1,2,3,4,5,6,7,8,9 ??? >> > > >> > >> > > >> > >> > > >> > thanks >> > > >> > >> > > >> > _ >> > > >> > Express yourself instantly with MSN Messenger! Download today - >>it's >> > > >>FREE! >> > > >> > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ >> > > >> > >> > > >> >> > > >>It sounds like you are confusing a data storage requirement (a >>unique, >> > > >>non-repeating identifier for every row) with a presentation >>requirement >> > > >> (a >> > > >>neatly numbered list of records). If I need a nicely ordered list >> of >> > > >>numbers, I use my programming language to provide it. If I need to >> > > >>uniquely identify a record, I use the ID. >> > > >> >> > > >>When an ID has been issued, it generally stays "used" even if that >> > >record >> > > >>no longer exists. >> > > >> >> > > >> >> > > >>Shawn Green >> > > >>Database Administrator >> > > >>Unimin Corporation - Spruce Pine >> > > > >> > > > _ >> > > > Express yourself instantly with MSN Messenger! Download today - >> it's >> > >FR
Re: Relative Numeric Values
David, I agree with Kim. Trying to encode information into primary keys is a bit like trying to write a legal contract in chalk on a sidewalk. The contract is washed away next time it rains, the neat looking key order is washed away by errors, species discoveries & reclassifications. The PK doesn't need to mean anything, indeed it shouldn't be made vulnerable to real-world errors of any kind; it's job is strictly logical, as a marker that guarantees row uniqueness and can relate rows in one table to rows in another.. HTH. PB - David Blomstrom wrote: I think my question is more oriented towards PHP, but I'd like to ask it on this list, as I suspect the solution may involve MySQL. I'm about to start developing an enormous database focusing on the animal kingdom and want to find a key system more user friendly than the traditional scientific name. So imagine instead a page with the following in the head section: $AnimalID = 'canlup'; This page displays information on the wolf, based on the first three letters of its genus and species name, Canis lupus. Now imagine a page with this value: $AnimalID = 'bal'; This page displays information on the whale family Balaenidae. But what about the whale family Balaenopteridae, which begins with the same three letters? I could solve this problem by adding a numerical key to my database and displaying the following: $AnimalID = 'bal23'; $AnimalID = 'bal24'; The problem with this is that it makes it much harder to work with my data. When tweaking a page or writing a script, I can easily remember that bal = Balaenidae, but I can't possibly remember which numeral is associated with each mammal family. Also, what happens if I add or subtract rows from my database table, and the above values suddenly change to bal27 and bal28? So here's what I think I'd like to do: $AnimalID = 'canlup1'; $AnimalID = 'bal1'; $AnimalID = 'bal2'; The page with canlup1 will display the FIRST (and only) instance of canlup in the database - the wolf. The page with bal1 will display the first instance of bal, which will always be Balaenidae, whether the absolute value is bal27 or bal2884. A page with bal2 will always display the next mammal family that begins with bal, Balaenopteridae. So I THINK all I need to do is create a variable that reflects a particular value's ordinal position in a database... abc1 abc2 abc3, etc. Plus, I'll have to join two or three fields together to form a key; e.g. animals.species + animals.numerals Does anyone know how I can do this? Thanks. __ Do you Yahoo!? Plan great trips with Yahoo! Travel: Now over 17,000 guides! http://travel.yahoo.com/p-travelguide -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.13 - Release Date: 4/16/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting at boot-Fedora Core 3
Andy Pieters wrote: Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use there: stop restart I have a MySql server on one of my machines that is running FC3 and I don't even have mysql_safe here. (Version 3.23.58) Andy Hi All, that's just the problem. It won't start that way. I had already checked the logs, but, it only seems to log things after starting, bringing me back to zero position, a server that won't start this way. Cheers. [EMAIL PROTECTED] ~]# /sbin/service mysql start Can't execute ./bin/mysqld_safe[FAILED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Relative Numeric Values
--- Kim Briggs <[EMAIL PROTECTED]> wrote: > David, > > In reading through miscellaneous database design > text on the web, I > read just the other day that you should not try to > include meaningful > data in your key values. I assume there will be > some kind of "lookup" > tables for species, phylum, whatever. Trying to > make your key field > "smart" seems like way too much overhead and > complexity. I'm > wondering why, if the database is enormous, are you > being so short and > cryptic with the "user-friendly" values? Primarily because I want to make it easier to work with. If I create a new page that focuses on the king salmon, I'd rather type in $MyID = 'onc'; than $MyID = 'Oncorhynchus'. Or if I create an array, I'd rather list rhi, hip, equ than Rhinocerotidae, Hippopotamidae, Equidae. In fact, I'll have to discard big chunks of the animals database I received on a CD, as it's way to big (several MB) and includes living things I won't cover (bacteria, viruses, etc.). I'm also trying to decide on my URL structure. I could follow tradition and map out the lion like this: mammals.geobop.org/carnivora/felidae/panthera/leo/ ...but I'm thinking of shortening the URL's: mammals.geobop.org/car/fel/pan/leo/ I'm just trying to come up with something that's more user friendly. Thanks. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Relative Numeric Values
David, In reading through miscellaneous database design text on the web, I read just the other day that you should not try to include meaningful data in your key values. I assume there will be some kind of "lookup" tables for species, phylum, whatever. Trying to make your key field "smart" seems like way too much overhead and complexity. I'm wondering why, if the database is enormous, are you being so short and cryptic with the "user-friendly" values? my $.02 KB On 4/16/05, David Blomstrom <[EMAIL PROTECTED]> wrote: > I think my question is more oriented towards PHP, but > I'd like to ask it on this list, as I suspect the > solution may involve MySQL. > > I'm about to start developing an enormous database > focusing on the animal kingdom and want to find a key > system more user friendly than the traditional > scientific name. > > So imagine instead a page with the following in the > head section: > > $AnimalID = 'canlup'; > > This page displays information on the wolf, based on > the first three letters of its genus and species name, > Canis lupus. > > Now imagine a page with this value: > > $AnimalID = 'bal'; > > This page displays information on the whale family > Balaenidae. But what about the whale family > Balaenopteridae, which begins with the same three > letters? > > I could solve this problem by adding a numerical key > to my database and displaying the following: > > $AnimalID = 'bal23'; > $AnimalID = 'bal24'; > > The problem with this is that it makes it much harder > to work with my data. When tweaking a page or writing > a script, I can easily remember that bal = Balaenidae, > but I can't possibly remember which numeral is > associated with each mammal family. Also, what happens > if I add or subtract rows from my database table, and > the above values suddenly change to bal27 and bal28? > > So here's what I think I'd like to do: > > $AnimalID = 'canlup1'; > $AnimalID = 'bal1'; > $AnimalID = 'bal2'; > > The page with canlup1 will display the FIRST (and > only) instance of canlup in the database - the wolf. > > The page with bal1 will display the first instance of > bal, which will always be Balaenidae, whether the > absolute value is bal27 or bal2884. A page with bal2 > will always display the next mammal family that begins > with bal, Balaenopteridae. > > So I THINK all I need to do is create a variable that > reflects a particular value's ordinal position in a > database... > abc1 > abc2 > abc3, etc. > > Plus, I'll have to join two or three fields together > to form a key; e.g. animals.species + animals.numerals > > Does anyone know how I can do this? Thanks. > > __ > Do you Yahoo!? > Plan great trips with Yahoo! Travel: Now over 17,000 guides! > http://travel.yahoo.com/p-travelguide > > -- > 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: MySQL bottleneck
So is karma :) From: sol beach <[EMAIL PROTECTED]> Reply-To: sol beach <[EMAIL PROTECTED]> To: B Wiley Snyder <[EMAIL PROTECTED]> Subject: Re: MySQL bottleneck Date: Sat, 16 Apr 2005 20:56:08 -0700 Incompetence is its own reward. Simply put, 360K is NOT a big number or DB given today's hardware. On 4/16/05, B Wiley Snyder <[EMAIL PROTECTED]> wrote: > Oh wait, I see what happend. I stepped on MY OWN thread. I hate when I do > that ! Sorry > > >From: [EMAIL PROTECTED] > >To: "B Wiley Snyder" <[EMAIL PROTECTED]> > >CC: mysql@lists.mysql.com > >Subject: Re: MySQL bottleneck > >Date: Sun, 17 Apr 2005 01:21:36 - (UTC) > > > >Hello there, > > > >no offence but that questions is not answerable. I wouldnt expect many > >replies. Let me try to help you out by asking YOU a few questions which > >might point you into the correct direction: > > > >1) Is the data entered once and than mostly read access or is it > >frequently updated ? > > > >2) Do you need transaction support ? > > > >3) Do you need the data to be EASY transferable between different OS > >(MAC/WIN/Unix/Linux) ? > > > >BTW: You posted into another thread (which is not good). > >I suggest you think about the above questions and start a new topic again. > > > >Best regards > > > >Nils Valentin > >Tokyo / Japan > > > >http://www.be-known-online.com > > > > > > > Hello there, let's say I have 365,000 users I need to enter their data, > > > pull > > > from it and modify it regularly. Is MySql the way to go ? Or do I need > >to > > > buy an oracle or ms server ? > > > > > > thanks in advance for a clue > > > > > >>From: [EMAIL PROTECTED] > > >>To: "B Wiley Snyder" <[EMAIL PROTECTED]> > > >>CC: mysql@lists.mysql.com > > >>Subject: Re: How to retain "Key" order when Deleting a Row > > >>Date: Tue, 12 Apr 2005 14:48:54 -0400 > > >> > > >>"B Wiley Snyder" <[EMAIL PROTECTED]> wrote on 04/11/2005 10:38:12 > > >> PM: > > >> > > >> > Hello experts, > > >> > > > >> > I just need someone to please point me in the right direction on > > >>retaining > > >> > my "key" or id order in my table when I delete a row. So for example > >I > > >>have > > >> > 10 rows Id 1-10 that are created automatically when the record is > > >>inserted. > > >> > > > >> > So if I delete record with id 5 my id's are not 1,2,3,4,6,7,8,9,10 > >but > > >> > 1,2,3,4,5,6,7,8,9 ??? > > >> > > > >> > > > >> > thanks > > >> > > > >> > _ > > >> > Express yourself instantly with MSN Messenger! Download today - it's > > >>FREE! > > >> > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > >> > > > >> > > >>It sounds like you are confusing a data storage requirement (a unique, > > >>non-repeating identifier for every row) with a presentation requirement > > >> (a > > >>neatly numbered list of records). If I need a nicely ordered list of > > >>numbers, I use my programming language to provide it. If I need to > > >>uniquely identify a record, I use the ID. > > >> > > >>When an ID has been issued, it generally stays "used" even if that > >record > > >>no longer exists. > > >> > > >> > > >>Shawn Green > > >>Database Administrator > > >>Unimin Corporation - Spruce Pine > > > > > > _ > > > Express yourself instantly with MSN Messenger! Download today - it's > >FREE! > > > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > > > > > > > > -- > > > 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] > > > > _ > Express yourself instantly with MSN Messenger! Download today - it's FREE! > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > _ Dont just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: zip code search within x miles
Jeff Kolber <[EMAIL PROTECTED]> writes: > How are sites doing the search by zip and coming up with results within x > miles? Is there some OSS zip code download that has been created for this? The ones I'm familiar with use this: http://www.census.gov/geo/www/tiger/zip1999.html [...] > I would be interested, anyone have insights into doing with Canadian > Zip Codes or otherwise optimizing a database of Canadian Zip Codes? I looked into this a few months back (for a very similar project, actually) and found many places offering Canadian postal code databases, but none for free. If you already have the database, I don't see why optimizing it would be any different than for American postal codes. ScottG. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL bottleneck
Oh wait, I see what happend. I stepped on MY OWN thread. I hate when I do that ! Sorry From: [EMAIL PROTECTED] To: "B Wiley Snyder" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: MySQL bottleneck Date: Sun, 17 Apr 2005 01:21:36 - (UTC) Hello there, no offence but that questions is not answerable. I wouldnt expect many replies. Let me try to help you out by asking YOU a few questions which might point you into the correct direction: 1) Is the data entered once and than mostly read access or is it frequently updated ? 2) Do you need transaction support ? 3) Do you need the data to be EASY transferable between different OS (MAC/WIN/Unix/Linux) ? BTW: You posted into another thread (which is not good). I suggest you think about the above questions and start a new topic again. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com > Hello there, let's say I have 365,000 users I need to enter their data, > pull > from it and modify it regularly. Is MySql the way to go ? Or do I need to > buy an oracle or ms server ? > > thanks in advance for a clue > >>From: [EMAIL PROTECTED] >>To: "B Wiley Snyder" <[EMAIL PROTECTED]> >>CC: mysql@lists.mysql.com >>Subject: Re: How to retain "Key" order when Deleting a Row >>Date: Tue, 12 Apr 2005 14:48:54 -0400 >> >>"B Wiley Snyder" <[EMAIL PROTECTED]> wrote on 04/11/2005 10:38:12 >> PM: >> >> > Hello experts, >> > >> > I just need someone to please point me in the right direction on >>retaining >> > my "key" or id order in my table when I delete a row. So for example I >>have >> > 10 rows Id 1-10 that are created automatically when the record is >>inserted. >> > >> > So if I delete record with id 5 my id's are not 1,2,3,4,6,7,8,9,10 but >> > 1,2,3,4,5,6,7,8,9 ??? >> > >> > >> > thanks >> > >> > _ >> > Express yourself instantly with MSN Messenger! Download today - it's >>FREE! >> > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ >> > >> >>It sounds like you are confusing a data storage requirement (a unique, >>non-repeating identifier for every row) with a presentation requirement >> (a >>neatly numbered list of records). If I need a nicely ordered list of >>numbers, I use my programming language to provide it. If I need to >>uniquely identify a record, I use the ID. >> >>When an ID has been issued, it generally stays "used" even if that record >>no longer exists. >> >> >>Shawn Green >>Database Administrator >>Unimin Corporation - Spruce Pine > > _ > Express yourself instantly with MSN Messenger! Download today - it's FREE! > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > > -- > 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] _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL bottleneck
None taken, I'm sure it's a vague question but I had to start somewhere. I'm not an expert on anything that large as of today. 1) Is the data entered once and than mostly read access or is it frequently updated ? It's entered once but mostly(almost ALL 99%) read access. 2) Do you need transaction support ? No 3) Do you need the data to be EASY transferable between different OS (MAC/WIN/Unix/Linux) ? No BTW: You posted into somebody elses thread (which is not polite). I suggest you think about the above questions and start a new topic again. How did I do that? I'm using this hotmail account which is acting really strange to begin with and I've posted any message directly to [EMAIL PROTECTED] If that posts to someone else's thread That's weired, I can't even GET any threads other then my own on this account. I thought I would actually try filling up MS mail servers with this list instead of my own but it looks like I only get my own threads and they come via user email not mysql@lists.mysql.com so If that happened I appologize and will be more then happy to just dump this account if it happens this time. 4> basically the main thing in the application is password authentication then when the user is authorized their homepage is but from a handfull of variables from the database. Sorry to offend if this steps into someones thread, let me know if it does. Best Regards and thanks for the reply From: [EMAIL PROTECTED] To: "B Wiley Snyder" <[EMAIL PROTECTED]> Subject: Re: MySQL bottleneck Date: Sun, 17 Apr 2005 01:19:32 - (UTC) Hello there, no offence but that questions is not answerable. I wouldnt expect many replies. Let me try to help you out by asking YOU a few questions which might point you into the correct direction: 1) Is the data entered once and than mostly read access or is it frequently updated ? 2) Do you need transaction support ? 3) Do you need the data to be EASY transferable between different OS (MAC/WIN/Unix/Linux) ? BTW: You posted into somebody elses thread (which is not polite). I suggest you think about the above questions and start a new topic again. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com > Hello there, let's say I have 365,000 users I need to enter their data, > pull > from it and modify it regularly. Is MySql the way to go ? Or do I need to > buy an oracle or ms server ? > > thanks in advance for a clue > >>From: [EMAIL PROTECTED] >>To: "B Wiley Snyder" <[EMAIL PROTECTED]> >>CC: mysql@lists.mysql.com >>Subject: Re: How to retain "Key" order when Deleting a Row >>Date: Tue, 12 Apr 2005 14:48:54 -0400 >> >>"B Wiley Snyder" <[EMAIL PROTECTED]> wrote on 04/11/2005 10:38:12 >> PM: >> >> > Hello experts, >> > >> > I just need someone to please point me in the right direction on >>retaining >> > my "key" or id order in my table when I delete a row. So for example I >>have >> > 10 rows Id 1-10 that are created automatically when the record is >>inserted. >> > >> > So if I delete record with id 5 my id's are not 1,2,3,4,6,7,8,9,10 but >> > 1,2,3,4,5,6,7,8,9 ??? >> > >> > >> > thanks >> > >> > _ >> > Express yourself instantly with MSN Messenger! Download today - it's >>FREE! >> > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ >> > >> >>It sounds like you are confusing a data storage requirement (a unique, >>non-repeating identifier for every row) with a presentation requirement >> (a >>neatly numbered list of records). If I need a nicely ordered list of >>numbers, I use my programming language to provide it. If I need to >>uniquely identify a record, I use the ID. >> >>When an ID has been issued, it generally stays "used" even if that record >>no longer exists. >> >> >>Shawn Green >>Database Administrator >>Unimin Corporation - Spruce Pine > > _ > Express yourself instantly with MSN Messenger! Download today - it's FREE! > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > _ Dont just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL bottleneck
Hello there, no offence but that questions is not answerable. I wouldnt expect many replies. Let me try to help you out by asking YOU a few questions which might point you into the correct direction: 1) Is the data entered once and than mostly read access or is it frequently updated ? 2) Do you need transaction support ? 3) Do you need the data to be EASY transferable between different OS (MAC/WIN/Unix/Linux) ? BTW: You posted into another thread (which is not good). I suggest you think about the above questions and start a new topic again. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com > Hello there, let's say I have 365,000 users I need to enter their data, > pull > from it and modify it regularly. Is MySql the way to go ? Or do I need to > buy an oracle or ms server ? > > thanks in advance for a clue > >>From: [EMAIL PROTECTED] >>To: "B Wiley Snyder" <[EMAIL PROTECTED]> >>CC: mysql@lists.mysql.com >>Subject: Re: How to retain "Key" order when Deleting a Row >>Date: Tue, 12 Apr 2005 14:48:54 -0400 >> >>"B Wiley Snyder" <[EMAIL PROTECTED]> wrote on 04/11/2005 10:38:12 >> PM: >> >> > Hello experts, >> > >> > I just need someone to please point me in the right direction on >>retaining >> > my "key" or id order in my table when I delete a row. So for example I >>have >> > 10 rows Id 1-10 that are created automatically when the record is >>inserted. >> > >> > So if I delete record with id 5 my id's are not 1,2,3,4,6,7,8,9,10 but >> > 1,2,3,4,5,6,7,8,9 ??? >> > >> > >> > thanks >> > >> > _ >> > Express yourself instantly with MSN Messenger! Download today - it's >>FREE! >> > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ >> > >> >>It sounds like you are confusing a data storage requirement (a unique, >>non-repeating identifier for every row) with a presentation requirement >> (a >>neatly numbered list of records). If I need a nicely ordered list of >>numbers, I use my programming language to provide it. If I need to >>uniquely identify a record, I use the ID. >> >>When an ID has been issued, it generally stays "used" even if that record >>no longer exists. >> >> >>Shawn Green >>Database Administrator >>Unimin Corporation - Spruce Pine > > _ > Express yourself instantly with MSN Messenger! Download today - it's FREE! > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > > -- > 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: 4==4something: equal vs identical
At 22:18 +0200 4/16/05, Andy Pieters wrote: Hi everone I ran into some situation where MySql selects a row by using the following query: SELECT `id` FROM `shop_products` WHERE `id`="4aef" LIMIT 1; ++ | id | ++ | 4 | ++ Granted the field IS of type int but 4 is not identical to 4aef (it may be equal to the eyes of MySql) Isn't there an MySql equivalent of === (test for same+same type) or should I just ignore this. For a comparison of integer with string, the string is converted to number and a numeric comparison is done. '4aef' converts to 4. I suppose you could convert the integer to string instead: WHERE CONCAT(`id`) = "4aef" -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Relative Numeric Values
I think my question is more oriented towards PHP, but I'd like to ask it on this list, as I suspect the solution may involve MySQL. I'm about to start developing an enormous database focusing on the animal kingdom and want to find a key system more user friendly than the traditional scientific name. So imagine instead a page with the following in the head section: $AnimalID = 'canlup'; This page displays information on the wolf, based on the first three letters of its genus and species name, Canis lupus. Now imagine a page with this value: $AnimalID = 'bal'; This page displays information on the whale family Balaenidae. But what about the whale family Balaenopteridae, which begins with the same three letters? I could solve this problem by adding a numerical key to my database and displaying the following: $AnimalID = 'bal23'; $AnimalID = 'bal24'; The problem with this is that it makes it much harder to work with my data. When tweaking a page or writing a script, I can easily remember that bal = Balaenidae, but I can't possibly remember which numeral is associated with each mammal family. Also, what happens if I add or subtract rows from my database table, and the above values suddenly change to bal27 and bal28? So here's what I think I'd like to do: $AnimalID = 'canlup1'; $AnimalID = 'bal1'; $AnimalID = 'bal2'; The page with canlup1 will display the FIRST (and only) instance of canlup in the database - the wolf. The page with bal1 will display the first instance of bal, which will always be Balaenidae, whether the absolute value is bal27 or bal2884. A page with bal2 will always display the next mammal family that begins with bal, Balaenopteridae. So I THINK all I need to do is create a variable that reflects a particular value's ordinal position in a database... abc1 abc2 abc3, etc. Plus, I'll have to join two or three fields together to form a key; e.g. animals.species + animals.numerals Does anyone know how I can do this? Thanks. __ Do you Yahoo!? Plan great trips with Yahoo! Travel: Now over 17,000 guides! http://travel.yahoo.com/p-travelguide -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database load and table design ?
In the last episode (Apr 16), Michael Gale said: > Currently I am using syslog-sql to store syslog data in a mysql > database. The table format is something like: > > IDhostnamefacilityprioritydatemessage > > Now I am writting a perl app to calculate stats based on the data in > the table which will get run everyday. It is currently doing a loop, > here is an example: > > Select count(facility) from syslog WHERE machine = '$srv' AND facility = > '$fac' AND date1 > (NOW() - INTERVAL 24 hour) > > Now $srv is the name of the host and $fac is the facility name. This > select statement is in a loop that loops through each server and each > facility. > > When this is running it puts a load on the DB, since there could be > about 20 host, each with 6 facilities, which equals about: > > 600 - The number of times that the select statement would be run > > I suppose that running the query: > > select host,facility from WHERE date1 > (NOW() - INTERVAL 24 hour) > > and letting perl do the math on the selected results would be less of a > system load ? Why not SELECT host, facility, COUNT(*) FROM syslog WHERE date1 > (NOW() - INTERVAL 24 HOUR) GROUP BY host, facility -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Database load and table design ?
Hello, Currently I am using syslog-sql to store syslog data in a mysql database. The table format is something like: ID hostnamefacilityprioritydatemessage ID is auto incrementing Now I am writting a perl app to calculate stats based on the data in the table which will get run everyday. It is currently doing a loop, here is an example: Select count(facility) from syslog WHERE machine = '$srv' AND facility = '$fac' AND date1 > (NOW() - INTERVAL 24 hour) Now $srv is the name of the host and $fac is the facility name. This select statement is in a loop that loops through each server and each facility. When this is running it puts a load on the DB, since there could be about 20 host, each with 6 facilities, which equals about: 600 - The number of times that the select statement would be run I suppose that running the query: select host,facility from WHERE date1 > (NOW() - INTERVAL 24 hour) and letting perl do the math on the selected results would be less of a system load ? Is there a better way ? Also I am going to display the results using the following format: hostnamehost A host B ... Facility name facility A X XX facility B X xX facility C X XX Is there an easy way to put that into a mysql table ?? Thanks. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Size of BLOB types?
Beautiful! Cheers, (one and all), Dan. On Sat, 16 Apr 2005, Dan Nelson wrote: >In the last episode (Apr 16), Dan Bolser said: >> The manual dosn't specify the maximum number of characters in the >> >> TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. >> >> http://dev.mysql.com/doc/mysql/en/blob.html > >At the top of that page: > > The four TEXT types, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT, > correspond to the four BLOB types and have the same maximum lengths > and storage requirements. > >There should probably be a link to >http://dev.mysql.com/doc/mysql/en/string-type-overview.html , which >gives you the exact limits. > >> Are these valid synonyms, TINYBLOB, MEDIUMBLOB and LONGBLOB? >> >> I have a field with just under 1000 characters, am I OK with a TINYTEXT? > >No, since TINYTEXT is limited to 256 bytes. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Size of BLOB types?
In the last episode (Apr 16), Dan Bolser said: > The manual dosn't specify the maximum number of characters in the > > TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. > > http://dev.mysql.com/doc/mysql/en/blob.html At the top of that page: The four TEXT types, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT, correspond to the four BLOB types and have the same maximum lengths and storage requirements. There should probably be a link to http://dev.mysql.com/doc/mysql/en/string-type-overview.html , which gives you the exact limits. > Are these valid synonyms, TINYBLOB, MEDIUMBLOB and LONGBLOB? > > I have a field with just under 1000 characters, am I OK with a TINYTEXT? No, since TINYTEXT is limited to 256 bytes. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Size of BLOB types?
>...my question is what are the maximum >sizes (in characters) of each of the BLOB / TEXT types, I assume the reason the sizes are not given in characters is that these are binary fields - it's in bits because that's what relevant to binary data. >and why isn't that >information on the manual page for BLOB / TEXT types. For that you'd have to ask MySQL. As to why there's a "TINY" - again I'm assuming, but I'd expect if someone has a lot of small binary data elements to store, they wouldn't necessarily want to waste 1K, or 65K of disk space for each element. Just because you have no use for it doesn't mean others don't. My experience with most DB software is that it's driven by requirements, not whim. - Original Message - From: "Dan Bolser" <[EMAIL PROTECTED]> To: "Robert Dunlop" <[EMAIL PROTECTED]> Cc: "Hassan Schroeder" <[EMAIL PROTECTED]>; Sent: Saturday, April 16, 2005 2:22 PM Subject: Re: Size of BLOB types? On Sat, 16 Apr 2005, Robert Dunlop wrote: >Your question was would a TINYBLOB hold 1,000 characters. >TINYBLOB (TINYTEXT) = 257 characters. 1,000 > 257 = No. >Your next option, BLOB (TEXT) = 64K. 1,000 < 64K = Yes. Yeah, I got that part, more generally my question is what are the maximum sizes (in characters) of each of the BLOB / TEXT types, and why isn't that information on the manual page for BLOB / TEXT types. Another question comes to mind, which is why is TINYTEXT so useless? A VARHCAR(255) is nearly as good! I would have thought any datatype with BLOB in its name would have the self respect to hold at least 65536 characters! Thanks for the pointers so far, Dan. > >- Original Message - >From: "Dan Bolser" <[EMAIL PROTECTED]> >To: "Hassan Schroeder" <[EMAIL PROTECTED]> >Cc: >Sent: Saturday, April 16, 2005 1:49 PM >Subject: Re: Size of BLOB types? > > >On Sat, 16 Apr 2005, Hassan Schroeder wrote: > >>Dan Bolser wrote: >>> The manual dosn't specify the maximum number of characters in the >>> >>> TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. >>> >>> http://dev.mysql.com/doc/mysql/en/blob.html >>> >>> Are these valid synonyms, TINYBLOB, MEDIUMBLOB and LONGBLOB? >> >>The very beginning of the cited page is: >> >> >> A BLOB is a binary large object that can hold a variable amount of >> data. The four BLOB types, TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB, >> differ only in the maximum length of the values they can hold. >> >> See Section 11.5, â?oColumn Type Storage Requirementsâ?. >> >> The four TEXT types, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT, >> correspond to the four BLOB types and have the same maximum lengths >> and storage requirements. >> >> >>And if you follow that link to Section 11.5, you'll find the size >>of all of the above, and the answer to your question: >> >>> I have a field with just under 1000 characters, am I OK with a TINYTEXT? >> >>:: which is "nope" :-) >> >>FWIW! > >FWIW? > >Naturally I followed that link, but was unable to understand (or piece >together) the information there in. > >Storage Requirements for String Types: >(or maximum length of BLOB types for dummies) > >TINYBLOB (or TINYTEXT) = 1+(2^ 8) =257 characters >BLOB (or TEXT) = 2+(2^16) = 65538 characters >MEDIUMBLOB (or MEDIUMTEXT) = 3+(2^24) = 16777219 characters >LONGBLOB (or LONGTEXT) = 4+(2^32) = 4294967300 characters > >Does that answer my question? > >I think it does, but I am not sure. Seems strange not to have this >information at the very begining of the cited page. > > > > -- 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: Size of BLOB types?
Dan Bolser wrote: FWIW? For What It's Worth... Naturally I followed that link, but was unable to understand (or piece together) the information there in. Storage Requirements for String Types: (or maximum length of BLOB types for dummies) Not exactly -- "storage requirements" include the DB overhead characters so, for instance, the max *usable* size of TINYBLOB (or TINYTEXT) = 1+(2^ 8) =257 characters is 255 bytes. Does that answer my question? Yep. :-) For ~1000 characters you'll need a TEXT field. I think it does, but I am not sure. Seems strange not to have this information at the very begining of the cited page. I'd have probably put it there in plain English (and numbers) too, but no one asked me :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Size of BLOB types?
On Sat, 16 Apr 2005, Robert Dunlop wrote: >Your question was would a TINYBLOB hold 1,000 characters. >TINYBLOB (TINYTEXT) = 257 characters. 1,000 > 257 = No. >Your next option, BLOB (TEXT) = 64K. 1,000 < 64K = Yes. Yeah, I got that part, more generally my question is what are the maximum sizes (in characters) of each of the BLOB / TEXT types, and why isn't that information on the manual page for BLOB / TEXT types. Another question comes to mind, which is why is TINYTEXT so useless? A VARHCAR(255) is nearly as good! I would have thought any datatype with BLOB in its name would have the self respect to hold at least 65536 characters! Thanks for the pointers so far, Dan. > >- Original Message - >From: "Dan Bolser" <[EMAIL PROTECTED]> >To: "Hassan Schroeder" <[EMAIL PROTECTED]> >Cc: >Sent: Saturday, April 16, 2005 1:49 PM >Subject: Re: Size of BLOB types? > > >On Sat, 16 Apr 2005, Hassan Schroeder wrote: > >>Dan Bolser wrote: >>> The manual dosn't specify the maximum number of characters in the >>> >>> TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. >>> >>> http://dev.mysql.com/doc/mysql/en/blob.html >>> >>> Are these valid synonyms, TINYBLOB, MEDIUMBLOB and LONGBLOB? >> >>The very beginning of the cited page is: >> >> >> A BLOB is a binary large object that can hold a variable amount of >> data. The four BLOB types, TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB, >> differ only in the maximum length of the values they can hold. >> >> See Section 11.5, â?oColumn Type Storage Requirementsâ?. >> >> The four TEXT types, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT, >> correspond to the four BLOB types and have the same maximum lengths >> and storage requirements. >> >> >>And if you follow that link to Section 11.5, you'll find the size >>of all of the above, and the answer to your question: >> >>> I have a field with just under 1000 characters, am I OK with a TINYTEXT? >> >>:: which is "nope" :-) >> >>FWIW! > >FWIW? > >Naturally I followed that link, but was unable to understand (or piece >together) the information there in. > >Storage Requirements for String Types: >(or maximum length of BLOB types for dummies) > >TINYBLOB (or TINYTEXT) = 1+(2^ 8) =257 characters >BLOB (or TEXT) = 2+(2^16) = 65538 characters >MEDIUMBLOB (or MEDIUMTEXT) = 3+(2^24) = 16777219 characters >LONGBLOB (or LONGTEXT) = 4+(2^32) = 4294967300 characters > >Does that answer my question? > >I think it does, but I am not sure. Seems strange not to have this >information at the very begining of the cited page. > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Size of BLOB types?
Your question was would a TINYBLOB hold 1,000 characters. TINYBLOB (TINYTEXT) = 257 characters. 1,000 > 257 = No. Your next option, BLOB (TEXT) = 64K. 1,000 < 64K = Yes. - Original Message - From: "Dan Bolser" <[EMAIL PROTECTED]> To: "Hassan Schroeder" <[EMAIL PROTECTED]> Cc: Sent: Saturday, April 16, 2005 1:49 PM Subject: Re: Size of BLOB types? On Sat, 16 Apr 2005, Hassan Schroeder wrote: >Dan Bolser wrote: >> The manual dosn't specify the maximum number of characters in the >> >> TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. >> >> http://dev.mysql.com/doc/mysql/en/blob.html >> >> Are these valid synonyms, TINYBLOB, MEDIUMBLOB and LONGBLOB? > >The very beginning of the cited page is: > > > A BLOB is a binary large object that can hold a variable amount of > data. The four BLOB types, TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB, > differ only in the maximum length of the values they can hold. > > See Section 11.5, â?oColumn Type Storage Requirementsâ?. > > The four TEXT types, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT, > correspond to the four BLOB types and have the same maximum lengths > and storage requirements. > > >And if you follow that link to Section 11.5, you'll find the size >of all of the above, and the answer to your question: > >> I have a field with just under 1000 characters, am I OK with a TINYTEXT? > >:: which is "nope" :-) > >FWIW! FWIW? Naturally I followed that link, but was unable to understand (or piece together) the information there in. Storage Requirements for String Types: (or maximum length of BLOB types for dummies) TINYBLOB (or TINYTEXT) = 1+(2^ 8) =257 characters BLOB (or TEXT) = 2+(2^16) = 65538 characters MEDIUMBLOB (or MEDIUMTEXT) = 3+(2^24) = 16777219 characters LONGBLOB (or LONGTEXT) = 4+(2^32) = 4294967300 characters Does that answer my question? I think it does, but I am not sure. Seems strange not to have this information at the very begining of the cited page. -- 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: Size of BLOB types?
On Sat, 16 Apr 2005, Hassan Schroeder wrote: >Dan Bolser wrote: >> The manual dosn't specify the maximum number of characters in the >> >> TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. >> >> http://dev.mysql.com/doc/mysql/en/blob.html >> >> Are these valid synonyms, TINYBLOB, MEDIUMBLOB and LONGBLOB? > >The very beginning of the cited page is: > > > A BLOB is a binary large object that can hold a variable amount of > data. The four BLOB types, TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB, > differ only in the maximum length of the values they can hold. > > See Section 11.5, “Column Type Storage Requirements”. > > The four TEXT types, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT, > correspond to the four BLOB types and have the same maximum lengths > and storage requirements. > > >And if you follow that link to Section 11.5, you'll find the size >of all of the above, and the answer to your question: > >> I have a field with just under 1000 characters, am I OK with a TINYTEXT? > >:: which is "nope" :-) > >FWIW! FWIW? Naturally I followed that link, but was unable to understand (or piece together) the information there in. Storage Requirements for String Types: (or maximum length of BLOB types for dummies) TINYBLOB (or TINYTEXT) = 1+(2^ 8) =257 characters BLOB (or TEXT) = 2+(2^16) = 65538 characters MEDIUMBLOB (or MEDIUMTEXT) = 3+(2^24) = 16777219 characters LONGBLOB (or LONGTEXT) = 4+(2^32) = 4294967300 characters Does that answer my question? I think it does, but I am not sure. Seems strange not to have this information at the very begining of the cited page. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Size of BLOB types?
Dan Bolser wrote: The manual dosn't specify the maximum number of characters in the TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. http://dev.mysql.com/doc/mysql/en/blob.html Are these valid synonyms, TINYBLOB, MEDIUMBLOB and LONGBLOB? The very beginning of the cited page is: A BLOB is a binary large object that can hold a variable amount of data. The four BLOB types, TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB, differ only in the maximum length of the values they can hold. See Section 11.5, âColumn Type Storage Requirementsâ. The four TEXT types, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT, correspond to the four BLOB types and have the same maximum lengths and storage requirements. And if you follow that link to Section 11.5, you'll find the size of all of the above, and the answer to your question: I have a field with just under 1000 characters, am I OK with a TINYTEXT? :: which is "nope" :-) FWIW! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting at boot-Fedora Core 3
Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use there: stop restart I have a MySql server on one of my machines that is running FC3 and I don't even have mysql_safe here. (Version 3.23.58) Andy -- Registered Linux User Number 379093 -- --BEGIN GEEK CODE BLOCK- Version: 3.1 GAT/O/>E$ d-(---)>+ s:(+)>: a--(-)>? C$(+++) UL>$ P-(+)>++ L+++>$ E---(-)@ W+++>+++$ !N@ o? !K? W--(---) !O !M- V-- PS++(+++) PE--(-) Y+ PGP++(+++) t+(++) 5-- X++ R*(+)@ !tv b-() DI(+) D+(+++) G(+) e>$@ h++(*) r-->++ y--()> -- ---END GEEK CODE BLOCK-- -- Check out these few php utilities that I released under the GPL2 and that are meant for use with a php cli binary: http://www.vlaamse-kern.com/sas/ -- -- pgpAURHhrWK92.pgp Description: PGP signature
4==4something: equal vs identical
Hi everone I ran into some situation where MySql selects a row by using the following query: SELECT `id` FROM `shop_products` WHERE `id`="4aef" LIMIT 1; ++ | id | ++ | 4 | ++ Granted the field IS of type int but 4 is not identical to 4aef (it may be equal to the eyes of MySql) Isn't there an MySql equivalent of === (test for same+same type) or should I just ignore this. With kind regards Andy -- Registered Linux User Number 379093 -- --BEGIN GEEK CODE BLOCK- Version: 3.1 GAT/O/>E$ d-(---)>+ s:(+)>: a--(-)>? C$(+++) UL>$ P-(+)>++ L+++>$ E---(-)@ W+++>+++$ !N@ o? !K? W--(---) !O !M- V-- PS++(+++) PE--(-) Y+ PGP++(+++) t+(++) 5-- X++ R*(+)@ !tv b-() DI(+) D+(+++) G(+) e>$@ h++(*) r-->++ y--()> -- ---END GEEK CODE BLOCK-- -- Check out these few php utilities that I released under the GPL2 and that are meant for use with a php cli binary: http://www.vlaamse-kern.com/sas/ -- -- pgpZTv9kC6LFt.pgp Description: PGP signature
Size of BLOB types?
The manual dosn't specify the maximum number of characters in the TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. http://dev.mysql.com/doc/mysql/en/blob.html Are these valid synonyms, TINYBLOB, MEDIUMBLOB and LONGBLOB? I have a field with just under 1000 characters, am I OK with a TINYTEXT? Cheers, Dan. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL bottleneck
Hello there, let's say I have 365,000 users I need to enter their data, pull from it and modify it regularly. Is MySql the way to go ? Or do I need to buy an oracle or ms server ? thanks in advance for a clue From: [EMAIL PROTECTED] To: "B Wiley Snyder" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: How to retain "Key" order when Deleting a Row Date: Tue, 12 Apr 2005 14:48:54 -0400 "B Wiley Snyder" <[EMAIL PROTECTED]> wrote on 04/11/2005 10:38:12 PM: > Hello experts, > > I just need someone to please point me in the right direction on retaining > my "key" or id order in my table when I delete a row. So for example I have > 10 rows Id 1-10 that are created automatically when the record is inserted. > > So if I delete record with id 5 my id's are not 1,2,3,4,6,7,8,9,10 but > 1,2,3,4,5,6,7,8,9 ??? > > > thanks > > _ > Express yourself instantly with MSN Messenger! Download today - it's FREE! > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > It sounds like you are confusing a data storage requirement (a unique, non-repeating identifier for every row) with a presentation requirement (a neatly numbered list of records). If I need a nicely ordered list of numbers, I use my programming language to provide it. If I need to uniquely identify a record, I use the ID. When an ID has been issued, it generally stays "used" even if that record no longer exists. Shawn Green Database Administrator Unimin Corporation - Spruce Pine _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL not starting at boot-Fedora Core 3
Hi All, attempting another mysql install, on a 3rd machine. Extracted the tar.gz file to /usr/local/mysql. Followed the install docs here, http://dev.mysql.com/doc/mysql/en/installing-binary.html and successfully ran the MySql grant tables script, 6. If you haven't installed MySQL before, you must create the MySQL grant tables: shell> scripts/mysql_install_db --user=mysql I then followed here, http://dev.mysql.com/doc/mysql/en/automatic-start.html to a T, and copied mysql.server to /etc/init.d, and just for good measure, gave it permission to execute, chmod +x /etc/init.d/mysql I then rebooted, to see how things would go at boot, and saw a failed message for mysqld_safe, Apr 16 21:20:01 localhost lsb_log_message: Can't execute ./bin/mysqld_safe failed Can anyone explain why it wouldn't start..? Anything I should be looking for..? I can start the server with ./mysqld_safe from within the bin dir and I can connect as root or mysql. Cheers. /etc/init.dmysql permissions [EMAIL PROTECTED] init.d]# ls -lh mysql -rwxr-xr-x 1 root root 6.2K Apr 16 21:11 mysql Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Include repeats in query
Hi, I have the following query: SELECT person FROM people WHERE ORDER BY RAND() * (1 / score) LIMIT 1 This returns a person randomly, but the chance of the person being selected is increased with a higher `score`. What I want to do is make a single query that will return 10 results in this fashion. Currently I'm doing: for (i = 1; i <= 10; i++) do: SELECT person FROM people WHERE ORDER BY RAND() * (1 / score) LIMIT 1 Which returns a results like: Mike Sam Sam Mike Mike Mike John Sam Mike John This is exactly the result I desire, but programmatically it's not the most efficient way. I'm guessing using 1 query and using the result set is MUCH faster, 1 query... 1 result, instead of 10. I have tried: (SELECT person FROM people WHERE ORDER BY RAND() * (1 / score) LIMIT 1) UNION (X) UNION (X) ... [repeat ten times] This however returns this kind of result: Mike Sam John The UNION query seems to remove the repeats, and because this is a mathematical system this will throw it out. This of course is not what I want :-(. Is there an option that allows repeats? Cheers, - Martin
Access denied-phpMyAdmin
Hi All, I can access the database from the terminal on Fedora 3, [EMAIL PROTECTED] bin]# ./mysql -h localhost -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.1.10a-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> But, get the following error when accessing via phpMyAdmin with user as root and the correct password, phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. |#1045 - Access denied for user 'root'@'localhost' (using password: YES) I don't understand this. What have I missed..? $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin-2.6.1-pl3/'; $cfg['Servers'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = 'password is correct'; // MySQL password (only needed Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]