Received MQTT messages displayed in HA mqtt integration but not in influxdb/grafana

I have a sensor that is sending 146 mqtt messages within a couple of seconds. Using mqtt explorer I can see each of these messages being received and I can see these mqtt messages in the mqtt integration in HA.

However when I look to see this within HA or within influxdb/grafana I only see one maybe two values.

I thought that as each mqtt message is seperate it would be written to influxdb as a seperate item but this doesnt appear to be the case.

What am I doing wrong?

The format of the data being received by the sensor is:

Message 289 received on Spectrophotometer at 21:28:
{
    "wave": 752.6,
    "abs": 4956.6089
}
QoS: 0 - Retain: false
Message 288 received on Spectrophotometer at 21:28:
{
    "wave": 750.9,
    "abs": 4575.6792
}
QoS: 0 - Retain: false

This is my settings in mqtt.yaml

  - name: "Spectrophotometer Full Spectrum Wavelength"
    state_topic: "Spectrophotometer"
    unit_of_measurement: "λ"
    force_update: true
    value_template: "{{ (value_json.wave) }}"     
    
  - name: "Spectrophotometer Full Spectrum Absorbance"
    state_topic: "Spectrophotometer"
    unit_of_measurement: "au"
    force_update: true
    value_template: "{{ (value_json.abs) }}"  

:astonished:

Flooding the network with messages too quickly for HA to keep up.

thanks Tom, thats what I half expected but I would expect HA to be reporting errors but I didnt see anything.

I have slowed the transmission so that the sensor send a message every 5 seconds but I am still not seeing all the data entering Influxdb. The data seems to only enter Influxdb every 30 seconds so i am loosing 5 out of 6 messages

Is this a restriction on influxdb on HA or is there a config parameter I need to tune?