Mysql Deamon Stop Automatically

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]

Repair or Optimize -- MyISAM tables

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 Kit

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/[

Duplicate Entries

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

Re: Duplicate Entries

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 w

Help to Join 5 tables

me of you can help me and thanks in advance Kayamboo suresh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail &l

Help to join 5 tables

Hope that some of you can help me and thanks in advance Kayamboo suresh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thre

Joining Tables

unique not null , pro_pd varchar(16) unique not null); 5.CREATE TABLE claim(claim_id int auto_increment primary key, user_id varchar(20) not null, don_id varchar(20) not null, pro_pd varchar(20) not null, claim_date date not null, claim_det text not null) ; thanks in advance kayam

Join with Union

Hi I changed from mysql 3.23.49 -nt to 4.0.2 max to make use of union But one problem when trying to join tables is that UNION works only for SELECT queries with same number of coulmns. Is there any way to join 3 or more tables having different columns using UNION? I am writing my query dur

Re: mysql default charset

Go to mysqlAdmin Go to my.ini setup add language = MYSQL_HOME/share/your_language_here Save the changes Hope this will help regards KayambooSuresh At 11:33 Χ΋ 02/09/01 +0300, you wrote: >Hi, >How can I set my mysqld-nt.exe to run different charset >for example cp1251. >I tried mysqld-nt.e

can't install mysql-4.0.3 with innodb

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 lon

make problems on solaris 8 x86

Hello I am installing mysql 3.23.37 on solaris 8 x86. I am having problem with strings-x86.s when running make Has anybody come accross this problem and is there a work around I am using gtar and gmake Thanx in advance Suresh

FW: make problems on solaris 8 x86

