Part 5 of "Managing MySQL on Solaris 10" series will be published later

In Solaris, a process can be in any of the following states during the course of its execution.

O Running
S Sleeping
R Runnable (in dispatch queue)
Z Zombie
T Terminated
C* CPU

Using uptime to get quick summary statistics

-bash-3.00$ uptime
 2:18pm  up 119 day(s), 12:38,  56 users,  load average: 1.00, 0.84, 0.81

[root@db:/] uptime
 2:19pm  up 194 day(s),  1:59,  16 users,  load average: 16.64, 11.16, 13.32

When the competition for processor and other resources gets intense, the processes start getting increasingly delayed. We can see that on the db server, at the time of run queue being sampled, there were between 13 to 16 processes waiting to run (ready for CPU).

What processes are …

Yes, after few hours our 2 contries will become members of the European Union. I would like to send a European greeting to Lucian and Andrei and to all bulgarian and romanian bloggers.

Bine ati venit Europa !
????? ????? ?????? !

Bulgaria
Bulgaria established diplomatic relations with the EU in 1988. In 1993, the European Association Agreements signed and it entered into force in 1995.

In December 1995 Bulgaria submitted its application for EU membership in December 1995. The Commission presented its first Regular Report on Bulgaria’s progress towards accession in November 1998. The second report, released in 1999, recommended that formal negotiations are opened.

Accession negotiations between Bulgaria and the EU started on 15 February 2000. Sofia …

I was walking down Mountain View's Castro Street this afternoon, and noticed that meebo is advertising for developers and system admins. Interestingly, they seem to match the design pattern used by pretty much every web 2.0 company I have seen around here (except MySpace): linux, MySQL, and Ajax. So, there you go.

Tags for this post: mysql web 2.0
Related posts: Managing MySQL the Slack Way: How Google Deploys New MySQL Servers; I won a radio shark and headphones!; …

Fotolog is the top 28th site in the world, according to Alexa rankings today, and, ofcourse, it uses MySQL :)

The last couple of weeks have been fantastic, I’ve learned and discovered so many new things that I haven’t been able to write about any of them. So, I’m going to combine many things into a single post!

Item: I have a new job. After working at the fabulous MySQL for most of 2005 and 2006, I’ve given up my post as Director of Development to take on a new challenge at Canonical Ltd. Canonical is associated with Ubuntu Linux, the Bazaar distributed revision control system, and the launchpad.net collection of services for products in the open source universe. Working for Brian and more recently …

On one of my servers today I noticed some DELETE statements that had been running for more than 14000 seconds due to system locks.

Queries: 180.2M  qps: 1294 Slow:  173.3k         Se/In/Up/De(%):    09/02/33/00
             qps now: 2065 Slow qps: 8.1  Threads:  463 ( 225/ 738) 06/01/49/00
 Cache Hits: 610.9k Hits/s:  4.3 Hits now:   4.1  Ratio:  3.9% Ratio now:  3.3%
 Key Efficiency: 99.2%  Bps in/out: 134.7k/ 1.5M   Now in/out: 203.9k/ 1.3M

      Id      User         Host/IP         DB      Time    Cmd Query or State
      --      ----         -------         --      ----    --- ----------
18951229       www   192.168.1.170     fl_db1     14516  Query DELETE FROM user_
19003358       www   192.168.1.107     fl_db1     14273  Query DELETE FROM user_
19014485       www   192.168.1.105     fl_db1     14221  Query DELETE FROM user_
19117224       www   192.168.1.109     fl_db1     13733  Query DELETE …

To say I have a lot of books is too under value the phrase "a lot".

At last move I had more then 36 crates of books, that was three years
ago. Today? I am not sure, though I have started to catalog all of
them with Delicious Monster.

I even bought the bluetooth barcode scanner :)

Delicious Monster just uses Amazon, so I am at the mercy of Amazon's
database. At this point I have almost all of my computer related
books cataloged (missing about 90 books that I need to complete), and
all of my graphic novels. This means I haven't touched my geology
text books or my science fiction collection.

The problem?

ISBN and UPC.

Namely, Amazon isn't a complete repository. Sure, it misses some
graphic novels, but it has also missed about a dozen O'Reilly
…

Just came across interesting and really disturbing information about MySql :

As you might noticed there are no recent MySQL Community versions available for download from MySQL Download Area This applies both to binaries (which is expected with new polices) but also to the source files which were promised to be available.

So what is if you would like to use recent MySQL code while staying with community version ? I chatted with Monty on this topic today.

So, if you need mysql binaries for new versions you have 2 options:

1. Use your distribution vendor’s builds (in Gentoo, Ubuntu and Debian)
2. or Build your own binaries from …

The yearly PHP community summaries are already appearing throughout the blogosphere. Every year they just get better and better and it becomes clear that the PHP community's accomplishments outshine those of the previous year.

PHP for many years has been the leader in Web development. In the past couple of years though this leadership has become even more noticable. Evans Data Corporation has estimated that over 4.5M developers worldwide use PHP today. Not only is that an impressive number on its own, but when you dig into the numbers you can see that in 2007 PHP is expected to surpass Java in areas like Europe; and that includes all permutations of Java usage including in environments where PHP doesn't attempt to be relevant such as the desktop.

2006 has clearly been a very exciting year for PHP. It comes at a time where the Web, Web applications and Web services …