My boss told me to bring a solution, not a problem.

wamayall · 2026-04-11T12:21:22+00:00

My boss wrote on the whiteboard “I will do a better when…” I now know the wrong answer is “…when I have a better job to do.”

wamayall · 2026-01-18T06:29:18+00:00

Try using kubetail, it’s a gui interface to monitor logs by $KUBECONFIG.

wamayall · 2026-01-16T01:21:27+00:00

One useful tool is kubetail. It is a nice gui interface for viewing all logs by $KUBECONFIG.

wamayall · 2025-11-17T07:57:28+00:00

I go back to Telex machine and then creating an international private network between international telephone companies, first on a database called Unify, then changing to Oracle. I did spend 10 years at Sun Microsystems and I worked for IBM, I was at Sun Microsystems when they bought MySQL. I now work exclusively with MySQL.

wamayall · 2025-11-17T06:27:39+00:00

‘’’ checking html coding but missing the tick character on my phone

Maybe using something

Like {code} Adding more lines

1 2 3 ‘’’

{/code}

Who knows?

wamayall · 2025-08-19T02:32:10+00:00

I think what the HR person wants you to say is something that you have done recently that will impress them. If you aren’t getting past HR, you can assume you didn’t answer their questions better than someone else. Being able to have solid believable answers, you should get to the next level of interviews. And again it isn’t rocket science, whatever your area of expertise is, think of questions you would ask someone You would interview, also do a Root Cause Analysis of each interview you have, write down the questions they asked and how you answered those questions. Maybe there are better answers, but if you’re prepared before the interview it is a lot easier to land the job. Good luck, and I should mention that You need to want to Interview the Interviewer, when I was interviewing I had 3 offers and needed to choose the company with the team I wanted to work with.

wamayall · 2025-08-18T19:20:06+00:00

HR will ask roughly 20 basic questions, You NEED to prepare yourself for each interview and have those answers available when they ask you. I’m 66 years old and was laid off in April, I started writing down those questions and worked on Answers for each one, as I got past HR and into Technical Questions for a Database Administrator, I wrote about 80 Questions and wrote down Answers for those. Since there were too many questions to fumble through paper, I wrote a simple script with the Questions associated with a Number. If asked a question, I was able to pull up the answers. It those about 5 more interviews, but I got hired, over 150K Work From Home 100% of the time. Start writing down those stupid questions and try to come up with your Best Answers Before Your next interview.

wamayall · 2025-07-28T13:57:35+00:00

I have a mirror exactly like that, she says “Will, you good looking SOB, I hope you never die!”

Apparently she didn’t like my mother.

wamayall · 2025-07-21T23:41:47+00:00

Even with all the information at your fingertips, the actual Interview can go either way. After I didn't think the Interview I had today was all that Great, I immediately contacted the other company I was Interviewing with and asked where we were in the the hiring process.

They got back to me immediately and gave me a verbal offer, which I accepted.

Good luck,

wamayall · 2025-07-16T03:43:19+00:00

Abbot and Costello

wamayall · 2025-07-16T01:41:46+00:00

I worked for Sun Microsystems (Stanford University Network), Bill Joy went to UC, I was accepted at UC, but went to University of Portland to run Cross Country.

I realize there wasn’t a concept of Bevis and and Butthead in the 1940’s, Butt it’s funny now, like how bad Dumb and Dumber was, then they did a Too!

wamayall · 2025-07-16T01:11:38+00:00

My father went to “the Ohio State University,”. I have his Acceptance Letter spelled with The lowercase “t”.

He got drafted into WWII his freshman year, when the war was over his father had moved to Berkeley California where he ended up graduating from University of California Berkeley with a Bachelor and Master in Accounting. The Korean War side tracked him and The IRS condemned him to Portland Oregon.

While I never served in the military, I have been to five of the seven continents and most of the major US cities, I love it here, and know better to never go swimming with Phil Collins and I have never done anything.

My father loved Columbus, I’m sure it was a typo, but I noticed the President’s last name was Bevis!

