This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT * FROM ( | |
| SELECT | |
| table_name, | |
| round(((data_length + index_length) / 1024 / 1024), 2) as size_mb | |
| FROM information_schema.TABLES | |
| WHERE table_schema = "db_name" | |
| ) t | |
| ORDER BY size_mb DESC | |
| LIMIT 5; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/sh | |
| if [ $# -lt 2 ]; then | |
| echo "Usage: $0 <count> <delay>" | |
| exit 1 | |
| fi | |
| count=$1 | |
| delay=$2 | |
| pid=$(sudo -u tomcat jps | grep Bootstrap | cut -d' ' -f1) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import com.sun.management.*; | |
| import java.lang.management.*; | |
| import java.lang.ref.*; | |
| import java.nio.file.*; | |
| import java.util.*; | |
| import java.util.concurrent.*; | |
| import java.util.logging.Logger; | |
| import javax.management.*; |
laszlocsontos
/ javacore.20150724.142128.4450.0005.txt
Created
July 24, 2015 12:35
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 0SECTION TITLE subcomponent dump routine | |
| NULL =============================== | |
| 1TICHARSET UTF-8 | |
| 1TISIGINFO Dump Requested By User (00100000) Through com.ibm.jvm.Dump.JavaDump | |
| 1TIDATETIME Date: 2015/07/24 at 14:21:28 | |
| 1TIFILENAME Javacore filename: /home/lcsontos/thirdfoot/sources/kungfu-concurrency-java/javacore.20150724.142128.4450.0005.txt | |
| 1TIREQFLAGS Request Flags: 0x81 (exclusive+preempt) | |
| 1TIPREPSTATE Prep State: 0x106 (vm_access+exclusive_vm_access+trace_disabled) | |
| NULL ------------------------------------------------------------------------ | |
| 0SECTION GPINFO subcomponent dump routine |
laszlocsontos
/ javacore.20150724.142128.4450.0003.txt
Created
July 24, 2015 12:30
Waiting for lock - IBM javacore
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 0SECTION TITLE subcomponent dump routine | |
| NULL =============================== | |
| 1TICHARSET UTF-8 | |
| 1TISIGINFO Dump Requested By User (00100000) Through com.ibm.jvm.Dump.JavaDump | |
| 1TIDATETIME Date: 2015/07/24 at 14:21:28 | |
| 1TIFILENAME Javacore filename: /home/lcsontos/thirdfoot/sources/kungfu-concurrency-java/javacore.20150724.142128.4450.0003.txt | |
| 1TIREQFLAGS Request Flags: 0x81 (exclusive+preempt) | |
| 1TIPREPSTATE Prep State: 0x106 (vm_access+exclusive_vm_access+trace_disabled) | |
| NULL ------------------------------------------------------------------------ | |
| 0SECTION GPINFO subcomponent dump routine |
laszlocsontos
/ javacore.20150724.142128.4450.0001.txt
Created
July 24, 2015 12:25
Idle thread in thread pool - IBM javacore
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 0SECTION TITLE subcomponent dump routine | |
| NULL =============================== | |
| 1TICHARSET UTF-8 | |
| 1TISIGINFO Dump Requested By User (00100000) Through com.ibm.jvm.Dump.JavaDump | |
| 1TIDATETIME Date: 2015/07/24 at 14:21:28 | |
| 1TIFILENAME Javacore filename: /home/lcsontos/thirdfoot/sources/kungfu-concurrency-java/javacore.20150724.142128.4450.0001.txt | |
| 1TIREQFLAGS Request Flags: 0x81 (exclusive+preempt) | |
| 1TIPREPSTATE Prep State: 0x106 (vm_access+exclusive_vm_access+trace_disabled) | |
| NULL ------------------------------------------------------------------------ | |
| 0SECTION GPINFO subcomponent dump routine |
laszlocsontos
/ gist:39da67d024fba4a1dc8c
Created
July 22, 2015 09:22
Endless loop in java.util.HashMap#get()
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "ajp-bio-8009-exec-37" daemon prio=10 tid=0x00007f346c048000 nid=0xd1b5 runnable [0x00007f3375540000] | |
| java.lang.Thread.State: RUNNABLE | |
| at java.util.HashMap.get(HashMap.java:303) | |
| at com.liferay.portal.security.permission.ResourceActionsImpl.getActions(ResourceActionsImpl.java:724) | |
| at com.liferay.portal.security.permission.ResourceActionsImpl.getPortletResourceGuestUnsupportedActions(ResourceActionsImpl.java:421) | |
| at com.liferay.portal.security.permission.ResourceActionsUtil.getPortletResourceGuestUnsupportedActions(ResourceActionsUtil.java:199) | |
| at com.liferay.portal.security.permission.AdvancedPermissionChecker.hasGuestPermission(AdvancedPermissionChecker.java:905) | |
| at com.liferay.portal.security.permission.AdvancedPermissionChecker.hasPermissionImpl(AdvancedPermissionChecker.java:963) | |
| at com.liferay.portal.security.permission.AdvancedPermissionChecker.hasPermission(AdvancedPermissionChecker.java:603) | |
| at com.liferay.portal.service.permission.PortletPermissionImpl.contains(PortletPermissionImpl.java:28 |
laszlocsontos
/ stack_trace.txt
Last active
August 29, 2015 14:23
Stack Trace Interpretation Example
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "http-bio-9080-exec-1" daemon prio=10 tid=0x00007f9124065800 nid=0x3559 runnable [0x00007f901a611000] | |
| java.lang.Thread.State: RUNNABLE | |
| -------------------------------------------------------------------------------------------------------------------- | |
| --------------------------------------- [[ WHAT DOES THE SUB-COMPONENT DO?]] --------------------------------------- | |
| -------------------------------------------------------------------------------------------------------------------- | |
| at java.net.SocketInputStream.socketRead0(Native Method) | |
| at java.net.SocketInputStream.read(SocketInputStream.java:152) | |
| at java.net.SocketInputStream.read(SocketInputStream.java:122) | |
| at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:145) | |
| at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:114) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2015-06-22 12:24:48 | |
| Full thread dump Java HotSpot(TM) 64-Bit Server VM (24.72-b04 mixed mode): | |
| "Attach Listener" daemon prio=10 tid=0x00007f90f8001800 nid=0x35ce waiting on condition [0x0000000000000000] | |
| java.lang.Thread.State: RUNNABLE | |
| Locked ownable synchronizers: | |
| - None | |
| "http-bio-9080-exec-1" daemon prio=10 tid=0x00007f9124065800 nid=0x3559 runnable [0x00007f901a611000] |
laszlocsontos
/ take_dumps.sh
Created
November 25, 2014 12:55
Gather JVM CPU usage metrics per thread
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/sh | |
| count=30 | |
| delay=1 | |
| pid=`jps -v | grep liferay | awk '{ print $1 }'` | |
| if [ -n "${1}" ]; then | |
| pid=$1 | |
| fi |