To see the current status of mysql log, type the following command in XAMPP
SHOW VARIABLES LIKE 'general_log';
below output will come in the phpmyadmin Variable_nameValuegeneral_logOFF
To enable the log, type SET GLOBAL general_log = 1;
Disabling log SET GLOBAL general_log = 0;
To check where is the log file saved SHOW VARIABLES LIKE 'general_log_file';
Below output will come Variable_name Value general_log_file \xampp\mysql\data\dino-laptop.log
The log files will be saved in the above mentioned path
PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 89 bytes)
In my php script, i was not able to get page view, the page was having lot of variables. and some was taking lot since it was in foreach loop updating a big table output.
debugging foudn that, it was due to memory was not sufficient for the php to allocate.
In the php.ini we cam increase the memory with the memory_limit = 128M configuration. After increasing the size form 128M to 256M, mine was working fine.
But i think i should re design the webpage as php consuming this much memory is not good in long term. There will be better way to reduce it .