PlanetMysql.ru — информация о СУБД MySQL

There has been a lot of chatter the past week about Apple replacing MySQL with Postgres in the new OSX Lion Server [U.S. | England | New Zealand ]. Most of it seems to tie things back to Oracle's new stewardship over the MySQL project, a lot of that stemming from what I would say is FUD from the EnterpriseDB folks, regarding doom and gloom about the way Oracle might handle the project in the future. Not that the FUD is entirely unwarrented; While Oracle has done a pretty decent job with MySQL so far, looking at what Oracle has done to projects like Open Solaris certainly would make one queasy. And yes, we've seen an uptick in people asking for help with Oracle/MySQL to Postgres migrations since the acquisition of Sun. That said, I have an alternative theory. Maybe they just like it better?


Continue reading "Maybe they just like it better?"
PlanetMySQL Voting: Vote UP / Vote DOWN

In this latest release I’ve added a basic MySQL connection pool to the benchmarking script which improves the method in which connections to MySQL are handled and reused. In addition, there have been some optimizations made to the thread handler functions for better debug reporting. Download the latest release now and see how your MySQL server performs against the rest of the community! Download here: download page.

PlanetMySQL Voting: Vote UP / Vote DOWN

We had a very successful weekend of Planet.mysql users submitting their database statistics so I’ve pushed some code into a new release today so that everyone can benefit from some new features. The biggest change is to the threading logic. Previously the benchmarking script was serializing MySQL operations and only making use of a secondary thread (not the invoking thread) to query the database. Now you have the option of running with “–threads=x” to make use of your multi-core server. A good example of this improvement was on my Macbook Pro; before the threading change it was inserting ~700/sec, after the code change I tried –threads=4 and saw an improvement to ~900/sec. Rather significant.

Download the new script now and see how your server compares to the ones in the central database!

PlanetMySQL Voting: Vote UP / Vote DOWN

This is a simple matter with a simple solution that might help someone save time and confusion. Emacs wasn’t coloring my comments correctly so I went ahead and had it change them to red-italic. If you are having similar issues you can drop the following into your home directory’s .emacs file. Enjoy. Keep in mind that if you are using emacs in a terminal session as opposed to the X-server gui then you will not see the italics.


