mysql

"Online applications are vulnerable to theft of sensitive information because adversaries can exploit software bugs to gain access to private data, and because curious or malicious administrators may capture and leak data. CryptDB is a system that provides practical and provable confidentiality in the face of these attacks for applications backed by SQL databases. It works by executing SQL queries over encrypted data using a collection of efficient SQL-aware encryption schemes. CryptDB can also chain encryption keys to user passwords, so that a data item can be decrypted only by using the password of one of the users with access to that data. As a result, a database administrator never gets access to decrypted data, and even if all servers are compromised, an adversary cannot decrypt the data of any user who is not logged in. An analysis of a trace of 126 million SQL queries from a production MySQL server shows that CryptDB can support operations over encrypted data for 99.5% of the... more... - imabonehead from Bookmarklet

"A little-known fact about Facebook Timeline: It relies on MySQL, a database-management system that was originally designed to be used in small-scale applications on just one or a few machines -- a far cry from the 800+ million users of the world's largest social network. What gives? In this report from Wired, Serkan Piantino, who will be in charge of Facebook's New York engineering office, reveals that Facebook turned to MySQL to help address the memory needs of Timeline, since it works in a fundamentally different way from the news feed." - imabonehead from Bookmarklet

"So, I want to take a shell script and be able to put it on any machine - and have it backup the databases on that machine using mysqldump.. and put them each separately into a backup directory.. here's what I came up with. Can you make it better?" - imabonehead from Bookmarklet

"I often get asked how to set up and use SSL with MySQL, especially on Windows – I think largely because the manual step-by-step is more geared towards Linux users (though this “how-to” is valid for all – anyone can copy/paste the commands after changing the paths). So I’ve compiled a concise, yet comprehensive, how-to that I wanted to share with everyone out there who wants to set this up quickly and efficiently." - imabonehead from Bookmarklet

"One of the challenges many face when running a secure encrypted MySQL backup on Linux is using managed or scheduled mysqldumps without exposing them. The data – within the mysqldump backup file The credentials – that are used connect into mysql So, how might this be accomplished? I’ll show you one option. It starts with the installation of Gazzang’s ezNcrypt. Its not open source, but it is inexpensive and provides you a simple and secure means to protect and encrypt data transparently with the flexibly to map to your environment and applications. This technique also applies to other backup tools such as xtrabackup." - imabonehead from Bookmarklet

"Dealing with large data sets makes it necessary to pick out only the newest or the hottest elements and not displaying everything. In order to have older items still available, Pagination navigation's have become established. However, implementing a Pagination with MySQL is one of those problems that can be optimized poorly with MySQL and certainly other RDBM systems. However, knowing the underlying database can also help in optimizing pagination queries, because there is no real copy and paste solution." - imabonehead from Bookmarklet

"MySQL is the world’s most popular open source database. Whether you are a fast growing web property, technology ISV or large enterprise, MySQL can cost-effectively help you deliver high performance, scalable database applications. Check out this site MySQL Commands for a nice MySQL cheat sheet. UrFix.com however has created a list of commands I use almost daily when monitoring and maintaining my LAMP server. I hope you find these useful…" - imabonehead from Bookmarklet

Presentation slides are now available. - imabonehead from Bookmarklet

"Oracle has finally done what the business management at MySQL had been asymptotically approaching for years. It’s taking MySQL open core. It’s interesting to read the views of the founder of MySQL (as well as the comments). Monty says..." - imabonehead from Bookmarklet

"Debugging SQL code is a very important task these days. Unfortunately not all database servers support this feature. And MySQL is one of such servers. In spite of its wide feature set, debugging is not implemented in it. So the problem is that MySQL provides no API functionalities for code debugging. But the necessity to debug SQL code does not disappear and becomes more and more important each year. Some companies that develop tools to access data of MySQL server databases create their own debuggers that solve this problem to some extent." - imabonehead from Bookmarklet

