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 150

Displaying posts with tag: Technology (reset)

Customizing db_STRESS
Employee +0 Vote Up -0Vote Down

One of our colleagues, Dimitri, at the Paris Sun solution center has developed a real neat and useful tool called dim_STAT. To make it short it's a tool for both high-level and detailed, monitoring and performance analysis of Solaris and Linux systems.

Data is collected and saved in a MySQL database, and it provides a very functional web base user interface. It allows real time or off line monitoring, multi-host etc.

Actually what is really interesting with dim_STAT is that, when I'm benchmarking or tryinng to find a performance bottleneck, I can collect all the data I need and come back later for analysis.

Recently, Dimitri has added a new tool db_STRESS, that allows us to put load on a database system and gives a high level metric (TPS: Transactions per seconds) and therefor allows us to compare how different systems

  [Read more...]
ActiveState Perl 5.10, Windows XP, and DBD-mysql
+0 Vote Up -0Vote Down

A few months ago I installed ActivePerl 5.10 on a Windows XP Pro workstation. Next I tried to install DBD::mysql using CPAN, it failed. When I browsed modules via ppm, a GUI in this version of ActiveState Perl on Windows, DBD::mysql was not listed as an available module.

I then downloaded the source code, manually modified the MAKE file, fiddled with Visual Studio NMAKE, compiled it a few times, without success.

Google revealed the existence of Strawberry Perl. So I removed ActiveState Perl, installed Strawberry, ran ppm install DBI, ppm install DBD-mysql. And it worked.

Fast-forward a few weeks, I started playing with EPIC, a plugin for Eclipse that supposedly provides a nice IDE for Perl development and debugging. As a result, I started fiddling with PadWalker, a prerequisites for EPIC. I couldn’t

  [Read more...]
new wiki for connector/net
Employee +0 Vote Up -0Vote Down

We have started a new project wiki for MySQL Connector/Net.  It’s a little light in content right now but should grow rapidly.  It can be found here.  Please let us know what we can do better.

mysql connector/net 6.0.3 GA has been released
Employee +0 Vote Up -0Vote Down

MySQL Connector/Net 6.0.3, a new version of the all-managed .NET driver for MySQL has been released.  This is the first GA release of the new 6.0 connector and introduces several new features and enhancements.  This release is approved for use in all scenarios and officially supports MySQL servers 4.1 and higher.   We had three major goals with this release:  speed, entity framework support, and a better Visual Studio experience.  I'm happy to report that we have met all three.

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.0.html] and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another

  [Read more...]
mysql connector/net 5.2.6 has been released
Employee +0 Vote Up -0Vote Down

MySQL Connector/Net 5.2.6, a new version of the all-managed .NET driver for MySQL has been released.  This release is of GA quality and is suitable for  use in production environments.  We strongly urge you to  review the change log that is shipped with the product for a thorough review of the changes.

We have a ton of fixes in this release so please review the changelog and see if your favorite bug has been fixed.  This version officially supports all versions of MySQL from 4.1 and later.

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/5.2.html] and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose

  [Read more...]
Workbench Rocking
Employee +1 Vote Up -0Vote Down

Mike Hillyer talks about MySQL Workbench. Very nice workshop! (Hillyer will make slides and screen recording of his talk available.)

This is a great platform-native application. All presentation code is written for each specific platform. It is the second most-popular download and the second most purchased product in the MySQL online shop.  There's a community edition and there's a standard edition of the Workbench. People in the workshop got a 1 year subscription to the commercial, standard edition.

I'm sitting in the room here in MySQL Conference. I'm running a WB 5.1 edition I've built on my MacBook Pro laptop.

Workbench Rocking
Employee +0 Vote Up -0Vote Down

Mike Hillyer talks about MySQL Workbench. Very nice workshop! (Hillyer will make slides and screen recording of his talk available.)

This is a great platform-native application. All presentation code is written for each specific platform. It is the second most-popular download and the second most purchased product in the MySQL online shop.  There's a community edition and there's a standard edition of the Workbench. People in the workshop got a 1 year subscription to the commercial, standard edition.

I'm sitting in the room here in MySQL Conference. I'm running a WB 5.1 edition I've built on my MacBook Pro laptop.

Workbench Rocking
Employee +0 Vote Up -0Vote Down

Mike Hillyer talks about MySQL Workbench. Very nice workshop! (Hillyer will make slides and screen recording of his talk available.)

This is a great platform-native application. All presentation code is written for each specific platform. It is the second most-popular download and the second most purchased product in the MySQL online shop.  There's a community edition and there's a standard edition of the Workbench. People in the workshop got a 1 year subscription to the commercial, standard edition.

I'm sitting in the room here in MySQL Conference. I'm running a WB 5.1 edition I've built on my MacBook Pro laptop.

Another Pluggable Storage Engine for MySQL
Employee +0 Vote Up -0Vote Down

Kazuho Oku of Cybozu Labs, Inc., a community contributor to MySQL and SCA signatory, gives a talk on Q4M, a message queue stroage engine for MySQL.

Kaj Shoot Out on Cloud Computing
Employee +0 Vote Up -0Vote Down
I'm sitting in Kaj Arnö's Cloud Computing Shoot Out here in the MySQL Confernce & Expo. Great panel, great discussion! The important question, always, is about business models related to storage vs. compute clouds.
Another Pluggable Storage Engine for MySQL
Employee +0 Vote Up -0Vote Down

Kazuho Oku of Cybozu Labs, Inc., a community contributor to MySQL and SCA signatory, gives a talk on Q4M, a message queue stroage engine for MySQL.

Another Pluggable Storage Engine for MySQL
Employee +0 Vote Up -0Vote Down

