This note is protected by password and is a Read Only.
Get the size of a MYSQL Dababase:
SELECT table_schema "Data Base Name",
round(sum( data_length + index_length) / 1024 / 1024 / 1024, 4) "Data Base Size in GB"
FROM information_schema.TABLES
GROUP BY table_schema ;


http://bit.ly/OUAttendance

O'Reilly MySql High Performance (2nd Eddition)

Class Kit: zakma.com/s-45.z

MySql download: http://www.mysql.com/downloads/mysql/
Clean / Remove current MySql instalation: yum remove mysql
Un-tar the mysql tar.gz: tar -xzf Desktop/mysql-5.1.53-linux-i686-glibc23.tar.gz
Create a simbolic link to the instalation dir: ln -s mysql-5.1.53-linux-i686-glibc23 mysql
cd mysql
scripts/mysql_install_db

show index from \G
mysqlslap -uusername -p -a -i 10 --concurrency=1,4,16,64,256
show processlist;

Infobright Enterprise Edition (column level compression - open source)


Daily Notes:
http://bit.ly/OUAttendance
O'Reilly MySql High Performance (2nd Eddition)
QAN: Query Analyzer
Benchmarking Tool: mysqlslap

None Private Note List:

URL Note Summary Days before delete
AllowedHtml <ul> <li><br> - Line break.</li> <li><o... 30137
BigDataFishig <b>#RealTimeData + #BigData + #Fishing</b>...teach... 30975
ChatSample Lee: Hello there, so can you explain how to chat u... 30137
Command-Line-Shortcuts <h3>Basic Keyboard Shortcuts</h3><b>Up/Down Arrows... 30223
dba <h2 style="display: inline;">Timeline:</h2> 21-Ja... 30166
dst_upgrade <h1>Oracle 11.2.0.2 DST Upgrade</h1><ol><li><b>che... 30201
Feedback ... 30081
hadoop_class_at_ebay eBay's North Campus, Parley room 2161 N. First ... 30260
mysql Get the size of a MYSQL Dababase: [code]SELECT ta... 30136
outlook-meeting-assassin <h1>Outlook Meeting Assassin</h1>A Simple Outlook ... 30695
Programming-Quotes <h3>Programming Quotes</h3> Java is to JavaScri... 30223
scrum <h2 style="margin: 0px 0px 0px 0px; padding: 0px 0... 867
vi <h2>vi cheat sheet</h2><b><u>Starting & ending com... 30142
websiteTricks-transperent [code]<!-- div.background { width:500px; h... 30081
xdb_installation <h1>Oracle XML DB (XDB) Installation</h1><ol> <li... 30201
zzzzzzzzzzz whycghkghfjjfhkctshsaqzmypqgrehghtmfggfhgoygvfjknm... 652

What else can I do with this?