Posts

Showing posts from March 8, 2019

MySQL Seems to lose connection when i set variables online

Image
0 I have a Percona Cluster with 5 nodes, and it seems every time i try to change a variable online without starting mysql, i get a message that mysql lost connection even though mysql is still running: SET GLOBAL general_log=1 ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 128237 Current database: *** NONE *** This happens every time i try to change a global variable online. What would be causing this? mysql percona-xtradb-cluster share | improve this question asked Nov 26 '18 at 2:49 The Georgia The Georgia 375 1 13 37

Catafractário

Image
Representação de um cavaleiro catafractário, à maneira da era sassânida. Os catafractários (grego: κατάφρακτος, kataphractos ) eram uma unidade de cavalaria pesada utilizada por povos antigos (sármatas, partos, armênios e, posteriormente, romanos e bizantinos). A armadura utilizada por esta cavalaria se chamava catafracta. [ 1 ] Referências ↑ Bivar, A. D. H. (1972), " Cavalry Equipment and Tactics on the Euphrates Frontier ", Dumbarton Oaks Papers 26: 271–291 Este artigo é um esboço. Você pode ajudar a Wikipédia expandindo-o . Editor: considere marcar com um esboço mais específico . O Commons possui uma categoria contendo imagens e outros ficheiros sobre Catafractário This page is only for reference, If you need detailed information, please check here

Power BI DAX Calculation based on month selected in slicer

Image
0 I need several measures in my report. The measure I want to start with is count of distinct ID four months before the month I selected on (e.g if I select on Aug 2018, the calculation would be all distinct ID before 30/04/2018). The reason I'm doing this is later on I also want to use this same slicer to work on count of ID within the four month period based on the selection. Here is my DAX Calculation with comments: Count four months ago = // Find the end date of the month VAR end_of_last_quarter = FORMAT ( EOMONTH ( MAX ( 'Calendar'[Date] ), -4 ), "dd/mm/yyyy" ) RETURN // Count distinct ID on or before that date CALCULATE ( DISTINCTCOUNT ( 'Report Data'[Id] ), FORMAT ( 'Report Data'[REPORT DATE], "d/mm/yyyy" ) &