u/yorusora_

Hi people, I haven’t done this before. But are there any downsides of indexing a column on production. Like some query is running very slow, and I figured out that u should put an index on one of the columns. I wouldn’t be here if I had someone experienced to ask from. I’ve a few questions-

1. Is it okay to run the query on my sql workbench to add index?
2. If something goes wrong what do you people generally do, like taking snapshots or

PITR

1. ?
2. Is it safe to run the query directly on the db or usually people run it some other way, like via cli on VM?
3. I heard about locking and stuff. But the version I’m using says it won’t lock the DB. But still anything I should test before actually you know doing it live?

I’ve no idea what’s the general procedure and what could go wrong. If someone has done it before, Appreciate any sort of advice or pointers. Thanks

Hi people, I haven’t done this before. But are there any downsides of indexing a column on production. Like some query is running very slow, and I figured out that u should put an index on one of the columns. I wouldn’t be here if I had someone experienced to ask from. I’ve a few questions-

1. Is it okay to run the query on my sql workbench to add index?
2. If something goes wrong what do you people generally do, like taking snapshots or PTIR ?
3. Is it safe to run the query directly on the db or usually people run it some other way, like via cli on VM?
4. I heard about locking and stuff. But the version I’m using says it won’t lock the DB. But still anything I should test before actually you know doing it live?

I’ve no idea what’s the general procedure and what could go wrong. If someone has done it before, Appreciate any sort of advice or pointers. Thanks

So me and my roommate know each other. We are friends when we see each other, I mean she doesn’t contact me when she leaves from the city where my office is located. Which I don’t like. But I have accepted that, and now I don’t expect that out of her. Well the thing is I used to live in a hostel sort of place, where I bought all the vessels to cook and also got the all the grocery. The expensive organic stuff. I mean I saw the signs, she was working from home and when she used to visit, she often told that she craves home cooked meal and would try to use my stuff to cook. Well, once or twice is fine. But she would come use my stuff, and not even buy anything. I know I can tell no if I don’t want to and I did. But I used to think, that this behaviour is not one should have.

And now we shifted together, and I got all my vessels and other stuff with me. She is using it and never mentioned about contributing any thing. It’s been one month and she didn’t even buy her own plate. And I only had one plate. She would use my bowl to eat. And she is very chill about it but it stresses the hell out of me. Thankfully now she got one from her home.

So today she mentioned that let’s get grocery for the weekend. She said we should switch oils and also use cold pressed groundnut oil, I don’t like ground nuts. I mean if she likes she can get it. Already all my money went into buying the stuff I had, and she can’t even buy an oil that she wants to use? So I told her we can get olive oil, she said no. So I told her that I got sesame oil for my cooking, just like that she can get an oil that she wants. To that she replied she will hardly be here and since we cook together it doesn’t make sense to get another one. But idk man, she still uses my glass and other stuff. Idk is this normal? I feel like she will judge me if I tell her about the fact that it stresses me that she never even mentioned about contributing to the stuff I had. And I mind u organic stuff which is not cheap.

We are kind of close but not like going to each other’s home or sharing food kind of close. Whenever we go out, we split bills.

And also, if any person who shares flat with someone has any tips for me or any advice such that I can de stress please do share.

I’m looking for dramas to watch.

I’ve watched many. Some jdrama or jpn movies that I liked - monster, hirugao, a calm sea and beautiful days with you. Obereru knife, and many more.

Please recommend any new or any underrated ones. Thanks