and delete are not equivalent but i want to get
rid
of
all
information inside
thanks
Pau Marc Muñoz Torres
skype: pau_marc
http://www.linkedin.com/in/paumarc
http://www.researchgate.net/profile/Pau_Marc_Torres3/info/
--
--
--
Thanks
Suresh Kuna
Hi Pau,
Would you please paste the timeout error ? If you want to get rid of a
table then the recommendation is to drop the table in non-peak hours.
Thanks
Suresh Kuna
On Sat, May 16, 2015 at 2:00 PM, Pau Marc Muñoz Torres paum...@gmail.com
wrote:
Hello every body
i have a big table in my
://lists.mysql.com/mysql
--
--
Thanks
Suresh Kuna
MySQL Database Consutant MongoDB DBA
Hadoop Admin
about this.
Thanks
--
Thanks
Suresh Kuna
MySQL DBA
Hello Shafi,
The below blog will give you more information on the error -
http://sureshkuna.blogspot.in/2010/12/aborted-connection-31084472-to-db-ms.html
Thanks
Suresh Kuna
On Mon, May 21, 2012 at 1:15 PM, Shafi AHMED shafi.ah...@sifycorp.comwrote:
Ladies and Gentlemen:
I am getting below
PM
To: 'Suresh Kuna'
Cc: 'mysql@lists.mysql.com'; 'shafi...@gmail.com'
Subject: RE: [Warning] Aborted connection.. (Got timeout reading
communication packets)
Hi suresh: I have gone through your blog..and feel it is more generic...
Can you please elaborate why the other setup(DR) works
--
Thanks
Suresh Kuna
MySQL DBA
.
--
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
/refman/5.0/en/forcing-innodb-recovery.html
Thanks
Suresh Kuna
2012/1/24 Suporte Avanutri supor...@avanutri.com.br
I've tried this before, but the server stills going down. The first error
is always this:
Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */* FROM 'usuario': Lost
connection to MySQL
Hi,
Try the 3 options available in the below URL option, i.e ignore built in
innodb and set the default storage engine to another storage engine.
http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#option_mysqld_ignore-builtin-innodb
Thanks
Suresh Kuna
MySQL DBA
2011/12/24
table1.id=
table2.id AND table1.value=table2.value)
For more details on intersect and minus, check this blog -
http://www.bitbybit.dk/carsten/blog/?p=71
Thanks
Suresh Kuna
On Sun, Oct 16, 2011 at 5:12 PM, Grega Leskovšek legr...@gmail.com wrote:
WHat is wring with the following three sentences
.
Navicat is good for the database work, but not for pretty reports.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
Hi,
The permanent solution is to convert the table into Innodb engine.
Thanks
Suresh Kuna
On Fri, Oct 14, 2011 at 1:00 PM, Mark Goodge m...@good-stuff.co.uk wrote:
On 14/10/2011 08:07, James wrote:
Hello,
I have the following error on my mysql server log and managed to repaired
Hello Shafi,
Adding to Prabhat alternatives, you can use --force to the mysqldump command
to ignore the errors and continue taking backup.
Regarding the error, we need to check whether the table is present or not
and the engine type specifically.
Thanks
Suresh Kuna
On Sat, Sep 24, 2011 at 3:31
you want this was and will always be the best solution
said this independent of the software becasue the only interesting fact is
if the can data migrated 100% consistent, every sort of export/import
is per design complexer, slower and maybe unsafer
--
Thanks
Suresh Kuna
MySQL DBA
Hi Prabhat,
FYI
On Thu, Sep 15, 2011 at 10:33 AM, Suresh Kuna sureshkumar...@gmail.comwrote:
If the hardware on master and slave, version of mysql server, configuration
and memory allocations are same then you can do a clean shutdown of mysql on
slave and copy the files to master. Check
SSDs,
mount it locally for MySQL. S On Tue, Sep 13, 2011 at 21:19, Suresh Kuna
sureshkumar...@gmail.com wrote: I would recommend to go for a 15K rpm
SSD raid-10 to keep the mysql data and add the Barracuda file format with
innodb file per table settings, 3 to 4 GB of innodb buffer pool depending
write_buffer = 8M
[mysqlhotcopy]
interactive-timeout
Regards
Maria
--
Thanks
Suresh Kuna
MySQL DBA
-file-formats.html
I would go with the Singer suggestions in What you want to do is part.
Thanks
Suresh Kuna
On Wed, Sep 14, 2011 at 7:21 AM, Singer X.J. Wang w...@singerwang.comwrote:
Comments:
1) There is no such thing as 15K RPM SSDs... SSDs are NON ROTATIONAL
STORAGE, therefore RPMS make
in in terms of clues
Andy.
Quoting Suresh Kuna sureshkumar...@gmail.com:
Can yo paste the complete error log, Ram memory size and configuration
file
here and make sure the machine has enough memory to run the services.
Check the sys log for what is happening just before the service
://lists.mysql.com/mysql?**
unsub=sureshkumar...@gmail.comhttp://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?**
unsub=eroomy...@gmail.com
http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
--
Thanks
Suresh Kuna
MySQL DBA
have
received this communication in error, please delete this mail notify us
immediately at ad...@sifycorp.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com
--
Thanks
Suresh
To unsubscribe:
http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
way of doing this with
out the cron job script?
--
Hez
--
Thanks
Suresh Kuna
MySQL DBA
=sureshkumar...@gmail.comhttp://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
On Thu, Jun 16, 2011 at 10:53 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
How we can create a deadlock manually to test this problem.
Thanks
Suresh Kuna wrote:
Good question Yogesh, I can say the best solution is
Create a deadlock and test it, you will come to know more about
occures and
both query are waiting to execute. What wil happen in that case?
1. Do the connection will wait till deadlock is removed or
2. Connection will close after 180 seconds as both queries are ideal and
waiting for each other.
Thanks,
Yogesh
--
Thanks
Suresh Kuna
MySQL DBA
| | NULL|
|
| lname | varchar(20)| NO | | NULL|
|
+-++--+-+-+-
---+
4 rows in set (0.00 sec)
Mimi
--
Thanks
Suresh Kuna
MySQL DBA
://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
.
Guidance needed
Thanks
Ramesh
--
Thanks
Suresh Kuna
MySQL DBA
...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
thinking to take backup in compressed format.
Thanks
Suresh Kuna wrote:
It really depends on What kind of backup you performed a month ago rather
than the type of tables at the moment...
On Thu, May 19, 2011 at 6:50 AM, Michael Dykman mdyk...@gmail.com
mdyk...@gmail.com wrote:
What
|
+--++--++
2 rows in set (0.00 sec)
But the SysEvents.frm is there in the datadir.
On 19 May 2011 09:35, Suresh Kuna sureshkumar...@gmail.com wrote:
use repair table table_name use_frm ; and try it out.
It needs to be run inside mysql.
On Thu
Can you paste the table files in the datadir and the execution part of the
below query.
On Thu, May 19, 2011 at 11:11 AM, Ramesh rames...@gmail.com wrote:
Lost all the records once i done the repair table with use_frm.
On 19 May 2011 10:30, Suresh Kuna sureshkumar...@gmail.com wrote:
Run
the repair table with use_frm.
On 19 May 2011 10:30, Suresh Kuna sureshkumar...@gmail.com wrote:
Run this - repair table SystemEvents use_frm ;
On Thu, May 19, 2011 at 10:24 AM, Ramesh rames...@gmail.com wrote:
mysql repair table SystemEvents.frm
Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
It will, try it out.
On Wed, Apr 20, 2011 at 1:11 PM, Brent Clark brentgclarkl...@gmail.comwrote:
Sorry
Would you be so kind as to explain your thinking.
How would upgrading Mysql fix the issue?
Regards
Brent Clark
On 20/04/2011 06:23, Suresh Kuna wrote:
Install the latest version
Okie cool, Can you paste the error log details when it came up with force
recovery 6.
On Wed, Apr 20, 2011 at 6:16 PM, Brent Clark brentgclarkl...@gmail.comwrote:
On 20/04/2011 10:10, Suresh Kuna wrote:
It will, try it out.
Thanks for replying.
My Colleague and I, we tried a different
/libc.so.6(clone+0x5e) [0xb6ded84e]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.htmlcontains
information that should help you find out what is causing the crash
--
Thanks
Suresh Kuna
MySQL DBA
Install the latest version of mysql on top of the current version and start
the database.
On Tue, Apr 19, 2011 at 9:34 PM, Brent Clark brentgclarkl...@gmail.comwrote:
Thanks for replying
5.1.55
On 19/04/2011 13:55, Suresh Kuna wrote:
What is the version of MYSQL you are using currently
--
Thanks
Suresh Kuna
MySQL DBA
:
http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
Suresh Kuna
MySQL DBA
by running it on different ports.
On Tue, Oct 19, 2010 at 10:42 PM, kranthi kranthikiran@gmail.comwrote:
Hi all,
How to install multiple instances in windows???
Thank you.
--
Thanks
Suresh Kuna
MySQL DBA
--
Thanks
Suresh Kuna
MySQL DBA
.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
--
Claudio
--
Thanks
Suresh Kuna
MySQL DBA
...@googlemail.com
Date: Tue, Oct 12, 2010 at 5:45 PM
Subject: Backing up the InnoDB tables
To: [MySQL] mysql@lists.mysql.com
Hi
On a shared MySQL server with access just to my own database, what is the
recommend backup methods and strategies for the InnoDB tables ?
Cheers
Neil
--
Thanks
Suresh Kuna
no
luck. Thanks for any help.
sangprabv
sangpr...@gmail.com
http://www.petitiononline.com/froyo/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
--
Thanks
Suresh Kuna
MySQL
://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
Suresh Kuna
MySQL DBA
space in one of the files before the last
auto-extending file, which these files are fixed sizes?
Both servers are 5.0.77-log. One server is Cent OS, the other is RHEL.
I'm very confused here.
JW
On Mon, Aug 2, 2010 at 1:53 PM, Suresh Kuna sureshkumar...@gmail.comwrote:
Hey john,
Yes
*
Or will that cause MySQL to complain the file size isn't correct the next
time it starts?
Thanks for any help!
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
Thanks
Suresh Kuna
MySQL DBA
...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
unless and until if the variable is read-only, you don't need Lin.
On Mon, May 31, 2010 at 3:17 PM, Lin Chun franks1...@gmail.com wrote:
hi
as the title
thanks
--
-
Lin Chun
--
Thanks
Suresh Kuna
MySQL DBA
://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
with a new MySQL 5.x
server, is it possible?
What do I need to change on my MySQL 5.x server to allow old clients to
work?
Also, what do I need to change to allow old PHP 4.x code to talk to a MySQL
5.x server?
Thanks,
POL.
--
Thanks
Suresh Kuna
MySQL DBA
, Apr 13, 2010 at 2:21 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
hi all
what is the difference between
OPTIMIZE TABLE tablename;
and
ANALYZE TABLE tablename;
thank you
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
--
Thanks
Suresh Kuna
MySQL DBA
of the AUTO_INCREMENT counter to be used for new rows,
do this:
ALTER TABLE t2 AUTO_INCREMENT = value;
You cannot reset the counter to a value less than or equal to any that have
already been used.
Thanks
Suresh Kuna
that host alone.
--
Thanks
Suresh Kuna
MySQL DBA
2010/3/2 PengXiaoxun fikm...@163.com
I create a new account via the following statement:
CREATE USER 'monty'@'%' IDENTIFIED BY '123456';
Without any privileges granted, the user 'monty' can access the database
information_schema via a remote
Hi Robert,
We can see the functions by using the below command
Show function status ;
--
Suresh Kuna
MySQL DBA
On Mon, Feb 8, 2010 at 10:37 AM, Sir Wally Lewis robert.gill...@basx.com.au
wrote:
How do I get a list of all defined UDF's known to the system?
Kind Regards,
Robert
Suresh Kuna
MySQL DBA
-u name -p password database_name backup.sql;
but i am getting error.. i am using windows xp system.. please help me
--
Thanks
Suresh Kuna
MySQL DBA
Hi Murali,
We can switch to another user only by a new connection and not possible in
mysql prompt.
Thanks
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 2:24 PM, muralikrishna g
muralikrishn...@gmail.comwrote:
i am working on my pc with mysql-5.0.27-community-nt
i have created users by using
Which OS your are using ?
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 2:25 PM, muralikrishna g
muralikrishn...@gmail.comwrote:
i am working on my pc with mysql-5.0.27-community-nt
i have created several data bases and tables in that.. to take backup, we
have to use dump., i dont know
Not a problem as you are doing it from a whole data directory.
Thanks
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 11:56 AM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi All,
I am creating symlinks as database.
I have mysql data directory created on /var/lib/mysql
and the newly created and old databases use the
same datadir
Thanks
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 9:22 AM, Carlos Proal carlos.pr...@gmail.comwrote:
As Suresh and others said, you have to stop the dbms, move to content of
the dir and restart the dbms.
Also, if you have
to supply
the old password apart from the new one as well.
For more details, check the below link
http://code.google.com/p/securich/wiki/Documentation
Thanks,
Suresh Kuna
MySQL DBA
On Fri, Jan 22, 2010 at 11:52 PM, Tompkins Neil
neil.tompk...@googlemail.com wrote:
Hi
Thanks for all the responses
Suresh Kuna
MySQL DBA
On Mon, Jan 25, 2010 at 6:06 PM, Wagner Bianchi
wagnerbianch...@gmail.comwrote:
Hi friends,
Last weekend I made an environment that use a MySQL Server version 4.1 that
was defined to be the MASTER and other one version 5.1 defined as SLAVE.
Because the application
Did you check the server load when it took 10 min.
Check the query log, number of connections and the number of queries in
query log at that time.
We need to analyze the system with the collected data what we have for
monitoring.
Thanks
Suresh Kuna
On Fri, Jan 22, 2010 at 12:25 PM, madunix madu
Hi Krishna,
As table is using MyISAM engine and it acquires a table level lock, the
queries will be executed one after one .
By converting it into Innodb as it acquires a row level lock, doing a select
and delete based on primary key will be faster and the concurrency
increases.
--
Thanks
Suresh
,
Krishna
On Thu, Jan 21, 2010 at 4:46 PM, Suresh Kuna sureshkumar...@gmail.comwrote:
Hi Krishna,
As table is using MyISAM engine and it acquires a table level lock, the
queries will be executed one after one .
By converting it into Innodb as it acquires a row level lock, doing a
select
?unsub=sureshkumar...@gmail.com
--
Thanks
Suresh Kuna
MySQL DBA
Hi Manasi,
That alone is the difference in this case.
--
Thanks
Suresh Kuna
MySQL DBA
On Tue, Jan 19, 2010 at 10:36 AM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Dear Carlos,
Thanks for the response. But I haven't gave any privileges besides
repl_slave priv to user replication
. is there any parameter
where I can set this. that after every 60 seconds slave should write data
from master to its own local database.
--
Regards,
Manasi Save
Quoting Suresh Kuna sureshkumar...@gmail.com:
Hi Manasi,
As both are implemented by replication, there is a possibility for loosing
data
Hi Manasi,
As both are implemented by replication, there is a possibility for loosing
data.
Thanks
Suresh Kuna
MySQL DBA
On Wed, Jan 13, 2010 at 8:20 PM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi All,
I want to implement MySQL Master Master Replication. But I have read
the same. Configure the replication
between the two server.
By doing this, We will save the import time in second server.
Thanks
Suresh Kuna
MySQL DBA
On Wed, Jan 13, 2010 at 3:58 AM, Tom Worster f...@thefsb.org wrote:
Frankly, I didn't entirely understand what you were proposing. I got lost
around
Blog: http://oradbapro.blogspot.com
--
Thanks
Suresh Kuna
MySQL DBA
dictionary will get
effected.
Thanks
Suresh Kuna
MySQL DBA
On Thu, Jan 7, 2010 at 9:46 AM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi Johan,
Is it possible to do such manipulation in NDB, the way innodb works.
Thanks in advance.
--
Regards,
Manasi Save
Quoting Johan
Hi Faizal,
Max_connections are the connections for the overall MySQLD server.
Max_user_connections are the connections for the particular user ( i.e for
an account ) of the MySQLD server.
Suresh Kuna
MySQL DBA
On Thu, Jan 7, 2010 at 11:00 AM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
Dear all
in advance..
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Thu, Jan 7, 2010 at 11:27 AM, Suresh Kuna sureshkumar...@gmail.comwrote:
Hi Faizal,
Max_connections are the connections for the overall MySQLD server.
Max_user_connections are the connections
Hi Jeetendra,
What is the error it it saying in error log ?
Is this the fresh installation or already installed MySQL ?
Thanks
Suresh Kuna
MySQL DBA
On Mon, Jan 4, 2010 at 10:16 AM, Jeetendra Ranjan
jeetendra.ran...@sampatti.com wrote:
Hi,
I am using MySQL 5.0.85-community on Fedora 8
' to avoid this problem.
100102 1:18:32 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
Thanks
Jeetendra Ranjan
- Original Message -
*From:* Suresh Kuna sureshkumar...@gmail.com
Hi Jeetendra,
Check the below url for details with the raw partition.
http://dev.mysql.com/doc/refman/5.4/en/innodb-raw-devices.html
Thanks
Suresh Kuna
MySQL DBA
On Mon, Jan 4, 2010 at 11:06 AM, Suresh Kuna sureshkumar...@gmail.comwrote:
Jeetendra,
Give the MySQLD user permissions to the new
Try this : /dev/sda3:10Graw;/dev/sda1:5Graw
Change the newraw to raw and start the MySQL.
and paste the error log ouput.
Thanks
Suresh Kuna
MySQL DBA
On Mon, Jan 4, 2010 at 12:37 PM, Jeetendra Ranjan
jeetendra.ran...@sampatti.com wrote:
Hi Suresh,
Thanks, this link we already have
89 matches
Mail list logo