The default configuration file for MySQL is intended not to use many resources, because its a general purpose sort of a configuration file. The default configuration does enough to have MySQL running happily with limited resources and catering to simple queries and small data-sets. The configuration file would most definitely need to be customized and tuned if you intend on using complex queries and when you have good amount of data. Most of the tunings mentioned in this post are applicable to the MyISAM storage engine, I will soon be posting tunings applicable to the Innodb storage engine. Getting started...
Dear Kettle fans,
One of the things that’s been on my TODO list for a while was the creation of a resource exporter…
It’s called “Resource exporter” and not “Job exporter” or “Transformation exporter” because it is intended to export more than just a single job or transformation. It exports all linked resources of a job or transformation.
The means that if you have a job that has 5 transformation job entries, you will be exporting 6 resources (1 job and 5 transformations). If those transformations use 3 sub-transformations (mappings) you will in total export 9 resources.
The whole idea behind this exercise is to be able to create a package (for example to send to someone) that has all needed resources contained in a single zip file.
Let’s …[Read more]