Kazuho Oku of Cybozu Labs, Inc., a community contributor to MySQL and SCA signatory, gives a talk on Q4M, a message queue stroage engine for MySQL.

Kaj Shoot Out on Cloud Computing
Employee +0 Vote Up -0Vote Down
I'm sitting in Kaj Arnö's Cloud Computing Shoot Out here in the MySQL Confernce & Expo. Great panel, great discussion! The important question, always, is about business models related to storage vs. compute clouds.
Kaj Shoot Out on Cloud Computing
Employee +0 Vote Up -0Vote Down
I'm sitting in Kaj Arnö's Cloud Computing Shoot Out here in the MySQL Confernce & Expo. Great panel, great discussion! The important question, always, is about business models related to storage vs. compute clouds.
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.


mysql connector/net 6.0.2 beta has been released
Employee +0 Vote Up -0Vote Down

Hi,
MySQL Connector/Net 6.0.2, a new version of the all-managed .NET driver for MySQL has been released.  This is a beta release and is intended to introduce you to the new features and enhancements we are planning.  This release should not be used in a production environment.

This release was quickly pushed out due to a problem that caused 6.0.1 to not register with Visual Studio correctly.  We also made a small correction to a previous bug fix.  SQL generated from entity framework for stored procedures will now not directly reference the schema.  This allows the model to move to a different database without need of change.  We had previously made this change for tables but failed to do so for procedures.

It is now available in source and binary form from [


  [Read more...]
mysql connector/net 6.0.1 beta has been released
Employee +0 Vote Up -0Vote Down

MySQL Connector/Net 6.0.1, a new version of the all-managed .NET driver for MySQL has been released. This is a beta release and is intended to introduce you to the new features and enhancements we are planning. This release should not be used in a production environment.

We had three major goals with this release. Speed, Entity Framework support, and a better Visual Studio experience. I'm happy to report that we have met all three. Please see the complete list of changes below.

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.0.html] and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site.)

  • Massive speedups. We have increased the speed of the provider. In
  [Read more...]
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."

Simon on the WSJ
Employee +0 Vote Up -0Vote Down
Simon Phipps, Sun's Chief Open Source Officer, speaks to The Wall Street Journal.
MySQL University: MySQL and ZFS
+0 Vote Up -0Vote Down

I didn’t announce it last week, but I did a MySQL University presentation on using MySQL with the ZFS filesystem. ZFS is the main filesystem for Solaris/OpenSolaris and offers a number of different benefits for people using MySQL, including some improvements to the ease of use, management, and performance of the storage you use with your MySQL database.

You can get the presentation, and the recordings of the presentation, from the appropriate MySQL University page: MySQL and ZFS.

Simon on the WSJ
Employee +0 Vote Up -0Vote Down
Simon Phipps, Sun's Chief Open Source Officer, speaks to The Wall Street Journal.
Simon on the WSJ
Employee +0 Vote Up -0Vote Down
Simon Phipps, Sun's Chief Open Source Officer, speaks to The Wall Street Journal.
Moving data from Sql Server to MySQL
+0 Vote Up -0Vote Down

To move data from Sql Server to MySQL, it is certainly possible to use tools that can make connections to both data stores and manipulate data that way, such as Access, Excel, or SSIS. Here I will introduce a process that does not need any special tools or data drivers. Instead, we can use the utilities and methods that come with a standard Sql Server and MySQL install to accomplish that task.

With this approach, it is assumed that matching tables already exist on MySQL. If not, they need to be created first.

This process is comprised of these steps: first bcp command will be generated based on Sql Server database meta data (sysobjects, think information_schema in MySQL); then the generated bcp commands will be executed; the resulting csv files can then be transferred to the MySQL server, optionally it is possible to compress them if the size is big; and finally

  [Read more...]
Dropping a table does not remove permissions granted to it in MySQL
+0 Vote Up -0Vote Down

If:

1. A table t1 is created in database test;
2. A login is granted select permission on t1;
3. t1 is dropped and then recreated.

Then that login would still be able to read the newly recreated table t1, even if t1 has totally different columns. The reason is that the table select privilege is stored in tables_priv in mysql database, and when t1 is dropped, that privilege will not be cleared in tables_priv.

Personally, I think this needs to be changed. In other words, when a drop table command is issued, not only the table needs to be dropped, this command should also go to tables_priv in mysql to remove that select permission. Not too sure how big a task that is, perhaps I should try to see if I can implement it myself, after I get comfortable with the source code and development process of MySQL.

MySql connector/net 6.0 alpha has been released
Employee +0 Vote Up -0Vote Down

MySQL Connector/Net 6.0.0, a new version of the all-managed .NET driver for MySQL has been released.  This is an alpha release and is intended to introduce you to the new features and enhancements we are planning.  This release should not be used in a production environment.

We had three major goals with this release.  Speed, Entity Framework support, and a better Visual Studio experience.  I'm happy to report that we have met all three.  Please see the complete list of changes below.

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.0.html] and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose

  [Read more...]
Perl script to convert MySQL character set to utf8
+0 Vote Up -0Vote Down

“Groovy, baby!”, as international man of mystery likes to say.

It seems converting character and text data to utf8 character set is a common task for MySQL, especially during an upgrade. In fact, I had trouble with it during server and WordPress database upgrade for this blog site. I wrote about it in this post, where I explained how to do it step-by-step using a command line tool such as mysql, taking advantage of some nifty code generation trick with information_schema.

One drawback of that method is that it’s a manual process, therefore time-consuming and error-prone.

I spent some time today to cook up a simple Perl script to automate this task. See below. Remember to change MyDatabase to your database name (there are 3 places that

  [Read more...]
Previous 30 Newer Entries Showing entries 121 to 150 of 150

Planet MySQL © 1995, 2013, 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.