with another reading for you. Welcome everyone! This is Kelly from House of Virgo. If you are new to my channel, please do hit like, share, and subscribe. This is a channel for Virgos only. Virgos San Moon, Rest in Your Venus. Be mindful, some of the messages may or may not resonate, so take the fits, leave the rest. These are general readings, okay, guys? If you want to get a personal reading, there's a link in the description box below. And please do go over and join my channel. You can become a member. I believe you may have to join from a desktop computer. I don't think the join button is showing up in the app. But once you join, there'll be members only live chats where you can pop in and ask me any question. I'll pull cards for you. We'll just chit chat. I'll be doing that once a week, hopefully starting on January 8th. All right, you guys, so pop in, pop in, pop in. All right, Virgo, let's see what's going on for you. What are your love messages? And in the past couple of readings, that damn n-word kept showing up, that narc-type situation. So let's see what the energies are. We're holding out for some of you. I know, I hear you.  I want something new.  Okay, let's just roll with it. Hello, everyone in the chat. And hello, all of my moderators. Thank you for being here. All right, let's see. Okay, wedding rings. So somebody's got marriage on their mind. Maybe you are married. Soul connection, eternal love, everlasting promise. Somebody's got union on their mind. An exchanging of rings or vows. An exchanging of promises to each other. Okay, so this reading is for today through the rest of January. So let's see. There might be something coming up here for you guys. Okay, the sword in the rose, clarity. Somebody's going to tell you the truth Virgo or come forward to tell you they want to be exclusive or just be in a relationship with you. They're going to reveal their feelings. Okay, give you some clarity. Somebody's got some new ideas or the thinking, the idea of being in union with you. Okay, solidarity. Interesting. Somebody's tired of being single. They want to align with you. Be honorable towards you, protect you. Okay, let's see. That's nice. I think that's a nice start. Okay, camera. Okay, somebody's been thinking about you or they have you on their mind. Maybe if you sent this person pictures, or they're sending you pictures, these are like keepsakes or they have keepsakes of you. Maybe they saw you somewhere and they saved your photo and they keep looking at it. Okay. Somebody here has learned from the past. They've learned from some past mistakes. There's healing. The rose represents love. Okay, so you might be receiving a rose from someone or they're sending you roses or giving roses to somebody. Okay, Grim Reaper. So there's somebody here who was in a relationship of some sort and that connection, that relationship is over. They're not giving that person any more second chances. Okay, this person is growing and transforming their life, their life. So feels like the Grim Reaper came and told them and showed them what life is going to look like if they continue on with somebody from their past and they've decided that's done. It's dead. If they continue on with someone else, I feel like maybe you're connecting with someone or you meet someone in January who was in a relationship with someone who might have been more like the Grim Reaper and just kept showing them nothing but death and sorrow. Feels like this person is confirming to themselves, no, it's dead in the water. This relationship is done. I'm not going back to this anymore.  Okay, one more. Okay, keys on a ring. All right, this person has a lot of options but they were, whoever they were with in the past was just stringing them along or it was just this person is done with any kind of one night stands or meaningless casual acquaintance friends with benefits types of relationships. Either they chose to be in or that they realized they were in they put their heart out on the line and came to terms with, well, this was never going to be anything else. There's never going to be anything healthy. The person I feel like they were with just had a really bad energy about them and maybe you meet this person or you already know about this person and they come to terms with this to come and they give you truth. They tell you what was going on. They reveal to you what they've come to terms with. They have clarity. They're making a final decision here that they're not going back or they're not repeating past mistakes. They know what their purpose is in life. They know they want to be in a healthy relationship and this person is seeking, you know, union like long term type of a relationship. All right, so I'm feeling this is really good news coming for you. All right, now for some, okay, like I said, there is an energy of reminiscing. So for some of you, this could be a past person. Then something ended and they went with somebody else and you know, maybe it was a rebound or they realized that that wasn't their person or they made a mistake and for others this could be somebody new who comes in and just explains the situation that they were in. Okay, which I really like that energy because someone's coming forward with truth. Like they're not hiding anything. Let's take a look and see what the tarot has to say. All right, look at that, seven of cups. So yeah, this person, I feel like they realized they've been, this person was ghosted by someone and they realized that they were living in fantasy with this person. Whoever they were connecting with wasn't going to commit. This person is tired of living in a dream like state, visions of grandeur, living in a fantasy world, never knowing where they stood or knowing where they stand with other people. And I feel like this person was confused by whoever they were with, their behavior of the other person. Like one minute, it feels like they got a lot of mixed messages from whomever they were with and it left them in in the clouds. This person was pulling smoke screen over them all the time. Okay, and I feel like if you knew this person from before, if you were involved with them and you knew that they were going out and floundering with others or they were just, you know, not taking your relationship seriously and you walked away and you just said, you just took a look at the facts and the evidence that this person was just not coming through for you in a way that you needed them to. A lot of you let them go and I feel like letting that person go, it feels like this person is wanting to try to have a reunion with you, okay, and try to have a successful connection if this is a past person. And for others, it's really the same message of it's just somebody new or someone you're talking to it currently, you know, because I feel like they look at their past person and they see that their past person, now just remember, the roles could be reversed. They look at their past person and they see that their person was just flirting for attention. They were just very much an attention seeker, okay. This very well could have been your past person who was never able to commit and was just seeking attention all the time and just really couldn't, you know, they were seeking attention from others to help build up their ego, that kind of thing. They desperately needed the praise. They were just living in Vanishingland. A lot of you ghosted this person and said, no more of that. You're not interested in, you know, being well for them to keep siphoning from. A lot of you just put a cap on the well.  Their life is or has become unfulfilling. It has not been sustainable. It's not enough. It's kind of like people who, you know, when somebody takes a drug, it just doesn't sustain. You have to keep getting more and more and more till finally it just doesn't work anymore, you know, and you either switch drugs or try something new or you just completely surrender. It's really, it's really difficult life to be chasing waterfalls all the time, right? Where's the satisfaction in that? Okay, so we've got fire energy, Sagittarius, Leo, Aries. Okay, now some of you could have been connecting with that person of that sign. The one thing I will say is whoever they may have been with in the past was very secretive. It came up, the person they were connecting with, either the person they were connecting with or this is your person, was coming across as someone who seemed to be very confident, self assured, but that was a mask. They were just fronting, okay, and keeping some deep dark secrets about who they truly were, okay. Yet still, I feel like maybe in the past this person was just chasing after you continuously, but it might have been just for validation, okay, if this was your past person, if this is somebody else that you're meeting or talking to connecting with, they had the same thing with another person. So you guys come together in some kind of like, yeah, oh yeah, yeah, I get it, yeah, no, I really been there, dealt with the same type of an energy, you know, there's, what is there like three types of people there are, they are the irresponsible people, okay, they're grown boy, grown girl energy, or they are the people who abandon, they're the abandoners, or you've got people who are the criticizers, the whole judgment, they look for perfection in relationships, you know, so whomever you were connecting with in the past was one of those three, whoever your person that is new was connecting with in the past also had the same energy or one or two or three or all, you know, of that similar type of energy. So let's put that aside and take a look at a relationship that I feel could possibly be forming here. I mean, the point of the relationship, you two, this feels very early, it feels like you're connecting on some level where it's like you're getting to know each other right now. Let's see, tell us more, tell Virgo more about this relationship with somebody new here, or someone from the past, okay, there's regret, oh, there's a lot of regret, okay, there's remorse, there's sadness, okay, so somebody's coming in here feeling quite down and depressed. I don't feel like somebody's ready to rush into anything just yet, okay, somebody's still letting go of hurt and pain, they, so many now also these energies could be you as well, somebody here feels abandoned or very unloved, okay, not good enough, there's a sense of loss, lost their soul, lost their self-esteem, a sense of regret or loss that they had to let somebody go, even though they knew they needed to do it, there's still that breakup pain, that feeling, there's also a sense of looking at how somebody was floundering around with others and disrespecting the relationship, taking a look at how somebody was just messing around, look, I'll show you what I was seeing, it's like finding out that somebody was just, you know, having way too many drinks with too many people and flirting in a very disrespectful way in the relationship and somebody's looking at that here and just like wow, that really hurt, you know, so it's not time for somebody yet, I mean they know, somebody knows that they want, it could be about self as well, if this is a past person who's trying, wants to, is reminiscing about the past, they have a lot of regret and remorse for the things that they've done as well in their life, that three of cups, those three cups of spilled didn't work out, regret and remorse for not turning around and seeing those two cups that were there the whole time, okay, okay, and you know, whatever the situation is, I am seeing somebody here that's still grieving, a loss, still in a bit of pain, you know, but I feel like somebody here is pushing through the struggle, you know, is not afraid to face the fear and the labor and the hard work of letting go, okay, that 10 of, or now I was going to say 10 of cups, but the 10 of ones and energy is like, just somebody's really stressed here, they're exhausted and that's why I'm saying, I feel like, whomever it is, somebody just not want to repeat the cycle of the past, it was just too, it was unfulfilling, it was a relationship that could not, it was just things could not be sustainable, it's how I feel, okay, so there's definitely clarity coming to someone here on some truth, truth with self, truth with another person about how things went in the past, making a decision here, regret and remorse for stringing someone along, okay, or having one night stands, somebody might be realizing it's just the relationship is over, there's no second chances and is taking steps to grow and transform their life, okay, see I called out this 10 of cups and they gave it to me, okay, putting those burdens aside, it's not, it's an energy of like actually working through the problem, not running from the problem or working around the problem, it's like going through it, working through it, I feel like somebody was carrying a very heavy burden, a lot of burdens in their life, they just kept building and building because this person could never just put the wands down and say forget it, I'm done with this, I'm not, it's too much, I'm too exhausted, somebody was forced to let go of relationship, was forced to be done with something because it was just too much of a burden, so here's the, here's the glow happening, the 10 of cups energy, here's the support and the healing coming in, okay, contentment and joy, marriage for some, a new beginning is starting here in love, you know, an ending in a new beginning is happening here, like the 10 is always, for me, it's not, it's more like, like the nine is about completion, like okay the cycle's completed, but the 10 is like the finale, like now we celebrate, you know, the, when you finish your last day of work and then you have your retirement party, your last day of work is the nine of cups, your retirement party is a set of cups, right, and here we go, celebrating because we're coming to the end, the cycle is complete, it's finished, and now all the good energy starts happening, the celebratory, the support, the healing and the love, the emotional fulfillment, and the freedom, okay, we also have cancer and we have Aquarius, so the freedom comes in here, somebody is sets themselves free, completely, you know, there's fresh hope, somebody takes a risk on a new path here, I was ready to have a new beginning, the 10 is the completion and the zero is starting over, okay, like a child, like a fool, like willing, letting go, once we release the burdens and the hurt and the pain, anybody, once that's, there's like an uplifting sense, no more of that weighing down energy, and then that's like free, a freedom comes, and that's what I feel like is happening here, okay, it's either for your person or it's going on with you, and a new start here, feeling inspired to start over growth, okay, and there's an energy here as well of like, someone feels an urgency to connect with you, like an urgency comes out, somebody's definitely got it for you as well, there's a very strong physical attraction as well here, so all right, you only eat of cups here, okay, and I feel like it sits under the eight of ones, somebody is like walking away from another person who is forcing their obsessions on another person, I don't know who that's for, it was just a message that just came out to me now, but somebody's moving on, okay, whoever felt like they were abandoned in a relationship, they're not chasing after to get back in, they're actually saying, okay, well, if this person's going to leave me, I'm going to let them, and just keep going, I'm just going to keep moving forward, I don't know who that is for, it goes that you could be this other person, um, whomever it is, whatever's going on, somebody's walking away from the struggles as well, abandoning the pain and the hurt, which is a very promising thing, now let me get a couple clarifying cards, let's look at the high priestess, so part of the secret that somebody was keeping um, was that they were trying to, they were trying to lock on to somebody else's finances, I don't know what exactly that means, but somebody was looking at another person as paycheck, as a meal ticket, okay, um, child support, this could be the person that you're currently talking to or will be meeting up with in January, um, they may tell you that the person that they were connecting with only ever saw them as a lotto ticket, only ever, only ever saw them as a financial, um, way out, a financial gain, okay, um, and I feel like the person that you are talking with will express this to you, because they come to have some clarity about this, they thought that the person they were talking to was really interested in them, for who they were, um, but that actually was not the case, they come to realize that that was bullshit, that's a real tough pill to swallow, when you're giving your love and then you're finding out that the person who was loving you in return was was doing it had like underlying motives, tough, tough, tough, my sympathies on whomever you're communicating with at this time who had to deal with that, um, but if this was your ex serves him right, serves him right, I know, I know some of you were like, well, if you left a relationship and this person got involved with someone else, then you're kind of like, all right, serves them right, because they should have known better, but apparently, I don't think so, because I feel like the person you were connecting with was just kind of living in like a dream state, fantasy land, and they agreed to open themselves up to someone that they really admired, and they thought would be a better, like the grass is greener on the other side, and that person actually only wanted them for money or status, or things like that, okay, and that's why I get a sense that whoever you're, if this was your ex, your past person that you had a relationship with, and this resonates for you, that's why I get a sense it's like the grim reaper showed up at their door and made them realize that was a bad decision, that was a, that was a bad decision, that's why there was regret and loss here, okay, I just saw the native cup, so this person is going to be coming in to give you an offer of love here, like I said, wedding rings, give you clarity, truth, they made a mistake, they feel remorse about that, okay, fine, keep it moving, and even, you know, if it's your person from the past who's learned the lesson, or it's this is somebody new who learned a hard lesson, which we do have learning from the past, I feel like this person, they want to give you your love, but they're going through this healing, this grieving process at this time, okay, and I feel like you might be helping them in some ways, if you know if you're already connecting with this person, or if you meet them going forward, you might be helping them by relating, sharing your story, and telling this person, yeah, I understand, you know, so there's kind of like a common bond there, but I wouldn't allow that bond to create that new relationship, just accept that about each other, and then create new truths, and create, make some memories together that are good and positive, right, because eventually, if two people come together based on their past experiences, and that's all that they they're glued to each other about, when those past things eventually fade, and when that fades, then they're both standing there like, whoa, we were glued to each other based on past stuff, but what do we have going forward? What memories do we create going forward, right, so if you are getting involved with somebody here, that you have similar experiences from unhealthy connections in the past, it's okay to share them, but don't dwell on them, create new things together, okay, because when those past things begin to heal and disappear, you want to have something else that you're holding on to that's healthy. Let me just take a look at this Queen of Wands, and it's the same thing if it's your past person coming back in, you know, if you spend the whole time talking about the past issues of the relationship, you know, and you're, you're, you're bonding over the fact that you're healing each other, that's great, but where are the new, where's the new stuff you're creating together?  All right, she made this Queen of Wands, okay, yeah, Three of Pentacles, this feels like someone that was connecting to another person in their past or that they ran to. Um, this person was, whoever they were connecting with was only co-op, co-op, wait, what's the word, collaborating to, I feel like using them, using their status or their skill set to increase their own, it wasn't about love, I didn't see anything here about love, okay, we have Libra Jebediah Aquarius as well, so I don't see anything here about love. I see a whole lot of Cupid's Arrows and I see a whole lot of like maybe some physical things, physical attraction and a lot of ego, but I don't see true love, deep love, partnership, all right, so I feel like that's really important for you to know, pay attention to, especially, um, you know, as I say, Virgo, you want to take somebody back, I mean, I feel like people can, people can always come back and just say they're sorry, but sorry is, sorry does, you know, words only go so far, somebody's truly repentant and, you know, can have a conversation with you and, and you can say, well, this is what, you know, if, you know, if it's a past relationship, this is how I felt hurt and this is what you, these are the things you did and these are how I felt about that and if the person, a healthy person is going to turn around and say, wow, I didn't realize I was doing that and I'm, I'm sorry, can you show me? How can I make it better? What can I do? What do you suggest? You know, they're open to finding ways to repair the past relationship, but if the person turns around and is not open and then they blame you or they say you're overly sensitive, you're overreacting or you're overthinking it, you know, these are all abuse terms or you made me do it or it's your fault, then let that person go because they're not safe. That's not a safe person and we're not looking for perfection in relationships. We're just looking for openness and honesty and to be able to create an intimate bond. You know, maybe you meet somebody new, Virgo, who just blames everything on another person from their past and doesn't interject anything like, well, yeah, I mean, my past person was really, I think there was something wrong, there was issues, but and I did the very best I could. I'm sure there's some things I could have improved on and maybe I'll get another chance in this relationship with you, Virgo, that I'll be able to show that I've improved in a lot of ways, but you know, it's, there's a bit of humility and humbleness that comes with vulnerability and being in an open loving relationship that has to be there. It has to.  But I also feel like this person coming in is basically already decided there's no more chances with the past relationship. It's done with whomever they were with. Now, I don't feel like this person is coming in. If it's a past person to say to you, this relationship is over, there's no more chances.  Usually when people are done with their relationship, if they've spoken to the point where they can't talk anymore, they can't, they're like completely exhausted, there's nothing left to say, somebody's not listening to them, then they just leave. I don't feel like you're this person from your past.  Okay. So for some of you, if all your past relationships were with narcissists, this isn't about that. This could be about a friend or a sibling or a coworker, a colleague. So keep that in mind. Okay. Not every single reading is going to be about the narc. Not every single reading is going to be about your ex. Okay. Some of you might resonate with yesterday's reading and be listening tonight and say, Oh my gosh, that's my fricking brother.  Or my friend, this friend that I recently made like a year ago, it's just disappeared. You know, it is a lot of a lot of, like I said, you have to be open minded when you listen to these readings because a lot of stuff can show up that you may not be aware fully because if you go in kind of like thinking to yourself, this is going to be about my ex. And it doesn't make sense. Then you're missing the message. When you start with these readings with me, you start listening, take a deep breath, open your mind, listen and see and plug in and see where it's fitting in your life. Okay. And if you didn't do that yet, do it now or do it tomorrow. All right, I've got to, I just, you know, I started uploading on my Moom Pitero channel last night and I'm going to keep doing that. So that other channel, if you don't know, that's my initial, my first channel and I do every zodiac sign and I do readings every 10 days for the next 10 days. So if you're cross, if you're just in cross-watching, wherever your person is, I don't recommend cross-watching because then you're too focused on other people. I recommend you focusing and staying focused on self and healing self always. Let's take a look here. I was using these cards, so I'm going to use them here. Okay. So manifestation, laying all your cards on the table, fear not, use every tool in your arsenal to create, manifest this new journey as it is above and below. So we'll be here on earth. Okay. This is the magician. Okay. So there's definitely a new beginning that's happening here, turning visions into reality, feeling inspired and taking action based on inspiration. Okay. There might have been a lot of scattered energy in the past or a feeling of wasting or not knowing which direction to go or not being able to have fulfillment in a particular relationship. All that's turning around now. Okay. It's focused on the course, focused on the path at hand and actually putting in the effort and doing the work to make things happen. Okay. You also have wealth, health and abundance. So Virgo, I can tell you in January, you are coming into some wealth. Your health is going to be good. You're going to find that like somehow whatever you're doing, whatever, see the magician always feels like you're magnifying all the pluses and zooming out and away from all the negatives. What you focus on is what you create. Okay. You focus on negativity. That's what you're going to keep creating in your life. But if you focus on positive energy, and I'm not saying you have to like wake up and be like living in a cloud and be positive every single day. That's a, that's a task. We strive for that, but don't beat yourself up if like one day you're like unable to accomplish something or you're not feeling like you can do something or just not, you're feeling kind of in a low mood. That's okay. You're human. That's a human condition, right? But whatever the things are that you are able to focus on in a positive way, you create this abundance for yourself. You'll begin to see it around you. It just begins to magically happen. That's what the magician talks about creating that magic in your life, your health beginning to improve. You know, healing energy starts happening. That thing that you were worried about in your health begins to like start healing. More money coming in. Okay. Maybe somebody gets a raise or a promotion or gets offered a better job. Right. Maybe you get that stimulus check or that tax refund that's a lot higher than you thought. Okay. Abundance is just really like you have all of a sudden you were at one point in your life. You can only afford one roll of toilet paper.  And it's a feeling of like, you'll feel like, wow, my wishes are actually coming true because of things that you're manifesting because you're laying your cards on the table and you're taking a look here in January.  You're not helpless. You can do the things that you need to do with whatever you have to work with. Use those tools. So I see good stuff coming in for you. Okay.  A lot of fun, a lot of sexual passion coming in here. Some communication or some kind of offer from someone coming in. It could be this, this person here that we've been talking about in January. There could be travel or trip this person wants to come in and be with you, like in a physical sense, be very intimate and physical and I don't mean, listen, I'm not saying you got to like do the deed. Just saying it's more like physical intimacy, like kissing and hugging and cuddling and being close, that kind of energy, but it is lustful because it will give a sense of like turning each other on. And I do have to just preface, if you're going to like go down that road with someone before given this time for someone to prove themselves, I would stay away from that energy because that could go downhill real fast and leave you feeling worse. Right. I'm not telling you what to do here. That was just some advice that I was picking up, but just be mindful that this energy is coming in because there is somebody here who's, you know, even if it's not a past person, and this is someone new that you're talking to or will be coming in, try not to put the cart before the horse too soon, especially if this person is still in a grieving state from a past relationship, treading dangerous waters there. Okay. Just be, just be mindful, but apart from the lustfulness, there is a very fiery passionate energy with this person. And I feel like because it, this comes in the form of the Night of Wands, it's not, let me make something clear. I see a lot of readers that they show the Night of Wands and they instantly say, this is someone who's like a sexual deviant and they're impulsive and they're a player. That's the Night of Wands in the reverse. The Night of Wands in the upright is very free spirited and a creative person. Okay. And that is just the definition of the Night of Wands. You know, they come in with a very strong, a very passionate energy, very physically active type of a person. Okay.  But there is lust. It can be like, lust doesn't necessarily mean sex. It can just mean a lust for life, a very strong, passionate energy. Okay. But sometimes those passions can lead down that road. If you two are just sitting on the couch and you're getting close and, you know, you're, you know, I think men have more of a difficult time with that than women. So I don't know. I feel like maybe I'm talking to the guys here. Just be very careful because when you act on your passions and your lust, you get in trouble. You wind up putting the car before the horse.  Control yourselves. All right, let's see. What else? Oh, luck is on your side, Virgo. The wheel is turning in your favor. You have the Midas touch. Good things are coming now. So be ready. Yes, you deserve this, Virgo. Karma is on your side for all the good you've put out.  For some of you, like, totally the wheel is turning, things are shifting and turning in your favor. Okay. Every, every good ounce of energy that you've put out in the past, some of you have finished those soul contracts. There's karmic soul contracts. You have completed the cycle. Some of you have learned your lessons. Things are over. Okay. And you're starting new and it's coming in now in the beginning of this year for sure. Starting. Okay. If somebody doesn't show up in January, don't sweat it, but just know the energy and the atmosphere is ripe for this to begin manifesting. Okay. As long as you have opened yourself up to that, nothing's going to come in, nothing's going to land in your hand if your palms are closed. If you're still holding on to something in the past, okay, you're not going to be able to open up and receive unless you drop what's in your hand. I'm not letting go of the past. I'm holding on so nothing can get in here. You know, and at the same time, you're holding on to something from your past and you're asking spirit or universe, please bring me, bring me and they keep bringing you people, but nobody can get in. You got to let go so they can receive. You have to surrender in order to receive. All right, let's take a look here. What else is going on? I hear my grandson crying. Popular social female. Okay. Okay. For some of you, this is just someone who's going to be significant at this time in your life. Okay. I don't know how and I don't know in what way, but this person actually does come in here as a queen of wands and that's twice someone who's very confident and self-assured and feisty. Let me ask, in what way is this person coming in? Aries, Leo, Sagittarius, the snake. Oh, okay. I just heard there's going to be some interference in a relationship, third party, third person showing up again or showing up, interference. Okay. This is an enemy. This is the other woman and for you guys, it's the other guy, for the other man. Okay. So, if you're getting involved with someone, either the past is returning or you've got somebody new, I feel like wasn't that yesterday or maybe not? Was it, it was either also in the Aquarius or the Capricorn reading. I did on my other channel. The snake was here. There's competition, definitely. This person's clever, malicious and somebody needs to be very, very careful. Popular, meaning this person is in the public eye in some way or just everybody knows who this person is. All right. But you also, for some of you, are going to be gaining popularity, maybe on social media in January and be careful because there's a lot of snakes out there. Okay. Some of you might have a competitor that could be another person, a male or female, who will try to compete with you because you will really gain recognition in January in your, whatever you're doing in your career or your finances or just whatever you're doing in your life, even in love. Okay. Somehow you're going to be exposed, but in a good way. Okay. I also got a loving older female. All right. Let me see. Now that could be you or it could be somebody else. Let's see. How is this loving older female? This is a queen of cups energy. Someone who's very nurturing, healing and supportive, generally. Let's take a look. Oh, girl talk. This is going to be a friend. Time with friends. Moving on. Happily single, living in the moment, having fun. This could be a friend coming to you who's recently out of a relationship. This feels very much like a friend, male or female, that you might be communicating with. You're going to be spending time with this person in January, like a night out or getting together. Okay. With some other females or other males in your life. And just really living it up, having fun, celebrating together, reminiscing a reunion of some sort coming up for you in January, meeting up with some, some old friends, which is good. It's, it feels like kind of like a night, a night needed out. All right. And good news about money. Yeah. That's what I was saying here. Wealth, health and abundance. So you guys are definitely going to be getting some good news because everything I said about the wealth, health and abundance, like there's something coming in here for you. You're going to be receiving some news, some financial news. Hmm. There's a communication. There's a letter or text in email or something that comes in about a new job or race. Some profits gained. Maybe something with stocks, although I hardly think that right now. But you never know. There's definitely going to be some good news, like some, something you've invested in in the past is now you're getting paid for that or you're getting paid back or you're getting recompense, recompense. Am I saying that word right? Yeah. So it's very positive, very good news about money. I'm up. I'm up for that. All right. Let's take a look and see what your initials and other messages are here. This, this reading felt like really peaceful. I posted in my community tab, you guys, that I was listening to this video last night when I went to sleep. It was like one of those calming music things. I never, ever, ever, ever listened to those things when I go to sleep. But I turned it on and I was like, Oh, I kind of like this.  I'm not kidding. I posted the link in my community tab if you want to check it out. I mean, maybe I'm the only person on the planet who's experiencing like I'm the last person on the planet to be experienced or speaking about this, but I swear it's true what they say. I never do this, but man, I woke up so rested and so peaceful. I wasn't feeling nervous or anything. I just thought, let me just try a different way of going to sleep. And it was glorious.  And I actually have a blankie, believe it or not. It's a big blanket. It's not like a kid's blankie, but I just curl up with it. You know, no matter what, no matter who I'm with, I just curl up with that. I just love it so much. All right, let's see. Okay. All right, I'm seeing campfire. I'm seeing a campfire right now. Somebody camping or building a campfire, sitting around the campfire, there's or just fire, like a fire pit or something, or having some drinks or something, or planning to or thinking about that. There's even like a lantern, you know, when you're out at night. Okay. Um, somebody's birthday is on the 9th. I just heard rest in peace. I just heard rest in peace. And I'm also getting the birthstone peridot, P-E-R-I-D-O-T. It's green, green birthstone, peridot, peridot. Is that how you say it? When I was a kid, I used to call it peridot. I used to call it biplane, a bitplane. So, yeah, I'm just hearing, oh, and then they just told me RuPaul. They just gave me an image of RuPaul and the name RuPaul. Okay. Let's see. Somebody likes the color lavender. There's a sixth, somebody's birthday is on the 6th, or somebody was born in 1996 or 1969. All right. So they're giving me now, this strange, I'm seeing triple X and I'm seeing mirrors, triple X and mirrors. And I'm also seeing enter the dragon, the mirror scene, enter the dragon. Is that in the mirror scene? I mean, is that mirror scene in that movie? I can't remember now. It's been so long. Jax, who's Jax? Jax? Jackson? Jax? Jax? Jax? Okay. Something like pretty profound happened in 2020 for someone specific. May of 2020. They're just seeing shattered illusions, a shattered illusion. Okay. Wow. This is just, when somebody comes in, somebody comes in who's got really long black hair, very long black hair. They come in with like in a magician energy. This is also the person that could be connected to a fire. I'm just seeing a fire. Are they connected to fire or fires in some way? And somebody's birthday is on the 1st. And also the 19th and the 16th I'm hearing. And then they're giving me the 11th. Okay. I just, they just told me Game of Thrones. Game of Thrones. Okay. They just told me the Knight, who was the Knight in Game of Thrones, Lannister, the dragon slayer, King Slayer. Oh, that's it. King Slayer. I don't know what that means. I don't know what his first name was. I just know Lannister and a Knight. King Slayer, Game of Thrones. They said, maybe you know someone who looked like that person. I'm just seeing the image, the face. I'm also seeing somebody has dyed their hair very light blonde, like almost platinum. Maybe even has a tinge of silver in it or gray, like purposefully dyed like that. Or maybe you might have like a tinge of gray or silver in your hair. And then I'm hearing, they're giving me grapes, grapes. They're saying grapes. Somebody's eating grapes, maybe. That's interesting. All right. Let's get into your charms. What do we have? Oh, you've got the monkey. Very cute. Very cute. Watch out for flying monkeys, Virgo. Just what I'm hearing. Oh, and they just told me, they just said fruity stripe. Fruity stripe. I don't know what that means. Fruity stripe. Or fruit stripe. Wasn't that a gong? Or fruit? Or somebody's eating sunflower seeds as we're listening. Okay. There's just all these messages that come. There's a message on Twitter and there's a private message on Twitter for you that's coming in January. I don't know who it's from. Could be somebody who was born in the year of the monkey. Oh, and then I'm hearing the name Daisy. Daisy. You're telling me Daisy. Oh, okay. So you've got money here. Maybe they meant to say year of the money. Somebody's going to find a hundred dollar bill or whatever it is, whatever the monetary name is in other countries. But it's a big bill, a hundred. If you have a, if you have hundreds, hundred, hundred bills, why can't I talk today? It's going to be a surprise. Like it's folded up and you'll unfold it. Some of you might think that it's not real. Like it's a joke, but no, it's a hundred. It's gift from spirit. It's gift from the universe. That could be good news about money coming in. You might find it in your co-pocket or I don't feel like you're going to steal it, but you know, money's money. It's going to be in a, you're going to find it in a place where there's anybody around where you can give it back or find out if it belongs to anybody. This is a gift for you. So take it. Right. It's a gift. So I don't know. Maybe some of you already found it and you're going to be getting it. So or somebody's going to give it to you, but I mostly feel like you're going to find it. I'm not going to pull it and work because I'm just really pulling me back to this monkey and the money. It's interesting because somebody's name starts with a K. That's what they're trying to tell me. Somebody's name either starts with a K or there's a K in it. It's very significant and either something about making money or finding money and the year of the monkey. They could be connected. They may not be. And somebody's going on like a safari cruise or this doesn't have to be in January. This could be anytime or the saving money to go on like some kind of safari vacation of some sort somewhere. I don't know. It could be like your local zoo or it could be like a actual expedition somewhere in another country. All right, Virgo, I'm going to leave your messages there. Please let me know. There's a link in the chat here to join the membership. Okay. So it's going to be pinned at the top of the chat. Go up there and click it and join if you want to get to be part of my channel. And to my moderators, I'm going to check and see if I can get you guys in there without having to pay. But if not, you may have to. So if you want to do it, awesome. If you don't want to do it, don't worry about it. It's fine. But yeah, you guys. So also go check out my other channel, Moon Pie Tarot. If you're interested in any of the other zodiac sign, I will also post a Virgo reading up there as well. Okay. All right, you guys. So awesome to talk to you and see you again. I'm going to go get something to drink. We just had like a big snowstorm and I was going to take some pictures, but it's like, wasn't really that bad in the area I'm in. So yep, that's it. Love you all. Okay, I'll see you guys tomorrow. Take care. Bye.


