 |
Open Query blogAbout MySQL, Drizzle, MariaDB and more! |
See the OurDelta blog for details of this release. RHEL/CentOS packages also coming.
|
Filed under: Software and tools |
by arjen Social tagging: mariadb > mysql > Open Query > ourdelta > pbxt > xtradb
No Comments »
Many configs have thread_stack_size configured explicitly, but that can cause rather bad trouble:
if the stack inside a thread it’s too small, you can get segfault crashes (stack overflow, essentially). Particularly on 64-bit.
if the stack is too large, your system cannot handle as many connections since it all eats RAM.
Let mysqld sort it out, on startup [...]
|
Filed under: Uncategorized |
by arjen Social tagging: crash > mariadb > my.cnf > mysql > Open Query > segfault > thread_stack_size
2 Comments »
We got good responses to the “identify this query profile” question. Indeed it indicates an SQL injection attack. Obviously a code problem, but you must also think about “what can we do right now to stop this”. See the responses and my last note on it below the original post.
Got a new one for you!
You [...]
Filed under: Good practice / Bad practice |
by arjen Social tagging: master > mysql > open query > replication > slave > trivia
5 Comments »
You do SHOW PROCESSLIST, and you see one of your web apps issue the following query:
SELECT … WHERE … AND 1=2 UNION SELECT …
What does this tell you, and what do you do next?
Filed under: Good practice / Bad practice |
by arjen Social tagging: mysql
6 Comments »
I have been very busy here in Malaysia this week. On thursday, I was asked to do a MySQL University session on MMM. The preparation was very stressful. There was no good wifi to be found until literally a few hours before the session (Big thank you to Gurdip at APIIT for providing a space and [...]
|
Filed under: Conferences |
by walter Social tagging: conference > foss.my > malaysia > mmm > mysql > MySQL University
4 Comments »
The MySQL 5.0 and MySQL/MariaDB 5.1 source code is now also available through Launchpad. If you were waiting for a version for 5.1 and are ok with building the plugin from source, now you can!
The repo contains a subdir for examples, we’re hoping many people will contribute little snippets and scripts to import and use [...]
Filed under: GRAPH engine |
by arjen Social tagging: graph > mariadb > mysql > open query > OQGRAPH > rdf > tol > tolweb > tree > tree of life
1 Comment »
At this point we have a 32-bit and a 64-bit Linux binary tarball, should work on most Ubuntu and CentOS and the like (I tested a few). Possibly OSX coming. Not sure on Windows right now.
For further details and download links, see yesterday’s release post.
Filed under: GRAPH engine |
by arjen Social tagging: download > GRAPH engine > mysql > open query > OQGRAPH > source
No Comments »
It’s time to play! A special thanks particularly to Antony Curtis for the excellent smart and actually very speedy coding, and for just being a great guy to work with. If you would like to utilise his ace MySQL knowledge and coding skills, do talk to me!
Right now, we have a source tarball available for [...]
Filed under: GRAPH engine |
by arjen Social tagging: Antony Curtis > download > GRAPH engine > mysql > Open Query > OQGRAPH > source
No Comments »
This Thursday (October 22nd, 13:00 UTC), Walter Heck (of Open Query) will present Dual Master Setups With MMM. MMM (Multi-Master Replication Manager for MySQL) is a set of flexible scripts to perform monitoring/failover and management of MySQL master-master replication configurations (with only one node writable at any time). Session slides (PDF).
The toolset also has the [...]
Filed under: Software and tools |
by walter Social tagging: dual master > failover > loadbalancing > mmm > multi-master > mysql > MySQL University > Open Query > replication > Walter Heck
No Comments »
Antony and I are busy getting the Open Query GRAPH Engine code ready so you all can play with it, but we needed to test with a larger dataset to make sure all was fundamentally well with the system.
We have some intersting suitable dataset sources, but the first we tried in ernest because it was [...]
Filed under: GRAPH engine |
by arjen Social tagging: graph > GRAPH engine > graphengine > hierarchy > mysql > open query > sql > tolweb > tree > tree of life
1 Comment »