Personal blog of Yzmir Ramirez

Percona is pleased to officially (and belatedly) welcome Sasha Pachev to our team of consultants.

Before joining Percona, Sasha worked as an independent MySQL consultant. Sasha was the original implementer and maintainer of MySQL replication from 3.23 to 4.02. He is also the author of MySQL Enterprise Solutions and Understanding MySQL Internals.

Sasha, a big welcome – we are fortunate indeed you’re working with us!

Entry posted by Ryan Lowe |
No comment

Add to: | | | |

The Zend Framework team announces the immediate availability of Zend
Framework 1.11.2, our first maintenance release in the 1.11 series. This
release includes around 50 bug fixes.

You may download ZF 1.11.2 from the Zend Framework site .

The collaborative Q&A site Stack Overflow is a great place for geeks to hang out, answer questions and earn reputation. But there’s an additional bonus: the site also exposes a Web service API that allows developers to build mashups on top of the base service. This two-part article will give you a crash course in the Stack Overflow API, illustrating how easy it is to retrieve and search site content from within your PHP application.

Percona Server version 5.1.53-12.4 is now available for download. It is now the current stable release version.

Functionality Added or Changed

•  Percona Server 5.1.53-12.4 is based on MySQL 5.1.53.
•  New Features Added:
  • Precompiled UDFs for Maatkit (FNV and MurmurHash hash functions to provide faster checksums) are now included in distributions. Fixes feature request #689992. (Aleksandr Kuzminsky)
•  Other Changes:
  • innodb_doublewrite_file – It’s no longer necessary to recreate your database and InnoDB system files when a dedicated file to contain the doublewrite buffer is specified. (Yasufumi Kinoyasu)

Bugs Fixed

• Bug #643149 – Slow query log entries were not written in the usual parsing format. (Alexey Kopytov)
• Bug #671764 – innochecksum wasn’t distributed with RPM and .DEB packages. (Aleksandr Kuzminsky)
• Bug #673426 – Use of these system variables as command-line options could cause a crash or undefined behavior: log_slow_timestamp_every, log_slow_sp_statements, slow_query_log_microseconds_timestamp, use_global_long_query_time. (Oleg Tsarev)
• Bug #673567 – Compiler could produce spurious warnings when building on non_Linux platforms. A check is now made to see if clock_gettime() is present in librt at the configure stage. If yes, -lrt is added to LIBS. (Alexey Kopytov)
• Bug #673929 – Query cache misses were being reported for some queries when hits were actually occurring. (Oleg Tsarev)
• Bug #676146 – The development environment test of log_slow_verbosity=innodb on a slave for row-based replication was not working correctly. (Oleg Tsarev)
• Bug #676147, Bug #676148 – The development environment tests of options log_slow_slave_statements and use_global_long_query_time work only on statement-based replication. They were failing when row-based replication was attempted. A check is now made for the replication type to test. (Oleg Tsarev)
• Bug #676158 – Setting the query cache size to 512M caused test failure on low memory systems. (Aleksandr Kuzminsky)
• Bug #677407 – The innodb.innodb_information_schema test could fail sporadically due to flawed logic in the INFORMATION_SCHEMA.INNODB_LOCKS caching mechanism. (contributed by Kristian Nielsen) (Alexey Kopytov)
• Bug #681486 – A dependency between Debian packages libmysqlclient16 and percona-server-common was removed. (Aleksandr Kuzminsky)
• Bug #693415 – The test percona_innodb_buffer_pool_shm was failing. It should be run with the --big-test option. As the buffer pool size used in the test is 128M, the shared memory segment should be increased appropriately in order to run the test successfully. (Aleksandr Kuzminsky)
• Bug #693814, Bug #693815, Bug #693816, Bug #693817, Bug #693819 – Tests in the test environment were updated to reflect past INFORMATION_SCHEMA changes. (Aleksandr Kuzminsky)
• Bug #693818 – Warning and error messages for stored routines could incorrectly report row numbers due to a change in the slow_extended patch. (Alexey Kopytov)

The Release Notes for this and previous releases can be found in our Wiki.

Downloads are available here and from the Percona Software Repositories. The latest source code for Percona Server, including the development branch, can be found on Launchpad.

Please report any bugs found at Bugs in Percona Server.

For general questions, use our Percona Discussions Group, and for development questions our Percona Development Group.

For support, commercial, and sponsorship inquiries, contact Percona.

Entry posted by Fred Linhoss |
No comment

Add to: | | | |

Wil Sinclair, previous head of Zend Framework, has written a new post on his blog discussing “Process Patterns” and coining a new term. Click on inside, I’ve got the URL around here somewhere.

Ok, this one is not strictly PHP but since it’s Ivo and he’s a member of the PHP community, let’s cut him a little slack and see what he’s up to.

My friend Kevin Schroeder recently released his latest book “You Want to Do What with PHP ?” This book isn’t for everyone, click on inside and I’ll help you decide if it’s right for you.

Julian Egelstaff recently posted “Things I learned at Jump In Camp” about Microsoft’s Jump In Camp last month in Seattle. Click on in, let’s look talk about it.

Form and Validation components were heavily updated this week, including the refactorization of code to a new Locale component and the implementation of new fields and constraints. In addition, Doctrine project published the first stable release of Doctrine 2.0.

Development mailing list

• [Symfony2] ParamConverter
• [Symfony2] Security Component: How to make my own firewall?
• [Symfony2] About the _view variable in Twig templates
• [Symfony2] functional tests that require login

Symfony2 development highlights

Changelog:

• 242be93:
  [Form] added proper error handling to FileField
• b8ef7e7:
  [Form] improved semantics of property paths and removed FieldGroup::merge() for now
