Re: deleting big tables

2015-05-17 Thread Adarsh Sharma
--+ > > process with id 37 have been there for a long time, i tried to kill it and > drop the table. what can i do? > > > Pau Marc Muñoz Torres > skype: pau_marc > http://www.linkedin.com/in/paumarc > http://www.researchgate.net/profile/Pau_Marc_Torres3/info

Re: deleting big tables

2015-05-16 Thread Adarsh Sharma
Hi Pau, Ideally drop table should not take that much time , you have to check if your command is executing or it is in waiting stage. May be you are not able to get lock on that table. Cheers, Adarsh Sharma On Sat, 16 May 2015 at 23:34 Pau Marc Muñoz Torres wrote: > Hello every body >

Re: DBA: please review my.cnf [for Java Hibernate application] and give suggestions

2014-02-12 Thread Adarsh Sharma
Is it a standalone DB server or Application is also hosted on top of it. You can give 50-70% of RAM to memory parameters like Innodb_buffer_pool_size ( Innodb ) and key_cache ( Myisam ) for mysql tables. Below link : http://mysql.rjweb.org/doc.php/memory will give you a brief idea. Thanks

Locking causing slow updates

2014-01-08 Thread Adarsh Sharma
Hi, I have a small innodb table ~ 2k rows in Mysql 5.5.31-log version. Dont understand why sometimes in a day , one update on that table is taking around 1 minute to complete. DBName Table Name DataData Free | test | users | 0.48MB | 0.00MB

Re: Mysql Monitoring with Graphite

2013-02-21 Thread Adarsh Sharma
Anyone has any idea about this. On Thu, Feb 21, 2013 at 7:42 PM, Adarsh Sharma wrote: > Hi all, > > I need to set up mysql monitoring graphs in Graphite. I am able to monitor > > basic system metrics after runnning example-client.py that comes with > graphite installation. &g

Mysql Monitoring with Graphite

2013-02-21 Thread Adarsh Sharma
Hi all, I need to set up mysql monitoring graphs in Graphite. I am able to monitor basic system metrics after runnning example-client.py that comes with graphite installation. when i m looking for mysql plugin for graphite , i find MySQLPerfCollector.py but when i am running it after installing

Re: Doubt Regd. Circular Replication In Mysql

2012-09-24 Thread Adarsh Sharma
Agreed with your point Rick, right now i am maintaining my datadir & logging in my EBS volumes so if any of the instance goes down ,we will launch new instance & use the existing EBS volumes and start replication again. I think it will start automatically from the point where it goes down and star

Doubt Regd. Circular Replication In Mysql

2012-09-24 Thread Adarsh Sharma
Hi all, Today i set up a circular replication between three nodes A,B & C successfully. I expect whatever writes on A will propagated to B & then Propagated to C because the structure is like below :- A -> B - > C -> A I created a sample table stag in test database in A and insert few records th

Re: Partitioning on a Substring of Varchar Column in Mysql

2012-09-22 Thread Adarsh Sharma
olve this issue. Thanks for your link also , it is very helpfull. Thanks > See tips in > http://mysql.rjweb.org/doc.php/ricksrots > > > > -Original Message- > > From: Adarsh Sharma [mailto:eddy.ada...@gmail.com] > > Sent: Friday, September 21, 2012 5:09 AM > > To: my

Re: Partitioning on a Substring of Varchar Column in Mysql

2012-09-21 Thread Adarsh Sharma
Just update the string needed function substring(id,9,6). On Fri, Sep 21, 2012 at 5:18 PM, Adarsh Sharma wrote: > Hi all, > > I created a partition on a timstamp column ( dt_dtamp ) in mysql-5.1.58 > testing table.But as all of us know that partitioned column need to be > primar

Partitioning on a Substring of Varchar Column in Mysql

2012-09-21 Thread Adarsh Sharma
Hi all, I created a partition on a timstamp column ( dt_dtamp ) in mysql-5.1.58 testing table.But as all of us know that partitioned column need to be primary key. I have already id column as primary key but my application cann't afford primary key ('id','dt_stamp') in a table. I thought & tried

