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 ROUTINE_NAME='

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 tab

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]

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 wonde

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 m

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] HTTP FTP

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

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. J

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 ar

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 ne

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: 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 tw

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 a