• 7c557d0:
  [Form] made $data and $validator parameter in the constructor optional
• 78b6987:
  [Form] locale can now only be set statically before creating a form/field, otherwise we have too many problems updating a field’s state when the locale is changed
• 9db7db4:
  [Form] implemented CountryField
• 93d3716:
  [Form] implemented LanguageField
• fdb7f84:
  [Locale, Form, Validator] refactored code to new Locale component, implemented Country constraint
• 993257a:
  [Validator] implemented Language constraint
• a059ec8:
  [Validator] implemented Image constraint
• 4f46235:
  [HttpFoundation] send proper charset along with the default text/html header
• cd64046:
  [Form] changed semantics of “always_empty” option in PasswordField
• df6ffbb:
  removed user provider name
• b57411b:
  renamed reloadUserByAccount() to loadUserByAccount()
• faac8e6:
  [TwigBundle] replaced the ifrole tag with a has_role function
• d935df0:
  [TwigBundle] removed unused tag and contenttag Twig tags
• 5d65f3e:
  [TwigBundle] converted path and url tags to functions
• d87c3c5:
  [FrameworkBundle] added config keys for PdoSessionStorage
• 5e94807:
  speed up url matching for route without variable
• a2105d4:
  slight compiler refactoring
• 094d428, 3d9b13f:
  unified equality comparisons, put var on the right side
• c54f6d8:
  fixed DoctrineMongoDBBundle to work with latest version of Doctrine
• 03d25cc:
  refactored creation of access decision manager to make use of newly added compiler passes
• 32aef96:
  [Routing] removed call to setDefaultAnnotationNamespace() so this can be configure on the injected reader
• 763ef35:
  [Routing] . added creation of a file resource in annotations loader

Documentation

• New IRC Logs 2010-12-16 page

New job postings

• Symfony/Doctrine/JQuery developer at Idael Software – full-time based in Yverdon, Switzerland – Contact: job [at] idael [dot] ch

New plugins

• rsGitExternals: manage git repositories within your symfony project. provides a simple task to handle gits.
• mpRealityAdmin: provides a new admin generator theme with some additions.

Updated plugins

• sfRADIUSAuth:
  • committed initial version of the plugin
  • RADIUS auth via MSCHAPv2 is working
• sfProjectAnalyser:
  • added an global option ‘plugin_assets_path’ to set the path of the plugin’s assets (for custom project directory)
  • fixed typos
  • added a threshold for symfony extended class in order to avoid displaying all classes of a type (mainly for model classes)
  • moved the ‘plugin_assets_path’ to the config plugin section
  • implemented a return code for the main task so it can be used by a CI tool
  • fixed the class grouping algorithm
  • added a config option ‘output’ that allows to render the output as XML instead of HTML
  • added alert for $this->executeXXX code at action level
• sfDoctrineActAsTaggable:
  • tag markup and css cleanup for consistency between tag sidebars and tag widgets
• sfGuardExtra:
  • added opportunity to choose new password on reset
  • improved reset password form
• sfFormButtons:
  • updated helper to use jQuery helper for remote javascript functions
  • added sfJqueryReloadedPlugin as required dependency
  • increased package and API versions to reflect new dependencies and internal usage of jQueryHelper
  • added new functions to readme
• sfJqueryReloaded:
  • added Option to control caching of ajax requests
  • added ‘stop_propagation’ option for jq_remote_function, preventing events from bubbling
• idlErrorManagement:
  • added a new app.yml option to easily disable the recording
  • added a new method tryToLogError, that’s try to log with symfony logger
  • fixed permissions on cache directories creation
  • removed try/catch in the plugin configuration section
  • fixed a bug in comment error action, prevent querying doctrine with invalid errorId

New symfony powered websites

• RE/MAX Paraíso: (Deutsch, English, Spanish, Dutch) Portal inmobiliario multiidioma

They talked about us

• Utilisation de l’event dispatcher depuis les classes du modèle
• Some layout changes for lyMediaManagerPlugin
• Using the Symfony2 console
• Rilasciato Doctrine 2.0
• Propel 1.6 Gets Versionable Behavior – With A Twist
• Symfony2 : créer un admin sécurisé
• Symfony2 ParamConverter’s
• Sensio Labs annonce les conférences Symfony Live 2011
• Symfony 1.4 vs. sfGuardUserPlugin : understand credentials and permissions
• Symfony cheat sheets
• Creating an Online Store with Symfony – Part 2: Design
• Cadeau de noël pour les utilisateurs de VIM
• Formateo de fechas con symfony
• Générer une liste de checkbox pour un formulaire à partir d’une table (class) dans Symfony
• Symfony?????????????????1.4???
• Askeet. ???? ?????????. ???????????

Inspired by Baron’s earlier post, here is one I hear quite frequently -

“If you enable innodb_file_per_table, each table is it’s own .ibd file.  You can then relocate the heavy hit tables to a different location and create symlinks to the original location.”

There are a few things wrong with this advice:

1. InnoDB does not support these symlinks.  If you run an ALTER TABLE command, what you will find is that a new temporary table is created (in the original location!), the symlink is destroyed, and the temporary table is renamed.  Your “optimization” is lost.
2. Striping (with RAID) is usually a far better optimization.  Striping a table across multiple disks effectively balances the  ‘heavy hit’ access across many more disks.  With 1 disk/table you are more likely to have the unbalance one disk overloaded, and many idle.
3. You restrict your backup methods.  You can’t LVM snapshot across logical volumes.

Another common claim with this recommendation is that it allows you to quickly add space when running out.  LVM actually allows you to add physical volumes, and increase the size of logical volumes   This is much easier to do than more one large table around.

Entry posted by Morgan Tocker |
22 comments

Add to: | | | |