Dave
[ mysql query]
> when I installed mysql 3.23.43 it instructed me to be sure to add a password with
>the following results-
> :
> seaport2:/# /usr/mysql/bin/mysqladmin -u root -p password 'new-password'
> Enter password:
> /usr/mysql/bin/mysqladmin: connect to server at 'localhost' failed
Amit,
> I am trying to run the following query:-
>
> select red,green,blue from colorchanger where
> colorcode = select value from jobattributekit where
> attributekit = "Color" and jobnumber =
> "28200124RB4-001" and scenario="JN75K";
It doesn't support subselects. It's having a problem with
when I installed mysql 3.23.43 it instructed me to be sure to add a password with the
following results-
:
seaport2:/# /usr/mysql/bin/mysqladmin -u root -p password 'new-password'
Enter password:
/usr/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'r
Yuri,
- Original Message -
From: "Yuri" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, August 17, 2002 1:41 AM
Subject: InnoDB on FreeBSD-Alpha problem
> Anyone i running MySQL with InnoDB
> on FreeBSD-Alpha?
>
> I get the mysqld compiling/running
> ok. DB dump i
Hi all
Does mysql support simple joins?
I am trying to run the following query:-
select red,green,blue from colorchanger where
colorcode = select value from jobattributekit where
attributekit = "Color" and jobnumber =
"28200124RB4-001" and scenario="JN75K";
ColorChanger Table:-
ColorCode Color
In the last episode (Aug 16), Fr. Robert Bower said:
> Is it a good idea to use an auto increment field as a primary key in mysql?
> I know in some products like paradox it is a bad idea because of possible
> corruption problems down the road?
If you get corrupt databases, don't blame the primary
At 09:59 PM 8/16/2002, you wrote:
>Hi guys,
>
>Just an FYI, We've finally decided to license out our logo to
>CafePress.com
>with the MySQL Developer logo. You can buy shirts, mugs, tote bags and
>more
>If you have a chance please check it out. Here is the link
>
> http://www.cafeshops.com/cp/sto
Father,
[ mysql, query ]
> Is it a good idea to use an auto increment field as a primary key in mysql?
> I know in some products like paradox it is a bad idea because of possible
> corruption problems down the road?
I don't believe there would be any problems in the latest versions of
MySQL; o
> How do I uninstall mySQL?
MSWindows or *NIX? Which one?
(And have you searched the archives? I think I've seen this question
answered before, perhaps depending on your OS and version.)
--
Joel Rees <[EMAIL PROTECTED]>
-
Be
Is it a good idea to use an auto increment field as a primary key in mysql?
I know in some products like paradox it is a bad idea because of possible
corruption problems down the road?
Thanks
In Christ,
Father Robert
St. Nectarios Orthodox Church
[EMAIL PROTECTED]
http://www.stnectarios.org
Fo
Hi guys,
Just an FYI, We've finally decided to license out our logo to
CafePress.com
with the MySQL Developer logo. You can buy shirts, mugs, tote bags and
more
If you have a chance please check it out. Here is the link
http://www.cafeshops.com/cp/store.aspx?s=mysqldeveloper.0
P.S. Sorry in a
I'd like to thank everyone for giving such helpful and detailed
responses;
it's the sort of thing that shows me how good the support here can be!
I did want to address some things that may not have been clear enough
in my original message. When I said "not speed" I didn't mean that speed
wasn't
Adam,
[ mysql, query ]
> However, you can do it manually (I think) by playing around with both
> the order of the where clause and the order of the join clause
Yes.
> Also, MySQL has a really wimpy default configuration (I can't figure out
> why). Here is my /etc/my.cnf (I don't know what th
In the last episode (Aug 17), delz said:
> I'm using phpmyadmin to create database on Mysql server. I want my
> idx to start at 1800 then implement auto increment. How do i do it
> using phpmyadmin?
send the following command:
ALTER TABLE mytable AUTO_INCREMENT = 1700;
In general, phpmyadmin qu
Hi All,
Good day !!!
I'm using phpmyadmin to create database on Mysql server. I want my idx to
start at 1800 then implement auto increment. How do i do it using
phpmyadmin?
Regards,
Delz,
-
Before posting, please check:
h
Hi,
I deleted a db I didn't mean to. I am using mysql 4.0.1 Alpha and some
innodb and some myisam tables.
I have the log files I need to restore my data since I have been running
since the last backup with binlog enabled in my.cnf.
The problem is that mysqlbinlog shows some log files, but oth
Lo everyone,
I've implemented replication on my MySQL Server... The master is mysql 3.23
(FreeBSD Ports), and my one and only slave is mysql 3.23 (Win32). I added
the slave so that I can have a hardcopy / backup database in the event that
I have a data loss on the master.
This is all very well
Thanks alot!
-James
-Original Message-
From: Oscar Rylin [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 3:05 PM
To: 'James Kelty'; [EMAIL PROTECTED]
Subject: RE: Server Error
http://www.geocrawler.com/archives/3/8/2002/6/0/9054036/
/ Oscar Rylin
-Original Message-
F
Course, you could just be v. nice to me - I made it into separate pages in 2
frames for much the same reason. :-)
donna
( v. 3.23.34)
On Friday 16 August 2002 9:21 pm, Frank Shute wrote:
> I'm using 3.23.51 and I wondered if the manual was available as
> separate pages of html in a tarball.
>
>
At 08:40 AM 8/14/2002, you wrote:
>I am running a website which generates around 100,000 pageviews a day and I
>am wondering if I stop using persistent conections to the MySQL database and
>use
>normal open and close conections this would reduce the load onto my server?
>
>Most conections are eith
http://www.geocrawler.com/archives/3/8/2002/6/0/9054036/
/ Oscar Rylin
-Original Message-
From: James Kelty [mailto:[EMAIL PROTECTED]]
Sent: den 16 augusti 2002 22:57
To: [EMAIL PROTECTED]
Subject: Server Error
Hello,
Does anyone know, off the top of their head, what server_errno=1159
A simple query in MySQL 4 that gets a count from 3 inner joined tables:
select count(*) as C from quotes q inner join articles a using (article_id)
inner join media m using (media_id)
article_id and media_id are int(11), and are the primary keys for their
respective tables. When used as foreig
The explain command is still a little confusing new to me, but... does this
> ;tempsap;ALL;10019;
... not mean that MySQL is not recognizing the indexes on the tempsap -
AdminProducer join?
>
> -Original Message-
> From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
> Sent: Friday, A
How do I get rid of the MySql column in Welcome to phpMyAdmin 2.2.6 page?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Take a look at MyODBC...
.mark
> -Original Message-
> From: Oladejo, Tokunboh [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 16, 2002 10:48 AM
> To: [EMAIL PROTECTED]
> Subject: Access to MySQL
>
>
> Hi All,
>
> Does anyone knows of any easy way/short cut of exporting
> Microsoft
Anyone i running MySQL with InnoDB
on FreeBSD-Alpha?
I get the mysqld compiling/running
ok. DB dump is restored ok locally.
Locally everything wirks. But it
crashes on the incoming network connection.
unaligned access: va=0x11fff784 pc=.
Anyone knows the solution?
Thanx,
Yuri.
---
If your table(s) are already set to comply with MySQL's much stricter
formatting standards (e.g., spaces in field names, etc), then you can simply
create an ODBC connection and "export" your table to the MySQL database.
That does not always work, and does not always work well. But it is pretty
sim
Hi,
We have a MySQL+InnoDB server on Linux-Debian as ISP mail solution in conjunction
with Postfix and DBmail and a Webmail in PHP/MySQL. The mail database is now 4.8Gb
size for about 210 users on IMAP and POP3. The database have to grow to more than
1000 or perhaps 2000 users.
We must in a next
mySQL,
How do I uninstall mySQL?
Scott
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]
ok fixed thoes every little bit helps... I hope.
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 1:00 PM
To: Mary Stickney; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
I also noticed the field where you make the jo
This solution worked really well for me:
www.cynergi.net/exportsql/
Donna
On Friday 16 August 2002 6:48 pm, Oladejo, Tokunboh wrote:
> Hi All,
>
> Does anyone knows of any easy way/short cut of exporting Microsoft access
> tables into MySql database.
>
> Thanx
> All
>
>
Hello,
Does anyone know, off the top of their head, what server_errno=1159 on a
SLAVE means? Replication is working, but I just want to know what that is.
Thanks.
-James
sql query
James Kelty
Director of Operations
Everbase Systems, LLC
624 A Street
Ashland, OR 97520
[EMAIL PROTECTED]
541.488
You can index fields with nulls. You can't make into a primary key, that's
all.
> -Original Message-
> From: Mary Stickney [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 16, 2002 12:38 PM
> To: Jocelyn Fournier; Mark Matthews; [EMAIL PROTECTED]
> Subject: RE: MySQL vs. Oracle (not spee
Apparently I had list File permissions with my user. Thanks anyway.
-James
-Original Message-
From: James Kelty [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 11:06 AM
To: [EMAIL PROTECTED]
Subject: Replication Problem
Hello,
I have this replication problem. I am getting thi
I'm sorry, but are you and I reading the same thread here? :)
> -Original Message-
> From: Serge Paquin [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 16, 2002 12:01 PM
> To: Mark Matthews
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: MySQL vs. Oracle (not speed)
>
>
> I
I'm using 3.23.51 and I wondered if the manual was available as
separate pages of html in a tarball.
The manual as shipped is a single page and as this machine's dog slow
and takes an age to jump from one part of the manual to another,
I thought separate pages might improve matters.
I can only f
for reports only
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 2:14 PM
To: Mary Stickney; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
...in this case...is very "sad".
You use this query to generate repo
SELECT * INTO mysql_table IN ""
[ODBC;DSN=mysql_dsn;SERVER=localhost;UID=root;PWD=]
FROM access_table
You need myODBC and execute this in Access. Respect the double empty quotes.
- Original Message -
From: "Oladejo, Tokunboh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, Augu
...in this case...is very "sad".
You use this query to generate report or it's for usually work ?
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original M
Hi,
Usually Network Adapter doesn't make this things(Hardware and Software
CRC).I think you should check what happened with the "query" string.When you
"hang" the error make a dump of memory and see where is "broke" your array
of char.
Regards,
Gelu
__
I don't have a choice as to what database I use I WISH I did
and I didnt design the tables, I inherited them
BUT I can do SOME redesign, but only by creating new tables.
I have to leave all the old tables as is , for the old stuff.
see my hands are tied behind my back.
-Orig
On Friday 16 August 2002 12:43 pm, Brian Moon wrote:
> No, it should be and is scanning through the 500,000+ rows that meet the
> key of (approved, datestamp). The table has 1M+ in it. My question is, how
> can it be faster? Can it not be faster? Is MySQL on my size server just
> not going to h
Mary,
you could try downloading MySQL-Max-3.23.52 for Windows and converting your
tables to the InnoDB format.
Your tables maybe take some 500 MB of space in InnoDB. If you have a
reasonably big Windows server with > 500 MB RAM, they will fit completely in
the buffer pool if you configure it big
Regarding your testing... did you test many concurrent processes or
concurrent multi-user access? If you need concurrent multi-user access for
an OLTP app then you should test it.
To this end I developed a Perl routine which launched concurrent sessions in
the background. I could adjust the numbe
Hi Mary,
My opinion:
MySQL forums are open to every one to said about him MySQL
problems,experience... etc.From performance point of view(slow query), 90 %
from the people which was posted on this forums , has problem with Database
and Table design.Comparing RDBMS it's not quite fairly because ev
> There is at least one reason, which is that persistent connections cause
> the server to hold open connection slots even the connection isn't
actively
> being used at the moment.
But isn't this really just a failure of the connection pooling mechanism? If
you have a connection pooling program
it was a limitation of the DBTOOLS table manager... I am indexing right now
using alter table...
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 1:08 PM
To: Mary Stickney
Cc: Jocelyn Fournier; Mark Matthews; [EMAIL PROTECTED]
Subject: Re: MySQ
no I am using myisam it was just a limitation of DBTOOLS
I am getting it done using alter table
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Van
Sent: Friday, August 16, 2002 1:06 PM
To: Mary Stickney
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL
In the last episode (Aug 16), Randall Severy said:
> > It is only libmysqld that you're having problems with? I have
> > built mysql (the regular separate client and server) on three Tru64
> > systems with no problems. What version of Tru64?
>
> Yes, it's only libmysqld that I can't get to
> I profiled my PHP app with a debugger
A single session and a few queries does not make a very good test. The
reason for persistent connections is to scale web apps to handle intense
multi-user activity like 1000 queries per second or 100's or even 1000's of
concurrent database connections. Do a
Hello,
I have this replication problem. I am getting this error on the slave:
020816 16:30:49 Slave: Failed reading log event, reconnecting to retry, log
'FIRST' position 4
020816 16:30:49 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4
02
In the last episode (Aug 16), Mary Stickney said:
> looks to me like I can only make indexes on fields that are not
> null... this one is not , not null
Indexing of NULL columns went into Mysql 3.23.2 (Dec 16, 2000).
With tables this large, you might also want to raise some of the cache
paramete
Mary:
You can index fields containing NULL values in MyISAM tables, but not ISAM
tables. If you're using ISAM tables, this might explain your performance
issues. There are also other more featured table types, but MyISAM is probably
going to yield the most performance in your application.
Van
Hi All,
Does anyone knows of any easy way/short cut of exporting Microsoft access
tables into MySql database.
Thanx
All
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
I also noticed the field where you make the join are not exactly of the same
type :
e.g :
AdminHierarchy.CoverageID=AdminCoverage.CoverageID
in adminHierarchy :
CoverageID varchar(15) NOT NULL
in admincoverage :
CoverageID varchar(10) NOT NULL
AdminCoverage.ProductID=AdminProduct.ProductID
Hello.
On Fri 2002-08-16 at 10:49:00 -0500, [EMAIL PROTECTED] wrote:
>
> yes I do
But they are not listed in the "Possible Keys" column, which they
should. MySQL cannot use them for some reason.
I had a look at the posting with the CREATE TABLEs and it seems the
reason is that the columns
Hello!
I have a problem when I trying to start mysqld (as a root, under RH 7.2).
Allegedly I don't have a rights to run this program...
What I have to do to run mysqld without rebooting system?
Best regards:
Krzychu
---
Super promocyjna oferta dla mieszkancow Krakowa
http://www.promocj
Me again
I found a work around to my problem:
select country, count(distinct client_name, client_address, etc..) clients
from addresses group by country
But I still don't understand why the below would not work. I downloaded the
3.# version of the OBDC but that didn't seem to help.
Help.
T
On Fri, 16 Aug 2002, Victoria Reznichenko wrote:
> K> do someone know what should be the problem?
> K> Server is Win2K and has latest mysql server installed client is the one
> K> from RedHat 7.3 (3.23.49) (=`mysql_config --version`)
>
>
> Do you always get this error or you got it just once?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 3.23.52, the world's most popular Open Source Database, has been
released and is now available in source and binary form for a number of
platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
This is a bu
Mary Stickney wrote:
> thanks Serge..
>
> incidentally my very first post to the list contained my query , and is the
> reason I joined this list in the first place.
> This 3 year sales report has been running for over 24 hours now. this is
> unacceptable, since they also wanbt a 5 year
> one and
I believe MySQL doesn't do a lot of the optimizations that MSSQL does.
However, you can do it manually (I think) by playing around with both
the order of the where clause and the order of the join clause
The where clauses go in order, so you want to use the first part of the
where clause to get
Our experience has been totally the opposite.
We recently ported a Delphi application from MS-SQL to MySQL.
The MySQL server was a less powerful box than MS-SQL was running on.
I will not go into great detail because some of the software is proprietary
and we make $$$ providing the service.
No, it should be and is scanning through the 500,000+ rows that meet the key
of (approved, datestamp). The table has 1M+ in it. My question is, how can
it be faster? Can it not be faster? Is MySQL on my size server just not
going to handle scanning 500K rows? That seems like a low number to ha
Hi!
- Original Message -
From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, August 16, 2002 7:16 PM
Subject: Re: MySQL vs. Oracle (not speed)
> Hi,
>
> Does the MySQL-4.1 development tree publicly available (if so, on w
You can if you have a MySQL version > 3.23.2, and are using the MyISAM
handler.
(http://www.mysql.com/doc/en/CREATE_INDEX.html)
What version of MySQL do you use ??
- Original Message -
From: "Mary Stickney" <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>; "Mark Matthews"
looks to me like I can only make indexes on fields that are not null...
this one is not , not null
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 11:34 AM
To: Mary Stickney; Mark Matthews; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracl
On Fri, 16 Aug 2002, Brian Moon wrote:
> I ran into a problem when the queries started to call for 500,000+ rows.
> The query would not return. Here is the query and explain:
>
> select SQL_NO_CACHE id from single_table where approved='Y' AND datestamp >=
> '2001-08-16 00:00:00' AND ( ( author
At 08:40 AM 8/14/2002, you wrote:
>I am running a website which generates around 100,000 pageviews a day and I
>am wondering if I stop using persistent conections to the MySQL database and
>use
>normal open and close conections this would reduce the load onto my server?
>
>Most conections are eith
Hi,
I see you do an order by on AdminHierarchy.WritingAgentSlot but this column
is not indexed.
Please tell me if an index on this column improve the speed of the query a
bit.
Regards,
Jocelyn
- Original Message -
From: "Mary Stickney" <[EMAIL PROTECTED]>
To: "Mary Stickney" <[EMAIL PR
incidentaly... Primary keys cant not be made on most of these tables due to
the fact that
the farther back in time you got the more screwed up the data is...
Fields have been added and they did not have the info to fill in the
blanks...
-Original Message-
From: Mary Stickney [mailto:[EM
thanks Serge..
incidentally my very first post to the list contained my query , and is the
reason I joined this list in the first place.
This 3 year sales report has been running for over 24 hours now. this is
unacceptable, since they also wanbt a 5 year
one and I am sure that will take 5 years
I did the first day I joined the list and again today
-Original Message-
From: John Griffin [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 10:09 AM
To: [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
Hi Mary,
It's not a question of approval. If you are having pro
Hi,
Does the MySQL-4.1 development tree publicly available (if so, on which port
??)
Regards,
Jocelyn
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 16, 2002 3:42 PM
Subject: Re: MySQL vs. Oracle (not speed)
> Hi!
>
>
> I te
I am getting the taxid's I need from here so as not to try ane merge the
entire table..
and there are 833...
CREATE TABLE tempsap (
TempSapRecNum mediumint(9) NOT NULL auto_increment,
StatusCode char(3) ,
Company varchar(10) ,
FirstYear varchar(4) ,
I think this is a touch on the negative side. I'm sure many people get soured on
MySQL when they to a post here and get yelled at for not trying hard enough. It
sounds like Mary is having a valid problem. Her query works fast in one database and
slow in the other. Because she did not come o
Could you please send also tempsap ?
Thanks and regards,
Jocelyn
- Original Message -
From: "Mary Stickney" <[EMAIL PROTECTED]>
To: "Mark Matthews" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, August 16, 2002 4:55 PM
Subject: RE: MySQL vs. Oracle (not speed)
> this is a rea
Song,
Friday, August 16, 2002, 12:57:58 AM, you wrote:
S> Well, I am not sure if anyone has experienced the same problem, or if this
S> problem has been documented, but this is what I have noticed:
S> After one of my data table was full, I started to delete old records from
S> the table to allow
Daniel,
Friday, August 16, 2002, 3:19:40 PM, you wrote:
DK> I'm interested in what are the differences between different versions of
DK> libmysql.dll's and libmysql.so's?
Exported functions are different.
DK> And are their versions the same under linux and windows?
DK> Where can I get their he
Krata,
Friday, August 16, 2002, 5:10:20 PM, you wrote:
K> Hi,
K> i am using mysql c api to send some queries to mysql server which is on
K> another computer (100MBit almost next to the client)
K> in my code i am doing this
K> if (mysql_real_query(mysql,query,strlen(query)))
K>
Art,
Thursday, August 15, 2002, 4:53:26 PM, you wrote:
AF> Still could not get it to work so I uninstealled and reinstalled. Will use
AF> the anonymous login etc util I figure out this security system. Is there a
AF> document that explains the password system in laymans terms?
You can find info
John,
Thursday, August 15, 2002, 1:03:58 PM, you wrote:
JS> >Description:
JS> <[root@localhost mysql]# ./bin/mysqladmin version
JS> ./bin/mysqladmin: connect to server at 'localhost' failed
JS> error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock'
JS> (111)'
JS> Ch
yes I do
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 10:37 AM
To: Mary Stickney; Francisco; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Do you have an index on AdminProducer.taxid and on tempsa
Mary Stickney wrote:
> no need to get defensive ...
>
> We did do a timed test.
>
> I am trying to sped up a program that currently take over 12 hours to run...
> I started running it yesterday morning and it is still going. and going and
> going...
Would it be possible for you to send the list
Do you have an index on AdminProducer.taxid and on tempsap.taxid ?
- Original Message -
From: "Mary Stickney" <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>; "Francisco"
<[EMAIL PROTECTED]>; "Elizabeth Bogner" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, August
explian returns this
;table;type;possible_keys;key;key_len;ref;rows;Extra
;table;type;possible_keys;key;key_len;ref;rows;Extra
;AdminCoverage;range;CoverageID,CoverageIdSbc,InitPremDateIndex,CovIdCovIdSb
cIndex,CovIdCovIdSbcInitPremIndex;InitPremDateIndex;3;;315663;where used;
Using temporary; U
Hi,
Which columns are indexed in your table ?
What does EXPLAIN into MySQL return ?
Regards,
Jocelyn
- Original Message -
From: "Mary Stickney" <[EMAIL PROTECTED]>
To: "Francisco" <[EMAIL PROTECTED]>; "Elizabeth Bogner"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, August 16,
Hi, Victoria:
The version installed is mysql-3.23.51. I don't know why my previous
operation did not succeed. However, I now grant the permissions through
"insert into db values (...) and succeed.
THank you very much.
Duo
>From: Victoria Reznichenko <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>
Hi Mary,
It's not a question of approval. If you are having problems with MySQL there is an
entire list of people who are willing to offer support for free. Post your query and
some table information and let's see if we can clear up your performance issues.
John Griffin
-Original Message-
speed is of the utmost importance ,
I can't have a client run a report and wait 2 days for it to finish.
-Original Message-
From: Aron Pilhofer [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:46 AM
To: Mary Stickney; [EMAIL PROTECTED]; Francisco; Elizabeth Bogner;
[EMAIL PROT
it has been sent to the list but here it is again
I did a 4 table join , drwing 3 years of sales data
table one 6.5 million records --- AdminHierarchy
table two 1.5 million records AdminCoverage
table three 10191 records --- AdminProcuder
table four 19823 records --- AdminP
I did send in my query the day I joined this list and the table
structures.
I just did again...
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:47 AM
To: Mary Stickney
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
this is a read only datawarehouse database we refresh monthly from the
antiquated mainframe we have
ok here are the tables
Adminhierarchy 6.5 million records
CREATE TABLE adminhierarchy (
Source char(2) NOT NULL ,
WritingAgentID varchar(15) NOT NULL ,
CoverageID
Try the script oracledump.pl at this link. I used it to export my
Oracle data to Mysql and it worked great. Some variables to modify at
the top of the script, but that's it.
http://mirrors.sunsite.dk/mysql/Downloads/Contrib/oracledump
Stanley G. Martin
Sprint - ISS Enterprise App/Decision Supp
Mary Stickney wrote:
> What exactly is Trolling
>
>
> I find MYSQL to be slow , sorry if that doesn't met with your approval.
But you don't give examples.
I've found MS-SQL to be slow at times, especially when used from JDBC,
but I don't make crack comments about it newsgroups without bac
I did crash the MYSQL server the other day...
I am currently looping thru and getting the sales agent by agent.
I tried to do the query for all 804 agents at one time and after an hour and
a 1/2 and still not being done
decided against doing it that way.
next I decided I should have a table al
Well, I meant this to be off-list (thus the next message) because I don't
want to start a round of M$ bashing, blah, blah...
But since I blew it already, I don't mean to sound harsh or defensive,
because, frankly, I don't have a vested interest one way or the other which
db you use. And I'm not d
no need to get defensive ...
We did do a timed test.
I am trying to sped up a program that currently take over 12 hours to run...
I started running it yesterday morning and it is still going. and going and
going...
-Original Message-
From: Aron Pilhofer [mailto:[EMAIL PROTECTED]]
S
Hello,
I have two different tables with similar fields (id, name, profession,
hobbies) Some people might be listed in both tables. I need a write query
to select
count(*) from the tables group by name... i'd like it get something like
this:
Joe Smith. total 5 records . 3 records from ta
The "Open Source" argument went down well with my management. Of course,
both Oracle and MySQL have full support teams, and should fix any bugs in
their databases promptly - and, so far as I know, they do. However, we have
had problems with (other) large companies in the past when we find bugs in
1 - 100 of 153 matches
Mail list logo
