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 121 to 150 of 171 Next 21 Older Entries

Displaying posts with tag: code (reset)

MySQL Ideas for Google Summer of Code (GSoC)
Employee +0 Vote Up -0Vote Down


Check out the ideas from MySQL for Google Summer of Code 2009!

These are specially-selected projects for students who are looking to do some coding in a real, open-source, highly-adopted software environment. 

The learning experience will be tremendous given that MySQL engineers will be mentoring them. 

Some student stipend is provided by the Google Summer of Code. It is intended for students to gain "exposure to real-world software development scenarios and the opportunity for employment in areas related to their academic pursuits."

MySQL Ideas for Google Summer of Code (GSoC)
Employee +0 Vote Up -0Vote Down


Check out the ideas from MySQL for Google Summer of Code 2009!

These are specially-selected projects for students who are looking to do some coding in a real, open-source, highly-adopted software environment. 

The learning experience will be tremendous given that MySQL engineers will be mentoring them. 

Some student stipend is provided by the Google Summer of Code. It is intended for students to gain "exposure to real-world software development scenarios and the opportunity for employment in areas related to their academic pursuits."

MySQL Ideas for Google Summer of Code (GSoC)
Employee +0 Vote Up -0Vote Down


Check out the ideas from MySQL for Google Summer of Code 2009!

These are specially-selected projects for students who are looking to do some coding in a real, open-source, highly-adopted software environment. 

The learning experience will be tremendous given that MySQL engineers will be mentoring them. 

Some student stipend is provided by the Google Summer of Code. It is intended for students to gain "exposure to real-world software development scenarios and the opportunity for employment in areas related to their academic pursuits."

Google Summer of Code: Help improve MySQL documentation!
Employee +0 Vote Up -0Vote Down

MySQL is participating in Google Summer of Code 2009 (GSoC for short), and so is the MySQL documentation team. We've just put our ideas on this page; you might want to have a look if you're interested in applying for a GSoc project.

One of the projects is purely technical and doesn't involve writing any documentation, but rather improving the technique that goes on behind the scenery.

The other project does involve writing documentation, but it's mostly (if not exclusively) about creating examples for the Connectors & APIs chapter of

  [Read more...]
Choosing the Tools for Release Management
+0 Vote Up -0Vote Down
When planning which tools you use to maintain, build, and deploy your database, it is important to look at what tools are already available and in use within your organization. Using existing tools can save you a lot of time and helps standardize processes across your organization. If you manage both application development and database development - integrate your tools and processes from the onset to make your release cycles as smooth as possible.
New Sun Contributor Signatories for MySQL
Employee +0 Vote Up -0Vote Down

I just checked the "Sun Contributor Agreement" (SCA) signatories list, and there are already 11 people who have signed the contributor agreement with an intent to contribute to MySQL.

Among the signatories, you will also notice Paul McCullagh of PrimeBase/PBXT fame. (To learn about how to submit your SCA paperwork, see here.)

Signing the SCA with an intent to contribute to any given Sun-sponsored open-source project would also suffice when it comes to contributing to any other Sun-sponsored open-source project.

So, as an example, Nils Goroll is


  [Read more...]
New Sun Contributor Signatories for MySQL
Employee +0 Vote Up -0Vote Down

I just checked the "Sun Contributor Agreement" (SCA) signatories list, and there are already 11 people who have signed the contributor agreement with an intent to contribute to MySQL.

Among the signatories, you will also notice Paul McCullagh of PrimeBase/PBXT fame. (To learn about how to submit your SCA paperwork, see here.)

Signing the SCA with an intent to contribute to any given Sun-sponsored open-source project would also suffice when it comes to contributing to any other Sun-sponsored open-source project.

So, as an example, Nils Goroll


  [Read more...]
New Sun Contributor Signatories for MySQL
Employee +0 Vote Up -0Vote Down

I just checked the "Sun Contributor Agreement" (SCA) signatories list, and there are already 11 people who have signed the contributor agreement with an intent to contribute to MySQL.

Among the signatories, you will also notice Paul McCullagh of PrimeBase/PBXT fame. (To learn about how to submit your SCA paperwork, see here.)

