Category: Mysql

How To Protect your WordPress Site from the Genericons Example.html XSS

By admin | March 10, 2017| No Comments

How To Protect your WordPress Site

Introduction On May 6th, 2015, a critical WordPress bug was disclosed that potentially affects millions of users. The vulnerability, which actually stems from components that make use of the “Genericons” icon font package, can leave your site open to cross-site scripting (XSS) attacks. In this article, we’ll explain the impact of the vulnerability, how to…
Read more

Introduction to mysql cursor

By admin | January 17, 2017| No Comments

mysql cursor

To handle a result set inside a stored procedure, you use a cursor. MySQL cursor allows you to iterate a set of rows returned by a query and process each row accordingly. MySQL cursor is read-only, non-scrollable and asensitive. Read only: you cannot update data in the underlying table through the cursor. Non-scrollable: you can only…
Read more

How To Install MySQL on Ubuntu 14.04

By admin | July 13, 2016| No Comments

mysql installation in ubuntu

Introduction MySQL is an open-source database management system, commonly installed as part of the popular LAMP(Linux, Apache, MySQL, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to manage its data. The short version of the installation is simple: update your package index, install the mysql-serverpackage, and then run the included security…
Read more

MySQL Table Locking

By admin | June 14, 2016| No Comments

mysql table lock

In this tutorial, you will learn how to use MySQL locking for cooperating table access between sessions. MySQL allows a client session to acquire a table lock explicitly for preventing other sessions from accessing the table during a specific period. A client session can acquire or release table locks only for itself. It cannot acquire…
Read more

Why MySQL could be slow with large tables ?

By admin | June 3, 2016| No Comments

If you’ve been reading enough database related forums, mailing lists or blogs you probably heard complains about MySQL being unable to handle more than 1.000.000 (or select any other number) rows by some of the users. On other hand it is well known with customers like Google, Yahoo, LiveJournal,Technocarati MySQL has installations with many billions…
Read more

MySQL performance tuning settings

By admin | May 8, 2016| 1 Comment

In this blog we’re going to discuss the top ten MySQL performance tuning settings that you can implement after an installation. When we are hired for a MySQL performance audit, we are expected to review the MySQL configuration and to suggest improvements. Many people are surprised because in most cases, we only suggest changing a…
Read more

Show Buttons
Hide Buttons