Setting root password, causing problems.

Hello all! I wanted to discuss a problem I am having with setting up MySQL. I noticed that my root password isn't set. When i try to set it via phpMyAdmin, MySQL doesn't recognize my databases, and denies all connections. Now I've tried setting the password via SSH by accessing the MySQL prom

Re: 5.0.1 vs 5.0.15: view performance

Thanks a lot Shawn: After adding index, it's amazingly faster(< 0.15 sec, was > 16 min !). I thought index columns would be necessary only for tables have 10,000 rows or more but I was so wrong. address_id, association_id and unit_id are PKs for tables Address, Address_Association and Enterpr

Re: run mysqld-nt.exe in background

wang shuming <[EMAIL PROTECTED]> wrote on 10/31/2005 01:11:06 AM: > Hi, > How could run mysqld-nt.exe in background on win2000/XP, not as a service of > windows. > mysqld-nt.exe --console alway show a dos/ text window . > Regards! > Shuming Wang > Xtech Company limited > Room 17G,17/F,Plaza 2, Ti

run mysqld-nt.exe in background

Hi, How could run mysqld-nt.exe in background on win2000/XP, not as a service of windows. mysqld-nt.exe --console alway show a dos/ text window . Regards! Shuming Wang Xtech Company limited Room 17G,17/F,Plaza 2, Tiancheng Building,No 96 Longkouxi Road, Tianhe Guangzhou,Guangdong,China http://www.x

Re: 5.0.1 vs 5.0.15: view performance

As I suspected, you have no indexes. You didn't even define a primary key (PK). For each table, decide which column or combination of columns you can use to uniquely identify each row. Make that your PRIMARY KEY for each table. For other columns or combinations of columns you frequently use in

Re: Active user sessions

On 31/10/2005 3:43 p.m., Cabbar Duzayak wrote: Hi, Is there a way of listing all the active db sessions and their IP addresses and/or db user names? Something like v$session in oracle? Thanks... SHOW PROCESSLIST; -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: 5.0.1 vs 5.0.15: view performance

Thanks Shawn for the help: The same query took 2min less than before on 5.0.15 after using inner join. Is what you ask: mysql> show create table address\G; *** 1. row *** Table: address Create Table: CREATE TABLE `address` ( `city` varchar(4

Active user sessions

Hi, Is there a way of listing all the active db sessions and their IP addresses and/or db user names? Something like v$session in oracle? Thanks... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 5.0.1 vs 5.0.15: view performance

You just identified the reason this is SO slow. You seem to have no indexes. Can you post the results of SHOW CREATE TABLE address_association\G SHOW CREATE TABLE address\G SHOW CREATE TABLE enterprise_unit\G That will let me know exactly what is and isn't already indexed. Thanks! Shawn Green D

Re: 5.0.1 vs 5.0.15: view performance

Thanks SGreen's help. I don't know much about how to use the result of 'Explain' but here it is mysql> explain -> select t0.association_id -> , t0.property_dict as asso_property -> , t0.status_code as asso_status_code -> , t0.flag as asso_flag ->

Re: 5.0.1 vs 5.0.15: view performance

At 15:53 -0500 10/30/05, [EMAIL PROTECTED] wrote: "YL" <[EMAIL PROTECTED]> wrote on 10/30/2005 10:24:24 AM: Dear list, I need some inputs/help on my finding below: 5.0.15 make my view (below) almost useless compare with 5.0.1-alpha: with the same data set, 5.0.15 took 18min but 5.0.1 took

Re: mysql_library_init()

At 10:23 -0500 10/30/05, Bruce Martin wrote: I noticed my client crashes when I try to connect to MySQL 5 server. My client was written against the MySQL 4 C API's. So I looked at the new Docs for MySQL 5 C API's and noticed a new function, mysql_library_init(). I see it has 3 parameters. int

FW: What development environment?

Hello, I am a website designer and am committed to learning how to create database driven websites. Currently I am thinking about using php with MySql, but was wondering if there were any more compelling development environments such as visual studio.net, asp, and or java. Based on the experience

Re: 5.0.1 vs 5.0.15: view performance

"YL" <[EMAIL PROTECTED]> wrote on 10/30/2005 10:24:24 AM: > Dear list, I need some inputs/help on my finding below: > > 5.0.15 make my view (below) almost useless compare with 5.0.1-alpha: > > with the same data set, 5.0.15 took 18min but 5.0.1 took 6.3sec to get > the result: > mysql>select cou

5.0.1 vs 5.0.15: view performance

Dear list, I need some inputs/help on my finding below: 5.0.15 make my view (below) almost useless compare with 5.0.1-alpha: with the same data set, 5.0.15 took 18min but 5.0.1 took 6.3sec to get the result: mysql>select count(1) from unit_address; +--+ | count(1) | +--+ | 143

mysql_library_init()

I noticed my client crashes when I try to connect to MySQL 5 server. My client was written against the MySQL 4 C API's. So I looked at the new Docs for MySQL 5 C API's and noticed a new function, mysql_library_init(). I see it has 3 parameters. int mysql_library_init(int argc, char **argv, char

Permissions for the install

What should the permissions be for the MySQL 5 install on Mac OS X. By default it was Owner = System Group = wheel. Could someone give me a list of directories and what owner:group settings I should have? Bruce Martin The Martin Solution PO Box 644 Delaware Water Gap, PA (570) 421-0670 [EMAI