1) ... 3
2) ... 4
3) 6
4) ...11
5) ....15
6) ....16
: 3, , , , , . .
:
MYSQL Workbench 5 . .
, ,
apache-jmeter. .
Witcher1, :
1) Ingredients
2) Elixirs
3) Locations
4) Monsters
5) ML
6) IL
.1 Witcher1
Ingridients , Elixirs. , . 1: n ( ), (.1).
Ingridients (Discription) , (WhereFind). idElixirs Ingridients Elixirs.
Elixirs , . .
Locations , .
IL , . Ingridients Locations n: m ( ), , IL.
Monsters
Witcher 3, , .
ML n: m Location Monsters , , , .
|
|
Witcher1 , , , : , , , .. , , .
, .
JOIN, ML Monsters Witcher1.
:
SELECT
monsters.MonstersName, monsters.MonstersDiscription,
ml.DiscriptionHowFind, ml.idLocations
FROM
ml JOIN monsters ON monsters.idMonsters=ml.idMonsters;
, . , . , , , , :
SELECT
monsters.MonstersName, monsters.MonstersDiscription,
ml.DiscriptionHowFind, ml.idLocations
FROM
ml JOIN monsters ON monsters.idMonsters=ml.idMonsters
where monsters.MonstersName=Hym;
ID Monsters ML. :
SELECT SELECT
IdMonsters, MonstersName idMonsters, MonstersName
FROM ml; FROM monsters;
ML Monsters, idMonsters.
SELECT
ml.idMonsters, monsters.MonstersName
FROM
ml JOIN monsters ON
ml.idMonsters=monsters.idMonsters
ORDER BY monsters.idMonsters;
, .
JOIN. Elixirs Monsters , :
SELECT
monsters.MonstersName,elixirs.ElixirName, elixirs.ElixirDiscription
FROM
elixirs JOIN monsters ON
elixirs.idElixirs=monsters.idElixirs;
, .
JOIN. Ingridients Locations , :
SELECT
ingridients.Discription, locations.Discription, ingridients.WhereFind
FROM
ingridients JOIN locations ON
ingridients.idIngridients=locations.idIngridients
ORDER BY ingridients.Discription;
UPDATE
Monsters (Hym). , Him:
UPDATE
monsters
SET MonstersName='Him'
where idMonsters=1;
, Hym :
UPDATE
monsters
SET MonstersName='Hym'
where idMonsters=1;
.2. UPDATE
. COUNT COUNT(DISTINCT)
|
|
COUNT ( NULL) . COUNT , 1 . :
.3. Elixirs, Monsters Monsters JOIN elixirs.
COUNT(DISTINCT) COUNT:
.4. Monsters.
DELETE.
Elixirs , INSERT:
INSERT INTO elixirs VALUES (6,ForDelete,DiscriptionDelete);
.5. Elixirs.
, , :
DELETE FROM elixirs WHERE idElixirs=6;
.6. .
, , :
Response Times Over Time .
Response Times Distribution - , .
Response Time Percentiles . X , Y- .
:
.7.
Number of Threads(users) . 1000, .
Ramp-Up Period , .
JOIN .
.8.
3 , .
Response Times Over Time
.7. Response Times Over Time
, Monsters&Locations . . , Monsters, ML , . - .
Response Times Distribution
.8. Response Times Distribution.
, .
Response Time Percentiles
, -. , 90% 0 340 , 5% 15% , .
10% 340 700 , , .
. , , .
|
|
, , .
, , .
: , , .
1. http://phpclub.ru/mysql/doc/ - MySQL -
2. ., ., . . - MySQL. (2- )
3. ., ., . MySQL
4. ( ), : 571
5. CD PROJECT RED, GOG COM. 3: .