[UPHPU] Database Design

[Jonathan Duncan]

On Mon, 6 Nov 2006, Richard K Miller wrote:

>
> On Nov 6, 2006, at 4:50 PM, Mac Newbold wrote:
>
>> 
>> So it looks like the meeting this month (Thurs. Nov. 16, 7pm) is on 
>> Database Design, and that I'll be presenting it. So I'd like to ask for 
>> some input as I go about preparing for our discussion.
>> 
>> 1. Are there any particular areas of database design that you'd really like 
>> to know more about?
>> 
>> 2. How much do you think you know about good database design?
>> 
>> 3. I'm thinking about doing one or more case studies based on real (or 
>> semi-real) situations. Would that interest you? Would you have a situation 
>> we could study?
>> 
>
> I'd be most interested in benchmarking, performance tweaking, and which tools 
> to use for these.  I guess that would include an explanation of SHOW 
> VARIABLES and SHOW STATUS, and I'm referring to 1 machine, not necessarily a 
> cluster.
>
>

Although not really on the topic of database "design" I would also be 
interested in these things.  I would like to find a good "real-time" mysql 
monitoring tool.

Perhaps in addition to database design we could also learn more about 
database administration and performance tuning.  A good design can also be 
a very effective way to increase performance efficiency.

Jonathan