Hi,
Hi guys,
I'm doing a data migration from oracle to MySQL.
There is a table including BFILE datatype column on the Oracle, but I
can't find the replacement in MySQL, Would anyone like to give me some
advice or solutions?
A BFILE is nothing more than a filename really, except
that it can
On Thu, 2007-07-26 at 18:37 +1000, Andrew Armstrong wrote:
Hello,
I am seeking information on best practices with regards to Data Warehousing
and MySQL. I am considering moving to PostgreSQL.
* Table 1: 80,000,000 rows - 9.5 GB
* Table 2: 1,000,000,000 rows - 8.9 GB
Just
Hello,
I am seeking information on best practices with regards to Data Warehousing
and MySQL. I am considering moving to PostgreSQL.
I am currently using MySQL as the database of choice. I am now running into
performance issues with regards to large tables.
At the moment, I have the
Good morning,
I am trying to build MySQL from source on Solaris 6. A pre-compiled
version is not available for Solaris 6 and we cannot upgrade the OS to
Solaris 8.
I currently have Ver 9,38 Ditrib 3.22.32 installed, but the main MySQL
Server (the one one Solaris is used as a client only) has
On 7/26/07, Andrew Armstrong [EMAIL PROTECTED] wrote:
snip
Information is deleted from this DW as well, after every five minutes.
The data being recorded is time sensitive. As data ages, it may be deleted.
Groups of samples are aggregated into a summary/aggregation sample prior to
being deleted.
Hey,
Table 1 has 29 columns. Row length median is 78. Row size median is 126
bytes. Fixed table format.
Table 2 has 6 columns. Row length median is 22. Row size median is 96 bytes.
Fixed table format.
There are three indexes on each of these tables.
Table 1 has an index on 4 columns, and
Do you have a suggestion to how this should be implemented?
Data is aggregated over time and summary rows are created.
-Original Message-
From: Wallace Reis [mailto:[EMAIL PROTECTED]
Sent: Thursday, 26 July 2007 8:43 PM
To: Andrew Armstrong
Cc: mysql@lists.mysql.com
Subject: Re: Data
krishna chandra prajapati wrote:
Hi Everybody,
I am looking for a tool which can moniter mysql and if any thing goes wrong
with mysql then it can send a mail or alert. It can show the innodb status
and all the complete details about mysql.
Regards,
Krishna
I don't think a single tool
Hello,
I need some advice for setting up a mysql database (debian etch) to
store many blobs (about 1 GB) . I run a HP DL 360 (?), 1 GB RAM,
RAID 5, 10K disks, 30 GB and the standard installation of mysql
coming with debian etch (5.0.32, readline 5.2)
I need only one database (innodb) with 1
I'm having a problem with the fulltext searching, and was looking for some
help.
i'm currently working with the following query:
select table.*
from table where match(title, description) against ('*search term*' IN
BOOLEAN MODE)
the reason I am using boolean mode, is so that it matches things
Hi Martijn,
thank you for your advice!
Martijn Tonies [EMAIL PROTECTED] 写道: Hi,
Hi guys,
I'm doing a data migration from oracle to MySQL.
There is a table including BFILE datatype column on the Oracle, but I
can't find the replacement in MySQL, Would anyone like to give me some
advice or
Tangirala, Srikalyan wrote:
Hi All:
Could you provide some more information about Oracle limitations, MySQL
limitations, Oracle vs. MySQL etc?
Sure, let's play devil's advocate for a minute.
Some things unique to MySQL that Oracle does not offer include:
- Storage engines, choices like
Wallace is right, Data Warehousing shouldn't delete any data. MySQL
isn't as robust as say, Oracle, for partitioning so you need to fudge
things a little. I think partitioning is the way to go and you should
use MERGE tables to handle your partitions. Really what you are
looking to do is
I've already chosen granularity for samples.
5 minute samples for example can expire after two days.
Aggregated/summarized rows of this data (30 minute sample for example, which
is the aggregation of the past 30 minutes worth of 5 minute samples in a
given window) expire after a week, etc.
I'm
Hi all!
OS: Win 2000 server
MySQL: mysql 4.1
I have an issue trying to restore some databases from a disk replaced, I mean,
move from the old disk to the new one, I cannot launch mysqld from the old
disk because boot sector was damaged, so I cannot do a mysqldump, We've
replaced the disk and
All well and good but that comparison is dated:
March 14, 2005
Many enhancements all around since then.
Simon
-Original Message-
From: Rajesh Mehrotra [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 26, 2007 11:32 AM
To: Tangirala, Srikalyan; cluster
Cc: mysql@lists.mysql.com
Subject:
Hi All:
I am doing a study on the migration of databases from Oracle to MySQL. In
this process, I gathered few points.
Overall, I think arguments can be made in favor of MySQL in terms of
performance, stability, ease of use, and cost. All of these things point to
decreased TCO when using MySQL
Hi Lars,
Lars Schwarz wrote:
hi all, is there any shorthand to extract the string part of a varchar
field
only?
like when having german street addresses (e.g. foostreet 23) in a varchar
field
and i want to select the non-numeric part of it (foostreet) only?
I can't think of a way to do this
hi all, is there any shorthand to extract the string part of a varchar field
only?
like when having german street addresses (e.g. foostreet 23) in a varchar
field
and i want to select the non-numeric part of it (foostreet) only?
thanks, best: lars
Hi,
You can use Applications Manager to monitor mysql servers.
The product is free to monitor upto 10 mysql servers.
More info available here
http://manageengine.adventnet.com/products/applications_manager/
http://manageengine.adventnet.com/products/applications_manager/mysql-management.html
Hi Ofer,
Is it necessary to stop the slave before doing the mysql dump.
If we use --single-transaction option in mysqldump should provide consistent
backup..right.
or stop slave
note the slave status info.
start slave
start mysqldump.
regards
anandkl
On 7/26/07, Ofer Inbar [EMAIL PROTECTED]
Hi guys,
I'm doing a data migration from oracle to MySQL.
There is a table including BFILE datatype column on the Oracle, but I can't
find the replacement in MySQL, Would anyone like to give me some advice or
solutions?
Thank you very much!
@@@^_^@@@
Could you please explain Linear Hashing Partitioning in MySQL
thanks,
DT
www.ejinz.com
Search Engine News
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Jan Pieter, all !
I am sorry I reply so late, was too busy with other things till now.
Jan Pieter Kunst wrote:
Dear mysql-ers,
It seems that the Mac OS X PowerPC 64 bit version of the MySQL
Community server is no longer available.
That was true in some versions, there were issues with
Hi,
Could you provide some more information about Oracle limitations, MySQL
limitations, Oracle vs. MySQL etc?
I thought it was your study?
MySQL doesn't have (compared to Oracle):
- check constraints
- a procedural language as mature as Oracle PL/SQL
- triggers on a per statement basis as
As far as I know my make is GNU. In fact, as I said at the end of the
email
pvwdev-s mysql-5.0.45 make --version
GNU Make version 3.76.1, by Richard Stallman and Roland McGrath.
Linedata Services (UK) Ltd
Registered Office: Bishopsgate Court, 4-12 Norton Folgate, London, E1 6DB
Registered
The only regular expression MySQL support return a true/false if the
expression was found. I had to do something similar to what you want
to do. Although I needed to count how many digits there were.
You can use the REPLACE() function to strip out the numbers. Of
course, this means you need
Thanks for your input Raj.
Regards,
Sri
-Original Message-
From: Rajesh Mehrotra [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 26, 2007 11:32 AM
To: Tangirala, Srikalyan; cluster
Cc: mysql@lists.mysql.com
Subject: RE: Migration from Oracle to MySQL
Check out
Check out
http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html
Raj Mehrotra
hccs - Experts in Healthcare Learning
[EMAIL PROTECTED]
-Original Message-
From: Tangirala, Srikalyan [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 26, 2007 11:11 AM
To: cluster
Cc:
Giulio
did you take into consideration that the Solaris make is not the GNU
make? and that you possibly have to install first the GNU make before
making MySQL?
suomi
Giulio Troccoli wrote:
Good morning,
I am trying to build MySQL from source on Solaris 6. A pre-compiled
version is not
Hi,
As my mysql command line utility aborts when searching for certain
characters in a binary field (it affects bash as well), I decided to
convert these characters via CHAR(character) instead, like this:
select binary_column from my_table where binary_column like CONCAT
I'm having a very weird problem with $result-fetch_assoc(). Here are two
very simplified examples. One uses a prepared statement (although for this
exercise I'm not using any bound parameters, my results aren't affected);
the other example uses $db-query(). Look at the retrieved $row.
?php
$db =
padmanabhan
padmanabhan G wants you to join Yaari!
On 7/26/07, Andrew Armstrong [EMAIL PROTECTED] wrote:
Do you have a suggestion to how this should be implemented?
Data is aggregated over time and summary rows are created.
I think that you didnt design correctly your DW.
It should have just one very larger table (the fact table).
Data should
I think I've figured things out. First off, I missed $db-stmt_init()
completely. Second, I missed the fact that you HAVE to bind the retrieved
values to variables, you can't create a result object and then use
$result-fetch_array(). And so on...
In short, I guess I was mixing incompatible
Yep, thanks.
I've been looking at MySQL's partitioning in 5.1 which seems the best
choice. It's not GA yet, but I may consider using it as it appears to be
working fine at the moment.
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Friday, 27 July 2007 10:23 AM
36 matches
Mail list logo