"This is the first in a three part series of blogs in which I’ll try to explain how to take an existing application and shard it. Database Sharding has proven itself a very successful strategy for scaling relational databases. Almost every large web-site/SaaS solution uses sharding when writing to its relational database. The reason is pretty simple – relational database technology is showing its age and just can’t meet today’s requirements: a massive number of operations/second, a lot of open connections (since there are many application servers talking to the database), huge amounts of data, and a very high write ratio (anything over 10% is high when it comes to relational databases). Many sites and blogs posts explain what sharding is, for example here and here. But how do you shard your application? Actually, the flow is quite simple, and consists of just four steps..." - imabonehead from Bookmarklet

"Just in case anybody missed it: http://blogs.oracle.com/MySQL... MySQL has long been an open source product, not an open source project…. and this really is the final nail in that. To me, this was expected, but it’s still sad to see it. I am very, very glad we have diverse copyright ownership in Drizzle so that this could not happen easily at all." - imabonehead from Bookmarklet

"Earlier this month I published an article on this blog describing the system of record approach to multi-master replication. As mentioned in that article my colleagues and I at Continuent have been working on improving Tungsten to make system of record design patterns easier to implement. This article describes how to set up system of record using Tungsten Replicator shard filters, which are a new feature in Tungsten 2.0.4. By doing so we will create a multi-master configuration that avoids replication loops and transaction conflicts. On top of that, it is quite easy to set up." - imabonehead from Bookmarklet

"In the Major version upgrade, people are generally using very common technique which is, taking backup by mysqldump from MySQL 4.1 and reload into MySQL 5.0. This is also recommended by MySQL Guru's specially when data is sensitive and contains different character-sets (Here, its recommended to convert data from normal text to binary and vice versa) but we can also use mysql_upgrade script when data is not that much important or possible to re-generate easily by the row data. For the minor version upgrade, mysql_upgrade script is the best way to upgrade the mysql dbs." - imabonehead from Bookmarklet

#yay - Serkan Ünsal

#yay - Paruğ Demircioğlu from BuddyFeed

sql ile yapabilirsin. SELECT ADDDATE('2008-01-02', INTERVAL 31 DAY); vs. vs. - Ufuk ACAR

date('d.m.Y', strtotime('+7 days', strtotime('02.03.2010'))); - Tuncay KINALI

allah cümlenizden razı olsun abiler :)) - Eren Süleymanoğlu

"I'm happy to announce a new round of Google MySQL tool releases. We're just getting started, but here's what's available so far..." - imabonehead from Bookmarklet

combofix - Onur Onat

sonuçta sql ile ilgilenen adam bilgisayarla ilgili bir adamdır bilgisayarla ilgili adam antivirüs programı kullanıyor olabilir ve bana tavsiye edebilir bunu tartışacağımız yere benim sorunumla ilgili bir tavsiye verirseniz daha mutlu olurum.. saygılar.. - Eren Süleymanoğlu

implode?? - canosayan

evet implode ile çözdüm saygılar canosayan :) - Eren Süleymanoğlu

ne demek. bir mukabele - canosayan

Okay...now it's down to 36% without me doing anything. It appears that it is an automated process that dumps the DB and then compresses it into a gzip file. - Sean

"It’s always good to have some equations for reference when you are tuning a MySQL server. How else will you know what to set your buffer sizes to after all? If you have some that I’ve missed… add a comment!" - imabonehead from Bookmarklet

"The deadline scheduler has many advantages over the cfq scheduler, which is the default in operating systems like RedHat Enterprise Linux. In my previous post, I quickly showed how much of a performance gain can be had by switching to the deadline scheduler. Now I will show some real performance numbers for different RAID configurations." - imabonehead from Bookmarklet

@mustafa sağol deneyeceğim. - Uğur GÖK

TMP Dizininin Sismesinden kaynakli bir sorun bu MYSQL de hala bug olarak beklemede. innodb longtext lerde bu sorunu veriyor - Melih Buyukbayram

"Today's article will list a few coding techniques that we as database administrators and developers can use to whittle down unwieldy results sets into manageable chunks." - imabonehead from Bookmarklet

http://www.webgrafiktasarim.org/ bu siteden windows7 üzerine php,mysql, phpmyadmin kurulumu gibi bütün kurulum bilgilerine ulaşabilirsin. - ahmetkucukoglu

SQLyog denemelisin! - İnatçı Keçinin Çıngırağı