You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » What are the suggested optimization settings for a MYSQL and/or MS SQL
Post a reply
Topic review (newest first)
- richiesgr
- 2008-11-13 08:27:45
So What Is there any improvement ?
- james Oswald
- 2008-06-16 20:12:16
I have done that to all of the tables as well as expanding the key buffer from 16 megs to 64M.
- james Oswald
- 2008-06-16 20:12:15
I have done that to all of the tables as well as expanding the key buffer from 16 megs to 64M.
- parham
- 2008-06-16 19:43:12
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.
- James Oswald
- 2008-06-16 19:31:24
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