/
setup.php
47 lines (36 loc) · 1.27 KB
/
setup.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
<?php
/*
steps
docker-compose build
docker-compose run mysql - in seperate terminal
docker-compose run quexf - in seperate terminal
Drive load via a terminal:
for ((i=1;i<=10;i++)); do sleep 1; curl http://localhost:8080/setup.php ; echo -e ‘\n\n\n\n’$(date);done
*/
$mysqli = mysqli_init();
/* connect to server */
mysqli_real_connect($mysqli, "p:mysql", "root", "password", "mydb");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
/* return name of current default database */
if ($result = $mysqli->query("SELECT DATABASE()")) {
$row = $result->fetch_row();
printf("Default database is %s.\n", $row[0]);
$result->close();
}
$createQuery = "CREATE TABLE IF NOT EXISTS employeestest(id int(11) NOT NULL auto_increment, mscol varchar(250) NOT NULL default '', PRIMARY KEY(id))";
$mysqli->query($createQuery);
for ($i=0; $i < 5000; $i++) {
printf("Default database is {$i}.\n");
$mysqli->query("INSERT INTO employeestest(mscol) values('my')");
}
$mysqli->query("INSERT INTO employeestest(mscol) values('NO')");
for ($i=0; $i < 5000; $i++) {
printf("Default database is {$i}.\n");
$mysqli->query("INSERT INTO employeestest(mscol) values('my')");
}
$mysqli->close();
?>