nue to be a high priority for for a lot of people and You know the longer the longer we're forced to wait to address those issues May add to the difficulty of finding solutions I agree though. I reckon though. I recognize the difficulty of doing the kind of um broad community engagement that we had hoped to do When when zoom is is our primary tool at the moment We've been using other mechanisms for participation for like the sustainable transportation plan and even net zero plan. So Um, I think that there are some other things to brainstorm But it it is basically remote and virtual and very hands-off obviously Okay, I think I have everything I need though Rachel The only thing I was going to just chime in with was whether or not there was anything any topics Although they seem to be a little bit more tactical from the town's economic recovery task force that would be Important for I know that the select board has been very involved with supporting many of those efforts and then our board less specifically so although again supporting those who are moving forward with development in the town in such a difficult economic time is something that Is important to this board. So I'm just wondering if there are any topics related to What we're hearing from those business owners in town that we should add to the agenda as well That's a great suggestion. I I can definitely figure out Uh, how we reference that in the meeting. Okay Okay, that's all great Let's see. Uh, so the next item on our agenda is um open forum so we will um invite members of the public to To speak on on a topic of their choosing um, you have, please note that you have Three minutes. I think jenny will be running the clock again Um, we ask that you please state your name and your address for the record As you begin. So if you are interested in Speaking publicly at the meeting tonight in the open forum if you could please use the raise hand function in the participant section of zoom Give it a minute All right seeing none. We will close the public forum section of the meeting get back to my agenda here and Think that concludes our agenda. So do we take a motion to adjourn? Well, I'd just like to say Well, I'll second that But I'll uh, also just say congratulations to rachel and welcome to kathryn Yes, welcome kathryn and thank you Thank you. I hope I didn't screw anything up too No, I follow the faith in you Great Thanks. Do we have a second to adjourn? Yes Great, so I'll run through the list here. Uh, kin. Hi Jean. Yes, david Yes Katie Yes And I'll say yes as well. Thank you everyone Have a great night. Thank you everybody. Thanks. Talk to you soon. Bye. Bye.


