Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 51 10 Older Entries

Displaying posts with tag: review (reset)

WTF worthy man page suggestion...
+0 Vote Up -0Vote Down

I encountered the following text in a man page. Please tell me that I am not alone in thinking that the "typical" solution suggested is WTF worthy...

After calling "commit" or "rollback" many drivers will not let you
fetch from a previously active "SELECT" statement handle that's a child
of the same database handle. A typical way round this is to connect the
the database twice and use one connection for "SELECT" statements.



If the programmer really wants to reuse values from a SELECT statement which occurred within a transaction after the transaction is closed, they should …






  [Read more...]
Using MySQLTuner – MySQL Optimization Tool
+0 Vote Up -0Vote Down

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved. Downloading MySQLTuner: wget http://mysqltuner.com/mysqltuner.pl chmod +x mysqltuner.pl Using MySQLTuner Script for Lampp systems: Just […]

review: MySQL Cookbook
+0 Vote Up -0Vote Down

Last year O’Reilly released the 2nd Edition of the  MySQL Cookbook by Paul DuBois.  You can read my review here.

Whenever a publisher releases a 2nd Edition of a book, you know it was well received the first time around.  So that’s a good sign that the material has gotten people buying.  I would say in the computer reference and howto market, that’s a very good indication that the material is well written and relevant.  I certainly found it to be …

  [Read more...]
review: High Performance MySQL 2nd Ed.
+0 Vote Up -0Vote Down

I just finished reading the recently released 2nd Edition of High Performance MySQL by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy Zawodny, Arjen Lentz & Derek Balling.  I’ve posted a review here on Amazon.

Wow, that’s quite a list of authors, but when you look at the material, you see why.  This book is a very indepth look at the MySQL server.  Intended for the intermediate to advanced DBAs and developers who want to know the …

  [Read more...]
Review of AssemblySys dataServices
+0 Vote Up -0Vote Down

On a large data migration project that I am currently spearheading, we have a large installed userbase of over 2 million users running on a social networking engine. The schema has been redesigned from scratch, and code is being written to match the new schema, using the all-powerful MySQL database as the system to manage all that data.

Since this social network is global, we need good and reliable location information. The current location model is flawed and full of holes, so we have chosen AssemblySys‘ data to replace it.

We are not using AssemblySys’ …

  [Read more...]
review: Backup & Recovery by W. Curtis Preston
+0 Vote Up -0Vote Down

Just finished up O’Reilly’s Backup & Recovery by W. Curtis Preston.  The title is wide-reaching, covering backups at the operating system as well as on all the popular database platforms, including Oracle, MySQL, Postgres, Sybase, SQL Server and DB2.  Preston has an amazing grasp of a spectrum of technologies and platforms, and as an Oracle & MySQL DBA myself, I’d use this as my backup reference text any day.

I’ve posted my review of Backup and Recovery over at Amazon.

Thoughts on Google Chrome
+0 Vote Up -0Vote Down

So Google Chrome – Google's attempt at an open source browser, came out yesterday and I took it out for a spin. At its heart is the Webkit engine (also open source) and Google Gears, powered by SQLite (can MySQL rival SQLite in applications like this?). Here are my thoughts.

  [Read more...]
High Performance MySQL: Review
+0 Vote Up -0Vote Down

High Performance MySQL, Second Edition
Optimization, Backups, Replication, and More

By Baron Schwartz , Peter Zaitsev , Vadim Tkachenko , Jeremy Zawodny , Arjen Lentz


  [Read more...]
Book Review: Building powerful and robust websites with Drupal 6
+0 Vote Up -0Vote Down

I just finished reading Building Powerful and Robust Websites with Drupal 6 ( …

  [Read more...]
Reviewing MONyog
+0 Vote Up -0Vote Down

I was contacted by the folks at MONyog and asked if I would review MONyog. Since using MONyog is something I have been wanting to do for a while, I jumped at the chance. Of course, “jumped” is relative; Rohit asked me at the MySQL User Conference back in April, and here it is two months later, in June. My apologies to folks for being slow.

This review is an overall review of MONyog as well as specifically reviewing the newest features released in the recent beta (Version 2.5 Beta 2). Feature requests are easily delineated with (feature request). This review is quite long, feel free to bookmark it and read it at your leisure. If you have comments …

  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 51 10 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.