Status Report

Buffer Pool Usage and Dirty Pages

Buffer Pool Usage PercentageDirty Pages Percentage
99.72%2.99%

Process List (73)

IdUserInstance NameHostDBCommandTimeStateInfoActions
10544931 admin avaxe-api 172.31.7.89:41782 avaxe_nashville Query 6 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544932 admin avaxe-api 172.31.7.89:41784 avaxe_nashville Query 6 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544933 admin avaxe-api 172.31.7.89:41786 avaxe_nashville Query 6 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544934 admin avaxe-api 172.31.7.89:41788 avaxe_nashville Query 6 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544935 admin avaxe-api 172.31.7.89:41790 avaxe_nashville Query 6 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544936 admin avaxe-api 172.31.7.89:41792 avaxe_nashville Query 6 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544939 admin avaxe-api 172.31.7.89:41814 avaxe_nashville Query 6 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544941 admin avaxe-api 172.31.7.89:41824 avaxe_nashville Query 6 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544943 admin avaxe-api 172.31.7.89:41828 avaxe_nashville Query 6 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544944 admin avaxe-api 172.31.7.89:41830 avaxe_nashville Query 6 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544945 admin avaxe-api 172.31.7.89:41834 avaxe_nashville Query 5 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544946 admin avaxe-api 172.31.7.89:41836 avaxe_nashville Query 5 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544947 admin avaxe-api 172.31.7.89:41838 avaxe_nashville Query 5 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544948 admin avaxe-api 172.31.7.89:41840 avaxe_nashville Query 5 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544949 admin avaxe-api 172.31.7.89:41848 avaxe_nashville Query 5 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544950 admin avaxe-api 172.31.7.89:41850 avaxe_nashville Query 5 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544951 admin avaxe-api 172.31.7.89:41852 avaxe_nashville Query 5 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544952 admin avaxe-api 172.31.7.89:41855 avaxe_nashville Query 5 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544953 admin avaxe-api 172.31.7.89:41854 avaxe_nashville Query 5 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544955 admin avaxe-api 172.31.7.89:41866 avaxe_nashville Query 5 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544965 admin avaxe-api 172.31.7.89:41920 avaxe_nashville Query 5 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544970 admin avaxe-api 172.31.7.89:41944 avaxe_nashville Query 4 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544994 admin avaxe-api 172.31.7.89:42040 avaxe_nashville Query 3 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544995 admin avaxe-api 172.31.7.89:42042 avaxe_nashville Query 3 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10544998 admin avaxe-api 172.31.7.89:42054 avaxe_nashville Query 3 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10545000 admin avaxe-api 172.31.7.89:42062 avaxe_nashville Query 3 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10545006 admin avaxe-api 172.31.7.89:42084 avaxe_nashville Query 3 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10545007 admin avaxe-api 172.31.7.89:42090 avaxe_nashville Query 3 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10545009 admin avaxe-api 172.31.7.89:42098 avaxe_nashville Query 3 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10545010 admin avaxe-api 172.31.7.89:42100 avaxe_nashville Query 3 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10545012 admin avaxe-api 172.31.7.89:42106 avaxe_nashville Query 3 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10545014 admin avaxe-api 172.31.7.89:42112 avaxe_nashville Query 3 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10545019 admin avaxe-api 172.31.7.89:42134 avaxe_nashville Sleep 3
10545020 admin avaxe-api 172.31.7.89:42138 avaxe_nashville Sleep 3
10545021 admin avaxe-api 172.31.7.89:42144 avaxe_nashville Sleep 3
10545022 admin avaxe-api 172.31.7.89:42146 avaxe_nashville Sleep 3
10545023 admin avaxe-api 172.31.7.89:42152 avaxe_nashville Sleep 3
10545024 admin avaxe-api 172.31.7.89:42154 avaxe_nashville Sleep 3
10545025 admin avaxe-api 172.31.7.89:42160 avaxe_nashville Sleep 3
10545026 admin avaxe-api 172.31.7.89:42162 avaxe_nashville Sleep 3
10545027 admin avaxe-api 172.31.7.89:42172 avaxe_nashville Sleep 3
10545028 admin avaxe-api 172.31.7.89:42174 avaxe_nashville Sleep 3
10545029 admin avaxe-api 172.31.7.89:42176 avaxe_nashville Sleep 3
10545030 admin avaxe-api 172.31.7.89:42178 avaxe_nashville Sleep 3
10545031 admin avaxe-api 172.31.7.89:42186 avaxe_nashville Sleep 3
10545032 admin avaxe-api 172.31.7.89:42190 avaxe_nashville Sleep 2
10545033 admin avaxe-api 172.31.7.89:42196 avaxe_nashville Sleep 2
10545034 admin avaxe-api 172.31.7.89:42200 avaxe_nashville Sleep 2
10545035 admin avaxe-api 172.31.7.89:42202 avaxe_nashville Sleep 2
5177479 rdsadmin server localhost Sleep 1
10545013 admin avaxe-api 172.31.7.89:42108 avaxe_nashville Query 1 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10545036 admin avaxe-api 172.31.7.89:42208 avaxe_nashville Sleep 1
10545037 admin avaxe-api 172.31.7.89:42210 avaxe_nashville Sleep 1
10545038 admin avaxe-api 172.31.7.89:42212 avaxe_nashville Sleep 1
10545039 admin avaxe-api 172.31.7.89:42214 avaxe_nashville Sleep 1
10545040 admin avaxe-api 172.31.7.89:42224 avaxe_nashville Sleep 1
5177311 rdsadmin server localhost mysql Sleep 0
10545015 admin avaxe-api 172.31.7.89:42114 avaxe_nashville Query 0 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10545018 admin avaxe-api 172.31.7.89:42124 avaxe_nashville Query 0 Sending data SELECT pi.MlsNumber, pi.PropertyType, pi.PropertyStatus, ListPrice FROM PropertyIndex AS pi LEFT JOIN Duplicates AS d ON pi.MlsNumber = d.MlsNumber...
10545041 admin avaxe-api 172.31.7.89:42228 avaxe_nashville Sleep 0
10545042 admin avaxe-api 172.31.7.89:42232 avaxe_nashville Sleep 0
10545043 admin avaxe-api 172.31.7.89:42236 avaxe_nashville Sleep 0
10545044 admin avaxe-api 172.31.7.89:42238 avaxe_nashville Sleep 0
10545045 admin avaxe-api 172.31.7.89:42240 avaxe_nashville Sleep 0
10545046 admin avaxe-api 172.31.7.89:42242 avaxe_nashville Sleep 0
10545047 admin avaxe-api 172.31.7.89:42244 avaxe_nashville Sleep 0
10545048 admin avaxe-api 172.31.7.89:42245 avaxe_nashville Sleep 0
10545049 admin avaxe-api 172.31.7.89:42248 avaxe_nashville Sleep 0
10545050 admin avaxe-api 172.31.7.89:42252 avaxe_nashville Sleep 0
10545051 admin avaxe-api 172.31.7.89:42268 avaxe_nashville Sleep 0
10545052 admin avaxe-api 172.31.7.89:42272 avaxe_nashville Sleep 0
10545054 admin avaxe-cronjobs 172.31.8.74:35660 avaxe_nashville Query 0 starting SHOW FULL PROCESSLIST
10545055 admin avaxe-cronjobs 172.31.8.74:35662 avaxe_nashville Sleep 0

Process Summary by Instance Name

Instance NameProcess Count
server 2
avaxe-api 69
avaxe-cronjobs 2