On Sat, Aug 25, 2001 at 09:24:25PM -0500, Paul DuBois wrote:
> At 10:07 AM -0700 8/24/01, Katherine Porter wrote:
> >For single values I usually use this DBI function and query:
> >
> > my $val =3D $dbh->selectrow_array("SELECT value FROM tab1 WHERE test=3D=
> >2");
> >
> >However, what if I wan
On Sun, Aug 19, 2001 at 10:21:46AM -0400, Philip Mak wrote:
> On Sun, 19 Aug 2001, Sinisa Milivojevic wrote:
>
> > If this is happening on Windows, we truly can not do anything about
> > it.
> >
> > You could help there by forcing all table names to be lower-case by
> > starting mysql service wit
DELAY_KEY_WRITE=1
Tim.
On Mon, Aug 06, 2001 at 07:36:17AM -0700, Jeff Tanner wrote:
>
> I running a test on mysql to test its performance of doing a bulk insert
> into a table using LOAD DATA INFILE.
>
> The table is simple:
>
> CREAT TABLE test (
> valueCHAR(32) NOT NULL PRIMARY KEY
toring the last value
into a session global to simplify emulation of last_insert_id.
CHECK clause for SET types.
Handle embedded quotes etc in default values etc.
Query mysql db to set initial start value of auto_increment sequence
=head2 AUTHOR
Copyright Tim Bunce, 2001. Released un
Great. Thanks.
Tim.
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Tim Bunce" <[EMAIL PROTECTED]>
Cc: "Nathanial Hendler" <[EMAIL PROTECTED]>; "Mysql"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
I recall that maybe a month or four ago someone posted a message (on
the [EMAIL PROTECTED] list I think) saying that they'd written a
utility to parse MySQL create table statements and write out equivalent
Oracle create table statements.
I remember replying to the message (possibly privately) and
On Fri, Jul 06, 2001 at 04:36:08PM +0300, Sinisa Milivojevic wrote:
> Tim Bunce writes:
> > On Fri, Jul 06, 2001 at 02:51:34PM +0300, Sinisa Milivojevic wrote:
> >
> > It may have been implemented 2 months ago (for v4.0), but it doesn't
> > seem to be documented
On Fri, Jul 06, 2001 at 02:51:34PM +0300, Sinisa Milivojevic wrote:
> Volker Paepcke writes:
> > Hi!
> >
> > One year ago Michael Widenius posted this:
> >
> >
> > We have on the other hand played with the idea to at some point
> > implement SQL commands of type:
> >
> > IS
You'll find mysqldumpslow (in the mysql distribution) does all that and
much much more
It's a pity that it's not mentioned in the online documentation
since it's a _very_ useful tool.
Tim.
On Mon, Jun 25, 2001 at 11:59:59PM -0700, Nathanial Hendler wrote:
> I wrote a perl script that will parse
On Tue, Jun 26, 2001 at 05:20:25PM -0400, Sherzod Ruzmetov wrote:
>
> Can someone explain me why is it waste of space???
No support for emulating autoincrement fields.
No support for mysql specific types.
No support for mysql specific functions.
No support for ...
In fact no support for almost
On Tue, Jun 12, 2001 at 04:42:42PM -0700, Jeremy Zawodny wrote:
> On Tue, Jun 12, 2001 at 05:06:59PM -0500, Zhu George-CZZ010 wrote:
> >
> > Is there a way/tool to migrate the Application from MySql to Oracle
> > 8i?
>
> Oracle has one available on their web site...
Mostly a waste of space.
Ti
On Wed, May 16, 2001 at 03:01:26PM +0300, Heikki Tuuri wrote:
> Andreas,
>
> sorry, it is the default MySQL behavior to create a MyISAM table if
> another handler is not present.
>
> There was a long thread of emails between MySQL developers if MySQL
> should give an error message if a table can
On Sun, May 13, 2001 at 06:09:12PM +0300, Heikki Tuuri wrote:
> >
> >> >Suggested improvements would be the addition of COALESCE TABLESPACE
> >>
> >> Do you mean reorganization and compaction of a tablespace? The way to
> >> do it is to dump and reload all tables in the tablespace.
> >
> >During
On Wed, Apr 11, 2001 at 06:14:51PM -0500, pmetha wrote:
> Hello all:
>
> I need to create a db link type structure within Oracle 817 EE
> to connect to MySQL so that I can read mySQL tables.
>
> Can any kind person point me in the direction of how to do this
> if it is possible at all.
We're ex
On Wed, Apr 11, 2001 at 12:33:44PM -0400, Ken Menzel wrote:
> The list reject my trace (it was too large), so here is a smaller
> one! Stops after info from first top starts showing CPU usage of 99%
> Ken
>
> Hi Tim, I just had it happen. Overall average 14 queries per second
> on this machin
I suspect the point is that many more threads simply makes the problem
appear more often and thus be reproducible and thus more easily fixed.
Tim.
On Wed, Apr 11, 2001 at 04:49:19PM +0200, Lars Andersson wrote:
> My 4.2 STABLE dosent get so many queries, according to mysqladmin (Queries
> per se
FYI, people experiencing this problem should try to make the mysqld as
idle as possible (ie disconnect or idle the connections) and then run
truss -p NNN (where NNN is the pid of the mysqld process) and post
a typical chunk of the output.
That would give valuable info to the mysql developers.
Ti
I've seen what's probably the same thing under 4.2-STABLE.
The poll() system call returns 1 but there's no corresponding
file handle marked in the data structures that were passed to poll().
(It could be a mysqld bug if they're asking to poll() for certain kinds
of events but then not checking f
On Sun, Apr 08, 2001 at 12:46:43AM +0300, Michael Widenius wrote:
>
> Hi!
>
> >>>>> "Tim" == Tim Bunce <[EMAIL PROTECTED]> writes:
>
> Tim> On Sat, Apr 07, 2001 at 02:14:42AM +0300, Michael Widenius wrote:
> >>
>
On Sat, Apr 07, 2001 at 02:14:42AM +0300, Michael Widenius wrote:
>
> The reason singly queries are slower are of course that the
> initialization phase (reading the data from a socket, parsing,
> locking, checking which keys to use) is about half of the query time.
>
> Peter> Heikki made test
On Fri, Apr 06, 2001 at 07:26:14PM +0300, Heikki Tuuri wrote:
> Hi!
>
> The MySQL manual says that INSERT DELAYED only works for MyISAM
> and ISAM tables, but the parser does not check that the table type
> is correct. We have to block this in the parser.
>
> If you use it on Innobase tables, th
f any do.
Tim.
> --Greg Johnson
>
> -Original Message-
> From: Martin Hubert [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 06, 2001 9:52 AM
> To: Tim Bunce; Heikki Tuuri
> Cc: [EMAIL PROTECTED]; FileCopy
.
Plus, of course, it wouldn't actually matter if it did in this case
since mysqld will happily convert the strings to numbers anyway.
Tim.
> On Fri, 6 Apr 2001, Tim Bunce wrote:
>
> > Date: Fri, 6 Apr 2001 11:00:57 +0100
> > From: Tim Bunce <[EMAIL PROTECTED]>
>
But if you're measuring the elapsed time of the perl script to do
benchmarks, as here, then it'll give a more accurate picture by
removing irrelevant overheads.
Tim.
> -Original Message-
> From: Tim Bunce [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 06, 2001 3:01 A
On Thu, Apr 05, 2001 at 07:50:24PM +0300, Heikki Tuuri wrote:
>
> for ($j = 0; $j < 10; $j = $j + 1) {
>
>$dbh->do("insert into speed1 values ($j, $j, $j)");
> }
That would run faster if you do a prepare with placeholders outside
the loop and then just use $sth->execute($j, $j, $j)
On Fri, Apr 06, 2001 at 12:13:22AM -0400, Thalis A. Kalfigopoulos wrote:
> On Thu, 5 Apr 2001, Roel Vanhout wrote:
>
> > Hi all,
> >
> > Is there a way to turn the query logging on and off while the database
> > server is running? Right now I have a script that stops and restarts the
> > databas
On Thu, Apr 05, 2001 at 09:12:08PM -0400, Steve Werby wrote:
> "Michael Widenius" <[EMAIL PROTECTED]> wrote:
> > This thing has been up a couple of times over the years. The problem
> > is that requiring people to be subscribers to the mailing list before
> > posting will only confuse the poor peo
Hi!
> I just come across this old email:
>
> On Thu, Mar 09, 2000 at 03:14:28PM +0200, sinisa wrote:
> >
> > This happens in the case when mysql does not have to create temporrary
> > tables in order to obtain result set, but is reading from the live
> > table itself.
> >
> > Changing a table d
On Thu, Mar 29, 2001 at 07:57:41PM +0300, Michael Widenius wrote:
>
> mysql> rename tables test1 to test3, test2 to test1, test3 to test2;
> Peter> ERROR 1192: Can't execute the given command because you have active locked
> Peter> tables or an active transaction
>
> I bet this happens when you
On Mon, Mar 19, 2001 at 02:24:52PM +0200, Sinisa Milivojevic wrote:
>
> Hi!
>
> I tested your test case and you are right !
We've just discovered a very similar sounding problem immediately after
upgrading to 3.23.35. In our case an update is reporting 0 zero rows
updated which then triggers an
the MySQL slow query log
# Original version by Tim Bunce, sometime in 2000.
# Further changes by Tim Bunce, 8th March 2001.
use strict;
use Getopt::Long;
# t=time, l=lock time, r=rows
# at, al, and ar are the corresponding averages
my %opt = (
s => 'at',
h => '*
On Fri, Feb 23, 2001 at 11:29:21AM +0200, Tõnu Samuel wrote:
> [EMAIL PROTECTED] wrote:
> >
> > On 22.02.2001 16:22:13 Simon Windsor wrote:
> >
> > > Has anyone user MySql on a ReisserFS file system ?
> >
> > HERE!
> >
> > No problems whatsoever - why should there be problems anyway?
>
> Only
On Mon, Feb 12, 2001 at 03:02:49PM +0200, Heikki Tuuri wrote:
> [...]. Currently, in MySQL
> you must call UNLOCK TABLES before issuing another LOCK TABLES, because
> there is no deadlock detection in MySQL itself.
I believe a LOCK TABLES does an automatic atomic UNLOCK TABLES of any
that were l
On Mon, Feb 05, 2001 at 01:36:50PM -0700, Steve Ruby wrote:
> Henrik Lebtien Mohr wrote:
> >
> > Hi there
> >
> > I use ASP and ADO 2.5 to access the data in my MySQL RDBMS.
> > I get an error "Multiple-step error" when I try to update a recordset like
> > the following:
> >
> > with rs
> >
On Mon, Feb 05, 2001 at 03:23:49PM +0800, Chan, Kwok-Hing wrote:
> Can MySQL make a DB link connection to Oracle such that MySQL can access
> tables in Oracle
No.
> and vice versa?
Yes. It's possible, at least in theory, to use the Oracle Transparent
Gateway product to go Oracle -> Gateway -> M
On Fri, Feb 02, 2001 at 05:48:41PM +0100, Marcello Giovagnoli wrote:
> >
> > Do you mean that mysql_store_result() should store everything to a
> > local file and and mysql_fetch... should read from this file?
> > This should not be that hard to do.
Like SQL_BUFFER_RESULT, but at the client inst
On Thu, Feb 01, 2001 at 09:17:13AM -0600, Fowler, J.T. wrote:
> My error - I had the [EMAIL PROTECTED] URL in my notepad not the correct
> ORACLE link
>
> For news about how to "FOR FREE" convert from mySQL to ORACLE:
>
> http://www.oracle.com/ip/deploy/database/featurestory/index.html?mysql.
On Wed, Jan 31, 2001 at 05:07:09PM +0200, Michael Widenius wrote:
>
> The problem is not just the open; The problem is that we currently have to map
> all read/writes to a handler that checks if the table is raid or not.
Fair enough.
> What we need in the future is to add a wrapper around file
On Tue, Jan 30, 2001 at 01:13:43PM -0800, Jeremy D. Zawodny wrote:
> On Tue, Jan 30, 2001 at 05:08:46PM +0000, Tim Bunce wrote:
> > On Tue, Jan 30, 2001 at 10:57:16PM +0800, Sam Wong wrote:
> > > >
> > > > So why isn't the --with-raid option set in the bi
On Tue, Jan 30, 2001 at 10:57:16PM +0800, Sam Wong wrote:
> > So why isn't the --with-raid option set in the binary download version?
>
> The file will be bigger and slower in result
I doubt it would be significantly bigger. I believe --with-raid support is
a very small and simple layer between m
On Tue, Jan 30, 2001 at 12:44:43PM +0100, Tonu Samuel wrote:
> On Tue, 30 Jan 2001, Jason Frisvold wrote:
>
> > Thanks for the reply.. Is that a stable way of doing things? Is
> > there a performance hit when using the --with-raid option?
>
> Very small if at all. RAID does some additional
On Tue, Jan 23, 2001 at 01:26:59PM +0200, Tomi Junnila wrote:
> * Santeri Paavolainen <[EMAIL PROTECTED]> wrote on 23.01.01 13:05:
> > >Fix:
> > SELECTs can be worked around with table aliases, others not.
>
> Oops, I forgot to include the cure. The first way to do this I encountered
> is to
On Fri, Jan 19, 2001 at 04:07:59PM -0700, Jason Radley wrote:
> I am currently using php and mysql and I was wondering if you can take the
> data from a mysql database and move it to a oracle database?
I'll be experimenting soon with using Oracle's ODBC Gateway to access
MySQL data 'live' via MyO
43 matches
Mail list logo
