public static void InsertGraphicsCardMetric(Objects.GraphicsCardMetrics metric)
{
MySqlConnection m_cn = new MySqlConnection(connectionstring);
MySqlCommand cmd = new MySqlCommand("insertGraphicsCardStat", m_cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("?C_UUID", metric.card.GUID);
cmd.Parameters["?C_UUID"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("?T_RECORDED", metric.TimeRecorded);
cmd.Parameters["?T_RECORDED"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("?GC_TEMP", metric.Temprature);
cmd.Parameters["?GC_TEMP"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("?GC_POWER", metric.Power);
cmd.Parameters["?GC_POWER"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("?GC_USEAGE", metric.Power);
cmd.Parameters["?GC_USEAGE"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("?GC_FANSPEED", metric.FanSpeedPercent);
cmd.Parameters["?GC_FANSPEED"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("?GC_FANRPM", metric.FanSpeedRPM);
cmd.Parameters["?GC_FANRPM"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("?T_ELAPSED", metric.TimeElapsed);
cmd.Parameters["?T_ELAPSED"].Direction = ParameterDirection.Input;
m_cn.Open();
cmd.ExecuteNonQuery();
m_cn.Close();
}
public static void InsertGraphicsCardMetric(Objects.GraphicsCardMetrics metric)
{
string sql = String.Format("insert into CardStats (CardUUID,Time,Temp,GPUUsage,Power,FanSpeedPercent,FanSpeedRPM,TimeRecorded)" +
"values ('{0}',{1},{2},{3},{4},{5},{6},{7})", metric.card.GUID, metric.TimeElapsed, metric.Temprature, metric.GPUUsage, metric.Power, metric.FanSpeedPercent, metric.FanSpeedRPM, metric.TimeRecorded);
ProcessSQLNonQuery(sql);
}
public static void InsertGraphicsCardMetric(Objects.GraphicsCardMetrics metric)
{
switch (DataSaveMethod)
{
case 0:
DataHelper.MySQLHelper.InsertGraphicsCardMetric(metric);
break;
case 1:
DataHelper.sqliteHelper.InsertGraphicsCardMetric(metric);
break;
}
}
public static Objects.GraphicsCardMetrics GetGraphicsCardMetric(Objects.MiningRig rig, Objects.GraphicsCard card, double timeElapsed)
{
dynamic CardInfo = DataHelper.ExcavatorSocket.Client(rig, 0, "device.get", new string[] { card.ID.ToString() });
Objects.GraphicsCardMetrics metric = new Objects.GraphicsCardMetrics();
metric.card = card;
metric.FanSpeedPercent = CardInfo.gpu_fan_speed;
metric.FanSpeedRPM = CardInfo.gpu_fan_speed_rpm;
metric.GPUUsage = CardInfo.gpu_load;
metric.Power = CardInfo.gpu_power_usage;
metric.Temprature = CardInfo.gpu_temp;
metric.TimeElapsed = timeElapsed;
metric.TimeRecorded = rig.LastCheckTime;
card.LastGPUMetric = metric;
return(metric);
}
