With PEP 470 now requiring files to be hosted on PyPI, you may have noticed that MySQL Connector/Python is now no longer available using the pip-tool.

The MySQL Engineering team at Oracle really would like to have the connector available through PyPI and have been talking with the Python Foundation towards that. We know users and developers of OpenStack, for example, have requested this as well as lots of other Python users.

For now we suggest to download the latest Connector/Python directly from the MySQL homepage:

• Download: http://dev.mysql.com/downloads/connector/python/
• Using MySQL repository (APT/YUM/..): http://dev.mysql.com/downloads/repo/

Going forward …

MVVM stands for Model, View and ViewModel pattern.
Application: Used in knockout.js library.
Role of each part:
Model - Handles the application's persisted data that is the data which the view page receives through an ajax request from the server(GET or POST). It can also be used to store the data which is passed to the page when the page is loaded for the first time with some data content, to be used later on client(browser) side.
View - It simply represents the html content. Each View is associated with a ViewModel. View changes according to changes in ViewModel(It's next in list).
ViewModel - It is basically a model for the view. It is a code representation of the data and the supported …

It has been seven years since the last time I blogged about generated columns, and a lot has happened -- now both MariaDB and MySQL support them. So it's time to look again, see how well they're doing, and compare to the SQL standard's Optional feature T175 Generated columns.

This is not an introductory description or an explanation why you'd want to use generated columns rather than (say) triggers and views. For that, I'd recommend the relevant manuals or the blog posts by Alexander Rubin and Anders Karlsson.

The Generation Clause

Standard …

In PHP you are work on php and you want to need display count number of files in specific folder then you do glob through you count number of file are there in specified folder now in following example you can see varwwwtest in this folder count how many files are there in that folder gl

…

Thu, 2016-02-04 14:24mariadb

Vote MariaDB for Database of the Year! MariaDB is nominated for Database of the Year by LinuxQuestions.org. LQ for short is Linux user community that each year votes for the best database of the year.

You can, of course, vote for MariaDB!

The site requires a simple registration - which may take a few moments, but it is well worth your time!

1. Register on linuxquestions.org
2. Activate account by email
3. Post a message to get the right to vote, e.g. write on the vote thread
4. After a delay, …

Redmine is an open source project management and issue tracking tool based on the Ruby on Rails Framework. This tutorial covers the Redmine 3 installation with Nginx as the web server and MySQL as the database on Ubuntu 15.10 (64 Bit) operating system.

Last weekend I had the pleasure to attend the excellent FOSDEM conference in Brussels, Belgium. I indulged aplenty in pancakes with Nutella, a Belgian beer or two, and some truly interesting presentations. MySQL had a lecture hall for itself the whole weekend, and the booth conveniently located outside.…

If you are running ‘OPTIMIZE TABLE’ or altering ‘TABLESPACE’ just be careful not to kill MySQL service while running these commands
Here is a test case:
We have a table:

CREATE TABLE `sbtest1` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`k` int(10) unsigned NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `k_1` (`k`)
) ENGINE=InnoDB AUTO_INCREMENT=2427738 DEFAULT CHARSET=latin1 COMPRESSION='lz4'

After a while we want to ‘OPTIMIZE’ this table:

mysql> optimize table sbtest1;
ERROR 2013 (HY000): Lost connection to MySQL server during query

Uups MySQL process was killed/crashed.

[root@ps-5 mysql]# ls -l dbtest/
total 1092792
-rw-r-----. 1 mysql mysql 65 фев 4 03:43 db.opt
-rw-r-----. 1 mysql mysql …

Thanks to everyone who participated in this week’s live webinar on Managing MySQL Replication for High Availability led by our colleague Krzysztof Książek, Senior Support Engineer at Severalnines. The webinar included theory discussions bundled with live demo demonstrations on all of the key elements that were discussed, which made for a nicely interactive webinar to watch.

If you missed the session and/or would like to watch the replay and read through the slides in your own time, they are now available online for sign up and viewing.

Whether you’re looking into deploying a MySQL Replication topology or maintaining one, you’ll find great insight here about topology changes, managing …