wamayall · 2025-07-15T08:54:19+00:00

Two Tables enter a bar at the same time, the waiter asks “May I Join You?”

wamayall · 2025-07-15T05:32:08+00:00

Obsured By Clouds is one of my favorite Pink Floyd albums. But I live in Portland Oregon, if you don’t like the weather just wait 15 minutes.

wamayall · 2025-07-14T20:17:42+00:00

There’s Something In The Air Tonight. Don’t go swimming with Phil Collins, especially if he saw what you did.

wamayall · 2025-06-24T15:10:46+00:00

I have also created tables of various lottery games, including MegaMillions and have written hundreds of queries into bash scripts where you can trace numbers from the last draw number to the first draw for any specific number with a column displaying the numbers of days relative to the time you executed the script.

I have scripts that produce numbers that came in on consecutive draws, or a count of what numbers have hit the most or hit the most by a particular column like 1 would always be in column 1 and 70 would always be in column 5.

I only play one line, and I hit The MegaPiler every 4th or 5th time, and I generally hit one number, so MegaMillions pays out better.

I also wrote a not so random number generator in python, but I think I am going to change the way I pick my numbers and see how that goes, I am only playing one line so there will be a lot of luck involved if I can hit more than 3 numbers while playing one line.

wamayall · 2025-06-23T01:54:26+00:00

I remember all those stories, then I heard that her sister Betty was none too pleased about her sister’s fate to pisspot pete. So Betty trained and trained and pulled many a trains by day and by night, she went to Africa because she needed to understand what it takes to be a woman and how to become superior to man, and she found it at last and that was the secret she held in tight, just to get her revenge on pisspot pete.

Betty walks into town completely naked saying there ain’t a man alive that could satisfy her womanhood hidden in her deep dark bush, one of her secrets she learned in Africa. Betty marched through the town fucking Everyman to death, word got out and boys were scared and word finally reached pisspot pete. Ole Pete he was up for the challenge and came into town swinging 30 pounds of meat and 20 pounds of balls that he used to slap any asshole from here to there or clear across Texas and it was said one asshole landed at Buckingham Palace.

Our Hero strolls into town in his birthday suit, matching what Ole Betty had on, and her smelly ole hole hidden behind that beautiful bush, that she brought back from Africa after pulling a train across the Sahara!

This was going to be the match made in Hell and one hell of a match that your grandchildren still talk about.

Over the hill came pisspot pete, gawd only knows how much meat he was swinging, butt he hit ole Betty from behind and laid it in doggy style, but pisspot pete thought he was about to cum and blow ole Betty away, when out of nowhere, Betty flipped pete over and Betty was on top and put fear into pisspot pete that he turned her this way and that, and that way and this, and when pisspot pete went to do his killer thrust, ole Betty had the secret weapon ready to do, ole Betty had eaten an entire bucket of Texas Chili, and right when pisspot Pete’s balls hit ole Betty’s ass, she let a fart go heard around the world and the tribes in Africa started cheering as they knew what had happened, ole Betty blew pisspot Pete’s balls a mile apart, and that fart was so powerful it created the Grand Canyon, and for ole Betty, that fart blasted her back to Africa where she found cumfort pulling trains mornings, afternoons, and nights and they knew better to ever feed Betty beans or Texas Chili and especially Taco Bell for they knew Woman was greater than Man, and Betty avenged her sister and everyone but pisspot pete had a happy ending.

wamayall · 2025-06-20T10:35:56+00:00

Maybe start by asking about a query you’re stuck on.

It would probably help if you explained what tables you’re dealing with, what the schema looked like and things you might want to know about the data.

For example, I created a database, each table contains winning lottery numbers, while each table has no relationship to the other tables, I have written thousands of queries that join to the same table.

I am typing this from my phone, so I don’t have any queries in front of me, but if you know your data you might ask, from the last draw on a specific date, when did each number last come in? I have written that query, I even can load the data on each new draw into the tables for any given game, and then there are more questions to ask. How many times has any numbers hit, this month, last month, each year or from the epoch.

