2013-02-01T06:55:53  *** pradi <pradi!~Adium@122.166.93.246> has joined #amclug
2013-02-01T07:24:17  *** arvind_khadri <arvind_khadri!~arvind@unaffiliated/arvind-khadri/x-2237230> has joined #amclug
2013-02-01T08:03:32  *** ecthiender <ecthiender!~ecthiende@122.166.93.246> has joined #amclug
2013-02-01T08:24:15  <arvind_khadri> ecthiender, http://ideditor.com/ check that
2013-02-01T08:24:16  <alipi_not> Title: iD (at ideditor.com)
2013-02-01T08:28:28  <arvind_khadri> ecthiender, by default mysql uses innodb right?
2013-02-01T08:28:48  <ecthiender> arvind_khadri, no. myISAM I think
2013-02-01T08:28:56  <arvind_khadri> ecthiender, oh ok
2013-02-01T08:50:15  <ecthiender> arvind_khadri, actually our mysql is quite slow.
2013-02-01T08:50:31  <arvind_khadri> ecthiender, hmm
2013-02-01T08:50:49  <ecthiender> arvind_khadri, i just ran a query on information schema limit to 1 result, and its still taking ages.
2013-02-01T08:51:39  <ecthiender> arvind_khadri, to run this query select * from TABLES limit 1;
2013-02-01T08:51:49  <ecthiender> it took so long: 1 row in set (1 min 13.38 sec)
2013-02-01T08:52:02  <ecthiender> arvind_khadri, wtf?! thats not normal.
2013-02-01T08:52:10  <arvind_khadri> :O
2013-02-01T08:52:33  <ecthiender> arvind_khadri, do a query on some db. maybe gitorious or something..
2013-02-01T08:52:39  <ecthiender> check how long its taking
2013-02-01T08:53:27  <arvind_khadri> ecthiender, running
2013-02-01T08:54:58  <ecthiender> arvind_khadri, still running?
2013-02-01T08:55:02  <arvind_khadri> ecthiender, ran
2013-02-01T08:55:09  <ecthiender> arvind_khadri, what query and how long?
2013-02-01T08:55:14  <arvind_khadri> select * from users limit 1; took 17 secs
2013-02-01T08:55:30  <arvind_khadri> select * from users; took 0 secs though
2013-02-01T08:55:43  <ecthiender> arvind_khadri, http://pastie.org/private/l3agcld5kxezkbjcweaa3w
2013-02-01T08:55:44  <alipi_not> Title: Private Paste - Pastie (at pastie.org)
2013-02-01T08:56:29  <ecthiender> arvind_khadri, so 260 myisam tables and 177 innodb ones
2013-02-01T08:56:41  <arvind_khadri> ecthiender, nice.
2013-02-01T08:57:26  <ecthiender> arvind_khadri, can we setup monit?
2013-02-01T08:57:42  <ecthiender> arvind_khadri, anyway back to tuning mysql
2013-02-01T08:58:10  <arvind_khadri> ecthiender, ya, I was reading how to configure innodb
2013-02-01T08:58:16  <ecthiender> arvind_khadri, cool
2013-02-01T08:58:35  <arvind_khadri> http://dev.mysql.com/doc/refman/5.5/en/innodb-configuration.html
2013-02-01T08:58:36  <alipi_not> Title: MySQL :: MySQL 5.5 Reference Manual :: 14.3.2 Configuring InnoDB (at dev.mysql.com)
2013-02-01T09:06:06  *** static <static!7d10b405@gateway/web/freenode/ip.125.16.180.5> has joined #amclug
2013-02-01T09:47:40  <ecthiender> arvind_khadri, https://httpd.apache.org/docs/2.2/misc/perf-tuning.html
2013-02-01T09:47:42  <alipi_not> Title: Apache Performance Tuning - Apache HTTP Server (at httpd.apache.org)
2013-02-01T09:47:50  <ecthiender> static, whats up? :)
2013-02-01T10:24:43  *** ecthiender <ecthiender!~ecthiende@122.166.93.246> has quit IRC (Ping timeout: 260 seconds)
2013-02-01T10:34:54  *** static <static!7d10b405@gateway/web/freenode/ip.125.16.180.5> has quit IRC (Quit: Page closed)
2013-02-01T13:49:47  *** ecthiender <ecthiender!~ecthiende@122.166.93.246> has joined #amclug
2013-02-01T14:15:11  *** ecthiender <ecthiender!~ecthiende@122.166.93.246> has quit IRC (Remote host closed the connection)
2013-02-01T14:57:24  *** arvind_khadri <arvind_khadri!~arvind@unaffiliated/arvind-khadri/x-2237230> has quit IRC (Ping timeout: 248 seconds)
2013-02-01T15:49:20  *** pradi <pradi!~Adium@122.166.93.246> has quit IRC (Quit: Leaving.)
2013-02-01T15:50:43  *** pradi <pradi!~Adium@122.166.93.246> has joined #amclug
2013-02-01T16:00:12  *** pradi <pradi!~Adium@122.166.93.246> has quit IRC (Quit: Leaving.)
2013-02-01T19:46:47  *** arvind_khadri <arvind_khadri!~arvind@unaffiliated/arvind-khadri/x-2237230> has joined #amclug
2013-02-01T20:36:05  *** arvind_khadri <arvind_khadri!~arvind@unaffiliated/arvind-khadri/x-2237230> has quit IRC (Ping timeout: 255 seconds)