• Blog
  • Get Help Now!
  • Customer Portal

BlueGecko Denmark

  • Why you need us
    • Why act now
    • Why are we unique
  • What we do
    • Products Supported 24/7
      • MySQL
      • Postgres
      • SQL Server
      • Open Source
      • OS & Storage
  • How we do it
    • Consulting
    • System Monitoring
    • Security
  • Support
    • Blog
      • Oracle
      • MySQL
      • News & Events
      • Oracle Applications
      • Amazon Web Services
      • Jeremiah Wilton’s Oradeblog
      • OurSQL Community Podcast
      • Remote DBA
    • Team viewer
    • Whitepapers
  • About Us
    • Philosophy
    • The Blue Gecko Teams
    • Employment Opportunities
    • Partners
    • News
    • Press
  • Contact Us

October 26, 2010 by pgalbraith

DBD::mysql 4.018 released

Dear Perl and MySQL developers, admins and enthusiasts, I'm please to announce the release of DBD::mysql 4.018! This release includes some code cleanups, added documentation as well as new features (database handle attributes) that allow you to be able to ascertain the server and client versions (Thank you to Robert M. Jansen). An example below, … [Read more...]

Filed Under: MySQL Tagged With: MySQL, Perl

October 22, 2010 by mhamrick

InnoDB tablespace fragmentation (find it and fix it!)

If you frequently delete rows (or update rows with variable-length data types), you can end up with a lot of wasted space in your data file(s), similar to filesystem fragmentation. If you're not using the innodb_file_per_table option, the only thing you can do about it is export and import the database, a time-and-disk-intensive procedure. … [Read more...]

Filed Under: MySQL Tagged With: MySQL

April 29, 2010 by mhamrick

Recovering a Schema From InnoDB .frm Files

Sometimes you find yourself in a bad situation where your only hope of recovering your InnoDB data lies in a handful of .frm and .ibd data files that were heretofore part of a working MySQL installation. It could be the case that someone thought backing up InnoDB tables was simply a matter of of copying the .ibd and .frm files somewhere safe. … [Read more...]

Filed Under: MySQL Tagged With: Mike Hamrick, MySQL

February 7, 2009 by snovotny

Velocity 2009

I've had the pleasure of being asked to speak at Velocity 2009 and tomorrow I go to San Francisco to participate the the Velocity Summit.  I'll get to rub elbows with the cabal that is planning/producing and executing the mamouth undertaking that is running a conference. I gave four topic possibilities all focused on MySQL or 24/7 operational … [Read more...]

Filed Under: MySQL Tagged With: MySQL, Sarah Novotny, Velocity 2009

December 1, 2008 by snovotny

MySQL 5.1GA

As is usually the case with fresh versions of software, we advise clients to move forward judiciously. This release has a bit of a hubbub surrounding it on the internet regarding Monty Widenius' post titled "Oops we did it again".   Monty's article is an excellent summary of what does and doesn't work as well as putting in an obligatory (though … [Read more...]

Filed Under: MySQL Tagged With: Monty Widenius, MySQL

March 28, 2008 by snovotny

Managing databases and other stuff

Databases exist to store data.  That said, a database is infrequently useful entirely on it's own.  So, managing databases means that we're often interacting with applications that access that data.   Some of the common applications that we work with include Oracle E-Business Suite, Tomcat, Apache and ColdFusion. We had an entertaining problem … [Read more...]

Filed Under: MySQL Tagged With: Apache, linux, MySQL, performance tuning

March 18, 2008 by snovotny

Busy couple of weeks

We've been working on lots of new customers and in our spare time writing a few scripts and white papers.  I've added a link to the right to download Chuck Edwards' paper on encrypting Oracle traffic with SSH tunnels.  Ed's been working hard on some handy Oracle scripts and I'll have that tarball published sometime this week. In the mean time, … [Read more...]

Filed Under: MySQL Tagged With: Chuck Edwards, Ed Murray, MySQL, PSOUG

Categories

  • Amazon Web Services
  • Configuration Management
  • downtime
  • Drizzle
  • ebs
  • Education
  • elastic block store
  • elastic compute cloud
  • hosting
  • hot backup
  • ignorance
  • Infrastructure
  • IOUG
  • Jeremiah Wilton's Oradeblog
  • misconception
  • misconceptions
  • Monocle
  • MySQL
  • MySQL Council
  • News
  • News & Events
  • Oracle
  • Oracle APEX
  • Oracle Applications
  • Oracle Data Guard
  • Oracle Database
  • Oracle Database Appliance
  • Oracle Linux
  • Our People
  • OurSQL Community Podcast
  • outage
  • parallel
  • performance
  • podcast
  • proof
  • Remote DBA
  • replication
  • S3
  • Security
  • SQL Server
  • System monitoring
  • Tomcat
  • Uncategorized

Contact Blue Gecko

  • This field is for validation purposes and should be left unchanged.

Get Our Newsletter

  • This field is for validation purposes and should be left unchanged.

The Fine Print

  • Privacy Policy
  • Terms of Use
  • When is remote DBA the right solution
  • What are remote DBA services
  • Get Help

Blog Categories

  • 24/7 support
  • Blue Gecko 360° Services
  • Products Supported 24/7

Virtual runs

Contact Blue Gecko

Blue Gecko A/S
Slotsgade 21
DK – 4200 Slagelse
Denmark
Phone: (DK) +45 70 60 51 20

Networks

  • Email
  • Twitter

© Blue Gecko Group