What kind of teacher do you want to be? What kind of teacher do you want to become? Can you picture it in your mind? Well, I did it. When I first started my journey as a Portuguese and English online tutor I asked myself this question and it landed me on a few ideas Which are also present over some units of the ESL teachers course I've been a student for a while and I am still today This year I merged in the education field taken this bright decision had brought me a lot of joy During my Tefal or TESOL teacher course lessons I recognized some of the do's and don'ts of my past teaching behavior and analyzed it all together I found an outstanding example to be followed. The best English tutor I've ever had was Mr. Gerson Why was he so special to me? He was a kind teacher who would sound like a database while calm speaking with his impeccable British accent Besides, he used to drive his lessons through boldness teaching techniques I'd choose him among others because he was a student too He was studying to apply for a job position as a Brazilian diplomat That factor was relevant to me because I believed it made me feel more comfortable with the uncomfortable situation of learning a new language What else could be more exciting than finding a teacher who is also a student? He used to share his past life experience with his students and conduct his classes with so much wisdom He used to bring up reliable and relevant materials during his lessons Which gave me the sense that his lessons were more consistent than others and yet his lessons were light Mr. Gerson carefully attended to students needs improving our pronunciation and teaching our ears to understand English His body posture during class was relaxed I remember it too well and his voice was gentle and precise and most importantly to us. He never judged us Instead when some other teacher was assigned to teach my class I found that they were getting bored teaching lacking confidence or seemed too apprehensive or lacking professionalism However, what I mean is students know even in classes. They've never taken before Students can feel how committed a teacher is or not with her or his classes So I thought to myself, how can I become as good as mr. Gerson? Well, first of all, I needed to like my job and be in class with my whole heart as he was Show to the student you care during your classes pay attention to your students and keep an eye on their progress It is your job to make sure they progress Do not forget that you are being paid by them which turns students into customers too Being creative about it is an excellent way to show your commitment. Don't be afraid of getting inspired by other teachers ideas or materials Listen to your students. I realize that teaching has a lot to do with listening Be open to suggestions and not only deliver to them. What do they expect to go beyond it enhance their ideas by adding your own Students want it and they will appreciate it Make the ordinary extraordinary to keep archiving goals students need to be motivated. It is part of your job to do so Relax don't rush things. Go slow and make sure your students understand what you are teaching Planning your lessons beforehand is fundamental, but keep in mind that it will not always be as perfect as you've outlined in your head Control your expectation level about it. Remember that the final result is an exciting part and essential But the journey is even more important in Conclusion if you consider branching into the education field as I did you will probably notice that a well-skilled teacher also Pursues perfect timing. It is very important to build a relationship with your students by treating them as a client Show them why you are the right teacher not only with words, but also by delivering an outstanding first lesson Show them that you understand what they need. I guess being a great teacher is more about overcoming obstacles and challenging yourself This behavior will lead you to become a bolder educator. Do you want to teach English online or abroad take a TEFL course?