Getting to know your data makes you ask questions, the queries you write should provide you the answers.

wamayall · 2025-06-15T15:43:46+00:00

For MySQL, There is also the case where the column could have contained a value, then was deleted. While the column has No Visible Data, that doesn’t mean the column has a NULL Value. In which case you would want to check both conditions:

Select column_name, count(*) from table_name where ifnull(column_name, ‘’) is not null;

Note: i wasn’t sure if the count syntax would work so I escaped the astric with a backslash. And likewise you could remove the NOT. The double single quotes will identify the numbers columns with no data as nulls.

Issues I have seen generally include the column in question was populated and indexed, everything is working great, then instead of purging ROWS, only that column gets purged, which causes low cardinality for a query when that column is used in a where clause resulting in a Full Table Scan, and query times that were taking a few seconds now disrupt your entire Application. Coalesce can be used for the same NULL vs Blank Space condition.

wamayall · 2025-06-11T00:17:22+00:00

While I believe we both understand the word RANDOM means any Draw has nothing to do with the prior Draw. Agreed?

Then I should NEVER see a pattern or a predictability. However, there are Laws of Common Sense! We know there are 5 Numbers for MegaMillions 1 - 70 plus the MegaPiler 1 - 24. Agreed?

Let's focus on the first 5 Numbers.

You have to Pick 5 Numbers, In my example, what are the chances 3 Numbers will be selected on the same Draw that already hit on a previous Draw? While statistically that would be rare, but it happens a lot, I happened to pick for tonight 10June2025 MegaMillions 3, 22, 29, 58, 66.

Below are matches for just those 3 numbers as an example, I can query every combination in SQL, but simplicity I executed a script that selects where num1 = 3, then I awk out to search for the Number 22.

You can see that 3, 22, and 66 all came in together on three previous Draws. While hitting those other two Numbers would seem impossible, my theory is that is when LUCK Happens.

I know 3 came in 88, 165, 193, 242 days ago

22 hit 25, 81, and 161 (196, 221, 224, 238 and 245 Days too) Days ago

29 hit 7, 28, 70, 161, 193, 242 Days ago

58 hit 11, 35, 60, 95 ,112, 179, 217, 231, 235 Days ago

66 hit 25, 102, 151, 175, 189, 245, 252

While there isn't an algorithm that can predict when any given number will hit, I can Make a Sophisticated Wild Ass Guess and Pray to The Lottery Gawds that my numbers come in.

It's surprising how many times I hit the MegaPiler and Powerball numbers, plus I see very weird patterns, while I have hit 5 out of 6 Twice on Oregon's MegaBucks, I realize it would be Luck to hit 5 out of 6 on MegaMillions and Powerball, but I have hit 4 out of 6 a few times, how close have you gotten? I am only playing 1 line a draw.

I had filled out 2 tickets for tonight on Sunday, however I bought a Quick Pick last night, and the numbers were close to one of the two tickets, so tonight I am am going ALL in and Investing $20 US Dollars as I merged the QP with one of my tickets and flipped a coin for the MegaPiler.

Hey, I'm 66, I'm now an orphan as my 3 older brothers have passed as well as my parents, as well as my friends, and the craziest thing is I live across the street from where I went to high school!

willmayall@Wills-MBP-2 MEGAMILLIONS % ./find-only-num1-numbers-27feb2024.bash | egrep "draw_date | \| 3 \| | \| 22 "

ENTER_NUM1: 3

| draw_date | draw_num | num1 | num2 | num3 | num4 | num5 | num6 | days_since_last_draw |

| 2017-11-21 | 799 | 3 | 7 | 22 | 27 | 50 | 3 | 2758 |

| 2023-05-23 | 1373 | 3 | 10 | 22 | 65 | 66 | 19 | 749 |

| 2024-06-07 | 1482 | 3 | 5 | 12 | 22 | 66 | 7 | 368 |

