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 want to store a
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 with a
values etc.
Query mysql db to set initial start value of auto_increment sequence
=head2 AUTHOR
Copyright Tim Bunce, 2001. Released under the same terms as Perl.
=cut
use strict;
use Carp;
use Parse::RecDescent;
use Data::Dumper;
use Getopt::Long;
use vars qw(%VARIABLE %opt);
%opt
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
)
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]
Sent: Friday, July 20, 2001 12:05 AM
Subject: Re: Perl Script: MySQL Slow Query Log
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)
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:
ISAM INSERT
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.
Will is be documented soon?
Tim
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 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.
Tim.
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 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 cannot be
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 my tests I've
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.
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
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 machine.
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
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
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 people that
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
database with
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) inside.
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 AM
To: Heikki Tuuri
Cc: [EMAIL PROTECTED
, 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]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED], [EMAIL
Message-
From: Martin Hubert [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 06, 2001 9:52 AM
To: Tim Bunce; Heikki Tuuri
Cc: [EMAIL PROTECTED]; FileCopyMartin
Subject:RE: Mysql speed
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, that can
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 tests
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 during such
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 have a
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
# 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 = '*',
);
GetOptions(\%opt,
'v+', # verbose
On Fri, Feb 23, 2001 at 11:29:21AM +0200, Tnu 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 problem we know is
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 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 30, 2001 at 01:13:43PM -0800, Jeremy D. Zawodny wrote:
On Tue, Jan 30, 2001 at 05:08:46PM +, 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 binary download version?
The file will be bigger
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 simply
35 matches
Mail list logo