Hi!
InnoDB is a table type in MySQL which supports transactions, row level
locking, foreign keys, and a non-free hot online backup tool.
InnoDB is included in MySQL-Max-3.23 and MySQL-4.0 distributions.
From now on, the feature set of InnoDB in the 3.23 branch will be frozen.
New features are
Hi!
Replication between MyISAM and and InnoDB tables should work, and actually
many people use it.
The only essential limitation in replication with InnoDB is that LOAD TABLE
FROM MASTER does not work. The workaround is to ALTER the table to MyISAM,
do LOAD TABLE..., and ALTER back.
Best
I've had a similar problem before. My workaround was to read the image into a string,
then escape the string (replace ' with \' etc). Then use an INSERT statement to put it
in the database. That works fine wih any sized image.
Stephan.
-Original Message-
From: [EMAIL PROTECTED]
Good morning !
i've searched various lists trying to find any hints to solve following
error after make command:
libmysql.c: In function `mysql_real_connect':
libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
libmysql.c:1325: too few arguments to
Dear Sir/madam,
we are able to connect Mysql database using JSP in Linux RedHat-6.2
OS (with out using user and password).
when we are trying to connect using user and password it was not able to
connect.
We wrote code like this
String DBUrl =
Hello!
I can't find a way to turn off buzzer (PC speaker) in mysql console. Am
I missing something or is it impossible and I should report user
interface bug to bugs mailing list?
mysql console version : 11.18 distribution 3.23.51
System: Windows 2000
Max
Max,
What's wrong with your PC speaker in mysql console?!
I am using the same version and have no problem with it.
Best regards,
Mikhail.
- Original Message -
From: Max Morawski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 10:36 AM
Subject: mysql console
Mikhail Entaltsev wrote:
What's wrong with your PC speaker in mysql console?!
I am using the same version and have no problem with it.
It's making loud noise on each error. It is *extremely* annoying.
Max
-
Before
Hello,
I have a field named rights (varchar[9])
it contains some records like wrxwrxwrx or wr-w--w-x
I'd like to find all the records that contains this : wr??
That's why I did this query : SELECT * FROM table WHERE rights LIKE
'wr??'
and it doesn't work !
It extension, a simple
Max,
It's making loud noise on each error. It is *extremely* annoying.
Try to use these ways:
1. -s, --silent option in mysql console. I don't know what does it mean (in
doculmentation I found only Be more silent.), but may be it will help you.
2. Generally, you can change settings of PC
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Mikhail Entaltsev wrote:
It's making loud noise on each error. It is *extremely* annoying.
Try to use these ways:
1. -s, --silent option in mysql console. I don't know what does it mean (in
doculmentation I found only Be more silent.), but may be it will help you.
No change.
2.
tristan Israel wrote:
Hello,
I have a field named rights (varchar[9])
it contains some records like wrxwrxwrx or wr-w--w-x
I'd like to find all the records that contains this : wr??
That's why I did this query : SELECT * FROM table WHERE rights LIKE
'wr??'
and it doesn't
Max,
2. Generally, you can change settings of PC speaker in OS settings.
No change.
Which OS do you use?
Mikhail.
- Original Message -
From: Max Morawski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 11:00 AM
Subject: Re: mysql console buzzer problem
I'd like to find all the records that contains this : wr??
That's why I did this query : SELECT * FROM table WHERE rights LIKE
'wr??'
Try to use this one:
SELECT * FROM table WHERE rights LIKE 'wr%' (It means everything that
begins from 'wr')
Next point:
'?' - it is not pattern in
Hi All,
I m getting this error (i knew this is very common error)when i try to
insert a record into a table.
---
java.sql.SQLException: Error during query: Unexpected Exception:
java.lang.IllegalArgumentException message given: Packet is
Hi,
You can try with string function substring(),LPAD(),RPAD()...
Please look in documentation at :
6.3.2 String Functions
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
I am wondering if there is any tweaks or better setups of my.cnf or anything
to help increase productivity of my server.
I have a Dual Athlon MP 2000+ with 1gb ram ATA 100 60gb hd and here are some
of my server stats/configs.
FreeBSD 4.6 - Mysql is compiled with LinuxThreads.
Also runs.. Apache,
Max,
Friday, August 16, 2002, 11:36:19 AM, you wrote:
MM I can't find a way to turn off buzzer (PC speaker) in mysql console. Am
MM I missing something or is it impossible and I should report user
MM interface bug to bugs mailing list?
Option --no-beep for mysql command line client is
samuel,
Friday, August 16, 2002, 12:45:36 AM, you wrote:
su please how can i set Sql command on connect to be able to connect to
su mysql.i am a novice.i tried to enter /var/lib/mysql/mysql.sock but still
su couldn't connect.help please. i have tried with both static and
su semi-static files.
Josh,
Friday, August 16, 2002, 12:18:46 AM, you wrote:
JZ is there a way to give certain users rights to create and drop mysql
JZ databases
JZ without being administrators?
JZ I'd like to create a new database every time a user runs my code on a
JZ new set of data.
To create and drop databases
Bill,
Friday, August 16, 2002, 3:59:56 AM, you wrote:
BE Thanks, Victoria. Yes, there is a master.info, and it looks like the
BE culprit. Can I just delete it?
Yup ..
BE Any idea where it came from?To the best of my knowledge, the server was
BE never started as a slave.
I don't know
say there are 2 servers A and B. I have configures replication so that
server A is a master and server B is a slave. so sometimes after
incorrect query replication stops and the error log indicates that I
should correct bin log. I dont know how. any help would be great.
Regards,
--
George
hi all
when i connect to my mysql database server using
mysql -h a.b.c.d -u xyz -pmypass
It logs on and it's fine and in mysql shell when i do use mysql then it is
allowing me to acess the mysql default mysql database. i dunn't want this.
when i type use mysql then it sud say access
Expensive colleagues, all good! I am here in the Brazil! I need an aid to
have access the MySql saw net local! Or either, I have the MySql in a
machine and want to share the bank with my fellow workers, Has that to be he
saw MyOdbc? Command of line? I am making in Java and using the JDBC.
Hi Elizabeth,
The first question I would ask why don't you want Oracle? If you can't come up with a
good business reason why your company shouldn't go with Oracle I would say you have
already lost the battle. The second question is who is making the purchasing decision?
If it's middle
Hi,
I'm interested in what are the differences between different versions of
libmysql.dll's and libmysql.so's?
And are their versions the same under linux and windows?
Where can I get their header files in C or Object Pascal?
Thanks,
Daniel
Expensive colleagues, all good! I am here in the Brazil! I need an aid to
have access the MySql saw net local! Or either, I have the MySql in a
machine and want to share the bank with my fellow workers, Has that to be he
saw MyOdbc? Command of line? I am making in Java and using the JDBC.
Help..
Replication is not working.. not sure why..
ON MASTER:
/etc/my.cnf
[mysqld]
datadir=/db/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
log-bin=mylog
server-id=1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
It doesn't suport alot of differnt things
it dosent have store procedures , dosent have a complete SQL command set...
I am using it becasue I am being forced to...
-Original Message-
From: Elizabeth Bogner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 9:25 PM
To:
Victoria Reznichenko wrote:
Max,
Friday, August 16, 2002, 11:36:19 AM, you wrote:
MM I can't find a way to turn off buzzer (PC speaker) in mysql console. Am
MM I missing something or is it impossible and I should report user
MM interface bug to bugs mailing list?
Option --no-beep for mysql
I don't know if you cut and pasted your code, if you did then try this.
$qid = mysql_query(SELECT * FROM 1_nodedata WHERE id = .$edit_id.;);
$tr = mysql_num_rows ($qid);
echo $tr;
That should give us a count of the rows and it will make sure our query is
returning something.
-Original
Hi John,
Yes, BSDi 4.1 does indeed have serious threading problems. There was a
patch issued that would stop the crashing, but I don't remeber the number.
I am now installing 4.3. If you are running a server that will be available
on the internet I highly advise upgrading to 4.2 or 4.3 with
We've been using Oracle, Sybase, MS SQL, DB2 and even other databases in
our company, and we've decided to go with - mainly - MySQL. We didn't
really have a hard time convincing the management about this decision,
since we produced a whole Open Source-strategy at the same time,
giving some
Hi!
- Original Message -
From: John Griffin [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, August 16, 2002 3:29 PM
Subject: RE: MySQL vs. Oracle (not speed)
Hi Elizabeth,
The first question I would ask why don't you want Oracle? If you can't
come up with a good
Let's see if I can convince your managers:
1. Support
Oracle offers support, this is true, but if you want pay for support, you can
buy it from MySQL AB. They have MySQL for free and they also have a licence
you can buy and ask for support. If you want to keep free, this list is a
good point
Hi
I am new to the world of databases. We will be installing an Oracle9i
database shortly as the backend for our current financial package. We
hope to replace it with MySQL in the future. The data held in the
database will be predominantly of text-type. However, some data fields
will be binary.
describe user.
Paul Maine wrote:
I have a column defined in a table as type date. I desire to include a date
comparison in the WHERE clause of the following statement. The following
statement is not working correctly, I suspect that there is a formatting
issue. The statement returns true even
Hi,
I am beging using MySQL for quite a while and it is a
very good choice if you don't really need stored
procedures. MySQL provides a pretty good
implementation of a subset of MySQL-92, performance is
great, it is cross-platform, provides transactions,
and its price... well is free.
Hope it
I have been doing speed tests the same query ran on MYSQL took 45
minutes
on MS-SQL it took 11 minutes..
yes you do get what you pay for
-Original Message-
From: Francisco [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 8:47 AM
To: Mary Stickney; Elizabeth
From: Francois Joubert [mailto:[EMAIL PROTECTED]]
Sent: 16 August 2002 14:46
To: MySQL List
Subject: Migrating Oracle To MySQL
Hi
I am new to the world of databases. We will be installing an Oracle9i
database shortly as the backend for our current financial package. We
hope to replace
Harald,
Thursday, August 15, 2002, 4:02:44 PM, you wrote:
HF I think I've found a bug in the handling of large INSERTs/UPDATEs
HF (MySQL 4.0.2, Intel/Linux).
HF Consider the following:
HF CREATE TABLE IF NOT EXISTS tbl1 (
HF id INT UNSIGNED NOT NULL AUTO_INCREMENT,
HF txt LONGTEXT
duo,
Friday, August 16, 2002, 2:23:52 AM, you wrote:
df Hi friends:
df I try to grant privileges to a user named 'glen' but not succeed. Here is
df the script:
[skip]
df mysql grant all privileges on test.* to 'glen'@'localhost' identified by
df 'tidbs1';
df ERROR 1133: Can't find any
Paul,
Friday, August 16, 2002, 1:19:15 AM, you wrote:
PM I have a column defined in a table as type date. I desire to include a date
PM comparison in the WHERE clause of the following statement. The following
PM statement is not working correctly, I suspect that there is a formatting
PM issue.
Hi,
i am using mysql c api to send some queries to mysql server which is on
another computer (100MBit almost next to the client)
in my code i am doing this
if (mysql_real_query(mysql,query,strlen(query)))
{
fprintf(stderr,In query : \%s\\n,query);
Mary Stickney wrote:
I have been doing speed tests the same query ran on MYSQL took 45
minutes
on MS-SQL it took 11 minutes..
yes you do get what you pay for
Why not post the queries and the schemas here? My guess is you don't
have something indexed correctly, or are using a
At 09:55 PM 8/15/2002 -0500, Dan Nelson wrote:
You don't want MIT threads; they are a last-resort for when a system
has no native threads library at all.
Dan,
Thanks for the quick response! Also, thanks for the response
several months ago to my earlier plea for help, for some reason I
Hi Mary,
I am not specially against or pro MySQL, Microsoft SQL
Server, Oracle or any other database. Teams make their
choices based on the project needs such as budget (is
your team ready to spend thousands of dollars on
Oracle and marry that corporation forever?),
deployment (do you want your
what query was it may I ask ?
Tom
- Original Message -
From: Mary Stickney [EMAIL PROTECTED]
To: Francisco [EMAIL PROTECTED]; Elizabeth Bogner
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 11:52 PM
Subject: RE: MySQL vs. Oracle (not speed)
I have been doing speed
Not to open a can of worms here, Mary, but I'd love to know exactly how you
got those results, since they basically contradict every known benchmark I
have seen (at least those not funded by M$... this being one:
http://www.eweek.com/article2/0,3959,293,00.asp) as well as every
benchmarking test
What exactly is Trolling
I find MYSQL to be slow , sorry if that doesn't met with your approval.
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:15 AM
To: Mary Stickney; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not
Hi,
i am using mysql c api to send some queries to mysql server which is on
another computer (100MBit almost next to the client)
in my code i am doing this
if (mysql_real_query(mysql,query,strlen(query)))
{
fprintf(stderr,In query : \%s\\n,query);
A problem I have with InnoDB tables, which forced me to use MyISAM tables in
a recent project, is as follows:
(I am running MySQL on Solaris, not that it matters much for this problem.)
With MyISAM tables, I can easily get different databases to reside on
separate physical drives.
The base
DOH! See what happens when I post before having a nice cup of coffee?
My face is red. Never mind. :)
aron
-Original Message-
From: Mary Stickney [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:53 AM
To: Francisco; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: RE: MySQL
I am not for one or the other I just hate to wait
I need speed...
we already have a MS-SQL server , so no more money needs to me spent...
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
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
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
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]]
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
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
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
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
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 ,
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)
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 ---
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
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
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,
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, 2002 4:31 PM
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;
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 16, 2002 5:31 PM
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 the
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
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 Check
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
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 {
K
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
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
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 read only
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
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) ,
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 tested a
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
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
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
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
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 either
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 LIKE
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.
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
[EMAIL
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 which
port
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
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.
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
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 am
-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
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?
well i
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.
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
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 are
1 - 100 of 148 matches
Mail list logo