Full Table Scan / Sequential Scan in MySQL: Understanding when this happens with EXPLAIN statement and avoiding optimizer’s choice of incorrect table scan
Post @ http://singztechmusings.in/full-table-scan-sequential-scan-in-mysql-understanding-when-this-happens-with-explain-statement-and-avoiding-optimizers-choice-of-incorrect-table-scan/
Posted at 11:22 PM on January 11, 2012 | leave a comment | Filed Under: Database, MySQL, SQL | Tagged: Databases, Dimension tables, Explain plan, Full table scan, Index (database), MySQL, mysqld, Select (SQL) | read on
Command-line Options for Java HotSpot VM (Virtual Machine) Performance Tuning
Post @ http://singztechmusings.in/java-hotspot-vm-virtual-machine-performance-tuning-command-line-options/
Posted at 9:41 PM on January 10, 2012 | leave a comment | Filed Under: Java, Java Internals, Performance Tuning | Tagged: ASCII, Code Cache, Heap, Hotspot VM, JVM, Performance Tuning, Permanent Generation, Thread Stack | read on
Singaram Subramanian