Alright, so my name is Michael Wood and today's topic is WordPress database optimization and maintenance. So this talk is going to be mostly targeted at people who understand what database maintenance is in the sense of you're probably a developer. However, we, if you're not a developer, you will have actionable things that you can actually do because there are plugins that can handle a lot of what we'll be talking about. So don't be afraid if you're not a developer, you should be able to understand this and put it into practice. There will be some words of warning as we go through for those of you who aren't developers just so that you know kind of what to expect when you get into this. Let me start out with just a quick introduction of myself. So I'm a WordPress developer at Bluehost. You can find me pretty much by Googling WP scholar and you'll find previous talks and websites and all kinds of stuff that I've done. So if you want to reach out and ask a question or follow up to this talk at some point feel free to reach out. So there's a few tools like I said there's some plugins that allow you to do a lot of the types of things that we'll be talking about. So one of those tools is a tool called query monitor. For those developers here, you're probably familiar with it for those who are not developers query monitor is kind of like a debug tool per se for WordPress. It will tell you what's going on behind the scenes. You know if things are taking a long time and are slow, like specific WordPress database queries, things like that. It will help you to see those and it will expose those types of things so obviously talking about database maintenance, a tool like query monitor which will just allow you to kind of view everything that's happening in WordPress is very helpful. So, that's one of the tools. Another tool is a plugin called WP optimize so this was a plugin created by the updraft team. So they're the ones behind updraft plus the backup plugin. So, we'll talk a little bit more about this. This is not a plugin that I normally just run on a site. I usually just use it to aid and some of these database tasks that we would do. And then this one, we probably won't, you probably won't need this. Ideally, your web host will have some sort of PHP my admin interface if you need to go and run some sort of database query. If you can run WP CLI you should be able to run database commands as well. But this is a tool that can be used if you need more database access and you don't really get that from your web host for some reason. I figured I'd throw it in but something you can play around with but we probably won't highlight in this talk. So when it comes to database optimization obviously the thing that we're really looking for is how can we speed up our site. And you know is database optimization the thing I should be doing to speed up my site or there are other things I should be doing to speed up my site. Typically when we're talking just general performance. There's a lot of things you would do probably before you get to database optimization, although one of the big things that would be helpful with database optimization is object caching, which we'll talk about here a little bit so we'll look at kind of a high level of like what are the types of things that we need to think about while we're monitoring our database and trying to figure out how it's performing. If as we go through you have questions. Feel free to post them in the chat, I do have the chat open and I'm looking at it. Do as best I can while I'm talking. So as your questions come up I'll try to answer them. And I'm sure there'll probably be a lot of questions. This is not a topic that I hear much about. So hopefully we'll get some good, good questions. So jumping into the questions to ask right so what are the types of things that you should be looking out for when you're trying to optimize or in general just do maintenance on your database. So what you want to ask yourself is how many queries are happening. And so, you know what's a normal number of queries that's going to depend on the type of site that you have right. So, in general, on average you might see WordPress make it anywhere from like 40 to 60 or even 100 queries on a page. That's not out of the ordinary. So if you have seen sites that'll make 400 queries 600 queries. And obviously, if you keep going higher. This becomes a problem. So ideally you want to reduce the number of queries as much as possible. So anything that we see happening that we can reduce is ideal. And sometimes you'll see, as you start to look at, well, where what types of things are are triggering the most queries. And I think that a particular plugin is essentially a bad actor and they're making hundreds and hundreds of queries. None of them can be cashed with object caching. And so then you have to question, you know, am I going to continue to use this plugin is there an alternative to this plugin. So a lot of times the fixes, it can be just moving away from a tool that you've been using, because you didn't realize it was not very performant. And that is if there are any slow queries. So are there any queries are taking a long time to to happen, right? Obviously that's going to slow things down. And there are specific types of plugins that do require more advanced queries and things are going to take longer. Obviously, those are the kinds of things that are core to your website. You probably don't want to just like kick a plug into the curb, because obviously it's your need a plugin like WooCommerce or something to run a commerce website. You don't, you know, if there's slow queries happening there, you probably don't have the option of eliminating that. But knowing that a query is slow and figuring out, you know, is this query cashable. Is it something that, you know, if, if we properly have object caching and stuff that we can kind of cut cut down on that. So there's a lot of a lot of little things like that we think about. Are there any duplicate queries so duplicate queries is something where if code is not using the proper WordPress approach essentially, you'll get a lot of duplicate queries. If you're seeing those kinds of things than chances are that you might be looking at some plugins that are not properly implementing the WordPress approach to using object caching or transients. And then are there any front end rights happening during normal page views that is very specific. And that is actually one of the things that if you have a high traffic website. That's probably one of the worst things that you could have on your site. So for example, there are plugins out there that want to keep track of how many visits are made to your website. And one way that people who write these plugins might do that is they say okay well, I have a counter. We started at zero and then every time somebody visits a particular page or the website in general, we'll just increment that counter. Well, that's fine. Except to do that, they have to write to the database and writes to a database are way more expensive than reading from a database. So we can easily fetch all the content metadata and all the things that we need to display stuff on the site. But the second that we have to write back to the database that becomes a slow process. And if you have high traffic sites, that's the kind of thing that creates a bottleneck that it can really cause performance issues. And as we get into more of like our storage engines and stuff that we'll talk about, it'll make a lot more sense why this is really, really bad. So, pretty much, if I see a plugin doing front end writes I usually as fast as possible just drop it. I said if there's a plugin and there's only one that it's related to your core functionality of what your site does, then you know maybe reaching out to the developer and trying to to work out you know hey can we do this a different way. It's not helping performance. So that's one thing we look at. And as I mentioned before. So are there any particular plugins or themes associated with these problem queries. Now, when we're talking about all of these things, if you enable query monitor. And you load up the front end of your site at the very top of the screen there's a little thing that will show up it's got some random numbers and stuff. If you click on that it will pop up a panel at the bottom. You can go to the database section and it will show you all the queries that are happening. You can filter by plugin and you can filter by theme. And you can look at if there's any queries that are front end writes or things like that so most of these things that you see here, you can kind of identify using that particular plugin. Let's, we're going to kind of start at the grand scale and work our way into the minutiae of database optimization and maintenance. So, speaking at the grand scale of the database as a whole. Let's look at just a few things that we can do to to optimize so first of all you just want to make sure that you have enough resources on the server to make sure that you can properly run your database without issues. So one of those things is if for some reason you're running out of disk space. It's possible that there will be corruption of the database files on that disk space. So if you don't have enough disk space on your server. That's a problem. Typically, if you're not self hosting a website. Most hosts have this all sorted out for you. However, never hurts to just verify that, you know, you're not coming up on the brink of, you know, disk space issues because either way, that's going to cause issues for your site. The other thing to look at is making sure that you have enough RAM to keep my sequel running. So if you don't have enough resources allocated to the random access memory, then what'll happen is my sequel which requires a certain amount will crash and stop running, even though the website will continue to load things it just won't be able to fetch anything the database, which obviously makes your site kind of useless. So there's kind of the two big things with server requirements just to make sure that your database is functioning correctly so. As I mentioned the next big thing is object caching so object caching, if you're not familiar is essentially every time that WordPress needs a piece of information, it will go and fetch it from the database. And so to do that, it will create a query requested, you know, I want to pick everything from the users table all the users from the users table where email equals whatever. So some kind of query like that. And some of them are way more expensive queries than others. And so the whole idea of caching is taking something that's expensive takes a lot of work, and making sure that we can keep a copy of that work as long as it is valid. And then serve up that that shorthand right so if I wanted to get the square root of 64 might take me a little while do that in my head but if I know the number and you asked me what the square root of 64 is, then I can tell you right. So being able to just kind of quick respond is essentially what object caching is doing right it says I know for this query that this is the answer so I'm not going to have to go look it up. So that's kind of what we're looking at. So, first of all, you want to find out if your web host actually offers object caching. This is not really something that you're just going to be able to install a plugin and have object caching. This is something that has to be already on the server. So, if, if your web host provides it, you should definitely enable it. If your web host does not provide it. You might want to look and reconsider your web host, assuming that the database optimization is a real problem for you, which for a lot of small sites it probably or low traffic sites it's probably not a deal killer. So, the easiest way to validate object caching is working is to use, like I said, queer monitor. And you may need to use another plugin to make sure that the object caching is actually probably properly working again, a lot of web hosts will have their own plugin to handle the actual integration with the object caching that they offer. However, a lot of web hosts also allow you to delete said plugins so if you happen to delete the plugin, then it's very likely that your object caching would not be working. So this is what it would look like. If you open up the query monitor panel on your site, whether you're on the front end or the back end doesn't really matter. And you go to this overview section. Down here, it has object cache and as you can see, it says persistent object cache plugin, not in use. However, we have this APCU object cache installed, but is not being used by WordPress and even give you a nice little link says install an APCU plugin. So, if you're seeing that you have object caching it's not in use, then that just usually means that you need a plugin to take advantage of it. And in some cases you might see oh we don't have object caching available at all, in which case, you know that's that's where you might readdress your hosting if, if the database is a problem. So typically when is the database going to be a problem if you're running a big ecommerce or an ecommerce site in general. A lot of those queries are going to be coming in to the database and it's not queries that we can really, you know, store because, you know, if one person puts a bunch of stuff on a shopping cart, we can't really store that for somebody else right. There's a lot of things with ecommerce that does require actually to be dynamic and and it does require like fresh queries to database. So, object caching can help to a degree. But, but yeah so we want to take a look at that and just make sure that we're using it so if you see that you're, you have redis available, and you have no redis plugin. This would be the redis plugin most likely you would use, unless you happen to be on Pantheon in which case they have their own redis plugin. If you happen to see that you have a memcache is available, then this is the memcache object caching plugin. Yes I am screen sharing, hopefully more than. Yeah, hopefully everybody can see. So the, the memcache plugin will will work in most cases, unless exception, you're on site ground in which case, the only way that I've found to actually get their object caching properly working is to use the site ground optimizer plugin, which does conflict with a bunch of other optimization plugins I like to use. So, typically, if there's a site ground site. Object caching is the only thing I turn on on that plugin, and then we use some other optimization plugins. All right, so one of the things that you'll want to take a look at because a lot of times you install plugin and the plugin will add some database tables, and then you decide oh I don't want this plugin it didn't do what I thought it did so you remove it. And then all of a sudden the you know once you delete it the plugin didn't clean up after itself and so there's a bunch of database tables that just are lingering in the database that really aren't even used at all. Yeah, let me let me do stop and reshare the screen see if that helps here. Just a second should be number two share. Let me make sure I pulled chat back up. Yeah, hopefully that reshare help. But yeah so you have plugins that will just not clean up after themselves, and it will leave a bunch of tables behind so this WP optimized plugin will allow you to see pretty easily if a table database table is not in use so for example you see in the screenshot here, the red items there where it says not installed, and in blue it has the name of the plugin so this is essentially the plugin is recognizing from a known set of database table names that this database table belongs to this plugin, and you don't actually have that plugin installed. So then it highlights it as this is really not in use. So that's really great. It makes it really easy to find those things that are kind of left behind.  Because like I said it just pulls from like a data source of known database tables and if there happens to be overlap, you could delete some stuff. So, the benefit of using WP optimize is that it's written by the people who created the updraft plus plugin. So you can actually install that alongside of WP optimize, and they have a checkbox that you can check before you do any database table manipulation. It will automatically back up your database as part of that process. So, highly recommend that you backup before you start deleting database tables for obvious reasons. There's a little bit more to the screenshot that's actually not showing here but for all the items that it says you know this this plugins not installed so this tables not being used over here just past this index size, there would be actually an action where you could do a remove and that clicking that button would remove that database table. So, the problem with that is, again, make sure you backup first. All right, so we've kind of looked at the database level right so now databases have tables.  So there's users and user meta posts and post meta comments and comments meta and taxonomy tables and. And then of course we have all the other plugins that are adding things as well. So what do we do about table optimization. So, the first thing that you want to do is make sure that you're using the no DB storage engine for your database tables. And again this is a per database table. So not a whole database, you can't just change it once and have it work for everything. Each individual table, you have to set it so. There's two database storage engines so one is called my isam it's kind of the older one. And so when you are writing to the database, it will do what's called a lock right we want to make sure that if we're writing to the database that's that maybe somebody else go into the site. Isn't also triggering a query that's writing to the exact same thing at the exact same time, and then causes a conflict and then you get corrupted data and so it's a mess right so the database is smart enough to say okay, we're going to lock this down when we're writing to the database now. As you can see it says, locks the entire table when writing or updating data, which means if you have a plug in that's, let's say incrementing a value in the options table to keep track of how many people are visiting a site. The entire options table gets locked down, which means anybody in the front end admin, or I'm sorry the back end will not be able to change settings on the site. Other people going to the front end and having that same query that needs to happen will not be able to do that until the other queries done. So as you can see the more and more traffic that you start to get your, your table in the database becomes the bottleneck for serving all of the people who are coming to your site. So that is the important thing about front end writes, making sure that doesn't happen. And also that you're not using my isam, because in ODB, when it locks things down it only locks the specific row that's being written to. So that frees up the rest of the table. So in the case of a particular value in the options table being set, that still means that somebody in the back end of WordPress and it's changing some other setting, it will work. So it allows for more simultaneous operations when you're using in ODB. So that's the logic behind it. So what you can see is it to do, again, WP optimize makes it pretty simple. So what you want to do is you'll come in, and you'll look at your table list and as you can see here we have comments and comments meta. And if we look over to the right there's just a button that says convert to in ODB. And you can literally click that. And then all of a sudden, your table is converted from my isam to in ODB. It's very easy. Again, always do a backup of your database just in case something goes wrong. Because all these database operations are would normally be done by a developer, you know, and they're not as easy as a click a button, usually. It's great to have the ability to do that. But you just got to be careful and back back up your site, just in case. I think the convert in ODB is actually really safe to do. I've never had a problem with it ever. But you never know what might happen. So it's always good to get that back up. You can also use WP CLI. So if you're familiar with WP CLI, you can do WP DB CLI, and that will allow you to write my SQL commands to essentially do the same thing. So show table status will basically just kind of list all of your tables. So table status where engine equals my isam will show you all the tables that you have in the database where the engine database storage engine actually needs to be updated. And then if you actually want to fix it for each table that you find, you'll run this altar table. And the table name engine equals an ODB, and that will update it as well. So if you're wanting to do this without installing a plugin and you have easy access to WP CLI, like for example, WP engine has their little WP CLI terminal built into their hosting platform, you can actually do this kind of thing there. And then we want to look at optimizing tables. So optimizing tables. So by default, and this is an interesting thing with WP optimize by default, they don't actually optimize in ODB tables, and they have this warning that shows up. And the reason they do this is because sites that are running older versions of my SQL. It's actually kind of a risk to actually try to optimize these in ODB tables. But you can do it if you're running a more recent version of my SQL so you can check the box to optimize those tables anyway. It's going to do the most good for the my isam but obviously we're going to convert those. So being able to run this database optimization is very helpful. If you want to run that from the WP CLI, you just run WP DB optimize and it will take care of it automatically. And then if you want to take a look at the date, the table sizes to see you know is there a particular database table that's ballooning in size that we need to look at or address. You know you can use WP optimize and it shows you the size of the data in those tables, and it also of course list the number of records. So if something is just incredibly large, which a lot of times the options table can get very large. Particularly if you have a heavy traffic site. There's sessions to get stored in the options table and so if you get 3 million people visiting your site you could have 3 million rows in your database table for all the different sessions. So, and then of course there's transients and all those, depending on whether you're using object caching or not can get rid into the database.  So usually that's that's where you're probably going to see the largest size. But you know one 1.5 megs is not that much. You know my sequel can handle quite a bit. You know, 5 million roses. You know it can handle. But obviously if you're at like 3 million things are going to get pretty slow. So you don't probably want to keep it pretty low, but if you have a big high traffic site, then expect to see that be a much larger. So removing unnecessary data can actually cut down for example on the size of some of these database tables so post revisions for example. In some cases, post revisions would just be stored indefinitely right you could have 1000 revisions on a single posts, and they just sit there. There are ways that you can configure in the WP config file. There are ways that will limit the number of post revisions per post to say 10 or 30 or whatever you think is appropriate. But obviously at some point, we need to make sure those revisions get cleaned up. So if you haven't set a specific value for how many gets, you know, how many persists, then WordPress isn't really going to like auto trash those, and you have to go clean them up yourself. There are auto drafts so every time you say I want a new post. It creates an auto draft so even if you leave and technically there's an auto draft. So sometimes we have a lot of those that just kind of sit there, and also need to be removed. So if you delete a post. And for example, maybe you don't have a specific timeframe in which the trash is set to be emptied which is again configurable from WP config. If you don't set that then trash posts could sit there again indefinitely and build up over time. And then of course spam comments and comments that have been trash, most likely they're spam anyway. Those, those can obviously build up quite a bit. And so sometimes it's a matter of well I don't use comments so let me just turn off comments and then clear out the ones that we have. Sometimes it is, you know, let's enable a fiss matter some other spam prevention plugin to cut down on the spam so we just kind of have that auto taken care of WP optimize does give you the ability to like schedule some of these types of cleanups. So if you want to say, delete all spam within, you know, over the two weeks, it would, you'd be able to do that and have it happen like once a week or whatever. So then any unapproved comments or expired transients, and this one's a little more risky to do but again you can do it with the WP optimize plugin which is to clean up orphan data. So for example, let's say you've added some data to a post and well, there's a lot of different scenarios where where data just kind of just ends up floating somewhere in a database table and the related item got deleted. So, all those kind of use cases are handled. But again, that's a back it up first kind of thing so this is the interface where you can do that in the WP optimize plugin. Let's see. So examples of transients. Yes, so transients. So, so there's a, we'll talk a little bit more to in depth about transients, how they work with object caching and all of that. But basically, if you have no object caching transients are just stored in the debt and P options table. And so the way it works is, you know, let's say I made. So I wrote a plugin and my plugin hits some other service like say Twitter, and maybe grabs a list of tweets or something like that. I can take the results and just say, hey, I want to store these as a transient. And so that would get put into the options table. And of course, you can store small things and you can store really big things. It's better to store small things. Because the bigger you get the slower things are going to get with your database so we'll talk a little bit more about the size of things in that options table as well but transients, they're just, you know, the equivalent of an object cache when there is no object it's a key value pair situation so if I say I have this thing I want to save it I want to give it this name. Next time I call it by this name give it back to me that's really all that's happening here. All right, so we've kind of looked at the database we've looked at the tables and now we're going to look at the queries themselves that are coming in to the database and how we can optimize these so this is where we get a little bit more into developer territory. Like I said that we've kind of given you developer ways and user friendly ways of doing most everything else. But usually if you're talking queries, you either can suggest to a developer that they improve the performance of something if you happen to see something weird, you know, happening with a particular query. I don't know about what's happening to ask for it. But that's what I'm saying most of this section is going to be more developer focused. So, when you make a query in WordPress. You can just make the query. If you don't use the WordPress caching functions for the WordPress transient functions. What's going to happen is, every time it's just going to hit the database and fetch or run that query whether it's a right or a fetch or whatever. I'm going to make that query, and it's going to be an efficient right because every time and it's going to always make that query so if you know it's possible that you could cash it. That would be the way to go. WordPress provides WP underscore cash functions, WP cash get WP cash set WP cash delete things like that, that you can use when you're writing your code to make sure that all of the important things that you want to store that, you know, extra work that you did. You can just fetch it by name next time that that's the way you want to go right so here we can see some code. It says, you know the cash key is my items, which is just obviously you would come up with a better name for the specific thing that you're trying to store. And we're basically saying well if, if we do a WP cash get for that cash key and it returns nothing, then we need to do the query anyway. So, but otherwise it would skip this condition and just return the query which is set up here. And this is probably not the best way to write the code from a best practice standpoint but it does fit on the slide much better so just give me that. Okay, so you make the query and you say okay, I want to do a new WP query and I'm going to fetch some stuff and it stores it all in the query. So I'm just going to store that whole query using WP cash set and so it's going to store it at the whole query as my underscore items. And then it is going to. So you can do some grouping that's what this empty string here is, and then you can set the amount of time before which that expires right so day and seconds would be one full day.  So this looks great right so you like okay, we're using the cash functions which means if object caching is enabled, then this would be cached, which is true. But there's one fatal flaw with this particular bit of code in this slide. And if anybody wants to lead your guests in the chat feel free. Otherwise, I'll go ahead and reveal. Basically, there is one major exception. And this is actually a horrible practice, the way that it's done on this slide, because you should never cash in WP query instance so when we're talking about the size of things in the database. Basically the size of a WP query instance is pretty enormous. And top it all off every WP query instance stores a copy of your database username and password, which is not something you want replicated all over your database because if there's some code that can read a particular value. Then you're basically giving your database access to to them right. But like I said, the query is huge. So if you are for example trying to fetch, you know, I don't know, 100 users or something so you have all the user data, and it's stored in the query. And you're storing the whole query. You know that's that's pretty big and it has sensitive data. So it's better to get the IDs of the users and just store a comma separated list of IDs in the database than it would be to to store all this other stuff right so that's what we want to be careful about when we're thinking about how we're putting things into a database. So, as I mentioned we have these WP cash functions and we have these transient functions. And so we're going to kind of take a look at the similarities and the differences between the two. So if you use the WP cash set function, it will use object caching, if it is present. However, if there is no object caching it will fall back to what is called a runtime cache, meaning if WordPress is loading up and it needs to make a query. It will make the query in the database, and it will, it will essentially remember that for this one particular page load. So if that query is made again. It won't make the query again it will just fetch it from this runtime cache. So it prevents duplicate queries on a single page load. But, you know it only stores it for that one page load so if you have a lot of traffic, you're just making the queries, all the time if you don't have object caching. It does that the ability to group entries, the whole idea behind grouping entries is, you're able to say okay all of these things are together and so that means you can clear the group of entries as a whole. Right so you can flush essentially a subset of the cache. Assuming that you've grouped them in a particular way. So for example, I think WordPress does this with post meta. It might group them by the ID of the post and so it makes it easier to clear everything for a particular post. So having a fall back, or I should say the fall back is not persistent. So if you fall back to that runtime cache, it's not going to persist past a single page load, basically what that means. But it does, as I said, prevent duplicate queries. So what does that look like on the set transient side. Oh, one more thing yeah you can you can also set the expiration. So on the set transient side, it will use object caching, if it is present so that's the same as WP cash set. However it falls back to database storage so if you set transient it will actually store your transients into the WP options table. So this can be good or bad right so if. Well, with any object cash there's usually some data storage limit. And it could be as little as like two megabytes. So depending on the amount of caching that's happening if you're caching tons of stuff, it could just be kicking things out of the cash normally. Well, if you're falling back to the database it's not kicking things out it's just constantly throwing new things into the database so if you're what I would call over caching. Then you would have a problem of the database. If object caching isn't actually present using set transient database starting to balloon in size, which again, that also becomes an issue so things to think about. You can't group entries with set transient, which means that you have to flush all the transients, or you just delete one by name at a time. So you can't do a subset. The fallback is persistent. So if there's no object caching it will, you know, continue to use that transient as long as it's valid. You can do duplicate queries not just on the specific request but across multiple page loads. And then of course you can set the expiration for those as well so kind of a comparing contrast on those two. So there may be cases where you might want to use one of the other you're just going to have to weigh the pros and cons. One of the other things about queries when you're making a query to the database, the number of joins will very directly impact the essentially the overhead or the performance of the query. So as you can see, here we have a meta query as a relation is doing two comparisons for meta and then somewhere below that it's doing some sort of taxonomy query and then it's comparing a few things there. So the more of those kinds of things that go into a single query, the slower that queries going to get. I think it's even exponential potentially with with joins so important to avoid unnecessary joins obviously there are certain things that would have to be there to make things function right. But if you get a little crazy with it, you're just hurting database performance so good to make sure that you kind of check yourself when you're using those types of queries like meta queries taxonomy queries and take queries. Let's see we have a quick question here says maybe something, nothing to do with database Google tag manager Google analytics slows down the site. Is there anything you can do. Yeah, definitely not database related so we're not going to obviously delve into that right now, but Google tag manager and Google analytics can slow down the site and so just really cool side tip I would recommend looking at. I always say it wrong but cloud flare. It's not as a razz it's something very similar, but they actually can load up a lot of the tags like Google tag manager does Google analytics and things like that. And basically what that means is it takes away a lot of that. It can load things way more perform than if you just use those directly but like I said, not database related. But a little side tip there. All right so we're getting kind of into the last 10 minutes here there's a few kind of little advanced things just want to get your brains thinking about, because if you kind of do all these things and you're still having some issues. Some other things you might want to look at. And then we'll kind of there's resources at the end and of course if anybody has questions will answer but so like I said you know if you for every person who logs into your site right so like if you just have a bunch of people visiting your site. You know like WordPress session associated with that and WordPress doesn't use sessions in the sense that if you think about PHP sessions and things like that that's not really the same thing it's a session stored in the database. So if you have an e-commerce site and you have a bunch of people logging in to view their account and stuff like that. Storage will balloon. And so you may need to come in and clean that out now deleting a session is not a huge deal all that means is that the user will be logged out and I've logged back in. So, you know if you have 3 million session records in your database but only like 150 people are actually logging in and on a given day, then you know it makes sense to to clear that out. So, this is a query that you can run to see how many of these sessions you might be getting of course you can wrap this little star with account at Perens to see the exact count. But you can also just do a delete from WP options where option name equal is like WP session that will clear out all those sessions. And there's probably some plugins that will actually do that clearing as well which may be a more reliable way to do it. Another thing to think about is the options table has a bunch of things that will auto right so anytime you love WordPress whether you're on the front end of the back end or wherever, as long as WordPress is loading. It will always run a query to load all of the options in the options table where auto load is set to yes. The idea is to fetch everything in a single query, because it would be more expensive to do it in individual queries, get everything in a single query that needs to be available all the time. And then make that accessible to the plugins and things that need it right. So that's the idea behind this auto load. It used to be that WordPress didn't put an index on the auto load column and it was performance thing and all your web posts would do that. But now you don't need to do that WordPress takes care of that for you but the issue here is one you may have a lot of things that are auto loading that don't need to be. And you could also have a lot of things auto loading that are just humongous. And you wouldn't really know that's what's going down your site unless obviously you took a look to see what's going on so this could be something that's happening. So this is a query that you can run to check the overall size of the data being auto loaded so you can say okay well, you know, my threshold is five megabytes 10 megabytes, you know, 1000 kilobytes whatever you want. And so you can you can run the query kind of figure out the overall size of what's being auto loaded. And then you can kind of take that a step further. And you can check to see, let's say we take the top 10 things and we want to see which ones are the biggest right so it might be that you have one value that's just huge and everything else is kind of small. So this will kind of give you an idea of size for a particular thing and you can see also as part of this what the plugin by the option name you can usually determine what the plugin name is that's associated with that particular option. So again you can evaluate do I want to use the plugin. Do I want to kind of like run a query to not auto load this particular value to change the value of the database to auto load. No, essentially. So there's a few things like that. And this query just is a way for you to easily find all of the auto loaded data for a plugin. Now, let's take this jetpack example right so jetpack does load a decent amount of stuff in the options table and auto loads it. Obviously, you have the option to not use jetpack. But in some cases, you've already stopped using jetpack but all of these options are still in the database. So that's a use case where it makes sense to come in and say, what are the things that are auto loading and what are these things are not used anymore it's kind of like the tables that were deleted or that are no longer used because the plugins not there. So you could do a similar cleanup here. There's no plugin to date that I'm aware of that handles this kind of thing. So it definitely is a developer task. But it is something that is worth looking into especially if you have a lot of things being auto loaded, especially if they're very large things being auto loaded. So the resources screen here will post on the meetup page a link to the slides. After the talk. And, but yeah so these are the things that we're using right so we have a link for query monitor. So I recommend you just kind of go to the query section and query monitor and look and kind of play around with that. We've optimized so we've already shown you a whole bunch of features of things that you can on just two screens and that plug in you can check up and get a pretty good idea of what's going on with your database. The PHP my admin plugin. Again, something I don't really recommend unless you absolutely need some other way of getting into your database. So that is WordPress admin or WordPress access, you can actually run a tool like this. And then, you know the redis and memcache plugins. If you need to utilize object caching that exists at the host. But again, you know if you have a particular host also should just look to see if their custom plugin would run for that. We've included a couple tutorials so this one is how to use query monitor I know I didn't talk too much about how to use it. But this will walk you through with screenshots and everything how to how to use that. And then a little tutorial on how to properly cache query results. So if you use those WPC like commands that we highlighted, and then we have kind of some advanced reading here, which is. So if you liked the last three slides that I went over the advanced section is probably for you. I've got a lot of a lot of details on how to kind of break apart queries and figure out, you know, what about this kind of change to make it more performant and if you're creating custom tables for your own plugin. You know how should I set the indexes and you know how do I go about doing this kind of options table cleanup so those are the resources. We're about at time but if anybody has questions, go ahead and post them in the chat. And again if you do have questions later you can always go to WPColor.com I've got a form there you can submit contact form for questions, and you can find me WPColor on Twitter and hit me up there as well so. I appreciate everybody coming up.