Skip to content

Instantly share code, notes, and snippets.

@maddinat0r

maddinat0r/mysql-pquery.log

Last active July 19, 2017 15:45
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save maddinat0r/5110302eb350bb3133a5505a4db306c0 to your computer and use it in GitHub Desktop.
Save maddinat0r/5110302eb350bb3133a5505a4db306c0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql-pquery.log
[12:09:30] [INFO] changed log level from 'warning, error' to 'info, warning, error'
[12:09:30] [INFO] Options instance with id '1' successfully created.
[12:09:30] [INFO] Creating new connection handle...
[12:09:30] [INFO] Connection handle with id '1' successfully created.
[12:09:30] [INFO] query "DELETE FROM employees WHERE emp_no >= 500000" successfully executed within 5.134 milliseconds
[12:09:30] [INFO] query "INSERT INTO employees VALUES (500002, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500001, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500000, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.395 milliseconds
[12:09:30] [INFO] query "INSERT INTO employees VALUES (500008, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500007, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500006, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 8.645 milliseconds
[12:09:30] [INFO] query "INSERT INTO employees VALUES (500005, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500004, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500003, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 8.655 milliseconds
[12:09:30] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 124.47 milliseconds
[12:09:31] [INFO] query "INSERT INTO employees VALUES (500017, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500016, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500015, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.294 milliseconds
[12:09:31] [INFO] query "INSERT INTO employees VALUES (500014, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500013, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500012, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.305 milliseconds
[12:09:31] [INFO] query "INSERT INTO employees VALUES (500011, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500010, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500009, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 8.328 milliseconds
[12:09:31] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 111.750 milliseconds
[12:09:32] [INFO] query "INSERT INTO employees VALUES (500020, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500019, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500018, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 6.32 milliseconds
[12:09:32] [INFO] query "INSERT INTO employees VALUES (500026, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500025, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500024, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 9.989 milliseconds
[12:09:32] [INFO] query "INSERT INTO employees VALUES (500023, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500022, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500021, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 10.1 milliseconds
[12:09:32] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 116.187 milliseconds
[12:09:33] [INFO] query "INSERT INTO employees VALUES (500035, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500034, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500033, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.329 milliseconds
[12:09:33] [INFO] query "INSERT INTO employees VALUES (500032, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500031, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500030, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.346 milliseconds
[12:09:33] [INFO] query "INSERT INTO employees VALUES (500029, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500028, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500027, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 8.294 milliseconds
[12:09:33] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 113.566 milliseconds
[12:09:34] [INFO] query "INSERT INTO employees VALUES (500038, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500037, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500036, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.263 milliseconds
[12:09:34] [INFO] query "INSERT INTO employees VALUES (500044, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500043, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500042, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 8.251 milliseconds
[12:09:34] [INFO] query "INSERT INTO employees VALUES (500041, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500040, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500039, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 8.268 milliseconds
[12:09:34] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 116.902 milliseconds
[12:09:35] [INFO] query "INSERT INTO employees VALUES (500047, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500046, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500045, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.547 milliseconds
[12:09:35] [INFO] query "INSERT INTO employees VALUES (500050, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500049, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500048, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.548 milliseconds
[12:09:35] [INFO] query "INSERT INTO employees VALUES (500053, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500052, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500051, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 8.537 milliseconds
[12:09:35] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 119.154 milliseconds
[12:09:36] [INFO] query "INSERT INTO employees VALUES (500062, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500061, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500060, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.97 milliseconds
[12:09:36] [INFO] query "INSERT INTO employees VALUES (500059, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500058, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500057, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.105 milliseconds
[12:09:36] [INFO] query "INSERT INTO employees VALUES (500056, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500055, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500054, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 8.1 milliseconds
[12:09:36] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 111.505 milliseconds
[12:09:37] [INFO] query "INSERT INTO employees VALUES (500071, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500070, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500069, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.586 milliseconds
[12:09:37] [INFO] query "INSERT INTO employees VALUES (500065, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500064, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500063, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 8.568 milliseconds
[12:09:37] [INFO] query "INSERT INTO employees VALUES (500068, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500067, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500066, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 8.565 milliseconds
[12:09:37] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 111.325 milliseconds
[12:09:38] [INFO] query "INSERT INTO employees VALUES (500080, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500079, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500078, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.229 milliseconds
[12:09:38] [INFO] query "INSERT INTO employees VALUES (500077, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500076, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500075, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 8.231 milliseconds
[12:09:38] [INFO] query "INSERT INTO employees VALUES (500074, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500073, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500072, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 8.241 milliseconds
[12:09:38] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 110.666 milliseconds
[12:09:39] [INFO] query "INSERT INTO employees VALUES (500089, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500088, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500087, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.230 milliseconds
[12:09:39] [INFO] query "INSERT INTO employees VALUES (500086, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500085, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500084, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.241 milliseconds
[12:09:39] [INFO] query "INSERT INTO employees VALUES (500083, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500082, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500081, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 8.189 milliseconds
[12:09:39] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 110.331 milliseconds
Raw
mysql-tquery.log
[12:10:59] [INFO] changed log level from 'warning, error' to 'info, warning, error'
[12:10:59] [INFO] Options instance with id '1' successfully created.
[12:10:59] [INFO] Creating new connection handle...
[12:10:59] [INFO] Connection handle with id '1' successfully created.
[12:10:59] [INFO] query "DELETE FROM employees WHERE emp_no >= 500000" successfully executed within 5.141 milliseconds
[12:10:59] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 111.84 milliseconds
[12:10:59] [INFO] query "INSERT INTO employees VALUES (500002, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500001, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500000, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.281 milliseconds
[12:10:59] [INFO] query "INSERT INTO employees VALUES (500005, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500004, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500003, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.255 milliseconds
[12:10:59] [INFO] query "INSERT INTO employees VALUES (500008, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500007, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500006, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.146 milliseconds
[12:11:00] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 113.484 milliseconds
[12:11:00] [INFO] query "INSERT INTO employees VALUES (500011, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500010, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500009, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.458 milliseconds
[12:11:00] [INFO] query "INSERT INTO employees VALUES (500014, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500013, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500012, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.182 milliseconds
[12:11:00] [INFO] query "INSERT INTO employees VALUES (500017, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500016, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500015, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.101 milliseconds
[12:11:01] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 110.58 milliseconds
[12:11:01] [INFO] query "INSERT INTO employees VALUES (500020, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500019, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500018, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.153 milliseconds
[12:11:01] [INFO] query "INSERT INTO employees VALUES (500023, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500022, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500021, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.162 milliseconds
[12:11:01] [INFO] query "INSERT INTO employees VALUES (500026, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500025, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500024, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.212 milliseconds
[12:11:02] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 109.810 milliseconds
[12:11:02] [INFO] query "INSERT INTO employees VALUES (500029, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500028, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500027, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.403 milliseconds
[12:11:02] [INFO] query "INSERT INTO employees VALUES (500032, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500031, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500030, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.211 milliseconds
[12:11:02] [INFO] query "INSERT INTO employees VALUES (500035, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500034, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500033, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.71 milliseconds
[12:11:03] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 110.94 milliseconds
[12:11:03] [INFO] query "INSERT INTO employees VALUES (500038, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500037, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500036, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.205 milliseconds
[12:11:03] [INFO] query "INSERT INTO employees VALUES (500041, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500040, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500039, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.289 milliseconds
[12:11:03] [INFO] query "INSERT INTO employees VALUES (500044, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500043, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500042, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.328 milliseconds
[12:11:04] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 109.801 milliseconds
[12:11:04] [INFO] query "INSERT INTO employees VALUES (500047, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500046, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500045, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.156 milliseconds
[12:11:04] [INFO] query "INSERT INTO employees VALUES (500050, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500049, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500048, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.173 milliseconds
[12:11:04] [INFO] query "INSERT INTO employees VALUES (500053, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500052, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500051, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.227 milliseconds
[12:11:05] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 109.891 milliseconds
[12:11:05] [INFO] query "INSERT INTO employees VALUES (500056, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500055, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500054, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.401 milliseconds
[12:11:05] [INFO] query "INSERT INTO employees VALUES (500059, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500058, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500057, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.177 milliseconds
[12:11:05] [INFO] query "INSERT INTO employees VALUES (500062, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500061, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500060, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.189 milliseconds
[12:11:06] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 109.800 milliseconds
[12:11:06] [INFO] query "INSERT INTO employees VALUES (500065, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500064, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500063, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.224 milliseconds
[12:11:06] [INFO] query "INSERT INTO employees VALUES (500068, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500067, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500066, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.257 milliseconds
[12:11:06] [INFO] query "INSERT INTO employees VALUES (500071, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500070, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500069, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.227 milliseconds
[12:11:07] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 109.915 milliseconds
[12:11:07] [INFO] query "INSERT INTO employees VALUES (500074, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500073, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500072, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.188 milliseconds
[12:11:07] [INFO] query "INSERT INTO employees VALUES (500077, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500076, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500075, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.268 milliseconds
[12:11:07] [INFO] query "INSERT INTO employees VALUES (500080, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500079, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500078, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.286 milliseconds
[12:11:08] [INFO] query "UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0" successfully executed within 110.313 milliseconds
[12:11:08] [INFO] query "INSERT INTO employees VALUES (500083, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500082, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500081, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.461 milliseconds
[12:11:08] [INFO] query "INSERT INTO employees VALUES (500086, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500085, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500084, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.266 milliseconds
[12:11:08] [INFO] query "INSERT INTO employees VALUES (500089, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500088, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), (500087, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) " successfully executed within 4.230 milliseconds
Raw
test.pwn
#include <a_samp>
#include <a_mysql>
main() {}
new MySQL:sql;
FormatQuery(&id, dest[], dest_size = sizeof dest)
{
format(dest, dest_size,
"INSERT INTO employees VALUES \
(%d, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), \
(%d, curdate(), 'asd', 'fgh', 'F', curdate(), NULL), \
(%d, curdate(), 'asd', 'fgh', 'F', curdate(), NULL) \
", id++, id++, id++);
}
public OnGameModeInit()
{
mysql_log(INFO | ERROR | WARNING);
sql = mysql_connect_file();
mysql_query(sql, "DELETE FROM employees WHERE emp_no >= 500000", false);
new query[512];
new id = 500000;
for (new i; i != 10; i++)
{
mysql_tquery(sql,
"UPDATE employees SET data = emp_no WHERE emp_no % (rand()*10) = 0");
FormatQuery(id, query);
mysql_tquery(sql, query);
FormatQuery(id, query);
mysql_tquery(sql, query);
FormatQuery(id, query);
mysql_tquery(sql, query);
// sleep aprox. one second
new tc = tickcount();
while (tickcount() < (tc + 1000))
{
floatsqroot(random(10000) + 1000);
}
}
return 1;
}
public OnGameModeExit()
{
mysql_close(sql);
return 1;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment