| # |
Dec 14th 2017, 09:09 |
 neon1024 |
Morning everyone |
| # |
Dec 14th 2017, 09:09 |
furqan |
any one !!! |
| # |
Dec 14th 2017, 07:47 |
furqan |
if it would log those queries also ,can u tell me how do i configure ,bacause by default it just logs in the queries in the web request -response cycle |
| # |
Dec 14th 2017, 07:46 |
furqan |
because the code is executed by the background jo processing engine resqueue |
| # |
Dec 14th 2017, 07:46 |
furqan |
okay ,so someone from teh portal suggested yestarday to get debugkit and to log queries and see ..So i do have the cakephp debugkit ,but will it also log the queries executed by the background workers as in the resqueue workers |
| # |
Dec 14th 2017, 07:39 |
joopm |
i dont have idea yet |
| # |
Dec 14th 2017, 07:32 |
furqan |
takes 20 seconds ,i am logging the results to a log file that have timestamp ! |
| # |
Dec 14th 2017, 07:31 |
furqan |
$result = $this->Event->save($event); |
| # |
Dec 14th 2017, 07:31 |
furqan |
this 1 takkes < half a sec |
| # |
Dec 14th 2017, 07:31 |
furqan |
$this->Event->query("insert into events (org_id,date,info, user_id ,uuid,published,analysis,attribute_count , orgc_id , timestamp ,distribution , sharing_group_id , proposal_email_lock , locked ,threat_level_id , publish_timestamp , disable_correlation ) values(1 ,'2017-09-18', 'furqan_test_event' , 9 , '42bfaf6e-3347-4c81-bc76-088372452682' ,0, 1, 2 ,1 ,1508771790 ,1 ,0 ,0 ,0 ,1 ,1505829657 ,0 )"); |
| # |
Dec 14th 2017, 07:28 |
furqan |
yes please ,thanks for your time |
| # |
Dec 14th 2017, 07:28 |
furqan |
i have tried out increasing buffer_pool_size ,writing to other tables ,logging and etc..But it just doesnt seem to get to the root cause |
| # |
Dec 14th 2017, 07:28 |
joopm |
oh i have to think about it |
| # |
Dec 14th 2017, 07:27 |
furqan |
in milliseconds |
| # |
Dec 14th 2017, 07:27 |
furqan |
so ,to give little more background ,when i try this query through ORM ,it takes 20 secons / write and the same with raw sql within this mehod on same table and everythin els ebeing same is much much more faster |
| # |
Dec 14th 2017, 07:26 |
furqan |
No its again the same 20 seconds delay ,for the query /queries to get executed via ORM |
| # |
Dec 14th 2017, 07:24 |
joopm |
okey wait for the result |
| # |
Dec 14th 2017, 07:24 |
furqan |
had to restart server and all |
| # |
Dec 14th 2017, 07:24 |
furqan |
just 1 minute |
| # |
Dec 14th 2017, 07:21 |
joopm |
did it help? |
| # |
Dec 14th 2017, 07:21 |
furqan |
Thanks on it |
| # |
Dec 14th 2017, 07:20 |
joopm |
i wait for that for a ahile |
| # |
Dec 14th 2017, 07:19 |
furqan |
wait i willlet me change it to 127.0.0.1 and see if that fixes it |
| # |
Dec 14th 2017, 07:19 |
furqan |
n in my office its just giuving me nightmare |
| # |
Dec 14th 2017, 07:19 |
furqan |
so in my home laptop ,its working just fine with teh exact same configuration and exact same code base |
| # |
Dec 14th 2017, 07:18 |
joopm |
in phpmyadmin? |
| # |
Dec 14th 2017, 07:18 |
joopm |
how do you mean my home box? |
| # |
Dec 14th 2017, 07:18 |
furqan |
okay let me try that out first |
| # |
Dec 14th 2017, 07:18 |
furqan |
so i thing has to do with the envoirnment |
| # |
Dec 14th 2017, 07:17 |
furqan |
but the exact same piece of code is working just fine in my home box ,exact same os -cent os ,and the same code base |
| # |
Dec 14th 2017, 07:17 |
joopm |
for me it was that reason |
| # |
Dec 14th 2017, 07:17 |
joopm |
it will help sure |
| # |
Dec 14th 2017, 07:17 |
joopm |
yes change it |
| # |
Dec 14th 2017, 07:17 |
furqan |
will try that now |
| # |
Dec 14th 2017, 07:17 |
furqan |
its localhost ,and i was asked to change it to 127.0.0.1 |
| # |
Dec 14th 2017, 07:17 |
joopm |
its happened to me when using localhost became extremely slow |
| # |
Dec 14th 2017, 07:17 |
furqan |
i have already set debug kit up ,but the queries are not directly executed in cake context ,there is a woker /background job processing cakeresqueue que that executes the logic/queries |
| # |
Dec 14th 2017, 07:16 |
joopm |
or exact ip address? |
| # |
Dec 14th 2017, 07:16 |
joopm |
localhost? |
| # |
Dec 14th 2017, 07:16 |
joopm |
what do you use in the config? |
| # |
Dec 14th 2017, 07:16 |
furqan |
Hi guys ,i was running into an issue ,wherein a query executed through cakephp ORM takes 20 seconds and the same through raw sql takes < 1 ,i had come to this portal and i was suggested to dump sql queries by debug kit |