TFS 0.X How to speed UP data base?

[neravia]

Hello.
How to speed UP data base in tfs 0.3.7?
Who have good settings or others idea?

 

[sharinn]

speedup your hard drive

 

[potinho]

Use SSD in your host, set

startupDatabaseOptimization

as

true

and check on perf top or htop which process is consuming resources. Database isn't the most common reason of performance problems. And check our last thread about my.cnf configuration.

 

[neravia]

Use SSD in your host, set

startupDatabaseOptimization

as

true

and check on perf top or htop which process is consuming resources. Database isn't the most common reason of performance problems. And check our last thread about my.cnf configuration.

Hi. I have SSD and optimization set to true. For my.cnf i use your config.

In putty i see: no tables for optimization.

 

[potinho]

Hi. I have SSD and optimization set to true. For my.cnf i use your config.

In putty i see: no tables for optimization.

I guess we need to understand one thing: why this need to optimize? Is your server slow or lagged because DB? There's too much database I/O?

 

[neravia]

I guess we need to understand one thing: why this need to optimize? Is your server slow or lagged because DB? There's too much database I/O?

Sometimes i have lags and lost comnection to database.
(OTX2 working on tfs 0.3.7)

 

[lukaszml]

Why are you creating another topic if you got a good answer in the previous one.... ?

Best settings for MySQL.

Hello. Who can share best options my.cnf for TFS 0.3.7?

otland.net

 

[neravia]

Why are you creating another topic if you got a good answer in the previous one.... ?

Best settings for MySQL.

Hello. Who can share best options my.cnf for TFS 0.3.7?

otland.net

This is data base settings topic.
Not only settings can speed UP data base.
If u see, hard drive and others too...