تفوته آدك الأيام فتا الشيخ رحمه الله سد معاجل المحظور قبل أنه قد باء بالخصران مع هرمانه معاجل المحظور قبل أنه الشيخ رحمه الله is talking about من استعجالة anybody who hastens بطريق محرمن in a prohibited manner what will happen سيحصل له في الزمان الثاني فإنه يلحق الإثم من جهة الأخام الأخرى ويمنع ويحرمن من استعجالة به في الدنيا he will gain a sin for it the day of judgment when he meets Allah and what will also happen to him is that same thing he will be prohibited from it in this world for example a person kills the person they are going to inherit they kill them so they can hasten their life take their death sorry they can hasten their death so they can take their life because they want to inherit them quickly the prophet the one who killed will not inherit so as your dad you are going to inherit from him you are going to inherit from him you hasten his death what will be said to you is anyone who hastens something before his time he will be punished by him by being prohibited from it and this is a قاعدة which صحاب رضان الله علي مجمعين they unanimously agreed on and they all agreed on that if a man divorces his wife in her deathbed and on his deathbed he's about to die he's about to leave this world he's about to departure and he realized that he's going to die and he doesn't want his wife to inherit him he doesn't want his wife to inherit him so he deliberately divorces her so she can't inherit him on his deathbed the scholars صحاب رضان الله علي مجمعين بالجمع by consensus what did they say he's divorced he will not be looked into بالتريف she's going to inherit him وَلَوْ كَانَةِ الْمَرْعَةُ قَدْطُلِّقَدْ even if he's divorced even if she's been divorced she will inherit him also the same one is the khamar alcohol anybody who drinks alcohol in this world who takes it in this world he won't drink it in the hereafter because what has he done he has hastened it in this دنيا before the hereafter if he doesn't repent from it he will not drink it in the hereafter نعم also the person who wears silk in this دنيا the male who wears silk in this دنيا what has the prophet صلى الله عليه وسلم say that he will not receive it in the hereafter so all of them are صور they are they are sub branches that all fall under this which is the author then said رحم الله after that the author says رحم الله if there comes a prohibition in the particular action that you're doing a prohibition comes regarding it or a prohibition comes in its condition then that thing is facade it is void it is nullified نعم that is what the author رحم الله he's talking about so إذا ورد النصوم من الشارع if there comes a text from the شريعة the legislator الله سبحانه وتعالى and the prophet صلى الله عليه وسلم tells us something that this thing is prohibited this action is prohibited doing it is void or even if there is in the condition there is a prohibition in the condition of that action then it's void as well and the evidence for that is the prophet صلى الله عليه وسلم حديث سبحانه وتعالى رضي الله وتعالى عنها that رمام البخاني المصلي من الشيخان they are narrated that the prophet أن النه that the prophet is sorry من عامل عمل ليس عليه أمرنا فهو ورد anyone who does an action that is not from our affairs is rejected the prophet prohibited anybody to introduce anything to the religion so to do that action is void أنه يقتد الفساد and that hadith is a hadith the scholars used for that قاعدة نعم also the man cannot marry a woman who is in her عدة a woman who is not finished her period of the ثلاثة تقرؤ the three cycles she hasn't finished a man goes and he gets married to her and he is prohibited from marrying her this is نكاح which is فاسد باطل baseless because why لأنه منهي عن نكاحها because he is prohibited from marrying her so وإن أتت تحريمه في نفس العمل in this action of marrying a woman while she is in that period of time is prohibited so if you do marry her and you go against that prohibition then your marriage with that woman is فاسد العتبار it's given no consideration does the word فاسد and باطل both mean the same are they both the same meaning the جمغور they don't differ between it the جمغور of the علمات the majority of the scholars فاسد and باطل both mean the same لكن حنفية and the أحلاف they distinguish between فاسد and they also distinguish فاسد from باطل they say that فاسد is ما نهي عنه لأصفه anything that is prohibited because of its description and they say باطل is what ما نهي عنه لأصفه they say the باطل is something that is prohibited because of its essence the حنابلا they also distinguish between it and they say that the فاسد is ما لم ينفع that the فاسد is that which doesn't benefit sorry sorry they say ما لم يقع اجمع على تحريبي وفاسادي they said the فاسد is something there is no unanimous agreement on it in regards to its being it being prohibited there's no unanimous agreement there's a خلاف some are saying it's permissible some are saying it's not permissible but if there comes اجمع موقع اجمع على تحريبي is facet if there comes باطل if there comes اجمع then this is called باطل so based on that they say for example نكاح المتع نكاح المتع is what is contract marriage they say this is باطل why? because there's اجمع regarding it according to حنابلا but نكاح بلا ولي they marry of the woman without the ولي the guardian they say this is called فاصد it is called فاصد because لعد من اكتفاق علي because there's no unanimous agreement there are some who differ on this issue like in this differing goes against the حديث of the prophet the prophet صلى الله عليه وسلم he say اي يوم امراءة نكاحة any woman who gets married بغير اذن وليها without the permission of her Wali is what فنكاحوها باطل the prophet said باطل عليه الصلاة والسلام and the خلاف in this issue is فاصد الاعتبار the خلاف that has been bought is called فاصد الاعتبار and insha'Allah is one of the things I have in my mind to do this issue of نكاح المرأة بغير اذن وليها marrying a woman without the permission of her Wali it's a محاضرة which I hope to do insha'Allah in the upcoming future the soon the close future وإن اتتحريمه في نصيل عمل أو شرطه فذو فساد وخلال so we understood that if the prohibition it comes what if the prohibition it occurs in the action itself that it's facet it is باطل if it comes in its condition it's also فاصد and it's باطل now I want you all to take this insha'Allah with you that the prohibition occurs in three ways فإن النهاية يقع على ثلاثة انحاء the prohibition happens in three different ways the first one is ما نهي عنه that which has been prohibited من الأفعال actions an action has been prohibited why for that in itself in and within itself it's been prohibited this one فهذا فعل فاسد لا ترتب عليه اثره بالاتفاق this one is void and nothing will be taken out of it by way of consents such as بزينة the prohibition of zina anything that comes after zina the sharia won't take into consideration لا تترتب علي اثر الله الصحيح through zina you can't say I'm married to a woman لا أبدل this is a haram in and within itself so what does that mean nothing comes out of it what do we mean nothing comes out of it we mean the children that you give birth are not yours those children are are not yours if the woman becomes pregnant or say this is prohibited then any nothing is taken into consideration any children that come they can't take your name they take the name of the mother it's not permissible for the man if he has a child through zina to name the child after himself number two the second type of prohibition is اذا نهي عن الفعلي وصف فيه a description lies in this thing the prohibition here is not the action in and within itself but it's a description that's present in the action or a condition that is present in the action فهذا يدول على فسادي أيضا وابطلان وعلا الصحيح this one the sheikh indicated that this one is is prohibited and what comes out of it is not taking into consideration as well and the prohibition is anyone who prays a voluntary prayer at the time when the prayers are prohibited او قاتل نهي the prophet said لا تصلوا بعد العصري don't pray after عصر لا صلاة بعد صلاة العصر there is no prayer after صلاة العصر ولا صلاة بعد الفجري and there is no صلاة after الفجر the prophet said عليه الصلاة والسلام so the person has been prohibited about a particular description so this one the person praying it's not taken into consideration it is not what it is not taken into consideration good the third one is اياتي النهي وعن الواسف بدون ذكر الفعل the third one is what the prohibition occurs in the description without the mentioning of the action the action is not mentioned the action is not mentioned this is the trickest one now the sharia are prohibited a form of description a prohibited this but it didn't mention a action pay attention for example wearing the silk for the men it's prohibited if a person goes and he prays صلاة with a silk is this صلاة correct or not the Jumho of the علماء the majority of scholars they take the view which is what تصحوا صلاة لصلاة is accepted from him so it is taken into consideration وعليه إثم المعصية but the ceiling is on his shoulders the حنابلا they said لا تصحوا صلاة he is not accepted why how can he try to get closer إذ كيف يتقربوا إلى الله how can he even think of wanting to get closer to Allah by a prohibited action how can he بفعل منهي عنه an action in which he is prohibited from how can he try to get closer to Allah through it وكيف يكون فعل الواحد معصية ويكون أيضا ضاع طاع and they said what also can't be accepted is how can one action be a sin and also be an obedience so he is sinning by doing this but he is also what but he is also he is doing also an obedience by praying because Allah has accepted it so he is disobeying الله تبارك وتعالى in what in committing this sin in standing in front of Allah تبارك وتعالى in what in salah with something which he stole or wearing clothes that is made out of silk نعم and but then he is accepted from him and that is an obedience and they stood by the hadith that we mentioned previously من عملا عملا ليس عليه أمرونا فهو رد that's what they said a lot of these picked fools coming to this a person who prays in a he prays a salah in a house that is robbed somebody took a house forcefully and somebody goes and he prays inside it the salah is صحيح according to the جمهور of the علماء but the sin of rubbing and stealing this thing is a sin that's on his shoulder and and the خلاف stands like that so based upon that the scholars they take those different forms and understanding from that line of poetry وإن أتت تحريمه في نفس العمل أو شرطة يفذو فسادن وخلال we elaborate more in this issue إن شاء الله تعالى إن أعوف رائد البهية then the sheikh goes ومتلف ومتلف ومتلف ونموذيه ليس يضمنه بعد دفاعي بالليته أحسنه الشيخ رحمه الله تعالى here he's talking about a qa'id which is very important which is is known as دفع الصائل a person comes to attack you and basically self defense somebody comes and he wants to do something to you it is permissible for you to defend yourself you're allowed to لكن بشرطن the condition is بأقل فالأقل you're allowed to use a minimum that is needed if he comes into the house and he's got a stick he's got a stick and then you go into your room and you bring a what's it called you know launcher and you blow his whole head off that is not correct or he's got nothing with him he came into your house he just wants to rob he came into the house and he's got nothing with him and if you just switch the light on him and you shout he'll jump out of the window and run away you're not allowed to do anything to what you can't, you can't harm him but if he comes into the house and he's got a gun and he's come into the house and he's come into the house to take, to rob, to harm he's come for that reason if he takes his life and he dies وَمُتْلِفٌ مُؤْذِهِ لَيْسَ يَضْمَنُواْ you're not, the matter is not placed on your shoulder he's death, nobody can ask you for it you're not going to pay a deal you're not going to pay anything that is with the condition that you only pushing him to what was needed if you take his life there's no devil why Allah said in the Quran الله تباركه تعالى he said there are a lot I asked that back this issue up but Allah said إِنَّمَا السَّبِيلُ عَلَى الَّذِينَ يَضْلِمُونَ الْنَاسَةَ وَيَبَغُونَ فِي الْأَرْضِ بِغَيْلِ الْحَقْ the path and the issue is on the people who are out the issue is placed on the people who are out there who are oppressing the Muslims or the individual the issue is on them not that the person who defends himself the one who defends himself he's not anything, there's nothing on him the one who's harmed is going to be harmed and the issue is on is the one who killed نعم for example somebody comes to your house and he looks into your door he peeps in he moves the curtain and tries to peep him and you see him and you take a stick and you put it in his eye and his eye goes in the شريعة you don't pay him back anything nothing's on you they're messing with the Salah they're not going to get out of his house anyone who looks into a house قوم in a house of a people غير إذنهم without their permission and what do they do ففقة ففقة أو عينه and they take his eye out فلادية له ولا قصص there's nothing they're going to give him not a penny and you're going to walk around with one eye see your problem you did it so yourself so this evidence قاعدة هي is ومطرف الموديه ليس ياضمانو لكن بعد دفاعي after defending yourself بلديه أحسن يجب أن يكون لديه جيد and a person's camel a person's camel came running at you you took a gun out you shot it or you killed it because it was attacking you there's nothing on you and etc those people who own the animal they will you're not going to have to give them back the camel and it falls under the قاعدة that we previously mentioned لا ضرارا ولا ضرار also falls under that falls under لا ضرارا ولا ضرار very good الشيخنا إن شاء الله رحمه الله he's going to go into what we know دلالات العلفاظ when lettuce show عموم generalization and whatnot he said وَالألْ تُفِيدُ الْكُلْ في العموم the word أل تُفِيدُ الْكُلْ the word أل it shows generalization the al الشيخ رحمه الله these are al-faz they are words that you need to know when you read the Qur'an you will know what is general what is specific and then the meaning becomes different for you the الشيخ يسaid وَالألْ the al which is referring to is الالجنسية الداخلة على الأسماء it is the al which enter the noun or it's also known as what according to some of the grammarians some of the grammarians they discuss each other which is the معرف is it the alif is it the alam is it the alam by itself some grammarians they say the alif is alif alwasl it's not even the alam is what is the alam is what is معرف على كل حال we spoke about the inajrumiya should we call it al or should we call it alif allam نعم so pay attention the al that enters a noun are three times you need to remember this the al that enters a noun are three times the first one is is the one that enters like for example عباس is already معرف he's already known who he is when you've put the alif allam in it you haven't made him even more known so they call this why do they call it pay attention this one you have to know is that it means it's just an additional with it or without it the meaning doesn't change that's what is that it means what is why when you're doing تفسير of the Quran and you come to words and letters you should never use the word زائدة it's سؤل أدب بعى القرآن when you say this is a زائدة so many grammarians use that it means that if you take this from the Quran the ayahs the siyaka everything won't change and that is the case every letter every word every word in the Quran you can't take it out it's متعبد بتلاوتي you worship Allah by every letter every letter has a purpose why it's there it has a what it has a purpose why it's there so we don't believe the Quran هزائدة also some people say when they come to you know ضوريبا يا يليني لأاملوا ضوريبا مثلوا فاستمعوا له ضوريبا ضوريبا in grammar what would we say مبنيو للمشول or we call it المفعول الذي لم يسمى فاعله ضم أوله وكسر مقبل أخري that's if it's too late if it's too late how can you say مبنيو للمشول use words like that وخولق الإنسان وبعيفة مبنيو للمشول the person who created it that we don't know can you say that لا so you say المفعول الذي لم يسمى فاعله that's the usage you say so it's important there you the next type of elif ألاام is the first one is ذائدة the second type of elif is known as what the second type of elif is called العهدية العهدية العهدية is if you and I were both talking about something and then I say to أخي البيت this bait is known to you and me because we were talking about it all the time so I say to you the house it's called عهدية because it is something I'm bringing you back to it's the one we were talking about the house it's called عهدية the elif it's called عهدية it is the one Allah used in صورة المزمن إنه أرسلنا إليكم رسولا شاهدا عليكم كما أرسلنا إلى فرعون رسولا فهذا فاث رسولا فاث رسولا وزوات يوز المعرف يوز نكرة it's indefinite 2 things shows it's indefinite فهذا هو there's no elif and there's a تنوين تنكير إنه there's a تنوين of indefinite إنه because Allah said إنه أرسلنا إليكم رسولا شاهدا عليكم كما أرسلنا إلى فرعون رسولا لن أرسل الله فعصا فرعون أرسولا the second أرسولا it's عهدية وهذا عهدية it is the one that was just been spoken about we should know it by now so it's عهدية it's in our minds it is what in our minds أصول الله تباركو إتعالى he used it in many مواطع of the Quran for example Allah says الله نور السماوات والأرض مثل نوره كمشكات فيها مصماح المصماح في مصماح الله فيها مصماح فيها مصماح المصماح this is عهدية why? because the مصماح that was being spoken about that one it's كود عهدية عهدية the condition for it is that same word has been previously spoken about in order to كود عهدية does it make sense كود عهدية نعم أزوجاجتك أنها كوكا من دوريون for example الله تباركو when He says in the Quran اليوم أكملت لكم دينكم today I have finished a religion for you this اليوم is عهدية we know it it's well known to us it's the day of عرفة it's the day of عرفة day of عرفة the prophet صلى الله عليه وسلم stood up and when did he say a day before Friday on a Friday sorry it was on a Friday it was on a Friday we know it اليوم the day يوم عرفة the prophet was standing حجة الوداع we know it العهدية is in our minds because the hadith tells us about it are you with me so عهدية means what عهدية means يراد به ارجعوا الكلام إلى معهود المصاحب سابق that's what it means the third is الجنسية الجنسية الجنسية it is the one that is intended for it a jins a you want that thing to encompass it the meaning to come into it that particular thing and the jinsia is of three types the jinsia is how many types three types the first one is اداخلة على الجمع that which enters plural for example you say المؤمنون المسلمون الرجال the third second type of the jinsia is those who enter particular agnes particular things and they are like الماء the water البيع the transaction when I say to البيع you know that it's all form of bear the third one is from the jinsia is اداخلة على الاسماء المفردة pay attention the reason why I'm telling you this because we're going to learn which one comes as a عموم the third one is from the jinsia that which enters singular words it enters a singular noun such as الانسان انسان is what انسان is what انسان is what اداخلة على الاسماء المفردة مثل مثل الانسان والسارق sorry like the word it enters humans مفرد like السارق the one who stole one والسارقة the female who stole one female فقطعوا the one that enters ازانية والزاني فجلدو ويبهم ويبهم this one it entered what it entered an اسم which is مفرد which is what which is جنسية so it's مفرد and it's in the jins right نعم this one فتفيد العموم على الصحيح it shows generalization according to strongest view where's the evidence that shows عموم the evidence is والعصر والعصر إنه الإنسان إنسان is it one or is it plural yeah it's more friend what's the جماعة and نس نس is plural are you with me إنسان is one person إنه الإنسان very Lee the people are upon what why do we say people it's just one why إنه الإنسان لفي خصر إنه الذين عموم to show you that إنسان is plural is جماعة and it shows generalization is why did Allah bring استثناء exception after it the exception only occurs to bring some out of it so they don't fall under that generalization exception don't add this to the list that's what Allah said إنه الذين عموم وعموم صالحة so then the L here right now is what إنسان is عموم it's a مفرد it's a معرف and it's الالجنسية very good this all show what that shows generalization also what shows its generalization is what Allah says I will طفل الذين لم يظهر وعلى عورات النساء طفل طفل is مفرد it's a gins it's an ismun it's an ism it's a lathzary مفرد معرف بأل الجنسية so you feed them that so you feed the عموم it shows generalization every child any child who doesn't know the women's عورات he can come in not a problem women don't have to be a hijami in front of children little kids where's the evidence somebody can say now it's not all children there's an exception the usage of the word اللذينة shows it because اللذينة is مصولة and it shows generalization and it's agreed upon there's no على كل حال also another example on it buying and selling you guys have to learn these words because it benefits you a lot الله says in the Quran what buying and selling is what الله سبحانه وتعالى he says الله has made bay'a permissible and he prohibited what الربع الربع الله prohibited it pay attention to this and then bay'a the transaction the asset for it is what الحلو how because البيع brother is a again لفظن مفردن مفان معرفن بالأل الجسمية يدلو على العموب it changes generalization where is that exception that you say this type of transaction is not allowed you see it allows you to be able to so the sheikh he mentions that first time والألتفيد كل في العموبي في الجمعي I brought it for you guys والإفراد and when it's singular كالعليم like like علم as an example very good والنكرات في سياق النهي تعطي تعطى العموبة أو السياق النهي the sheikh is talking about what the indefinite the if you have pay attention again he's still talking about what الفاد العموم the letter of the letter very important the letter of the letter are very very important for the طالب العلم to learn them very well أخي this is عام أخي this is خاص أخي this is مطلق أخي this is مقيد then you know where to stand your issue you got exception bring this text out of here but you're not going to take a general text when they are there's a عام you're holding onto and there's صور which مخصص that the sheikh has taken out of it I mean there's إستثناءات and you're still sticking to the generalization how does that work so you have to learn this وَنَّكِرَاتُ with the indefinite في سياق النهي in the context of negation write this down important negation there's an indefinite an indefinite and it's in what context the indefinite it's in the context of a negation examples will be given إن شاء الله تعالى what does it show shows generalization for example الله تعالى تعالى يسأل القرآن this is an indefinite it's an indefinite and it's in a context of negation for example الله تعالى he said وَمَا قَدَّرُوا اللَّهِ where's the indefinite وَمَا that's نفي straight away look at this this is the context now the context started straight away with what a negation straight away the minute you find an indefinite in that context what are you going to call it generalization generalization so Allah says وَمَا اللَّهِ did not قَدَّرُوا اللَّهِ حق قدره they did not so Allah is negating it from the disbelievers that they have not honored Allah the way he deserves to be honored إذ قالوا when they said ما أنزل الله Allah did not send down على بشري من شيء in anything this anything is it something they're referring to or are they referring to anything whatsoever it's is شيء إن اي نكرة how do you know it's a نكرة look at that تنوين that's there the تنوين there's no and that تنوين we took it when we studied تنوين العوض تنوين المقابلة تنوين تنكير تنوين تمكين we took those four there are ten we said but these four are the most common ones this is that's what you see means شيء إن ما أنزل الله Allah has not sent down من شيء إن نكرة في سياق إن في فتفيد العموم you say see how you learnt it there these are Allah it's an instrument that a person really needs to study and learn نعم so Allah refuted them سبحانه وتعالى by that statement of theirs what did he say قل ما أنزل الكتاب الذي جاء به موسى who is the one who is sent down this genuine this sweeping argument that they gave that they generalised it what did Allah reply to them by saying Allah said to them who is the one who sent down موسى with the book he brought who الله أتبارك وتعالى


