optimize mysql how?

[TKO]

Hello how can you optimize mysql?

 

[Cykotitan]

Edit your my.ini/my.cnf, adjust the cache and buffer variables and use only 1 table engine (disable the other)

 

[TKO]

This hard todo?

 

[vBzone]

thanks

 

[Cykotitan]

Use google, you could also check the 'Status' tab in phpMyAdmin to get a general overview of what variables should be changed.

 

[TKO]

no tips what to look for in the configs and on status? is it bad it they numbers are in red?

 

[Cykotitan]

It depends on what is in red, you can't make them all go green only by optimizing MySQL, your website scripts and TFS could be causing it too

 

[Lucenzo]

@Cykotitan

key_buffer		= 16M
max_allowed_packet	= 16M
thread_stack		= 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit	= 1M
query_cache_size        = 16M

Anything else and this also depends on hardware settings right? x

 

[Cykotitan]

some of these variables only apply to myisam database engine, are you using innodb or myisam?

 

[Lucenzo]

innodb, already seen your post about possible change to myisam.
Will there be any problems if i do that or is it safe to go?

 

[Cykotitan]

it just won't change anything if you use innodb

 

[ugurdrahs]

@Cykotitan

key_buffer		= 16M
max_allowed_packet	= 16M
thread_stack		= 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit	= 1M
query_cache_size        = 16M

Anything else and this also depends on hardware settings right? x

lol. what happends if u do this?

the server will run faster? with less laggs?

 

[Lucenzo]

That's the basic ini file. Which needs editing :L