A big welcome to the Portuguese MySQL Community. The MySQL team has recognized your support of MySQL, so we hope you can take advantage of the new Portuguese MySQL Planet. Wagner has started us off with his blogs so please feel free to submit your Portuguese Feeds.
May
11
2012
May
11
2012
Some of our users have encountered problems with establishing a connection over the tunnel.php script despite the fact that the tunnel.php script is installed correctly. The following error message occurs: ‘Can’t connect to MySQL server on ‘your.sitename.com’ (10061): Authentication failed.’ The problem appears to be with cached proxy servers and will be fixed in one [...]
May
11
2012
With the release of MySQL Cluster 7.2.5 we've released a version
of MySQL Cluster where each data node is capable of using up to
51 threads in total. This is a remarkable feat for a product that
only a few years ago was purely single-threaded. This article
tries to explain what it is in the MySQL Cluster architecture
that makes it so scalable to new HW demands.
The MySQL Cluster architecture is based on a design that is used
in the world's most sold telecom switch, the AXE switch. This
switch is used in all mobile networks delivered by Ericsson.
MySQL Cluster also originates from Ericsson. The architecture of
the AXE switch was developed in reaction to an older switch that
had quality issues since there were too many global variables and
too little modularity. The architecture was inspired by how HW
was designed. In HW design each module can only communicate with
other HW modules using signals (mostly electrical). The idea of
the AXE …
May
11
2012
Just a note on a problem that some people may find useful and may
work for you if you have the same issue.
A client had a problem this morning with queries being aborted
with the error message:
Got temporary error 4006 'Connect failure - out of
connection objects (increase MaxNoOfConcurrentTransactions)' from
NDBCLUSTER
Here you would think that increasing the number
of MaxNoOfConcurrentTransactions would help, but the root
cause is something else (the client is not even close of hitting
the default MaxNoOfConcurrentTransactions)
It turned out that during the night a couple of updates to the
schema had been made (ALTER TABLEs to convert a couple of TEXT to
VARCHAR, so that a particular index could be
created).
Looking in the mysql error logs we had:
120511 10:47:05 [ERROR] /usr/local/mysql/bin/mysqld: Sort
aborted: Got …
May
11
2012
Upscene
Productions is celebrating it's 10 year anniversary with a
massive discount on all our products: 70% discount until the end
of May.
We produce database development, management and testing tools
for:
* Oracle
* Microsoft SQL Server
* MySQL
* InterBase
* Firebird
* SQL Anywhere
* NexusDB
* Advantage Database
* Generic connectivity tools for ADO and ODBC
These include test data generator tools, database design and
development tools, auditing tools, a dbExpress driver for
Firebird, debugging tools, performance analysis tools.
Coupon code TENYEARS will get you this discount, check www.upscene.com for
more information.
May
11
2012
They say, “April showers bring May flowers.” They basically say that nature brings different things in different colors aimed at improving the things. That is so true for the blogging world too. This Log Buffer Edition also brings out different blog posts to improve things, so enjoy the Log Buffer #271. Oracle: One of world’s [...]
May
11
2012
This week has been rather calm.
I was busy with day-to-day work but had some spare time to use on simple implementations and tests. My work was related to Tablespace management in 5.6 and Table partition EXCHANGE. You can read the articles here.
I have also started to dig a little bit more in the details of Mongo’s architecture, given the need to have it properly reviewed and implemented in parallel with MySQL installations. As for news and reviews, I was interested in a couple of articles:
Interesting article from Vadim about SSD. This is more of
a suggested reading then one I can comment on.
What really makes me unhappy was the …
May
10
2012
Today on MySql Forums, there was a question in the newbie section about two users — I have a doubt on db host and db user relationship . What does this mean ?
| name | host |
|---|---|
| tom | % |
| joe | 127.0.0.1 |
New DBAs are often confused by the quirky methods of authentication that MySQL uses. Heck, extremely experienced MySQL DBAs can get confused.
From the manual, 6.2.4. Access Control, Stage 1: Connection Verification
When you attempt to connect to a MySQL server, the server accepts or rejects …
[Read more]
May
10
2012
I was lucky enough to get my hands on new Fusion-io ioDrive2 Duo
card. So I decided to run the same series of tests I did for
other Flash devices. This is ioDrive2 Duo
2.4TB card and it is visible to OS as two devices (1.2TB each),
which can be connected together via software RAID. So I tested in
two modes: single drive, and software RAID-0 over two
drives.
I should note that to run this card you need to have an external
power, by the same reason I mentioned in the previous post: PCIe slot can provide only
25W power, which is not enough for ioDrive2 Duo to provide full
performance. I mention this, as it may be challenge for some
servers: some models may not have connector for external power,
and for some …
May
10
2012
Setting the mode to STRICT_ALL_TABLES when you compile your stored procedure or function can prevent a lot of subtle bugs in your MySQL application. Consider this example: DELIMITER // CREATE FUNCTION test(p_first TINYINT, p_second TINYINT) RETURNS TINYINT BEGIN DECLARE v_result TINYINT; SET v_result := p_first + p_second; RETURN v_result; END// DELIMITER ; compile it and then test the funcion: mysql> [...]