RE: Is it my English or does this sound bad?

DOOD!! THAT IS NOT P.C.!!! YOU GONNA GET US IN TROUBLE... Peter <^_^> > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 05, 2003 5:10 PM > To: Defryn, Guy > Cc: [EMAIL PROTECTED] > Subject: Re: Is it my English or does this sound bad? > >

RE: best way to optimize a table with many to few relationship.

What you're talking about is a many-many relationship, as one product can belong to many categories, and one category can encompass many products. The best way to implement this is to have a [category] table, a [product] table, and a [categoryproduct] table. The latter table implements the many-ma

RE: When are MyIsam Tables physically updated?

This is not so...Mysql will write out the data for MyIsam tables without calling the operating system to do an fsync()...it's up to the OS to flush dirty pages to disk. See http://www.mysql.com/doc/en/Command-line_options.html under the --flush command line parameter. Peter <^_^> > -Original

RE: TIMESTAMP field is updated unintentionally

Timestamp columns update automatically. http://www.mysql.com/doc/en/DATETIME.html Peter <^_^> > -Original Message- > From: Marco Deppe [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 31, 2003 6:18 AM > To: [EMAIL PROTECTED] > Subject: TIMESTAMP field is updated unintentionally > >

RE: Cardinality doesn't auto start

You need to run [analyze table] to create the index stats...do this reasonable often (once a day for a well-used table). Running [optimize table] on the table recreates index stats AND reorganizes/defrags/coalesces data pages...do this once a week or so. Look up the mysqlcheck utility--it lets yo

RE: Weird locking/blocking issues

> > I have built mysql (4.0.9) on freebsd (4.7-RELEASE) with > linuxthreads > > (2.2.3) and still encounter the 'strange threading' > behavior described in J. > > Zawodny's blog. > > > > Here's the situation... > > > > 1/ there are three threads which lock and then write to two > different > >

Weird locking/blocking issues

Heya Folkth: I have built mysql (4.0.9) on freebsd (4.7-RELEASE) with linuxthreads (2.2.3) and still encounter the 'strange threading' behavior described in J. Zawodny's blog. Here's the situation... 1/ there are three threads which lock and then write to two different tables...the locks are got

RE: Building MySQL with LinuxThreads

To update on the threading problem that I see even with Linuxthreads on FreeBSD... The select thread which isn't given the read lock it requests cycles through the states 'NULL', 'Waiting for tables', 'Locked', 'System Lock', and 'Reopen Tables' from what I've seen so far (there could be more? Al

RE: Building MySQL with LinuxThreads

Heya Folkth: I have built mysql (4.0.9) on freebsd (4.7-RELEASE) with linuxthreads (2.2.3) and still encounter the 'strange threading' behavior described in J. Zawodny's blog. Here's the situation... 1/ there are three threads which lock and then write to two different tables...the locks are got

RE: High list latency?

I noticed a lag yesterday...but simply attributed it to our internal mail setup (which is bad in oh-so-many-ways). Peter <^_^> -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 11:45 PM To: [EMAIL PROTECTED] Subject: High list latency? I

RE: Changing InnoDB files

Heya thar: Take the file that you have as autoextend right now, round it down to the nearest meg, and enter this value as the size (without autoextend). Then make the new file autoextend. Peter <^_^> -Original Message- From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Sent: Thursday,

RE: FreeBSD 5.0 Thread Work...

rom: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 4:45 PM To: Grigor, Peter Cc: '[EMAIL PROTECTED]' Subject: Re: FreeBSD 5.0 Thread Work... On Mon, Jan 20, 2003 at 02:20:10PM -0500, Grigor, Peter wrote: > Alrighty then! > > Now FreeBSD 5.0 has bee

FreeBSD 5.0 Thread Work...

Alrighty then! Now FreeBSD 5.0 has been released, what are the plans for mysql to evaluate the new (really new :) thread implementation. Peter <^_^> - Before posting, please check: http://www.mysql.com/manual.php (the manua

RE: Problems with simple(?) query

In your query ID2 cannot be both 1 and 2 (typomundo) Peter <^_^> -Original Message- From: James Dyer [mailto:jad@;disparate.org] Sent: Monday, November 11, 2002 3:04 PM To: [EMAIL PROTECTED] Subject: Problems with simple(?) query Hi, I'm trying to write what I am sure should be a simpl

RE: perl dbi and mysql question

Of course, you could have also used: $stmt = $db->prepare("show databases"); Peter <^_^> -Original Message- From: Shon Stephens [mailto:sstephens@;corp.goamerica.net] Sent: Friday, November 08, 2002 9:50 AM To: Shon Stephens; '[EMAIL PROTECTED]' Subject: RE: perl dbi and mysql question

RE: Key/table cache size?

> I've got a query that selects the count of distinct rows in a table; the > table has 453632 rows and 24 distinct class_id's. > > mysql> SELECT count(DISTINCT(sig_class_id)) FROM acid_event; > +---+ > | count(DISTINCT(sig_class_id)) | > +--

RE: MySQL CPU usage skyrocketing

Ok, we know that FreeBSD has problems with its thread implementation; however, I'd like to know if the MySql guys know exactly what causes the problems to which Mr Zawodny refers. I'm running FreeBSD 4.6.2, and have seen the 'rogue thread' problem before which leads me to believe that either FreeB