Login or Register to Ask a Question and Join Our Community


MySQL DevZone RSS

MySQL Database Analytics with InfiniDB from Calpont – Part

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Web Development MySQL DevZone RSS MySQL Database Analytics with InfiniDB from Calpont – Part
# 1  
Old 10-27-2009
MySQL Database Analytics with InfiniDB from Calpont – Part
Let's be honest: working with big databases is a lot of fun. There's something cool about dealing with tables that have hundreds of millions or billions of rows in them, loading huge amounts of data, building star and snowflake schemas for data warehouses/marts, optimizing query performance, and all that jazz. Yes, working with big databases is a lot of fun.On the other hand, let's be honest: working with big databases is not a lot of fun. There's a lot of pain in dealing with tables that have hundreds of millions or billions of rows in them, waiting for huge amounts of data to be loaded only to have the load job toss its cookies and fail when it's 99% done, building special schemas that you wonder whether make any difference at all, and trying to figure out why just a simple two-way join query has been hanging for over an hour. Yes, working with big databases is not a lot of fun.

More...
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Programming

Need help on Insert data to mySQL database

Hi guys, I would like to seek help on inserting data whenever the switch is on or off to my sensor mySQL database in phpMyAdmin from my control.php. I'm using Raspberry PI as my hardware and follow a few tutorials to create my own Web Control Interface, it works perfectly without insert method.... (1 Reply)
Discussion started by: aoiregion
1 Replies

2. Programming

Mailx recipient from mysql database

Dear All, Can I make Mailx to read recipient address from a mysql database? I already tried emailing with bash script: SUBJECT="TEST" export EMAIL_ADDRESS=`mysql -uroot -pabcde smsd -e "SELECT email FROM recipient"` mysql -uroot -pabcde smsd -e "SELECT ID, SenderName, Body FROM inbox" |... (2 Replies)
Discussion started by: jazzyzha
2 Replies

3. UNIX for Dummies Questions & Answers

SSH import mysql database

Hi all, I am trying to import a database in putty with the syntax: mysql –u database_username –p database_name < filename.mysql As you can see in the screenshot it asks me for the database password - which suggests that the syntax is correct - but then after I enter the password it gives... (2 Replies)
Discussion started by: Juc1
2 Replies

4. Web Development

Updating Records in Mysql Database

so when i issue a command like the below: # mysql --pager=/usr/bin/less -u cactiman -p -e 'select * from data_input' cacti Enter password: ... (2 Replies)
Discussion started by: SkySmart
2 Replies

5. Shell Programming and Scripting

How to backup a particular Database in MYSQL?

Hi All, Thanks in Advance!! How to backup a particular Databases..through Bash script!! For example i have 6 databases; Anish linux Software Questions Rhce Google these are the databases i have from that i want to take "Anish" and "questions" database backup regularly.... (4 Replies)
Discussion started by: anishkumarv
4 Replies
Login or Register to Ask a Question

LEARN ABOUT LINUX

ndb_delete_all

NDB_DELETE_ALL(1)					       MySQL Database System						 NDB_DELETE_ALL(1)

NAME

       ndb_delete_all - delete all rows from an NDB table

SYNOPSIS

       ndb_delete_all options

DESCRIPTION

       ndb_delete_all deletes all rows from the given NDB table. In some cases, this can be much faster than DELETE or even TRUNCATE TABLE.
	       Usage

	   ndb_delete_all -c connect_string tbl_name -d db_name

       This deletes all rows from the table named tbl_name in the database named db_name. It is exactly equivalent to executing TRUNCATE
       db_name.tbl_name in MySQL.

       The following table includes options that are specific to ndb_delete_all. Additional descriptions follow the table. For options common to
       most MySQL Cluster programs (including ndb_delete_all), see Options Common to MySQL Cluster Programs(1).

       Table 17.16. ndb_delete_all Options and Variables: MySQL Cluster NDB 7.2
       +--------------------------+-----------------------------------+-------------------------------------+
       |Format			  | Description 		      | Added / Removed 		    |
       +--------------------------+-----------------------------------+-------------------------------------+
       |			  | Name of the database in which the | 				    |
       |       --database=dbname, | table is found		      |        All MySQL 5.5 based releases |
       |			  |				      | 				    |
       |       -d		  |				      | 				    |
       +--------------------------+-----------------------------------+-------------------------------------+
       |			  | Perform the delete in a single    | 				    |
       |       --transactional,   | transaction (may run out of       |        All MySQL 5.5 based releases |
       |			  | operations) 		      | 				    |
       |       -t		  |				      | 				    |
       +--------------------------+-----------------------------------+-------------------------------------+
       |			  | Run tup scan		      | 				    |
       |       --tupscan	  |				      |        All MySQL 5.5 based releases |
       +--------------------------+-----------------------------------+-------------------------------------+
       |			  | Run disk scan		      | 				    |
       |       --diskscan	  |				      |        All MySQL 5.5 based releases |
       +--------------------------+-----------------------------------+-------------------------------------+

       o   --transactional, -t

	   Use of this option causes the delete operation to be performed as a single transaction.

	       Warning
	       With very large tables, using this option may cause the number of operations available to the cluster to be exceeded.

COPYRIGHT

       Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.

       This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
       published by the Free Software Foundation; version 2 of the License.

       This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
       Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

SEE ALSO

       For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
       at http://dev.mysql.com/doc/.

AUTHOR

       Oracle Corporation (http://dev.mysql.com/).

MySQL 5.5							    01/30/2014							 NDB_DELETE_ALL(1)