mysql optimization

2008-07-03 Thread Mesut GÜLNAZ
i am looking for mysql 5.0 optimization documents on FreeBSD 6.3-stable. I tried to install mytop to see the running style of the system but p5-DBD-mysql has been failed coz of many bugs. And also read this section http://dev.mysql.com/doc/refman/5.0/en/mysql-benchmarks.html . do you have any

Re: Running 2 versions of MySQL on same server

2008-07-03 Thread Curtis Maurand
Which *n?x distribution are you running? [EMAIL PROTECTED] wrote: No, because I fear that would break the existing customer php apps, which is the whole point of running two versions of MySQL. What I guess I need to know is if php's mysql and mysqli extensions can be made to recognize

Re: Running 2 versions of MySQL on same server

2008-07-03 Thread up
FreeBSD 6.2-STABLE On Thu, 3 Jul 2008, Curtis Maurand wrote: Which *n?x distribution are you running? [EMAIL PROTECTED] wrote: No, because I fear that would break the existing customer php apps, which is the whole point of running two versions of MySQL. What I guess I need to know is

Re: Help with query MySQL and PHP

2008-07-03 Thread axis
This question is strictly related to the mysql query not the php code. I need to either create a new table from the old one or add columns. The thing is don't know how to do it. let me simplify things up: I need a query to retrieve values from the table PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS to a

Exporting MySQL to Oracle

2008-07-03 Thread Arpotu
All, I have a customer who has been on MySQL for about 8 years, but they are moving their business elsewhere. They are moving their database into an Oracle shop, and want me to export their MySQL data into a format that's easily imported into Oracle. Does anyone have experience doing this, or

mysql x64en server 64 bits

2008-07-03 Thread Jaime Fuentes
Hi every body: I've a Server with Intel quad Core processor + Wndows 2003 server R2 64 bits, I'm trying to install a myql 5.1 x64 but it shows me that this installation package is npot supported by this processor type. Contact your vendor. What could be happening ? please help me Urgent.

Re: convertion to utf-8

2008-07-03 Thread Pooly
2008/7/1 Dan Nelson [EMAIL PROTECTED]: In the last episode (Jun 30), Pooly said: 2008/6/30 Dan Nelson [EMAIL PROTECTED]: In the last episode (Jun 29), Pooly said: Hi, I'm trying to convert my tables to UTF8 but I'm getting the following error: ERROR 1062 (23000): Duplicate entry

Re: mysql x64en server 64 bits

2008-07-03 Thread Juan Eduardo Moreno
Hi, Try to download using the mirror called : United States of America [X10 WTI / Seattle, WA] HTTPhttp://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-essential-5.0.51b-winx64.msi/from/http://mirror.x10.com/mirror/mysql/

Create Table from Results of SQL Query

2008-07-03 Thread O. Olson
Hi, I have a SQL Query that has an inner join and it is taking too long to execute. I am thinking of speeding this up by dumping the result into a separate table – as I would be requiring the result of this query many times in the future. I am wondering if someone could show

Re: Create Table from Results of SQL Query

2008-07-03 Thread Dan Nelson
In the last episode (Jul 04), O. Olson said: I have a SQL Query that has an inner join and it is taking too long to execute. I am thinking of speeding this up by dumping the result into a separate table - as I would be requiring the result of this query many times in the future. I am

Re: Create Table from Results of SQL Query

2008-07-03 Thread O. Olson
Thanks Dan for your quick response - it works now. I am new to SQL in general and MySQL in particular. O.O. --- Ven 4/7/08, Dan Nelson [EMAIL PROTECTED] ha scritto: Da: Dan Nelson [EMAIL PROTECTED] Oggetto: Re: Create Table from Results of SQL Query A: O. Olson [EMAIL PROTECTED] Cc:

Re: Help with query MySQL and PHP

2008-07-03 Thread Ananda Kumar
you can do some thing like this. create table new_table(id int, hair varchar(50),eyes varchar(50)) select column1,column2,...from old_table; On 7/3/08, axis [EMAIL PROTECTED] wrote: This question is strictly related to the mysql query not the php code. I need to either create a new table

Why did the procedure spend so much time to analyze?

2008-07-03 Thread Moon's Father
When my database machine's load is too high,the procedure spend more much time than normal use. Here is my mysqldumpslow 's result. Count: 5 Time=6.60s (33s) Lock=0.00s (0s) Rows=1.0 (5), [EMAIL PROTECTED] SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA='site' AND