First of all, my bad -- I forgot to mention that I use MyISAM.
mysql> show table status from example like 'leads'\G
*** 1. row ***
Name: leads
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 1
On Fri, Apr 11, 2008 at 6:47 AM, Ben Clewett <[EMAIL PROTECTED]> wrote:
> A COUNT() forces the system to read every row in order to count them...
That is not strictly the case.
A count(field) can use an index scan rather than a sequential scan,
which may or may not be faster. Also some count(field)
Hi,
Can you please post your query? I also need to know your table type as
different settings effect different table types?
You are right that a SELECT COUNT(*) WHERE field = 'value' should hit
the index, but does depend on your query.
You might also try EXPLAIN before your query, which wi
On Fri, April 11, 2008 06:47, Ben Clewett wrote:
> Are you using MyIsam or InnoDB? Or something else?
>
> In either case the speed to get a COUNT() is largely down to the speed
> if your disks and size of disk caching. A COUNT() forces the system to
> read every row in order to count them, and an
Are you using MyIsam or InnoDB? Or something else?
In either case the speed to get a COUNT() is largely down to the speed
if your disks and size of disk caching. A COUNT() forces the system to
read every row in order to count them, and any large table is probably
larger than your caches.
I
Yes, I did try. The issue was the security level setting on the new DB
server, and not the password stuff. I've upgraded apache, mysql, and php
in the last few weeks, and 3-4 issues became painfully apparent when going
from php4 to php5, so I guess I was operating under similar assumptions
and
Have youtried this yet? While 4.0 client can't connect to a v.5
server unless the passwords have explicitly beewen stored as
old_password, I have never run into an issue connecting a 5.x client
to a 4.0 server.
- michael
On 6/7/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Is it possible t
eroic.
Geoffroy
-Message d'origine-
De : mos [mailto:[EMAIL PROTECTED]
Envoyé : samedi 2 juin 2007 23:49
À : mysql@lists.mysql.com
Cc : [EMAIL PROTECTED]
Objet : RE: MySQL 5.0 creates 100,000 Window handles
Geoffroy,
Thanks for the reply. Of course by now I figured out what
because of
physical resources, especially RAM, and perhaps by-design in OS kernel.
Regards,
Geoffroy
-Message d'origine-
De : Geoffroy Cogniaux [mailto:[EMAIL PROTECTED]
Envoyé : dimanche 27 mai 2007 23:13
À : 'mos'; mysql@lists.mysql.com
Objet : RE: MySQL 5.0 creates 10
007 23:13
À : 'mos'; mysql@lists.mysql.com
Objet : RE: MySQL 5.0 creates 100,000 Window handles
Hi,
Try [EMAIL PROTECTED] instead.
Bye.
Geof.
-Message d'origine-
De : mos [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 25 mai 2007 06:41
À : mysql@lists.mysql.com
Objet : MySQL
Hi,
Try [EMAIL PROTECTED] instead.
Bye.
Geof.
-Message d'origine-
De : mos [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 25 mai 2007 06:41
À : mysql@lists.mysql.com
Objet : MySQL 5.0 creates 100,000 Window handles
I noticed if my program executes a lot of Select statements, Windows XP
w
Don't include the password, let mysql prompt for it. ' ./bin/
mysqladmin -u root password -p '.
Daniel Culver
[EMAIL PROTECTED]
On Jan 17, 2007, at 7:57 PM, Mariella Petrini wrote:
./bin/mysqladmin -u root password '***'
./bin/mysqladmin: connect to server at 'localhost' failed
Hi,
After having compiled (debug and optimized version) of MySQL 5.1.14 on
Itanium-2 using icc, I have run
mysql_install_db --user=...
and started mysqld_safe in both scenarios (debug and optimized). In both
cases mysqld starts without any errors.
Unfortunaly when
hahaha, I see. Thank you very much.
Regards,
Gu Lei
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "åˆóã" <[EMAIL PROTECTED]>;
Sent: Friday, June 09, 2006 11:02 AM
Subject: Re: mysql-5.0/Docs
At 10:45 +0800 6/9/06, å^óã wrote
At 10:45 +0800 6/9/06, åóã wrote:
Thanks a lot.
In MySQL Internals Manual:
"At this moment, internals.xml has over 100
pages of information, including some details
about the formats of MySQL files that you won't
find anywhere else, and a complete description
of the message formats that
sage -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "åˆóã" <[EMAIL PROTECTED]>;
Sent: Friday, June 09, 2006 10:22 AM
Subject: Re: mysql-5.0/Docs
At 9:52 +0800 6/9/06, å^óã wrote:
>Hello:
>
>
>
>In MySQL Internals Manual:
>
>
>
>"With t
At 9:52 +0800 6/9/06, åóã wrote:
Hello:
In MySQL Internals Manual:
"With the BitKeeper downloads, /Docs is nearly
empty. The important files are only present if
you do a regular source-file download, or if you
do a separate 'bk clone' for 'mysqldoc' instead
of 'mysql-5.0' (in which cas
sheeri kritzer wrote:
Hi Amer,
Indeed, the 'func' table in the 'mysql' database has the same
structure that you found in your client database. in your upgrade,
did something go wrong and you did a mysqldump of the mysql database
and reimport? Are you sure you're in the right database? What do
Hi Amer,
Indeed, the 'func' table in the 'mysql' database has the same
structure that you found in your client database. in your upgrade,
did something go wrong and you did a mysqldump of the mysql database
and reimport? Are you sure you're in the right database? What does
describe mysql.func
> Many "big guys" like the one in Scottsdale, AZ, still have MySQL 3.23.
>
> I myself make my SQL 3.23 compatible.
Part of the reasons could be the license change in v4, of course.
MySQL no longer comes for free in many cases.
Martijn Tonies
Database Workbench - development tool for MySQL, a
On 3/8/06, Nicolas Verhaeghe <[EMAIL PROTECTED]> wrote:
> Many "big guys" like the one in Scottsdale, AZ, still have MySQL 3.23.
>
> I myself make my SQL 3.23 compatible.
>
Well, it all depends on what you'll do with the system, if its a
development desktop, a server for commercial stuff, etc. MyS
Many "big guys" like the one in Scottsdale, AZ, still have MySQL 3.23.
I myself make my SQL 3.23 compatible.
Yes, it is too new, and it is sad, because stored procedures will make
our job much easier.
I also program for MS SQL and use SPs extensively for all the good
reasons.
-Original Mess
Zsolt Branyiczky wrote:
Hi,
I installed mysql-essential-5.0.18-win32.msi (under Win XP) in order to
use it with Bugzilla. Since I had some problem with importing old
Bugzilla dumps containing some special hungarian vowels (they are
outside of latin1 characterset), I checked how mysql stores t
On Mon, 2005-12-26 at 09:27 +0800, Chenzhou Cui wrote:
Hi,
Sorry for long delay with reply.
I guess it is similar to
http://bugs.mysql.com/bug.php?id=17229
The problem is basically confirmed and we're now working to find
solution
> Dear Peter,
>
> Thanks very much for your concern. Answers
> Hi! No I haven't tested with the v5 driver yet,
I suggest you do so and keep us updated.
> but I found out that the
> problem is when I use date_format function
>
> If I dont use it the data is returned ok in my app(but with hours, minutes
> etc), but if i do a date_format i get "bytes" on e
s" on each record instance of get
date formated, the column type is datetime(of my table)
Regards!
-Mensaje original-
De: Martijn Tonies [mailto:[EMAIL PROTECTED]
Enviado el: Viernes, 10 de Febrero de 2006 12:51 p.m.
Para: 'Mysql '
Asunto: Re: MySQL 5.0.x and Delphi
Hi,
First of all: you're sending a message with an enormous quote of someone
elses message, this really is "not done" on an e-mail list. Start your own
topic.
> I'm having problems upgrading my database from 4.0.x to 5.0.x, specially
> with date fields
>
> For example with 4.0.x I do: "select s
Hi,
> I have a serius probleam , my backup system see the FK's with "show
> table status like 'tablename'" , and read the Comment column...
> in mysql 4.x works fine... but em 5.x the FK's has cuted
This didn't work "fine" in 4.x at all. The "comments" columns
was being misused to report FKs.
ssage-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 18 January 2006 15:57
To: mysql@lists.mysql.com
Subject: Re: MySQL 5.0 error after upgrade
Hello.
> ALTER TABLE `filos`.`settings` MODIFY COLUMN `IntVal` INTEGER
>CHARACTER SET latin1 COLLATE latin1_general_ci;
This seems like a
Hello.
> ALTER TABLE `filos`.`settings` MODIFY COLUMN `IntVal` INTEGER
>CHARACTER SET latin1 COLLATE latin1_general_ci;
This seems like a bug. MySQL Administrator should not assign character
set to integer columns. See:
http://dev.mysql.com/doc/refman/5.0/en/bug-reports.html
Kerry Frater wrot
Dear Peter,
Thanks very much for your concern. Answers to your questions are listed
below. Here, I am facing another serious problem: Should I interrupt the
Indexing work, which has been running for about 19 days? I don't know
how long it will take to finish the job. The table contains
1,045,
On Friday 04 November 2005 07:30 am, AESYS S.p.A. [Enzo Arlati] wrote:
> Hi, I'm trying to migrate from MySQL 4.1.11 to MySQL 5.0 and I get a
> problem with the new release.
> I have this table...
>
> provasql
> CREATE TABLE `provasql`
>
> `idrow` bigint(20) unsigned NOT NULL default '0',
> `descr
On Oct 28, 2005, at 1:06 AM, BÁRTHÁZI András wrote:
I'm new on this list, so a very short intro about me: I'm Andras
Barthazi, a Hungarian web developer. I like MySQL very much, I'm
using it since 3.x versions, so I think I know it very well. But...
I'm new to everything, but I can tell you
Hi,
Is it a so hard, or a so easy question, that nobody answers it? :) Or just
should wait some more hours, and don't hurry so much? ;)
Bye,
Andras
So, I started learning, how MySQL 5.0 handles character sets. It is, what I
think about it:
character_set_client | latin1
This is, what
> Has anyone been involved with the 5.0 certification program.
"I've read that the new MySQL 5 certificates will be available about 2
or 3 months after MySQL 5 becomes a Production Release."
http://db4free.blogspot.com/2005/10/mysql-5-certifications.html
--
Scott Noyes
[EMAIL PROTECTED]
--
MyS
On 9/27/05, Fred Ballard <[EMAIL PROTECTED]> wrote:
>
>
> I had the same problem. Disabling it isn't enough. I had
> to use the sc command from the Windows command prompt to
> delete the service. Just enter sc on the command line and
> a description of the command will be displayed.
>
> Fred
>
>
>
I had the same problem. Disabling it isn't enough. I had
to use the sc command from the Windows command prompt to
delete the service. Just enter sc on the command line and
a description of the command will be displayed.
Fred
-Original Message-
From: Scott Hamm [mailto:[EMAIL PRO
Scott Hamm <[EMAIL PROTECTED]> wrote on 09/27/2005 03:00:00 PM:
> MySQL 5.0 was installed up to the point where I tried to start it in
> Instnace Configuration wizard. It won't start at all even mysqld and
mysqld
> --safe-mode
>
> I'm getting frustrated -- hosed hard drive, reinstalled Windows 2
Scott Hamm <[EMAIL PROTECTED]> wrote on 09/27/2005 11:25:15 AM:
> While I try to install MySQL 5.0 and start it as "QCDA" server, and upon
> "execute" it could not start service during MySQL Instance Configuration
> Wizard on Windows 2000 Pro. The older and removed Mysql are set disabled
in
> ser
Hello.
Yes, MySQL 5.0.12 a bit unstable yet. You may want to make a bug
report. See:
http://dev.mysql.com/doc/mysql/en/bug-reports.html
Or send the the list definition of your tables, problematic
queries and a stack trace. It would be great if you include
a test script which generates
Hi!
Sujay Koduri wrote (in personal mail):
Hi jorg,
DO you have any idea when MySQL 5.0 is going to get into production.
Sujay, please
1) mail such questions to the list, not just to me personally
2) do not post above a full quote, it wastes readers' time, bandwidth,
and disk space.
Re
On 7/14/05, Joerg Bruehe wrote:
> Rick Robinson wrote:
>
> However, the online manual is not cloned, so while we are building 5.0.9
> there can also be new text for 5.0.10 changes that gets integrated into
> the online manual, and this may become visible earlier than 5.0.9 gets
> published.
Why a
Hi Rick, all!
Rick Robinson wrote:
Just a question on upcoming MySQL 5.0.x releases...what the heck is going on? I
see doc notes for 5.0.8, 5.0.9, and 5.0.10 all concurrently. Is the plan to
merge all these together for a single 5.0.10 release? Or will there be a 5.0.11
that merges all these
saiph wrote:
create database url;
use url
create table cath
(
name varchar(10) primary key,
) type=innodb;
create table site
(
url varchar(40) primary key,
aline varchar(40),
cath varchar(10),
constraint fk_cath foreign key(cath) references cath(name)
I prefer SQLyog. www.webyog.com
Ditto that. I used to use MySQL-Front, but switched when development
stopped. I don't miss it really. The structure synchronization and db
job agent features are maturing rapidly and work quite well. Saves a ton
of time for me. Not sure about v5.0 support yet, bu
TECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, March 30, 2004 10:30 AM
> Subject: Re: MySQL 5.0 - What is really available?
>
>
> > You mention Windows XP.
> > Check out Mysql-Front (now commercial), version 3 may fit the bill.
> > not sure. but it wa
shove it. They were rude and arrogant.
G. Jensen
- Original Message -
From: "dan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, March 30, 2004 10:30 AM
Subject: Re: MySQL 5.0 - What is really available?
> You mention Wind
Hello,
I prefer SQLyog. www.webyog.com
Karam
--- Martijn Tonies <[EMAIL PROTECTED]> wrote:
> Hi Mike,
>
>
>
> > I've downloaded and installed 5.0, it seems to be
> working fine. However, I
> > need a graphical user interface to create tables
> and such (when I say I
> > need, trust me, I need
Hi Mike,
> I've downloaded and installed 5.0, it seems to be working fine. However, I
> need a graphical user interface to create tables and such (when I say I
> need, trust me, I need). I'm running on XP (that explains a lot I know)
>
> So:
>
> Is Control Center for 5.0 available?
> Is MyODBC 5
Another option is DB Designer 4, http://fabforce.net/dbdesigner4/ never
quite used it because I live by phpmyadmin, but I know a few people who use
it.
Donny
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 30, 2004 10:26 AM
> To: [EMAIL PR
You mention Windows XP.
Check out Mysql-Front (now commercial), version 3 may fit the bill.
not sure. but it was the best windows interface for mysql ever made,
notice, I said best for windows... ;)
mysqlCC rocks, but not sure about 5.0 support.
perhaps you could test it and report, and if its no
My best guess is somewhere around summer, 2005
On Wed, 2004-03-17 at 09:41, Garg, Piyush (EM, GECIS) wrote:
> Hi Everyone,
>
> Can you please tell what is the expected date for the Production release of Mysql
> 5.0.
>
> Many Thanks and Regards,
> Piyush
--
|.
Matthew,
- Original Message -
From: ""Matthew Son""
Newsgroups: mailing.database.myodbc
Sent: Tuesday, March 09, 2004 10:26 PM
Subject: mysql 5.0 production release
> Hello,
>
> Can you give an estimate of when 5.0 will be released for production?
my guess is that 4.1 will be declared '
Stefan Traby <[EMAIL PROTECTED]> wrote:
> Hi !
>
> mysql 5.0 is _really_ cool.
>
> this bug should be reproducable:
Thank you for bug report! It was entered to the bug database as
http://bugs.mysql.com/2460
>
>
> ( cat table.sql ; ./populate.pl ; ./perfect_game.pl 32 ) | mysql test
>
.
cheers!
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "jamie murray" <[EMAIL PROTECTED]>
Cc: "Gerald R. Jensen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Sunday, January 04, 2
en" <[EMAIL PROTECTED]>
To: "jamie murray" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Sunday, January 04, 2004 2:05 PM
Subject: Re: mysql 5.0
Jamie:
I don't think your problem has anything to do with version 5.0 ... though
rant all privileges on *.* to [EMAIL PROTECTED] ;
I can access mysql from command line and these ->(php,perl,odbc,python
etc...)
- Original Message -
From: "Gerald R. Jensen" <[EMAIL PROTECTED]>
To: "jamie murray" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
Jamie:
I don't think your problem has anything to do with version 5.0 ... though
there have been some enhancements in security and user privs, the
fundamentals (IMHO) have not changed.
The problem is most likely with the application itself ... it needs to pass
the user ID and password, and the us
On Thu, Oct 23, 2003 at 07:30:55PM +0200, Angel Todorov wrote:
> Hello list,
>
> Can you tell me when approximately is the 5.0 version of MySQL going
> to be released? Thanks.
Probably not. MySQL doesn't have a fixed release schedule.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, L
rands" <[EMAIL PROTECTED]>
To: "Jim Winstead" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 09:26
Subject: Re: MySQL 5.0 and Stored Procedures
> Hi,
>
>
>
> I'm working with version 5.0 as well, like you I find it hard
- Original Message -
From: "Jim Winstead" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 15, 2003 7:10 PM
Subject: Re: MySQL 5.0 and Stored Procedures
> On Wed, Oct 15, 2003 at 11:57:02AM -0500, woody at nfri dot com wrote:
> > On Wed, 2003
On Wed, Oct 15, 2003 at 11:57:02AM -0500, woody at nfri dot com wrote:
> On Wed, 2003-10-15 at 10:55, Josh Wilson wrote:
> > I have just recently compiled Mysql 5.0 onto my redhat linux box, and
> > have been trying to set up some store procedures, but have yet to be
> > able to figure out how. Can
When you install development test releases (pre-alpha) you are pretty
much on your own... Unless any documentation was included with the
download, the only other thing around is the blurb on mysql.com
http://www.mysql.com/downloads/mysql-5.0.html
On Wed, 2003-10-15 at 10:55, Josh Wilson wrote:
>
On Tue, Sep 30, 2003 at 09:26:11AM +0200, Bob Brands wrote:
> Hi,
>
> I compiled MySQL 5.0 from the source tree to test how stored procedures
> work.
> When I create a function, It is not stored in de mysql.func table, but in
> the mysql.proc table.
>
> Example of the function a create:
>
> crea
"Duffy, Richard" <[EMAIL PROTECTED]> wrote:
>
> Do you have any idea when version 5.0 will be available?
You can install 5.0 from development source tree:
http://www.mysql.com/doc/en/Installing_source_tree.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensi
MySQL 5.0 Downloads: http://www.mysql.com/downloads/mysql-5.0.html
-Original Message-
From: Duffy, Richard [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 10:16 AM
To: '[EMAIL PROTECTED]'
Subject: MySQL 5.0
Do you have any idea when version 5.0 will be available?
regards,
Richa
Has 4.0 Been offical release, I thought it was still in Beta?
-Original Message-
From: Josh Wilson [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 22, 2002 10:32 AM
To: [EMAIL PROTECTED]
Subject: Re: MySql 5.0
When can we expect a release of 5.0 with stored procedure
functionality in
When can we expect a release of 5.0 with stored procedure
functionality in MySQL?
Sincerely,
Joshua Wilson
Software Engineer
SOSystems Corporation
[EMAIL PROTECTED]
801-222-0200
'Whoever controls your thoughts, controls your actions.'
--
68 matches
Mail list logo
