Migration tools/plan from oracle 7.3 to Mysql 4.0

Hi, I am new to MySql. Could you please let me know the different migration tools avialable for the migration of oracle 7.3 database to mysql 4.0 classic version. Out of those which one is the best in performance and cost wise. As per my knowledge views, stored procedures and triggers

Weird behavior on varchar fields

Hi, I have one table that is presenting strange behaviour, we set the varchar field for not allow nulls so, on 5% of the records the application is inserting blanks but when we select the value and we set the condition ="" it returns the same as " " and " ". Even, we tried to set the field

RE: Kernel panic when mysql stop command issued

I know that 2.6.7 works just fine with MySQL 4.0.20. I don't use Max though. Donny > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] > Sent: Monday, August 16, 2004 12:11 AM > To: Demetrios Stavrinos > Cc: [EMAIL PROTECTED] > Subject: Re: Kernel panic when mysql stop

Full text for keyword(s) search?

If I want to search for a word (or multiple words) in a field on one table, searching through at least a thousand records (and growing daily), should I be using full text or something else to make this search faster? I'm using MySQL 3.23.58. Thanks, Eve -- MySQL General Mailing List For list

RE: Why "VARCHAR" TO "CHAR" automatically when the length less th an 4.

This is described here: http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html. The table is created as a fixed table format. -Original Message- From: Emi Lu To: [EMAIL PROTECTED] Sent: 8/16/04 3:20 PM Subject: Why "VARCHAR" TO "CHAR" automatically when the length less than 4. Hello

RE: MySQL eats 100% CPU on a quad CPU system...

I use memlock to ensure it stays in memory. More than likely it's table optimization. EXPLAIN and SHOW INDEXES will likely help you once you turn slow query logging on. -J -Original Message- From: Justin Swanhart [mailto:[EMAIL PROTECTED] Sent: Monday, August 16, 2004 3:24 PM To: [EMAI

Re: MySQL eats 100% CPU on a quad CPU system...

Are you swapping? Check vmstat and iostat Are your queries optimized, are they doing full table scans? Enable the slow query log. On Mon, 16 Aug 2004 14:48:35 +0200, Fahr o Mavastradioz <[EMAIL PROTECTED]> wrote: > Hello people, > > I'm currently configuring a quad CPU system as a standalone

problem with xalan and mysql in same application (long list of er rors)

Hi everyone, I am working on an API wrapper that will use both MySQL and the Xalan xml api. My versions are: Xalan-C_1_8_0-windows_2000-msvc_60.zip (available at xml.apache.org) xerces-c_2_5_0-windows_nt-msvc_60.zip (available at xml.apache.org) mysql 4.0.20 windows 2000 professional service p

Query formation / index optimization?

Hello, I am trying to create a query for the following scenario, that doesn't take ages and ages to return. Let's assume the following columns in an events table: user_name, event_type, event_time. I want to select a count of all users which have more than 1 (2 or more) entries in the event tab

RE: Which ports