(global-font-lock-mode 1)
(custom-set-variables
'(gud-gdb-command-name "gdb --annotate=1")
'(large-file-warning-threshold nil))
(custom-set-faces
'(font-lock-comment-face ((((class color) (background light)) (:foreground "red" :slant italic)))))


PlanetMySQL Voting: Vote UP / Vote DOWN

This is a simple matter with a simple solution that might help someone save time and confusion. Emacs wasn’t coloring my comments correctly so I went ahead and had it change them to red-italic. If you are having similar issues you can drop the following into your home directory’s .emacs file. Enjoy. Keep in mind that if you are using emacs in a terminal session as opposed to the X-server gui then you will not see the italics.


(global-font-lock-mode 1)
(custom-set-variables
'(gud-gdb-command-name "gdb --annotate=1")
'(large-file-warning-threshold nil))
(custom-set-faces
'(font-lock-comment-face ((((class color) (background light)) (:foreground "red" :slant italic)))))


PlanetMySQL Voting: Vote UP / Vote DOWN

So you're a small startup company, ready to go live with your product, which you intend to distribute under an Open Source License. Congratulations, you made a wise decision! Your developers have been hacking away frantically, getting the code in good shape for the initial launch. Now it's time to look into what else needs to be built and setup, so you're ready to welcome the first members of your new community and to ensure they are coming back!

Keep the following saying in mind, which especially holds true in the Open Source world: "You never get a second chance to make a first impression!". While the most important thing is of course to have a compelling and useful product, this blog post is an attempt to highlight some other aspects about community building and providing the adequate infrastructure. This insight is based on my own experiences and my observations from talking with many people involved in OSS startups and projects.

Continue reading "Some friendly advice for bootstrapping your OSS project"
PlanetMySQL Voting: Vote UP / Vote DOWN

Some notes from my recent installation of MySQL 5.4.2-beta on a PPC G5 box running OSX 10.5.8. Hopefully these notes will save someone a bit of time when they begin the “I want to make my mac a development box” process. I’m not going to cover installing/configuring Apache and PHP since the web is full of those articles already.  So, first things first,  I downloaded the pkg file  – not the tarball – from the MySQL downloads site and installed the following files in the following order:

1. mysql-5.4.2-beta-osx10.5-powerpc-64bit.pkg
2. MySQLStartupItem.pkg
3. MySQL.prefPane

CNF File Settings

Here are some interesting settings that you may want to be aware of with 5.4 and OSX

• Do not set innodb_flush_method=fdatasync – it’s not a valid option, and the default after install is actually blank.
• Do not set “nice = value” in the [mysqld_safe] section as this is not recognized and give the error ‘nice: illegal option — -‘
• Set the variable lower_case_table_names=2 because the HFS+ file system is case insensitive – isn’t that special.
• The variable ‘log_slow_queries’ will work but you should use ’slow_query_log’ or ’slow_query_log_file’ instead since it’s getting removed in *gasp* MySQL 7.0 so we do have a bit of time before that becomes something to be concerned about but you will see it in the error log if you don’t correct it now.

Preference Pane service controller

In order to get the Preference Pane controller to work (if you are getting the following error in /var/log/system.log – “Could not setup Mach task special port 9: (os/kern) no access”) you need to correct the permissions for the installation directory as such
(root@g5)-(/usr/local)-
shell> chown -R _mysql:wheel /usr/local/mysql*

This will still generate the ‘(os/kern) no access‘ message in the system.log but the server will be started/stopped by the pane controller and that’s what we really care about. There may be some more notes along the way as I’m going to be testing 5.4 quite a bit for various application related matters.

PlanetMySQL Voting: Vote UP / Vote DOWN

This is a bit of a side-step from directly MySQL related information .. but I found myself installing Snow Leopard on my MacBook Pro today (which I use for pretty much everything) and every-time I do I have to try and remember all the applications I use. And I thought I would share them as I've found it useful you can pick up on things other people use. So here it is!

I have marked the applications which cost money with a green dollar symbol ($) and hyperlinked all the project names for convenience.

• iLife 2009 - iTunes, iPhoto, iMovie $


• Built-in Mac Applications - Mail, Safari, Terminal


• iWork 2009 - Office Suite - Pages, Numbers, Keynote $


• TextMate - Text Editor $


• VisualHub - Video Conversion - Use this for converting videos to watch on my iPhone/iPod touch .. no longer for sale but apparently you can download it for free now $


• Transmit - FTP client $


• VMware Fusion - Virtualization - for testing and Windows $


• World of Goo - Game - Possibly the most awesome game ever (via Macheist) $


• Skype - VoIP - We use SkypeOut alot in the support team for calling customers world-wide.


• Adium - Instant Messaging - MSN, Google Talk, Jabber


• X-Chat Aqua - IRC - used for work, prefer a graphical client with sound and growl capability for work.. use irssi on a remote server for personal IRC


• MacPorts - BSD Ports-style for Mac - Applications: bzr, mtr


• Growl - Desktop notifications - also Prowl for forwarding them to my iPhone


• Perian - Video Codecs - for Quicktime


• VLC - Video Player - I use this for watching most videos anyway


• Cisco VPN Client - Used for work (not freely distributed)


• Arduino - For all my Arduino electronics hacking.. for more details see my Geek My Ride page


• EAGLE - PCB Design


• SeaShore - Image Editor - based on the GIMP, but was a Mac UI.. great for simple edits.


• iStat Menus - Menubar System Stats - not yet working on Snow Leopard (will soon) - highly recommended... also lets you replace the menu clock with one that drops down to show a calendar and other timezones.

That's it! I hope some of you find some useful applications in there.

- Trent

PlanetMySQL Voting: Vote UP / Vote DOWN