This is cool, although I haven't used it so it will have to be a theoretical coolness.
A few months back Anders Karlsson posted a UDF and accompanying application for debugging stored procedures on sourceforge. The idea is that you can insert statements into your stored procedure for debugging purposes. The statements use a UDF that sends UDP messages to a debug server (provided with the UDF) to allow you to discover information about what is happening as your stored procedure is executed.
I can relax now, My talk is done and I’ve been talkinq to people about more specific things. Several have congratulated me on it.
Looking forward to the BOF, although sleep would be nice.oh how I’m going to sleep on the plane
Why is this needed?
“world” database current sample is 3 tables, cities, countries
and langs.
Not the Intellectual Property of MySQL, so it can’t be bundled
with the software
No table type diversity, not a lot of data type diversity
No MySQL 5 features
Not a lot of data
Not really used in tutorials and articles because it’s not robust
enough
Scenario
Basically, needed a sample database that was new, that allowed
for many queries.
Used an idea from a Dell Sample DB
It’s 2 stores, in 2 different countries.
Designing the Database
Designed with MySQL Query Browser
Normalized
Community provided feedback and content
Trick was balance between simplicity and completeness
Learning db, so people need to understand it
After schema was approved, data was loaded
Stored …
MySQL Users Conference 2006, SANTA CLARA, Calif. - MySQL AB today announced plans for a certification program for the many powerful database storage engines being developed for its flagship MySQL database server by third-party partners and the open source developer community. Several industry-leading companies -- including Innobase OY (a subsidiary of Oracle Corporation) and Solid Information Technology -- are supporting the new program by joining MySQL AB in producing open source engines for the millions of MySQL database users worldwide.
Today, a few days later than originally planned and after 91 days in beta testing, the new version of XAMPP for Linux and Windows is ready for downloading. The major updates in this version are PHP 5.1.2 and 4.4.2, MySQL 5.0.20, eAccelerator 0.9.4 and phpMyAdmin 2.8.0.3.
Find more details on the specific XAMPP project page.
I am at the scale out panel where DBA gurus from Technorati,
MySQL (Brian Aker), Google and Yahoo! are answering questions
about scaling.
Some Windows based sites are storing up to 30-40 TB of data using
MyISAM tables. That site is masochist.com (joke)
A question was asked whether the date in database should be
stored as formatted or stored as time only and then formatted by
application. The answer given was (the room was jam packed so I
couldn't see the faces) that optimization like this should be
done at the end. At first, you should try to add indexes where
ever needed. Once all the indexes have been added, only then we
should move with other smaller optimizations.
Power consumption having effect on business as you scale
out?
There is power, power per watt etc. Power is huge concern for us
(Technorati).
Some CPUs use a lot less power than others. At Yahoo! and Google,
power is a …
In having a discussion with Paul McCullagh (the creator of PBXT transactional storage engine) and Taneli Otala MySQL AB CTO after the keynote presentation at the MySQL User Conference, Taneli made the following comment (paraphrased and reproduced with permission).
“I talk about PBXT in discussions shamelessly. The development of PBXT was excellent timing in the MySQL community landscape”.
It was an excellent commendation that MySQL AB management considered so highly the contributions from the community. As mentioned in the opening keynote, MySQL with the Storage Engine API with MySQL 5.1 has great potential to expand what options are available to user of MySQL.
Good work Paul. I like many others wish you the best in your continued development and contribution. …
[Read more]Just a warning to everyone that I will not be posting many blog entries from the UC today, my laptop is suffering from an unknown issue that I need to diagnose and repair before I can do any work from it.
On the bright side there is a great blogger contingent here this year and there is plenty of content to go around.
Session attendees: I will get content online as soon as I can.