Signing the SCA with an intent to contribute to any given Sun-sponsored open-source project would also suffice when it comes to contributing to any other Sun-sponsored open-source project.

So, as an example, Nils Goroll


  [Read more...]
The Juice is Loose - MySQL Benchmark
+0 Vote Up -0Vote Down

Well I am still not happy with a lot of the code, but I have had some people ask me to help test my attempt at a new MySQL benchmark. So I cleaned up the code a bit and pushed what I had to LaunchPad. It’s way to early for this to be ready for prime time, I am using it to stress flash, but as I do i am still finding issues, so use at your own risk. My goal is to make this more generic and allow user customizable SQL files to be loaded in…. something like:

1 | select * from table where a =?  |  rand | a | 1000
2 | select * from table1,table2 where table1.id=table2.id and c = ? and d=? | rand,1-200 | c,d | 10

This would mean execute query #1 , using a random value from a 1000 times in a loop before exiting… and then execute query 2, 10 times using a rand value from c, and a value between 1-200 for d….

But that is a ways off.

For now I support 4 tests which

  [Read more...]
TomTom Linux impact light hit so far
+0 Vote Up -0Vote Down

I’ve been talking to device manufacturers and the Linux-centered software providers that feed them code for mobile phones, TV set-top boxes, industrial control, automotive technology, medical devices, military uses and a slew of other categories commonly classified as embedded devices, and I can definitively report that I am not hearing or sensing any fear, uncertainty or doubt (FUD) as a result of Microsoft’s TomTom patent suit.

I wrote last month that the controversial MS TomTom suit was not aimed at Linux as much as TomTom and some market categories for Microsoft. While we must all remind ourselves that anything may be possible considering court rulings and Microsoft strategies, I don’t see Microsoft’s TomTom suit as truly aimed at Linux. If

  [Read more...]
Using the google graph API with MySQL stored functions
+0 Vote Up -0Vote Down
After reading Alex’s blog post on generating graphs using google’s graph API I decided to do something similar for MySQL. I created a stored function that takes a height, width and a graph type from the list of available graph types in the graph API. The function returns a url to a google graph that [...]
Improving the Storage Engine “API”
+0 Vote Up -0Vote Down

I increasingly enclose the API part of “Storage Engine API” in quotes as it does score a rather large number on the API Design Rusty levels (Coined by Rusty Russell). I give it a 15 (out of 18. lower is better) in this case “The obvious use is wrong”.

The ideas is that your handler gets called to write a row (the amazingly named handler::write_row()). It’s passed a buffer which is the row to be stored. An engine that uses the MySQL row format (lets say, ARCHIVE) will simply pack the row and write it out.

Unless there is a TIMESTAMP field with auto set on insert. Up until now (and still now in MySQL) the engine had to check if this was the case and make sure the timestamp field was updated.

To remove

  [Read more...]
Fun with the 387
+0 Vote Up -0Vote Down

Filed  GCC bug 39228:

#include <stdio.h>
#include <math.h>
int main()
{
        double a= 10.0;
        double b= 1e+308;
        printf("%d %d %dn", isinf(a*b), __builtin_isinf(a*b), __isinf(a*b));
        return 0;
}

mtaylor@drizzle-dev:~$ gcc -o test test.c
mtaylor@drizzle-dev:~$ ./test
0 0 1
mtaylor@drizzle-dev:~$ gcc -o test test.c -std=c99
mtaylor@drizzle-dev:~$ ./test
1 0 1
mtaylor@drizzle-dev:~$ gcc -o test test.c   -mfpmath=sse -march=pentium4
mtaylor@drizzle-dev:~$ ./test
1 1 1
mtaylor@drizzle-dev:~$ g++ -o test test.c
mtaylor@drizzle-dev:~$ ./test
1 0 1

Originally I found the simple isinf() case to be different on x86 than x86-64, ppc32 and sparc (32 and 64).

After more research,












  [Read more...]
Contributing Code to MySQL -- Some Simple Guidelines
Employee +0 Vote Up -0Vote Down

If you would like to contribute to MySQL development, you can read the relevant top-level page on the MySQL Forge.

