On Fri, 2005-05-06 at 19:01, Greg Whalin wrote:
> What drives are you using? For SCSI RAID, you definitly want deadline
> scheduler. That said, even after the switch to deadline, we saw our
> Opteron's running way slow (compared to older slower Xeons). Whatever
> the problem is, we fought it
On Fri, 2005-05-06 at 22:16, John David Duncan wrote:
> > And no performance diff. Note that you're benchmarks only show a 20M
> > addition overhead. We're about 60x too slow for these drives so I'm
> > not
> > sure what could be going on here :-/
>
>
>
> I know of a site that encountered a s
And no performance diff. Note that you're benchmarks only show a 20M
addition overhead. We're about 60x too slow for these drives so I'm
not
sure what could be going on here :-/
I know of a site that encountered a similar performance issue:
The OS was reading in a lot more data from the disk th
In the last episode (May 06), Kevin Burton said:
> We have a few of DBs which aren't using disk IO to optimum capacity.
>
> They're running at a load of 1.5 or so with a high workload of
> pending queries.
>
> When I do iostat I'm not noticing much IO :
>
> Device:rrqm/s wrqm/s r/s w/s
Greg Whalin wrote:
What drives are you using? For SCSI RAID, you definitly want deadline
scheduler. That said, even after the switch to deadline, we saw our
Opteron's running way slow (compared to older slower Xeons). Whatever
the problem is, we fought it for quite a while (though difficult t
ohh one correction:
select substr(datetime,0,8) AS date, count(date) from userLog group by date;
Anoop
On 5/6/05, Anoop kumar V <[EMAIL PROTECTED]> wrote:
>
> how about this:
>
> select substr(datetime,0,8) AS date, count(datetime) from userLog group by
> date;
>
> I could not clearly under
how about this:
select substr(datetime,0,8) AS date, count(datetime) from userLog group by
date;
I could not clearly understand what you wanted to average upon.
HTH,
Anoop
On 5/6/05, Graham Anderson <[EMAIL PROTECTED]> wrote:
>
> how do I get the average number of hits per day
>
> I ha
What drives are you using? For SCSI RAID, you definitly want deadline
scheduler. That said, even after the switch to deadline, we saw our
Opteron's running way slow (compared to older slower Xeons). Whatever
the problem is, we fought it for quite a while (though difficult to test
too much w/
Kevin Burton wrote:
Greg Whalin wrote:
Deadline was much faster. Using sysbench:
test:
sysbench --num-threads=16 --test=fileio --file-total-size=20G
--file-test-mode=rndrw run
So... FYI. I rebooted with elevator=deadline as a kernel param.
db2:~# cat /sys/block/sda/queue/scheduler
noop anticipa
The message contains Unicode characters and has been sent as a binary
attachment.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Greg Whalin wrote:
Deadline was much faster. Using sysbench:
test:
sysbench --num-threads=16 --test=fileio --file-total-size=20G
--file-test-mode=rndrw run
Wow... what version of sysbench are you running? Its giving me strange
errors
sysbench v0.3.4: multi-threaded system evaluation
Kevin Burton wrote:
Greg Whalin wrote:
We have seen the exact same thing here. We used the deadline
scheduler and saw an immediate improvement. However, we still saw
much worse performance on our Opteron's (compared to our older Xeon
boxes). We ended up rolling back to Fedora Core 1
2.4.22-1
Greg Whalin wrote:
We have seen the exact same thing here. We used the deadline
scheduler and saw an immediate improvement. However, we still saw
much worse performance on our Opteron's (compared to our older Xeon
boxes). We ended up rolling back to Fedora Core 1
2.4.22-1.2199.nptlsmp kernel
Somethign else to think about as well, look at this slight modification:
select pk from a left join b using (pk);
Now, it's not likely this is a valid query for your table structure,
but, in this instance, a.pk and b.pk are not necessarily the same. b.pk
could potentially be NULL while a.pk was n
how do I get the average number of hits per day
I have a table like:
DateTimeid ip
20050506190723 1 121.198.262
what I have so far
SELECT DateTime , count( * )
FROM userLog
GROUP BY DateTime
LIMIT 0 , 30
I assume that DateTime would have to be converted to a specific da
My mistake; I wasn't aware of the 'using' clause being an alternative syntax
for 'on' in MySQL's versio of MySQL. I mostly use DB2 and that is *not*
valid in DB2's SQL.
Rhino
- Original Message -
From: "Simon Garner" <[EMAIL PROTECTED]>
To:
Sent: Friday, May 06, 2005 7:14 PM
Subject: Re
On Fri, 6 May 2005, Eric Bergen wrote:
>He's right in saying that mysql is capable of knowing. My thoughts are
>that it's not worth the speed loss, extra code, and potential guess work
>by mysql just so you don't have to type a table name.
I see what you mean. I didn't think about additional qu
He's right in saying that mysql is capable of knowing. My thoughts are
that it's not worth the speed loss, extra code, and potential guess work
by mysql just so you don't have to type a table name.
Eric Jensen wrote:
The way he is joining tables is fine. You can specify how to link the
using ON
On Sat, 7 May 2005, Simon Garner wrote:
>On 7/05/2005 11:00 a.m., Rhino wrote:
>> Actually, the error message is misleading. There is nothing that I would
>> call ambiguous in your query: you have a syntax error. The join should be
>> written:
>>
>> select pk from a inner join b on a.col1 = b
On Fri, 6 May 2005, Rhino wrote:
>Actually, the error message is misleading. There is nothing that I would
>call ambiguous in your query: you have a syntax error. The join should be
>written:
>
>select pk from a inner join b on a.col1 = b.col2
>
>Of course, you need to replace 'a.col1' and 'b.
The way he is joining tables is fine. You can specify how to link the
using ON or you can just say to use a commonly named field with USING.
The Problem is with the SELECT pk. That is ambiguous. From what table
would you like the pk field? It can be table1.pk or table2.pk.
Eric Jensen
Rhino
On 7/05/2005 11:00 a.m., Rhino wrote:
Actually, the error message is misleading. There is nothing that I would
call ambiguous in your query: you have a syntax error. The join should be
written:
select pk from a inner join b on a.col1 = b.col2
Of course, you need to replace 'a.col1' and 'b.col2'
Actually, the error message is misleading. There is nothing that I would
call ambiguous in your query: you have a syntax error. The join should be
written:
select pk from a inner join b on a.col1 = b.col2
Of course, you need to replace 'a.col1' and 'b.col2' with real column names
from tables
Why are columns included in the join between two tables ambigious?
It seems that they should *not* be ambigious!
Like this
select pk from a inner join b using (pk);
ERROR 1052 (23000): Column 'pk' in field list is ambiguous!!!
Is this a bug, or is it like this for a reason? It drives me nuts,
Tommy Barrios wrote:
Using the below statement results in a null data dump:
SELECT * FROM items WHERE item = '109S2' AND venturi_type = 'L-shaped'
AND category = 'burner';
Whereas if change the 'S' in the item = 10902 like this:
SELECT * FROM items WHERE item = '10902' AND venturi_type = 'L-s
Greetings All,
Being new to this list I beg indulgence in a matter that has me quite
befuddled.
Having already had good success in building my first database web site
I was taken aback when I ran across his little problem whist checking
things out for full functionality on a 7500+ item database;
We have seen the exact same thing here. We used the deadline scheduler
and saw an immediate improvement. However, we still saw much worse
performance on our Opteron's (compared to our older Xeon boxes). We
ended up rolling back to Fedora Core 1 2.4.22-1.2199.nptlsmp kernel and
shut down NPTL
hi,
When designing data it is common to have lookup tables such animal_type :
dog=1, cat=2,bird=3 etc
And then in other tables to refer to animals by their number 1, 2 or 3. This
is memory and
presumably speed efficient. Howver not much fun for humans who are
"reading/debugging" the data.
Alt
What kernel are you running.
If your running 2.6.x use the deadline scheduler or downgrade to
2.4.23aavm 2.6.[0-9] has major problems with the IO scheduler since the
process scheduler is very fast now.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message
We have a few of DBs which aren't using disk IO to optimum capacity.
They're running at a load of 1.5 or so with a high workload of pending
queries.
When I do iostat I'm not noticing much IO :
Device:rrqm/s wrqm/s r/s w/s rsec/s wsec/srkB/swkB/s
avgrq-sz avgqu-sz await svctm
Use explain to see what MySQL is doing.
My guess is that MySQL is trying to figure out if it would be faster to
use the index or scan the whole table. MySQL is probably deciding that
it is quicker to scan the whole table based on the low cardinality of
the indices it can use. Thus, you've just a
Hi all!
I'm having trouble building the latest stable on AIX 5.1. My env is as follows:
Relevant GNU tools:
autoconf-2.58-1.aix5.1.noarch.rpm
automake-1.7.9-1.aix5.1.noarch.rpm
binutils-2.14-3.aix5.1.ppc.rpm
bison-1.875-2.aix5.1.ppc.rpm
flex-2.5.4a-6.aix4.3.ppc.rpm
gcc-3.3.2-4.aix5.1.ppc.rpm
l
I was playing around with a table that had 100 tinyint fields. Each
record contained other a '0' or a '1' for each field.
A query such as SELECT * FROM `foobar` WHERE `f01` =1 AND `f02` =1 AND
`f03` =1 AND `f04` =1 AND `f05` =1 AND `f06` =1 AND `f07` =1 AND `f08` =1
AND `f09` =1 AND `f10` =
I am trying to drop a user via:
mysql> drop user 'wiki_user';
ERROR 1268 (HY000): Can't drop one or more of the requested users
The relevant user table:
mysql> select host,user from user;
+---++
| host | user |
+---+
I use "alter table tbl_name drop col_name" but failed.
The table has 20 million rows, and this turns out to
be a size problem. appreciate any suggestions.
__
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http:
doh! need another redbull. :)
- Original Message -
From: "Reggie Burnett" <[EMAIL PROTECTED]>
To: "'Jeremiah Gowdy'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
Sent: Friday, May 06, 2005 9:31 AM
Subject: RE: C API : Problem using multi-statements
Jeremiah
I don't use the client librar
Hello,
I am not the final authority on this but you can use
SSH/HTTP Tunneling.
More information on it can be found at:
http://www.devx.com/security/Article/27854?trk=DXRSS_DB
If you have any question regarding, SQLyog, I guess -
http://www.webyog.com/forums
would be your best guess.
Karam
-
Hello everyone,
When running these utilities does the MySQL daemon have to be "down"?
There's no activity against the database other than an occasional query.
George
__
Switch to Netscape Internet Service.
As low as $9.95 a month
That's kind of like asking what kind of car to buy to get from point A
to point B. A sports car, it will get you there fast and in style.
Unless you are a moving company, then it's totally inappropriate. A
taxi service? Well that's different too.
Ok, so you are selling by internet. Amazon.com,
You can use mysqldump to create a text version of your database. Mysqldump
will generate the statements that will both (re)generate your tables and
populate them with data. It may be the "low tech" solution you asked
about. Just "dump" your DB to file (memory stick, zip disk, CD-RW) and
move i
Hi
Instead of use two INSERT statements, try something like this:
INSERT INTO Table table1 VALUES (list of values1), (list of values2)
-Original Message-
From: Jeremiah Gowdy [mailto:[EMAIL PROTECTED]
Sent: 06 May 2005 17:19
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject:
Jeremiah
I don't use the client library in my work but this should work from 4.1 on.
-Reggie
-Original Message-
From: Jeremiah Gowdy [mailto:[EMAIL PROTECTED]
Sent: Friday, May 06, 2005 11:19 AM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: C API : Problem using mul
Answer is simple. Can't do that.
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Friday, May 06, 2005 5:40 AM
Subject: C API : Problem using multi-statements
Hello,
I have some problems using multiple queries in a databased driven project,
therefore I wrote a little testprogra
From: Peter Brawley <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Lieven De Keyzer <[EMAIL PROTECTED]>
Subject: Re: Multi-user bookmark system
Date: Fri, 06 May 2005 11:07:48 -0500
Lieven,
Here it is.
Removing the FK looks to me like an incorrect fix to the transitive
dependency.
But the F
Peter,
From: Peter Brawley <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Lieven De Keyzer <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: Multi-user bookmark system
Date: Fri, 06 May 2005 10:09:12 -0500
Lieven,
If a folder belongs to an account, why not use the account PK as a FK i
Hassan Schroeder wrote:
Mark Sargent wrote:
... but, my real query, now, is, why the configs/my.cnf were different,
Because there isn't any /etc/my.cnf created on your system by
default; you are responsible for creating one if needed, using
the examples in the ./support-files subdirectory.
Obviou
Lieven,
If a folder belongs to an account, why not use the account PK as a FK in
folders?
See http://www.intelligententerprise.com/001020/celko1_1.jhtml for ideas
about SQL representation of trees.
Peter Brawley
http://www.artfulsoftware.com
-
Lieven De Keyzer wrote:
I'm writing a web-appli
Thank you Gleb, I will try that out and let you know how I did..
Thanks again,
Anoop
On 5/5/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
>
> Hello.
>
> Remove mysqld-nt and install mysqld-nt-max. See:
>
> http://dev.mysql.com/doc/mysql/en/windows-start-service.html
>
> >jNo - mysqld-nt-max i
Oliver Hirschi wrote:
"Partha Dutta" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
You can turn off foreign key restrictions within your session:
SET SESSION foreign_key_checks = 0;
Then later, turn them back on using
SET SESSION foreign_key_checks = 1;
I saw, that the tables o
At 10:17 AM 5/6/05, Berta Alcala Larramendi wrote:
I'm doing an University project and I need to "buy" a server for a
business. I have to simulate an enterprise that sells by Internet. There
are many clients and products in the Data Base and we use MySQL in a Linux OS.
I need to find as much info
I'm writing a web-application that allows users to store their bookmarks.
Each user has a tree of folders (and bookmarks belong to these folders).
The only thing I want to do with tree elements at
the same level is display them, and let the
user only go up and down in the tree by one level. No aggr
On Thursday 05 May 2005 20:50, [EMAIL PROTECTED] wrote:
> To confirm that you would like
>
> [EMAIL PROTECTED]
>
> added to the mysql mailing list, please click on
> the following link:
>
> http://lists.mysql.com/s/mysql/427a791715a3ffed/filipe=ipb.pt
>
> This confirmation serves two purposes.
Hello,
I'm doing an University project and I need to "buy" a server for a business.
I have to simulate an enterprise that sells by Internet. There are many
clients and products in the Data Base and we use MySQL in a Linux OS.
I need to find as much information as possible about the hardware
requ
"Partha Dutta" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
> You can turn off foreign key restrictions within your session:
>
> SET SESSION foreign_key_checks = 0;
>
> Then later, turn them back on using
>
> SET SESSION foreign_key_checks = 1;
>
I saw, that the tables on my
Mark Sargent wrote:
... but, my real query, now, is, why the configs/my.cnf were
different,
Because there isn't any /etc/my.cnf created on your system by
default; you are responsible for creating one if needed, using
the examples in the ./support-files subdirectory.
Obviously the /etc/my.cnf on y
Hello,
Thank you! This is what I needed to do to get the server started. I
executed mysql_install_db as the operating system's root user which may
have been a mistake? That set the permissions on the 'mysql' database in
the data directory to root.root, causing the server to fail to start
when i
Thanks for the info. I did not know there was a GUI for the mysql product. I
installed it and its like Toad for mysql. Very cool.
As I am not very strong at using mysql, I am a J2EE developer. I came up with
two questions I need some more support with.
1). My home box does not have a static IP
Am Freitag, 6. Mai 2005 02.10 schrieb [EMAIL PROTECTED]:
> Forgive me if this question has been answer in the past.
>
> How can you record IP address on your first page index.html?
>
> I am using my index.html to be index.lasso, and client_ip tag does not
> seem to work.
> It is picking up my serve
Hello,
I have some problems using multiple queries in a databased driven project,
therefore I wrote a little testprogram which
causes the same problems.
I am using the C-API of MySQL 4.1.11 on a Gentoo Linux 3.3.2-r5,
propolice-3.3-7 with 2.4.27 kernel.
I connect to the server (on localhost)
Hello.
Remove mysqld-nt and install mysqld-nt-max. See:
http://dev.mysql.com/doc/mysql/en/windows-start-service.html
>jNo - mysqld-nt-max is not running - I can see in the task manager that
>jonly mysqld-nt is running!!
>jI also confirmed this by checking in my services - I only have
Hello.
Probably mysql_install_db wasn't executed due to SElinux restrictions.
Execute it is manually. Check that your data directory has the 'mysql'
database.
Robert L Cochran <[EMAIL PROTECTED]> wrote:
> When I installed MySQL-server version 5.0.4 on my Fedora Core 3 system
> (Linux x
Hello.
Are you sure that mysql.exe is the same version as the server?
Check if you're able to connect to 3.23.xx server using API. What value
does your MYSQL_SECURE_AUTH option have? See:
http://dev.mysql.com/doc/mysql/en/mysql-options.html
Nicholas Watmough <[EMAIL PROTECTED]> w
62 matches
Mail list logo
