Destroyed key cache still usable ?
You can assign a table’s index to a key cache of MSSQL even after you have destroyed it.
To minimize the use of I/O operation, MSSQL provides you with a cache mechanism to maintain a block of memory for frequently used or accessed tables.
You just have to set the size of that particular cache:
mysql> SET GLOBAL key_cache1.key1_buffer_size=256*512;
You can also destroy this cache by setting its size to ‘0’:
mysql> SET GLOBAL key_cache1.key1_buffer_size=0;
But when I tried to reuse this destroyed cache again, it worked fine. I don’t know how this could happen?
Please, make me understand this point.
Know the Answer? Share it...
Destroyed key cache still usable ?
Related Question
Slow performance of SQL server 2005 ?
State a way with which I can get fixed my entire corrupt SQL Database? ?
Suggest a Recovery for repairing the Read only Database in SQL 2000 ?
Is Mdf Repair Software best for SQL Server files of 2005? ?
Suggest for a Database Repair Tool for SQL Server 2005 ?
Suggest a process for fixing a table in Ms Sql? ?
How can you recover the Index Fragmentation in the SQL Database? ?
State a recovery for the corrupt index Database of Ms Sql. ?
Make a recovery for MDF files which has got deleted unexpectedly. ?
You are not allowed to access the database from this machine, please verify your access id or contact database administrator”. What this message indicates? ?
Incorrect Key File for table”….Try to repair it.” What this message specifies? ?
Database got corrupt by SQL Injection Attacks”. How to Repair ?
I am middle in the problem. Facing error in I/O operation on sql. Give solution for best command to repair mssql database ?
The error is generated in database. How to check db space mssql ?
SQL database giving an error on 2000 sql repair tool is working slowly. What to do ?
Getting the errorin SQL 2005: # table corrupted # buffer is too small, unavailability of free disk space. ?
How to run dbcc on mdf file on MS SQL server 2005. Describe some solutions ?
The SQL server log file giving error. How can be repairing ms sql log files ?
my SQL table database does not return any value. How to restore table from mdf file ?
The MS SQL has generated an error while restoring the database. How to recover mssql database ?
SQL is giving an encrypted error. How to fix mdf file of sql server 2005 error ?
Table error: Object ID 0, index ID 0, page ID (1:105). The PageId in the page header = (0:0) ?
Bug in libmysql.dll ?
Destroyed key cache still usable ?
Problem with intensive locking (deadlocks?) during execution of system_1_test ?
Merge table with INDEX statements out of order returns NULL for index columns ?
Overflow must be an error ?
Table name in Error message not in default character set ?
Lost Data with delayed insert or mysqlhotcopy or lock and flush ?
