DevHeads.net

Hi guys,

I'm working in a telecom company. I have table called deliverylog in which
30 million records gets inserted per/day. The table has grown to 0.5TB I
have to keep 60days record in the table. So, 60days * 30 million = 1800
million records. The query is taking a lot of time to fetch the result.

Please sugget me what storage engine must be used and how i can get the
things done. Is there any other alternative.

Any response is highly appreciated.

Thanks,
Krishna

I find my MySQL Community Edition 5.1.34 server running out of space on
/tmp (which is indeed small). Why is it using /tmp? How much free space
do I need on /tmp? Can/should I make the server use a different location
instead of /tmp?

Thanks,
Mike Spreitzer

Hello all,
I used Database Workbench on trial bases. It is nice. I plan to purchase an
IDE. Is is it the best around. Your feed back is appreciated.
yours
mosaed

Hi.
Here is the introduction.
http://www.oracle.com/technology/oramag/oracle/05-sep/o55security.html
I want to know whether MySQL has the same function as Oracle's?
Any reply is appreciated.

Hi.
I want to know which lock method is used within MySQL?
For example, if I query the following statements within MySQL client.
mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from GroupId_Test where id = 212 lock in share
mode;

+-----+---------+
| id | GroupId |
+-----+---------+
| 212 | 3014485 |
+-----+---------+
1 row in set (0.00 sec)

But when I execute statement called show engine innodb status, it only
display the total lock numbers.

Anybody can tell me how to see whether the lock is a share lock or exclusive
lock?

I just noticed a horrible thing.

I have a query (report) that can take 15 minutes or more to generate with
mySQL. We have > 500 Million rows. This used to be done in real time when we
had less rows, but recently we got a big dump of data that shot it up.

So, noticing via myTop the query taking so long, I closed my web page tab.
The query did NOT go away! WTF? So mysqld continued to peg the CPU at 75% to
135% (yes, top shows that if you have quad cpus. *sigh*)

Is there some way to force this to work sanely?

Hi All,

I have read many blogs suggesting some examples for this.
But suggestions from you guys who have ACTUALLY worked on such a scenario
would help me out the best.

Current Database has:
DEFAULT CHARACTER SET - latin1
DEFAULT COLLATION : latin1_swedish_ci

We need to convert this to
DEFAULT CHARACTER SET - utf8
DEFAULT COLLATION : utf8_general_ci

Note that this has to be done on a database that has *existing data* in it .

Hence just by doing a:

ALTER DATABASE CHARSET=utf8;

would result in unexpected behaviour of the data.

Thanks!
Uma

Hello everyone ,

I wanted to make sure i didn't miss
something but after a few tests and doing some web/doc search i come to
the conclusion that we cannot restrain a user from dropping a database but
still being able to drop tables and etc ?

Hello -

I'm trying to build an executable that would be distributed in binary
form, but needs to link to a MySQL DB -

problem I'm finding is that the shared libs range in name
libmysqlclient.so.15 , libmysqlclient.so.14, etc... And throw a
run-time error when it isn't found...

Is there a way to compile to just the .so, without the extension that
would be more portable?

Or is there a better approach to this? or do I just need to maintain a
copy that is linked to each different version ?

Thanks

Matt

Hpe you are doing well, and Trying to create a FK from "evaluacion"
table to "seccion" table I got this error message, does anybody knows
how to solve this, anyone have heard about this mistake, any help on
this will be really appreciated.

Saludos

Arturo Hinojo

NO imprimas este correo a menos que sea necesario.

Please consider the environment before printing this page.

Hello all,

Hope you are doing well, I have a general question creating foreign keys
, I'm creating FK from catalog tables to relation tables with them, when
I create a FK in innodb engine on MYSQL a new field with the same name
of the FK is created, in this case if I create for example 3 FK the
table will have 3 fields more, my Question is, is it right? How should
be filled these fields? Are they autofilled when I start to fill the
table?