The road Arms and an explosion possibly an ID Blast injury Get on him Grab you need another hand or you guess And there's three I'll copy our last transmission LZ marking IR bud elevation Sea level Oh yeah that's cool Further You said you think a little Over here Thought so Hey Oh no no no No, no Fall back See him at your line and let's get all There he comes Maryman grab that calm On his front On his back I'm done man So we're trying to help you all right Who has the zip tie Well this looks stupid COC COC this is second squad it buys One ready for LZ brief over The rest of the LZ is flat No wind speed at this time COC this is second squad ready to check over Move you can come closer you can look at it But I'm gonna be holding it in front of me Any other questions They may have supporting assets that you don't have Right you got to catch it off the X which is good You took a You got shot in the shoulder Bubble all right You guys got anything for me This guy gets it This guy gets it Yeah man I'll start doing it now One out of two No no you'll be like number one two three four five six seven eight Good good You get over there Dude Alright who's feeling lucky Punishment for incorrect answers One click for every wrong one Hey you right there Why would you jump there Oh sorry Run Move it If you have it right here Run Run Rodriguez Rousseau Hone Let's go pick up and move I'm moving Twenty You can shoot Call an ad rack at the same time Seventeen Eighteen You got range sixty meters Sick Five Six Seven We're starting to get to move We're going to go move Talk it down talk it down Talk it down


