Mysql 5.5 upgrade SLOW queries [SOLVED]

Have you upgraded to MYSQL 5.5 and experienced slow queries?

I have the answer for you. Turns out the upgrade completely erases all your settings in the MY.CNF file, which is in the /etc directory.

You have to manually edit that file and add all your old settings, hopefully from a previously backed up file.

You are welcome.

How to crack games / create trainers

Note: I didn't write this, it's a post from reddit
http://www.reddit.com/r/explainlikeimfive/comments/1sejpy/eli5_how_do_pirates_crack_games_without_access_to/

------------------------------

Ex software cracker/hacker here. There are two types of video game cracking.

1) Trainers - hacking the game to enable cheats, god-mode, multi-player cheats, etc

2) Cracks - hacking the source code to enable you to play the game off of your computer without the original source disk, license key, online authentication, etc.

Trainers

1 is fairly simple to understand. You load the game and scan your RAM (memory) using specialized software. Then you change a value in the game. Like picking up an ammo pack. So your character goes from 0 ammo to 100 ammo. Now you rescan memory and compare with your original scan. Next you manually test changing the individual memory locations that had changed since the first scan. You see what effect the changes you make manually have on the game. Lots of times, it can be easy to locate the right memory location. Once you find that location, you create a program to update that location - a trainer.

Cracks There is legitimate debugging software that allows you to see the code and instructions that are processed by your computer's CPU. The CPU's process simple instructions only in Assembly language - like increments, comparisons, and jumps. Programming languages uses the basic elements to build complex functions, but in the end they are made of these simple pieces. Sort how complex life and substances are only made of electrons, protons, and neutrons (maybe not the best analogy - but I'm rushing to dinner).

You run the program and set a break point. Let say I want to break a game so that it doesn't check for CD disk. I can listen for when the game accesses my CD drive and place a break there. I know the comparison is done before then. Then I place a break a few hundred lines before then and monitor the code, walking through it one step at a time. After years of doing this, you become very skilled at reading the code. Find the comparison and change the jump requirement. So something like: If "CD Disk exists" Jump to "start game"

Becomes If "CD Disk does not exist" Jump to "start game"

Of course the code doesn't say that. Instead it will say: cmp ecx, edx (compare two registers, basically variable storage) jz ###### ("jump if zero" or equal to a given address in the code)

You would change jz to jnz or "jump if not zero".

The final step would be to create a program - patch, to update the game's executable to modify the values that control the jump instruction.

Hopefully that is simple enough. Of course there are many new technologies to work around this and make it more complicated. Just like in the lock industry - lock makers build better locks, thieves come up with better ways to defeat them. It's a cycle. Software publishers and crackers play the same game.

Source: F(Ph)ormer Phrozen Crew member and multiplayer game trainer peddler.

PS: When I was a teen, I was long on time and short on cash. Now that has flipped and it's actually cheeper for me to buy my software rather than spending hours or days trying to crack it or find a working crack. I've also learned the value of supporting artists and businesses that you believe in.

Box office figures are always not true/exaggerated!

box office figures for films are not true

example: box office for films. these are literally always untrue/exaggerated, because it helps sell the film if ppl think it made a lot of money. if you look on wikipedia, it very often quotes a site called "box office mojo". what kind of a source is that? i can create a site for ten bux, call it "box office stats" and have it referenced by wikipedia as a source??

in reality, many films don't make much. many famous actors don't make a lot of money. they just pretend they do. i read an article about deadmaus saying that he's not even a millionaire and about robin williams making 75k to voice aladdin. because there is just as much benefit to robin williams' career in voicing aladdin than to disney having him voice it. he probably would've done it for free.

whoever is not smart enuf thinks that ppl in movie industry make a lot of money, trust me, they don't, and the industry, just like everywhere, constantly exaggerates things.