Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 91 to 120 of 180 Next 30 Older Entries

Displaying posts with tag: code (reset)

MySQL master master replication monitor with php code
+0 Vote Up -0Vote Down
For monitoring replication we know a lot of tools and codes – but this one is different because I wrote it Well this is fairly simple php code for monitoring a master master replication setup. It requires a single shared login id available on both MySQL servers. It will display in tabular format following details: […]
Calculate Mysql Memory Usage – Quick Stored Proc
+0 Vote Up -0Vote Down
While going through mysql doc and MySQL Server Memory Usage, I noted following quick points regarding how mysql uses memory. We have global buffers which are allocated irrespective of connections as and when mysql server is started. Along with that mysql server allocates memory to each thread to perform respective tasks. So the formula goes: Mysql […]
Discovr: a flickr experiment gone wrong
+0 Vote Up -0Vote Down

I need help with this. I had a dream… Well, not so much as a dream, maybe a “It’d be cool to…”

I thought it’d be nice to discover new photos on flickr using your favorite photos and the people who also favorited those photos, and the favorite photos of those who also favorited my pictures. Still with me?

It’s actually a quite simple code (about 500 lines, check it on github: discovr), but it’s terribly slow. Some possible reasons:

  [Read more...]
Aspects and benefits of distributed version control systems (DVCS)
Employee +2 Vote Up -0Vote Down

This blog post is a by-product of my preparation work for an upcoming talk titled "Why you should be using a distributed version control system (DVCS) for your project" at SAPO Codebits in Lisbon (December 3-5, 2009). Publishing these thoughts prior to the conference serves two purposes: getting some peer review on my findings and acting as a teaser for the actual talk. So please let me know — did I cover the relevant aspects or did I miss anything? What's your take on DVCS vs. the centralized approach? Why do you prefer one over the other? I'm looking forward to your comments!