To all of those that provided the information, thank you. Next time I have a question, I will do the research before bothering the list. -Darryl > -Original Message- > From: Steve Poirier [mailto:[EMAIL PROTECTED] > Sent: Monday, August 16, 2004 3:36 PM > To: [EMAIL PROTECTED] > Subject:

GROUP BY

My original concept to use group by was GROUP BY(MajorColumnGroupIng...MinorColumnGrouping) I am trying to be convinced that GROUP BY(Minor..Major) will work just as well Is there a difference??? thanks, Martin Gainty From: Joe Kislo <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Mysql 4.0.2

RE: Which ports

This has to be the top lazy question of the year. Do you know google.com or mysql.com ? Like google.com: Mysql port _ Steve Poirier > -Original Message- > From: Darryl Hoar [mailto:[EMAIL PROTECTED] > Sent: August 16, 2004 1:02 PM > To: [EMAIL PROTECTED]

Mysql 4.0.20(binary) Relay Log Purging not working

We just upgraded to MySQL 4.0.20 (binary), and we use replication to a slave running the same. We're having some difficulty deleting the relay log files the slave creates. I'm fairly confused, as the manual clearly says we shouldn't be having this problem: According to the MySQL manual: """ Rela

Why "VARCHAR" TO "CHAR" automatically when the length less than 4.

Hello all, I have a questions about "varchar columns" change to "CHAR columns" automatically. When I designed a table t1 create table t1(id varchar(3) not null) in MySQL. After that, we use "desc t1" to see the description of table "t1". The result is the following:

innodb_log_archive : should I activate it?

Hello I have looked in the archive of the mailing list, to see if there was any discussion on that, but I have not seen any message. I just install mysql 4.3.1 and I am wondering if I should archive the logfiles. In the documentation it is said about innodb_log_archive : "This value should

Re: Database Stats

25 databases with the SAME query? Sounds like the database structure are pretty similar. Perhaps you want to look into merge tables or unions. On Aug 16, 2004, at 12:58 PM, David Mohorn wrote: I have about 25 databases that I need to run the same query against that returns about 5 columns of in

Re: SQL question, SELECT DISTINCT

Disregard by last message it's a repeat. THANKS for the help! On Mon, 16 Aug 2004 14:32:27 -0400, "Michael Stassen" <[EMAIL PROTECTED]> said: > Then I'd suggest you declare f1 as an AUTO_INCREMENT column in the target > table, leave it out of the SELECT, and let it auto-generate IDs. > Something

Re: SQL question, SELECT DISTINCT

On Mon, 16 Aug 2004 13:57:13 -0400, "Michael Stassen" <[EMAIL PROTECTED]> said: > You were perfectly clear. We understand that you only want to test f2 > and f3 for uniqueness. The question is, which of the possible values > of f1 do you want to get. Do you see? For a particular unique f2, f3

Re: SQL question, SELECT DISTINCT

Then I'd suggest you declare f1 as an AUTO_INCREMENT column in the target table, leave it out of the SELECT, and let it auto-generate IDs. Something like this: INSERT INTO original_table (f2, f3) SELECT DISTINCT f2, f3 FROM new_table; I did that in the same order as your original message, t

Re: Upgrading Mysql and Perl DBD

This is covered in the manual : "A 4.1 client can connect to a pre-4.1 server, because the client understands both the old and new password hashing mechanisms." So, if you build the Perl modules against the 4.1.x library, you should be a

Re: SQL question, SELECT DISTINCT

On Mon, 16 Aug 2004 13:57:13 -0400, "Michael Stassen" <[EMAIL PROTECTED]> said: > You were perfectly clear. We understand that you only want to test f2 > and f3 for uniqueness. The question is, which of the possible values > of f1 do you want to get. Do you see? For a particular unique f2, f3

Upgrading Mysql and Perl DBD

I now have MySQL 4.0.2 and MySQL 4.1.3 beta both installed and running on one machine. I want to be able to use the Perl DBI / DBD to connect to both servers. I understand that there have been some changes between the MySQL 4.0.X and 4.1.X series that may require differently compiled DBD's. So

OS X Embedded Server

I have written an application for MAC OS X.3 that interfaces with MySQL through the Client/Server approach. I would like to simplify the installation process of the application by using the embedded MySQL server instead. However, I am having trouble figuring out how to: 1. Include the MySQL embe

Re: SQL question, SELECT DISTINCT

You were perfectly clear. We understand that you only want to test f2 and f3 for uniqueness. The question is, which of the possible values of f1 do you want to get. Do you see? For a particular unique f2, f3 combination, there may be multiple f1 values. How should we choose which one to put

Re: SQL question, SELECT DISTINCT

On Mon, 16 Aug 2004 12:39:32 -0400, [EMAIL PROTECTED] said: > Let me see if I can explain it a little betterIf you need to move all > 3 columns to the new table but you only want *1* row where f2 and f3 have > a unique combination of values, how do you want to choose *which* value > of > f1

release all mysql locks

Is there any command I can issue to release ALL locks held by any/all transactions ? I know that restarting the server does this, but is there a way to do this without restarting ? thanks, Mayuran -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:

Re: Database Stats

prototype of PHP script $db_stack=array("ip,user,pass,dbname,table","ip2,user2,pass2,dbname2,table2" ,...); $resultset=array(); foreach($db_stack as $k=>$v){ /// query database and get results $resultset[].=$portion_of_information; } foreach($resultset as $k=>$v){ //append row and save as csv fil

RE: T-SQL SUM() Overflow?

David- try redeclaring your INTEGER columns as BIGINT instead of INTEGER http://dev.mysql.com/doc/mysql/en/Numeric_types.html HTH, Martin Gainty From: "David Mohorn" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: T-SQL SUM() Overflow? Date: Mon, 16 Aug 2004 11:37:12 -0500 MIME-Version: 1.0

Re: Which ports

> Greetings, Howdie, > I have Mysql installed on my freebsd box. I want to > be able to access the database from the internet, but > I need to allow the ports used in my firewall. What > ports does mysql use ? http://dev.mysql.com/doc/mysql/search.php?q=port&from=%2Fdoc%2Fmysql%2Fen%2F&lang=en

Re: Database Stats

> I have about 25 databases that I need to run the same query against that > returns about 5 columns of information. > > I need this information then published within an Excel spreedsheet. > > What is the best way do handle this? > > Currently, I'm running each query manually, copying/pasting the

Which ports

Greetings, I have Mysql installed on my freebsd box. I want to be able to access the database from the internet, but I need to allow the ports used in my firewall. What ports does mysql use ? thanks, Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Database Stats

I have about 25 databases that I need to run the same query against that returns about 5 columns of information. I need this information then published within an Excel spreedsheet. What is the best way do handle this? Currently, I'm running each query manually, copying/pasting the result to E

Update MySQL row using URL link?

I currently update MySQL rows using phpMyAdmin. For example, dropping the following into the phpMyAdmin GUI: UPDATE mysql_db SET publish = 1 WHERE Date = 'Sunday, August 15, 2004 21:04:32' Since I get the update info in an e-mail send whenever the form is submitted, I'd like to turn querys like t

Re: SQL question, SELECT DISTINCT

Let me see if I can explain it a little betterIf you need to move all 3 columns to the new table but you only want *1* row where f2 and f3 have a unique combination of values, how do you want to choose *which* value of f1 to move over with that combination? Do you want the minimum value, the

Re: Replication, Windows, Modems

David Otton <[EMAIL PROTECTED]> wrote on 16/08/2004 13:55:59: > Hi, hoping someone's come across this before: > > I need to replicate data between two copies of MySQL, both running on > Windows XP. > > The amount of data is tiny - maybe 35k a day as an upper bound. It's > basically monitoring d

T-SQL SUM() Overflow?

Hello, I'm trying to run a T-SQL query that will SUM a column of type INT. I'm, however, receiving the following error: "Arithmetic overflow error converting expression to data type int." The four rows that its trying to sum have values of 3098082, 2488114, 316804, and 10657. What do I do? -

Re: Problems with DBI

I have a test.testac table created by a test script from a previous install. It is of type MyISAM, which does not support transactions. Did you alter or create your testac table to be of type InnoDB, which does support transactions? You can check with SHOW CREATE TABLE testac; or SHOW TA

Re: SQL question, SELECT DISTINCT

On Mon, 16 Aug 2004 11:36:32 -0400, [EMAIL PROTECTED] said: > It all depends on which values of f1 you want to ignore. > > f1 f2 f3 > - - -- > val1-1 val2 val3 > val1-2 val2 val3 > val1-3 val2 val3 > > Which value of f1 would you want in your new table? Which one

Re: SQL question, SELECT DISTINCT

It all depends on which values of f1 you want to ignore. f1 f2 f3 - - -- val1-1 val2 val3 val1-2 val2 val3 val1-3 val2 val3 Which value of f1 would you want in your new table? Which ones to ignore? Are there other columns (beyond these 3) to move as well? Yours,

SQL question, SELECT DISTINCT

say I'm selecting distinct (non-duplicate) rows for insertion, insert into original_table select distinct * from new_table these tables have 3 fields/row. Per the above code all 3 fields are evaluated by "distict *" . But my question is: I want to ignore field1, therefore I only want to test

Re: Problems with DBI

michael watson (IAH-C) wrote: Hi Not sure if I should be posting to the DBI list really, but I will try this one too. I'm running suse linux enterprise server 8.2, MySQL 4.0.15-standard-log, DBI 1.32 I get the following error message: DBD::mysql::db rollback failed: ROLLBACK failed at dbirollbackte

Re: connections are keeping inceresing

I would guess that your scripting library is not closing your connections for you as your variables go out of scope. Each database access library (PHP, DBI, ADO, etc) has its own command to manually close a connection. I suggest you review your code and make sure that you manually close each co

Re: Recovering table structures. [recovered]

On Monday 16 August 2004 11:05, Duncan Hill might have typed: > Had to rebuild my laptop this weekend. Made sure to make a backup copy > of /var/lib/mysql/*. Loaded on the mysql binary tar (as gentoo doesn't > have 4.1.3 in portage yet), and copied my data back across. > > However, even with the

Problems with DBI

Hi Not sure if I should be posting to the DBI list really, but I will try this one too. I'm running suse linux enterprise server 8.2, MySQL 4.0.15-standard-log, DBI 1.32 I get the following error message: DBD::mysql::db rollback failed: ROLLBACK failed at dbirollbacktest.cgi line 49 DBD::mysql:

Re: Mysql-Prozesse lassen sich nicht mehr killen :-(

Hi Daniel, try this: prompt> mysqladmin kill [id],[id] (for usage see mysqladmin --help | less) Cheers, Thomas Spahni On Mon, 16 Aug 2004, Beuter Daniel wrote: > Hallo miteinander dies ist mein erster Thread. > Weil ich nimmer weiter weiß wende ich mich an Euch. > Hab nen Traffich collector

connections are keeping inceresing

Hi, I found my MySQL's connections are keeping increasing recently. I setted the timeout as below: | interactive_timeout | 14400 | | wait_timeout | 14400 | When I run processlist, I found there are a lot of connections over 14400 but the connections are still sleeping. That's

AW: Mysql-Prozesse lassen sich nicht mehr killen :-(

OK Sorry for the german, will do it now in this way ;-) An script like this you said is running already,but the strange thing is that (for explanation-->I have two datacollectors and one mysqlserver with 2 databases 1 and 2), If collector 1 is writing in db1 and collector 2 is starting loading in

Re: MySQL eats 100% CPU on a quad CPU system...

It depends on lots of things. But as an estimate.. Probably you need to add some indexes.. Which type of queries you are using? which database type? Other things.. what about database size? maybe you need more RAM etc.. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator & Web Developer ht

Re: GROUP BY optimization headscratcher

Reaching on this one, but how about reversing your join: FROM T2,T1 Based on your query, it appears you are summarizing all the data in T2 and pulling some "extra" data from T1. Since you are doing a full table scan (using all the records) on T2, you probably want to center your query around

Replication, Windows, Modems

Hi, hoping someone's come across this before: I need to replicate data between two copies of MySQL, both running on Windows XP. The amount of data is tiny - maybe 35k a day as an upper bound. It's basically monitoring data from a remote device. The problem is that neither machine is internet-ena

MySQL eats 100% CPU on a quad CPU system...

Hello people, I'm currently configuring a quad CPU system as a standalone MySQL server. The machine runs nothing except for MySQL and some trivial things like SSH and iptables. A second server acts as a webserver and is connected to this one though an internal LAN connection. Using top or ps, it s

SV: ASP Connection to Mysql fails

Hi Try doing a "response.write conn" after you have made a connection with the DSN that should print out the connection string the DSN is using i hope this help debug the problem Nickolai Paul Stearns wrote: > Actually I can connect from the web server to the DB server using DSN (the odbc tool

Mysql-Prozesse lassen sich nicht mehr killen :-(

Hallo miteinander dies ist mein erster Thread. Weil ich nimmer weiter weiß wende ich mich an Euch. Hab nen Traffich collector der in ne Datenbank auf nem anderen Server schreibt. Nachdem der collector gerade am laden in die Datebank war wurde per cronjob das rotieren des in-use tables angestoßen.

Script to fill a Date base....

Hello How I can fill a Database in MySQL with PHP whit the method POST??? I have a DB in MySQL and I have to fill with PHP, I don't know how I can, I need a Script like this but this is not working I don't why? Please if anyone have a Script that Do the same thing please send to

Best way to construct query for 1M records DB?

Hello all, I am stuck on the best way to proceed in order to make a SQL query efficient and quick searching through a very large (near million and growing) database. I am working with MySQL 3.23.58 and using PHP to construct a dynamic query, based on HTML form input. Please let me know if you nee

Re: Replication blocked

A few brief comments on this one... (1) "Multi-threaded would probably cause thousands of problems" Well, not necessarily. Currently, the slave reads transaction A from the relay log, executes its actions, commits it, then reads transaction B, executes and commits. It wouldn't be unreasonable

SQL_SLAVE_SKIP_COUNTER

Hi, If I run these commands on slave: SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1 SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1 SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1 (3 times and then...) START SLAVE How many counter will be skipped? Is it 3 or just 1? Thank you. Regards, Batara -- MySQL General Mailing Li

Re: Database export

I used to check, optimize and repair tables, tar the database directory and copy it simply. :) For me this is the simpliest way. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator & Web Developer http://www.dalar.net - Original Message - From: "Edd Dawson" <[EMAIL PROTECTED]> To

Database export

I have a 4GB database which i need to move to another hosting company. The source and destination databases are mysql so there is no conversion issue. My question is has anyone any recomendations on which is the best method for doing this. I am aware of doing a database dump and then importing int

Recovering table structures.

Had to rebuild my laptop this weekend. Made sure to make a backup copy of /var/lib/mysql/*. Loaded on the mysql binary tar (as gentoo doesn't have 4.1.3 in portage yet), and copied my data back across. However, even with the innodb files in place, the mysql engine is saying things like: Didn'