Documentation
Table of Contents
12 §¡§Ô§â§Ö§Ô§Ú§â§à§Ó§Ñ§ß§ß§í§Ö §á§â§à§Ó§Ö§â§Ü§Ú
12.1 §°§Ò§Ù§à§â
§£ §Ñ§Ô§â§Ö§Ô§Ú§â§à§Ó§Ñ§ß§ß§í§ç §á§â§à§Ó§Ö§â§Ü§Ñ§ç Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â §ã§à§Ò§Ú§â§Ñ§Ö§ä §ã§à§Ó§à§Ü§å§á§ß§å§ð §Ú§ß§æ§à§â§Þ§Ñ§è§Ú§ñ, §Õ§Ö§Ý§Ñ§ñ §á§â§ñ§Þ§í§Ö §Ù§Ñ§á§â§à§ã§í §Ó §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç.
§¡§Ô§â§Ö§Ô§Ú§â§à§Ó§Ñ§ß§ß§í§Ö §á§â§à§Ó§Ö§â§Ü§Ú §ß§Ö §ä§â§Ö§Ò§å§ð§ä §ß§Ñ §ß§Ñ§Ò§Ý§ð§Õ§Ñ§Ö§Þ§à§Þ §å§Ù§Ý§Ö §ã§Ö§ä§Ú §Ü§Ñ§Ü§à§Ô§à-§Ý§Ú§Ò§à §Ñ§Ô§Ö§ß§ä§Ñ.
§³§Ú§ß§ä§Ñ§Ü§ã§Ú§ã §Ü§Ý§ð§é§Ñ §Ñ§Ô§â§Ö§Ô§Ú§â§à§Ó§Ñ§ß§ß§à§Ô§à §ï§Ý§Ö§Þ§Ö§ß§ä§Ñ §Õ§Ñ§ß§ß§í§ç:
§æ§å§ß§Ü§è§Ú§ñ_§Ô§â§å§á§á§Ú§â§à§Ó§Ü§Ú°Ú"§¤§â§å§á§á§Ñ §å§Ù§Ý§à§Ó §ã§Ö§ä§Ú","§¬§Ý§ð§é §ï§Ý§Ö§Þ§Ö§ß§ä§Ñ §Õ§Ñ§ß§ß§í§ç",§æ§å§ß§Ü§è§Ú§ñ³å§ï§Ý§Ö§Þ§Ö§ß§ä§Ñ³å§Õ§Ñ§ß§ß§í§ç,§á§Ö§â§Ú§à§Õ³å§Ó§â§Ö§Þ§Ö§ß§Ú±Õ§¯§Ñ§é§Ú§ß§Ñ§ñ §ã Áú»¢¶Ä²© 1.8.2 §Þ§à§Ø§ß§à §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ä§î §ß§Ö§ã§Ü§à§Ý§î§Ü§à §Ô§â§å§á§á §å§Ù§Ý§à§Ó §ã§Ö§ä§Ú, §á§Ö§â§Ö§é§Ú§ã§Ý§Ú§Ó §Ú§ç §é§Ö§â§Ö§Ù §Ù§Ñ§á§ñ§ä§å§ð.
§±§à§Õ§Õ§Ö§â§Ø§Ú§Ó§Ñ§Ö§Þ§í§Ö §æ§å§ß§Ü§è§Ú§Ú §Ô§â§å§á§á§Ú§â§à§Ó§Ü§Ú (§æ§å§ß§Ü§è§Ú§ñ_§Ô§â§å§á§á§Ú§â§à§Ó§Ü§Ú):
| §¶§µ§¯§¬§¸§ª§Á §¤§²§µ§±§±§ª§²§°§£§¬§ª | §°§±§ª§³§¡§¯§ª§¦ |
|---|---|
| grpavg | §³§â§Ö§Õ§ß§Ö§Ö §Ù§ß§Ñ§é§Ö§ß§Ú§Ö |
| grpmax | §®§Ñ§Ü§ã§Ú§Þ§Ñ§Ý§î§ß§à§Ö §Ù§ß§Ñ§é§Ö§ß§Ú§Ö |
| grpmin | §®§Ú§ß§Ú§Þ§Ñ§Ý§î§ß§à§Ö §Ù§ß§Ñ§é§Ö§ß§Ú§Ö |
| grpsum | §³§å§Þ§Þ§Ñ §Ù§ß§Ñ§é§Ö§ß§Ú§Û |
§±§à§Õ§Õ§Ö§â§Ø§Ú§Ó§Ñ§Ö§Þ§í§Ö §æ§å§ß§Ü§è§Ú§Ú §ï§Ý§Ö§Þ§Ö§ß§ä§à§Ó §Õ§Ñ§ß§ß§í§ç (§æ§å§ß§Ü§è§Ú§ñ_§ï§Ý§Ö§Þ§Ö§ß§ä§Ñ_§Õ§Ñ§ß§ß§í§ç):
| §¶§µ§¯§¬§¸§ª§Á §¿§§¦§®§¦§¯§´§¡ §¥§¡§¯§¯§½§· | §°§±§ª§³§¡§¯§ª§¦ |
|---|---|
| avg | §³§â§Ö§Õ§ß§Ö§Ö §Ù§ß§Ñ§é§Ö§ß§Ú§Ö |
| count | §¬§à§Ý§Ú§é§Ö§ã§ä§Ó§à §Ù§ß§Ñ§é§Ö§ß§Ú§Û |
| last | §±§à§ã§Ý§Ö§Õ§ß§Ö§Ö §Ù§ß§Ñ§é§Ö§ß§Ú§Ö |
| max | §®§Ñ§Ü§ã§Ú§Þ§Ñ§Ý§î§ß§à§Ö §Ù§ß§Ñ§é§Ö§ß§Ú§Ö |
| min | §®§Ú§ß§Ú§Þ§Ñ§Ý§î§ß§à§Ö §Ù§ß§Ñ§é§Ö§ß§Ú§Ö |
| sum | §³§å§Þ§Þ§Ñ §Ù§ß§Ñ§é§Ö§ß§Ú§Û |
§±§à§ã§Ý§Ö§Õ§ß§Ú§Û §á§Ñ§â§Ñ§Þ§Ö§ä§â §á§Ö§â§Ú§à§Õ³å§Ó§â§Ö§Þ§Ö§ß§Ú §Ù§Ñ§Õ§Ñ§Ö§ä §á§Ö§â§Ú§à§Õ §Ó§â§Ö§Þ§Ö§ß§Ú §á§à§ã§Ý§Ö§Õ§ß§Ú§ç §ã§à§Ò§â§Ñ§ß§ß§í§ç §Ù§ß§Ñ§é§Ö§ß§Ú§Û. §¥§Ý§ñ §å§Õ§à§Ò§ã§ä§Ó§Ñ §Ó§í §Þ§à§Ø§Ö§ä§Ö §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ä§î §±§à§Õ§Õ§Ö§â§Ø§Ú§Ó§Ñ§Ö§Þ§í§Ö §ã§Ú§Þ§Ó§à§Ý§í §Ö§Õ§Ú§ß§Ú§è §Ú§Ù§Þ§Ö§â§Ö§ß§Ú§ñ, §ß§Ñ§á§â§Ú§Þ§Ö§â '5m' (§Þ§Ú§ß§å§ä) §Ó§Þ§Ö§ã§ä§à '300' (§ã§Ö§Ü§å§ß§Õ) §Ú§Ý§Ú '1d' (§Õ§Ö§ß§î) §Ó§Þ§Ö§ã§ä§à '86400' (§ã§Ö§Ü§å§ß§Õ).
§±§Ñ§â§Ñ§Þ§Ö§ä§â §á§Ö§â§Ú§à§Õ³å§Ó§â§Ö§Þ§Ö§ß§Ú §Ú§Ô§ß§à§â§Ú§â§å§Ö§ä§ã§ñ §ã§Ö§â§Ó§Ö§â§à§Þ, §Ö§ã§Ý§Ú §ä§â§Ö§ä§Ú§Û §á§Ñ§â§Ñ§Þ§Ö§ä§â §ï§ä§à (§æ§å§ß§Ü§è§Ú§ñ §ï§Ý§Ö§Þ§Ö§ß§ä§Ñ §Õ§Ñ§ß§ß§í§ç) - last.
§¬§à§Ý§Ú§é§Ö§ã§ä§Ó§à §Ù§ß§Ñ§é§Ö§ß§Ú§Û (§ã §á§â§Ö§æ§Ú§Ü§ã§à§Þ #) §ß§Ö §á§à§Õ§Õ§Ö§â§Ø§Ú§Ó§Ñ§Ö§ä§ã§ñ.
§´§à§Ý§î§Ü§à §Ñ§Ü§ä§Ú§Ó§ß§í§Ö §ï§Ý§Ö§Þ§Ö§ß§ä§í §Õ§Ñ§ß§ß§í§ç §å §Ñ§Ü§ä§Ú§Ó§ß§í§ç §å§Ù§Ý§Ñ§ç §ã§Ö§ä§Ú §á§â§Ú§ß§Ú§Þ§Ñ§ð§ä §å§é§Ñ§ã§ä§Ú§Ö §Ó §Ó§í§é§Ú§ã§Ý§Ö§ß§Ú§ñ§ç.
12.2 §±§â§Ú§Þ§Ö§â§í §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ß§Ú§ñ
§±§â§Ú§Þ§Ö§â§í §Ü§Ý§ð§é§Ö§Û §Ñ§Ô§â§Ö§Ô§Ú§â§à§Ó§Ñ§ß§ß§í§ç §á§â§à§Ó§Ö§â§à§Ü:
§±§â§Ú§Þ§Ö§â 1
§³§å§Þ§Þ§Ñ§â§ß§í§Û §â§Ñ§Ù§Þ§Ö§â §Õ§Ú§ã§Ü§Ñ §Ô§â§å§á§á§í §å§Ù§Ý§à§Ó §ã§Ö§ä§Ú 'MySQL Servers'.
§±§â§Ú§Þ§Ö§â 2
§³§â§Ö§Õ§ß§ñ§ñ §Ù§Ñ§Ô§â§å§Ù§Ü§Ñ §á§â§à§è§Ö§ã§ã§à§â§Ñ §Ô§â§å§á§á§í §å§Ù§Ý§à§Ó §ã§Ö§ä§Ú 'MySQL Servers'.
§±§â§Ú§Þ§Ö§â 3
5-§Þ§Ú§ß§å§ä§ß§à§Ö §å§ã§â§Ö§Õ§ß§Ö§ß§Ú§Ö §Ü§à§Ý§Ú§é§Ö§ã§ä§Ó§Ñ §Ù§Ñ§á§â§à§ã§à§Ó §Ó §ã§Ö§Ü§å§ß§Õ§å §Õ§Ý§ñ §Ô§â§å§á§á§í §å§Ù§Ý§à§Ó §ã§Ö§ä§Ú 'MySQL Servers'.
§±§â§Ú§Þ§Ö§â 4
§³§â§Ö§Õ§ß§ñ§ñ §Ù§Ñ§Ô§â§å§Ù§Ü§Ñ §¸§±§µ §ß§Ñ §Ó§ã§Ö§ç §å§Ù§Ý§Ñ§ç §ã§Ö§ä§Ú §Ó §ß§Ö§ã§Ü§à§Ý§î§Ü§Ú§ç §Ô§â§å§á§á §å§Ù§Ý§à§Ó §ã§Ö§ä§Ú.