Ops Mantras (as made popular by Dormando).
I've been doing this shit for a while now. I'm presently acting
as a MySQL DBA for SixApart, but these views are mine and not of my
employer. This is an omega post of all of the generalized one off
mantras I find valuable when approaching operations management.
Even if these end up being idealistic, my humble view is to shoot
for these and you'll be better off with what you end up
with.
It's uh, long, sorry. This _was_ inspired by another post which
I'll not be direct linking. Aside from the list-style, I've not
stolen anything else. The Mantras are broken up into major
sections:
- The Technical Element
- The Human Element
- The Practice
The Technical Element
Design for change
- The old google mantra is right. Design for change. Change is
having to deploy new software, upgrade …
i am listed as one of the ten members of the php group.
most of the php source code says it is copyright “the php group”
(except for the zend engine stuff). the much-debated
contributor license agreement for PDO2 involves the php
group.
could i assign whatever rights (and responsibilities) my
membership in the php group represents to someone else? how much
should i try to get for it? i mean, if mysql was worth $1
billion....
i am still disappointed that a way of evolving the membership of
the php group was never established.
A
In the first article on IP to location I described the overall concept. In this edition we'll look at the implementation and how to scale the tracing to a reasonable speed.
With the examples from the last article you can also implement everything to build your own database. Before you jump into it take a minute to look at the implications.
Taking the example from the previous article
217.80.0.0/12 for the German Telekom we have to
trace 1mio addresses and scanning them all will take a while:
# time traceroute -w 1 -m 8 -q 1 217.80.0.1 traceroute to 217.80.0.1 (217.80.0.1), 8 hops max, 40 byte packets 2 217.0.72.230 36.974 ms 3 ke-eb1.ke.de.net.dtag.de (62.154.98.82) 54.454 ms 4 217.0.74.213 54.610 ms 5 * * * 6 * * * 7 * * * 8 * * * real 0m3.244s
If we can make the make …
[Read more]
Guess what ? I also will be speaking at MySQL Users Conference
2008, which is always excited.
According to session schedule I'll have one talk about
Innodb Scalability Limits and another one together with Andrew
Aksenoff about Sphinx.
Looking back at Proposals (+1) I'm surprised only one talk was chosen and also this particular one.
May be I should put more effort into detailing advance session description - I normally tend to provide good choice of topics to conference organizers without too many details, working these out only when we know which sessions are of potential interest. Well perhaps with …
[Read more]News Summary - Jan 27th to Feb 3rd, 2008
|
• Community - and
… |
|
Monty has started blogging and has announced the Early Release of the sources and Specs for Maria (aka MyISAM++). Also check out comments from Guiseppe (the Data Charmer) and from the Performance blog. Maria and Falcon are the two newest … |
A
Ran DBT2 with the following:
[root@localhost scripts]# ./run_workload.sh -s100 -c 16 -w 20 -t 32 -d 1200 -n
Here are the results ( This beats a lot of other benchmarks I have seen with 8 core machines & regular disk ). This is an innodb test, with the ibdata file on 1 mtron drive and the log files on another. The test does not really show the mtrons ability though., simply because the dataset is only 20 warehouses they all fit into memory. So far I have seen 18K TPM on a 300 warehouse run which stresses the disk more. Anyways here are the results:
Response Time (s) Transaction % Average : 90th % Total Rollbacks % ------------ ----- --------------------- ----------- --------------- ----- Delivery 3.81 0.656 : 0.741 50043 0 0.00 New Order 42.61 0.607 : 0.681 559699 5569 0.99 Order Status 3.79 0.592 : 0.665 49792 …[Read more]