Tag Info

New answers tagged

0

No, the DMVs track aggregates, not individual executions, so you can't pinpoint things like that. Want to drill in, you'll need to capture queries using server-side trace, extended events, management data warehouse or a 3rd party monitoring tool. The latter cost money but you get what you pay for. We have one I could recommend...


0

This kind of sounds like poor flushing behavior, ideally you'd be seeing consistent IO not stretches of 90 and 25. What is the adaptive flushing method in use (or is it off)? keep_average? Is flushing neighbor pages enabled? Sometimes this helps, sometimes this really isn't efficient to do. Generally, its good on spinning disks so probably not the issue ...


1

Broadly, they mean that the partition(s) that need to be accessed will be determined at runtime. In the first plan, where both are KEY, some earlier step in the plan is producing one or more values for the partition key. Those partition keys are then used to determine which partitions Oracle needs to scan the index for. In the second plan, the ROWID from ...


1

OBSERVATION #1 Take a look back at your top output Cpu(s): 84.0%us, 5.1%sy, 0.0%ni, 0.0%id, 0.0%wa, 4.5%hi, 5.0%si, 1.4%st See the last status variable 1.4%st ? What is that ? According to In Linux “top” command what are us, sy, ni, id, wa, hi, si and st (for CPU usage)? st, "steal time", is only relevant in virtualized environments. It ...


1

Improving performance is usually not a single stop solution. But looking at your conf and the results of mysql tuner you can do the following Increase innodb_buffer_pool_size by a LOT. That is usually quite critical for InnoDB tables. Further set the following two paramenters in you cnf file for InnoDB sort_buffer_size=2M join_buffer_size=2M You ...


1

From the online manual http://dev.mysql.com/doc/refman/5.6/en/show-open-tables.html The number of table locks or lock requests there are for the table. For example, if one client acquires a lock for a table using LOCK TABLE t1 WRITE, In_use will be 1. If another client issues LOCK TABLE t1 WRITE while the table remains locked, the client will block ...


1

I wrote these posts Mar 28, 2014 : MySQL not releasing memory Apr 24, 2012 : How costly is opening and closing of a DB connection? May 24, 2011 : What are user connections - when are the created and destroyed? and discussed the many buffers that are allocated for each connection. They are part of RAM and not encapsulated within the cache. Since the ...



Top 50 recent answers are included