Re: delete syntax

2011-12-01 Thread Krishna Chandra Prajapati
delete from mysql.user where user='mail_admin'; Krishna On Fri, Dec 2, 2011 at 7:23 AM, Tim Dunphy bluethu...@jokefire.com wrote: hello list, I am attempting to delete a user from the mysql.user table without success. mysql delete from mysql.user where user='mail_admin@%'; Query OK, 0

Re: Backup Policy

2011-03-15 Thread Krishna Chandra Prajapati
xtrabackup, mysqlhotcopy for myisam, incremental backup using zamanda. Krishna On Tue, Mar 15, 2011 at 9:09 PM, petya pe...@petya.org.hu wrote: Hi, What storage engine are you using? Peter Boros On 03/15/2011 02:12 PM, Adarsh Sharma wrote: Dear all, Taking Backup is must needed task

Re: best way to have a unique key

2011-01-20 Thread Krishna Chandra Prajapati
uuid() Krishna On Fri, Jan 21, 2011 at 12:02 AM, Anthony Pace anthony.p...@utoronto.cawrote: Due to certain reasons, the company I am doing business with has decided that the primary key, for an orders table, be a unique key; however, I don't like the possibility of it conflicting if moved

Re: Large table

2011-01-14 Thread Krishna Chandra Prajapati
partitioning will help u Krishna On Fri, Jan 14, 2011 at 4:18 AM, Sairam Krishnamurthy kmsram...@gmail.comwrote: All, I have a very large table. It has about 1 billion rows. Initially everything was fine. But now the table is a bit slow. Loaded takes a lot of time. I usually load in chunks

Re: Error while running Mysql

2010-12-23 Thread Krishna Chandra Prajapati
HI Adarsh, Try memtester command #memtester 5 1 It' a linux tool to check ram for errors. http://krishna-mysql.blogspot.com/2010/12/faulty-physical-ram.html Krishna On Thu, Dec 23, 2010 at 6:08 PM, Adarsh Sharma adarsh.sha...@orkash.comwrote: Dear all, I am able o successfully build

Re: MySQL Parallel Inserts

2010-12-14 Thread Krishna Chandra Prajapati
Hi Andy, I agree, prefer LOAD DATA INFILE... command for bulk loading. It is 30% faster than normal inserts. Krishna On Tue, Dec 14, 2010 at 8:02 AM, Andy listan...@gmail.com wrote: Greetings everyone. I am in a situation where I need to do parallel inserts into MySQL database from inside

Re: WTA Increasing InnoDB Speed

2010-10-23 Thread Krishna Chandra Prajapati
Hi Willy, Try percona server. It gives better performance than mysql. Krishna On Sat, Oct 23, 2010 at 3:37 AM, Willy Mularto sangpr...@gmail.com wrote: Dear List, I have MySQL 5.14 installed on Dell R710 32GB RAM 600GB SAS HDD with Ubuntu 10.04 64 Bit. I deploy InnoDB as my default engine.

Re: How to Install mysql from source

2010-10-19 Thread Krishna Chandra Prajapati
Hi, There is a detailed readme (text file) within the file you have downloaded. It will gives you the complete picture. Krishna cgi.com On Mon, Oct 18, 2010 at 9:24 PM, ml ml mliebher...@googlemail.com wrote: Hello List, i am trying to install mysql on debian lenny from source. Here is what

Re: mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TABLES

2010-10-19 Thread Krishna Chandra Prajapati
Hi Pradhan, Obviously, it should fail. Since you have deleted the root user which is used by mysqldump for making connection to mysql server for taking backup Krishna CGI.COM On Tue, Oct 19, 2010 at 11:06 AM, Tanmay Pradhan tanma...@gmail.com wrote: Hi, I am using the following version of

Re: Purposely Corrupting a table

