You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » What are the suggested optimization settings for a MYSQL and/or MS SQL
#1 2008-06-16 19:31:24
- James Oswald
- Guest
What are the suggested optimization settings for a MYSQL and/or MS SQL
What are the suggested optimization settings for a MYSQL and/or MS SQL talend database.
Currently I'm using the 2.3.3 Integration Suite with a project that has 50 jobs. 1 job calls 4 jobs, which 2 of the jobs call 22 to 29 jobs.
So when opening this jobs that call other jobs (Sequencers) they take a long time. This also happens with any save or run.
WHat I'm looking for is any recommended tuning we can do to the MYSQL talend database that would speed this up.
(I would post those images, but I can't get them to generate either). The Generate documnetation takes hours and sometimes doesn't generate the documentation for the overall job and the job that calls 29 other jobs.
James
#2 2008-06-16 19:43:12
Re: What are the suggested optimization settings for a MYSQL and/or MS SQL
you can perform some basic tunning on the MYSQL db. please open the mysql administrator and perform maintenance options by right clicking on all the db tables and choosing the db optimization option. let's see if this improves your performance.
Offline
#3 2008-06-16 20:12:15
- james Oswald
- Guest
Re: What are the suggested optimization settings for a MYSQL and/or MS SQL
I have done that to all of the tables as well as expanding the key buffer from 16 megs to 64M.
#4 2008-06-16 20:12:16
- james Oswald
- Guest
Re: What are the suggested optimization settings for a MYSQL and/or MS SQL
I have done that to all of the tables as well as expanding the key buffer from 16 megs to 64M.
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » What are the suggested optimization settings for a MYSQL and/or MS SQL