What about a baseline of benchmerks for common, recent hardware using
the sql-bench tools?
I can't find anything like that- It would be nice to know how my
setup/server compares to other servers of the same or similar
ability.
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On F
mind, as the mysql settings are no longer
included in the primary php.ini file but in 34_mysql.ini.
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Feb 10, 2004, at 10:34 PM, Don Read wrote:
On 11-Feb-2004 Eric W. Holzapfel wrote:
Hello Listers,
I have a problem with my PHP/redhat s
On Jan 31, 2004, at 1:09 AM, Adam Goldstein wrote:
On Jan 30, 2004, at 10:25 AM, Bruce Dembecki wrote:
On Jan 28, 2004, at 12:01 PM, Bruce Dembecki wrote this wonderful
stuff:
So.. My tips for you:
1) Consider a switch to InnoDB, the performance hit was dramatic,
and it's
about SO much
timeout = 20
net.ipv4.tcp_keepalive_time = 2000
net.ipv4.tcp_sack = 0
net.ipv4.tcp_timestamps = 0
vm.bdflush = 50 1000 64 256 1000 3000 60 20 0
net.ipv4.tcp_wmem = 4096 16384 262143
vm.max-readahead = 512
vm.min-readahead = 10
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
--
MySQL Gener
not
forget that even those are out of date the moment the backup is done ;)
Replication is your best friend, next to your Dog of course,
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Jan 30, 2004, at 11:50 AM, Mauro Marcellino wrote:
By open file tool I mean software that works
On Jan 28, 2004, at 12:01 PM, Bruce Dembecki wrote this wonderful stuff:
I don't think there would be any benefit to using InnoDB, at least not
from a transaction point of view
For the longest time I was reading the books and listening to the
experts
and all I was hearing is InnoDB is great becau
average of ~1.3Mbs & 1.0 Mbs, with
peaks to 5.7Mbs/5.0Mbs (I dunno is the below graph will make it through
the list...). This graph is from the Apache/php server.
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Jan 28, 2004, at 11:33 AM, Brent Baisley wrote:
The split setup
epair scripts feature the flush.
But, none of this yet explains why testing from the linux box using the
remote G5/mysql server (over only 100Mbit switch) gives better results
than testing directly on the server.
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Jan 27, 2004, at 9:45 AM,
on the graphs suggest easily 25-150% more, plus the amount more that
would come if the site could handle them and they were happy. (We all
know web users are a fickle bunch, and will drop a slow loading site
like a hot potato.)
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Jan 26, 2
again, just to be sure, as
that'innodb_buffer_pool_size = 70M' entry seems valid.
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Jan 26, 2004, at 9:07 PM, Kev wrote:
I just installed the server logistics package of mysql 4.0.15 and am
getting
the following error entry in
Fink works excellent for DBI, and even for mysql. You can also change
the mysql.info file to add compiler options, like G5 optimizations,
openssl, etc.
http://fink.sourceforge.net/
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Jan 26, 2004, at 8:50 PM, tait sanders wrote
phpMyAdmin also give a nice, simple frontend for doing this... copy
tables or db's with/without data.
Personally, I don't think mysql should be used on a box without
phpMyAdmin on it, at least as a backup admin tool;)
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Ja
filesystems... such as Linux 2.4 w/reiserfs?
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Jan 26, 2004, at 11:49 AM, Gabriel Ricard wrote:
2GB was the per-process memory limit in Mac OS X 10.2 and earlier.
10.3 increased this to 4GB per-process. I've gotten MySQL running with
3GB of R
ad
balancing, but, that was quickly discarded for subdomain/site topic
separation. It can handle only about 20% on the main server's userload
it seems. (php files reside local on it, all images are served via main
server/thttpd, some dynamic includes are done via NFS mount to main
serve
limits of the underlying OS. This means file sizes, memory
allocation and whatever else. Have you heard of anybody allocating
more the 2GB using OSX? I've heard of quite a bit more using Linux or
other Unix flavors, but not OSX.
As for optimizing settings, you need to profile you work loa
of
expensive ram), does anyone have any advice for optimizing the
settings? Or are they pretty optimized as it is? (according to
benchmarks, anyways)
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Jan 26, 2004, at 10:13 AM, Brent Baisley wrote:
You may be hitting an OSX li
2 wallclock secs (33.21 usr 7.03 sys + 0.00
cusr 0.00 csys = 40.24 CPU)
wisconsin: Total time: 8 wallclock secs ( 5.00 usr 0.49 sys + 0.00
cusr 0.00 csys = 5.49 CPU)
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What kind of my.cnf file are you using with that setup?
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Jan 8, 2004, at 2:48 PM, [EMAIL PROTECTED] wrote:
We moved our main production server to a dual opteron last night,
running SuSE 9.0 x86_64 (kernel 2.4.21), and the binaries mysql
Any word on G5/64bit compiles of mysql?
I know I am not the only one wanting to know Does it work, and How to
compile best for it.
or am I alone in the universe?
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
I posted this before, "Subject: 64bit G5 Panther compiles" but
received no reply.
Is there any answer yet for the ability to compile a working, 64bit
Mysql on OSX Panther?
Would you use GCC compiler flags-mpowerpc-gpopt and -mpowerpc64 ?
--
Adam Goldstein
White Wolf Net
eed it to be the fastest model, using the least resources but be
stable... able to handle as many requests/sec as possible. Sort of a
"High Performance" fork of the Apache2/php/mysql set. Mysql being the
most important. ;)
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
--
M
21 matches
Mail list logo