And now, it's a one-touch game for everybody. Funny how it gets evened up like that. Wow, the beam assist crossed me up. Let's go. Let's go! Punch him in the face, Vegeta! How's it going, everybody? Dato Doi here, back with another round of Dragon Ball Fighter's Rank Matches. This time, playing a suggested team of Goku, GT, Vegeta, Blue, and Bardock. It also looks like we'll be running another rematch back with this guy. Very, very bad. I always worry that when I rematch people I just played with a new team, and they're like, hey, wait a minute. Is this his main? Ha, ha, ha. Which, you know what? It might as well be, let's go, Goku. Let's get this top tier energy, dude. All right, well, this is going very well so far. Ha, ha, ha. See, Bardock assist wasn't up, and that was very bad, because I don't think you can do the GT Goku stuff with Vegeta. I may be wrong. I don't play a lot of the two characters, especially together, but now we're getting through the damage. Will he level three though? We out. We are out. Oh, that should be knockout too. I wonder if I'll have to spend any more damage. All right, I'm doing it. Oh, I didn't have to. Let's go. Let's go. I definitely was about to give up. Ha, ha, ha. I was definitely about to give up. Emusist knocked me right back into him. That kind of sucked. Emusist just was like, yeah, take him 16. He went in that, ah! You're gonna dunk me? Like this, dude? And I up teched into the dragon rush. This is why I don't up tech as much as I used to because I'm just not responsible. I will just up tech and not look at the screen anymore. I don't know why I do it, but. Oh! All right, get back in the corner. Oh, forgot. Okay, darn, could have done so much more damage with that. I gotta start faking that more. He reflects it every time. So if I just fake it, that's a big punish. Did not do that last match. Finish, finish, finish, finish, finish. Okay, good. Ha, that's fine. At least we've managed out of the level three. That would have been detrimental. All right, hold on. Knock me down. Do I down tech? I think I do. I'm not guard canceling. You gotta open me up. So good job. Great job. Ha, ha, ha. You gotta open me up. So excellent work there on opening me up. This will probably kill. There goes Vigito. All right, I'm fine. I don't need Vigito. I got Bardock right here, dude. Oh, what was I just saying? I got Bardock right here. Okay, I should have just used back L. All right, we got a spark here. Probably should have sparked early in the game. I don't think, I don't think I would disagree with that. The Super Dash is a flying. Bounce it up. I really wish that hit. Really wish that hit. I'm gonna just do it. Ah, too obvious. I knew just doing it was a risk. Ah, I was snapping me. That looked hella sus. I thought that was the fight. Maybe that was the wind down part of the animation, but wow, we lived that. We lived a pretty sizable beating there, but come on, dude. I thought that two-H hit. I was about to get hyped. I was like, yeah, oh, oh, I'm getting, I'm getting comboed as we speak. All right, bad first game, but we had one of those last set as well. So we gotta just hope my go-through GT lives a little longer. Again, I will take this every day of the week. Here we go, get back. I probably should have faked that. I didn't think you'd reflect there though. I thought he'd block. That was a bad read on my part. Okay, I'm cool with this. Our kids, it was an awful idea. I don't know why I did it. I don't know why I committed to it so early. Here we go. Got caught by that, but that's cool. What? Oh my God, I don't even know where I am. I, get this man out of here. I'm going out and go-through GT. Not the smartest decision right now, but. Ah, the switch was nice. The switch was nice and we're bleeding health now. There we go, there we go. Sliding, good stuff. And then bait it, it didn't fall for it. It didn't fall for it at all. I should have kept the blocks up. Didn't even try a gimmick mix up or anything like that. So it might be time to spark. He's got three bars. It's definitely time to spark. Two and then three. No, he didn't want to use the three. It'd be fair, it wouldn't have killed. Oh no, how to waste the sparking. And that's just another, that's just another part of the game. We don't have any more. All right, Bardock's gone, sparking's gone. I don't know why, I don't know if, I don't know why. Super Dash felt that was not, that was too much. No more chasing Super Dash said. Damn, this is, this turned into a really bad game after that spark. This turned into a really bad game. All right, Dragon Rush, that's enough to kill and like two hits, two supers, I mean. Cooler's back out again. Cooler's back out again. Damn, I don't know if my Vegeta was up to this task. We might have to get the reverse 3-0, but I'd be down, I'd be down to make it. On the back, I like that. Oh, not sure how that didn't, hey good. Okay, it should kill. Good, final comment, we gotta play very safe fighters now. One bar, we gotta keep building up the three and getting those hard knockdowns. And we only got like what? Two hits left until we're dead, so. This is going to be very challenging. See what I did there is I knew he was gonna try to do something like a, I don't know, either a command grab in the air or some form of anti air. So I wanted to approach on the ground where he wouldn't be expecting it. You might have to reflect here. Very unfortunate that happened, but oh, and I'm letting him get too much damage. I shouldn't have reflected. I should, I have to play safer than that. Reflex are, even though the reflex are pretty good, it's still too risky in this area. No techs and I'm out. I'm out of the game, I couldn't take. All right, so don't reflect like that in the clip. Oh, he dropped it, let's go. See, here's what I wanted to do. I wanted to do forward S, but I couldn't get it out. That's why I jumped and did. I tried to do forward S, but my thumb hit up instead of forward, leading to what the train wreck you saw there.  All right, that was good though. I wanna play safer now. I don't know why I reacted to that with a Super Dash on my own. That was not a great choice. Cooler than damage, I like it. Safe jump, so I'm just gonna stay on the ground. Back dash heavy there would have been nice. Didn't block the last 6M. No, that was like the last thing we needed and then I was out. Wow, he got hit. Ah, I didn't think it. I didn't look at my bar. I had no vanish. Okay, good. That's a snap. That's a snap, that's good. And here he was ready for that, the reaction. Oh my goodness. Try to get a little cheesy. And it looks like it might be time for a spark. I wasted the vanish because I knew I wasn't gonna get that. Oh, these switches. They're getting me good. The tag after tag, bounce over his head. No, we're back in it. I'm glad we didn't get caught by that. That would have been bad. Okay, good. Oh, again, I forwarded that. I have to play slower. The tags here are too risky for me to be clicking buttons like this. Uh-oh. He didn't do anything appropriate for that, which is good. Beam assist. I'm really lacking a beam assist right here. My neutral's trash. All right, that's a snap, but who, the beam assist? Yeah, let's get rid of that. I didn't mean to do that variation, in case you're wondering. Really, that beat me out? The mash. Okay, we're still good, we're still good. We have a health lead. We also have sparking. I won't use sparking early, especially because Bardock's dead. I may even try to save up for level three sparking, but if Vigito starts getting hit, that's where I got to draw the line. All right, well, we're down a character now. Yeah, this is what I'm afraid of. This is where sparking might have to go. I don't want Vigito to lose too much out. That's the main thing. He is the comeback machine. He's what's going to get us out of here. Beam assist are doing it up. We haven't gotten a hit in so long. Sparking is going to waste. Level one, that's fine. We can pop up and vanish off of that. We didn't get the chance to vanish. Down tech saved me. He didn't build another bar, thank you. No, he blocked it as well. It's going awful. Okay, if you're going to do that, then I have faith. Let's go. Let's go, we can still do it. It looks awful and that's because quite frankly, it is. I said, oh, let's go. Let's go, I'm still risking it, dude. I'm going risky options all the time. Come on, it's still doable, baby. It's still doable. In it. No, we can't do that again. Good, get him down. No, we're doing good work here. Let's go. I don't think two bars would have killed there. No, the down heavy, I should have seen it coming. We approached too much in the air and now it's a one-touch game for everybody. Funny how it gets evened up like that. Wow, the beam assist crossed me up. Let's go. Let's go. Punch him in the face, Vegito. Oh my goodness. I thought that level one kill, that's the only reason I went for it. You're finished. You can't keep up, let's go. You're finished. Oh my goodness, is this why people play Vegito? Am I finally feeling it, dude? Come on, get it. You can't do that, that's illegal. I'm sorry, but that's illegal to do. It technically isn't wrong, but it is illegal. That's illegal, is nobody gonna, somebody has to vouch for me here. You can't leave somebody on. What am I gonna do with all this hype? Where am I, am I gonna put it into arts and crafts? Yeah, yeah, no, I'm definitely not gonna put it into arts and crafts. Thank you guys so much for watching. They'll hopefully you enjoyed it. If you did, make sure to let me know down below in the comment section. While you're down there, if you like the channel and the videos, you wanna stay up to date with everything new coming to Dragon Ball Fighters and other fighting games, including Dragon Ball Super Broly and a whole bunch of content form, make sure to hit the like button and subscribe. Other than that, if you want more videos right away, there should be some up on your screen, so feel free to check those out if they interest you. Other than that, I am Dr. Joya and I will see you in the next one.


