Ok i was able to test a bit and i don´t think that 5.6.36-82.0 or 2.6.37-82.2 are different, so lets just go with the most recent one.
I built a test-case that can be re-run a couple of times. I´m seeing different behavior over a couple of runs, so be sure to try this at least 10-15 times. Also let the script run till it did the queries at least 15 times.
My observation is that one of two things happen:
- it will show no result on the first query and results for #2 & #3 from the start and stay that way
- it will show NO results on all queries and suddenly at the 10th try it will start showing results on all three queries
Hopefully you can reproduce this and maybe explain.
Test setup:
RHEL6.7.z
Percona-Server-shared-56-5.6.37-rel82.2.el6.x86_64
Percona-Server-shared-51-5.1.73-rel14.12.625.rhel6.x86_64
Percona-Server-client-56-5.6.37-rel82.2.el6.x86_64
Percona-Server-server-56-5.6.37-rel82.2.el6.x86_64
Default install - default my.cnf, no changes, single server only
[<email address hidden> ~]$ cat testscript.sh
service mysql stop
rm -rf /var/lib/mysql/*
mysql_install_db --user=mysql
service mysql start
mysql test < /root/mad_partner-anonymized.sql
COUNT=1
while true; do
echo $COUNT
bash testquery.sh
sleep 1
COUNT=$(($COUNT + 1))
done
[<email address hidden> ~]$ cat testquery.sh
#!/bin/bash
mysql -vvv test -e"SELECT DISTINCT partner0_.organizationOID AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN (
'be067ca5-6cd3-42dc-8a68-a08e9800b195',
'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab',
'8c1fb1ae-25e2-49f8-bb6a-65b5716d0d2b',
'7a090a98-08ec-4924-ac1a-d4b45c749cac',
'83031acb-43cd-4c97-963e-8692a007aba5');"
mysql -vvv test -e"SELECT DISTINCT partner0_.organizationOID AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN (
'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab',
'7a090a98-08ec-4924-ac1a-d4b45c749cac',
'be067ca5-6cd3-42dc-8a68-a08e9800b195');"
mysql -vvv test -e"SELECT DISTINCT partner0_.organizationOID AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN (
'8c1fb1ae-25e2-49f8-bb6a-65b5716d0d2b', '83031acb-43cd-4c97-963e-8692a007aba5');"
[<email address hidden> ~]$ bash testscript.sh
Ok i was able to test a bit and i don´t think that 5.6.36-82.0 or 2.6.37-82.2 are different, so lets just go with the most recent one.
I built a test-case that can be re-run a couple of times. I´m seeing different behavior over a couple of runs, so be sure to try this at least 10-15 times. Also let the script run till it did the queries at least 15 times.
My observation is that one of two things happen:
- it will show no result on the first query and results for #2 & #3 from the start and stay that way
- it will show NO results on all queries and suddenly at the 10th try it will start showing results on all three queries
Hopefully you can reproduce this and maybe explain.
Test setup: Server- shared- 56-5.6. 37-rel82. 2.el6.x86_ 64 Server- shared- 51-5.1. 73-rel14. 12.625. rhel6.x86_ 64 Server- client- 56-5.6. 37-rel82. 2.el6.x86_ 64 Server- server- 56-5.6. 37-rel82. 2.el6.x86_ 64
RHEL6.7.z
Percona-
Percona-
Percona-
Percona-
Default install - default my.cnf, no changes, single server only
[<email address hidden> ~]$ cat testscript.sh partner- anonymized. sql
service mysql stop
rm -rf /var/lib/mysql/*
mysql_install_db --user=mysql
service mysql start
mysql test < /root/mad_
COUNT=1
while true; do
echo $COUNT
bash testquery.sh
sleep 1
COUNT=$(($COUNT + 1))
done
[<email address hidden> ~]$ cat testquery.sh
#!/bin/bash
mysql -vvv test -e"SELECT DISTINCT partner0_ .organizationOI D AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN ( 6cd3-42dc- 8a68-a08e9800b1 95', 58c2-46f3- 9880-9a02e8e9c8 ab', 25e2-49f8- bb6a-65b5716d0d 2b', 08ec-4924- ac1a-d4b45c749c ac', 43cd-4c97- 963e-8692a007ab a5');"
'be067ca5-
'dff1ffa7-
'8c1fb1ae-
'7a090a98-
'83031acb-
mysql -vvv test -e"SELECT DISTINCT partner0_ .organizationOI D AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN ( 58c2-46f3- 9880-9a02e8e9c8 ab', 08ec-4924- ac1a-d4b45c749c ac', 6cd3-42dc- 8a68-a08e9800b1 95');"
'dff1ffa7-
'7a090a98-
'be067ca5-
mysql -vvv test -e"SELECT DISTINCT partner0_ .organizationOI D AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN ( 25e2-49f8- bb6a-65b5716d0d 2b',
'83031acb- 43cd-4c97- 963e-8692a007ab a5');"
'8c1fb1ae-
[<email address hidden> ~]$ bash testscript.sh