Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Kill all mysql threads that have 300 or more seconds of time:
mysqladmin -uroot processlist | grep -v +| awk –field-separator=’|’ {’ if ($7 > 500) print ” mysqladmin -uroot kill ” $2 ‘}
One quick note, need to check to see what status the connection is in, sleeping if you want to kill idle connections, or something else.
mysqladmin -uroot processlist | grep -v +| grep Sleep | awk –field-separator=’|’ {’ if ($7 > 500) print ” mysqladmin -uroot kill ” $2 ‘}
I spoke at the MySQL Meetup in Montreal on Tuesday. It was our
last regular meetup now that I'm going to be a trainer. Slides
are online here. Me trying to explain how memory usage works
was probably a bit ambitious - feel free to comment if I've
simplified something. My backup section also only gave examples
for mysqldump.
Live in Montreal, and want to organize the meetings? Let me know.
While I'm doing most of my blogging these days over at InfoWorld, once in a while I'll post something over here that is more about MySQL. Some folks likely saw our announcement with Virgin Mobile selecting MySQL Enterprise. This is one in a long series of wins in the telecommunications industry in the last year. It's been a rapidly growing part of our business and one that I'm …
[Read more]
I am about to embark for my longest trip ever.
I will board a plane on Saturday in my hometown in Sardinia,
Italy, heading to Munich. A comfortable two hours flight, to be
ended with a business meeting and a traditional Munich dinner,
both provided by Kaj Arnö.
The easy part of the trip ends here. From Munich, I will go to
Orlando, USA, to the Company Meeting.
After the meeting, a short stopover in Los Angeles, and then the
loooong jump to Sydney, which I will be wisiting for the first
time. And another first time will be in Melbourne, a few days
later, where I will attend the Linux Conf Au, and also present a session
about MySQL Proxy during the MySQL MiniConf.
…
Coverity Inc, a long time expert in code analysis, has announced their work with the US government Department of Homeland Security to indentify security and quality issues in 11 popular open source projects: Amanda, NTP, OpenPAM, OpenVPN, Overdose, Perl, PHP, Postfix, Python, Samba, and TCL. Coverity has been doing a mix of static and dynamic code analysis in the open source world for quite some time and I've always been impressed with what they've found. In particular, they did an extensive evaluation of the LAMP stack and MySQL a few years back which helped us identify some security risks which... READ MORE
This document offers some tips on how to migrate your Drupal website from a database running on the same server as your web server, to a physically separate database server.
As days goes by, more and more multi-core systems are popping up everywhere. Infact, with the advent of the new 4-socket quad-core Sun Fire X4450 , 16-core systems are soon becoming common out there.
However,personally, I think these systems are still underutilized from their true potentials. Of course virtualization is a way of increasing the utilization but that is like working around the symptoms and not fixing the real problems. Software Applications fundamentally has lagged behind the microprocessor innovations. Operating Systems too have lagged behind too. Solaris, however advanced opertating system has still lot to achieve in this area. For example, yes the kernel is multi-threaded, yes it can scale well easily to 100s of cores but that scaling is generally achieved by creating copies of the process (or multiple connections or multiple threads however you look at it) at the APPLICATION level. One area however …
[Read more]Virgin Mobile, a leading Mobile Virtual Network Operator, has implemented a MySQL Enterprise Platinum subscription to manage its data using the world's most popular open source database.
I posted this at the new blog but it never hit Planet MySQL, so we’ll see if posting it here does the trick.
Learn all about it at http://www.mikehillyer.com/mysql/speaking-at-the-2008-mysql-conference-expo/
I was blog-tagged by Doug Burns - his post is here: I *hate* chain letters …. I hate them too, I literally never pass them on no matter what vile fate that condemns me to (so far nothing has happened so maybe those are idle threats). But this one includes a chance to talk about myself [...]