Can anybody help me with this please -Original Message- From: suresh [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 2:20 PM To: [EMAIL PROTECTED] Subject: make problems on solaris 8 x86 Hello I am installing mysql 3.23.37 on solaris 8 x86. I am having problem with strings-x86

Re: innodb_data_file_path

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-commun

Re: innodb_data_file_path

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

Re: innodb_data_file_path

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 wrote: > Jeetendra, > > Give the MySQLD user permissions to the new directory

Re: innodb_data_file_path

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

Re: mysql Create table in system database

me but the data 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

Re: Are there any difference between max_connection and max_user_connection?

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 wrote: > Dear all > >

Re: Are there any difference between max_connection and max_user_connection?

n the queries that your application hits the database. On Thu, Jan 7, 2010 at 12:20 PM, F.A.I.Z.A.L 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. som

Re: Are there any difference between max_connection and max_user_connection?

; > > Cheers > Faizal S > GSM : 9840118673 > Blog: http://oradbapro.blogspot.com > > > -- Thanks Suresh Kuna MySQL DBA

Re: upgrading mysql

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 wrote: > Frankly, I didn't entirely understand what you were proposing. I got lost > ar

Re: MySQL Master Master Replication and data loss

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 Replicatio

Re: MySQL Master Master Replication and data loss

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

Re: Performance Innodb my.cnf

> innodb_write_io_threads = 16 > innodb_support_xa = false > innodb_io_capacity = 1 > innodb_max_dirty_pages_pct = 90 > > concurrent_insert = 2 > > -- > 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: MySQL Replication Delete is not gettting replicated

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 >

Re: Selecting, Inserting and Deleting data

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

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 ab

Re: mysql update

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

Re: Problems with slave_skip_errors on replication

Suresh Kuna MySQL DBA On Mon, Jan 25, 2010 at 6:06 PM, Wagner Bianchi wrote: > 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 that w

Re: Record old passwords ?

a user to change one's old password, the user needs 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 < ne

Re: Using symlinks for database creation in mysql

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 c

Re: How to change mysql default database directory

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 wrote: > 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 a fresh ins

Re: how to switch between users

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 wrote: > i am working on my pc with mysql-5.0.27-community-nt > i have created users by using create user and i

Re: how to dump database or tables

Which OS your are using ? Suresh Kuna MySQL DBA On Fri, Jan 29, 2010 at 2:25 PM, muralikrishna g wrote: > 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 the correct s

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

-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 view all acounts in a database

In the mysql prompt, execute the below use mysql ; select user from user ; will show all the accounts in a MySQL database. On Fri, Feb 5, 2010 at 5:27 PM, ishaq gbola wrote: > Hi Guys, > > Which command can allow me view all accounts in a Mysql database > > > > -

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

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 wrote: > How do I get a list of all defined UDF's known to the system? > > > > Kind Regards, > > >

Re: Default privileges of a new user?

an only connect from that host alone. -- Thanks Suresh Kuna MySQL DBA 2010/3/2 PengXiaoxun > I create a new account via the following statement: > CREATE USER 'monty'@'%' IDENTIFIED BY '123456'; > Without any privileges granted, the user 'monty'

setting auto_increment value with a local variable

hange the value 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: MySQLClient 3.x compatible with MySQL 5.x?

ith 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..

, Apr 13, 2010 at 2:21 PM, F.A.I.Z.A.L 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

Re: How to corrupt a database please???

ves: 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?

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 wrote: > hi > > as the title > > thanks > > -- > - > Lin Chun > -- Thanks Suresh Kuna MySQL DBA

Re: Replication of MySQL Stored Procedure

what should I do? >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net >> >> > -- > 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: Which tool to use for developing Pl/Sql on MySQL?

sts.mysql.com/mysql?unsub=sureshkumar...@gmail.com > > -- Thanks Suresh Kuna MySQL DBA

Re: InnoDB Tablespace

> > innodb_data_file_path=ibdata1:1G;ibdata2:1G;ibdata3:1G;ibdata4:1G;ibdata5:1G;ibdata6:16G; > *ibdata7:16G* > > 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: InnoDB Tablespace

s 3.9 GB? Could this > be because it's filling up 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 > > O

Re: Kill All Proccesses

mysql > > To unsubscribe: > http://lists.mysql.com/mysql?unsub=ekilimc...@gmail.com > > > > > > > > > > -- > > Best regards, > > > > Eugene Kilimchuk > > -- Thanks Suresh Kuna MySQL DBA

Re: Backup

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: InnoDB Crash

and recreate the database but still 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: >

Re: Backing up the InnoDB tables

, 2010 at 5:45 PM > Subject: Backing up the InnoDB tables > To: "[MySQL]" > > > 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 MySQL DBA

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

> 'time_zone_name' > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/mysql?unsub=joh...@pixelated.net > > > > > > > -- > - > Johnny Withers > 601.209.4985 > joh...@pixelated.net > -- Thanks Suresh Kuna MySQL DBA

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

gt; >> > > >> So what configure options do i need if i want to install mysql > > >> seperatly in a folder? > > >> Do i also need --datadir? If yes, where sould my data dir be? In > > >> /usr/local/mysql-5.1.42/var? > > >> > > >> Thanks a lot, > > >> Mario > > >> > > > -- > > > Regards, > > > > > > Himanshu Raina > > > -- > > > Guillotine, n.: > > >A French chopping center. > > > > > > > > > > -- > > 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: Purposely Corrupting a table

m it, or the responce back from a select is an error? > >> > >> > >> > > -- > 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: How to install multiple instances in windows

by running it on different ports. On Tue, Oct 19, 2010 at 10:42 PM, kranthi wrote: > Hi all, > >How to install multiple instances in windows??? > > > > Thank you. > > -- Thanks Suresh Kuna MySQL DBA

Re: Issue while SymLinking a Database

t; Adarsh Sharma > > -- > 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: Replication issue

7;s of members. If I understand the problem, it is caused by > blob containing a character which is the same character that is used to mark > the end of a transaction in the bin log. > > My questions: 1) Is this a reasonable/correct analysis and 2) how do I work > around the issue? > > Thanks, > > Carl > > > > > -- Thanks Suresh Kuna MySQL DBA

Re: Mysql issue / crashing

ysqld(page_cur_parse_insert_rec+0x580) [0xb7500390] > mysqld [0xb74ea325] > mysqld(recv_recover_page+0x502) [0xb74ec2e2] > mysqld(buf_page_io_complete+0x624) [0xb74a22e4] > mysqld(fil_aio_wait+0x12d) [0xb74bdb8d] > mysqld [0xb7533d80] > /lib/i686/cmov/libpthread.so.0 [0xb6ffd4c0] > /lib/i686/cmov/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

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 wrote: > Thanks for replying > > 5.1.55 > > > On 19/04/2011 13:55, Suresh Kuna wrote: > > What is the version of MYSQL you are using cur

