Re: regarding BFILE datatype from Oracle

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

Re: Data Warehousing and MySQL vs PostgreSQL

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

Data Warehousing and MySQL vs PostgreSQL

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

Error compiling on Solaris 6

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

Re: Data Warehousing and MySQL vs PostgreSQL

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.

RE: Data Warehousing and MySQL vs PostgreSQL

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

RE: Data Warehousing and MySQL vs PostgreSQL

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

Re: Mysql monitering and performance tool

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

help with optimal configuration for blobs

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

fulltext search option

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

回复： Re: regarding BFILE datatype from Oracle

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

Re: Migration from Oracle to MySQL

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

Re: Data Warehousing and MySQL vs PostgreSQL

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

RE: Data Warehousing and MySQL vs PostgreSQL

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

Got error 1 from storage engine

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

RE: Migration from Oracle to MySQL

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:

Migration from Oracle to MySQL

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

Re: Extract String only from varchar Field?

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

Extract String only from varchar Field?

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

Re: Mysql monitering and performance tool

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

Re: seeding a slave from a slave

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]

regarding BFILE datatype from Oracle

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! @@@^_^@@@

Hashing Partitioning

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]

Re: Mac OS X PowerPC 64 bit

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

Re: Migration from Oracle to MySQL

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

RE: Error compiling on Solaris 6

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

Re: Extract String only from varchar Field?

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

RE: Migration from Oracle to MySQL

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

RE: Migration from Oracle to MySQL

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:

Re: Error compiling on Solaris 6

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

mysql cli aborts when searching for binary data

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

PHP mysqli problem

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 is your Yaar! :)

padmanabhan padmanabhan G wants you to join Yaari!

Re: Data Warehousing and MySQL vs PostgreSQL

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

RE: PHP mysqli problem

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

RE: Data Warehousing and MySQL vs PostgreSQL

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