It's past 7 o'clock in the morning, but this night has been a
productive one (hey - no bad thinking please ;-)).
I have updated db4free.net to the latest MySQL 5.1 development
source version (5.1.12-beta) and discontinued the 5.0 server. The
"former" 5.1 server which ran on port 3307 is still alive, but no
new accounts are being created there anymore. During the next
days I plan to make the databases that run on the port 3307
server accessible on the main 5.1 server (with standard port
3306) to have everything together on one server - and let the
port 3307 server die.
Before the update, most users have only used the 5.0 server, but
only a little number of users did anything on the 5.1 server. My
intention is to test 5.1 more intensively under a higher load and
I hope that this also helps to contribute to the development of
MySQL 5.1 by finding bugs or other flaws on a …
It's been some time since I last blogged. I've been quite busy
erasing all the
bugs from the partitioning implementation in MySQL 5.1. At the
moment
there is 1 bug left in review and a few on its way into the main
clone. The
rest of the bugs are fixed and already in the 5.1 clone. So the
next 5.1
release (5.1.12) will have partitioning ready for tough tests. So
if you have
been waiting for partitioning to stabilise it's time to try it
out now with your
application and see how it works.
I watched an interesting animation my daughter made about how
partition
pruning using dynamic PowerPoint slides. Really interesting to
see what can
be done if one knows how to handle these types of tools. She's
quickly
becoming our family authority on presentations.
Lately we've also started working on some extensions for the
partitioning
hopefully ready for 5.2. We …
What format do you use to store data during transport?
I had a problem, I needed to pull data from one website system,
into another. Where is the data? Its in MySQL, so I decided to
skip the API for the system I am exporting the data from and
instead just extracted the data from the database (and yes... I
will use the API for reinserting the data... I don't want to
break the business logic of the new system).
That was an easy decision.
Then I asked myself, what do I store the data in during the
conversion? I needed some format because the old web site is not
kept on the same system as the new. So I was going to need a flat
file for a bit of time.
The first answer that came to mind?
XML!
So for the last couple of weeks I have been thinking about how I
was going to design the XML schema. Not putting a lot of thought
into this, just jotting down notes in my …
As you might have recognized already, I love to take a look into
the Change logs from time to time and hope to find some goodies
there. Here's an especially nice one in the Change log of
5.1.12:
INFORMATION_SCHEMA contains new tables, GLOBAL_STATUS,
SESSION_STATUS, GLOBAL_VARIABLES, and SESSION_VARIABLES, that
correspond to the output from the SHOW {GLOBAL|SESSION} STATUS
and SHOW {GLOBAL|SESSION} VARIABLES statements.
This was reason enough for me to compile MySQL 5.1 from source
and take a look:
Welcome to the MySQL monitor. Commands end with ; or \g.[Read more]
Your MySQL connection id is 3 to server version: 5.1.12-beta-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use information_schema
Database changed
mysql> show tables;
+---------------------------------------+
| Tables_in_information_schema | …
Okay, so maybe I went a little overboard. But having switched to RSS in order to better interact with
the MySQL
forums, I seem to have embraced this new way of having
content delivered to me whole-heartedly. Of course I added all of
the available forum feeds immediately, but then also I added
feeds to Planet MySQL as well as some of the constituent
blogs directly, also a few NASA blogs and some from family&friends,
well, before I knew it the list of feeds has stretched the entire
height of my monitor, and I have a 21.3" monitor turned into
portrait orientation.
I have to admit, I like staying on top of things and having my
feeds polled at 15 minute intervals. I may have to figure …
I’ve had an introductory article to MySQL Cluster 5.1 Disk Data published in the September 2006 issue of International PHP Magazine.
If you’re using Cluster or you’re interested in doing so, and you’ve not yet tried out MySQL 5.1, you’ll find that disk data storage makes MySQL Cluster more flexible, scalable, and cheaper to run than MySQL 4.1 and 5.0 Cluster. In the article, I’ve outlined some reasons why this is so. The article covers the basics of creating disk-based Cluster tables, and discusses some Disk Data do’s and dont’s. There’s also some info about some other improvements to MySQL Cluster that are being made in 5.1, as well as some diagrams and sample PHP5 code for accessing a MySQL Cluster. Just in case you’re not that familiar with setting up a MySQL …
[Read more]Over on the MySQL Index Analyzer site I have just released version 0.04 as a downloadable package.
This is the first GUI version that allows real analysis and has more features than the command line version.
A quick overview of what is new:
- Swing GUI
- Analysis features as on the command line
- Copying of generated ALTER TABLE statements to the clipboard
- Information on data and index size distribution
- Rudimentary analysis of possible disk space savings
So go have a look :)
Not so long ago Solid released solidDB for MySQL Beta 3 so I decided now is time to take a bit closer look on new transactional engine for MySQL. While my far goal is the performance and scalability testing before I wanted to look at basic transactional properties such as deadlock detection, select for update handling and phantom reads in the repeatable read isolation level.
Solid has OPTMISTIC (default) and PESSIMISTIC concurrency control, so it was interesting to test both.
We used default isolation mode which is REPEATABLE-READ for this test.
Test 1: Solid, deadlock detection, default (OPTIMISTIC) concurrency control.
PLAIN TEXT SQL:
- CREATE TABLE `test2` (
- `id` int(11) NOT NULL,
- `names` varchar(255) DEFAULT NULL, …
Steve Hamm has a great blog entry on Alfresco and other open source (and SaaS) companies that are destroying the incumbents in markets they founded in the first place. Alfresco, of course, we founded by John Newton, who founded Documentum (and, hence, the document management industry). Now Alfresco is cannibalizing that same market.
There are other examples. Paul Doscher and JasperSoft. John Roberts and SugarCRM. Etc. Many open source business managers formerly ran huge swaths of the proprietary market.
I'm just waiting for Larry Ellison to give up his day job at Oracle to get a job at MySQL....
ADVERTISEMENT
…