Re: Mysql issue / crashing

It will, try it out. On Wed, Apr 20, 2011 at 1:11 PM, Brent Clark wrote: > 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: > >

Re: Mysql issue / crashing

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 wrote: > On 20/04/2011 10:10, Suresh Kuna wrote: > >> It will, try it out. >> > > Thanks for replying. > > My Colleague and I, we t

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

> SELECT `Blogs`.* FROM `Blogs` JOIN `Users` ON `Blogs`.`UserId` = > `Users`.`Id` > > That is, if you already had a table with the joined outcome, you would use > the WHERE-clause to determine what of it enters into further processing. > > > -- > 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: Restore only one database or one table

> -- > - michael dykman > - mdyk...@gmail.com > > May the Source be with you. > > -- > 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: MyISAM Repair table problem

9573240; Skipped > Data records: 82882799 > > What might be the problem and how to make the table repair successfully. > > Guidance needed > > Thanks > Ramesh > -- Thanks Suresh Kuna MySQL DBA

Re: Test mail

unsub=sureshkumar...@gmail.com > > -- Thanks Suresh Kuna MySQL DBA

Re: Restore only one database or one table

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 > wrote: >

Re: MyISAM Repair table problem

SysEvents.frm | repair | error| > Corrupt| > > +--++--++ > 2 rows in set (0.00 sec) > > But the SysEvents.frm is there in the datadir. > > > > On 19 May 2011 09:35, Suresh Kuna wrote: > >> use repair table table_name use_f

Re: MyISAM Repair table problem

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 wrote: > > Lost all the records once i done the repair table with use_frm. > > On 19 May 2011 10:30, Suresh Kuna wrote: > >> Run this - repa

Re: MyISAM Repair table problem

epair table with use_frm. >> >> On 19 May 2011 10:30, Suresh Kuna wrote: >> >>> Run this - repair table SystemEvents use_frm ; >>> >>> >>> On Thu, May 19,

Re: MySQL ignores foreign key constraints

umint(10) unsigned | NO | PRI | NULL| > auto_increment | > | fname | varchar(20)| NO | | NULL| > | > | initial | varchar(5) | YES | | NULL| > | > | lname | varchar(20)| NO | | NULL| > | > > +-++--+-+-+- > ---+ > 4 rows in set (0.00 sec) > > > Mimi > -- Thanks Suresh Kuna MySQL DBA

Re: Query on wait_timeout

ock 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: Query on wait_timeout

Thu, Jun 16, 2011 at 10:53 AM, Adarsh Sharma wrote: > 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 c

Re: Deleting records older than X hours

re elegant way of doing this with > out the cron job script? > > > > -- > > Hez > -- Thanks Suresh Kuna MySQL DBA

Re: How to view Query Execution time

.mysql.com/mysql?** > unsub=sureshkumar...@gmail.com<http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com> > > -- Thanks Suresh Kuna MySQL DBA

Re: about the config file

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: Reg...My Hung MYSQL instance

l & 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 Kuna MySQL DBA

Re: mysql

me with the local client. > >> > >> Ciao Mad! > >> > >> Claudio > >> > >> > >> > >> 2011/8/23 Andrew Moore > >> > >> > >>> > >>> That's too bad. How did you configure things? What trouble shooting > have > >>> you > >>> done so far? > >>> On Aug 23, 2011 9:18 AM, "madu...@gmail.com" > wrote: > >>> > >>>> > >>>> When I try to start my mysql DB I keep getting the following message: > >>>> "Can't connect to local MySQL server through socket > >>>> '/var/run/mysqld/mysqld.sock'" > >>>> > >>>> Thanks > >>>> > >>>> -- > >>>> MySQL General Mailing List > >>>> For list archives: http://lists.mysql.com/mysql > >>>> 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: trying to change wait_timeout

before and after > > show variables like 'wait_time%' returns 28800. Most confusing. > > > > > > > > > > -- > > 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 ..