This page has some useful links to various forms of contributing to MySQL, including contribution of code to MySQL. (The MySQL|Sun team have recently simplified some of these pages in order to make them more useful to community members and potential contributors.)

Note that after some simple paperwork submitted to Sun ("Sun Contributor Agreement" or "SCA"), any


  [Read more...]
Contributing Code to MySQL -- Some Simple Guidelines
Employee +0 Vote Up -0Vote Down

If you would like to contribute to MySQL development, you can read the relevant top-level page on the MySQL Forge.

This page has some useful links to various forms of contributing to MySQL, including contribution of code to MySQL. (The MySQL|Sun team have recently simplified some of these pages in order to make them more useful to community members and potential contributors.)

Note that after some simple paperwork submitted to Sun ("Sun Contributor Agreement" or "SCA"), any


  [Read more...]
Contributing Code to MySQL -- Some Simple Guidelines
Employee +0 Vote Up -0Vote Down

If you would like to contribute to MySQL development, you can read the relevant top-level page on the MySQL Forge.

This page has some useful links to various forms of contributing to MySQL, including contribution of code to MySQL. (The MySQL|Sun team have recently simplified some of these pages in order to make them more useful to community members and potential contributors.)

Note that after some simple paperwork submitted to Sun ("Sun Contributor Agreement" or "SCA"), any


  [Read more...]
Golden Rules for Contribution-based Communities
Employee +0 Vote Up -0Vote Down

There are some basic, golden rules when it comes to having a vibrant community of contributors.

The following are rules I have extracted and learned based on my experience managing and working with engineers actively involved and participating in the Apache/Derby, PostgreSQL and MySQL open-source communities. These rules are also based on extensive discussions with many folks involved with the MySQL community, with the PostgreSQL community and with the Apache/Derby (Java DB) community, over many years.

Before I go through these rules, I would like to thank Marten Mickos for having suggested some of the headings for these rules. (I originally had much longer headings for all of them.) I would also like to thank many of MySQL, PostgreSQL and Java DB colleagues, as well as to many other colleagues involved in open-source development, for having

  [Read more...]
Golden Rules for Contribution-based Communities
Employee +0 Vote Up -0Vote Down

There are some basic, golden rules when it comes to having a vibrant community of contributors.

The following are rules I have extracted and learned based on my experience managing and working with engineers actively involved and participating in the Apache/Derby, PostgreSQL and MySQL open-source communities. These rules are also based on extensive discussions with many folks involved with the MySQL community, with the PostgreSQL community and with the Apache/Derby (Java DB) community, over many years.

Before I go through these rules, I would like to thank Marten Mickos for having suggested some of the headings for these rules. (I originally had much longer headings for all of them.) I would also like to thank many of MySQL, PostgreSQL and Java DB colleagues, as well as to many other colleagues involved in open-source development, for having

  [Read more...]
Golden Rules for Contribution-based Communities
Employee +0 Vote Up -0Vote Down

There are some basic, golden rules when it comes to having a vibrant community of contributors.

The following are rules I have extracted and learned based on my experience managing and working with engineers actively involved and participating in the Apache/Derby, PostgreSQL and MySQL open-source communities. These rules are also based on extensive discussions with many folks involved with the MySQL community, with the PostgreSQL community and with the Apache/Derby (Java DB) community, over many years.

Before I go through these rules, I would like to thank Marten Mickos for having suggested some of the headings for these rules. (I originally had much longer headings for all of them.) I would also like to thank many of MySQL, PostgreSQL and Java DB colleagues, as well as to many other colleagues involved in open-source development, for having

  [Read more...]
Upload Image to MySQL using PHP
+0 Vote Up -0Vote Down
Upload Image to MySQL using PHP As a new-bie to php/mysql, I tried different stuffs. So here I’m with my php code for Image Upload to MySQL. Its a quite […]
Progress in nofrm branch
+0 Vote Up -0Vote Down

“Ban FRM Now!” branch in Launchpad

Now we’re reading part of the table information out of the proto file on disk instead of the frm.