Folks, I know that it's a Monday in 2020, but regardless, I still have some surprisingly good news. The coup in Bolivia, the coup attempt in Bolivia by the United States government, has officially failed. Because they held an election, and the socialists didn't just win. They won big. They won in a landslide, according to exit polls, capturing 52.4% of the vote. The Socialist Party, MAS, formally run by Ivo Morales, has won big. So much so that there will be no need for a runoff election in November.  And this led to people dancing in the streets in the middle of the night celebrating this victory. And fascists such as Fernando Camacho, crying as the results came in. And after the news broke, former president of Bolivia, Ivo Morales, stated that he will be returning to his country because he was exiled once the fascists came to power. And he was in Argentina, but he's coming back. So this is just phenomenal news. And before we get into the specifics here about this, I just want to explain to you why this is so important. This situation could have been absolutely deadly if the fascists hung on to power. Because back when the United States government overthrew the socialist government in Chile, Salvador Allende, guess what happened? Pinochet came to power. And he was one of the most brutal dictators the world has ever seen. So we were looking at a situation where Janine Agnes could have been as brutal as Pinochet. And there were already signs that this was a very violent and repressive regime that we were seeing starting to emerge. So that's one of the reasons why this is important, because lives are probably going to be saved, countless lives, because this election went this way. And second of all, it also signals that the United States government is losing its influence in Latin America. Because what did we just try to do a year ago, a little over a year ago? We just tried to overthrow Maduro in Venezuela and install Juan Guaido, our puppet. That failed, and now our coup attempt here in Bolivia also failed. And yes, you should question our motives, because I don't think it's a coincidence that the countries that we always target and want regime change in happen to have a lot of resources. In Venezuela, they have the number one oil reserves in the world. In Bolivia, lots and lots of lithium, which private corporations in America want. So this is a victory for the people and for the world, quite frankly, for the international socialist movement. So for more details on this, we go to Jake Johnson of Common Dreams, who explains a year after former Bolivian president, Evo Morales, was ousted in a military coup that installed a brutal fall rate regime. Morales ally, Luis Arque, declared victory in the South American nation's high stakes presidential election early Monday after exit polls showed the socialist candidate with a large advantage over his two main competitors. Quote, democracy has won Arque, who served as Morales finance minister, said in an address to the nation after one exit poll showed him leading the race with 52.4% of the vote and former president Carlos Mesa in a distant second with 31.5%. Right-wing candidate Luis Camacho, an ally of unelected interim president, Jeanine Agnes, won just 14.1% of the vote. That's astonishing, according to the survey. The Washington Post reported that if the exit poll numbers are confirmed by the official count, which was being tabulated slowly late Sunday, it would be more than enough to avoid a November runoff and claim outright victory. Arque characterized his apparently decisive victory, which Agnes was forced to acknowledge as a mandate to continue the policies of the Morales government, which lifted millions of Bolivians out of poverty and expanded the nation's economy. I think the Bolivian people want to retake the path we were on, Arque said Monday. Twice postponed due to the coronavirus pandemic, Sunday's election was a do-over of last year's presidential contest, which was thrown into chaos after the U.S. dominated organization of American states, OAS, leveled baseless allegations of fraud by Morales who was eventually forced to resign and flee the country under threat by Bolivia's military. The coup against Morales sparked a wave of indigenous-led protests that were violently repressed by the Bolivian military and police forces, which were granted sweeping immunity from prosecution by the anti-Indigenous Agnes government. The OAS allegations were indeed the main political foundation of the coup that followed the October 20th election three weeks later. Mark Weisbrot, co-director of the Center for Economic and Policy Research, wrote last month. But they provided no evidence to support these allegations because there wasn't any. This has since been established repeatedly by a slew of expert statistical studies. So this really is just excellent news. However, the question is, why did this happen in the first place? Why was there a coup attempt? Why did the OAS declare their electoral victory fraudulent? Well, this is about lithium. This is what Evo Morales said. But I want you to hear it from Evo Morales himself because he explained in an interview with Glenn Greenwald of The Intercept that this really was a lithium coup, as he called it. Because what they were doing was they were taking the money that they were making from lithium in this country and they were helping to lift people out of poverty using their country's resources to benefit their own people. And the United States government, mostly large multinational corporations, private companies, they didn't like that they weren't getting a piece of the pie. So this ended up leading to a coup. And Evo Morales puts it concisely and explains quite simply, this is about lithium and that's it. Not a North American company is judged. Of course, they are always with the mentality of competitiveness and in addition to that, they are with a mentality of privatisation. And in our policies, no, the state is going to industrialise it. There may be partners, but fundamentally, they have to pay for services. In terms of lithium, we had a proposal of 41 plants. The majority of the industrialists of lithium, for example, hydroxyl of lithium, carbonate of lithium, crude of potassium, there was the plant of battery, the others for insumers and the others for their products. Their products for medicine and food. And I'm not an expert, but I had to understand, debating with the technicians, as ministers, vice ministers, managers of the lithium issue. And last year we came in and we inaugurated a plant, as I mentioned earlier, of crude of potassium, we are exporting. And we are exporting lithium, but from the pilot plant, next year we are going to inaugurate the plant of the carbonate of lithium industry. So if I feel that that energy sector is so important, that from Bolivia, I even had the opportunity to put the price of lithium for the whole world, but with participation from Europe, China, Asia, and from outside the United States, that doesn't support it. That an Indian handles that, and as a state in addition to that. So if I am convinced, this is a coup of state of lithium. This was a lithium coup d'etat, that's what he called it. Now with Venezuela, John Bolton admitted, the quiet part out loud, remember in an interview with Fox News where he said, you know what, really would be nice if American companies and Venezuelan companies, of course, got access to Venezuela's oil. So this is always about natural resources, always about natural resources. And they didn't work this time. And it's funny because these private companies who wanted access to Bolivia's lithium, they were so confident that they could actually carry out this coup successfully, that they were literally bragging about it because Tesla CEO, Elon Musk, when confronted about his company, monetarily benefiting from Bolivia's lithium, said, we will coup whoever we want, deal with it. Yeah, seems like not so much anymore, right Elon? So I know that you're gonna say, Mike, you're oversimplifying the situation. No, it really is that simple. It really is that simple. You just have to connect the dots. And I wanna go to a tweet from Artie Hale, who has the most concise summary that we need. If someone is confused about this situation, show them this tweet because it explains perfectly what happened. So for those unclear about Bolivia's situation, one, Bolivia democratically elected socialists. Two, US wanted Bolivia's lithium. Three, socialists said no. Four, US claimed fraudulent elections. Five, US overthrew socialists. Six, evidence showed US lied. Seven, socialists won general election again. Eight, imperialism lost. And this is a happy ending for now. We don't know what the future will bring, but for now, this is a really huge rebuke of fascism in Bolivia.  So you can install brutal regimes that repress our people. And you do so under the guise of promoting democracy. Like this is really phenomenal news. And let me just say what's obvious here. This proves that socialism really is the antidote to fascism because the material conditions that lead to people becoming so desperate that they're even susceptible to being radicalized into fascism, those are all addressed with socialism. And guess what? They experienced socialism under Evo Morales and it was working. His government lifted millions of Bolivians out of poverty because rather than just taking all of the resources that Bolivia has and hoarding it, they actually benefited the people. They used the resources of Bolivia to create social programs that lifted people out of poverty and it worked. But in order to make sure that a population can benefit off of their own natural resources, you have to make sure that you resist imperialism by the US government and other countries as well. And it's been difficult because the United States has a lot of influence in the region. This has been basically their backyard. Latin America has been their backyard and they've been dominant, but now they're starting to lose that influence and that's a really good sign. And this isn't just good for Bolivia. I mean, it's really great for Bolivia, but this shows that the international socialist movement is growing. It's more powerful. It's legitimized now. So this is great. I look forward to seeing Evo Morales returning to power, maybe being part of the party again. This is just honestly, I'm a little bit shocked by this news because when I saw the news roll in on Sunday evening, I thought, okay, we'll sleep on this and see because nothing good could come of this horrible, wretched year. It's not possible. And I was proven wrong. My cynicism was proven wrong. And this is just honestly such great news for people in Bolivia and around the world. You know, it's a message to the US government. You can't do what you want when you want for purposes of monetary gain for private corporations. This is great news.


