MySQL Variable size usage in shell prompt

2015-06-16 Thread Manivannan S
the dump file? Regards Manivannan S DISCLAIMER: This email message and all attachments are confidential and may contain information that is Privileged, Confidential or exempt from disclosure under applicable law. If you are not the intended recipient, you are notified that any dissemination

Performance Improvements with VIEW

2013-07-30 Thread Manivannan S.
some MySQL sites and other blogs, I have seen that VIEWS will never improve the performance. But here I see some improvements with a view. I would like to know how VIEW is improving the performance. Regards Manivannan S DISCLAIMER: This email message and all attachments are confidential

Installation of MySQL in Redhat Linux 6.0

2012-07-05 Thread Manivannan S.
to install MySQL glibc23 package. I want to know why MySQL glibc23 package is not able to install with SELinux enabled?? Thanks in advance. Regards, Manivannan S DISCLAIMER: This email message and all attachments are confidential and may contain information that is privileged

RE: NoSQL help

2012-06-14 Thread Manivannan S.
in terms of second, minute, hourly, weekly and Monthly report also. From: Ananda Kumar [mailto:anan...@gmail.com] Sent: Thursday, June 14, 2012 12:32 AM To: Rick James Cc: Johan De Meersman; Manivannan S.; mysql@lists.mysql.com Subject: Re: NoSQL help Did you try with myisam tables. They are supposed

RE: NoSQL help

2012-06-14 Thread Manivannan S.
plan for 1.5 milion records.. From: Ananda Kumar [mailto:anan...@gmail.com]mailto:[mailto:anan...@gmail.com] Sent: Thursday, June 14, 2012 3:33 PM To: Manivannan S. Cc: mysql@lists.mysql.commailto:mysql@lists.mysql.com Subject: Re: NoSQL help can u share the sql, explain plan, indexes etc, show

RE: NoSQL help

2012-06-14 Thread Manivannan S.
. this is my execution plan for 1.5 million records From: Ananda Kumar [mailto:anan...@gmail.com] Sent: Thursday, June 14, 2012 3:33 PM To: Manivannan S. Cc: mysql@lists.mysql.com Subject: Re: NoSQL help can u share the sql, explain plan, indexes etc, show full processlist out put when the sql's

NoSQL help

2012-06-13 Thread Manivannan S.
. I have seen the concept of NoSQL and I am planning to implement this NoSQL concept into my database. Does anyone have any idea in NoSQL especially MongoDB technology and how to use this ? Thanks in advance. Regards, Manivannan S DISCLAIMER: This email

Reducing ibdata1 file size

2012-05-21 Thread Manivannan S.
the server but data still exist in the ibdata1 data file. How to reduce the ibdata1 file size in both LINUX and WINDOWS machine. Do you have any idea how to solve this problem. Thanks for any feedback. Thanks Manivannan S DISCLAIMER: This email message and all attachments are confidential

RE: Error in starting MySQL service on LINUX

2012-04-05 Thread Manivannan S.
service on LINUX Am 05.04.2012 12:27, schrieb Manivannan S.: Hi, In 64-bit Linux(Centos/Red Hat) machine when I am trying to start the MySQL service by using service mysql start command , I am getting the following error I have installed MySQL-client-5.1.52-1.glibc23

Error in starting MySQL service on LINUX

2012-04-05 Thread Manivannan S.
-client-5.1.52-1.glibc23.x86_64.rpm MySQL-server-5.1.52-1.glibc23.x86_64.rpm In my Linux machine. Does anyone know how to solve this issue in MySQL? Thanks Manivannan S DISCLAIMER: This email message and all attachments are confidential and may contain information that is privileged

RE: Error in starting MySQL service on LINUX

2012-04-05 Thread Manivannan S.
:39, schrieb Manivannan S.: Hi, If I execute service myqsld start its saying mysqld: unrecognized service DISCLAIMER: This email message and all attachments are confidential and may contain information that is privileged, confidential or exempt from disclosure

RE: Error in starting MySQL service on LINUX

2012-04-05 Thread Manivannan S.
- From: lists-mysql [mailto:replies-lists-b3z1-my...@listmail.innovate.net] Sent: Thursday, April 05, 2012 5:28 PM To: Manivannan S. Subject: RE: Error in starting MySQL service on LINUX Original Message Date: Thursday, April 05, 2012 11:04:48 AM + From