Not everything (yet) but a bit. Good first steps. Had to fix bugs along the way as well (and find weirdness in FRM file format…).

Progress is being made.

Source Control Layouts for Databases
+0 Vote Up -0Vote Down
It’s easy to decide that you’re going to store changes to your database in source control, but it can be difficult to figure out what and where it should be stored.  In this article I’ll explain what I like to see put into source control, and how I layout my source control folders. There are […]
Perl Script for Analyze – Optimize – Repair Mysql Databases
+0 Vote Up -0Vote Down
The perl script is mainly created to avoid manual Mysql Server Maintenance. The script uses Perl module DBI. You need to provide access credentials and database name(optional). Regarding Analyse, Optimize […]
Performance notes on INFORMATION_SCHEMA tables
+0 Vote Up -0Vote Down
I have written a bit in the past about using INFORMATION_SCHEMA tables, and I use them extensively in stored procedures for performing regular maintenance operations. There are a great many clever and useful things you can do with them. However, recently I have been noticing some performance issues using these tables that puts a damper […]
Interesting SQL Challenge
+0 Vote Up -0Vote Down
A former colleague recently posed a problem to me: “This guy has a table full of table names, and he wants to run a query that unions those tables.” I spent a couple of minutes telling him why it was a bad idea. It’s not a very robust solution, and an incorrect value in your […]
libmallocfail
+0 Vote Up -0Vote Down

Bazaar branches of libmallocfail

Simple LD_PRELOAD library that will take parameters via environment variables and cause malloc() to occationally fail.

Aim was to use this to test bits of MySQL/Drizzle although since their libtool based stuf, the binary in tree is a libtool shell script, and I haven’t found a way to LD_PRELOAD only for mysqld and not the shell script and the other processes spawned by it.

I have found a bug in libc though :)

Using short if statement in programming
+0 Vote Up -0Vote Down

In many programing languages it is possible to shorten if statements using what’s called the ternary operator. It is sometimes referred as the “one line if statement” or the “short if statement”. This can help at times to produce cleaner code, however use this operator wisely as it is not always best to be used for more complicated statements.

PHP Example of an if statement


1
2
3
4
5
6
7
8
if($nFoo > 0)
{
   echo "I'm at the work.";
}
else
{
   echo "I'm at home.";
}

PHP Example using the ternary operator


1
echo $nFoo > 0 ? "I'm at the work." : "I'm at home.";

The expression (expr1) ? (expr2) : (expr3) evaluates to expr2 if

  [Read more...]
Project Kenai
+0 Vote Up -0Vote Down

Sun is a huge company. So it comes as no surprise that I’m finding out about Project Kenai via Tim Bray, instead of some internal mailing list (believe me, there must be thousands).

Tim’s got a Q&A with Nick Sieger, who’s one of the chieftains behind Kenai. I find it amusing that the comparison is made against Google Code and GitHub - has SourceForge hit irrelevancy? I’m surprised Launchpad isn’t mentioned.


Very Cover Flow like UI, with slider, etc. That’s Elliot Murphy, ex-Dolphin, current Ubuntero in the pic

  [Read more...]
how to fix eleven bugs in mysql 5.1
+0 Vote Up -0Vote Down
my “mysql client fixes” branch on launchpad contains fixes for eleven bugs (nine of them reported on bugs.mysql.com).

don’t get too excited — these are all the lowest priority-level bugs, mostly typos in comments and documentation.

now i have to figure out the latest process for actually getting these changes into the official tree. there are different policies around how and when to push to trees since i was last doing any server development. from someone who is partially outside, it all seems very tedious and designed to make it impossible to fix anything. process gone bad.

the mysql server isn’t going to get the benefits of using a good, open-source distributed revision control system unless it stops
Creating an Intermediate Replication Layer
+0 Vote Up -0Vote Down
A few weeks ago, I discussed how to keep binlogs in sync in a tree or pyramid replication scheme. That thread discussed how to re-distribute load in case of failure in one of the intermediate slaves. Today we will look at how to create those intermediate replication slaves. We start with a traditional flat replication […]
Previous 30 Newer Entries Showing entries 121 to 150 of 171 Next 21 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.