CODEWITHSUNDEEP
mysqlmemory-table
stramin
stramin

Reputation: 2400

How to run a MySQL query on every service start?

I need to run a query to populate a memory table on every MySQL start.

Is there any way to do this?

Upvotes: 4

Views: 1378

Answers (2)

Roger Dueck
Roger Dueck

Reputation: 625

Another option is to have a system script run after mysql starts. With systemd in Linux, the following would work:

cat > /lib/systemd/system/mysql-preload.service << END
[Unit]
Description=Pre-Load MEMORY tables after MySQL starts
PartOf=mysql.service
After=mysql.service

[Service]
Type=oneshot
ExecStart=/home/myuser/script.sh

[Install]
WantedBy=multi-user.target

END
systemctl daemon-reload

The script will be run the next time mysql starts or restarts. Not quite as good as init_file because mysql will be available for queries before the MEMORY tables have been populated, but much more flexible.

Upvotes: 0

Giorgos Myrianthous
Giorgos Myrianthous

Reputation: 39950

MySQL is able to read statements from init_file on startup.

You'd have to place the following in my.ini or my.cnf (depending on the OS) file

[mysqld] 
init-file="/path/to/your/query/populate_memory_table.sql"

Upvotes: 5

Related Questions