| Id | User | Instance Name | Host | DB | Command | Time | State | Info | Actions |
|---|
| 35935510 |
rdsadmin |
server |
localhost |
mysql |
Sleep |
5 |
|
|
|
| 37543208 |
admin |
avaxe-cronjobs |
172.31.8.74:57010 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543209 |
admin |
avaxe-cronjobs |
172.31.8.74:57012 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543210 |
admin |
avaxe-cronjobs |
172.31.8.74:57014 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543211 |
admin |
avaxe-cronjobs |
172.31.8.74:57016 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543214 |
admin |
avaxe-cronjobs |
172.31.8.74:57024 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543215 |
admin |
avaxe-cronjobs |
172.31.8.74:57026 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543216 |
admin |
avaxe-cronjobs |
172.31.8.74:57030 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543217 |
admin |
avaxe-cronjobs |
172.31.8.74:57032 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543219 |
admin |
avaxe-cronjobs |
172.31.8.74:57034 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543220 |
admin |
avaxe-cronjobs |
172.31.8.74:57036 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543221 |
admin |
avaxe-cronjobs |
172.31.8.74:57038 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543222 |
admin |
avaxe-cronjobs |
172.31.8.74:57044 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543223 |
admin |
avaxe-cronjobs |
172.31.8.74:57042 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543224 |
admin |
avaxe-cronjobs |
172.31.8.74:57046 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543225 |
admin |
avaxe-cronjobs |
172.31.8.74:57048 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543226 |
admin |
avaxe-cronjobs |
172.31.8.74:57052 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543227 |
admin |
avaxe-cronjobs |
172.31.8.74:57050 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543228 |
admin |
avaxe-cronjobs |
172.31.8.74:57054 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543229 |
admin |
avaxe-cronjobs |
172.31.8.74:57056 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37543237 |
admin |
avaxe-cronjobs |
172.31.8.74:57074 |
avaxe_nashville |
Sleep |
2 |
|
|
|
| 37542581 |
admin |
avaxe-cronjobs |
172.31.8.74:36562 |
avaxe_nashville |
Sleep |
1 |
|
|
|
| 37543244 |
admin |
avaxe-api |
172.31.7.89:54704 |
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... |
|
| 37543245 |
admin |
avaxe-cronjobs |
172.31.8.74:57250 |
avaxe_nashville |
Sleep |
1 |
|
|
|
| 37543246 |
admin |
avaxe-cronjobs |
172.31.8.74:57258 |
avaxe_nashville |
Sleep |
1 |
|
|
|
| 35935559 |
rdsadmin |
server |
localhost |
|
Sleep |
0 |
|
|
|
| 37541608 |
admin |
avaxe-cronjobs |
172.31.8.74:46392 |
avaxe_nashville |
Query |
0 |
Commit |
INSERT IGNORE INTO Media ( ClassName, MediaKey, MediaModificationTimestamp,
MediaObjectID, MediaType, MediaURL, Modificatio... |
|
| 37542150 |
admin |
avaxe-cronjobs |
172.31.8.74:56526 |
avaxe_nashville |
Query |
0 |
Writing to binlog |
DELETE FROM Price_History WHERE MlsNumber = '2150876'
AND StreetAddress = '6498 Arno College Grove Rd' AND ZipCode = '37046'
... |
|
| 37542813 |
admin |
avaxe-cronjobs |
172.31.8.74:42050 |
avaxe_nashville |
Query |
0 |
Commit |
INSERT IGNORE INTO Media ( ClassName, MediaKey, MediaModificationTimestamp,
MediaObjectID, MediaType, MediaURL, Modificati... |
|
| 37543197 |
admin |
avaxe-api |
172.31.7.89:54646 |
avaxe_nashville |
Sleep |
0 |
|
|
|
| 37543212 |
admin |
avaxe-cronjobs |
172.31.8.74:57020 |
avaxe_nashville |
Query |
0 |
Sending data |
SELECT m.id,m.MediaURL,m.MediaType, m.MediaKey,
m.ResourceRecordID,m.PreferredPhotoYN,m.MlsNumber,pi.PropertyStatus,pi.ListDate
FROM Media AS m
LEF... |
|
| 37543213 |
admin |
avaxe-cronjobs |
172.31.8.74:57022 |
avaxe_nashville |
Query |
0 |
Sending data |
SELECT m.id,m.MediaURL,m.MediaType, m.MediaKey,
m.ResourceRecordID,m.PreferredPhotoYN,m.MlsNumber,pi.PropertyStatus,pi.ListDate
FROM Media AS m
LEF... |
|
| 37543230 |
admin |
avaxe-cronjobs |
172.31.8.74:57058 |
avaxe_nashville |
Sleep |
0 |
|
|
|
| 37543231 |
admin |
avaxe-cronjobs |
172.31.8.74:57060 |
avaxe_nashville |
Query |
0 |
Sending data |
SELECT m.id,m.MediaURL,m.MediaType, m.MediaKey,
m.ResourceRecordID,m.PreferredPhotoYN,m.MlsNumber,pi.PropertyStatus,pi.ListDate
FROM Media AS m
LEF... |
|
| 37543232 |
admin |
avaxe-cronjobs |
172.31.8.74:57062 |
avaxe_nashville |
Query |
0 |
Sending data |
SELECT m.id,m.MediaURL,m.MediaType, m.MediaKey,
m.ResourceRecordID,m.PreferredPhotoYN,m.MlsNumber,pi.PropertyStatus,pi.ListDate
FROM Media AS m
LEF... |
|
| 37543233 |
admin |
avaxe-cronjobs |
172.31.8.74:57064 |
avaxe_nashville |
Query |
0 |
Sending data |
SELECT m.id,m.MediaURL,m.MediaType, m.MediaKey,
m.ResourceRecordID,m.PreferredPhotoYN,m.MlsNumber,pi.PropertyStatus,pi.ListDate
FROM Media AS m
LEF... |
|
| 37543234 |
admin |
avaxe-cronjobs |
172.31.8.74:57066 |
avaxe_nashville |
Query |
0 |
Sending data |
SELECT m.id,m.MediaURL,m.MediaType, m.MediaKey,
m.ResourceRecordID,m.PreferredPhotoYN,m.MlsNumber,pi.PropertyStatus,pi.ListDate
FROM Media AS m
LEF... |
|
| 37543235 |
admin |
avaxe-cronjobs |
172.31.8.74:57070 |
avaxe_nashville |
Query |
0 |
Sending data |
SELECT m.id,m.MediaURL,m.MediaType, m.MediaKey,
m.ResourceRecordID,m.PreferredPhotoYN,m.MlsNumber,pi.PropertyStatus,pi.ListDate
FROM Media AS m
LEF... |
|
| 37543236 |
admin |
avaxe-cronjobs |
172.31.8.74:57072 |
avaxe_nashville |
Sleep |
0 |
|
|
|
| 37543239 |
admin |
avaxe-cronjobs |
172.31.8.74:57078 |
avaxe_nashville |
Query |
0 |
Sending data |
SELECT m.id,m.MediaURL,m.MediaType, m.MediaKey,
m.ResourceRecordID,m.PreferredPhotoYN,m.MlsNumber,pi.PropertyStatus,pi.ListDate
FROM Media AS m
LEF... |
|
| 37543247 |
admin |
avaxe-cronjobs |
172.31.8.74:57260 |
avaxe_nashville |
Query |
0 |
Creating sort index |
SELECT m.id,m.MediaURL,m.MediaType,m.MediaObjectID,MediaKey,m.ResourceRecordID,m.PreferredPhotoYN,m.MlsNumber
FROM Media AS m
LEFT JOIN PropertyInd... |
|
| 37543248 |
admin |
avaxe-cronjobs |
172.31.8.74:57266 |
avaxe_nashville |
Sleep |
0 |
|
|
|
| 37543249 |
admin |
avaxe-cronjobs |
172.31.8.74:57268 |
avaxe_nashville |
Sleep |
0 |
|
|
|
| 37543250 |
admin |
avaxe-cronjobs |
172.31.8.74:57270 |
avaxe_nashville |
Sleep |
0 |
|
|
|
| 37543251 |
admin |
avaxe-cronjobs |
172.31.8.74:57274 |
avaxe_nashville |
Sleep |
0 |
|
|
|
| 37543252 |
admin |
avaxe-cronjobs |
172.31.8.74:57276 |
avaxe_nashville |
Query |
0 |
Creating sort index |
SELECT m.id,m.MediaURL,m.MediaType,m.MediaObjectID,MediaKey,m.ResourceRecordID,m.PreferredPhotoYN,m.MlsNumber
FROM Media AS m
LEFT JOIN PropertyInd... |
|
| 37543253 |
admin |
avaxe-cronjobs |
172.31.8.74:57280 |
avaxe_nashville |
Query |
0 |
Creating sort index |
SELECT m.id,m.MediaURL,m.MediaType,m.MediaObjectID,MediaKey,m.ResourceRecordID,m.PreferredPhotoYN,m.MlsNumber
FROM Media AS m
LEFT JOIN PropertyInd... |
|
| 37543256 |
admin |
avaxe-cronjobs |
172.31.8.74:57372 |
avaxe_nashville |
Sleep |
0 |
|
|
|
| 37543257 |
admin |
avaxe-cronjobs |
172.31.8.74:57374 |
avaxe_nashville |
Sleep |
0 |
|
|
|
| 37543258 |
admin |
avaxe-cronjobs |
172.31.8.74:57376 |
avaxe_nashville |
Sleep |
0 |
|
|
|
| 37543259 |
admin |
avaxe-cronjobs |
172.31.8.74:57380 |
avaxe_nashville |
Sleep |
0 |
|
|
|
| 37543260 |
admin |
avaxe-cronjobs |
172.31.8.74:57382 |
avaxe_nashville |
Sleep |
0 |
|
|
|
| 37543261 |
admin |
avaxe-cronjobs |
172.31.8.74:57384 |
avaxe_nashville |
Query |
0 |
starting |
SHOW FULL PROCESSLIST |
|
| 37543262 |
admin |
avaxe-cronjobs |
172.31.8.74:57386 |
avaxe_nashville |
Sleep |
0 |
|
|
|
| 37543263 |
unauthenticated user |
avaxe-cronjobs |
172.31.8.74:57390 |
|
Connect |
0 |
Reading from net |
|
|