Tips

MySQL

MySQL Performance Tuning and Optimization Tips

At the system level, you’ll adjust hardware and software options to improve MySQL performance. 1. Balance the Four Main Hardware Resources Storage Take a moment to evaluate your storage. If you’re using traditional hard disk drives (HDD), you can upgrade to solid-state drives (SSD) for a performance improvement. Use a tool like iotop or sar from Read more…

By Chris, 3 yearsFebruary 19, 2023 ago

Javascript

Encoding data for POST requests

Right now, when you go to copilot.github.com you’re greeted with this example: This is bad and might result in security issues. Here’s where things go wrong: body: `text=${text}`. Unescaped text is added into a format with defined encoding. It’s similar to SQL/HTML injection, as something intended as a ‘value’ gets to interact with the format directly. Read more…

By Chris, 3 yearsFebruary 15, 2023 ago

MySQL

MySQL Performance Tuning and Optimization Tips

Javascript

Encoding data for POST requests