Language Selection

English French German Italian Portuguese Spanish

Tips for tackling MySQL 5.0

Filed under
HowTos

Testing, testing, testing. IT pros have been checking out the new MySQL 5.0 open source database since its recent release its commercial parent, MySQL AB. Some of those IT pros put our resident MySQL expert, Mike Hillyer, to the test, too. In this tip, he answers users' questions about the ins and outs of choosing, testing and using MySQL 5.0, an open source relational database management system.

Wondering why Hillyer is our go-to guy for MySQL? Well, he holds the MySQL Professional Certification and is the top ranked MySQL expert at Experts-Exchange.com. He's also the webmaster of VBMySQL.com, a site for Windows users of MySQL, and and works on the MySQL AB documentation team.

Can you offer some step-by-step and "watch out!" tips for evaluating MySQL 5.0?

Mike Hillyer: I would recommend installing MySQL 5.0 on a separate machine and trying it with your existing applications. Run as many tests as you can and see if everything runs smoothly. If you do not encounter any errors you, then you can bring MySQL 5.0 into your production systems.

There really should not be things to watch out for, in the sense of bugs or incompatibilities, but you can always watch the change logs and look for entries that are marked "Incompatible Change."

What hardware would be best for evaluating MySQL 5.0?

Full Story.

More in Tux Machines

New Arduino boards include first FPGA model

Arduino launched a “MKR Vidor 4000” board with a SAMA21 MCU and Cyclone 10 FPGA, as well as an “Uno WiFi Rev 2” with an ATmega4809 MCU. Both boards have a crypto chip and ESP32-based WiFi module. In conjunction with this weekend’s Maker Faire Bay Area, Arduino launched two Arduino boards that are due to ship at the end of June. The MKR Vidor 4000 is the first Arduino board equipped with an field programmable . The Intel Cyclone 10 FPGA. will be supported with programming libraries and a new visual editor. The Arduino Uno WiFi Rev 2, meanwhile, revises the Arduino Uno WiFi with a new Microchip ATmega4809 MCU. It also advances to an ESP32-based u-blox NINA-W102 WiFi module, which is also found on the Vidor 4000. Read more

DragonFlyBSD 5.3 Works Towards Performance Improvements

Given that DragonFlyBSD recently landed some SMP performance improvements and other performance optimizations in its kernel for 5.3-DEVELOPMENT but as well finished tidying up its Spectre mitigation, this weekend I spent some time running some benchmarks on DragonFlyBSD 5.2 and 5.3-DEVELOPMENT to see how the performance has shifted for an Intel Xeon system. Read more

Red Hat News: KVM, OpenStack Platform 13 and More

today's leftover

  • The Prominent Changes Of Phoronix Test Suite 8.0
    With development on Phoronix Test Suite 8.0 wrapping up for release in the coming weeks, here is a recap of some of the prominent changes for this huge update to our open-source, cross-platform benchmarking software.
  • AMD AOCC 1.2 Code Compiler Offers Some Performance Benefits For EPYC
    Last month AMD released the AOCC 1.2 compiler for Zen systems. This updated version of their branched LLVM/Clang compiler with extra patches/optimizations for Zen CPUs was re-based to the LLVM/Clang 6.0 code-base while also adding in experimental FLANG support for Fortran compilation and various other unlisted changes to their "znver1" patch-set. Here's a look at how the performance compares with AOCC 1.2 to LLVM Clang 6.0 and GCC 7/8 C/C++ compilers.
  • More Roads And Faster Browsers
    And it's exactly what is happening with our Web pages. Browsers become more performant. So developers instead of using this extra performance to make the page extra-blazingly fast, we use it to pack more DOM nodes, CSS animations and JavaScript driven user experiences.
  • Firefox 61 Beta 6 Testday Results
    As you may already know, last Friday – May 18th – we held a new Testday event, for Firefox 61 Beta 6. Thank you all for helping us make Mozilla a better place: gaby2300, Michal, micde, Jarrod Michell, Petri Pollanen, Thomas Brooks. From India team: Aishwarya Narasimhan, Mohamed Bawas, Surentharan and Suren, amirthavenkat, krish.
  • Lemonade Proposes Open Source Insurance Policy for All to Change, Adopt
    Technology-focused homeowners and renters insurer Lemonade Inc. has proposed an open source renters insurance policy that anyone can contribute to changing, even its rivals since Lemonade is not copyrighting it.
  • Security updates for Monday