hi All how we can allocate memory for mysql database. since we have different storage. each having its own buffer for running the query. in oracle we have some calculation for allocating sga size,like this any method is exist for mysql.
i am seeing mysql is using default 8m for all (myisam and innodb). how to increase the memory size for innodb and myisam innodb_buffer_pool_size --> 8388608 innodb_additional_mem_pool_size --> 1048576 in oracle,we have dynamic memory and static memory. we can update dynamic memory in online but for static we need to shutdown and startup the db. , what about for mysql. Architecture wise both database has huge different but i need some idea to upgrade my mysql server please assist me.. thanks in advance.. Best Regards Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com