Topics for this podcast:
*Microsoft founds CodePlex Foundation, losing Sam Ramji
*Software patents at the center of MS, OIN maneuvering
*Eucalyptus Systems releases hybrid cloud product
*Oracle-Sun Microsystems and the potential fate of MySQL
iTunes or direct download (26:40, 6.1 MB)
Citrix joins the Linux Foundation. BonitaSoft raises $3m. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca
“Tracking the open source news wires, so you don’t have
to.”
# Citrix joined The Linux Foundation.
# Open source BPM vendor BonitaSoft raised $3m from Ventech and Auriga Partners.
# Jaspersoft updated JasperReports Professional with enhanced data visualization.
# US CIO Vivek Kundra outlined the government’s cloud strategy, using NASA’s open source Nebula cloud.
# Infobright …
[Read more]
We’re happy to announce the availability of the next Alpha
release of MySQL Workbench 5.2. There have been further
improvements to the querying part and we added the
foundations for the administration part (which will be
onboard in the next alpha).
On startup, MySQL Workbench 5.2 now doesn’t automatically create
a new design-document anymore – thats for decreasing
resource-usage when you only launch Workbench for running a
few queries against your database. Also the fix to make Workbench
work on Snow Leopard has been included in 5.2 now as well.
Please download the program, take it for a test-drive and tell us
what you think. But keep in mind, that this is still an
alpha version – so be advised to not use it for production
data! Also please note, MySQL Workbench files saved with
version 5.2 cannot be opened with previous versions of our
program.
For Linux we now …
[Read more]Before I even start this post I am going to repeat our view that Oracle is well aware that it has little to gain from killing off MySQL and that we expect MySQL to become the scale-out database for non-transactional web applications and to compete with SQL Server in departmental deployments.
That said there has been some interesting discussion on Twitter
this week in response to the European Commission’s investigation
of Oracle-Sun about whether Oracle could - in theory - kill off
MySQL. Here’s a Q+A explaining my view as to how Oracle could
kill MySQL but probably won’t, and why MySQL AB’s choice of dual
licensing and the GPL has come back to haunt Monty
Widenius.
Q. Oracle can’t kill MySQL even if it wants to, because its open
source. Right?
A. …
[Read more]Following the release of our report, ‘The Myth of Open Source License Proliferation’ and during research for it, we heard and sensed a feeling that open source software licenses had evolved to become a generally well-accepted piece of the the enterprise IT and IP market. However, we also heard from numerous vendors, developers and other individuals that the next battlefront is obviously software patents, which are in need of reform, according to many supporters of free and open source software.
This week, we saw some of the software patent skirmishes that are driving and validating this thinking. There was first news that the Open Invention Network, the consortium dedicated to legal and IP defense of Linux, had bought some software patents that related to …
[Read more]CodePlex, patents and Linux code. An interesting few days for Microsoft open source.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca
“Tracking the open source news wires, so you don’t have
to.”
CodePlex, CodePlex, CodePlex!
Microsoft launched the CodePlex Foundation to facilitate
open source contributions, and confirmed the departure of Sam Ramji.
Patents, Patents, Patents!
The OIN confirmed the acquisition of 22 patents formerly
owned by …
MySQL provides a level of statistics for your INSERT, UPDATE, DELETE, REPLACE Data Manipulation Language (DML) commands using the STATUS output of various Com_ variables, however it is per server stats. I would like per table stats.
You can achieve this with tools such as MySQL Proxy and
mk-query-digest, however there is actually a very simple solution
that requires no additional tools.
The following 1 line Linux command (reformatted for ease of
reading) gave me exactly what I wanted, and it had ZERO impact on
the database.
$ mysqlbinlog /path/to/mysql-bin.000999 | \ grep -i -e "^update" -e "^insert" -e "^delete" -e "^replace" -e "^alter" | \ cut -c1-100 | tr '[A-Z]' '[a-z]' | \ sed -e "s/\t/ /g;s/\`//g;s/(.*$//;s/ set .*$//;s/ as .*$//" | sed -e "s/ where .*$//" | \ sort | uniq -c | sort -nr 33389 update e_acc 17680 insert into r_b 17680 insert into e_rec 14332 insert into rcv_c 13543 update e_rec 10805 …[Read more]
After my previous post about InnoDB Doublewrite Buffer impact I've received several feedbacks where people are claiming to see an important performance degradation when they enabling doublewrite... Discussing with them about their wokloads I've tried to reproduce a similar activity with dbSTRESS tool. And finally I was happy (or unhappy - all depends on the side :-))
And now I'll tell you a story how to fix it :-))
Sorry, it'll be little bit long (but it was hard to make it
shorter :-))
First of all let's get a look on the I/O activity and possible
solutions to make it running more optimally...
I/O Requests
Generally we may …
Reaction to EC’s Oracle-Sun delay. OIN to acquire ex-Microsoft patents. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca
“Tracking the open source news wires, so you don’t have
to.”
Reaction to EC’s Oracle-Sun delay
Despite widespread criticism of the European Commission’s
decision to open a formal investigation into Oracle’s proposed
acquisition of Sun, Glyn Moody maintained that the EC deserves credit for
making open source a central part of its analysis. Meanwhile
Monty Program (by way of Steven J Vaughan Nicholls) explained why the EU
should block Oracle/Sun, Roberto Galoppini reported …
While not a MySQL topic, as most of my readers view my MySQL Blog, my WordPress blog has been hacked? Has yours?
Like many, I’m sure you may have read about it like at Wordpress blogs under attack from hack attack but I was surprised when my custom permlinks did not work.
Being surprised I looked at Administrator accounts, and I found that there was one more number then being displayed in the list. I had to dig into the database to find the problem.
mysql> select * from wp_users where ID in (select user_id from wp_usermeta where meta_key = 'wp_capabilities' and meta_value like '%admin%'); +-----+-------------+------------------------------------+---------------+------------------------------+---------------------------+---------------------+---------------------+-------------+--------------+ | ID | user_login | user_pass | user_nicename | …[Read more]