During the Collaborate 11 conference in Orlando Florida, on Tuesday April 12 from 10:15 to 13:00 I’ll be at the Oracle “DemoPod”. I’m told that this is in the Oracle booth, which is Booth#657 at the back of the exhibit hall.
On Wednesday April 13 from 13:00 to 14:00 my talk is “MySQL Oracle and ANSI Syntax”. Session ID = 431. Room = 310A, subject to change. Sorry, Trudy Pelzer won’t be a co-speaker, I’ll be doing this one alone.
Object oriented programming makes it all doable: Setting up a
base class for a connection object, and deriving child classes
for specific database vendors.
HeidiSQL now introduces experimental support for MS SQL in
r3735. How that works? Seamless:
- In the session manager, chose the new network type "MSSQL" and
specify the hostname, user and password. All other settings are
unused for MS SQL.
- As HeidiSQL allows to have multiple connections open at once,
you can of course connect to a MS SQL server and at the same time
to some MySQL server.
- Table data can already be edited (INSERT, UPDATE, DELETE)
- Structure editors like the table editor are highly incomplete
yet, just shows a part of the column definitions.
- Once all MySQL specific stuff is abstracted into the above
mentioned objects, you will be able to do an SQL export from …
Object oriented programming makes it all doable: Setting up a
base class for a connection object, and deriving child classes
for specific database vendors.
HeidiSQL now introduces experimental support for MS SQL in
r3735. How that works? Seamless:
- In the session manager, chose the new network type "MSSQL" and
specify the hostname, user and password. All other settings are
unused for MS SQL.
- As HeidiSQL allows to have multiple connections open at once,
you can of course connect to a MS SQL server and at the same time
to some MySQL server.
- Table data can already be edited (INSERT, UPDATE, DELETE)
- Structure editors like the table editor are highly incomplete
yet, just shows a part of the column definitions.
- Once all MySQL specific stuff is abstracted into the above
mentioned objects, you will be able to do an SQL …
Ronald Bradford will be presenting at two conferences in April, the O’Reilly MySQL Conference and the IOUG Collaborate 11 conference. His presentations include:
User fired queries in a query tab are now processed in a separate
thread, which makes the GUI responsive while you run a longer
query. Many users asked for that in issue #1509, which is finally fixed now. However,
there is one follow up issue, caused in one specific scenario -
will be fixed soon. Please update to the latest build to check
that out (Help > Check for updates).
Second thing is I am searching for a new logo image, including an
application icon in sizes of 16px, 32px and 48px. As a
non-designer, I recently tried out some of my own ideas but in
the end they all feel slightly wrong and ugly. If you have a good
idea or even like to create a logo for HeidiSQL feel free to
comment and attach files on issue #2332. The new logo should contain some
green …
Ronald Bradford will be speaking in New York on March 22nd at the offices of the startup incubator General Assembly starting at 6pm.
His presentation “How better indexes save you money” will be an enlightening experience about how index only improvements to already indexed queries and with no additional code changes resulted in huge performance improvements and significant savings in hosting costs for a client.
More information available at Meetup.com EffectiveMySQL Group.
David Stokes mentioned yesterday that the mid-April Orlando Florida “Collaborate 11″ conference has many MySQL-related sessions.
I (Peter Gulutzan) emphasize these session titles, presenters,
and what they represent:
MySQL 5.5 Replication by Lars Thalmann (MySQL replication
team)
InnoDB: Performance and Scalability Features by Inaam Rana (MySQL
InnoDB team)
MySQL Backup and Security - Best Practices by Lenz Grimmer (MySQL
community team)
InnoDB: Status, Architecture and Latest Enhancements by Calvin
Sun (MySQL InnoDB team)
Sharding Techniques for MySQL by Mats Kindahl (MySQL replication
team)
When Things Go Wrong: How to Find SQL Error by Sveta Smirnova
(MySQL support team)
MySQL, Oracle and …
Cloud, cloud, cloud. Cloud computing has become the phrase du jour, says one analyst from Gartner. But with many moving to cloud for its obvious benefits, it can no longer be ignored. An offshoot of cloud computing is utility computing. What interests us here is Database-as-a-Service, in particular MySQL on cloud.
Coming back to our original question – Is your MySQL monitoring tool cloud ready? Well, many monitoring tools need agents on server to be monitored. For obvious reasons database-on-cloud vendors don’t allow one to install anything on the servers. With Amazon launching RDS (which is nothing but MySQL instance on cloud) there is a pressing need for tools that …
[Read more]Monty Widenius has announced that Trudy Pelzer's and Peter Gulutzan's reference book "SQL-99 Complete, Really" is now available on the askmonty.org knowledge base http://monty-says.blogspot.com/2011/01/sql-99-complete-really-now-freely.html Of course I agree with Monty's praise of our book, but remember that for more current SQL-standard information I occasionally post here on blogs.mysql.com/peterg.
When you have an .sql with a huge number of single INSERT
statements, such as this:
INSERT INTO mytable (id, name, ...) VALUES (1, 'foo', ...);
INSERT INTO mytable (id, name, ...) VALUES (2, 'bar', ...);
INSERT INTO mytable (id, name, ...) VALUES (3, 'xyz', ...);
...
Such dumps take quite a long time to import normally, as there is
a significant overhead per query, multiplied many times for large
dumps. HeidiSQL now can package such statements into one larger
multi statement query and send this at once the server. As I was
testing 4000 INSERTs on a local, simple table I experienced a
huge performance improvement:
- single queries: ~40 seconds
- one packaged multi stament: <1 second.
HeidiSQL automatically calculates a package size of some kb below
your max_allowed_packet size. Which is in some cases not small
enough as I noticed connection cut offs as I sent …