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.
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 any
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
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)
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:
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 to
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
of handles (logical resources) but 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
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 100,000 Window handles
Hi,
Try [EMAIL PROTECTED] instead.
Bye.
Geof.
-Message d'origine
.
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's causing
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
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
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
PROTECTED]
To: åˆóã [EMAIL PROTECTED]; mysql@lists.mysql.com
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 the BitKeeper downloads, /Docs is nearly
empty. The important files are only present if
you do
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
hahaha, I see. Thank you very much.
Regards,
Gu Lei
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: åˆóã [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, June 09, 2006 11:02 AM
Subject: Re: mysql-5.0/Docs
At 10:45 +0800 6/9/06, å^óã wrote:
Thanks a lot.
In MySQL
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
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
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
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. MySQL 5 is
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, and
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
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 to
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
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 each
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
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. Even
-
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 bug. MySQL
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
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
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`
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,
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
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]
--
MySQL
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
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
services
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 2000
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
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
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.
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
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 are
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)
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
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
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.0
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). I'm
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 Windows XP.
Check out Mysql-Front (now
(OPTIMIZE and REPAIR MyISAM tables) and was basically told
I could 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
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,
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
after
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
] ;
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];
[EMAIL PROTECTED]
Sent: Sunday, January 04, 2004 2:05 PM
Subject: Re: mysql 5.0
Jamie:
I
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
there have been some enhancements in security and user privs, the
fundamentals (IMHO) have not changed.
The problem
.
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, 2004 3:05 PM
Subject: Re: mysql 5.0
Password security was improved in version
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,
[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-10-15 at 10:55, Josh Wilson wrote:
I have just recently compiled Mysql 5.0 onto my
[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 to find
documentation on MySQL-5.0 and not much support for MySQL-5.0
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:
create
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,
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=ensita
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.'
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
67 matches
Mail list logo