Posts Categorized: Pythian
Another medley of database blogs under the famous banner of Log Buffer is in your virtual hands. This edition of Log Buffer, the Log Buffer #221 puts spotlight on the fresh and cool blogs from Oracle, MySQL and SQL Server arena.
Recently, one of our customers had a problem with one of their replication slaves where a sql statement gave an error while executing on the slave which was executed successfully on the Master server. The slave stopped with the error. We found the main difference in MySQL configuration between Master and Slave was the amount of memory allocated to innodb_buffer_pool_size because Slave was running several MySQL instances that were used for backup purposes. We need to increase the memory of innodb_buffer_pool_size variable where the locks table can fit in the configuration file and restart the database. This should fix the problem.
When big news is released, the world of modern information shakes – and nowhere is this more visible than with the blogs. Log Buffer is the ideal joint for the shakers and movers of the blogosphere. This edition Log Buffer #220 sheds a spotlight on those hot spots.
Since writing a blog entry sorely to talk about a software release bearing my name would be slightly… ah… self-serving (and we couldn’t have that in a blog, now, could we?), I thought to expand a little bit on the topic and discuss why I am contributing to other peoples’ modules, and how I usually go about it.
There are plethora of thrilling business software trends on the horizon as the summer of 2011 starts. Many of these will significantly impact IT organizations seeking to align IT operations with business objectives. Awareness of such trends can help you to keep ahead of the competition. What better way to get abreast of these trends in a nutshell than the Log Buffer? Log Buffer #219 is in your hands to enjoy.
Pythian is pleased to announce that Paul Vallee, Pythian’s Founder and Executive Chairman, has been named as one of Ottawa’s rising stars on Ottawa Business Journal’s 2011 Forty Under Forty list.
Oracle’s assault on the global market goes on with full might and as it adds new products in it’s array, SQL Server also strives hard to get the attention of people through various public appearances, and MySQL is also not behind as its growing array of bloggers marches on. This week’s Log Buffer casts a shadow on some selective blogs from these three technology in its latest edition Log Buffer #218.
Pythian is pleased to announce the new Flash Cache Query Tool for Oracle Exadata, developed by our Senior Consultant, and Oracle ACE, Christo Kutrovsky. This tool will be most valuable for Exadata DBAs and Exadata Architects that are trying to understand if the Oracle Exadata Flash Cache is used as envisioned.
Clouds are dispersing and the sun has started shining through. On the IT horizon, the cloud of Amazon has also dispersed and that is the biggest news of the previous week. Well clouds are elastic and they congregate and become solid after dispersion, and so Amazon will be fine too. And our blogosphere is fine too and here is the latest report about them in this week’s edition Log Buffer #217.
Unfortunately, there is no easy way to monitor what’s in the Smart Flash Cache. Oracle only provided a “list flashcachecontent” command in the cellcli tool, it has no summarization options, and only displays object numbers. So I wrote this handy tool which lets you query the cell flash content on all cells, similarly, you can query the buffer cache (db_cache) contents in v$bh.