Charles, thank you for serving our country. You have been given multiple military awards. Can you tell us about your service? Well, I was 20 years old when I went in matter of fact, I volunteered because the draft was very close to me in the neighborhood and Landed somewhere in England. I could see where planes have been Shot down in the water off England coast In front I crossed the channel I served in France and Germany and I was on my way to the Pacific when a Truman out they dropped the a-bomb And that diverted me back to France I served in some of the things I saw the very disturbing like we couldn't give away food that we didn't eat and I saw sisters and people just Pulling food out of the garbage can that we had thrown away Was not allowed to give them And one of the most amazing things to me was close to the end of the war The Germans were coming out of the woods with their hands up in the air giving up And we took them in and they served us well. We became friends What was one the enemy was shooting at and finally? I was given a hold of a number of soldiers that were going home. I Was last on the list because they had set up time of service family composition and I was not married had no children So I was the sergeant in charge of processing those going home passing me And I returned to Well, I came in New York Harbor and the people were waving and welcoming soldiers home We understand that you just turned a hundred years old. What makes the game of baseball so great? I don't know. I was old back in high school. I never played myself But we just was nothing for us but baseball and football at the time. We're not in the soccer There was some basketball Matthew remember Joe black he was a class and school made a mind and They made it very well But always was Matter of fact, I was a Dodger fan. I Was a Yankee. No, it's a Dodger fan until the Yankees what yet Dodgers moved to LA Then I became a Yankee fan What does being recognized as veteran of the game at the iconic Yankee stadium mean to you? About the biggest thing that's happened in my life at this time It was certainly be remembered me right so my I'll remember it right up to all the last moment Love it the township lovely the playing field And my family and buddies here They all love it too. We just crazy about I was amazed when I got the word Thank you again Charles


