MySql Query cache on Windows

Slow server? Check if your query cache is set by querying:

mysql> show variables like 'have_query_cache';
 +------------------+-------+
 | Variable_name | Value |
 +------------------+-------+
 | have_query_cache | NO  |
 +------------------+-------+

How to enable this?
Find your my.ini … in my case in: C:\ProgramData\MySQL\MySQL Server 8.0
Add under [mysqld]

query_cache_size = 268435456
query_cache_type=1
query_cache_limit=1048576

More info here: https://dev.mysql.com/doc/refman/5.6/en/query-cache-configuration.html
And as you will notice this is 5.6 documentation. In my case this does not work, because I am using MySQL8.0 …. The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0.

The search to speed up my server continues….

Thunderbird outlook hotmail messages appear twice in SENT-folder

How can I keep sent messages from appearing twice in the ” sent ” folder. I am using outlook.com and hotmail.com e-mail addresses with IMAP.
Each time I send a message with Thunderbird the sent message is put in the “sent” folder two times.
What setting needs to be changed to in order to have only one copy of the message put in the “sent” folder?

The answer:
Outlook/Hotmail and gmail automatically put copies of sent mail in the imap sent folder. If you have settings to also keep a copy then two are being put in the sent folder.

right click on imap mail account in Folder Pane
select 'Settings'
select 'Copies & Folders'
in 'When sending messages, automatically:'
uncheck : 'Place a copy in:'
click OK

Solution was found here.
Have a nice day!

Windows 10 Intel ATOM and GMA 500 drivers

TO ANYONE USING WIN10 WITH OLD INTEL ATOM PROCESSORS/ INTEL GRAPHICS MEDIA ACCELERATOR 500
After hours of trying different graphic drivers for an old Acer Aspire One 751h (Atom Z520 1.33/2gb/250gb), where the last version provided on Acer support site (8.14.10.2003) is bugged, and newer ones like 8.14.10.2230 that claims to support Z500 processor Series but isn’t even recognized on win10 as a valid driver to Intel GMA500 adapter, I found a driver version that works without bugs (so far): 5.0.0.2030. Thank you: reddit.

So, to anyone trying to install this specific graphic card driver, don’t waste time trying to install the ‘latest’ driver/software, just go with the latest driver release FOR the graphic card. You can find a copy here.
When searching Intel you get nothing, thanks!
When installing, you will have to set the file properties of setup.exe to compatibility mode first so it thinks it’s running on Windows 7.

Honestly, Windows 10 works on an old laptop like this, but is slow as $h*7! I’m going back to Windows 7 on this one, to keep the machine useable.

Disk clone in 2020

Imagine a laptop with a doubtful drive, slow response, long waittimes, just something is wrong. You have another spare drive, plus a USB encasing to connect this other drive to your laptop. So all you want to do is swap them out and copy the complete Windows 10 OS from the original to the spare drive. How do you clone this? And since this is a personal thing, some free software would be best.

Continue reading Disk clone in 2020

PHP variables and strings

Sometimes you have to be reminded of the basics:

“How to use a dollar-sign $ in a string?”
In single quotes a dollar sign isn’t parsed as anything. Nothing is auto parsed in single quotes in php. If you use double quotes they are automatically parsed:

echo "$var"; // this will print the value of $var;
echo '$var'; // this will print $var;
echo "\$var";// this escapes the dollar sign so it will print $var;

ASP MDB x64 issue

ADODB.Connection error '800a0e7a'
Kan de voorziening niet vinden. Mogelijk is deze niet juist geïnstalleerd.
/someaspfile.asp, line 123

Okay; moved to a new server… Windows 2016 Standard, 64 bit
So now what? Well, you could read here.

ASP Error: ADODB.Connection error ‘800a0e7a’ Provider cannot be found. It may not be properly installed.
Without naming a source the answer is: “Never mind.  I found the answer on another forum.  “Enable 32-bit applications” needs to be enabled in the connection pool for the website, within IIS Manager 7.”

But how? Well, just:

  • Start Internet Information Services (IIS) Manager
  • Go to your application pools
  • Click on “DefaultAppPool”
  • Click on “Advanced Settings”
  • In General, set “Enable 32-bit Applications” to true

That’s all folks!
Contact My Brain if you need any help!

Disable These Files Might Be Harmful to Your Computer Warning

source: https://winaero.com/blog/disable-these-files-might-be-harmful-to-your-computer-warning/

Disable These Files Might Be Harmful to Your Computer Warning in Windows 10

If you connect a network share, i.e. mount a network drive by IP address of the server, Windows 10 displays a warning message These Files Might Be Harmful to Your Computer when you are opening files stored there. Here’s how to get rid of it.

Continue reading Disable These Files Might Be Harmful to Your Computer Warning