Are Single Column Indexes are sufficient

2012-09-17 Thread Adarsh Sharma
Hi all, Currently i am doing performance level tuning of some queries that are running very slow in my slow -query log. Below are the sample of some queries & the cardinality of indexes :- --- Below queries take more than 15 minutes to complete on a table scd_table of size 7 GB SELECT t0.id, t0.be

Re: Understanding Slow Query Log

2012-09-05 Thread Adarsh Sharma
nder an index usrless. > > On 2012-09-05 5:19 AM, "Adarsh Sharma" wrote: > > I already attached the list. > > Attaching one more time & thanks for the interest. > > Cheers > > > > On Wed, Sep 5, 2012 at 11:44 AM, Manuel Arostegui > wrote: > >

Re: Understanding Slow Query Log

2012-09-05 Thread Adarsh Sharma
I already attached the list. Attaching one more time & thanks for the interest. Cheers On Wed, Sep 5, 2012 at 11:44 AM, Manuel Arostegui wrote: > > > 2012/9/5 Adarsh Sharma > >> Actually that query is not my concern : >> >> i have a query that is taking

Re: Understanding Slow Query Log

2012-09-04 Thread Adarsh Sharma
f so, the query > will get slower. Meanwhile, the index I suggested will (probably) be much > faster. > > > > -Original Message- > > From: Suresh Kuna [mailto:sureshkumar...@gmail.com] > > Sent: Saturday, September 01, 2012 1:03 AM > > To: Adarsh Sharma > > Cc:

Understanding Slow Query Log

2012-09-01 Thread Adarsh Sharma
Hi all, I am using Mysql Ver 14.14 Distrib 5.1.58 in which i enabled slow query log by setting below parameters in my.cnf : log-slow-queries=/usr/local/mysql/slow-query.log long_query_time=100 log-queries-not-using-indexes I am assuming from the inf. from the internet that long_query_time is in

Innodb Table Gets Locked while Drop

2012-04-05 Thread Adarsh Sharma
Dear All, Today i faced an issue while issuing commands on my innodb tables. When I issued any drop table or alter table command my query gets into waiting state for more than 15-20 minutes. Mysql Version :-5.5.4 community I researched on the issue and find that every command try to get lock

Re: ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist

2012-03-15 Thread Adarsh Sharma
/recovering-create-table-statement-from-frm-file/ On Thu, Mar 15, 2012 at 11:56 AM, Adarsh Sharma mailto:adarsh.sha...@orkash.com>> wrote: Thanks baron , below are the contents of my error.log :- 120315 17:17:51 [Note] Plugin 'FEDERATED' is disabled. 120315 17:17:51 Inno

Re: ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist

2012-03-15 Thread Adarsh Sharma
rtz wrote: It sounds like InnoDB itself might have failed to start, but there is not enough information to know for sure. Please check the server's error log. On Thu, Mar 15, 2012 at 2:01 AM, Adarsh Sharma wrote: Dear All, Is there any way to recover data or only schema of corrupted

ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist

2012-03-14 Thread Adarsh Sharma
Dear All, Is there any way to recover data or only schema of corrupted innodb tables.My 4 innodb tables are coorupted in a database. mysql> show tables; +-+ | Tables_in_ois | +-+ | acos| | aros| | aros_acos

Re: Removing Data Duplicacy

2012-02-22 Thread Adarsh Sharma
Thanks Johan, but i mentioned before that adding auto increment column doesn't solve the issue & it causes errors in the multi threaded application. Multiple clients calls this insert procedure simultaneously, so it fails the transactions if two or more clients reads the same ID value. I need t

Re: Installing Mysql Workbench

2012-02-16 Thread Adarsh Sharma
2. Yacc 3. Bison 4. Flex These packages of appropriate version must be installed on your linux. On Thu, Feb 16, 2012 at 2:04 PM, Adarsh Sharma wrote: Any update on the issue Dear all, Today I am facing some issues while installing mysql-workbench-gpl-5.2.37-sr

Re: Installing Mysql Workbench

