parallel processing in mysql

Does anyone know whether mysql supports parallel processing? I searched the documentation on mysql.com, but didn't find it mentioned thanks AOD __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.

how to spool timing of a query into a spool file

Hi. this is a minor problem that is driving me nuts. I have a query that runs nicely and I want to save its timing information in a spool file. When I connect to mysql and run the query it adds the time elapsed after the data (9 rows in set 1.1 sec). But when I run the same query in the line

how to spool timing of a query into a spool file

Hi this is a 2nd attempt. My first post never made it to the list. What I'm trying to do is to spool queries results into a spool file (via tee command). For some reason the timing information doesn't get there. When I run a query from mysql, the output is followed by a line with the number of

scaling/tuning problem

Hi. I have a query which completes in about 9 sec when executed alone, but the time grows dramatically when I execute several similar queries at the same time. If I execute 3 queries the time grows to 27-40sec, for 5 queries - toabout 1min, for 20 queries ran simultaniously the time jumps to 2-4

more problems with Wokrbench migration tool

Hi. I have ran into couple of problems using Oracle workbench migration tool. I was wondering if anyone out there has any insight. 1. If a date field in a mysql table has a default (let's say -12-31) the script for oracle table will also have -12-31 as a default field. This

Re: InnoDB Tables/Databases

Deryck, others: I'm doing some reading on InnoDB and am pretty ignorant on the subjets. Can someone explain why would InnoDB be faster than MySQL? From what I read it looks like it will have more overhead to support the transactions and that should decrease the performance rather than improve

can't use m2o.pl

Hi all: I have tried running the m2o.pl scrip to convert the mysql dump into an Oracle DDL and it seems to me that it didn't do anything at all. I ran the command the way README suggest : m2o mysqldump oracledump, but saw a number of the mysql-specific commands in the resulting file. Has

scheduling, priorities etc

Hi all: I have read somewhere that mysql allows inserts into a table without holes to go concurrently with the reads from that table. starting at v 3.23.7. I'm running 3.23.41-nt and have tried to accomplish that, but couldn't. My reads seem to only start after the inserts are completed. Is

why, oh why do I get this error

Hi. I'm running mysql on NT. when I start it via mysqld everything works. when I try to do: mysqld --log-update, I'm getting message can't initialize innodb as 'innodb_data_file_path' is not set. I didn't see anything about innodb being related to log-update option in the manual or MySQL

intro mysql book

Can someone recommend an intro MySQL book. I'm looking for a book with info on MySQL internals from the dba standpoint as well as usage from a developer standpoint. I'm going to take a look at MySQL by Paul Dubois. It seems to have good reviews, but would be interested in other recommendations.