Showing entries 1 to 10 of 21965
10 Older Entries »
Displaying posts with tag: MySQL (reset)
How to get MySQL Primary Keys in one minute

This blog post talks about one of the important MySQL configuration, sql_generate_invisible_primary_key, available in MySQL 8.0.30. This will save you from performance bottlenecks due to tables without Primary Key. If…

The post How to get MySQL Primary Keys in one minute first appeared on Change Is Inevitable.

OpenLampTech Newsletter Repost – Developer Interview With Phil Kurth

Freelance web developer Phil Kurth shares a fantastic developer interview with the OpenLampTech newsletter readers.

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Phil Kurth works with a wide range of clients and builds WordPress plugin extensions for the ever-popular Advanced Custom Fields plugin.

Phil has a lot of knowledge, insight, and experience in the web development industry so I’m very excited he agreed to share this information (and more) with the OpenLampTech newsletter readers.

And now without any further ado, on to the interview.

[Read more]
MySQL at DOAG 2023 – recap

Last week, from November 21 to 24, the DOAG Conference took place in Nuremberg, Germany.

The MySQL Team was present at the Oracle booth. I attended the conference Thursday and Friday.

There were 20 sessions tagged “MySQL” and one full day workshop dedicated to students. I delivered the first part of the workshop dedicated to MySQL for Developers, DBAs and Ops. My colleague Carsten who attended the full week, delivered the second part of the workshop dedicated to the MySQL offer in OCI: MySQL HeatWave and LakeHouse.

The first day was a special “theme” day about Open Source Databases and other topics. Colin Charles talked about MySQL Security, Raphael Salguero presented the differences between Oracle Database, PostgreSQL and MySQL.

There were also presentations about MySQL Clustering and HA from Matthias Jung and future …

[Read more]
Newsletter Repost – OpenLampTech issue #106

MySQL Invisible Columns | Lightweight Linux distros | 10 PHP libraries for 2023 | New WooCommerce install default blocks. OpenLampTech is a media and content source for PHP, MySQL, and the LAMP stack.

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Thank you for reading OpenLampTech. If you are not yet subscribed, be sure and grab a free subscription today.

Thank you for reading this post. Please share it with someone else who would enjoy it as well.

[Read more]
Thoughts on the October 2023 MySQL Releases

A few days ago, Oracle released three new MySQL GA versions: 8.2.0, 8.0.35 and 5.7.44.  I skimmed the release notes (8.2.0, 8.0.35 and 5.7.44), and I am not impressed.  I guess that I would be even less impressed / more disappointed if I had checked in greater detail, and if I had reviewed the 8.1.0, 8.0.34 and 5.7.43 release notes.  The subject of my disappointment is Oracle not fixing bugs in

Newsletter Repost: Developer Interview With Marian Pop – OpenLampTech

PHP developer and Laravel content creator Marian Pop shares a fantastic developer interview with the OpenLampTech newsletter readers.

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Welcome to this OpenLampTech text-based developer interview.

PHP developer Marian Pop is very active in the Laravel community.

Marian writes a daily blog, and a newsletter, and has a podcast – all covering Laravel.

Subscribe to OpenLampTech to read this interview and more.

[Read more]
Newsletter Repost – OpenLampTech issue #105

SQL Upserts | WordPress nonces | WordPress CLI | Microservices with PHP | Laravel vs Symfony. OpenLampTech is a media and content source for PHP, MySQL, and the LAMP stack.

Custom WooCommerce and Shopify Solutions

Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!

Learn More

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Thanks for your interest in the OpenLampTech newsletter. …

[Read more]
How to Connect to SQL Server in Delphi with Devart SDAC

We will walk you through the process of connecting to SQL Server using Devart SDAC, including installation and examples of how to interact with the components.

The post How to Connect to SQL Server in Delphi with Devart SDAC appeared first on Devart Blog.

Developer Interview With Przemysław Hernik – OpenLampTech Repost

Long-time WordPress and Vue.js software engineer Przemysław Hernik shares a fantastic developer interview with the OpenLampTech readers.

Custom WooCommerce and Shopify Solutions

Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!

Learn More

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Be sure you’re subscribed to the OpenLampTech newsletter so you …

[Read more]
MySQL 8.2 Read/Write Splitting: a what cost ?

We’ve seen in previous articles what Transparent Read/Write Splitting is with MySQL 8.2 and how to use it with MySQL Connector/Python.

I love this new feature, but I was wondering if it was really worth it.

Will the application benefit from offloading reads to another node, and won’t using the MySQL Router and parsing the request slow down connections?

These are the kinds of questions I’d like to cover and answer in this article.

The environment

To perform the test, I use the following environment:

  • Linux Kernel 5.15.0 – aarch64
  • MySQL Community Server 8.2.0
  • MySQL Router 8.2.0
  • sysbench 1.1.0 using LuaJIT 2.1.0-beta3
[Read more]
Showing entries 1 to 10 of 21965
10 Older Entries »