The combination of max_allowed_packet variable and replication in MySQL is a common source of headaches. In a nutshell, max_allowed_packet is the maximum size of a MySQL network protocol packet that the server can create or read. It has a default value of 1MB (<= 5.6.5) or 4MB (>= 5.6.6) and a maximum size of 1GB. This adds some constraints in our replication environment:The master server shouldn’t write events to the binary log larger than max_allowed_packetAll the slaves in the replication…2014-05-14 04:00:59 by Miguel Angel Nieto
Last year we published our very popular post 30 Free Icon Font Sets, and today we are back with another 20 fantastic free sets for you. Icon fonts do have their pitfalls and there are... The post 20 More Sets of Free Icon Fonts appeared first on Speckyboy Design Magazine.2014-05-14 07:10:43
We just released, as an open source release, our new percona-agent (https://github.com/percona/percona-agent), the agent to work with Percona Cloud Tools. This agent is written in Go.I will give a webinar titled “Monitoring All MySQL Metrics with Percona Cloud Tools” on June 25 that will cover the new features in percona-agent and Percona Cloud Tools, where I will also explain how it works. You are welcome to register now and join me.There will be more posts about percona-agent, but…2014-05-14 12:00:44 by MySQL Performance Blog
PHP Tutorials for beginners2014-04-28 10:54:00
It is that time of the week again, a chance for you to sit back and enjoy some of our favorite web and mobile designs from this past week. You may also like to browse... The post Weekly Web & Mobile Creativity n.63 appeared first on Speckyboy Design Magazine.2014-05-04 09:48:03
Making stuff good is rewarding, making stuff great is intoxicating. It’s like there’s a direct line from perfection and excellence to the dopamine release. And the reverse is true as well. When you make crappy stuff, you feel crappy. No one likes to work in a broken shop on a broken stool. So it’s hard to fault people from being attracted to sayings like “Quality is Free”. It validates the good feelings that flow from making stuff perfect, and it makes it seem like…2014-05-14 08:41:00
I got this idea from a Valerii Kravchuk’s MySQL bug report: http://bugs.mysql.com/bug.php?id=71978 In theory, I completely agree that MySQL and forks should not allow us to set a default storage engine which cannot be used to create a table. You can see the same with MariaDB’s SEQUENCE. The MySQL & forks philosophy seems to be: ignore your mistakes, so you can repeat them forever. Which can turn a mistype into a major data loss. Unless you only use InnoDB and your magic powers tell…2014-05-14 07:11:35 by Federico Razzoli
In InnoDB bugs found during research on InnoDB data storage I mentioned MySQL Bug #67963 which was then titled “InnoDB wastes 62 out of every 16384 pages”. I said: InnoDB needs to occasionally allocate some internal bookkeeping pages; two for every 256 MiB of data. In order to do so, it allocates an extent (64 pages), allocates the two pages it needed, and then adds the remainder of the extent (62 free pages) to a list of extents to be used for single page allocations called FREE_FRAG.…2014-05-14 22:22:50 by Jeremy Cole
Improving security has been a high priority for MySQL 5.7. To give you an idea of some of the changes to date, I recommend reading Todd Farmer's blog: Redefining --ssl option, Password expiration policy, AES256 encryption. In MySQL 5.7, we are also proposing to remove the 'old' format for saving passwords. To provide some historical context: The old password format is a 16-byte hash and considered to be cryptographically weak. Code appears online (I won't link to it) which allows the hash to be…2014-05-14 11:00:12 by Morgan Tocker
Benchmarking lets you test how a system responds when it is given work to do, and removes the guesswork from your performance tuning efforts. The workloads you use when benchmarking are very different from real life deployments, which can be extremely variable. If you remember this, benchmarking is extremely useful, enabling you to measure current performance and determine the performance impact of any changes. Such changes could be the addition of new hardware or opening up your application to…2014-04-28 03:20:08 by Oracle MySQL Group
We have developed links to a range of existing feeds because we found getting up-to-date and relevant news on PHP and Web Development fairly fragmented.
We use an algorithm based around likes and tweets over time to try and rank popular and most recent articles first.
This should keep the news fresh and always changing. We would love to get your feedback on improvements or additions, just let us know here: