In the last episode (Aug 25), Moon's Father said:
> Hi.
>For example, entering mysql command line client,
>mysql> pager more ( or pager md5sum and so on.)
>
>I want to know how many command the 'pager' follows? Any reply will
> be big appreciated.
Any command can be used as a pager.
I know, all the shell command can do this. Thanks.
2010/8/25 Moon's Father
> Hi.
>For example, entering mysql command line client,
>mysql> pager more ( or pager md5sum and so on.)
>
>I want to know how many command the 'pager' follows? Any reply will be
> big appreciated.
>
Hi
If you don't mind keeping the general log, you can periodically parse it. I
read that MySQL 5.1 (or some later version) will have an option to keep the
general log in a table - that will be very handy.
Be careful if you use this option (logging to a table) - while it's an
extremely att
Hi Shuly,
you can use the method suggested by Shuly or you cook up your
query logs if you need more accurate information. May be you can write a
small script to do the job.
Regards,
Chandru
forums.mafiree.com
On Mon, Dec 22, 2008 at 7:34 AM, mos wrote:
> At 02:32 PM 12/21/2008, y
If you don't mind keeping the general log, you can periodically parse it. I
read that MySQL 5.1 (or some later version) will have an option to keep the
general log in a table - that will be very handy.
On Sun, Dec 21, 2008 at 2:32 PM, Avraham, Shuly wrote:
>
> Hi,
>
> Is there any way to figure
At 02:32 PM 12/21/2008, you wrote:
Hi,
Is there any way to figure out how many, if any, people are accessing and
using our MySQL server?
I am aware of the SHOW PROCESSLIST command, but this one only shows how
many processes are currently running. I would like to register this
information,
On Mon, Sep 8, 2008 at 12:47 AM, Dan Nelson <[EMAIL PROTECTED]> wrote:
> In the last episode (Sep 08), Yi Wang said:
> > According to the mysql manual, I changed key_buffer_size from 8M to
> > 512M. But In mysql administrator, key buffer hitrate seems stay
> > unchanged. And key buffer usage alway
On Mon, Sep 8, 2008 at 12:47 PM, Dan Nelson <[EMAIL PROTECTED]> wrote:
> In the last episode (Sep 08), Yi Wang said:
>> According to the mysql manual, I changed key_buffer_size from 8M to
>> 512M. But In mysql administrator, key buffer hitrate seems stay
>> unchanged. And key buffer usage always be
In the last episode (Sep 08), Yi Wang said:
> According to the mysql manual, I changed key_buffer_size from 8M to
> 512M. But In mysql administrator, key buffer hitrate seems stay
> unchanged. And key buffer usage always below 4M.
>
> The total db size is about 200M. And the system's load is sligh
On 12/6/06, Mikhail Berman <[EMAIL PROTECTED]> wrote:
-Original Message-
>
From: Dotan Cohen [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 06, 2006 3:37 PM
> To: MySQL General
> Subject: How many records in table?
>
> What's a quick query to determine how many records a given tab
On 06/12/06, Mikhail Berman <[EMAIL PROTECTED]> wrote:
Use SELECT in with count(*)
SELECT count(*) from YOUR_TABLE
Mikhail Berman
Thanks, Mikhail. Will do.
Dotan Cohen
http://what-is-what.com/what_is/xss.html
http://english-lyrics.com/
--
MySQL General Mailing List
For list archives: htt
Use SELECT in with count(*)
SELECT count(*) from YOUR_TABLE
Mikhail Berman
-Original Message-
From: Dotan Cohen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 06, 2006 3:37 PM
To: MySQL General
Subject: How many records in table?
What's a quick query to determine how many record
indexes on a table to
optimise all of your queries. Sometimes this makes the indexes much
larger
than the data itself.
Hope this helps,
Andy
> -Original Message-
> From: Brent Baisley [mailto:[EMAIL PROTECTED]
> Sent: 03 November 2006 16:04
> To: John.H; mysql
> Subj
much larger
than the data itself.
Hope this helps,
Andy
> -Original Message-
> From: Brent Baisley [mailto:[EMAIL PROTECTED]
> Sent: 03 November 2006 16:04
> To: John.H; mysql
> Subject: Re: How many colums should a index contain?
>
> I think you want to create separate
I think you want to create separate indexes. Indexes are basically a sorted list. So a single index on all those fields would sort
the data first by id, then bid, then title,...
If id is unique, then there is absolutely no reason to add other fields to the index. Think of a compound index as a f
John.H wrote:
but why when I do a query with 'explain' ,it shows that the
'possible_keys' is null or primary rather than the index I just create
Please always CC the list - you will get much faster responses and
others will be able to offer their input as well.
Post the query, the explain
John.H wrote:
I have two tables and I must do :
select `id`,`bid`,`title`,`link`,`bname` from table1 where `bid` in
( ...this is a subquery in table2 )
should I create a index (`id`,`bid`,`title`,`link`,`bname`) so that my
query
will take less time
or should a index contain so many colums?
I
Dan,
Cheers for doing the translating, I'm one of those beardy types they
keep locked in a dark room writing search engines so my English isn't
spectacular ;^)
As Rolando points out your file system may place a limit on the
number of files or directories, but to my knowledge XFS has no su
That does make sense, John.
What Philip is saying is that you might run into problems with one of
the tables used to keep track of tables and databases, before you run
into problems with any hard coded limit of MySQL itself.
The OS and the hardware will impose some (rather generous)
restrictions
AM GMT-0500 US/Eastern
Subject: Re: How many databases does MySQL 5 support?
John M.Brown schrieb:
> Thanks for the info, but my question is how many databases, not so much how
> many rows per table or how big the database can be... I mean, how many
> "create database ABC" c
John M.Brown schrieb:
Thanks for the info, but my question is how many databases, not so much how many rows per table or how
big the database can be... I mean, how many "create database ABC" can I do
before MySQL says "sorry, you can't have more than X databases".
Say I create 1000 empty MySQL
Thanks for the info, but my question is how many databases, not so much how
many rows per table or how big the database can be... I mean, how many "create
database ABC" can I do before MySQL says "sorry, you can't have
more than X databases".
Say I create 1000 empty MySQL databases (meaning no
John,
How many databases does a single instance of MySQL Server 5.x support?
I suspect you'll get a bit of a , with a 64bit machine there's
a limit of 4.2 billion rows per table and with an XFS file system 8EB
per table, there's a join limit specified somewhere but I don't think
there's an
At 06:32 AM 8/3/2006, Ratheesh K J wrote:
Hello all,
Just wanted to know how many columns are preferable in table. At present
we are having nearly 50 - 60 columns in some of the tables. Is this ok or
should we be splitting the tables for normalization.
If we really need to split then how be
Hello.
Looks like it returns as much as:
select count(distinct id) from sale where user_id=1;
I've found it in comments at:
http://dev.mysql.com/doc/mysql/en/Counting_rows.html
Jerry Swanson <[EMAIL PROTECTED]> wrote:
> This is my query
> select id, status from sale where user_id
Your sample query doesn't really make sense, but perhaps you are looking for
SQL_CALC_FOUND_ROWS. From the manual, "SQL_CALC_FOUND_ROWS (available in
MySQL 4.0.0 and up) tells MySQL to calculate how many rows there would be in
the result set, disregarding any LIMIT clause. The number of rows ca
On Saturday 13 November 2004 06:40 am, Jerry Swanson wrote:
> This is my query
> select id, status from sale where user_id = 1 GROUP BY id;
>
> I need to know how many rows or how many entries this query returns. I
> tried to use "count" and "sum". But the result is wrong.
>
> I want to be able to
Have you tried looking in the manual? This information should all be there
somewhere. The URL is http://dev.mysql.com/doc/mysql/en/index.html.
According to relational theory, there can only be one PRIMARY KEY in any
table, although it may contain multiple columns. I *think* you can have as
many UN
Apart from "my.cnf" MySQL also provide you with
my-huge.cnf, my-large.cnf, my-medium.cnf and my-small.cnf.
Files whih are used for diferrent sizes of datadases. Check them out it can
help. if you find the conf you r looking for in one of the cnf file you just
have to rename it to my.cnf.
Vinay
On Mon, 25 Aug 2003 10:05:32 +0530 (IST)
"Rupak Banerjee" <[EMAIL PROTECTED]> wrote:
>
> Hi,
> I have a mysql database running on Mysql version 3.23.53 on a Red Hat
> Linux 7.2. In the database there is a single table with over 150,000
> records. Unfortunately, the performance of that table is
Hi Jeremy,
Thankx for the solution..but can you please tell
me how to increase the key buffer fo mysql ??
Its urgent...we are facing a lot of problems.
Thankx once again for the solution.
> On Fri, Aug 22, 2003 at 10:55:49AM +0530, Rupak Banerjee wrote:
>> Hi,
>>
>> We are using MySql ve
Thank you for the Email. I will contact you within 24 hours.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Fri, Aug 22, 2003 at 10:55:49AM +0530, Rupak Banerjee wrote:
> Hi,
>
> We are using MySql version 3.27.53 on a Red Hat Linux platform version
> 7.2. For the past couple of months we are noticing that the performance
> of the server has gone down very badly. Every, single insertion is
> taking
"Rupak Banerjee" <[EMAIL PROTECTED]> wrote:
> Hi,
> We are using MySql version 3.27.53 on a Red Hat Linux platform version
> 7.2. For the past couple of months we are noticing that the performance
> of the server has gone down very badly. Every, single insertion is
> taking a hell lot of time.The
Hi Rupak!
> We are using MySql version 3.27.53 on a Red Hat Linux platform version
> 7.2. For the past couple of months we are noticing that the performance
> of the server has gone down very badly. Every, single insertion is
> taking a hell lot of time.The particular table has only 150,000 reco
* B. Fongo
> I was able to extra the information from the first 2 tables yesterday
> using following query:
>
> SELECT Customers.Name, Customers.City, Orders.Product,
> Order.Price FROM Customers inner join Orders USING (cust_id) WHERE
> customers.cust_id = "2"
>
> -
On Wed, 02 Apr 2003 11:10:04 -0600
gerald_clark <[EMAIL PROTECTED]> wrote:
> AChecks for empty
> B Checks for empty
> AUpdates
> AReads ( and owns record )
> BUpdates
> BReads ( and owns record )
>
Reality says to do it more like this
A Write lock on table
B Tries to
<[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 11:59 AM
Subject: RE: How Many
> Just noticed this thread.
>
> Here is another method, still using the 'userid' method, but slightly
> differently; it claims a job immediately. You then have to run a select
by
>
ike
get_last_update or mysql_affected_rows to gather information on what the
UPDATE affected rather than another select. This was just quick and
generic.
-Mike
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 11:12 AM
To: gerald_clark
C
<[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 11:10 AM
Subject: Re: How Many
AChecks for empty
B Checks for empty
AUpdates
AReads ( and owns record )
BUpdates
BReads ( and owns record )
Now What?
Cal Evans wrote:
No. You check for empty. update, check
last man wins.
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 11:10 AM
Subject: Re: How Many
> AChecks for empty
&
lt;[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 9:22 AM
Subject: Re: How Many
Cal Evans wrote:
Ed,
1: It depends on your hardware. I don't think MySQL imposes a
restriction.
2: It doesn't work that way. It's not like V
-
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>
Cc: "Ed Kiefer" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 9:22 AM
Subject: Re: How Many
>
>
> Cal Evans w
Cal Evans wrote:
Ed,
1: It depends on your hardware. I don't think MySQL imposes a restriction.
2: It doesn't work that way. It's not like VFP or Access where you 'edit' a
record. You can SELECT the contents of a record, you can manipulate them and
then you can UPDATE that record (assuming yo
Ed,
1: It depends on your hardware. I don't think MySQL imposes a restriction.
2: It doesn't work that way. It's not like VFP or Access where you 'edit' a
record. You can SELECT the contents of a record, you can manipulate them and
then you can UPDATE that record (assuming you have a primary key
>From: "Andrew Kuebler" <[EMAIL PROTECTED]>
>
>2) Is it just as fast with Mysql to access 10 fields in a table with 10
>columns as it would be to access those same 10 fields among let's say 90
>other fields in a 100 column table?
Are you certain that performance should be your primary concern her
I'm not sure what the limit is. MySQL limits tend to be dictated by the
OS that is being used. The more columns you have the larger the database
file will be. You should try to avoid having many empty columns in a
database design, even if you are using varchar instead of char. Try to
think ahe
At 15:41 -0400 10/1/02, Chuck Payne wrote:
>Hi,
>
>I am having problems get how many days out an invoice is from mysql. I have
>try this.
>
>SELECT NOW()-summitted_date FROM table;
>
>But it not working as usually. So please guys a little help.
What do you mean "not working as usually"? A query
I can't think of any reason to have that many fields. It really starts
to make the databases structure unmanageable, or at least difficult and
time consuming to manage. It also can make it very difficult to create a
good, flexible search interface.
Filemaker might be an exception because of the
In the last episode (Jun 08), Shoshi & Iphtach Cohen said:
> Hi experts,
>
> I appreciate if you could tell me how many MySQL tables we can open in
> parallel.
>From a client's point of view? Unlimited. Internally, mysql will only
open "table_cache" number of tables at once. If the number of
10, 000 files open at the same time...maybe the OS itself is getting
flustered, you want to make sure that your OS can handle it, on *nix, u can
do a
ulimit -a and see the open files parameter
Beyond that, the system level limit on Linux can be found as
cat /proc/sys/fs/file-max
- Original Me
* Egor Egorov
> RB> Are you saying that the mysql server will need to open all
> the tables in a
> RB> database at the same time? When does this happen? When I issue the USE
> RB> command?
>
> Roger, number of opened files is not the same as number of files in
> the directory. When table is create
Roger,
Wednesday, April 17, 2002, 6:54:29 PM, you wrote:
RB> * Egor Egorov
>> RB> 1) does this apply to InnoDb tables?
>>
>> Not quite, InnoDB stores tables in the tablespace, that may consists of
>> several files..
RB> Yes... but rarely one file per table...
RB> But what about the .frm files..
You'd probably want to make sure the tables are at least in 3rd normal form.
1st: each column contains only ONE attribute. The means you can't
have a list of people for "members" or the such. And each row must
have a primary key. No two rows can be identical in a table.
2nd: no column is parti
- Original Message -
From: "John Mayson" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, December 24, 2001 4:40 PM
Subject: How many tables?
> How far should I go with this? Right now when I look at my frequency
table, it's mostly a
> list of numbers. I suppose t
Gerald Clark wrote:
> >> You might want to try:
> >>
> >> WHERE mycolumn in (1, 3, 23, ...)
> >>
> >> Or even better, put your thousand records into a temporary table and then
> >
> > just do a join.
> >
> >> --jfarr
I have yet to have a query that is to long when talking to MySQL via DBD, howev
in() is usefull for OR ing, but is there a way to do this AND ing?
> You might want to try:
>
> WHERE mycolumn in (1, 3, 23, ...)
>
> Or even better, put your thousand records into a temporary table and then
just do a join.
>
> --jfarr
>
> - Original Message -
> From: "Mysql List" <[EMA
Well, a column can't be one value AND another value.
Mysql List wrote:
> in() is usefull for OR ing, but is there a way to do this AND ing?
>
>
>
>
>> You might want to try:
>>
>> WHERE mycolumn in (1, 3, 23, ...)
>>
>> Or even better, put your thousand records into a temporary table and t
If you use just 1 OR you will force a table scan and slow everything down ?
- Original Message -
From: "Mysql List" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: 26 September 2001 20:06
Subject: How many OR, AND in a query?
> Hi,
> How many OR or AND can I put in a select q
You might want to try:
WHERE mycolumn in (1, 3, 23, ...)
Or even better, put your thousand records into a temporary table and then just do a
join.
--jfarr
- Original Message -
From: "Mysql List" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 1
Hi Bob,
thas just a difference in the apache-config from caldera.
That has nothing to do with mysql!
Thomas
- Original Message -
Jeremy,
Yeah I follow you and as a LInux user of 5 years I am accustomed to
seeing
multiple processes launched for the same executable but
On Thu, Jun 07, 2001 at 08:23:03AM -0400, R Talbot wrote:
> Please explain why I get multiple Daemon process
> when I start mysql.server..Such as
>
> 1075 pts/0S 0:00 sh /usr/local/mysql/bin/safe_mysqld
> --user=root --pid
> 1093 pts/0SN 0:00 /usr/local/mysql/libexec/mysqld
> -
> Depends on OS, memory, disk space.
>
> Theoretically there is no "limit".
>
> If your using linux, and don't have support for large files built in, then
> your table size limit is 4GB. Putting a table with 1k rows at a max size of
> around 4 million records. If you have large file support in
it all depends on your hardware, technically the MyISAM table type can
handle up to 8 terabytes of data.
Zhu George-CZZ010 wrote:
>
> If each record is about 1K byte, how many records can MySql handle? Does anyone
>have any estimation or hands-on experience?
>
> Thank you very much in advance
Depends on OS, memory, disk space.
Theoretically there is no "limit".
If your using linux, and don't have support for large files built in, then
your table size limit is 4GB. Putting a table with 1k rows at a max size of
around 4 million records. If you have large file support in, and have the
---Reply to mail from Nathanial Hendler about How many queries per second do you get?
>
> Hello, I was just looking at my MySQL databse using mytop and saw that I was
> getting over 60 queries per second. Can people give me an idea of how many
> queries per second they get?
>
>
Hello
I have
> I want to ask you :
> 1- How many rows does a mysql table can hold?
> 2- I have to design a database for all universities of my country , Is it
> better to consider one database for each university or one database for
all
> universities . Note that a query on a table "student" would be more qui
I think a good soluthion it is to do a table for every thing and use MERGE
table for searching data in all the table (for MERGE see documentation at
pag. 271 "MySql table Type" chapter).
Il 16:24, mercoledì 14 marzo 2001, abdelhamid bettache scrisse:
> I want to ask you :
> 1- How many rows
"Jeremy D. Zawodny" wrote:
>
> On Wed, Mar 14, 2001 at 07:19:24AM -0800, abdelhamid bettache wrote:
> > 2- I have to design a database for all universities of my country ,
> > Is it better to consider one database for each university or one
> > database for all universities . Note that a query
On Wed, Mar 14, 2001 at 07:19:24AM -0800, abdelhamid bettache wrote:
> I want to ask you :
> 1- How many rows does a mysql table can hold?
Millions. Probably billions. I've heard of someone putting 2 billion
rows in a table before (if memory serves).
> 2- I have to design a database for all uni
On 09.02.2001 12:01:01 Kissandrakis S. George wrote:
> I have 6500 tables under one database there is no problem
Pardon me, but how do you keep track of that many tables? I mean, I've a hard
time with 10 or 20 tables - but 6500???
---
I have 6500 tables under one database there is no problem
i hope that helps :)
--
Kissandrakis S. George [[EMAIL PROTECTED]]
Network and System Administrator [http://www.phaistosnetworks.gr/]
Tel/Fax: (+30 892) 24450/23206
Phaistos Networks S.A. - A DOL Digital Company
---
I think 12 tables is not a large number by any means.
If they _logically_ form one database, I'd not bother about the number.
Only if performance problems pop up, and are positively recognized as being caused
by too many files in the database directory, I'd start looking for a solution.
Which need
Just a side note... you can do JOINs on tables from different databases on the same
mySQL server
eg
SELECT t1.UserName FROM db1.table AS t1, db2.anothertable AS t2 WHERE t1.UserName =
t2.UserName
As for database layout... I would go with what makes the most sense... If having 84
tables in o
>
> How do you decide when a table should go into another database. For
> example, I have a database with about 12 tables and growing. I keep
> them in one database because I am doing joins that periodically involve
> all of the tables. Is this the right way to do it?
>
> Richard
Richard, I'
Hello Anna,
According to the MySQL Crash-Me the maximum numbers for 3.23.xx are:
- Columns in table 3398
- max table row length (without blobs) 65534
- table row length with nulls (without blobs) 65502
If you understand the concepts of DB normalization don't bother reading the
following:
300
It may become less readable on the server side, but if you
want to store lots of little bits of information, use a BIGINT
column as a collection of a bunch of bits ... pack and unpack
them in your application.
For searching, use the bitwise operators to do comparisons.
-Tilghman
--
"There cann
77 matches
Mail list logo
