Myisam advantages

[P.R.Karthik]

 Hi,

  I am newbie to mysql can i know the advantages of myisam storage engine
and some of its special features.

-- 
Regards
Karthik.P.R
kart...@mafiree.com

Re: How to interrupt MySQL interpreter output?

[P.R.Karthik]

And also make sure that you have the SUPER privilege to kill it.

Regards,
KarthiK.P.R



On Fri, Jan 27, 2012 at 9:09 AM, Suresh Kuna wrote:

> login into another session, check the thread id and kill it. ( Kill
> threadid.)
>
> On Fri, Jan 27, 2012 at 3:51 AM, Dotan Cohen  wrote:
>
> > If I see that a query is taking a long time to finish, how can I
> > interrupt the MySQL CLI interpreter? Ctrl-C does not work. Thanks.
> >
> > --
> > Dotan Cohen
> >
> > http://gibberish.co.il
> > http://what-is-what.com
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:http://lists.mysql.com/mysql
> >
> >
>
>
> --
> Thanks
> Suresh Kuna
> MySQL DBA
>

Re: mysqld got signal 6 (problem why bigger than I initially realised)

[P.R.Karthik]

HI Brent,

Can you please paste your configuration file settings (my.cnf) ? It will
help to identify where things went wrong.

Is there any other memory consuming application running on the server
beyond mysql ?

Regards,
KarthiK.P.R



On Tue, Mar 27, 2012 at 4:17 PM, Brent Clark wrote:

> Hey Guys
>
> Yesterday I sent an email, about '1 client is using or hasn't closed the
> table properly', but the problem is actually bigger than I realised.
>
> We run Mysql replication, and on the second node, Mysql is crashing with
> 'mysqld got signal 6' every so often.
>
> Other than the drives, we have replaced the hardware, and still the
> problem persists.
>
> Googling, I thought it was a memory exhaustion issue, so I started playing
> with the following variables and values.
>
> key_buffer_size=8384512
> max_connections=41
>
> But it still crashes
>
> Mar 27 12:36:53 xyz-web02 mysqld: key_buffer_size=8384512
> Mar 27 12:36:53 xyz-web02 mysqld: read_buffer_size=131072
> Mar 27 12:36:53 xyz-web02 mysqld: max_used_connections=3
> Mar 27 12:36:53 xyz-web02 mysqld: max_threads=41
> Mar 27 12:36:53 xyz-web02 mysqld: thread_count=1
> Mar 27 12:36:53 xyz-web02 mysqld: connection_count=1
> Mar 27 12:36:53 xyz-web02 mysqld: It is possible that mysqld could use up
> to
> Mar 27 12:36:53 xyz-web02 mysqld: key_buffer_size + (read_buffer_size +
> sort_buffer_size)*max_threads = 97828 K  bytes of memory
>
> xyz-web02:# free -m
> total   used   free sharedbuffers cached
> Mem: 12038  11966 71  0117  11378
> -/+ buffers/cache:469  11568
> Swap: 2047  0   2047
>
> We running Debian Squeeze 64bit.
>
> I have attached the full crash message.
>
> If anyone can help, I would be *most* grateful (If you are in South
> Africa, I will buy you a meal, let alone a beer :)
>
> Kindest Regards
> Brent Clark
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>

Re: MySQL slowlog - only in file?

[P.R.Karthik]

Hi Rafal,

If there are more slow queries in your server and logging them into a table
will increase the IO of the server.
It is better to be in a file. The slow query log file can be processed
easily by 
pt-query-digest
.

Regards,
KarthiK.P.R
MySQL DBA


On Fri, May 11, 2012 at 2:47 PM, Nilnandan Joshi wrote:

> Hi Rafal,
>
> If you are using MySQL 5.1 and later version than you can enable the log
> tables and you can see slow queries in the log tables.
> Please check this post:
> http://nilinfobin.com/2012/03/slow_log-and-general_log-tables-in-mysql-5-1/
>
> regards,
> Nilnandan
>
> On Fri, May 11, 2012 at 2:40 PM, Rafał Radecki  >wrote:
>
> > Hi all.
> >
> > Is there a possibility to see the info from slowlog somewhere in
> database?
> > I would like to see slow queries using mysql and not by watching the log
> > file.
> > I've searched on google and mysql website but hasn't found the solution.
> >
> > Best regards,
> > Rafal Radecki.
> >
>

Re: mysql replication

[P.R.Karthik]

Hi ,

Can you paste the complete error log.

Regards,
KarthiK.P.R



On Wed, Aug 29, 2012 at 7:04 AM, aaron zhang
wrote:

> Hi all
>
> i use mysql database,when i use mysql replication ,the slave host do not
> replication,i check the error message,i found error message,it is 'row is
> too large', i do not understand why,please tell and help me ,thanks
>