I am using a 256MB version of pi, 64MB assigned to GPU, so left over 192MB of system memory.
I have disabled swap file to extend the life of the pi, and to improve performance.
Installed MySQL, it took 20-25% of the left over memory which should be around 36-48MB, while my database shouldnt be more than 1MB of storage.
Attempted to modify the configuration file of MySQL to reduce its memory usage, but failed, its still take almost the same amount of memory.
Need to know are there any other method to reduce MySQL memory usage without disable features of MySQL ? Thanks.