My SQ L library for MQ L4 with proper memory management
Info
The My SQ L library for MQ L4 with proper memory management is a Library for MetaTrader 4 that the original mql4-mysql. mqh libraryhad a serious problem with memory management.
Usage
This tool is typically used for enhancing chart analysis and decision making.
Platform
This Library works exclusively on MetaTrader 4 (both build 600+ and newer versions).
Setup
Place the downloaded file in MQL4/Libraries folder via File ? Open Data Folder in MetaTrader 4.
How to Install and Use My SQ L library for MQ L4 with proper memory management
1. Storage: Place library files in the MQL/Libraries directory to ensure they are accessible to your projects.
2. Implementation: Include the library in your code using the #import directive, ensuring you match the exact function names and parameters.
3. Compilation: Ensure the library is present in the directory before you compile your main EA or script, as the compiler links them during this phase.
4. Management: Keep libraries organized in sub-folders if you manage many custom functions to maintain a clean project structure.
Frequently Asked Questions
Q: What is a library file used for? A: Libraries store reusable code modules, allowing you to centralize common logic used by multiple EAs or indicators.
Q: Is a library executable? A: No, libraries are non-executable files containing functions; they must be imported into an EA, indicator, or script to function.
Q: Can I update a library while the platform is running? A: You should compile your EA or script after updating a library to ensure the latest code changes are integrated.
What this tool does
The original mql4-mysql.
Typical Use Case
This Library excels in automated trading and technical analysis on MetaTrader 4.
Compatible Platform & Setup
This Library works on MetaTrader 4. Place the file in the MQL4/Libraries folder and restart the terminal.
Description & Settings
Related: ALG L I B - Numerical Analysis Library - another powerful library for MetaTrader 4 traders.
The original
mql4-mysql.mqh
libraryhad a serious problem with memory management. Problems were reported by several users (you can read about it here: ).
Also recommended: Simple Unit Test include library for new MQ L4 - similar library with strong performance on MetaTrader 4.
Since I wanted to use library as part of my projects, I simply couldn't afford memory build up which would result in crash of the system. After examination of the code I managed to trace the problem to the FetchArray function, which allows user to read and save data from database. Memory wasn't properly released or allocated, so I made several changes to the code that should prevent memory leak.Test of the improved library was made and the memory consumption remained stable. Test lasted for several hours and included several thousand connections/read of data with minimal increase of memory usage (less then 10 MB), which is probably the result of MetaTrader 4 itself and indicators running (not a clean install of MetaTrader 4 terminal). From my previous test, the original library couldn't handle more then a few reads from database and only worked for several minutes before collapsing. Test was done with EA, which requested data on every tick.
IMPORTANT: Read original description of library for example!
Should be declared as local variable, not as a global. If you use library with EA or indicator, then local declaration is necessary. This is done so that with every iteration, the variable memory address is different (automatically allocated by MetaTrader 4) and released after the cycle.
You should also open connections for every specific task. Maintaining connection open for several different requests isn't advised. Example: I want to read several rows from database and save it into array, I declare this procedure in a function. When function is called, connection is established and when data is read, connection is closed and after that function returns XX data. Connection is opened for minimum amount of time.
Always remember to close connection with deinit_MySQL, if you don't, connections will build up and with time you will reach MAX number of connections allowed by server running your database. Server will crash.
Also proper transaction management should be implemented, so that two or more connections don't interfere with each other. Can cause read data violation, this will stop your EA from working.
Apache server with MySQL DB for those who needed it (free software):
If you want simple DB, server and DB management tool (it's free and friendly for users):
Read this for how to set protection for DB:
Test it, please give feedback. That's the only way problems can be fixed.
Info:
I could write a forum post with detailed examples on how to use the library and what is needed to use it.
This is quite a substantial subject, so I will only write it if there's need for it. Post a request if you want me to write a user manual.
You may also like: Script Calling Library for MT4 build 600 and later - excellent alternative for library users on MetaTrader 4.
⚠ Limitations & Risk Warning
- This tool is provided for educational and testing purposes only.
- Past performance does not guarantee future results.
- Trading involves substantial risk of loss. Use on a demo account first.
- Results may vary depending on market conditions, broker, and settings.
- We recommend thorough backtesting and forward testing before using with real funds.