RE: Integrity on large sites

In my experience this happens a lot if you put application programmers in charge of the database. I've upset quite a few in my time by introducing RI and then their horribly coded application falls over! -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: 24 May 2007

Re: Integrity on large sites

B. Keith Murphy wrote: Here is the kicker. Each box was a top of the line Sun server that had 32 processors and 32 gigs of RAM. They could handle up to 64 procs and 64 gigs. And each cost well over a million dollars for the hardware alone. Running Oracle on it must have cost over 100,000

Re: How to get the table.column in mysql client tab completion? Or feature request to add this.

Hi, Daevid Vincent wrote: [snip] Also, it would be great if mysql client was smart enough to limit my tab completion choices to possibilities based upon the current SQL query I'm crafting. So If I have: select t[TAB] from ResolveTable join Tickets; It should only show me columns that start

Re: Integrity on large sites

You youngsters may not realize that there were billing applications serving millions of customers long, long before there were any kind of database management systems. They employed concepts called flat files and batch processing. And they ran on machines far weaker than anything any of

Re: Integrity on large sites

Hey there, thanks for your comments. There are issues where sharding may be appropriate, but you are talking about the heaviest of heavy duty loads. Not only that, hardware is getting to the point where it is surpassing our needs. Remember the days when it cost $200k to run a library database?

error message

Hi All, We are using 5.0.40-enterprise-gpl-log version on our production db. If we run a stored proc, we are getting the below error Query OK, 0 rows affected, 1 warning (0.01 sec) ERROR 1308 (42000): LEAVE with no matching label: SWL_return mysql show warnings; - //

select with like not working...

Hi all, I'm new to the list so please excuse me if I make some newbie mistakes, I am having trouble figuring out why a select statement won't work, Here's the statement: SELECT 'FName' FROM `current` WHERE `FName` like '%jason%';. if I run select 'FName' FROM current; then I get 6 rows

Re: select with like not working...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Have you tried using 'jason%' instead of '%jason%'? Also, do you have an index on that column? Jason Pruim wrote: Hi all, I'm new to the list so please excuse me if I make some newbie mistakes, I am having trouble figuring out why a select

Need script to populate data.

Group, I'm an oracle dba and new to mysql. I've just recieved responsiblity to work on a mysql project. Basically I have 1 table: forumid smallint(5) unsignedNO (null) 0 (null) styleid smallint(5) unsignedNO (null) 0 (null) title varchar(100)NO

Need script to populate data.

Group, I'm an oracle dba and new to mysql. I've just recieved responsiblity to work on a mysql project. Basically I have 1 table: forumid smallint(5) unsignedNO (null) 0 (null) styleid smallint(5) unsignedNO (null) 0 (null) title varchar(100)NO

Re: Need script to populate data.

This should do it. Save it in a file then run it like perl newfile.pl. Save the output into a text file, then run it against your database. $records = 100; for ($i=1;$i=$records;$i++) { print INSERT INTO MyTable (forumid, styleid, title, title_clean, . description, description_clean, options)

Re: Need script to populate data.

Ryan, Thanks for your help. I'm not able to ssh into this box - how can I run this script, basically all I have to work with is MySQL Query Broswer. TIA From: Ryan Stille [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: Need script to populate data. Date: Fri, 25 May 2007

Re: Need script to populate data.

In the last episode (May 25), SRM SRM said: Thanks for your help. I'm not able to ssh into this box - how can I run this script, basically all I have to work with is MySQL Query Broswer. You can generate data by using a stroed procedure, too. I prefer this method because it doesn't

do I need 2 selects?

Say I have x rows of 2 columns each. For example, 2 rows: 'A 10:00pm' and 'A 11:00pm'. I want to return one 'A' row with the latest time (eg. 'A 11:00pm). I could do 'select distinct(col1) from table' and then 'select col1, max( col2 ) where col1=row[0]'? Is there a way to do it in one

Re: select with like not working...

I have tried %jason%, %jason, jason% all with the same result... Do you need to have an index of the column? Currently I didn't intentionally make one so I'm not sure if it's automatic or not... On May 25, 2007, at 1:26 PM, Mike Lockhart wrote: -BEGIN PGP SIGNED MESSAGE- Hash:

Re: select with like not working...

would you can post the table script?? create and insert... because it should be work ... Jason Pruim escreveu: I have tried %jason%, %jason, jason% all with the same result... Do you need to have an index of the column? Currently I didn't intentionally make one so I'm not sure if it's

Re: Integrity on large sites

It is my contention that as the clustering capabilities of MySQL continue to grow and mature (think of when version 6.0 goes stable) companies will move to MySQL in droves. THEN you have the ability to build a single virtual database (at least from the point of view of your application)

RE: How to get the table.column in mysql client tab completion? Or feature request to add this.

Daevid Vincent wrote: [snip] Also, it would be great if mysql client was smart enough to limit my tab completion choices to possibilities based upon the current SQL query I'm crafting. So If I have: select t[TAB] from ResolveTable join Tickets; It should only show me

Re: do I need 2 selects?

Baron Schwartz wrote: Hi James, James Lockie wrote: Say I have x rows of 2 columns each. For example, 2 rows: 'A 10:00pm' and 'A 11:00pm'. I want to return one 'A' row with the latest time (eg. 'A 11:00pm). I could do 'select distinct(col1) from table' and then 'select col1, max( col2 )

Re: do I need 2 selects?

Hi James, all! James Lockie wrote: Say I have x rows of 2 columns each. For example, 2 rows: 'A 10:00pm' and 'A 11:00pm'. I want to return one 'A' row with the latest time (eg. 'A 11:00pm). I could do 'select distinct(col1) from table' and then 'select col1, max( col2 ) where col1=row[0]'?

Strange result from multiple JOIN

I'm trying to construct a join, but the effect I want seems to be impossible to achieve. In this schema, the uid field is unique in the players table, but not in the ranking table (one player per uid, multiple rankings per player) I want to select player names and rankings for a particilar

Re: do I need 2 selects?

Hi James, James Lockie wrote: Say I have x rows of 2 columns each. For example, 2 rows: 'A 10:00pm' and 'A 11:00pm'. I want to return one 'A' row with the latest time (eg. 'A 11:00pm). I could do 'select distinct(col1) from table' and then 'select col1, max( col2 ) where col1=row[0]'? Is

Re: do I need 2 selects?

- Original Message - From: James Lockie [EMAIL PROTECTED] To: MySQL Mailing List mysql@lists.mysql.com Sent: Friday, May 25, 2007 3:11 PM Subject: do I need 2 selects? Say I have x rows of 2 columns each. For example, 2 rows: 'A 10:00pm' and 'A 11:00pm'. I want to return one 'A'

RE: Need confirmation: Subselects are broken with regards to index usage?

Lets hope something is done about it soon, not all sub queries SHOULD be re-written as joins. Generally joins that result in the need to use DISTINCT are better off re-written as IN OR EXISTS sub queries. In any event, I have a lot of very complex queries that work great for our other database

Re: Integrity on large sites

Hi Naz, Just to throw out (plug) an ongoing project: http://www.hivedb.org/ From the site: HiveDB is an open source framework for horizontally partitioning MySQL systems. Building scalable and high performance MySQL-backed systems requires a good deal of expertise in designing the system