Skip to content
Juzhax Technology
  • Linux
  • Mac
  • WordPress
  • Blog
  • PHP
  • Joke
  • CSS
  • HTML
  • MySQL
Search this site
  1. Home
  2. › database – Page 2 – Juzhax Technology

Tag Archives: database

How to Handle Old Slugs Without Breaking Links

Posted byjuzhax·Published 2026-08-13·3 minutes read

A safe URL migration pattern: check the current slug first, use redirect history only after a miss, and return a small 404 response for unknown URLs.

How to Prevent MySQL Placeholder Errors in Large Batch Upserts

Posted byjuzhax·Published 2026-07-31·2 minutes read

Large multi-row upserts can exceed MySQL’s prepared-statement placeholder limit. Split the work into smaller chunks and keep the chunks inside one transaction.

Few Steps to install Redis in Centos 7

Posted byjuzhax·Published 2020-05-08·1 minute read

A note to install Redis to new machine that running CentOS 7 Basic settings for Redis

Create Database and User in MySQL or MariaDB in shell

Posted byjuzhax·Published 2020-04-27·1 minute read

I write this because just a note or cheatsheet for me to copy and paste from here to make my life easier. Every time when migrate website from one server to one server, I need to recreate the user and database before insert back to the new host.

Optimize MySQL order by RAND()

Posted byjuzhax·Published 2015-09-12·Last updated 2015-09-13·1 minute read

It is not recommended to use ORDER BY RAND() only, it will slow for query large database like over 50,000 rows. The easiest way to optimize existing code, just add RAND()< (SELECT ((1/COUNT(*))*10) FROM Table_name) after the WHERE before the ORDER, this sub query will speed up the select random from the table. Using this Continue reading “Optimize MySQL order by RAND()”

Posts pagination

‹Previous Page 1 Page 2Page 2 of 2

Latest Posts

  • O
    Ollama Using Too Much Memory? Check Context and CPU Offloading in 5 Steps
  • E
    Extract Local JSON with Ollama, JavaScript and Zod in 5 Steps
  • B
    Bitnami in emergency mode: “Cannot open access to console, the root account is locked”
  • H
    Hosting a Minecraft Java server on Linux after CentOS 7
  • M
    MongoDB Transparent Huge Pages warning: when to enable or disable THP

Interesting Posts

  • H
    How to Transfer a Split APK Between Android Test Devices
  • W
    Why an API Gateway Can Return 502 While the Web Portal Works
  • U
    Using curl to test speed test of url
  • W
    Why npm Works Over SSH but Fails in Automated Deployments

Archives

  • November 2026 (16)
  • October 2026 (26)
  • September 2026 (2)
  • August 2026 (16)
  • July 2026 (8)
  • February 2026 (1)
  • April 2025 (1)
  • March 2025 (3)
  • November 2024 (3)
  • September 2024 (1)
  • August 2024 (1)
  • July 2024 (1)
  • June 2024 (1)
  • January 2024 (1)
  • October 2023 (3)
  • July 2023 (1)
  • April 2023 (3)
  • July 2022 (2)
  • June 2022 (1)
  • May 2022 (3)
  • April 2022 (5)
  • October 2021 (1)
  • August 2021 (1)
  • March 2021 (2)
  • February 2021 (2)
  • November 2020 (4)
  • August 2020 (1)
  • May 2020 (10)
  • April 2020 (19)
  • February 2020 (2)
  • June 2019 (1)
  • May 2019 (1)
  • April 2019 (3)
  • March 2019 (2)
  • February 2019 (5)
  • April 2017 (1)
  • July 2016 (2)
  • May 2016 (4)
  • April 2016 (2)
  • March 2016 (4)
  • October 2015 (2)
  • September 2015 (2)
  • July 2015 (3)
  • June 2015 (2)
  • October 2014 (2)
  • September 2014 (4)
  • August 2014 (7)
  • June 2014 (1)
  • April 2014 (4)
  • March 2014 (1)
  • February 2014 (1)
  • January 2014 (3)
  • December 2013 (6)
  • November 2013 (9)
  • October 2013 (17)
  • February 2013 (1)

Engineering Philosophy

Thoughtfully engineered software, built to scale, maintained with care, and designed to be useful.

More Work from Us

  • Top Hashtags
  • Top Radio
  • Justin.my

Newsletter

Get the latest posts and updates straight to your inbox.

Connect With Me

  • Buy Me a Coffee
  • LinkedIn
  • X
  • Threads
  • Github
  • Facebook
  • Twitter
  • Youtube

Copyright © 2026 Juzhax Technology | Powered by Juzhax Technology

  • About Us
  • Privacy Policy
  • Disclaimer