Here's a SQL statement that converts dates to epoch time in Oracle.
I'm too lazy to convert it to MySQL but it should give you a start.
select 86400 * ( to_date('14-feb-2000 10:38:39', 'dd-mon-
hh24:mi:ss')
- to_date('01-jan-1970', 'dd-mon-') )
from dual;
--Walt
>
.
> I access through JDBC drivers. Oracle usually needs 10
> seconds in every
> query I execute. It is very odd.
>
> Thank you again.
>
> - Original Message -
> From: "Weaver, Walt" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sen
You didn't provide much information about your system.
What version of MySQL? Oracle?
With Oracle, which optimizer are you using? Oracle, compared to MySQl,
is very tunable and it's easy to make it run badly.
We run customer databases on both MySQL and Oracle, using a product
developed on MySQ
Perl/DBI is a possibility.
--Walt
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 16, 2004 8:48 AM
> To: [EMAIL PROTECTED]
> Subject: ORACLE to MySQL migration
>
>
> Hello colleagues,
> I have to migrate a lot of ORACLE 8.1.7 databases to
Or use an outer join with "where members.list_id is null", as was
mentioned on the list earlier today.
--Walt
> -Original Message-
> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 06, 2004 3:18 PM
> To: [EMAIL PROTECTED]
> Subject: Re: A challenge I think
>
>
>
I'd use the InnoDB table type and establish a primary key/foreign key
relationship (parent-child) between the two. That way referential integrity
will be done for you by the database.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Chris Burger [mailto:[EMAIL PROTECTED]]
Sent:
Try this (not sure the syntax is exactly right since I'm more used to
Oracle's outer join syntax):
select * from main left join activity on main.user = activity.id
where activity.id is null;
This should return only the users in main that are not in activity.
--Walt Weaver
Bozeman, Montana
-
This must be a great scam. I'm starting to see'em all over the place.
--Walt
-Original Message-
From: Ocita Gabriel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 3:53 PM
To: [EMAIL PROTECTED]
Subject: Goodday
Attn: mysql ,
My name is Ocita G, the manager, credit
and for
I wasn't aware of this. I thought the Red Hat database was PostgreSQL.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: john greene [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 2:32 PM
To: [EMAIL PROTECTED]
Subject: mysql comes with linux ?
red hat linux implementa
Yeah, the table DDL in an Oracle export file is in ascii format. I've used
vi in the past to extract the DDL. You might be SOL though as far as reading
the data is concerned.
--Walt
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 12, 2002 11:42 AM
To
I think it will be very difficult to do. In Oracle export files the data is
written in Oracle's own proprietary binary format. I don't know of any tools
other than Oracle's own import utility that is able to read the .dmp file.
You may need to get them to send you a .csv file instead.
--Walt Wea
Take a look in the my.cnf file.
-Original Message-
From: Laura Findley [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 2:45 PM
To: MySQL List
Subject: MySQL port # ?
Does anyone know how to determine what port MySQL is using?
I need to know the port so that I can use it in a JD
I wasn't asking a question. I was trying to answer one.
I obviously didn't do a very good job...:>)
--Walt
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 10:01 AM
To: [EMAIL PROTECTED]
Subject: Re: RE: MySQl price
Weaver,
Tu
Well, I'm under the impression that if the application you're selling
provides links to MySQL but not the database itself you don't have to pay
for a license for each sale; it's up to the buyer of the app to obtain a
MySQL license.
I'd sure talk to someone at mysql.com, though.
--Walt Weaver
B
InnoDB supports foreign keys. And, an index must be created on the foreign
key; this would help from an optimization point of view.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: harm de laat [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 8:43 AM
To: Kiss Dániel
Cc: [E
I believe the autoextend functionality won't be available until 4.0.2.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: vlady [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 2:19 PM
To: [EMAIL PROTECTED]
Subject: Innodb "autoextended"
Hi all,
I am using mysql-4.0.1. I a
Hmmm... we're running 3.23.47 here and have run into a 32 table join
limit...
--Walt
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 10:19 AM
To: mysql mailing list
Cc: Arthur Fuller
Subject: Re: Maximum JOINED tables
* Arthur Fuller
> I
Yup, it'd be the answer to everything. :>)
-Original Message-
From: Andrew Hazen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 10:00 AM
To: Weaver, Walt; 'Arthur Fuller'; 'mysql mailing list'
Subject: RE: Maximum JOINED tables
Would have been
32.
-Original Message-
From: Arthur Fuller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 9:48 AM
To: mysql mailing list
Subject: Maximum JOINED tables
I have searched the manual without success. I want to know the maximum
number of tables MySQL permits to be JOINed in a sing
I've been trying to find it too. Haven't had any luck yet...
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 9:06 AM
To: [EMAIL PROTECTED]
Subject: Trying to find source Tarball for 4.0.2
Dear List,
Which 4GL Relational Database Management System are they talking about?
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Phil Reardon [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 7:57 AM
To: [EMAIL PROTECTED]
Subject: newbie question
I have data on CD ROM for the Mari
when MySQL 4.0.2 will be out? We'd like to play around with InnoDB's
autoextend feature on v.4.
Thanks,
--Walt Weaver
Bozeman, Montana
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:/
First question: did you set autocommit=0?
--Walt Weaver
Bozeman, Montana
-Original Message-
From: a a [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 9:27 AM
To: [EMAIL PROTECTED]
Subject: transactions on MySQL (innoDB)
Hello
I can't create innoDB tables in db MySQL to do
According to perror, error 127 = Record-file is crashed. This is a symptom
of a corrupted table.
Check out the MySQL manual, 4.4.6.9, How to Repair Tables. Specifically, try
running myisamchk on the table.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Carter, Robert L (MN65)
Oracle-L has a number of PL/SQL gurus on it. Good list.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Lance Prais [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 12:42 PM
To: [EMAIL PROTECTED]
Subject: Important question
Does anyone know of any good PL SQL Oracl
In my experience InnoDB tables are superior to BDB, but during my
comparisons I was working with a lot more data -- millions of rows -- than
you will be; BDB's problems seemed to center around the size of the tables.
So, BDB could work well for you.
But, I can recommend InnoDB as a good way to go
InnoDB!
--Walt
-Original Message-
From: Dominique DUTENDAS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 8:02 AM
To: MySQL
Subject: Lock row
Hi, I want to lock a row in a table, and just the row I have selected
what's the solution under MySQL
Thank's
Dominique
-
Sure seems that way to me. Same SQL engine no matter what table type you
use.
InnoDB didn't scare me. Pretty friendly to use. :>)
--Walt
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 2:09 PM
To: [EMAIL PROTECTED]
Cc: Tobias Lind - Tel
Couldn't you return the data you need by using an outer join? The rows in
tbl1 that aren't in tbl2 would have null values in the name fields. You
could order by the name fields.
Or, you could migrate the data to Oracle and use DECODE to put "No record"
in the name fields that are null. :>)
--W
Sounds good. Thanks for the info, Heikki.
--Walt
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 11:13 AM
To: [EMAIL PROTECTED]
Subject: Re: Benchmarking MyISAM, InnoDB, and Oracle: a problem with
InnoDB
Walt,
this is probably a perfo
Cool. Thanks, John.
--Walt
-Original Message-
From: John Kemp [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 1:06 PM
To: Weaver, Walt
Cc: [EMAIL PROTECTED]
Subject: Re: innoDB confusion
Walt,
It'll go to the database_machine_name.err file on that machine.
John
W
m confused as to how I capture this.
I'm running on Linux Redhat 6.2 with the 2.4 kernel, mysql 3.23.44.
Thanks,
-- Confused In Bozeman
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 11:18 AM
To: [EMAIL PROTECTED]
Subject: Re: innoDB
Do a "show table status" at the mysql prompt. Under "type" you should see
InnoDB.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 10:57 AM
To: Mysql List (E-mail)
Subject: RE: innoDB confusion
One fina
Thanks for the info on 2.4, everyone. I've been doing my testing on 2.4.17.
Here are the "official" results of my testing here (I had the 2.4 time in my
previous email messed up):
MyISAM: 2.2 -- 11 minutes; 2.4 -- 6 minutes
InnoDB: 2.2 -- 21 minutes; 2.4 -- 9 minutes
Pretty good increase in per
Anyone else out there been playing with the new Linux 2.4 kernel?
I just upgraded a test server from 2.2 to 2.4 and reran some of my InnoDB
tests. The results were dramatic; updating a 600,000 row table went from 21
minutes and change to 6 minutes and change.
Haven't tried 2.4 and MyISAM tables
John wrote:
> That's not something that is generally necessary with other RDBMSs.
I disagree. I would imagine all transaction-oriented RDBMS's work this way.
Oracle certainly does. You need to do an explicit commit or rollback to
release the lock. (or close the cursor, etc.)
Unless, of course, a
If you'd like I can send you the configure "script" I used to set up MySQL
for Berkeley and InnoDB.
--Walt
-Original Message-
From: Ken Kinder [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 28, 2001 1:26 PM
To: Weaver, Walt; [EMAIL PROTECTED]
Subject: Re: Forcing Tabl
Ken,
When you configured/compiled MySQL, did you use the --with-innodb option?
What version of MySQL are you running?
FWIW, I wasn't real impressed with the Berkeley tables, but the InnoDB
tables work very well.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Ken Kinder [mail
Thanks for the reply, Heikki.
That the MyISAM would fit in OS file cache didn't occur to me. That would
certainly help explain the big discrepancy. And yes, we had autocommit
turned on for InnoDB, not for Oracle. The InnoDB buffer pool size was 350mb,
not big enough to hold the whole table. The O
This post is partially a reply to a request to share my MyISAM/InnoDB/Oracle
comparison testing with you guys. In addition, I have a question about
locking mechanisms in InnoDB which I'll ask at the end of the post.
I've been comparison testing MyISAM, InnoDB, and Oracle for the past two
weeks or
Yup, somehow I must've missed that. Thanks...
--Walt
-Original Message-
From: Mike(mickalo)Blezien [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 10:22 AM
To: Weaver, Walt
Cc: [EMAIL PROTECTED]
Subject: Re: Error trying to create InnoDB database. HELP
Did you ru
Dammit, never mind. I figured it out.
Maybe someday I'll be able to ask an intelligent question here...
--Walt
-Original Message-
From: Weaver, Walt
Sent: Wednesday, December 05, 2001 10:09 AM
To: [EMAIL PROTECTED]
Subject: Error trying to create InnoDB database. HELP
Okay,
Okay, I've finally gotten around to trying to create an InnoDB database.
I've configured MySQL on Linux Red Hat 6.2, mysql 3.23.44 with the
--with-innodb parm. Everything installed wonderfully.
When I start up mysqld, the datafiles and logfiles are created just fine.
But, when everything is done
Not sure that total users is a good metric; queries per second may be
better.
We host web sites and use MySQL with MyISAM tables for small and
medium-sized sites, Oracle for the big ones. Oracle's row-level locking
abilities make a big, deciding difference for the bigger, more active sites.
Oracl
Yup, --quick did the trick. Actually I wound up using --opt. Thanks.
Quidditch is sort of an airborne soccer game. It requires special equipment
not normally available in stores.
-- Walt Weaver
Bozeman, Montana, USA
-Original Message-
From: Sinisa Milivojevic
To: Weaver, Walt
Cc
,
--Walt Weaver
Bozeman, Montana, USA
-Original Message-
From: sherzodR
To: Weaver, Walt
Cc: [EMAIL PROTECTED]
Sent: 11/30/2001 3:14 AM
Subject: re: mysqldump: problem/question
So what was the problem?
Weaver, Walt wrote:
WW: Okay, I know you guys have been wracking your brains
Okay, I know you guys have been wracking your brains for the last two days
trying to solve my problem of mysqldump running out of memory while dumping
a large table.
I figured it out, so you can all go on with your lives.
My copy of Paul DuBois' MySQL book came today and immediately solved my
pr
Another newbie question:
I'm trying to do a mysqldump of a fairly large, wide (two longblobs) table,
and am running into memory problems.
After running for some time the mysqldump process will die with an "Out of
memory (needed 8164 bytes)" message.
Is there a way to tell mysqldump to not cache
Okay, unregard my question. I figured out what I was doing wrong.
It's too embarrassing to tell you guys.
Thanks,
--Walt
-Original Message-
From: Weaver, Walt
Sent: Monday, November 26, 2001 9:52 AM
To: [EMAIL PROTECTED]
Subject: Using Berkeley tables -- how to set up?
I'm a relative newbie to MySQL (most of my experience is with Oracle) and am
currently trying to set things up to use the Berkeley tables with
transaction processing.
I downloaded the mysql-3.23.44.tar.gz source and installed it on Linux Red
Hat 6.2. I configured it with the --with-berkeley-db op
50 matches
Mail list logo