Even though there are several distributed alternatives available for some years now (with

  [Read more...]
Replication slave lag monitoring using heartbeat and windows batch scripts
+0 Vote Up -0Vote Down
“Show Slave Status” command has a last column “Seconds_Behind_Master”, which gives us idea about how much time slave is lagging behind master. It is an important to be considered parameter in monitoring and maintaining replication. This article explains us a way to monitor replication slave lag time. It also includes a sample batch scripts to […]
Some friendly advice for bootstrapping your OSS project
Employee +4 Vote Up -0Vote 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

  [Read more...]
Search / find through all databases, tables, columns in MySQL
+0 Vote Up -0Vote Down
What will you do if one day some one ask you to find single string in all databases, all tables and in all columns? I just read such question and tried to find a “ready made” solution. Reusability is Key Concept !! But I ended up finding no “copy-paste” material. Some of the posts like http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm helped me […]
"Idle"
+0 Vote Up -0Vote Down

For those who wonder why my blogging is so low these days (apart from today) .. I`m actually writing more Lines of Code than Blog Entries the last couple of weeks:)

And when I`m not writing code I`m reading :) Either proofreading an upcoming book on Zabbix or reading some of the other books Packt sent me.

Next to that I`m busy preparing my T-Dose presentation

Oh and did I mention a 40 something questions questionnaire about some merger ?

Technorati Tags:   [Read more...]
Software patent game plays out
+0 Vote Up -0Vote Down

Following the release of our report, ‘The Myth of Open Source License Proliferation’ and during research for it, we heard and sensed a feeling that open source software licenses had evolved to become a generally well-accepted piece of the the enterprise IT and IP market. However, we also heard from numerous vendors, developers and other individuals that the next battlefront is obviously software patents, which are in need of reform, according to many supporters of free and open source software.

This week, we saw some of the software patent skirmishes that are driving and validating this thinking. There was first news that the Open Invention Network, the consortium dedicated to legal and IP defense of Linux, had bought some

  [Read more...]
More MySQL connectors
Employee +1 Vote Up -0Vote Down

Some time ago I posted a compilation of applications and programming languages that provide an API to connect to the MySQL Server (http://mysql.com/). As it turned out, I forgot a few that I would like to mention here:

  • Apache DBD API: a MySQL driver for mod_apr_dbd is not included in the official distribution, but can be obtained seperately from here. Some distributions (e.g. openSUSE) actually provide installable packages of this driver module.
  • GRASS MySQL driver
  [Read more...]
stringstream is completely useless (and why C++ should have a snprintf)
+0 Vote Up -0Vote Down
  • It’s easy to screw up thread safety.
    If you’re trying to format something for output (e.g. leading zeros, only 1 decimal place or whatever… you know, format specifiers in printf) you are setting a property on the stream, not on what you’re converting. So if you have a thread running that sets a format, adds something to the stream, and then unsets the format, you cannot have another thread able to come in and do something to that stream. Look out for thread unsafe cout code.
  • You cannot use streams for any text that may need to be translated.
    gettext is what everybody uses. You cannot get a page into the manual before it tells you that translators may want to change the order of what

  •   [Read more...]
    Contributing to MySQL
    Employee +0 Vote Up -0Vote Down

    If interested in contributing code to MySQL, you should attend the MySQL University session on contributing code to MySQL.

    (Live broadcast with Q&A will be held on Thursday, June 25, 2009. You can still have access to rebroadcasts afterwards.)

    Contributing to MySQL
    Employee +0 Vote Up -0Vote Down

    If interested in contributing code to MySQL, you should attend the MySQL University session on contributing code to MySQL.

    (Live broadcast with Q&A will be held on Thursday, June 25, 2009. You can still have access to rebroadcasts afterwards.)

    Contributing to MySQL
    Employee +0 Vote Up -0Vote Down

    If interested in contributing code to MySQL, you should attend the MySQL University session on contributing code to MySQL.

    (Live broadcast with Q&A will be held on Thursday, June 25, 2009. You can still have access to rebroadcasts afterwards.)

    MySQL University: MySQL Code Contributions
    Employee +0 Vote Up -0Vote Down

    This Thursday (June 25th, 13:00 UTC), Lenz Grimmer will explain how to contribute code to MySQL, in a MySQL University session titled MySQL Code Contributions. Lenz is a member of the MySQL Community Team. His session will give an overview about how code contributions to MySQL should be handled and performed. It will cover the ideal workflow, requirements and available infrastructure and toolchain that potential contributors should be aware of.

    For MySQL University sessions, point your browser to this page. You need a browser with a working Flash


      [Read more...]
    Hidden Features Of Perl, PHP, Javascript, C, C++, C#, Java, Ruby, Python, And Others [Collection Of Incredibly Useful Lists]
    +2 Vote Up -0Vote Down

    Introduction

    StackOverflow is an amazing site for coding questions. It was created by Joel Spolsky of joelonsoftware.com, Jeff Atwood of codinghorror.com, and some other incredibly smart guys who truly care about user experience. I have been a total fan of SO since it went mainstream and it's now a borderline addiction (you can see my StackOverflow badge on the right sidebar).

    The Story

    Update 6/21/09: This server is currently under very heavy load (10-200), even with caching plugins enabled. Please bear with me as I try to

      [Read more...]
    MySQL Error of the day
    Employee +3 Vote Up -0Vote Down

    Just spotted the following posting from Paul DuBois on the internals mailing list:

    I'm engaged in a project (WL#3403) to compile information that will provide better information about our errors and error messages:
    • What an error means
    • Likely causes of the error
    • How to rectify or work around the error

    The general idea is to provide our users something more than a list of error codes and the messages from errmsg.txt, such as the manual currently includes here:

    http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html

      [Read more...]
    Does linux fallocate() zero-fill?
    +0 Vote Up -0Vote Down

    In an email disscussion for pre-allocating binlogs for MySQL (something we’ll likely have to do for Drizzle and replication), Yoshinori brought up the excellent point of that in some situations you don’t want to be doing zero-fill as getting up and running quickly is the most important thing.

    So what does Linux do? Does it zero-fill, or behave sensibly and pre-allocate quickly?

    Let’s look at hte kernel:

    Inside the fallocate implementation (fs/open.c):

    if (inode->i_op->fallocate)
    ret = inode->i_op->fallocate(inode, mode, offset, len);
    else
    ret = -EOPNOTSUPP;

    and for ext4:
    /*
    * currently supporting (pre)allocate mode for extent-based
    * files _only_
    */
    if (!(EXT4_I(inode)->i_flags & EXT4_EXTENTS_FL))
    return -EOPNOTSUPP;

    XFS has always done










      [Read more...]
    c++ stl bitset only useful for known-at-compile-time number of bits
    +1 Vote Up -0Vote Down

    Found in the libstdc++ docs:

    Extremely weird solutions. If you have access to the compiler and linker at runtime, you can do something insane, like figuring out just how many bits you need, then writing a temporary source code file. That file contains an instantiation of bitset for the required number of bits, inside some wrapper functions with unchanging signatures. Have your program then call the compiler on that file using Position Independent Code, then open the newly-created object file and load those wrapper functions. You’ll have an instantiation of bitset for the exact N that you need at the time. Don’t forget to delete the temporary files. (Yes, this can be, and has been, done.)

    Oh yeah – feel the love.

    Brought to you by the stl-is-often-worse-for-you-than-meth dept.

    More Code Contributions to MySQL
    Employee +0 Vote Up -0Vote Down

    MySQL has deep roots in open-source software development communities and code contributions to MySQL keep flowing in, being reviewed and integrated into the MySQL. 

    During our BoF at the MySQL Conference and Expo, Lenz Grimmer talked about our work to make MySQL (even more) contributor friendly, with some more focused effort starting on February 1, 20091.

    The desire to contribute code to MySQL remains as strong as ever as evidenced by this year's MySQL Conference and Expo, where I had an opportunity to speak with some contributors and partners who wish to contribute to MySQL. Of course, there are a lot of strong and varying opinions in this area.

    As I said above,


      [Read more...]
    More Code Contributions to MySQL
    Employee +0 Vote Up -0Vote Down

    MySQL has deep roots in open-source software development communities and code contributions to MySQL keep flowing in, being reviewed and integrated into the MySQL. 

    During our BoF at the MySQL Conference and Expo, Lenz Grimmer talked about our work to make MySQL (even more) contributor friendly, with some more focused effort starting on February 1, 20091.

    The desire to contribute code to MySQL remains as strong as ever as evidenced by this year's MySQL Conference and Expo, where I had an opportunity to speak with some contributors and partners who wish to contribute to MySQL. Of course, there are a lot of strong and varying opinions in this area.

    As I said above,


      [Read more...]
    More Code Contributions to MySQL
    Employee +0 Vote Up -0Vote Down

    MySQL has deep roots in open-source software development communities and code contributions to MySQL keep flowing in, being reviewed and integrated into the MySQL. 

    During our BoF at the MySQL Conference and Expo, Lenz Grimmer talked about our work to make MySQL (even more) contributor friendly, with some more focused effort starting on February 1, 20091.

    The desire to contribute code to MySQL remains as strong as ever as evidenced by this year's MySQL Conference and Expo, where I had an opportunity to speak with some contributors and partners who wish to contribute to MySQL. Of course, there are a lot of strong and varying opinions in this area.

    As I said above,


      [Read more...]
    A BoF on Community Code Contributions to MySQL
    Employee +0 Vote Up -0Vote Down

    The BoF schedule for MySQL Conference and Expo (2009) is now published. Lenz Grimmer, Sergei Golubchik, Tomas Ulin and myself will be available during a BoF which focuses on MySQL Community Code Contributions. Lenz will be moderating. For background material, you may start here.


    A BoF on Community Code Contributions to MySQL
    Employee +0 Vote Up -0Vote Down

    The BoF schedule for MySQL Conference and Expo (2009) is now published. Lenz Grimmer, Sergei Golubchik, Tomas Ulin and myself will be available during a BoF which focuses on MySQL Community Code Contributions. Lenz will be moderating. For background material, you may start here.


    A BoF on Community Code Contributions to MySQL
    Employee +0 Vote Up -0Vote Down

    The BoF schedule for MySQL Conference and Expo (2009) is now published. Lenz Grimmer, Sergei Golubchik, Tomas Ulin and myself will be available during a BoF which focuses on MySQL Community Code Contributions. Lenz will be moderating. For background material, you may start here.


    Drizzle low-hanging-fruit
    +0 Vote Up -0Vote Down

    We have an ongoing Drizzle milestone called low-hanging-fruit. The idea is that when there’s something that  could be done, but we don’t quite have the time to do it immediately, we’ll add a low-hanging-fruit blueprint so that people looking to get a start on the codebase and contributing code to Drizzle have a place to go to find things to do.

    Some of my personal favourites are:

      [Read more...]
    Developing with MySQL Connector/C++
    Employee +0 Vote Up -0Vote Down
    Giri Mandalika has written an article showing how to develop C++ database applications for MySQL and another article showing how to install MySQL Connector/C++ from the source.
    Developing with MySQL Connector/C++
    Employee +0 Vote Up -0Vote Down
    Giri Mandalika has written an article showing how to develop C++ database applications for MySQL and another article showing how to install MySQL Connector/C++ from the source.
    Developing with MySQL Connector/C++
    Employee +0 Vote Up -0Vote Down
    Giri Mandalika has written an article showing how to develop C++ database applications for MySQL and another article showing how to install MySQL Connector/C++ from the source.
    MySQL Conference Notes
    Employee +0 Vote Up -0Vote Down

    MySQL Conference 2009 is coming around the corner, next week, in Santa Clara.

    You may want to delve into the notes, as a fast way to learn about the happenings.

    If you want to become an active code contributor to MySQL, the hackfest by Mark Callaghan seems interesting, and you should probably also start here and here

    There will also be a special BoF geared to community contributors. (I still haven't been able to find out

      [Read more...]
    Previous 30 Newer Entries Showing entries 91 to 120 of 180 Next 30 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.