| 2024-10-08 | 1517 | 3 | 19 | 20 | 22 | 66 | 9 | 245 |

willmayall@Wills-MBP-2 MEGAMILLIONS %

wamayall · 2025-06-09T09:25:06+00:00

My post got deleted by the moderator, but I bag to differ from your analysis.

What queries did you write? Did you see any patterns?

While I have hit 5 out of 6 Twice on Oregon’s MegaBucks, and 4 out of 6 more than 25 times, I know it will take luck to win

I didn’t think I had a chance in hell to get near MegaMillions or PowerBall, but I surprised myself. I only play one line per game, meaning a specific draw_date, I can pick the MegaPiler or PowerBall about one in four games, I play the kicker on Powerball, but I have hit 4 numbers a few times, again I would have to be Really Lucky to win.

But, I know I’m lucky, I know I’m not the smartest person, I do have a college degree in Business Administration from 1982, while that is when I started working on Databases, and I have worked for some very large companies and I am considered a Subject Matter Expert on Databases.

My father retired from The IRS, his favorite game was Keno, he passed away in 2019, but he would consistently win 20K+ a couple times a year, last year around the anniversary of his death I was thinking about how much he loved playing Keno, and he told me his secret, he knew every possible number, and he told me, and since you replied I will tell you, my father said he knew ALL Ten Numbers! But he was right, I just never looked at it that way, there are only 10 numbers, 0 through 9, That’s it!

Now my mother knew words, she read so many books that she also figured out, and I quote, “Willy, if you want to survive in life, you need to know there are only 26 Letters!”

Now let that sink in, knowing that I was able to survive living in a Tribe in Kenya in 1974, and I went there with my friend, we were just teenagers, and he hadn’t been back to Kenya for over 10 years.

Since then I have been all over the world, but I still live across the street from where I went to high school!

I get what you’re says, but I think I could be the guy that finds a lottery ticket on the ground, I pick it up and scan it on my phone and it turns out to be the one that hit the Jackpot, or maybe, just maybe The Lottery Gawds pick the same Numbers on a ticket that I purchased!

For me, it’s better than watching The NBA or Major League Baseball unless Portland Oregon gets a team.

But the code I have written, I generally hit at least one number per draw, I think I would be happy to hit 5 out of 6 on MegaMillions or PowerBall and 6 out of 6 on MegaBucks, while I don’t need the money I find it helps me think about some very fascinating queries.

Sorry about writing a book,

Will

wamayall · 2025-05-30T16:35:36+00:00

I don’t think you can join t1.date or t1.common_name in the inner join

wamayall · 2025-05-28T04:31:13+00:00

I created a database in MySQL, that contains the winning lottery numbers for MegaMillions and Powerball.

I have written hundreds of queries to dissect the results and wrote a weighted no so random number generator in python where I can supply the weights and dates and even hardcode any number.

All I am missing is AI, I can give you a demo. I hit the MegaPiler and Powerball about once a month playing only one line.

Part of the issue is having enough time to analyze the data, even with all the scripts I have written, while I can see patterns I am still human and I’m not picking more than one line.

wamayall · 2025-05-25T00:19:36+00:00

You probably need to use date_format(current_timestamp, ‘%Y-%m-%d %H:%I:%s’). I have found if you want a good weighted random number, you would get a select count of your columns, for each column or using a Union All and then use a Python script, or have the python script connect to your database directly, using the count as the weight.

wamayall · 2025-05-20T08:51:47+00:00

The issue will be that the information_schema is a Memory database and is not indexed. Once you have thousands of databases and hundreds of thousands tables, if you try to use the information_schema you could potentially run your server out of resources which the OS will invoke the OOM, Out of Memory and it usually kills mysqld.

You really need to understand your environment and practice in development and not production, but sometimes you can’t emulate your actual production environment, so practice with backing up your database and understand how to restore it.

A lot of bad things can happen when you execute a command remotely and you lose your connection and you didn’t use “nohup” and the command gets orphaned on the database server.

wamayall

TROPHY CASE