Now mysql's version is 5.0.45
Any reply is appreciated.
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
I can alloc 14GB to innodb_buffer_pool_size, even 15GB on my 16GB
system. However I used mysql6.0, not mysql5.0. Maybe you can try newer
mysql version.
Thx, Xuekun
On 7/24/08, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi,
U can use max of 80% of your Memory to Mysql, as OS needs the remaning.
Unfortunately, right now I can't.
Someone mentioned getting rid of myisam configuration values might help.
Which ones would that be?
Regards
Dominik
Xuekun Hu wrote:
I can alloc 14GB to innodb_buffer_pool_size, even 15GB on my 16GB
system. However I used mysql6.0, not mysql5.0. Maybe you
As Ananda mentioned, key_buffer is used for myisam. However I don't
think that's the reason. :-) Maybe mysql5.0 is the reason, or any
other system limitation?
On 7/25/08, Dominik Klein [EMAIL PROTECTED] wrote:
Unfortunately, right now I can't.
Someone mentioned getting rid of myisam
I have a query:
SELECT Country, COUNT( Country ) AS Cnt FROM properties WHERE (
Country != 'USA' AND Country != 'US' AND Country != 'Unit' AND Country
!= 'United States' AND Country != ' ' AND Country IS NOT NULL ) GROUP
BY Country ORDER BY Cnt DESC LIMIT 8
that gets the top 8 non-US countries
On Fri, Jul 25, 2008 at 12:27 AM, Michael Stearne [EMAIL PROTECTED] wrote:
I have a query:
SELECT Country, COUNT( Country ) AS Cnt
FROM properties WHERE (
Country != 'USA' AND
Country != 'US' AND
Country != 'Unit' AND
Country != 'United States'
AND Country !=
I may be approaching this all wrong, but I need to know a percentage of
total sales within a select statement.
So I can do something like this:
Select company, state, sales, sum(sales) / sales as percent
From Sales
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Network EngineerSafe Data,
yes, u can use the below sql.
regards
anandkl
On 7/25/08, David Ruggles [EMAIL PROTECTED] wrote:
I may be approaching this all wrong, but I need to know a percentage of
total sales within a select statement.
So I can do something like this:
Select company, state, sales, sum(sales) / sales
I get:
Error Code : 1140
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is
illegal if there is no GROUP BY clause
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Network EngineerSafe Data, Inc.
(910) 285-7200 [EMAIL PROTECTED]
-Original Message-
From:
David Ruggles wrote:
I may be approaching this all wrong, but I need to know a percentage of
total sales within a select statement.
So I can do something like this:
Select company, state, sales, sum(sales) / sales as percent
From Sales
mmh, you want
sum(sales where
Hi David,
Try
Select company, state, sales, sum(sales) / sales as percent
From Sales GROUP BY company, state;
Not sure if you always want to group by state; if each company exists in
only one state then the group by is irrelevant, if not then it will give
you the by-state breakdown.
On Fri,
-Original Message-
From: David Ruggles [mailto:[EMAIL PROTECTED]
Sent: Friday, July 25, 2008 10:53 AM
To: 'mysql'
Subject: RE: How do I (can I) use aggregate functions inside a select
I get:
Error Code : 1140
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns
is
Sum() is driven by the group by.
I need it to be equivalent to this:
Select company, state, sales, sales / (select sum(sales) from sales) as
percent from sales
Which of course I could just use that, but the select I'm actually working
with isn't that simple and if there was some way to do what I
On Fri, Jul 25, 2008 at 12:35 PM, Arthur Fuller [EMAIL PROTECTED] wrote:
ORDER BY implies a sort of the result set. I don't think there is any way
around that.
I guess so. What I am doing is to just run the query once per day and
store the results in memcache.
Michael
Arthur
On Fri, Jul
Why? Because it's Friday and I'm feeling silly :)
mysql SELECT * FROM sales;
+--+---++
| company | state | sales |
+--+---++
| ABC | AZ| 140.01 |
| XYZ | AZ| 17.76 |
| ABC | NY| 123.45 |
| XYZ
I have a memory table with a few hundred thousand rows. As soon as I add an
index to the table, it loses 75% of the rows! No error is produced in the
log file or on the client machine. The rows 'A' to 'E' are present, but
rows 'F' to 'Z' are missing.
I have max_heap_table_size=1024M and
List,
I am bulk inserting a huge amount of data into a MyISAM table (a
wikipedia page dump).
Before I issued SOURCE filename.sql; I did an ALTER TABLE page DISABLE
KEYS; LOCK TABLES page WRITE;
The dump consists of about 1,200 bulk INSERT statements with roughly
12,000 tuples each.
For the
Am Freitag 25 Juli 2008 21:19:56 schrieb [EMAIL PROTECTED]:
To confirm that you would like
[EMAIL PROTECTED]
removed from the mysql mailing list, please click on
the following link:
http://lists.mysql.com/u/mysql/488a275c5444d766/lists=feilner-it.net
This confirmation serves two
Am Freitag 25 Juli 2008 21:19:53 schrieb [EMAIL PROTECTED]:
To confirm that you would like
[EMAIL PROTECTED]
removed from the mysql mailing list, please click on
the following link:
http://lists.mysql.com/u/mysql/488a2759cd767dbb/lists=feilner-it.net
This confirmation serves two
A changing world brings freshness. We can prove that reading makes a perfect
man.Pick up a copy of Weekly Headline News
Try it today and leave a mark and thank you note.
http://weeklyheadlinenews.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
At 06:46 PM 7/25/2008, you wrote:
List,
I am bulk inserting a huge amount of data into a MyISAM table (a
wikipedia page dump).
Before I issued SOURCE filename.sql; I did an ALTER TABLE page DISABLE
KEYS; LOCK TABLES page WRITE;
The dump consists of about 1,200 bulk INSERT statements with
21 matches
Mail list logo