Lately in the MySQL community, we only hear about scalability or performance improvements of storage engines, but nothing about query engine itself. For example, one classic example being InnoDB; if[...]
May
11
2010
May
11
2010
MySQL Admin Cookbook from Packt Publishing, authored by Daniel Schneller & Udo Schwedt, is a new addition to the MySQL literary genre with 99 great recipes for mastering MySQL configuration and administration. Announcing quick answers to common problems, these 99 recipes cover a broad spectrum of managing MySQL, and are appropriate for new MySQL administrators as well as more experienced administrators. MySQL Admin Cookbook is available in dead tree and PDF formats. The book's website is: https://www.packtpub.com/mysql-admin-cookbook/book with errata found at http://www/packtpub.com/support.
Subjects Covered
- Replication
- Indexing Tools
- Backing Up & Restoring MySQL Data
- Managing Data
- Monitoring & …
May
11
2010
MySQL Admin Cookbook from Packt Publishing, authored by Daniel Schneller & Udo Schwedt, is a new addition to the MySQL literary genre with 99 great recipes for mastering MySQL configuration and administration. Announcing quick answers to common problems, these 99 recipes cover a broad spectrum of managing MySQL, and are appropriate for new MySQL administrators as well as more experienced administrators. MySQL Admin Cookbook is available in dead tree and PDF formats. The book's website is: https://www.packtpub.com/mysql-admin-cookbook/book with errata found at http://www/packtpub.com/support.
Subjects Covered
- Replication
- Indexing Tools
- Backing Up & Restoring MySQL Data
- Managing Data
- Monitoring & …
May
11
2010
if I used foxpro database there’re no limit column when I save
the records more than 50 column but if I used mysql server to
save from foxpro there are limit column and then show warning
“command contain unrecognized phrase/keyword” like code below
:
SQLEXEC(test,”LOCK TABLE LocalOnLine.vouchers WRITE”)
SQLPREPARE(test,”UPDATE LocalOnLine.vouchers SET
division=?v_dv,agent=?v_ag,guide=?v_gd,invoice=?v_iv,month=?v_mt,years=?v_yr,voucher=?v_vc,;
bill=?v_vl,cgroup=?v_gr,client=?v_cl,client1=?v_c1,client2=?v_c2,remarks=?v_rk
WHERE month=?v_mt and years=?v_yr and voucher=?v_vc and
totalrp+totalus>0″)
server=SQLEXEC(test)
SQLEXEC(test,”UNLOCK TABLE”)
IF server<0
MESSAGEBOX('Update voucher '+v_vc+' '+v_vd+' '+ALLTRIM(v_nm)+'
failed',16,'Warning')
ENDIF
what wrong with my code above and there are limit column to save from foxpro to mysql server ?
please help me, …
[Read more]
May
11
2010
In a couple of recent consulting cases, I needed a tool to analyze how a log of queries accesses indexes and tables in the database, specifically, to find out which indexes are not used. I initially hacked together something similar to Daniel Nichter’s mysqlidxchk, but using the framework provided by Maatkit, which gave me a pretty good start right out of the box. This was useful in the very tight time constraints I was under, but was not a complete solution. Alas, I could not use anything like Percona’s enhancements for finding unused indexes.
So, in response to another consultant’s customer request (and sponsorship — thank you!) I spent more time actually writing a real tool in the Maatkit style, with full tests and all the rest of the usual goodies. The resulting …
[Read more]
May
11
2010
A lot of conversations with a few different people I respect (no links, sorry) have coalesced some thoughts about these newly popular “non-relational” datastores. I wanted to point out an aspect I’m not sure is very clear in the hot-topic department. This is about what happens when managers learn that their developers or operations team have installed some new technology in their systems without them knowing it.
Lest anyone think that this happens only in a poorly-managed company, I can attest that it happens everywhere, all the time. Remember Marten Mickos’s favorite story about salespeople asking prospects if they used MySQL, the managers saying absolutely not, and the developers contradicting them?
The moment of discovery is unpleasant for the manager, but everything leading up to it was a joy for the programmer. He decided that he’s annoyed with the MySQL database. SQL is hard anyway — it is such a pain to write …
[Read more]
May
11
2010
The version number is based on the last major beta release of
Flexviews.
FlexCDC is an almost complete refactoring of 'consumer.php' which
was included in Flexviews 1.5.0.
In the new FlexCDC version:
All DML operations are supported (binlog_format MUST BE
ROW)
INSERT
UPDATE
DELETE
REPLACE
LOAD DATA
Complete support for the following DDL operations is
provided:
ALTER TABLE
RENAME TABLE
These DDL operations are partially supported:
TRUNCATE - log is not truncated
DROP DATABASE - leaves orphaned log tables
DROP TABLE - leaves orphaned log tables
The following DDL operations are ignored and do not trigger
errors or warnings:
ALTER DATABASE
ALTER EVENT
ALTER LOGFILE GROUP
ALTER FUNCTION
ALTER PROCEDURE
ALTER SERVER
ALTER TABLESPACE
ALTER …
May
11
2010
Just a quick blog posting today…ODTUG Kaleidoscope 2010 is proud to announce the addition of a FULL MySQL track for the conference! Starting on Monday, June 28th, and running until the end of the conference on Thursday, July 1st, the track will host 19 sessions on MySQL. The MySQL database is the world’s most popular open source database, and is used by many popular and successful websites.
The track was put together in much the same way that ODTUG added its highly successful Hyperion and Essbase content to the conference, starting back in 2008. ODTUG recognized an opportunity to help out the community by providing room for content to be presented. Then, we connected with a respected leader in the MySQL community, one of the first three Oracle ACE Directors representing …
[Read more]
May
10
2010
In comments to my previous post I got number number of comments saying if MySQL would not have multiple storage engine interface it would not allow people to do various very cool stuff. And I agree with this. The question is how cool you want your database operation to be ? Visiting customers I see 2 very distinct groups of MySQL Users
Users what want cool database This is where a lot of energy is flowing (and Drizzle is picking up a lot on these market) - they want to do stuff which was not done before, they are interested in all kinds of plugins, replicating from MySQL to Cassandra and doing other cool stuff. Some of this cool stuff can be buggy but their applications are often not very business critical and they are ready to take a risks and spend sleepless nights troubleshooting issues as they come across. …
[Read more]
May
10
2010
Open Source Bridge dubs itself as the conference for open source citizens. It happens June 1-4 2010, in beautiful Portland, Oregon. The young event (it celebrates its second birthday this year), seems to already have a great database track.
From Monty Program Ab, we have Monty himself leading a session on The State of MariaDB. So if you want to go meet the creator of MySQL, the founder of MariaDB, or just taste some Salmiakki vodka, you certainly want to be there at Open Source Bridge.