comment on

I often hear people say that MySQL is "slow". Which often translates to sub-optimized or under-powered. Consider the following real-world example which shows that MySQL works fine with enormous data sets (Yes that almost 1 billion rows in a single table having 41 columns, 1 primary key, 1 unique key, 9 non-unique keys):

mysql> select count(*) from t_prod;
+-----------+
| count(*)  |
+-----------+
| 952174654 |
+-----------+
1 row in set (0.00 sec)

# ls -lh /var/lib/mysql/prod | grep t_prod
-rw-rw----  1 mysql mysql   11K Jun  4  2007 t_prod.frm
-rw-rw----  1 mysql mysql  222G Apr 18 07:35 t_prod.MYD
-rw-rw----  1 mysql mysql  102G Apr 18 07:35 t_prod.MYI
[download]

And I can tell up operations on that table are very fast as long as the indices are used properly.

Maintenance, however, is a nightmare. For example:

When there's a power outage or voltage flux and that 222G table's indices become corrupt and needs to be rebuilt. During which the table is locked and inaccessible.
When one needs to reduce the data set and the delete operation takes hours. During which the table is locked and inaccessible. (Of course, this can be mitigated by using partition tables).

--
When you earnestly believe you can compensate for a lack of skill by doubling your efforts, there's no end to what you can't do. [1]

In reply to Re^3: PostgreSQL cursors with Perl. by andreas1234567
in thread PostgreSQL cursors with Perl. by atemerev

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		`&`
	<		`<`
	>		`>`
	[		`[`
	]		`]`

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.