Re: MySQL Platform Migration

2016-09-10 Thread Suresh Rajagopal
Hi Reindl, Is the mysql datafile compatible with different operation system ? I have not done this in the past. Regarding cross-post, mysql list was bouncing due to html email format. Didn't realize until today. That's why posted in mariadb. Thanks Suresh - Original Message - From

MySQL Platform Migration

2016-09-10 Thread Suresh Rajagopal
Hi, Is there any documentation for migrating mysql 5.0 database from darwin to Linux. Thanks Suresh Rajagopal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: deleting big tables

2015-05-17 Thread Suresh Kuna
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

Re: deleting big tables

2015-05-16 Thread 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

Re: Replication problem

2014-08-29 Thread Suresh Kuna
://lists.mysql.com/mysql -- -- Thanks Suresh Kuna MySQL Database Consutant MongoDB DBA Hadoop Admin

Re: Understanding Slow Query Log

2012-09-01 Thread Suresh Kuna
about this. Thanks -- Thanks Suresh Kuna MySQL DBA

Re: [Warning] Aborted connection...... (Got timeout reading communication packets)

2012-05-21 Thread Suresh Kuna
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

Re: [Warning] Aborted connection...... (Got timeout reading communication packets)

2012-05-21 Thread Suresh Kuna
This needs to be investigated on the server, and cannot be guessed. On Mon, May 21, 2012 at 2:29 PM, Shafi AHMED shafi.ah...@sifycorp.comwrote: Sorry- a typo :) Hi suresh: I have gone through your blog..and feel it is more generic... Can you please elaborate why the other setup(DR) works

Re: Keynote videos from Percona Live MySQL Conference

2012-04-13 Thread Suresh Kuna
-- Thanks Suresh Kuna MySQL DBA

Re: How to interrupt MySQL interpreter output?

2012-01-26 Thread Suresh Kuna
. -- 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: RES: Force drop table

2012-01-24 Thread Suresh Kuna
/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

Re: how to make MyISAM as default engine for MySQL 5.6.4?

2011-12-24 Thread Suresh Kuna
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

Re: [MYSQL] INTERSECT, MINUS

2011-10-16 Thread Suresh Kuna
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

Re: Additional Software to Download and Install

2011-10-15 Thread Suresh Kuna
. 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

Re: Databasename/Tablename is marked as crashed and should be repaired

2011-10-14 Thread Suresh Kuna
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

Re: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES

2011-09-24 Thread Suresh Kuna
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

Re: Moving database from one machine to another machine..

2011-09-14 Thread Suresh Kuna
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

Re: Moving database from one machine to another machine..

2011-09-14 Thread Suresh Kuna
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

Re: Question about slow storage and InnoDB compression

2011-09-14 Thread Suresh Kuna
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

Re: Question about slow storage and InnoDB compression

2011-09-13 Thread Suresh Kuna
write_buffer = 8M [mysqlhotcopy] interactive-timeout Regards Maria -- Thanks Suresh Kuna MySQL DBA

Re: Question about slow storage and InnoDB compression

2011-09-13 Thread Suresh Kuna
-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

Re: MySQL daemons restarting every 7 minutes

2011-09-09 Thread Suresh Kuna
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

Re: MySQL daemons restarting every 7 minutes

2011-09-09 Thread Suresh Kuna
://lists.mysql.com/mysql?** unsub=sureshkumar...@gmail.comhttp://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA

Re: trying to change wait_timeout

2011-09-08 Thread Suresh Kuna
. -- 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

Re: strange mysql update ..

2011-09-08 Thread Suresh Kuna
://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA

Re: MySQL daemons restarting every 7 minutes

2011-09-08 Thread Suresh Kuna
-- Thanks Suresh Kuna MySQL DBA

Re: Reg...My Hung MYSQL instance

2011-08-23 Thread Suresh Kuna
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

Re: mysql

2011-08-23 Thread Suresh Kuna
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

Re: about the config file

2011-08-02 Thread Suresh Kuna
/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA

Re: Deleting records older than X hours

2011-08-01 Thread Suresh Kuna
way of doing this with out the cron job script? -- Hez -- Thanks Suresh Kuna MySQL DBA

Re: How to view Query Execution time

2011-08-01 Thread Suresh Kuna
=sureshkumar...@gmail.comhttp://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA

Re: Query on wait_timeout

2011-06-16 Thread Suresh Kuna
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

Re: Query on wait_timeout

2011-06-15 Thread Suresh Kuna
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

Re: MySQL ignores foreign key constraints

2011-05-20 Thread Suresh Kuna
| | NULL| | | lname | varchar(20)| NO | | NULL| | +-++--+-+-+- ---+ 4 rows in set (0.00 sec) Mimi -- Thanks Suresh Kuna MySQL DBA

