Posts Categorized: MySQL
Technical blogging has become more than just a way to tell the world what the technologist did. It has become a vibrant medium through which the tech bloggers are sharing their experiences and teaching the interested audience. It has become an enabling technology. This Log Buffer Edition encompasses such vibrant blogs in Log Buffer #274.
Glamour from across the world is sparkling in the South of France, but even that has failed to eclipsed the vivid aura of the database blogs from the realms of Oracle, MySQL and SQL Server. This Log Buffer Edition in Log Buffer #273 covers this glamorous gala of innovation.
I was presented with test results which showed that IN query was about 100 times faster than OR query. Where OR query took minutes to run, IN query took seconds! Ok, I said to myself, it is time to start digging. Here are my findings.
It is evident and beyond doubt now that the new media technologies like Twitter and Facebook are not going to wipe-out the blogs, rather they are complimenting each other very nicely and it seems they were made for each other. This Log Buffer Edition enhances this match, and presents you Log Buffer #272.
They say, “April showers bring May flowers.” They basically say that nature brings different things in different colors aimed at improving the things. That is so true for the blogging world too. This Log Buffer Edition also brings out different blog posts to improve things, so enjoy the Log Buffer #271.
My work was related to Tablespace management in 5.6 and Table partition EXCHANGE, you can read the articles here. I have also start to dig a little bit more in details on Mongo architecture, given the need to have it correctly review and implemented in parallel with MySQL installations. As news review I was more interested in a couple of articles, as for below
When preparing for the the IOUG Collaborate 12 deep dive on deploying Oracle Databases for high Availability, I wanted to provide some feedback on what hardware components are failing most frequently and which ones are less frequently. I believe I have reasonably good idea about that but I thought that providing some more objective data would be better. I couldn’t find and results of a more scientific research so I decided to organize a poll. This blog post shows the results and I promised to share it with several groups.
As the summer in many parts of the world starts, not only the snow is thawing, many bloggers are also coming out of hiatus and the database blogosphere is seeing new sensational activity. This Log Buffer Edition includes blogging tidbits from Oracle, SQL Server and MySQL. Enjoy reading Log Buffer #270.
I spent last week at Collaborate 2012 in Las Vegas and it was really great experience in many ways. I am a MySQL DBA and have been working with MySQL for most of my career, so Collaborate didn’t seem like an obvious choice. It turned out that there are so many things that I can learn from Oracle professionals and the Oracle community which can be applied in MySQL world as well. For me an indication of a good conference is when you come back inspired and full of ideas.
Why this article? First, I had fun digging in the code. Then, I was reading about the future improvements for MySQL 5.6, and of some current in 5.5. Most of them are well covered by people with more expertise than me, so I read, but after a while I became curious, I read the code, and did tests. I was looking at how the new Purge thread mechanism work and its implications. Here’s what I found,