article thumbnail

Geek Reading - Week of June 5, 2013

DZone

Making Google’s CalDAV and CardDAV APIs available for everyone ( Google Developers Blog). Pandora launches new HTML5 site for TVs and gaming consoles, available now on PS3 and Xbox 360 ( The Next Web). Dew Drop – June 5, 2013 (#1,561) ( Alvin Ashcraft's Morning Dew). The Daily Six Pack: June 5, 2013 ( Dirk Strauss).

Java 244
article thumbnail

Auto-Increment Counter Persistence in MySQL 8: Comparing the Evolution From MySQL 5.7

Percona

MySQL 8’s solution MySQL 8 addresses the auto-increment counter loss issue in the InnoDB storage engine upon server restart. sec) service mysql restart mysql> select * from users; ERROR 2013 (HY000): Lost connection to MySQL server during query No connection. sec) Consequently, in MySQL 5.7, Trying to reconnect.

Servers 113
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

MariaDB vs MySQL: Key Differences and Use Cases

Percona

MariaDB retains compatibility with MySQL, offers support for different programming languages, including Python, PHP, Java, and Perl, and works with all major open source storage engines such as MyRocks, Aria, and InnoDB. Scalability and replication options that can improve performance and high availability.

article thumbnail

Finding Distinct Values Quickly

SQL Performance

I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. Test Environment.

Servers 86
article thumbnail

InnoDB Performance Optimization Basics

Percona

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Storage The type of storage and disk used for database servers can have a significant impact on performance and reliability. Typically a good value is 70%-80% of available memory.

article thumbnail

How Improving Website Performance Can Help Save The Planet

Smashing Magazine

In 2013, A List Apart published Sustainable Web Design by James Christie. An obvious metric here is CPU usage, but memory usage and other forms of data storage also play their part. Note : You also may want to investigate Google’s PageSpeed Module , available for both Apache and Nginx. These include data transfer (i.e.

article thumbnail

PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types in Enterprise

Scalegrid

The supported programming languages for PostgreSQL include.Net, C, C++, Delphi, Java, JavaScript (Node.js), Perl, PHP, Python and Tcl, but PostgreSQL can support many server-side procedural languages through its available extensions. We found that Java is the most popular programming language for PostgreSQL, being leveraged by 31.1%

Strategy 182