Reset Forgotten MySQL Root Password
Have you ever forgotten the root password on one of your MySQL servers? No? Well maybe I?m not as perfect as you. This is a quick h00tow (how to) reset your MySQL root password. It does require root access on your server.
A public draft version of the all-new DRBD Users’ Guide has just been released. Feedback is more than welcome.
You may want to read the announcement as well.
One of my favorite features of the Oracle database is support for
Materialized Views or 'snapshots' as they used to be called. I've
often lamented that MySQL lacks this feature, but everybody I
talked to seemed to feel that the feature was just "too big",
"too difficult" or "frankly impossible" to implement. Well,
frankly, nothing motivates me more than telling me that something
is impossible.
*edit* - these restrictions do not apply to my system, this is
just what I found "in the wild" when I started
So I started doing some research and came across some rudimentary
stored procedure implementations for SELECT-PROJECT (single base
table, no joins) views. Their first major drawback is that they
require the user to hand-craft a stored procedure, which is not
only tedious, but it makes maintenance a nightmare. Second they
don't support joins, so their usefulness is very limited.
Nonetheless, it gave me a place to start. …
Maximizing Sysbench OLTP performance for MySQL
Sysbench is a popular open source benchmark used to measure performance of various parts of the operating systems and (one) application (database). Since we are talking about MySQL, I will concentrate on the database part of the test.
The oltp test in the sysbench benchmark creates a single table and runs a set of queries against it. Each row in the table is around 250 bytes and by default it creates 1000 rows. For our experiment we used 10 million rows. Allan has blogged about the details regarding the experiments; I will present an alternate view to those experiments.
The trick to getting good numbers with Sysbench and MySQL is very simple
Maximizing Sysbench OLTP performance for MySQL
Sysbench is a popular open source benchmark used to measure performance of various parts of the operating systems and (one) application (database). Since we are talking about MySQL, I will concentrate on the database part of the test.
The oltp test in the sysbench benchmark creates a single table and runs a set of queries against it. Each row in the table is around 250 bytes and by default it creates 1000 rows. For our experiment we used 10 million rows. Allan has blogged about the details regarding the experiments; I will present an alternate view to those experiments.
The trick to getting good numbers with Sysbench and MySQL is very simple
In this blog I'm sharing the results of a series of tests designed to explore the impact of various MySQL and, in particular, InnoDB tunables. Performance engineers from Sun have previously blogged on this subject - the main difference in this case is that these latest tests were based on Linux rather than Solaris.
It's worth noting that MySQL throughput doesn't scale linearly as you add large numbers of CPUs. This hasn't been a big issue to most users, since there are ways of deploying MySQL successfully on systems with only modest CPU counts. Technologies that are readily available and widely deployed include replication, which allows horizontal scale-out using query slaves, and memcached, which is very effective at reducing the load on a MySQL server. That said, scalability is likely to become more important as people increasingly deploy systems with quad-core processors, with the result that even two processor systems will need to …
[Read more]In this blog I'm sharing the results of a series of tests designed to explore the impact of various MySQL and, in particular, InnoDB tunables. Performance engineers from Sun have previously blogged on this subject - the main difference in this case is that these latest tests were based on Linux rather than Solaris.
It's worth noting that MySQL throughput doesn't scale linearly as you add large numbers of CPUs. This hasn't been a big issue to most users, since there are ways of deploying MySQL successfully on systems with only modest CPU counts. Technologies that are readily available and widely deployed include replication, which allows horizontal scale-out using query slaves, and memcached, which is very effective at reducing the load on a MySQL server. That said, scalability is likely to become more important as people increasingly deploy systems with quad-core processors, with the result that even two processor systems will need to …
[Read more]While I invited Kris Buytaert to present at the Drupal developer room at FOSDEM, I couldn't make it to his presentation as it was scheduled for the last presentation of the day. Oops! Fortunately, Luc Van Braekel recorded almost all Drupal presentations at FOSDEM so I'm sharing the video of Kris's presentation to make up for it. It's is well worth a look, and no, we are not family.
SANTA CLARA, CALIF. — Sun Microsystems, Inc. (NASDAQ: JAVA) today announced it has completed the acquisition of MySQL AB, developer of the world's most popular open source database, for approximately $1 billion in total consideration. Sun also unveiled the immediate availability of MySQL's complete portfolio of products and enterprise services backed by its 17,000-strong global sales and services organization and its extensive international network of authorized distribution channels. Sun now provides a single, secure choice for customers and developers seeking to put MySQL into deployment on a global basis. Users can get started today with free downloads at dev.mysql.com/downloads.