Hi,
I am using MySQL 5 as my database
I am not able to set variables query_alloc_blo ck_size, query_prealloc_ size and read_buffer_siz e. I tried SET GLOBAL command. I tried in Windows env and Linux env.
When I executed SQL Statement,
SET GLOBAL query_prealloc_ size = 32768;
Its not giving any error, but when i checked in variables, it is same as 8192(old value).
same thing for other variables also...
I tried to run simple select statement from C program infinite times and after few minutes, it was taking too much time to execute SQL statements. Can please anybody suggest me to change any parameters so that performance is not degraded or do something else.
Thanx in advance for your time and help
regards
sarma
I am using MySQL 5 as my database
I am not able to set variables query_alloc_blo ck_size, query_prealloc_ size and read_buffer_siz e. I tried SET GLOBAL command. I tried in Windows env and Linux env.
When I executed SQL Statement,
SET GLOBAL query_prealloc_ size = 32768;
Its not giving any error, but when i checked in variables, it is same as 8192(old value).
same thing for other variables also...
I tried to run simple select statement from C program infinite times and after few minutes, it was taking too much time to execute SQL statements. Can please anybody suggest me to change any parameters so that performance is not degraded or do something else.
Thanx in advance for your time and help
regards
sarma