Over the past couple days I’ve been tearing through the network I/O code inside of Drizzle. I moved anything that touched NET into the Protocol class (reading commands, preferences, error checking) and wrapped them with new Protocol methods. I then moved the NET structure out of Session (or THD for the MySQL folks) and into Protocol. At this point all network I/O was going through Protocol, which allowed me to do a proper abstraction layer with the old libdrizzle as a derived implementation class. The next step was to add in a new plugin hook for Protocol, and move the old libdrizzle implementation into a plugin. Since the server is the only thing using the old libdrizzle, all of that code also went into the plugin (note: this means the final death of old libdrizzle!). So now each new connection grabs a Protocol object from the default registered Protocol plugin and Session will use this anytime it …
[Read more]
EclipseLink JPA replaces TopLink Essentials as the JPA implementation
in GlassFish
v3. One of the benefits of using EclipseLink is that it
provides efficient pagination support for the MySQL
database by generating native SQL statements such as "SELECT ...
FROM <table> LIMIT <offset>, <rowcount>".
The MySQL LIMIT clause definition says:
The LIMIT clause can be used to constrain the number of rows
returned by the SELECT statement. LIMIT takes one or two numeric
arguments, which must both be non-negative …
EclipseLink JPA replaces TopLink Essentials as the JPA implementation
in GlassFish
v3. One of the benefits of using EclipseLink is that it
provides efficient pagination support for the MySQL
database by generating native SQL statements such as "SELECT ...
FROM <table> LIMIT <offset>, <rowcount>".
The MySQL LIMIT clause definition says:
The LIMIT clause can be used to constrain the number of rows
returned by the SELECT statement. LIMIT takes one or two numeric
arguments, which must both be non-negative …
Giuseppe Maxia and I are in the exact middle of our leg of the MySQL Campus Tour. Yesterday's session is was recorded -- A PDF of the slides can be downloaded at http://technocation.org/files/doc/2009_04_Tour.pdf (21 Mb).
The video is below:
Three great beta deliveries in one week!
MySQL Connector/.Net 6.0.2 beta, a new version of the all-managed .NET driver for MySQL.
MySQL Connector/C++ 1.0.4 beta, a new
release providing C++ API for connecting client
applications to the MySQL Server. If you know JDBC, this should
be familiar to you.
MySQL Connector/C 6.0.0 beta, a new
version of the C API for accessing MySQL database servers
Use them and let us know what you think.
Learn more about Connector/C++ here.
Learn more about Connector/C …
Three great beta deliveries in one week!
MySQL Connector/.Net 6.0.2 beta, a new version of the all-managed .NET driver for MySQL.
MySQL Connector/C++ 1.0.4 beta, a new
release providing C++ API for connecting client
applications to the MySQL Server. If you know JDBC, this should
be familiar to you.
MySQL Connector/C 6.0.0 beta, a new
version of the C API for accessing MySQL database servers
Use them and let us know what you think.
Learn more about Connector/C++ here.
Learn more about Connector/C …
After I yesterday checked the size of wchar_t on range number of platforms I decided to extend this to many more types. Again the same systems were used, a few more were added (MacOSX 10.5 x86 and x86_64 are the ones most used). The information is in pretty raw state bug my blog software is not able to present big tables correctly, thus I am going the raw way.
What is most interesting?
- long double varies a lot. Between 8 bytes (AIX 5.2 and 5.3 (ppc32/ppc64), Windows 32 & 64) through 12 bytes (Linux/FreeBSD/Solaris but not MacOSX on x86) to 16 byte (x86_64, ia64, hppa32, hppa64, ia64, ppc32/ppc64 (all MacOSX), sparc32, sparc64)
- Windows is missing few types
- MacOSX (10.4 & 10.5) doesn't have clock_id and timer_t
- time_t is 4 bytes on x86, ppc32, hppa32
- time_t is 8 bytes …
Hi,
MySQL Connector/Net 6.0.2, a new version of the all-managed .NET
driver for MySQL has been released. This is a beta release
and is intended to introduce you to the new features and
enhancements we are planning. This release should not be
used in a production environment.
This release was quickly pushed out due to a problem that caused 6.0.1 to not register with Visual Studio correctly. We also made a small correction to a previous bug fix. SQL generated from entity framework for stored procedures will now not directly reference the schema. This allows the model to move to a different database without need of change. We had previously made this change for tables but failed to do so for procedures.
It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.0.html] …
[Read more]
It's good to get out of the office and meet people. This year
I'll be doing several presentations at the 2009 MySQL
Conference and adjacent Percona Performance Conference in Santa Clara.
These include among others a talk on Tungsten Replicator on Thursday April 23 at
10:50.
In case you don't read this blog regularly, Tungsten Replicator provides advanced open
source replication for MySQL. The term "advanced" is not an
exaggeration. I'll be covering how to solve practical problems
including the following:
- How to install and configure Tungsten Replicator in 5 …
Introduction
DBT2 is a TPC-C like benchmark tool supporting MySQL. The results of a test run include transactions per minute, CPU utilization, I/O activity, and memory utilization. The DBT2 test kit can be downloaded from the DBT sourceforge site. The purpose of this document is to show how to use the virtualization technology: Solaris container to scale-out multiple mysql instances on the Sun's CoolThreads server.
Hardware and Software configurations
Sun SPARC T5240 Server: 2x8-core UltraSPARC T2 Plus(1165 Mhz,128 Threads) Processor; 64GB RAM; 2x146GB Internal Disk
Database: MySQL 5.1.30
Operating System: Solaris Express Community Edition snv_98 SPARC
Test Case 1: Single MySQL server on T5240 in 32 warehouse DBT2 Test …
[Read more]