Experiencing some slowness after upgrading one of our servers from 0.8 to 0.9. In particular, despite restarting the Drillbit, and even the server, several times, the Drill web UI and sqlline are both so slow as to be unusable.
For example, doing a show databases hangs indefinitely, until I CTRL-C the command (e.g., after a minute). show databases; +-------------+ | SCHEMA_NAME | +-------------+ | INFORMATION_SCHEMA | | cp.default | | dfs.default | | dfs.root | | dfs.tmp | | test.default | | test.schema1 | | sys | +-------------+ 8 rows selected (59.044 seconds) I tried changing schemas, but had to cancel after waiting several minutes. use test.schema1; +------------+------------+ | ok | summary | +------------+------------+ | true | Default schema changed to 'test.schema1' | +------------+------------+ 1 row selected (208.089 seconds) There are no errors or obvious issues in the logs. The server has plenty of disk, CPU, and RAM free. It's running a recent version of MAPR Hadoop on CentOS 6.5 on EC2. It feels like something is hanging Note: This is just after starting sqlline; no actual work, which might have slowed things down, has happened yet. This is what's running from a Drill perspective: ps aux | grep drill ec2-user 24662 0.0 0.0 106100 1328 pts/0 S 12:29 0:00 bash bin/drillbit.sh internal_start drillbit ec2-user 24697 0.3 2.3 6486240 730568 pts/0 Sl 12:29 0:36 /usr/lib/jvm/java-1.7.0-openjdk-1.7.0.79.x86_64/bin/java -Dlog.path=/opt/mapr/drill/drill-0.9.0/logs/drillbit.log -Xms1G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf -Dzookeeper.sasl.client=false -XX:+CMSClassUnloadingEnabled -XX:+UseConcMarkSweepGC -cp /opt/mapr/drill/drill-0.9.0/conf:/opt/mapr/drill/drill-0.9.0/jars/*:/opt/mapr/drill/drill-0.9.0/jars/ext/*:/opt/mapr/drill/drill-0.9.0/jars/3rdparty/*:/opt/mapr/drill/drill-0.9.0/jars/classb/* org.apache.drill.exec.server.Drillbit Drill has been started thusly: bin/sqlline -u jdbc:drill:zk=theServer:5181 Any idea how I could troubleshoot this? Anyone else experiencing slowness after upgrading? Thank you