2010-10-19 Thread Krishna Chandra Prajapati
Hi, Keep key_buffer_size very low and insert lots of data into table (myisam). After some time the index file will crash. Krishna CGI.COM On Tue, Oct 19, 2010 at 7:53 PM, Steve Staples sstap...@mnsi.net wrote: Ok, been googling all morning, and keep getting the same post (on multiple

Re: Primary key not unique on InnoDB table

2010-10-13 Thread Krishna Chandra Prajapati
Hi Neil, Yes, primary key is always unique. In your case, you are using composite key (players_id,default_teams_id). _Krishna On Wed, Oct 13, 2010 at 8:07 PM, Tompkins Neil neil.tompk...@googlemail.com wrote: I've the following table. But why isn't the primary key unique, e.g. preventing

Re: Backup

2010-10-11 Thread Krishna Chandra Prajapati
Hi kranthi, Take a look at LVM and xtrabackup. http://www.mysqlperformanceblog.com/2009/02/24/xtrabackup-open-source-alternative-for-innodb-hot-backup-call-for-ideas/ http://marcus.bointon.com/archives/87-MySQL-backups-with-Perconas-XtraBackup.html Krishna CGI (cgi.com) On Sun, Oct 10, 2010

Re: How to extend innodb files?

2010-09-28 Thread Krishna Chandra Prajapati
Hi Vokern, I suggest to have a single ibdata1 file and use *innodb_file_per_table* to have multiple .ibd tables. _Krishna On Tue, Sep 28, 2010 at 11:29 AM, Vokern vok...@gmail.com wrote: Hello, Currently I have the setting:

Re: How to extend innodb files?

2010-09-28 Thread Krishna Chandra Prajapati
reclaim the free space if required simply by dropping the table. _Krishna On Tue, Sep 28, 2010 at 5:16 PM, Vokern vok...@gmail.com wrote: 2010/9/28 Krishna Chandra Prajapati prajapat...@gmail.com: Hi Vokern, I suggest to have a single ibdata1 file and use innodb_file_per_table to have

Re: MySQL Server has gone away

2010-08-19 Thread Krishna Chandra Prajapati
Hi Jitendra, Check your error log file. Some thing might have gone wrong. Krishna On Wed, Aug 18, 2010 at 9:41 PM, jitendra ranjan jitendra_ran...@yahoo.comwrote: Hi, Whenever i run any commnd on mysql it gives message as below then gives the result successfully. What is the reason of the

Re: mysql is crashing

2010-08-13 Thread Krishna Chandra Prajapati
Hi Yectli, In mysql configuration file (my.cnf) you have given key_buffer_size = 5G For 32bit OS it should be less than or equal to 4GB and for 64bit it can be greater than 4GB. Reduce the key_buffer_size to 3GB and try. _Kirshna On Fri, Aug 13, 2010 at 3:02 AM, Yectli Huerta

Re: mysql is crashing

2010-08-13 Thread Krishna Chandra Prajapati
+0530, Krishna Chandra Prajapati wrote: Hi Yectli, In mysql configuration file (my.cnf) you have given key_buffer_size = 5G For 32bit OS it should be less than or equal to 4GB and for 64bit it can be greater than 4GB. Reduce the key_buffer_size to 3GB and try. _Kirshna Hello

Re: phpMyAdmin and other management tools

2010-07-01 Thread Krishna Chandra Prajapati
Hi Dave, I recommend you to use Toad for MySQL. It has wizard for query creation phpMyAdimn, mysql workbench, sqlyog lack this feature. Krishna On Thu, Jul 1, 2010 at 5:08 PM, David Stoltz dsto...@shh.org wrote: Hi Folks, I'm currently using phpMyAdmin to manage the mySQL databases. I'm

Re: Table creation fail

2010-06-23 Thread Krishna Chandra Prajapati
Hi, default cannot be used with primary key. mysql CREATE TABLE `testresults` ( - - `id_employees` INTEGER DEFAULT NULL , - `id_test_test` INTEGER DEFAULT NULL , - `testdate` DATE DEFAULT NULL , - `result` VARCHAR( 10 ) DEFAULT NULL , - `resultsdescription` MEDIUMTEXT

Re: Best way to purge old records from a huge table?

2010-06-04 Thread Krishna Chandra Prajapati
Hi Brian, I would suggest you to use mk-archiver (Maatkit Tools) for this activity. http://www.percona.com/files/presentations/Make_Life_Easier_Maatkit_v2.pdf Regards, Krishna On Fri, Jun 4, 2010 at 8:40 PM, Brian Dunning br...@briandunning.comwrote: Hey all - I have a table with

Re: large table issue

2010-06-02 Thread Krishna Chandra Prajapati
Hi, MySQL Partitioning will help you a lot. Try it. Regards, Krishna 2010/6/2 曹凯 tx...@hotmail.com Hi all, do you guys know how to deal with the large tables? here's my problem: I have two web servers( running Nginx ) , two DB servers( running MySQL 5.1.35 ) and a server for load

Re: Replication : request DELETE is not executed on slave

2010-04-28 Thread Krishna Chandra Prajapati
Hi dflorella, The important thing about mysql replication is same mysql version for both master as well as slave should be used. It should be taken as good practice. You need to check that master and slave are in sync. Is there any error (replication) on the slave server. Check the mode, strict

Re: Mysql - Tables Export to Excel!

2010-04-08 Thread Krishna Chandra Prajapati
Hi Vikram, You can use toad for mysql ( It's a free tool) to export table structure or data. Even you can use mysqldump also. Krishna On Thu, Apr 8, 2010 at 10:42 AM, Vikram A vikkiatb...@yahoo.in wrote: Hi, I would like to export my table structure from MYSQL from a particular db. Is

Re: Can't drop index

2010-04-02 Thread Krishna Chandra Prajapati
Hi Neil, Just check it up that any active transaction is still there in innodb internal data dictionary. Execute show engine innodb status\G Check for active transaction related to the current table. If it's there kill that transaction id and try again. _Krishna On Fri, Apr 2, 2010 at 10:35

Tokutek Acquires Oracle

2010-04-01 Thread Krishna Chandra Prajapati
Hi guys, Is the information is true. http://planet.mysql.com/ http://tokutek.com/2010/04/tokutek-acquires-oracle/ Regards, Krishna

Re: Replication - LINUX to WIN

2010-03-18 Thread Krishna Chandra Prajapati
Yes, go ahead. -Krishna On Thu, Mar 18, 2010 at 2:03 PM, Vikram A vikkiatb...@yahoo.in wrote: Hi, I have done replication with Win to Win servers with mysql version 5.0.41-community-nt. Now, We have Enterprise Linux(Red Hat 4.1.2-14) and windows server2003. Is it possible do the

Re: MySQL Storage Engine

2010-03-18 Thread Krishna Chandra Prajapati
Hi Neil, Recommend : Innodb storage engine Even, i would suggest inner join select query (if report query might takes few seconds) should be executed on slave. Before doing any thing. Plan out all the requirement. Regards, Krishna On Thu, Mar 18, 2010 at 2:48 PM, Tompkins Neil

Re: MySQL Storage Engine

2010-03-18 Thread Krishna Chandra Prajapati
- slave replication. http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html _Krishna On Thu, Mar 18, 2010 at 3:11 PM, Tompkins Neil neil.tompk...@googlemail.com wrote: Hi How do you mean executed on slave ? Neil On Thu, Mar 18, 2010 at 9:32 AM, Krishna Chandra Prajapati

Re: mysql proxy in production?

2010-03-12 Thread Krishna Chandra Prajapati
Hi Walter, I have tried and tested haproxy (ver 1.3). But it doesn't work to my expectation. May be newer version (1.4) works better. Brent try and check http://sqlrelay.sourceforge.net/sqlrelay/ http://www.cherokee-project.com/

Re: mysql proxy in production?

2010-03-12 Thread Krishna Chandra Prajapati
...@gmail.com wrote: On 11/03/2010 16:52, Krishna Chandra Prajapati wrote: Hi Brent You can visit the below link. http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/ Well thats disappointing. sigh So what are we supposed to use

Re: mysql proxy in production?

2010-03-11 Thread Krishna Chandra Prajapati
Hi Brent You can visit the below link. http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/ http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/ Thanks, Krishna On Thu, Mar 11, 2010 at 7:56 PM, Brent Clark

Re: Very slow delete for Master / Child tables with millions of rows

2010-03-11 Thread Krishna Chandra Prajapati
Hi Randall, How much memory is allocated to innodb_buffer_pool_size. Please send your mysql configuration file (my.cnf) Thanks, Krishna On Thu, Mar 11, 2010 at 8:57 PM, Price, Randall randall.pr...@vt.eduwrote: I am experiencing very slow deletes when I delete a record from a master table

Re: Enabling Slow query log in Mysql 5.0

2010-02-16 Thread Krishna Chandra Prajapati
Hi Machiel, The below link will help you. mk-query-digesthttp://www.xaprb.com/blog/category/maatkit/ Regards, Krishna On Tue, Feb 16, 2010 at 12:51 PM, Machiel Richards machi...@rdc.co.zawrote: Hi All I hope that someone can assist me with this. We have

ERROR

2010-02-07 Thread Krishna Chandra Prajapati
Hi List, I am getting the below error on my rhel server. Mysql is running on this box. Due to below error server hangs and stop responding. After system reboot it's working. Feb 7 02:38:29 DCTNMVH1 kernel: mysqld invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0 Feb 7 02:39:16

Re: Sharding

2010-01-29 Thread Krishna Chandra Prajapati
%20Scaling%20with%20HiveDB%20Presentation.pdf Carlos On 1/22/2010 11:44 PM, Krishna Chandra Prajapati wrote: Hi Carlos, Have you tried and benchmark hivedb. any body reviewed hivedb. Please share the experience. Krishna On Fri, Jan 22, 2010 at 11:47 PM, Carlos Proal carlos.pr

Re: SCALING INSERT

2010-01-23 Thread Krishna Chandra Prajapati
way to do so. (distributed servers) Thanks, Krishna On Thu, Jan 21, 2010 at 7:39 PM, Shawn Green shawn.gr...@sun.com wrote: Krishna Chandra Prajapati wrote: Hi list, I want to insert 1 records/sec into table. There can be n number of tables with unique data in each. What

Re: mysql update

2010-01-22 Thread Krishna Chandra Prajapati
Hi, How big is sample.sql dump ? there are many different things, might taking the time. dns resolve issue, network issue tcp0 0 www.myweb.:mysql A.B.C.D:8366 *TIME_WAIT* (It should established) load on the server, check mysql processlist (any wrong query is there) Thanks,

Sharding

2010-01-22 Thread Krishna Chandra Prajapati
Hi List, I am looking opensource tool for mysql sharding. One is mysql-proxy, but it is in alpha stage. Another one is spock proxy. Any one benchmark spock proxy. Is there other tools also. Please share views with mysql sharding Any response is highly appreciated. Thanks, Krishna

Re: Sharding

2010-01-22 Thread Krishna Chandra Prajapati
/07/sharding-for-masses-spider-storage.html Carlos On 1/22/2010 4:47 AM, Krishna Chandra Prajapati wrote: Hi List, I am looking opensource tool for mysql sharding. One is mysql-proxy, but it is in alpha stage. Another one is spock proxy. Any one benchmark spock proxy. Is there other

Selecting, Inserting and Deleting data

2010-01-21 Thread Krishna Chandra Prajapati
Hi List, I am working for a messaging company, sending sms to enterprise customers. In a mysql table data is being continuously inserted by user. Most of the time we have 5 to 10 millions of data in this table. Table name : alt_send_sms engine myisam From this table, i need to select data

Re: Selecting, Inserting and Deleting data

2010-01-21 Thread Krishna Chandra Prajapati
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 Kuna MySQL DBA On Thu, Jan 21, 2010 at 4:30 PM, Krishna Chandra Prajapati prajapat...@gmail.com

Re: Selecting, Inserting and Deleting data

2010-01-21 Thread Krishna Chandra Prajapati
-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, Krishna

SCALING INSERT

2010-01-21 Thread Krishna Chandra Prajapati
Hi list, I want to insert 1 records/sec into table. There can be n number of tables with unique data in each. What are the possible ways to do ? Thanks, Krishna

LOAD BALANCER

2010-01-21 Thread Krishna Chandra Prajapati
Hi list, Out of the below load balancer which is the best one. Is there any other load balancer available. 1 mysql proxy (Still alpha) 2 ultramonkey. 3 haproxy Thanks, Krishna

Re: innodb recovery

2010-01-20 Thread Krishna Chandra Prajapati
Hi John, The data files will give you some informations like log_file_size, mutliple tablespace is being used or not. Although my.cnf can help you a lot. With the above information, use it with newer version of mysql. Krishna On Wed, Jan 20, 2010 at 3:02 PM, Johny Brawo lydyh...@gmail.com

Re: Replications oddity.

2010-01-15 Thread Krishna Chandra Prajapati
Hi Brent, I believe you missed log_slave_updates component on 2 and 1. You have to enable binary logs + log_slave_updates on 2 and 1. http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates Thanks, Krishna On Fri, Jan 15, 2010 at 3:07 PM, Brent

Re: Error in running trigger

2009-12-22 Thread Krishna Chandra Prajapati
Hi Ranjan, User doesn't have sufficient privileges. root access required. Thanks, Krishna On Tue, Dec 22, 2009 at 3:26 PM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi, I have created the below trigger from root user with definer: CREATE definer=`*root...@`` TRIGGER

Re: Uninsall mysql 5.0.45 from RHEL 5

2009-12-19 Thread Krishna Chandra Prajapati
rpm -qa | grep mysql rpm -e mysqlpackagename Thanks, Krishna On Sat, Dec 19, 2009 at 2:05 PM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi, I have mysql 5.0.45 on Red Hat EL 5. How do i completely uninstall the same ? Thanks in advance. Jeetendra Ranjan

INSERT DATA INTO TABLE

2009-11-27 Thread Krishna Chandra Prajapati
Hi Experts, load data local infile and insert into tablename are the two methods of inserting data into a mysql table. Out of the above two method. Is there any faster method of inserting data into mysql tables. Thanks, Krishna Ch. Prajapati

Re: INSERT DATA INTO TABLE

2009-11-27 Thread Krishna Chandra Prajapati
mo...@fastmail.fm wrote: At 07:40 AM 11/27/2009, Krishna Chandra Prajapati wrote: Hi Experts, load data local infile and insert into tablename are the two methods of inserting data into a mysql table. Out of the above two method. Is there any faster method of inserting data into mysql

Re: question regarding mysql database location

2009-11-25 Thread Krishna Chandra Prajapati
Hi Manasi, At a time mysql can point to one data directory. For your task you can have n number of mysql installation with different data directory. After that you can use federated storage engine to perform your task. Thanks, Krishna Ch. Prajapati On Wed, Nov 25, 2009 at 12:19 PM, Manasi Save

Re: Virtual servers, Raid 10 or Raid 01 - your opinions?

2009-11-25 Thread Krishna Chandra Prajapati
Obviously raid 10 would be better choice!. Recommended for safety and performance. Thanks, Krishna Ch. Prajapati On Wed, Nov 25, 2009 at 4:34 PM, Götz Reinicke - IT-Koordinator goetz.reini...@filmakademie.de wrote: Hi, I do get two new Sun Fire X4170 servers with 8 SAS 300GB HDs, 24 GB

DELETE DATA FROM TABLE

2009-11-19 Thread Krishna Chandra Prajapati
Hi Experts, I have a crm table where 12 millions records inserted/day. We are running report queries on this table and using partitioning features for faster results. we have to maintain 45 days data means 540million records. As per my calculation 540 records will use 1.8 TB of disk space. Total

Re: DELETE DATA FROM TABLE

2009-11-19 Thread Krishna Chandra Prajapati
this, you should probably seek a bit more information about from this list or other sources. Regards, Gavin Towey -Original Message- From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] Sent: Thursday, November 19, 2009 12:13 AM To: MySQL Subject: DELETE DATA FROM TABLE

Re: mysql server is not starting

2009-11-11 Thread Krishna Chandra Prajapati
Hi faizal, Check your mysql error log file. Thanks, Krishna On Wed, Nov 11, 2009 at 4:17 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote: hi iam trying to start mysql services but it showing error. while i start it automatically goes to shutdown.. what is errmsg.sys? its looking this file but

Re: Temp file issues on Ubuntu 9.10

2009-11-09 Thread Krishna Chandra Prajapati
Hi Sebastiaan, Steps to fix the issue. 1. Do proper shutdown of mysql server. 2. Check the error log file that mysql server is shutdown properly. 3. Remove log files (ib_logfile0 and ib_logfile1). 4. Start mysql server (The log files will be created automatically) Thanks, Krishna On Sun, Nov 8,

Re: DROP TABLE TOOK 39MIN

2009-11-09 Thread Krishna Chandra Prajapati
Hi Michael, Already using innodb_file_per_table. Krishna On Mon, Nov 9, 2009 at 9:39 PM, Michael Dykman mdyk...@gmail.com wrote: Under InnoDb, you could use file-per-table which would have significantly reduced the inter-dependencies.. given the large data size and heavy I/O you report, it

Re: which mysql 64 bit binary for PowerEdge 1950 ?

2009-11-09 Thread Krishna Chandra Prajapati
Hi Sagar, You must use Intel EM64T Thanks, Krishna On Sat, Oct 31, 2009 at 5:45 AM, Sanjeev Sagar sanjeev.sa...@mypointscorp.com wrote: Hello Everyone, I would like to verify that which mysql 64 bit binary i need to use for PowerEdge 1950 ? Will it be *IntelEM64T* ? Following is the

DROP TABLE TOOK 39MIN

2009-11-08 Thread Krishna Chandra Prajapati
Hi Experts, I have a crm(customer resource management) table which contains 654 million records. Dropping table took 39min. In addition to this other queries become very slow and they are not associated with bkp_mtlog any way. why? mysql show table status like 'bkp_mtlog';

Re: 50M records each year.. how to handle

2009-11-02 Thread Krishna Chandra Prajapati
Hi Sudhir, I am handling 50M record each day. Your requirement can be easily full filled using partition and good architecture. Thanks, Krishna On Mon, Nov 2, 2009 at 2:57 PM, || Sudhir Nimavat || sudhir_nima...@yahoo.com wrote: I have come across a requirement where I need to store a very

CONNECTION (SOCKET AND TCP/IP)

2009-10-27 Thread Krishna Chandra Prajapati
Hi All, Any body can explain the difference between socket connection and tcp/ip connection. Thanks, Krishna

DEADLOCK MYSQL 5.1.37

2009-09-14 Thread Krishna Chandra Prajapati
Hi guys, I am getting very frequent deadlock in mysql 5.1.37. I am not able to understand why this below deadlock is coming. *** (1) TRANSACTION: TRANSACTION 0 1036157191, ACTIVE 0 sec, process no 4101, OS thread id 1908412736 fetching rows mysql tables in use 1, locked 1 LOCK WAIT 3 lock

Re: Mysql update query gives error of lock wait timeout

2009-08-29 Thread Krishna Chandra Prajapati
Increase your Innodb_buffer_pool_size. It will solve your problem. Thanks, Krishna On Sat, Aug 29, 2009 at 10:39 AM, Manasi Save manasi.s...@artificialmachines.com wrote: Hi All, I have a query which gives an error of lock wait timeout only this transaction is running with 2 records in

Re: Scaling Mysql

2009-08-24 Thread Krishna Chandra Prajapati
Yes, it's in our planning On Mon, Aug 24, 2009 at 11:10 PM, Gavin Towey gto...@ffn.com wrote: Have you looked at MySQL cluster? It was created specifically for telco needs. -Original Message- From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] Sent: Friday, August 21

Scaling Mysql

2009-08-21 Thread Krishna Chandra Prajapati
Hi list, I have two tables send_sms and alt_send_sms. Users are inserting records into send_sms @ 500/sec ie 3/min. After applying some updates to send_sms data are transferred to alt_send_sms and deleted from send sms. The same thing is happening with alt_send_sms table. Is it possible to

Re: Scaling Mysql

2009-08-21 Thread Krishna Chandra Prajapati
will be taken out from alt_send for processing and sending to client. All the above task are happening concurrently. We will be dealing with million of records/hour On Fri, Aug 21, 2009 at 6:11 PM, walter harms wha...@bfs.de wrote: Krishna Chandra Prajapati schrieb: Hi list, I have two

INFOBRIGHT STORAGE ENGINE

2009-07-30 Thread Krishna Chandra Prajapati
Hi, Is there anybody using infobright storage engine on production. Please let me know the performance. Thanks Krishna Chandra Prajapati

Re: INNODB INDEX SIZE

2009-06-26 Thread Krishna Chandra Prajapati
Chandra Prajapati prajapat...@gmail.com wrote: Hi guys, On MIS (management information system) server we have 16GB of physical memory. 10GB has been allocated to innodb_buffer_pool_size. Database size is around 500GB and some tables contains 600millions records. my question is if innodb

BULK DATA HANDLING 0.5TB

2009-06-12 Thread Krishna Chandra Prajapati
Hi guys, I'm working in a telecom company. I have table called deliverylog in which 30 million records gets inserted per/day. The table has grown to 0.5TB I have to keep 60days record in the table. So, 60days * 30 million = 1800 million records. The query is taking a lot of time to fetch the

MySQL: large_page_size

2009-05-21 Thread Krishna Chandra Prajapati
Hi, How much performance improvement we can get using large_page_size in mysql server. Is there anybody using on productions. Thanks, Prajapati Krishna Chandra Prajapati Email-id: prajapat...@gmail.com

MYSQLDUMP ERROR

2009-05-01 Thread Krishna Chandra Prajapati
for user 'dip'@'152.20.1.%' to database 'dip' when doing LOCK TABLES Thanks, Krishna Chandra Prajapati

Re: Oracle , what else ?

2009-04-22 Thread Krishna Chandra Prajapati
/mysql?unsub=fuller.art...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com -- Krishna Chandra Prajapati

Re: Does mysql support materialized views?

2009-04-20 Thread Krishna Chandra Prajapati
-- Krishna Chandra Prajapati

Re: Sun bought by Oracle

2009-04-20 Thread Krishna Chandra Prajapati
the Oracle umbrella, much like BerkeleyDB did? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com -- Krishna Chandra Prajapati

Re: Small InnoDB table with many concurrent queries

2009-04-20 Thread Krishna Chandra Prajapati
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com -- Krishna Chandra Prajapati

Re: Error code 121

2009-04-13 Thread Krishna Chandra Prajapati
-- Krishna Chandra Prajapati MySQL DBA, Mob: 9912924044

Re: Error code 121

2009-04-13 Thread Krishna Chandra Prajapati
Give the details what you are doing which gives the below issue. On Mon, Apr 13, 2009 at 4:03 PM, Kaushal Shriyan kaushalshri...@gmail.comwrote: On Mon, Apr 13, 2009 at 3:21 PM, Krishna Chandra Prajapati prajapat...@gmail.com wrote: prajap...@debian:~$ perror 121 OS error code 121: Remote

Re: Rename InnoDB database

2009-04-07 Thread Krishna Chandra Prajapati
Chandra Prajapati

Remote data

2009-03-18 Thread Krishna Chandra Prajapati
Hi all, I am looking for a solution. While being on one db server how to get the data from other server. One method is federated. Is there any other way Thanks, Krishna Chandra Prajapati

Is there any solution

2009-03-17 Thread Krishna Chandra Prajapati
Hi list, THE IDEA IS TO HAVE A COMMON LOGIN I have two mysql servers with different databases on each of them. I want to search each databases(few tables) on both the server using a single login(mysql connection) Procedure is working fine.but then i have to use two logins(mysql connection)

Re: enabling storage engine with RPM install

2009-02-19 Thread Krishna Chandra Prajapati
with RPMs? We've always just taken what we got and it was sufficient. Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com -- Krishna Chandra Prajapati MySQL DBA, Email-id: prajapat...@gmail.com

Re: Resend: enabling storage engine with RPM install

2009-02-19 Thread Krishna Chandra Prajapati
://www.weblyons.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com -- Krishna Chandra Prajapati MySQL DBA, Email-id: prajapat...@gmail.com

Reading table information......

2009-02-03 Thread Krishna Chandra Prajapati
version: 5.0.32-Debian_7etch8-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql -- Krishna Chandra Prajapati Mob: 9912924044 Email-id: prajapat...@gmail.com

Re: Data Inconsistent

2009-01-21 Thread Krishna Chandra Prajapati
://www.netintelligence.com/email -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony

Re: Data Inconsistent

2009-01-21 Thread Krishna Chandra Prajapati
-- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: prajapat...@gmail.com

Re: Applying an XML request to a database

2009-01-20 Thread Krishna Chandra Prajapati
requests OK, I just need to know how XML meets database. Are there any generalised pointers to begin with? Thanks in advance Jonathan Trahair -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number

Data Inconsistent

2009-01-20 Thread Krishna Chandra Prajapati
data than A and C. How to solve this issue. Krishna Chandra Prajapati

Re: Applying an XML request to a database

2009-01-20 Thread Krishna Chandra Prajapati
Yes On Tue, Jan 20, 2009 at 7:40 PM, cr.vege...@gmail.com wrote: Hi Krishna, I just tried the -X and -H options as you described. Works fine. Is it also possible to get -X or -H data from MySQL into PHP ? TIA, Cor - Original Message - From: Krishna Chandra Prajapati prajapat

Re: Data Inconsistent

2009-01-20 Thread Krishna Chandra Prajapati
' on server C after you issue that query? There's all sorts of things that could break replication... On Tue, Jan 20, 2009 at 7:21 AM, Krishna Chandra Prajapati prajapat...@gmail.com wrote: Hi Baron, In production we have three servers. A B -C

Re: Applying an XML request to a database

2009-01-20 Thread Krishna Chandra Prajapati
kind to give some pointers / refs ? Or may be a snippet ... TIA, Cor - Original Message - *From:* Krishna Chandra Prajapati prajapat...@gmail.com *To:* cr.vege...@gmail.com *Cc:* J Trahair j.trah...@foreversoftware.co.uk ; MySQL Generalmysql@lists.mysql.com *Sent:* Tuesday, January

Re: A tool

2009-01-20 Thread Krishna Chandra Prajapati
Thanks lakshmi On Wed, Jan 21, 2009 at 11:53 AM, lakshmi pathi lakshmipath...@gmail.comwrote: Hi Krishna Chandra Prajapati, How can i customize, to make it work on debian OS After months of search finally yesterday i got debian - Lastnight i tested giis binary with debian -- yes running

Re: stuck commits

2009-01-15 Thread Krishna Chandra Prajapati
. http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html Krishna On Wed, Jan 14, 2009 at 12:04 PM, Scott Edwards my...@foss.daxal.comwrote: On Tuesday 13 January 2009 07:23:52 am Krishna Chandra Prajapati wrote: Hi Scott, I believe something wrong with innodb parameters

mk-slave-restart

2009-01-12 Thread Krishna Chandra Prajapati
-restart root 22006 0.0 0.0 4004 700 pts/2S+ 14:51 0:00 grep mk-slave-restart Can you tell me whats wrong in the above syntax. It's not working. Please tell me the complete syntax. -- Krishna Chandra Prajapati

Re: stuck commits

2009-01-12 Thread Krishna Chandra Prajapati
Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: prajapat...@gmail.com

slave-skip-errors = 1048

2009-01-06 Thread Krishna Chandra Prajapati
Hi Baron, If, I have started mysql server with --slave-skip-errors=1048 then this error will be logged into mysql error file or not. Thanks, Prajapati Krishna Chandra Prajapati -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road

slave-skip-errors = 1048

2009-01-05 Thread Krishna Chandra Prajapati
Hi, If, I have started mysql server with --slave-skip-errors=1048 then this error will be logged into mysql error file or not. Thanks, Prajapati Krishna Chandra Prajapati

Re: Problem with MySQL prompt

2008-12-23 Thread Krishna Chandra Prajapati
, -Krishna Chandra Prajapati On Tue, Dec 23, 2008 at 2:00 PM, Stefano Elmopi stefano.elm...@sociale.itwrote: Hi Krishna, thanks for the your answer !!! I have three different my.cnf for my three instances but one general my.cnf to manage all instances, my general my.cnf

Re: Problem with MySQL prompt

2008-12-23 Thread Krishna Chandra Prajapati
to it. Thanks, Krishna Chandra Prajapati On Tue, Dec 23, 2008 at 5:14 PM, Stefano Elmopi stefano.elm...@sociale.itwrote: Hi Krishna, the problem is that you use --default-file on the command line and in this mode it's working fine, I also tried, but I have the configuration of the variable

Re: Problem with MySQL prompt

2008-12-22 Thread Krishna Chandra Prajapati
%3astefano.elm...@sociale.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com -- Krishna Chandra Prajapati Mob: 9912924044 Email-id: prajapat...@gmail.com

error writing communication package 1160

2008-12-07 Thread Krishna Chandra Prajapati
Hi all, I am getting the below error on one of mysql server Got an error writing communication packets Error_code: 1160 How i can fix it. Increasing max_allowed packet will help. max_allowed_packets = 1M -- Krishna Chandra Prajapati MySQL DBA, Mob: 9912924044 Email-id: [EMAIL PROTECTED]

  1   2   3   >