And then, hi and hello. I just thought, like, a tiny reminder. Can you put your phones on silence? FLCNOT for, like, the newcomers. And then, thank you, Haran. It was really nice. And now we have Venkatesh Devirella talking about new replication features. Here you go. OK. Thank you. My name is Venkatesh. I'm going to present about my SQL replication, about the new things that we actually added in A.O. This is the safe harbor. What it means is whatever we are going to tell you, later you cannot sue us.  You have to do the testing before it goes into the production. From morning, you've been listening many things about my SQL A.O. And if you observe, every presentation will have something to do with the replication. So we are the heart of the MySQL. And we have so many features that we added. And you can say there is no debate. It's never too late to replicate with version 8. So we have divided the features into these categories. Performance related, monitoring related, operations related. And many more we have added, which we cannot cover it in the time that we have got. So I have just one slide to explain other features. This is the typical replication picture. Before 5.7, it used to be just one particular node. And then there is a link between this. Now that we have group replication, we can have a picture like this. Every particular one you have a cluster of nodes which represents group replication. The link between this cluster and this cluster is asynchronous replication. And I'm going to talk about asynchronous replication. And there is a presentation at 3 o'clock that talks about group replication between these clusters. So you can put anywhere in the world and then asynchronous replication will work across them. So this is how, just to give you the background how replication works. You have master and you have a replica here. By the way, we changed the terminologies of replication related terminologies. Few things I will be telling you whenever I'm using a new word. So we are going to use a replica word instead of slave word. So if you see in the documentations of 8.0, you will start seeing few new words especially related to replication. So if I say replica, it is nothing but the slave that we have. There is no other technology that changes just the terminologies that we have. So this is the master and this is the slave. You write something here that goes to the binary log over the network. It goes to the relay log which will be picked up by receiver thread which is the old one is IO thread if you are familiar with the old terminology. We call it as receiver thread now. So the receiver thread picks it from the network, put it in the relay log and then the uplayer threads which the old terminology is SQL threads which uplayer threads will pick it up from the relay log, puts it on the replica and then if the replica has log slave updates enabled we will write it on its own binary log of the replica. If there is no enable, there is no binary log here. So this is how the regular replication happens. So my main concentration for the first feature will be on the replica slave. So that is the reason I have removed the other part of the picture. So what happens is you have the packets, they are coming through the network and there is a coordinated thread that picks up and then puts it on the parallel worker queues and worker threads will be taking it and then they will be getting applied on the replica. This is the typical how master replica happens. So this is if you have enabled the parallel threads, that is how you look. Otherwise it is going to be just the relay log will directly pick and then uplayer thread will pick it and then put it on the replica. This diagram will not be there. So that is the background. So a replica can apply more transactions in parallel. That is there in 5.6, that is there in 5.7 and we have improved more on the same area. In 8.0 what we have done, I will show you. So in 5.6 what is the parallelism that you can achieve? You can achieve the parallelism based on the database. So anything related to DB1 it will go to worker thread 1, anything related to DB2 it will go to worker thread 2. So if there is no transactions that based on DB2 there was worker thread 2 will be sitting idle forever if there are no transactions. So we can do much better. In 5.7 what we have done is on the master if these are the three transactions that happened exactly at the same time they are all three of them are there in the commit phase at the same time. We can 100% sure that they are not conflicting. That is the reason they were there in the commit time at the same time. So on the master we were able to take all these three and then put it on, parallely execute them on 5.7. So we can still do a further more parallelism here because these three transactions should happen only after this even though these things are not conflicting with them. So that improvisation is done here in 8.0. So what we are doing is we know which transaction depends on what tuples. That information we already have. Now using that information what we can do is if you increase the parallel threads on the slave and then we will see there is 1, 2, 3 and 4 so we can actually do a parallelism on all these things. Let us say the next one is just the row 5 and you have 5 threads running on the slave we still be able to take all these things and then execute them parallely. As long as there is a thread and there is something that is not conflicting we will be able to achieve it. So that is the reason. In fact if you have more parallel threads on the slave you can even achieve much more performance on the slave than the primary. How do you do it? How do you enable it? So there is a parallel works, parallel type. These two are the common in 5.7 also. So what we are doing in 5.7 also you can achieve the same thing using logical clock and this is the main important thing that we have added. The transaction dependency tracking should be the right set. So based on the right set we are doing it now in 8.0. So if you enable it, this one it is going to be the one that I told you, if you do not have this it is going to be the behavior of 5.7.  So what we are doing is let's say you have transaction 1 and transaction 2 even though they are not conflicting we should be able to parallelly execute them on the replica. But there are some applications where you don't want a state on the replica which doesn't exist at all on the master. For example transaction 1 is not executed but transaction 2 is done. The application doesn't want that to happen. They want the transaction 1 followed by the transaction 2. So that's why you have to set this slave-pressure commit order 1 for you will achieve the same behavior. And this is one more thing, performance related which is you don't have to set anything it's just by default the code is enabled. So what we have observed is the relay log is being picked up by the receiver thread is writing something to the relay log file and this coordinator thread also reading it from the same file we are seeing a lot of contention there a lot of log related issues which is reducing the performance. So what we have done is we have done a lot of code improvements there which will give you a huge performance difference when 5.7 to 8.0. So this is one more point that we say that you can upgrade to 8.2 if you are using the 5.7 and this you don't have to set any variables here. And in 5.7 we have introduced JSON in MySQL and in replication in 5.7 what happens is you update a JSON document. So the full document if the JSON is kind of a 1 MB or 10 MB if you modify one particular attribute the full data is getting transferred from master to replica which nobody wants it obviously. So what we have done a new improvement in 8.0 if this is the only thing that you are actually modifying it only that particular thing we will be transferring it. There are settings if you want for some reason for example no we don't want only that particular thing because we have some special mechanism of replica relay logs we want to full JSON document that is by default. But if you want this particular behavior to happen we have settings. So this is the setting that you have to do. This is the minimum which exists in even 5.5 where you have to say only modified columns you have to transfer. So that you have to anyway set it. Even in the modified columns if there is a JSON and you want only the partial JSON which you actually modify then you have to set this. Will log row value options is partial JSON. So you have to set this to make that enable. The same applicable for the other functions. Okay so there are many more performance related features that I will cover at the end of the slide but these are the important ones. So the next section is monitoring. Many people now in 5.7 starting from 5.7 many people converted to RBR nobody uses very less people use SBR statement based replication. But in the RBR the main problem main issues that we receive from the community is the replica is hanging there and we do not know what is happening. Is it that the long running query it is getting executed or is it that what is the query that is running all those information is not there in 5.7. So we have improved upon the same area which is you can still see what is happening and you can see what is the query in 8.0. How do you do it? So this is the now in thread stable if you see the process thing earlier it was kind of saying that row event that's what you see in 5.7 but now you can clearly see the query what exactly you have done it on the master you can clearly see insert into T1 values 1, 2, 3 in RBR that's the and so let's say what we have done is every DML, every DDL internally we have some stages in the process list if you are familiar with process list table there is a column called info that will tell you it is taking system log it is going so and so on but still that will not give you how much percentages of the query is done how much more is done that information is not there. Now we have added in event stage current table where you can say that this is the query that is happening and work completed is 1% of total 4 so 25% is done and then 75% is what we have estimated. So you keep checking this status and then see okay my replica is not hanging it's progressing if you see this 1 is improved 2, 3 like that so you can see the progress now. Another monitoring related things typically in the real time you don't have just AB you will have lot of nodes in the replication chain we never had anything to like always referred what is the lag of D with respect to 2A the original one we never had okay what's the immediate one is it that it really received machine C a long back or is it just that it received where is the problem is it between B to C or is it between C to D all those monitoring was next impossible till 5.7 but what we have done is we have introduced the concept of so this is what I was saying so here we don't know when it is actually added when this coordinator thread picked up when it is a worker queues picked up all those things are not there so what we have done is we have introduced lot of hooks that's called in monitoring all these places and then we have introduced the new terminologies which is you call it as this particular let's say an event is originated on A we call that as the event time stamp is original commit time stamp if you see an event name with original commit time stamp it is actually the one that is actually started and C which we called as for this D this is immediate commit time stamp so if you see some information on D with these two you can say that okay it is actually C immediate commit time stamp and then it actually started long time back on A that information is there now and for various steps here like when it is added when it is done when it is executed all these things we have a performance schema related queries where you can give transaction latency versus primary you can compare and last hop when was it actually happened and when it is actually added when is the worker queues that you actually picked up and you can see when is it added to the worker queues when is the coordinator that got picked up and then when it is actually though it came out from the network when is it available on the relay log and this is when it is relay log downloaded it on the replica so all those places we have different information that can be seen from the performance schema table next one is related to the operations that is more about the variables that we added and few things that we deleted removed and this is multi-source filters which is the new feature that we added in 5.7 but the problem with this is you have a master 1 you have a master 2 and there is a replica here that is getting data from both the nodes but if you want to filter some data there is a concept of replication filters that exist long back but the problem you have a filter on this channel that is applicable to this channel as well it is a global filters but now in 8.0 we have introduced the concept of per channel replication filters so you can actually say there is no filter here every data is coming from this master this replica but there is like I do not want anything that comes from the DB users related I do not want from this guy so that kind of repair channel replication filters you can enable it now in 8.0 so we have changed a lot of defaults in 8.0 because of the community feedback that we received many people I mean in the real time nobody will do it without the replication they want the replication to be enabled so why an extra step from the DB is to enable it so we have done the default since log bin now it is off on 5.7 on 8.0 by default because it is on by default we have to do a give a value to a server id so it is on so log slave updates is enabled expire log days was 0 this is 30 now so this is the main important thing that you have to really care in case you do not want those expire log days to be done so what we have changed it based on the community again and the information that we store the updates the metadata information that we store on the replica was actually happening on the file based which nobody likes nowadays because it is not a crash save so we changed the defaults to table now and the transaction writes that extraction which is the related to the first feature that I was talking it is off now but it is hashed will be calculated which is a this is the name like xx has 64 and another performance related things that we changed the default based on the bugs we are receiving the default one is index scan and table scan many issues were kind of replications is getting lagged it is taking too much time when we debug it is nothing but it is taking table scan by default if you don't have a index so everybody will face it and only after facing it they are changing it to this so then we have done a lot of research on it and which is the best value for the default for the many users to work so it is now to if there is an index for the query that you are doing there will be index scan otherwise it is going to be hashed scan it is not a table scan anymore the default value these are the new variables that we introduced some of them I already covered so bin log expiry log seconds there are some users where the data is huge that they can't wait they can't give expiry logs in days like they want it in off day for example if you take facebook it could be the many gigabytes or even terabytes will generate just in off day they are doing some work like all these particular binary logs that generated transfer it to some other place and they don't want that to be there on the master even the off day also so that's the feature it is actually contributed by the facebook guys where bin log expiry log seconds now what you can do is I want two days and off day let's say if it is off day 1800 seconds or whatever it is so you can mention in terms of granularity is now seconds and bin log row metadata which is one feature which you can enable it if you want an extra information on replica we are writing all the information now the table columns earlier we were not doing anything we are not writing anything into the binary log but if you enable this binary log row metadata many information about metadata we are writing into the binary log if they are available on replica's relay log now there are some people who actually get the information from the relay log after it is saved they are missing all these metadata so that's the reason we added a new feature where the metadata will be transferred and this is the one that I related the one that I told you about the JSON so you can just say bin log row value options is equal to partial where only the modified attribute of the JSON will be transferred from master to replica and this is the one that I was talking about right set you have to set so that it will be taking the new 8.0 feature of paralyzing the transactions as long as they are not conflicting and so as long as they are not conflicting so you should have a particular set where you have to compare with if your load is not too much you can just say that okay after 100 transactions I am pretty sure that the conflicting transactions will not happen so you can set it to 100 we will reduce it to 100 and then the conflict resolution will happen only for those 100 transactions and these are the if you are familiar with the 5657 replication these are the pretty common variables system variables that you use what is the heartbeat period what is the last heartbeat that you received all these information is there as a variables but since we are going towards the performance schema we actually removed all of them and then we have replaced with some information in the performance schema so this is information yeah so many more earlier when the server is disk full there is no way you can execute any of the replication commands because the disk full situation is it's a disk full and it has taken acquired the log log which is very important for the binary log and we are making all the commands related to replication to hang till you clear the disk and then do it but if somebody wants to see what is happening why is it hanging there was no way in 57 but in 8.0 we added the performance schema related where it can do anything to do with the logs still give you the all the information so that feature is there and then since atomic DDL in the morning you have heard it from my colleague so since it is there we have done more improvements on the replication side so we recover DDL after crash is happening even when you do a replication enable also interoperability which is the one that I was talking about metadata is added now more in the binary log and then the transaction byte length also is added that's actually part of the metadata that we have added and earlier in the 5.7 if there is a non-empty server you cannot add GTT support is not it's not possible to restore it so now even in the non-empty server also this if you are enabling GTT that still we can do it you can set some variables so that it works so that feature results for all these things we have a lot of blogs lot of documentation that we have already written so you can go through the documentation of my skill and the reset master the specified binary log file is always that reset master will go back to one the binary log name is going to one which nobody wants it because if they already done 100 the reset master they wanted from 101 right so you have 100 binary logs you actually stored it somewhere because you the master server you don't want to pile up the disk you changed it and then you executed the reset master for some reason it comes back to one nobody wants it because which one that is one and again you have one so now there is a new thing reset master 201 you mention it so the new binary log will be from 101 not from the one yeah so this is the one that I was talking with second precision you actually can mention and so for the maintenance purpose we have removed 4.x 5.0 compatibility code there is a huge code related to 5.1 4.0 and 5.0 related work which we are keep on supporting it look okay what if the master is from 4.0 what if the master is from 5.0 we don't want to maintain that anymore because nobody is actually having on still on 4.x so we have removed completely so if you are still using 4.0 something 5.0 you are not going to support it anymore so that's for the maintenance and as you know we are open source we take the contributions from many people so we just wanted to say thank you for these people who are actually contributed lot of things so in case if you want to contribute go to bucks.mySQL.com or when you face some issue in case if you are able to figure out that what is the issue that is happening you just have to sign some agreement and then put your patch if you figure out that there is no issues at all with your patch we will take it and then we will give you the credits to you so if you can't wait to upload or to download the 8.0 so this is where you can download this is where you can read the more information and the features will write the moment the feature is released we will write a very good blog and then it will be there here and as I said if you find some issues we will put it here and if you have already a patch we will put it there thank you can I have three questions sure you mentioned you mentioned that you can have some books in the correct so is it layer 7 or does it have any sort like networking layer layer 7 does it have any sort of coordination with the ASX or like no it's just that when it is received there will be an in-memory buffer that we maintain saying that it is here and then the performance schema that in-memory buffer this is the time that it is received and we will display it to you so it's application second second third one yeah so you mentioned the per channel correct what's the isolation level of that is it at the level of database or is it at the level of the table yeah we have from the db you can actually say ignore db you can even say ignore table so we have till the table level we cannot say column level but till db there is a do db there is an ignore db you can even mention wildcots the regular expressions you can even mention like you don't want anything that starts with db you can say db star you can say wild do ignore db you can mention the wildcots there it's not a new feature in 8.0 even 5556 you can do a db level you can even table level as well the only thing that we added in 8.0 is the per channel thing it was a global level all the channels are getting affected if you just set it on one on the replica so that is what we have changed per channel you can actually mention that's all I think thank you you mentioned the binary log can you query the binary log for audit purposes yes show bin log events is the way the command that will give you all the information but you should have it's human readable but of course if you are on the RBR it's not a human readable but there is a variable called bin log row query log events you have to enable it for us to write the query into the binary log some people doesn't want that query to be security reasons or whatever it is so even in the RBR if you want the query to be seen from the show bin log events then you have to mention a variable called bin log row query log events so the query events also will be written to the binary log if you have rate it like that then we will say in the comments there you will see insert into T1 followed by the row format that so the row format is obviously is not human readable but you have a query there show bin log events is the command but for show bin log events to be executed you need some certain privileges anybody cannot execute that for the security reasons obviously thank you so much thank you