' AND 1; > +---+ > | 'a' AND 1 | > +---+ > | 0 | > +---+ > 1 row in set, 1 warning (0.03 sec) > > DB 5.1.58-1-log:(none) mysql> SHOW WARNINGS; > +-+--+---+ > | Level | Code | Message | > +-+--+---+ > | Warning | 1292 | Truncated incorrect DOUBLE value: 'a' | > +-+--+---+ > 1 row in set (0.01 sec) > -- > Rik Wasmus > > -- > 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: MySQL daemons restarting every 7 minutes

vance, > > Andy. > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?** > unsub=sureshkumar...@gmail.com<http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com> > > -- Thanks Suresh Kuna MySQL DBA

Re: MySQL daemons restarting every 7 minutes

x27;t giving me much to go in in terms of clues.... > > Andy. > > > Quoting Suresh Kuna : > > 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. >> >

Re: MySQL daemons restarting every 7 minutes

'mysql-bin.002830' at > position 293541 > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?** > unsub=sureshkumar...@gmail.com<http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com> > > -- Thanks Suresh Kuna MySQL DBA

Re: Question about slow storage and InnoDB compression

tional_mem_pool_size = 32M > > [mysqldump] > max_allowed_packet = 16M > > [mysql] > no-auto-rehash > > [isamchk] > key_buffer = 1250M > sort_buffer_size = 384M > read_buffer = 8M > write_buffer = 8M > > [myisamchk] > key_buffer = 1250M > sort_buffer_size = 384M > read_buffer = 8M > write_buffer = 8M > > [mysqlhotcopy] > interactive-timeout > > > Regards > > Maria > -- Thanks Suresh Kuna MySQL DBA

Re: Question about slow storage and InnoDB compression

-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 wrote: > Comments: > 1) There is no such thing as 15K RPM SSDs... SSDs are NON ROTATIONAL > STORAGE, therefore RPMS

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

> 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..

Hi Prabhat, FYI On Thu, Sep 15, 2011 at 10:33 AM, Suresh Kuna wrote: > 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 if any memories

Re: Question about slow storage and InnoDB compression

MB or 512MB x 2 InnoDB log files. 2) dump and import the database > using innodb_file_per_table so that optimization will free up space.. 3) are > you running Bacula on the server as well? If so, decrease the buffer pool to > 1-2GB.. if not bump it up to to 3GB as you need some memory for b

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

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: Databasename/Tablename is marked as crashed and should be repaired

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 wrote: > On 14/10/2011 08:07, James wrote: > >> Hello, >> >> I have the following error on my mysql server log and managed to repa

Re: Additional Software to Download and Install

ata. The tables are going to be fairly simple. > <<<<<<<< > 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: [MYSQL] INTERSECT, MINUS

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 wrote: > WHat is wring with the following three sentences? > &g

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

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: RES: Force drop table

/refman/5.0/en/forcing-innodb-recovery.html Thanks Suresh Kuna 2012/1/24 Suporte Avanutri > 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': Los

Re: How to interrupt MySQL interpreter output?

gt; 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: Keynote videos from Percona Live MySQL Conference

To unsubscribe: http://lists.mysql.com/mysql > > -- Thanks Suresh Kuna MySQL DBA

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

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 wrote: > Ladies and Gentlemen: > > I am getting below errors and

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

This needs to be investigated on the server, and cannot be guessed. On Mon, May 21, 2012 at 2:29 PM, Shafi AHMED wrote: > 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 f

Re: Understanding Slow Query Log

; # Query_time: 120.000259 Lock_time: 0.00 Rows_sent: 1 Rows_examined: > 0 > SET timestamp=1346443103; > SELECT SLEEP(120); > > And also my slow log is increasing and decided to purge thorogh below > command : > > cat /dev/null > /var/lib/mysql/slow-queries.log > > > Anyone any ideas about this. > > > Thanks > -- Thanks Suresh Kuna MySQL DBA

Re: Replication problem

unning fine, but the transactions do not appear to appear on the > slave. > > > > > > I seek suggestions how to 1) find out what goes wrong when the vpn goes > > > down, and 2) (much more important now) how to find out whether or not > the > > > slave is actually replicating or not. > > > > > > --bill > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe:http://lists.mysql.com/mysql > > > > > > > > > -- -- Thanks Suresh Kuna MySQL Database Consutant & MongoDB DBA Hadoop Admin

  1   2   >