Tag: MySQL

Change Views DEFINER Without ALTER VIEW: How to Fix Thousands of Views

Recently I faced an interesting challenge: modify over 26k views on a single mysqld instance. Altering the view one by one was far from an easy task, so a I had to look for an efficient way to do it….

Read More >

Change Views DEFINER without ALTER VIEW : how to fix thousands of views!

Recently I faced an interesting challenge: modify over 26k views on a single mysqld instance. Altering the view one by one was far from an easy task, so a I had to look for an efficient way to do it….

Read More >

Log Buffer #240, A Carnival of the Vanities for DBAs

With Oracle Open World in the offing, Oracle and MySQL bloggers and professionals are flocking to either San Fransisco or to their blogs to relish this annual medley of technologies under one roof. This Log Buffer Edition covers that and much more in Log Buffer #240.

Read More >

Rounding Errors in MYSQL with DECIMAL Type

It seems to be assumed that fixed-point values, DECIMAL and NUMERIC, in MySQL are not susceptible to rounding errors because they are exact numeric data types. It must be kept it mind, that there are limits in precision, and the maximum number of digits for DECIMAL is 65. What I am discussing here is rounding error.

Read More >

Log Buffer #239, A Carnival of the Vanities for DBAs

Integrated and Turnkey solutions are the name of game these days. Solutions based on software, hardware, storage, and networking tightly knitted in one box with the option of customization are shaping the future. Oracle, once again leading the pack has come up with a groundbreaking appliance and blogs are buzzing with it and so is this Log Buffer Edition. ODA and various sizzling news from SQL Server and MySQL are adorning this Log Buffer #239.

Read More >

Log Buffer #238, A Carnival of the Vanities for DBAs

Weather is changing and so is the technology. They both never remain the same. There are lots of variations in both of them. Technological storms and innovative rains are making the blogging grounds more fertile, and this Log Buffer Edition is also sprinkling some seeds in Log Buffer #238.

Read More >

Oracle OpenWorld 2011 — Bloggers Meetup

Isn’t that that time of the year again? Yes, it is — it’s time for our annual Oracle Bloggers Meetup and of course Oracle is piggybacking OpenWorld with the meetup again! ;)

Read More >

Log Buffer #237, A Carnival of the Vanities for DBAs

Oracle users across the globe keep searching for easier ways to accomplish time consuming tasks, or keep searching for the solutions of errors and issues and then often land on valuable blog posts. In quest for this Log Buffer Edition, we also landed upon some chic blog posts across database technologies and hence this Log Buffer #237.

Read More >

My Broken Planet MySQL feed..

Having recently joined Pythian’s MySQL team, in anticipation of my first blog post, I was eager to add my blog feed to Planet MySQL for aggregation. Unfortunately in my haste I pasted the link to my blog as opposed to the blog feed and as the link was erroneous, Planet MySQL recursed back up the url until it reached a valid feed. Unfortunately for me, that was the main Pythian Blog feed and as a result all Pythian blog content is now getting aggregated under my name.

Read More >

Log Buffer #236, A Carnival of the Vanities for DBAs

Don’t restrict your database blogging diet to just your blog reader or to your casual surfing on the net. Scour the brave bold world of database blogs from end to end. Huh? difficult? That is why we have brought you another Log Buffer Edition. Covering Oracle technologies to the SQL Server forays before culminating at the adventures in MySQL, here is the Log Buffer #236 for your eyes.

Read More >
Page 27 of 63« First Page...10...2526272829...40...Last Page »