The Secretary of Defense presents the Navy Commodation Medal to A.V.C.M. Eric Oitzman. The Secretary of Defense presents the Navy Marine Corps Achievement Medal to O.S.C. Brian Wimmeras. A.B.H.1. Bedell Donowa. A.D.1. Brian Lefford. The Secretary of Defense presents a flag officer letter of Commodation to AZ-3 Cassandra Rhodes. The Secretary of Defense presents a Certificate of Achievement to the blue jacket of the quarter, F.N. Joshua Rosario of the Engineering Department. Junior Sailor of the Quarter, A.T.3 Kyla Bence of the AMD Department. Sailor of the Quarter, D.C.2 Benjamin Clark of the Engineering Department. And Senior Sailor of the Quarter, L.S.1 Leonard Carpenter of the Supply Department.


Where you see things going, what do you see down the line for frequency technology for humans? Well, I think there will be a lot more conventional acceptance and application and integration into the medical road. Especially with caraparcters or acupuncturists or any kind of integrative medicine practitioner. Because they're all looking for things like this and they all already know that frequency is the future and they've seen the results already, right? So when they see the technology, they say, you know what, I had a dream about this and this is, you know, about these coils and now you're showing it to me. So I see a lot more, you know, in the business sense and with the medical community starting to integrate this into their practices and as that happens, then as their patients come and use them, then they're going to learn about it as well.