1. Home
2. Questions
3. Tags
5. Users
6. Jobs
7. Companies
8. Unanswered
Teams

Ask questions, find answers and collaborate at work with Stack Overflow for Teams.
Try Teams for free Explore Teams
Teams
Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams

Return to Question

Tweeted twitter.com/#!/StackDBAs/status/457390761928318976

occurred Apr 19, 2014 at 5:30

edited tags

Link

edited Apr 18, 2014 at 14:31

RolandoMySQLDBA

184.4k
33
323
531

mysql innodb mysql-5.5 buffer-pool

Source Link

asked Apr 18, 2014 at 4:13

751
2
10
18

Will redirecting queries to dev/null warm up indexes?

I'm trying to warm up the buffer pool. Will running a query and re-directing the output to /dev/null suffice?

e.g. mysql -u username -p -e "select id from tbl where 1=1" > /tmp/results.txt

Thanks

mysql mysql-5.5 buffer-pool