Re: Restore only one database or one table

2011-05-18 Thread Suresh Kuna
://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA

Re: MyISAM Repair table problem

2011-05-18 Thread Suresh Kuna
. Guidance needed Thanks Ramesh -- Thanks Suresh Kuna MySQL DBA

Re: Test mail

2011-05-18 Thread Suresh Kuna
...@gmail.com -- Thanks Suresh Kuna MySQL DBA

Re: Restore only one database or one table

2011-05-18 Thread Suresh Kuna
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

Re: MyISAM Repair table problem

2011-05-18 Thread Suresh Kuna
| +--++--++ 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

Re: MyISAM Repair table problem

2011-05-18 Thread Suresh Kuna
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

Re: MyISAM Repair table problem

2011-05-18 Thread Suresh Kuna
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

Re: LEFT JOIN and WHERE: identical or not and what is better?, etc.

2011-04-26 Thread Suresh Kuna
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

Re: Mysql issue / crashing

2011-04-20 Thread Suresh Kuna
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

Re: Mysql issue / crashing

2011-04-20 Thread Suresh Kuna
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

Re: Mysql issue / crashing

2011-04-19 Thread Suresh Kuna
/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

Re: Mysql issue / crashing

2011-04-19 Thread Suresh Kuna
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

Re: Replication issue

2011-02-16 Thread Suresh Kuna
-- Thanks Suresh Kuna MySQL DBA

Re: Issue while SymLinking a Database

2011-01-02 Thread Suresh Kuna
: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA

Re: Purposely Corrupting a table

2010-10-19 Thread Suresh Kuna
Suresh Kuna MySQL DBA

Re: How to install multiple instances in windows

2010-10-19 Thread Suresh Kuna
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

Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!

2010-10-15 Thread Suresh Kuna
-- Thanks Suresh Kuna MySQL DBA

Re: multiple mysql installations - Install mysql from source with a prefix

2010-10-15 Thread Suresh Kuna
. -- 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

Re: Backing up the InnoDB tables

2010-10-13 Thread Suresh Kuna
...@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

Re: InnoDB Crash

2010-10-12 Thread 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

Re: Backup

2010-10-10 Thread Suresh Kuna
://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA

Re: Kill All Proccesses

2010-09-29 Thread Suresh Kuna
Suresh Kuna MySQL DBA

Re: InnoDB Tablespace

2010-08-03 Thread Suresh Kuna
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

Re: InnoDB Tablespace

2010-08-02 Thread Suresh Kuna
* 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

Re: Which tool to use for developing Pl/Sql on MySQL?

2010-07-15 Thread Suresh Kuna
...@gmail.com -- Thanks Suresh Kuna MySQL DBA

Re: Replication of MySQL Stored Procedure

2010-06-08 Thread Suresh Kuna
: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA

Re: do i have to restart the mysql server when i change some global variables?

2010-05-31 Thread Suresh Kuna
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

Re: How to corrupt a database please???

2010-04-18 Thread Suresh Kuna
://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA

Re: MySQLClient 3.x compatible with MySQL 5.x?

2010-04-13 Thread Suresh Kuna
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

Re: difference btw Analyze and Optimize table..

2010-04-13 Thread Suresh Kuna
, 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

setting auto_increment value with a local variable

2010-03-19 Thread Suresh Kuna
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

Re: Default privileges of a new user?

2010-03-01 Thread 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

Re: How do I get a list of all defined UDF's known to the system?

2010-02-07 Thread Suresh Kuna
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

Re: how to view all acounts in a database

2010-02-05 Thread Suresh Kuna
Suresh Kuna MySQL DBA

Re: hi help to take backup-mysql-windows-xp

2010-02-01 Thread Suresh Kuna
-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

Re: how to switch between users

2010-01-29 Thread Suresh Kuna
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

Re: how to dump database or tables

2010-01-29 Thread Suresh Kuna
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

Re: Using symlinks for database creation in mysql

2010-01-28 Thread Suresh Kuna
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

Re: How to change mysql default database directory

2010-01-28 Thread Suresh Kuna
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

Re: Record old passwords ?

2010-01-27 Thread Suresh Kuna
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

Re: Problems with slave_skip_errors on replication

2010-01-25 Thread Suresh Kuna
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

Re: mysql update

2010-01-22 Thread Suresh Kuna
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

Re: Selecting, Inserting and Deleting data

2010-01-21 Thread Suresh Kuna
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

Re: Selecting, Inserting and Deleting data

