Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Follow the feed
Showing entries 32591 to 32600 of 45496 « Previous | Next »
Quick tip: how do you rename all files so spaces are converted to underscores?

My friend today asked me how to convert all spaces in filenames under a specified directory to underscores. Also, at the same time lowercase all of the filenames. Here is a quick script to do what is needed. Let us start with creating some test data in a temp directory:

mkdir temp
cd temp
touch Foo FooO "Foo Bar" "FOO BAaR"
\ls | while read -r FILENAME
do
mv -v "$FILENAME" `echo $FILENAME| tr ' ' '_'| tr '[A-Z]' '[a-z]'`
done

Note:  I intentionally have slash in front of ls (\ls).  \ls means that we want to make sure there is no ls alias overwriting our command. This is needed if your system has alias setup to display ls in a different way instead of default listing.  mv -v shows us the filenames being renamed as your script goes through the whole dir.  Your output should be like:

`Foo' -> `foo'
`FOO BAaR' -> …

[Read more]
OSCon 2008 Video: Does Open Source Need to Be Organic?

A panel consisting of Brian Aker of MySQL, Rob Lanphier of Linden Lab, Stephen O'Grady of Redmonk, and Theodore Ts'o of the Linux Foundation gives some answers to the question, "Does Open Source Need to Be Organic?" This topic stemmed from a few posts by Ts'o a few months before OSCon.

From the official conference description:

there’s much more to a software project than just the license. Are software projects dominated by a single company still open source? Does a project need to be 'organic' to be truly open source? What does "organic" even mean in this context? Join us as we discuss these topics and more.

read …

[Read more]
OSCon 2008 Video: State of ... Lightning Talks

"The State of" Lightning talks, moderated by Josh Berkus, is always a great highlight.
OSCon 2008's speakers and projects included:

  • Alan Kasindorf: Memcached
  • Glynn Foster: OpenSolaris
  • OSI: Danese Cooper
  • MySQL: Monty Widenius
  • PostgreSQL: Bruce Momjian
  • GNOME: Dave Neary
  • Gentoo: Donnie Berkholz
  • OpenOffice.org: Louis Suarez-Potts
  • Jabber: Peter Saint-Andre
  • Mozdev: Brian King
  • OpenID: Scott Kveton
  • Open Scrum: James Dixon
  • Talking Book Project: Cliff Schmidt

read more

OSCon 2008 Video: Does Open Source Need to Be Organic?

A panel consisting of Brian Aker of MySQL, Rob Lanphier of Linden Lab, Stephen O'Grady of Redmonk, and Theodore Ts'o of the Linux Foundation gives some answers to the question, "Does Open Source Need to Be Organic?" This topic stemmed from a few posts by Ts'o a few months before OSCon.

From the official conference description:

there?s much more to a software project than just the license. Are software projects dominated by a single company still open source? Does a project need to be 'organic' to be truly open source? What does "organic" even mean in this context? Join us as we discuss these topics and more.

read …

[Read more]
OSCon 2008 Video: Does Open Source Need to Be Organic?

A panel consisting of Brian Aker of MySQL, Rob Lanphier of Linden Lab, Stephen O'Grady of Redmonk, and Theodore Ts'o of the Linux Foundation gives some answers to the question, "Does Open Source Need to Be Organic?" This topic stemmed from a few posts by Ts'o a few months before OSCon.

From the official conference description:

there?s much more to a software project than just the license. Are software projects dominated by a single company still open source? Does a project need to be 'organic' to be truly open source? What does "organic" even mean in this context? Join us as we discuss these topics and more.

read …

[Read more]
OSCon 2008 Video: Does Open Source Need to Be Organic?

A panel consisting of Brian Aker of MySQL, Rob Lanphier of Linden Lab, Stephen O'Grady of Redmonk, and Theodore Ts'o of the Linux Foundation gives some answers to the question, "Does Open Source Need to Be Organic?" This topic stemmed from a few posts by Ts'o a few months before OSCon.

From the official conference description:

there?s much more to a software project than just the license. Are software projects dominated by a single company still open source? Does a project need to be 'organic' to be truly open source? What does "organic" even mean in this context? Join us as we discuss these topics and more.

…

[Read more]
Giv tid!

Vores røde ananas-æbler står utroligt flot her en sensommer-eftermiddag:

 

Jeg holder meget at træer. En af grundene er, at træer tager tid. At plante et æbletræ er at planlægge mange år frem i tiden. Og ingen forventer, at et træ kan vokse op på få måneder eller år. Det giver en ro at arbejde med træer.

God software tager også tid. Linux, Apache, Perl, Emacs, GCC, det er alle projekter som også fandtes for mange år siden mens jeg stadig gik på Universitetet. Selv KDE er snart 12 år gammelt.

Jeg tror at en vigtig faktor i de mange Open Source successer er, at man har taget sig tid til at gøre tingene ordentligt. Jeg har alt for tit oplevet, hvordan manglende forståelse for hvor lang tid softwareudvikling tager har kørt gode projekter af sporet (og ikke kun indenfor proprietær software, se bare MySQL 5.0/5.1).

[PHP, MySQL] Batch changing charset and collation on databases

Recently I needed to quickly change charset on all tables and change each field’s chanset in each table in a specific database to latin1 and collation to latin1_swedish_ci. I googled a little and found this solution by shimon doodkin. I used it and it did work, but also it attempted to change charset at MySQL […]

MySQL Query Analyzer: DBA Task #1: Finding Bad Queries

One of the biggest problems I faced as a field DBA was defending my production databases against poorly performing SQL code. Talking to folks at the MySQL UC, during customer visits and trolling the MySQL forums/blogs confirms that this is a common problem and even more challenging when a performance problem pops up during times when no code promotions have taken place.

Traditional/popular way of finding bad SQL code
For MySQL DBAs the challenge to identify and isolate resource intensive SQL code is really two-fold; job #1 is to find the offending code (after that the chore becomes fixing it so it performs, but that is a topic for another post). Most MySQL DBAs have used the MySQL Slow Query Log ("SQ Log") at some point to help with job #1. For those not familiar, the SQ Log is enabled by starting MySQL with --log-slow-queries[=file_name] option. Once enabled the SQ Log captures queries that took longer than X seconds (user …

[Read more]
OSCon 2008 Video: State of ... Lightning Talks

"The State of" Lightning talks, moderated by Josh Berkus, is always a great highlight.
OSCon 2008's speakers and projects included:

  • Brian Aker: Memcached
  • Glynn Foster: OpenSolaris
  • OSI: Danese Cooper
  • MySQL: Monty Widenius
  • PostgreSQL: Bruce Momjian
  • GNOME: Dave Neary
  • Gentoo: Donnie Berkholz
  • OpenOffice.org: Louis Suarez-Potts
  • Jabber: Peter Saint-Andre
  • Mozdev: Brian King
  • OpenID: Scott Kveton
  • Open Scrum: James Dixon
  • Talking Book Project: Cliff Schmidt

Due to an equipment malfunction, I was able to get all the way through the Open Office lightning talk, but did not get the Gnome lightning talk. Please feel free to let me know about any others that did not make the video cut (or ones that …

[Read more]