eletedbyrecipient` tinyint(1) NOT NULL default '0',
`threadid` varchar(36) NOT NULL default '',
`senttime` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `folderid` (`folderid`),
KEY `threadid` (`threadid`),
KEY `inboxfolderindex` (`folderid`,`toi
ishna Chandra Prajapati
To: || Sudhir Nimavat ||
Cc: Mysql
Sent: Tue, 3 November, 2009 10:41:57 AM
Subject: Re: 50M records each year.. how to handle
Hi Sudhir,
I am handling 50M record each day. Your requirement can be easily full filled
using partition and good architecture.
Thanks,
Krishna
O
Its a very simple table that will store messages.
Each message would have subject, body,to_user_id,
from_user_id,is_deleted,date_sent and may be one or two more column
There would be frequent read operation and slow write operation.
Thanks
SN
Personally I'm always ready to learn, alt
I have come across a requirement where I need to store a very large amount of
data in a table.
In one of our app.. we can have around 50 Million records each year.. Can any
one guide me in choosing a strategy than can handle this load.
Thanks
SN
Sudhir NimavatSenior software
*mysql> create user 'test'@'localhost' identified by 'pass';*
Query OK, 0 rows affected (0.00 sec)
*mysql> GRANT CREATE, DELETE ON *.* TO 'test'@'localhost';*
Query OK, 0 rows affected (0.00 sec)
*mysql> select * from information_schema.user_privileges where grantee like
"'test'@'localhost'";*
+-
mysql -u root -ppassword
mysql> create user 'user'@'localhost' identified by 'password' ;
mysql> grant create on *.* to 'user'@'localhost';
mysql> flush privileges;
mysql> quit
mysql -u user -ppassword
mysql> create databas
Hi Ujang
I could reproduce the same error mentioned by you in the actual post even
after having all of the packages for MySQL. Figuring out the what could be
the problem .
Thanks & Regards
Sudhir Menon
5rt * < Package that contains the library
in my system.
*Pathname: /opt/csw/mysql5/lib/mysql/libmysqlclient.so.15*
Type: symbolic link
Source of link: libmysqlclient.so.15.0.0
Referenced by the following packages:
CSWmysql5rt
Current status: installed
Thanks & Regards
Sudhir Menon
+ handler_read_first +
handler_read_next + handler_read_key + handler_read_prev )
*
Thanks & Regards
Sudhir Menon
.so files are in PATH.
4. Recompile super-smack again.
I am using a CSW package other than the default SUNW package, let me see if
i could reproduce the problem.
Thanks & Regards
Sudhir
Hope this link has some workaround.
http://mysqldatabaseadministration.blogspot.com/2006/10/mysql-benchmarking-4-compiling-super.html
Meanwhile i do check out.
Thanks & Regards
Sudhir Menon
My reply was with regards to the answer in this post.
http://lists.mysql.com/mysql/214827
Anyways thanks for the concern from your end.. Mike :) My query was
answered.
Thanks & Regards
Sudhir Menon
Thanks Amit ...
Thanks & Regards
Sudhir
Thanks & Regards
Sudhir
Thank You... Res, Ananda for the reponse to myquery...
It works fine now.. :)
Yes, mysql by default sets the socket file in the below directory
/var/lib/mysql/mysql.sock.
But why does it refer to /tmp/mysql.sock file then, as that was the error
which was given when i tried to login to mysql.
Is that hard-coded for MySQL5.1 source code, which is what i wanted to know
?
Th
Hello,
I have mysql-5.0.22-2.1.0.1.rpm version installed on RHEL5.1 system. I have
been trying certain benchmarking tools and
found that MySQL5.1 has inbuilt benchmarking tool known as "mysqlslap".
Since the tool is not available
for MySQL5.0, i have downloaded the source rpm
MySQL-community-5.1.2
Hi,
When i try to query ... load data infile ...
i am getting the following error ...
ERROR 13: Can't get stat of 'upload_fct_HQ_CA001S.txt' (Errcode: 2)
The above mentioned same query i have used in many other modules, but i
never get the error. The file from which i am trying to load the data
Hi,
I am a Sudhir, working as a Software Consultant in Unidux Technologies,
Singapore. My job here is to suggest Technology. Now we are planning to
purchase license for the application server JRun. Currently we are
developing a procurement engine in Java, using MySql as the data base
server
19 matches
Mail list logo