2010-01-21 Thread Suresh Kuna
Innodb contains multi-version property, so it can handle more concurrent queries from user connections. On Thu, Jan 21, 2010 at 5:07 PM, Krishna Chandra Prajapati prajapat...@gmail.com wrote: Hi Suresh, my question is how i can run concurrent connection with the above work load. Thanks

Re: Performance Innodb my.cnf

2010-01-18 Thread Suresh Kuna
?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA

Re: MySQL Replication Delete is not gettting replicated

2010-01-18 Thread Suresh Kuna
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

Re: MySQL Master Master Replication and data loss

2010-01-14 Thread Suresh Kuna
to be lack for a particular period of time. On Thu, Jan 14, 2010 at 2:11 PM, Manasi Save manasi.s...@artificialmachines.com wrote: Dear Suresh, Thank you. In MySQL Replication, as the slave itself takes the writes from master but in how much time period does slave goes to master

Re: MySQL Master Master Replication and data loss

2010-01-13 Thread Suresh Kuna
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

Re: upgrading mysql

2010-01-12 Thread Suresh Kuna
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

Re: Are there any difference between max_connection and max_user_connection?

2010-01-07 Thread Suresh Kuna
Blog: http://oradbapro.blogspot.com -- Thanks Suresh Kuna MySQL DBA

Re: mysql Create table in system database

2010-01-06 Thread Suresh Kuna
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

Re: Are there any difference between max_connection and max_user_connection?

2010-01-06 Thread Suresh Kuna
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

Re: Are there any difference between max_connection and max_user_connection?

2010-01-06 Thread Suresh Kuna
on the queries that your application hits the database. On Thu, Jan 7, 2010 at 12:20 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote: hi Suresh thanks. max_connection=100(default). so, it won't allow user more than 100? and one more clarification. i am facing performance issue in mysqld. some time

Re: innodb_data_file_path

2010-01-03 Thread Suresh Kuna
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

Re: innodb_data_file_path

2010-01-03 Thread Suresh Kuna
Jeetendra, Give the MySQLD user permissions to the new directory which you are specifying. On Mon, Jan 4, 2010 at 10:57 AM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi Suresh, The error log show the related error as below InnoDB: File name /dev/sda3 InnoDB: File

Re: innodb_data_file_path

2010-01-03 Thread Suresh Kuna
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

Re: innodb_data_file_path

2010-01-03 Thread Suresh Kuna
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

Symbol resolution failed for /usr/local/lib/libz.so.

2007-04-24 Thread suresh kumar
to resolve this issue. Thanks In Advance Suresh. - Check out what you're missing if you're not on Yahoo! Messenger

Repair or Optimize -- MyISAM tables

2005-04-12 Thread Suresh
Hi Team, I would like to rebuild the tables which one will be suitable repair or optimize. Please suggest. Thanks in advance. Thanks Suresh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql Deamon Stop Automatically

2005-03-10 Thread Suresh
Hi Team, My Server's deamon goes down automatically, what are the basic steps to root cause. Thanks Suresh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql Kit

2004-10-09 Thread Suresh
Hi Team, I am in need of mysql alpha 4.0.0, i have searched mysql.com but i couldn't find it. Can anyone help me out, by reffering out a good site. Thanks Suresh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Duplicate Entries

2004-09-22 Thread Suresh
Hi, Yes ofcourse it is a primary key with two fields. The insert exists whenever it has a duplicate entry, it doesn't continue with further records. Is there any scope to resolve it. Thanks Suresh Eldo Skaria wrote: Hi, Suresh may be expressing that he has a primary key with two fields

Duplicate Entries

2004-09-21 Thread Suresh
it ? Thanks in advance, Suresh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Unable to start MYSQL

2003-08-29 Thread Suresh Babu A. [IT Engineer]
Hi Team, I couldn't start the mysql in the red hat 8, due the bad configuration in my.cnf and non availability of data file for the database. I want to reinstall the mysql, kindly let me know how to. I have also tried rmp -e File.rpm' and removed the files from /var/lib/mysql. Reinstalled

Unable to start MYSQL

2003-08-28 Thread Suresh Babu A. [IT Engineer]
Hi Team, I am unable to start the mysql service at my red hat 8, below is the error. What it is all about ? /usr/sbin/mysqld: ERROR: unknown option '--log-bin # required for re plication' 030829 01:01:37 mysqld ended Thanks in advance Suresh A. -- MySQL General Mailing List

can't install mysql-4.0.3 with innodb

2002-09-08 Thread suresh
Hello I just installed mysql 4.0.3-beta for innoDB 1.I deleted my existing mysql4.0.3, my.ini and my.cnf files 2.I created a new my.cnf file and copied to c:\winnt directory The contents being # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all

  1   2   >