2012-02-16 Thread Adarsh Sharma
Any update on the issue Dear all, Today I am facing some issues while installing mysql-workbench-gpl-5.2.37-src] in CentOS 5.4. ./configure runs successfully but below command results in below error : make make[3]: Entering directory `/root/Desktop/MYSQLWORKBENCH/mysql-workbench-gpl-5.2.

Installing Mysql Workbench

2012-02-15 Thread Adarsh Sharma
Dear all, Today I am facing some issues while installing mysql-workbench-gpl-5.2.37-src] in CentOS 5.4. ./configure runs successfully but below command results in below error : make make[3]: Entering directory `/root/Desktop/MYSQLWORKBENCH/mysql-workbench-gpl-5.2.37-src/ext/scintilla/gtk' /

Installing Mysql-Workbench

2012-02-09 Thread Adarsh Sharma
Dear All, I researched about data modelling & designing Schema diagrams & need a tool to design Schema diagrams. Today i download the source code of Mysql-Workbench ( mysql-workbench-gpl-5.2.37-src ), but when i run the ./configure command i am facing the below issue :- checking for GNOME..

This partition function is not allowed

2012-01-26 Thread Adarsh Sharma
Dear all, Today i am creating a partition table in my mysql server 5.1.34-community-log . create table sample( a integer, dt_stamp timestamp not null default current timestamp, content varchar)engine= innodb PARTITION BY RANGE ( UNIX_TIMESTAMP(dt_stamp) ) ( -> PARTITION p0 VALUES LES

Re: Suggestions for ibdata files structure

2012-01-25 Thread Adarsh Sharma
Adarsh Sharma wrote: Thanks for the suggestions. Last thing to close this topic :- I create new partitions & files for ibdata files as :- log-bin=/hdd5-1/mysql-bin innodb_data_file_path = /hdd2-1/innodb_data1/ibdata1:250G;/hdd3-1/innodb_data2/ibdata2:250G;/hdd4-1/innodb_data3/ibd

ERROR 1146 (42S02): Table doesn't exist

2012-01-24 Thread Adarsh Sharma
Dear all, Today I changed my database name from abc to abc1 by the below commands :- 1. Go to data dir : cd /hdd2-1/mysql_data/ 2. mv abc abc1 But when I go to the mysql prompt & try to use the tables in abc database , below error occurs: ERROR 1146 (42S02): Table 'abc1.job_queue' doesn't ex

Re: Suggestions for ibdata files structure

2012-01-23 Thread Adarsh Sharma
. As a general rule, it's a good idea to have one datafile per physical disk. Putting more datafiles on a single disk doesn't magically increase parallellism. - Original Message - From: "Adarsh Sharma" To: "mysql" Sent: Monday, 23 January, 2012 10:50:

ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE

2012-01-02 Thread Adarsh Sharma
Dear all, I am running Mysql on a Linux System ( Caos ). Today when I am trying to create a procedure in it, I m facing the below issue : ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE My OS version is : Systemr-5:~ # cat /etc/issue Welcome to SUSE Linux Enterprise Server 10 SP1 (x

Re: Restoring failed due to Unexpected Error

2011-11-21 Thread Adarsh Sharma
Any comments to get the data back know. My hard disk crashes about 90% but when I start any kind of backup or select output into a file from 40GB table , it stops after 30 GB & then stalled because there are bad sectors to read. Is it possible to get the remaining data ( 10GB) , as all backups

Restoring failed due to Unexpected Error

2011-11-18 Thread Adarsh Sharma
Dear all, Today i need to restore the backup of a 40GB table in a new system. I create a script that takes the backup in compressed format ( 2.3 GB ).The existing hard disk crashes & I need to restore my data. But when I restore the data below error exists :- [root@test1 hdd2-1]# gunzip < sou

Re: Select data from large tables

2011-11-15 Thread Adarsh Sharma
More than 20163845 rows are there and my application continuously insert data in the table. daily i think there is a increase in 2.5 Gb in that table. Thanks Chris Tate-Davies wrote: How many rows is that??? On Tue, 2011-11-15 at 16:05 +0530, Adarsh Sharma wrote: Dear all, I have a

Select data from large tables

2011-11-15 Thread Adarsh Sharma
Dear all, I have a doubt regarding fetching data from large tables. I need to fetch selected columns from a 90Gb Table & 5Gb index on it. CREATE TABLE `content_table` ( `c_id` bigint(20) NOT NULL DEFAULT '0', `link_level` tinyint(4) DEFAULT NULL, `u_id` bigint(20) NOT NULL, `heading` varchar

Re: Deleting Records in Big tables

2011-11-04 Thread Adarsh Sharma
he Create Index command on ID takes hours too complete. I think there is no easiest way to delete that rows from mysql tables. regards anandkl On Fri, Nov 4, 2011 at 12:52 PM, Adarsh Sharma mailto:adarsh.sha...@orkash.com>> wrote: Dear all, Today I need to delete some records

Deleting Records in Big tables

2011-11-04 Thread Adarsh Sharma
Dear all, Today I need to delete some records in > 70 GB tables. I have 4 tables in mysql database. my delete command is :- delete from metadata where id>2474; but it takes hours to complete. One of my table structure is as :- CREATE TABLE `metadata` ( `meta_id` bigint(20) NOT NULL AUTO_IN

Re: Removing Double Quotes

2011-11-03 Thread Adarsh Sharma
Thanks Johan, I solved the problem by the below command :- UPDATE website_master SET url= REPLACE( url,'"',''); Thanks Johan De Meersman wrote: - Original Message - From: "Adarsh Sharma" I need to remove the quotes in text columns in a mysq

Removing Double Quotes

2011-11-02 Thread Adarsh Sharma
Dear all, I need to remove the quotes in text columns in a mysql table. It has more than 5000 rows. In some rows there is values quoted with ". I want to remove them. Below is the snapshot : *ID /URL Country

Re: how to shrink ibdata1

2011-10-02 Thread Adarsh Sharma
innnodb_file per table creates ibdata files for each table and What to do if some tables data are deleted frequently. I have a innodb table which was truncated after 150GB in mysql database. Reindl Harald wrote: Am 02.10.2011 22:10, schrieb Dhaval Jaiswal: Hi All, How to shrink the Mysql

Re: [GENERAL] Download States and Capitals Database

2011-09-27 Thread Adarsh Sharma
, Adarsh Sharma wrote: Dear all, I googled a lot and find data of all countries , cities , location etc from Geo Spatial websites but I am able to find the data that shows all *states & their respective capitals* in world. Please let me know if anyone as prior information about

Download States and Capitals Database

2011-09-26 Thread Adarsh Sharma
Dear all, I googled a lot and find data of all countries , cities , location etc from Geo Spatial websites but I am able to find the data that shows all *states & their respective capitals* in world. Please let me know if anyone as prior information about this ? Thanks

Questions about Mysqldump

2011-09-14 Thread Adarsh Sharma
Dear all, Today i backup my all databases (25) by using the below command :- mysqldump --all-databases -q --single-transaction | gzip > /media/disk-1/Server11_MysqlBackup_15September2011/mysql_15sep2011backup.sql.gz Now I have some doubts or problems that I need to handle in future : 1. Is

Caution : Hard Disk Full

2011-08-25 Thread Adarsh Sharma
Dear all, Today by chance I am checking the space in mysql data directories. /dev/sdd5 274G 258G 2.6G 100% /hdd4-1 In the next 2 days i know my space becomes empty due to increase in data of myisam tables. [root@sd-1 hdd4-1]# du -sh * 33G innodb_data1 33G innodb_dat

Re: mysql

2011-08-23 Thread Adarsh Sharma
Follow the steps :- 1. Check mysqld is running or not > /etc/init.d/mysql status 2. If not > /etc/init.d/mysql start If error occurs , check the logs & usually this error means ur server is not running at the moment. Good Luck ! Claudio Nanni wrote: You have 2 options: use tcp/ip or find

Re: Best Way to store Hierarchical Data in Mysql

2011-08-19 Thread Adarsh Sharma
Its Ok, it happen sometimes. Alex Schaft wrote: Apologies. I hid reply to on the wrong message On 2011/08/19 12:10 PM, Adarsh Sharma wrote: Dear all, I researched a lot on storing Hierarchical data in mysql tables. Below links : http://scvinodkumar.wordpress.com/2011/01/30/managing

Best Way to store Hierarchical Data in Mysql

2011-08-19 Thread Adarsh Sharma
Dear all, I researched a lot on storing Hierarchical data in mysql tables. Below links : http://scvinodkumar.wordpress.com/2011/01/30/managing-hierarchical-data-in-mysql/ http://www.sitepoint.com/hierarchical-data-database-2/ shows different ways to store. But is there any standard way of doin

Which is better

2011-08-01 Thread Adarsh Sharma
Dear all, Just want to know which join is better for querying data faster. I have 2 tables A ( 70 GB ) & B ( 7 MB ) A has 10 columns & B has 3 columns.Indexes exist on both tables's ids. select p.* from table A p, B q where p.id=q.id or select p.* from table B q , A p where q.id=p.id Thank

How to view Query Execution time

2011-07-31 Thread Adarsh Sharma
Dear all, I want to know how much time did it take to run a sample query. In postgresql, we enable timing by \timing command. Is there is any way to enable in Mysql Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/my

Re: System Reboot while mysqldump

2011-07-27 Thread Adarsh Sharma
aination. jon.siebe...@gmail.com wrote: anything in error log by chance? On Jul 28, 2011 1:07am, Adarsh Sharma wrote: > > > > > > Dear all, > > > > Today I got stucked around a strange problem. > > Don't know why me linux reboot automatically. &g

System Reboot while mysqldump

2011-07-27 Thread Adarsh Sharma
Dear all, Today I got stucked around a strange problem. Don't know why me linux reboot automatically. *Server Info : *Linux Server-5 2.6.16.46-0.12-smp #1 SMP Thu May 17 14:00:09 UTC 2007 x86_64 x86_64 x86_64 GNU/Linux Welcome to SUSE Linux Enterprise Server 10 SP1 (x86_64) - Kernel \r (\l).

Re: Free Navicat

2011-07-26 Thread Adarsh Sharma
ailed link to install it with dependencies. > > Thanks > Walter Heck - OlinData.com wrote: > > You can try MySQL Workbench instead. It's FOSS too: http://wb.mysql.com/ > > > > have fun! > > > > On Tue, Jul 26, 2011 at 14:31, Adarsh Sharma > &

Re: Free Navicat

2011-07-26 Thread Adarsh Sharma
desktop OS and save yourself all kinds of misery altogether :P). cheers, On Tue, Jul 26, 2011 at 14:35, Adarsh Sharma <mailto:adarsh.sha...@orkash.com>> wrote: Ya , I know that but I fail to install Mysql-workbench in Linux Systems ( CentOS , Ubuntu ) Error shows like bel

Re: Free Navicat

2011-07-26 Thread Adarsh Sharma
. It's FOSS too: http://wb.mysql.com/ have fun! On Tue, Jul 26, 2011 at 14:31, Adarsh Sharma <mailto:adarsh.sha...@orkash.com>> wrote: Dear all, Is there is any free version of Navicat to access data from Mysql. I am using 30-day trial version. Thanks --

Free Navicat

2011-07-26 Thread Adarsh Sharma
Dear all, Is there is any free version of Navicat to access data from Mysql. I am using 30-day trial version. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How to Shuffle data

2011-07-13 Thread Adarsh Sharma
Do i need to move output to a CSV file & then write a Java or C code for it. I think a procedure can do it easily , If I know the proper function for that. Thanks wal...@waltertross.com wrote: What you want to do is not shuffle, but reverse the domain order, starting from the TLD (top level

How to Shuffle data

2011-07-13 Thread Adarsh Sharma
Dear all, I have million of sites stored in url column of a mysql table. Some few examples are :- www.facebook.com/home adelaide.yourguide.com/news/local/news/entertainment/cd-review-day-and-age-the-killers/1401702.aspx abclive.in/abclive_business/2393.html abclive.in/abclive_business/assocham_

Schema for Website Comments

2011-07-10 Thread Adarsh Sharma
Dear all, Today I need to create a schema for my application website that allows user comments too. I think we have to maintain hierarchical data and it is very common as all sites are supporting this feature. Can somebody suggest me some guidelines to follow and some links too. Thanks -

Re: Query on wait_timeout

2011-06-16 Thread Adarsh Sharma
connection UPDATE tempdb.dbo.bar SET col1 = 1 Connection two will be chosen as the deadlock victim On Thu, Jun 16, 2011 at 10:53 AM, Adarsh Sharma mailto:adarsh.sha...@orkash.com>> wrote: How we can create a deadlock manually to test this problem. Thanks Suresh Kuna

Re: Query on wait_timeout

2011-06-15 Thread Adarsh Sharma
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 it. On Wed, Jun 15, 2011 at 3:38 PM, Yogesh Kore wrote: Hi, Small doubt for wait_ti

Re: Doubt regarding Mysqlsump

2011-06-07 Thread Adarsh Sharma
Johan De Meersman wrote: - Original Message - From: "Claudio Nanni" I think this is the best option for you: http://www.percona.com/docs/wiki/percona-xtrabackup:start I must say, I still haven't looked very well at xtrabackup. How does it take consistent backups of MyISAM ta

Re: Doubt regarding Mysqlsump

2011-06-06 Thread Adarsh Sharma
Both MYISAM & Innodb Engines are used. Thanks Nilnandan Joshi wrote: Can you tell us which storage engine you are using? On Tue, Jun 7, 2011 at 11:30 AM, Adarsh Sharma mailto:adarsh.sha...@orkash.com>> wrote: Dear all, Is it possible to take backups of a table or complet

Doubt regarding Mysqlsump

2011-06-06 Thread Adarsh Sharma
Dear all, Is it possible to take backups of a table or complete database without stopping the application that continuously inserts and select data from the tables. For taking complete backup of a database I follow the below steps :- 1. First stop the application that insert & modifies table

Re: Not finding my.cnf file

2011-06-01 Thread Adarsh Sharma
sr/sbin/mysqld: Shutdown complete I checked & /hdd2-1/myisam_data/mysql-bin.index file is there , how to comes Thanks Peter Boros wrote: Hi, You probably didn't run mysql_install_db. Peter Boros On Wed, 2011-06-01 at 15:52 +0530, Adarsh Sharma wrote: I got the error after sett

Re: Not finding my.cnf file

2011-06-01 Thread Adarsh Sharma
y.cnf Regards John On 1 June 2011 10:24, Adarsh Sharma wrote: Dear all, I install mysql in CentOS -5.4 through 2 commands : yum install mysql-server yum install mysql-client And I can see directories created in /var/lib/mysql directory. But now i want to change it to my /hdd1-1 diret

Not finding my.cnf file

2011-06-01 Thread Adarsh Sharma
: [root@ws-test ~]# find / -name my.cnf [root@ws-test ~]# Now how could I solve this issue & from where mysql picks its configuration or it go for its default. Thanks & best Regards, Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To uns

Repair Command takes too much time

2011-05-31 Thread Adarsh Sharma
e this. Thanks & best Regards, Adarsh Sharma # Example MySQL config file for medium systems. # # This is for a system with little memory (32M - 64M) where MySQL plays # an important part, or systems up to 128M where MySQL is used together with # other programs (such as a web server) # # You can

Re: Restore only one database or one table

2011-05-19 Thread Adarsh Sharma
ea, too - the output is a text file, so bzip2 will probably compress that a factor 10 or better. Simply use bzcat to pipe the file back into the MySQL client to restore. That's pretty nice & What I am expected to hear. I will let u know after some practical implementation. Thanks & best Regards, Adarsh Sharma

Re: Restore only one database or one table

2011-05-18 Thread Adarsh Sharma
ment... On Thu, May 19, 2011 at 6:50 AM, Michael Dykman wrote: What tables types are you using? If MyISAM, this can be done easily. If InnoDB it will depend on your settings (file-per-table) - michael dykman On Tue, May 17, 2011 at 7:11 AM, Adarsh Sharma wrote: Dear all, I read all

Test mail

2011-05-18 Thread Adarsh Sharma
Hi all, Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Restore only one database or one table

2011-05-18 Thread Adarsh Sharma
Dear all, I read all the different ways to backp and restore data in mysql. Say, i perform a complete backup of all databases 1 month ago Now, is it possible to restore only a single database from a complete backup file of 250 GB that contains backup of more than 50 databases. Or if we want t

Re: ERROR 1062 (23000): Duplicate entry '31592' for key 'PRIMARY'

2011-04-28 Thread Adarsh Sharma
Thanks , but there is no trigger on tables. Even I solved the problem after googling a link but cannot understand below mentioned things :- Please have some comments on them misiaq wrote: Any triggers on this table..? "Adarsh Sharma" pisze: Dear all, I have a login ta

ERROR 1062 (23000): Duplicate entry '31592' for key 'PRIMARY'

2011-04-28 Thread Adarsh Sharma
Dear all, I have a login table in the database whose definition is as : CREATE TABLE `login` ( `log_id` int(4) NOT NULL AUTO_INCREMENT, `user_id` int(4) DEFAULT NULL, `log_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `log_status` int(4) DEFAULT NULL, PRIMARY KEY (`log_id`), KEY `use

Mysql Clustering Vs Scalr

2011-03-22 Thread Adarsh Sharma
Thanks & best regards, Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Suggestions for InnoDB files

2011-03-16 Thread Adarsh Sharma
Johan De Meersman wrote: From: "Adarsh Sharma" Johan De Meersman wrote: Interesting, but why like this instead of simply larger disks or raidsets ? It's the IT-Admin Issue , I can't question that and we have only disks of 300GB ( SAS ). Your admin is

Suggestions for InnoDB files

2011-03-15 Thread Adarsh Sharma
a large RAID10 set MyISAM tables get stored in one /hdd1-1 directory. Tables size grows day by day . Infact, one InnoDBtable is increasing 3GB/per day . What is the best configuration for them so that we doesn't hit performance issues. Thanks & best Regards, Adarsh Sharma

Backup Policy

2011-03-15 Thread Adarsh Sharma
afford to have some proprietary solution. Any suggestions will always Welcome. Thanks & best Regards, Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Script to mail output of select query

2011-03-15 Thread Adarsh Sharma
the information of how much increase data after 1 day daily. Please guide me how to do this. Thanks & best Regards, Adarsh Sharma status.sh Description: application/shellscript -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Unexpected Select Output

2011-03-14 Thread Adarsh Sharma
+---++++ | pdc_crawler | hc_categories | 0.00G | 0.06M | 58.71K | +-+---++----+----+ Why it is not able to print all table that fits in OR condition. Thanks & best Regards, Adarsh Sharma -- MySQL General Mailing Li

How to know Data Size through Scripts

2011-03-14 Thread Adarsh Sharma
ieve this. I researched a lot , I find commands as : SELECT CONCAT(sum(ROUND(((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 / 1024),2))," MB") AS Size FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA like 'abc' ; Is there is any simple commands to know this. Thanks

[ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm'

2011-03-13 Thread Adarsh Sharma
2011-03-14 10:36 mysql Thanks & best Regards, Adarsh Sharma # Automatically generated for Debian scripts. DO NOT TOUCH! [client] host = localhost user = debian-sys-maint password = l7MZwYyF45QH8wrY socket = /var/run/mysqld/mysqld.sock [mysql_upgrade] host = localhost user =

Tool for shifting tables from Mysql to Postgresql

2011-03-01 Thread Adarsh Sharma
e6c65 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". ERROR: invalid byte sequence I think a tool would ease that work. Thanks & best Regards, Adarsh Sharma -- MySQL Gene

Mysql to Postgresql

2011-02-22 Thread Adarsh Sharma
Dear all, Today I need to back up a mysql database and restore in Postgresql database but I don't know how to achieve this accurately. Can anyone kindly describe me the way to do this. Thanks & best Regards, Adarsh Sharma -- MySQL General Mailing List For list archi

Insert data in one table from Another Problem

2011-02-16 Thread Adarsh Sharma
ows in one row. That is four rows in one table contributes a single row in *other *table. I try with procedures and cursors but fail to achieve the output. Is it possible in Mysql. Please guide me how to achieve this as I am stuck around it. Thanks & Best Regards Adarsh Sharma

Limit of Mysql

2011-02-15 Thread Adarsh Sharma
.1 RDBMS. Is anyone has some experience of moving from these open -source databses ( Mysql, Postgresql ) to some mechanism of handling data in file systems. Please share the views. Thanks & best regards, Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.

Doubt Regarding Truncate

2011-02-10 Thread Adarsh Sharma
92G 64% /hdd5-1 Please guide me if I 'm doing something wrong. Thanks & best Regards Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Backup onle one procedure

2011-02-09 Thread Adarsh Sharma
-data --no-create-db --skip-opt test_crawler > adarsh.sql Thanks & Regards Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Auto-Increment Values in Mysql

2011-02-09 Thread Adarsh Sharma
rted right at 8 Please help how to achieve it. Thanks & best Regards Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Group By Problem

2011-02-08 Thread Adarsh Sharma
mentioned output. Failed to achieve the mentioned output. Thanks & Regards Adarsh Sharma

Re: Can't read dir of '.' (errno: 13)

2011-01-18 Thread Adarsh Sharma
Hi , After some research I want a useful link that describes my problem. Here is the link : http://bugs.mysql.com/bug.php?id=15851 I don't think that this is a permission problem as I cross-check it. But I am not able to remove it. Thanks & Regards Adarsh Sharma Adarsh Sha

Can't read dir of '.' (errno: 13)

2011-01-18 Thread Adarsh Sharma
ql data dir is /hdd2-1/myisam_data/* Mysql is the owner and group of myisam_data folder. Can I know why it occurs and how to debug it. Thanks & Regards Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

mysqldump except one table

2011-01-18 Thread Adarsh Sharma
me how to do this. Thanks & Best Regards Adarsh Sharma

Reading .MYD file of Mysql Tables

2011-01-09 Thread Adarsh Sharma
Dear all, I am facing a issue which should be resolved by editing .MYD file of a Table. I know there are 3 files foe a MyISAM table in Mysql but i want to read and edit some changes in .MYD file. If it is possible , Can anyone PLease tell me the way to do this. Thanks & Regards Ad

HNY-2011

2011-01-03 Thread Adarsh Sharma
Dear all, A very-very Happy New Year 2011 to all. May God Bless all of us to solve future problems. Thanks and Regards Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Issue while SymLinking a Database

2011-01-02 Thread Adarsh Sharma
d solution. Thanks & Regards Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

my.cnf file

2010-12-29 Thread Adarsh Sharma
. Please help. Thanks Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Automate Scripts to make for managing Large Database Servers.

2010-12-29 Thread Adarsh Sharma
Paths or Hard Disks. 3. Performing Updates of Softwares. 4. Checking Servers Power Status. Please guide me some more tasks that need a proper attention. Thanks & Regards Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Back-up Plan for Large Database

2010-12-27 Thread Adarsh Sharma
best option. http://www.zmanda.com/mysql-backup-considerations.html I also read about RAID and some other features too. But I want to know what is the best back up plan for 24/7 running Large Production Mysql Cluster. Thanks & Regards Adarsh Sharma -- MySQL General Mailing List For

How to Install Mysql

2010-12-23 Thread Adarsh Sharma
cnf Don't know what to do. Please help. Or I am going to install through rpm which is the easiest way. But which is best for our Production Servers. Thanks & Regards Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:htt

Error while running Mysql

2010-12-23 Thread Adarsh Sharma
spective owners. Segmentation fault [r...@ws-test mysql-5.5.8]# Don't know what to do.Please help. Thanks & Regards Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

4 days to drop Index

2010-12-22 Thread Adarsh Sharma
whether it is fine in MySQL or things needed to work on. Thanks & Regards Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

  1   2   >