Alfresco has a seminar next week in Munich, on Tuesday 26.6.2007 17:00-20:00 at the Hotel Excelsior close to Stachus. I’ll be talking about MySQL’s relationship to its communities.
I’m looking forward to meeting our joint users, and learning more about Alfresco Enterprise Content Management — including the case study from the Swiss Federal Court.
So you ran into some basic limitations with MyISAM when your site got busier. Even single row updates would lock the whole table and slow things down to a crawl. Then you updated to InnoDB to get the benefit of row-level locking, but now the site is even slower than before. What gives? Well, we [...]
I’ve been able to steal some more time to work on my script following My ?hourly? MySQL monitor script Version 0.03 almost a month ago.
The purpose of this script is simple. Create an hourly ‘cron’ job that records and monitors information against the OS and MySQL Server. This is most helpful when environments simply don’t have any monitoring in place. I’ve found it very productive when running a benchmark on site to simply enable for an hour. An amount of analysis is required, but I at least have a baseline of data collection. That is the first goal.
So hourly.0.05.tar.gz is taking some shape, and has the following new features:
Or, Why is My Transaction So Big? My team and I still use old-style rollback segments for one of my client’s 10g production databases. We just never found the need to switch to automatic undo management. There are a number of 1GB rollback segments. They are that size because they need to be able to support [...]
somewhere in these 1.6GB of debug log files and signal traces… somewhere… really.
It was just a matter of time. But eventually, it was bound to happen. Some in the industry have been playing fast and loose with the term "open source," and yesterday Michael Tiemann, president of the OSI, cried 'Foul!' on his blog. As Michael writes:
Starting around 2006, the term open source came under attack from two new and unanticipated directions: the first was from vendors who claimed that they have every bit as much right to define the term as does the OSI, and the second was from vendors who claimed that their license was actually faithful to the Open Source Definition (OSD), and that the OSI board was merely being obtuse (or worse) in not recognizing that fact. (At least one vendor has pursued both lines of attack.) This was certainly not the first attack we ever had to repel, but it is the first time we have …
[Read more]
While upgrading fom MySql 3 to Myql 5 our only real problem was
with merge tables. We have two in the system, both did not work.
Createing the merge table did not give an eror, bt when we tried
to select from it, we get the error message 1168:
Unable to open underlying table which is differently defined or
of non-MyISAM type or doesn't exist
This kind of error message gives my the creeps. Or?? Why doesn't
it say which one of the cases it is? Surely these are three
different cases and it should be easy to separate them. Is it
difficult to add error messages to MySql? Or a lazy
programmer??
OK, we try to look at the table definition i MySql's own tool the
Query browser. But if you try to do 'Edit Table' in the Query
Browser, you get the following error message:
A MySql eror message was encountered. The eror message is:
Cannot fetch table information
The following error occurred:Unable to open …
I somehow totally missed this thread , started and summarized by Jeremy Cole on the death of Raid ..
In Yes Jeremy, RAID Really Is Dying Kevin Burton makes a good point ..
Most large scale out shops should probably be using a redundant array of inexpensive servers.
or RAIS , the difference between a Redundant Array of Inexpensive Servers an Inexpensive Disks being that you don't need expensive Controllers for the Inexpensive Servers .. This is exactly what I have been telling people for a while now..
In the summary posting Jeremey also points out
data partitioning is the only game in town, cache everything, and use MySQL replication for high availability and redundancy.
…
[Read more]
It seems that its very popular right now for people to say what
their top 5 or 10 wishes are for MySQL Server. Many people who
have chatted with me are well aware of a small collection of
mine. Guess what? I have no plans to iterate through them
here.
I personally don't believe it is particularly productive. MySQL
is a company with a lot of smart people and almost every one of
them will have their own distinct and unique wish list. For a few
to have their wishes set above the rest could drive a wedge in
the works. Of course, a small number of senior officers of the
company to broadcast their opinions (Mårten, Monty, etc) is
perfectly reasonable - they are expected to have a public vision
- wether it be purely their own or distilled from the collective
of the company. So where should we espouse our heart felt
opinions? The WorkLog RawIdeas acts as a voracious black hole
from which few ideas ever escape to fruition. Perhaps the
internal Wiki …
So Vista has this "great" new feature called UAC which allows a user to run as a standard user until he or she needs elevated permissions at which point the system will prompt either for an administrator's password or for your consent if you are already an administrator. Everyone seems to generally hate it but we seem to be stuck with it. In any case, that's not what this post is about.
Those of you who are software developers know that we often need to set environment variables for ourselves. We use BitKeeper for source control so I need a BK_USER environment variable. I also often need to add things to my path. So what could be wrong with this? Oh, let me count the ways.
First, environment variables for the currently logged on user are not properties of the computer. Computer properties would be computer name, description, performance settings, etc. However, the first way you …
[Read more]