Tag Info

New answers tagged

0

To know whether 7 is high or low, you'd need to know something about the database server. If, for example, you have a single CPU with 4 cores, 7 sessions would mean that, at any given time, 3 of your 7 threads were probably waiting to get scheduled for the CPU since your machine is only capable of running 4 sessions at any instant in time. That would imply ...


0

pagefile.sys % Usage shows total system committed not what currently is utilized. This value can increase due to load when system finds out it has to back process with more page file. Have a look at below link for detailed explanation http://blogs.technet.com/b/perfguru/archive/2008/01/08/explanation-of-pagefile-usage-as-reported-in-the-task-manager.aspx I ...


0

If all you want to do is waste a lot of space, you don't need a fancy table at all. A single varchar(4000) (filled up) should be enough: SQL> create table foo(a varchar(4000)); Table created. SQL> insert into foo select rpad(to_char(rownum), 4000, '*') from dual connect by level <= 1024 ; 1024 rows created. SQL> exec ...


4

Your query_cache_min_res_unit is 4KB and you have 6GB of query cache free ? Look at this 6 MB = 6144 KB 6144 KB divided by 4KB/query = 1536 queries. You can potentially fit up 1536 small query results in that 6GB of free space in the query cache. That 6GB is most likely being viewed as memory fragmentation. Why ? According to the MySQL Documentation on ...



Top 50 recent answers are included