Re: delete syntax

delete from mysql.user where user='mail_admin'; Krishna On Fri, Dec 2, 2011 at 7:23 AM, Tim Dunphy 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 rows affected (

Re: Backup Policy

xtrabackup, mysqlhotcopy for myisam, incremental backup using zamanda. Krishna On Tue, Mar 15, 2011 at 9:09 PM, petya 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 in Da

Re: best way to have a unique key

uuid() Krishna On Fri, Jan 21, 2011 at 12:02 AM, Anthony Pace wrote: > 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 to another machine. > >

Re: Large table

partitioning will help u Krishna On Fri, Jan 14, 2011 at 4:18 AM, Sairam Krishnamurthy wrote: > 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 of 22 million

Re: Error while running Mysql

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 wrote: > Dear all, > > I am able o successfully build Mysql 5.5.8 from its sour

Re: MySQL Parallel Inserts

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 wrote: > Greetings everyone. > > I am in a situation where I need to do parallel inserts into MySQL database > from inside my Perl program.

Re: WTA Increasing InnoDB Speed

Hi Willy, Try percona server. It gives better performance than mysql. Krishna On Sat, Oct 23, 2010 at 3:37 AM, Willy Mularto 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. The server is a h

Re: Purposely Corrupting a table

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 wrote: > Ok, been googling all morning, and keep getting the same post (on > multiple different sites). > >

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

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 wrote: > Hi, > > I am using the following version of MySQL on my Mac

Re: How to Install mysql from source

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 wrote: > Hello List, > > i am trying to install mysql on debian lenny from source. Here is what > i did (yes, i did rea

Re: Primary key not unique on InnoDB table

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 wrote: > I've the following table. But why isn't the primary key unique, e.g. > preventing duplicates if entered ? > >

Re: Backup

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 a

Re: How to extend innodb files?

u can reclaim the free space if required simply by dropping the table. _Krishna On Tue, Sep 28, 2010 at 5:16 PM, Vokern wrote: > 2010/9/28 Krishna Chandra Prajapati : > > Hi Vokern, > > > > I suggest to have a single ibdata1 file and use innodb_file_per_table to >

Re: How to extend innodb files?

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 wrote: > Hello, > > Currently I have the setting: > > > innodb_data_file_path=ibdata1:10G;ibdata2:10G;ibdata3:10G;ibdata4:10G:autoe

Re: MySQL Server has gone away

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 wrote: > Hi, > > Whenever i run any commnd on mysql it gives message as below then gives the > result successfully. What is the reason of the below error message :

Re: mysql is crashing

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

Re: mysql is crashing

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

Re: phpMyAdmin and other management tools

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 wrote: > Hi Folks, > > > > I'm currently using phpMyAdmin to manage the mySQL databases. I'm > wonderi

Re: Table creation fail

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` MEDIUMTE

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

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 wrote: > Hey all - > > I have a table with 12,000,000 records spread ove

Re: large table issue

Hi, MySQL Partitioning will help you a lot. Try it. Regards, Krishna 2010/6/2 曹凯 > > 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 balancing. >

Re: Replication : request DELETE is not executed on slave

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 o

Re: Mysql - Tables Export to Excel!

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 wrote: > Hi, > > I would like to export my table structure from MYSQL from a particular db. > Is there any tool for d

Re: Can't drop index

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

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

Re: MySQL Storage Engine

- 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 wrote: > Hi > > How do you mean "executed on slave" ? > > Neil > > > On Thu, Mar 18, 2010 at 9:32 AM, Krishna Chandra P

Re: MySQL Storage Engine

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

Re: Replication - LINUX to WIN

Yes, go ahead. -Krishna On Thu, Mar 18, 2010 at 2:03 PM, Vikram A 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 replication LINUX(Mast

Re: mysql proxy in production?

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

Re: mysql proxy in production?

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/ http://www.alobbs.com/1344/MySQL_asynchronous_balancing_with_HTTP_

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

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 wrote: > I am experiencing very slow deletes when I delete a record from a master > table and have cascading d

Re: mysql proxy in production?

Hi Brent You can visit the below link. 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 wrote:

Re: Enabling Slow query log in Mysql 5.0

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 wrote: > Hi All > > > >I hope that someone can assist me with this. > > > >We have a client

ERROR

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 DCTNMV

Re: Sharding

rizontal%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 experienc

Re: SCALING INSERT

way to do so. (distributed servers) Thanks, Krishna On Thu, Jan 21, 2010 at 7:39 PM, Shawn Green 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 ea

Re: Sharding

> > http://datacharmer.blogspot.com/2009/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 &

Sharding

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: mysql update

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, Krishn

LOAD BALANCER

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

SCALING INSERT

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

Re: Selecting, Inserting and Deleting data

perty, 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

Re: Selecting, Inserting and Deleting data

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

Selecting, Inserting and Deleting data

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 base

Re: innodb recovery

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 wrote: > Hello! > > I g

Re: Replications oddity.

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 Clar

Re: Error in running trigger

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 `C

Re: Uninsall mysql 5.0.45 from RHEL 5

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

Re: INSERT DATA INTO TABLE

japati On Sat, Nov 28, 2009 at 3:50 AM, mos wrote: > At 07:40 AM 11/27/2009, Krishna Chandra Prajapati wrote: > >> Hi Experts, >> >> load data local infile and insert into are the two methods of >> inserting data into a mysql table. >> >> Out of

INSERT DATA INTO TABLE

Hi Experts, load data local infile and insert into 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: Virtual servers, Raid 10 or Raid 01 - your opinions?

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 G

Re: question regarding mysql database location

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: DELETE DATA FROM TABLE

ta. If you need to do 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:

DELETE DATA FROM TABLE

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 d

Re: mysql server is not starting

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 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 it was not there

Re: which mysql 64 bit binary for PowerEdge 1950 ?

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

Re: DROP TABLE TOOK 39MIN

Hi Michael, Already using innodb_file_per_table. Krishna On Mon, Nov 9, 2009 at 9:39 PM, Michael Dykman 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 might be a wis

Re: Temp file issues on Ubuntu 9.10

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,

DROP TABLE TOOK 39MIN

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

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 ver

CONNECTION (SOCKET AND TCP/IP)

Hi All, Any body can explain the difference between socket connection and tcp/ip connection. Thanks, Krishna

DEADLOCK MYSQL 5.1.37

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 struct(

Re: Mysql update query gives error of lock wait timeout

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 recor

Re: Scaling Mysql

Yes, it's in our planning On Mon, Aug 24, 2009 at 11:10 PM, Gavin Towey 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:

Re: Scaling Mysql

g/min 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 wrote: > > > Krishna Chandra Prajapati schrieb: > > Hi list

Scaling Mysql

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 in

INFOBRIGHT STORAGE ENGINE

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

Re: INNODB INDEX SIZE

Thanks, I am looking answer internally how the thinks work. Regards, Krishna On Fri, Jun 26, 2009 at 2:33 PM, Moon's Father wrote: > Hi. > I think innodb will split these into many small pieces and then merge them > to execute. > > > On Thu, Jun 18, 2009 at 1:52 PM, Kr

BULK DATA HANDLING 0.5TB

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 resul

MySQL: large_page_size

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

nied for user 'dip'@'152.20.1.%' to database 'dip' when doing LOCK TABLES Thanks, Krishna Chandra Prajapati

Re: Oracle , what else ?

gt;> > > Personally I would be surprised if the Oracle deal goes unchallenged. >> I >> > > don't think Oracle really 'want' MySQL as it makes very little money >> and >> > > it raises competition concerns. I wouldn't be surprised if Oracle were >> to >> > > look at offloading MySQL to ease competition fears, perhaps to someone >> > > like Google who are already heavily involved in the development of >> MySQL. >> > > >> > > >> > > On Tue, 2009-04-21 at 22:36 +0100, Andy Shellam wrote: >> > > >> > > > Personally (and I hope I'm wrong) I don't believe there's room in >> > > > Oracle's portfolio for two diverse RDBMSs, and I envisage them >> > > > re-branding MySQL as an Oracle open-source derivative which begins >> as >> > > > being the MySQL codebase but is slowly migrated toward Oracle's >> > > > engineering, to ease the transition for growing companies moving >> from >> > > > MySQL/Oracle open-source to the Oracle enterprise versions. >> > > >> > > >> > > -- >> > > MySQL General Mailing List >> > > For list archives: http://lists.mysql.com/mysql >> > > To unsubscribe: >> > > http://lists.mysql.com/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: Small InnoDB table with many concurrent queries

= 16 > innodb_flush_log_at_trx_commit = 2 > innodb_log_buffer_size = 8M > innodb_lock_wait_timeout= 120 > innodb_log_file_size= 256M > innodb_log_files_in_group = 3 > > ------ > > > thanks for any info > > -- > 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: Sun bought by Oracle

the above article. Will it eventually come under 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: Does mysql support materialized views?

; ----- > Lin Chun > -- Krishna Chandra Prajapati

Re: Error code 121

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

Re: Error code 121

prajap...@debian:~$ perror 121 OS error code 121: Remote I/O error On Mon, Apr 13, 2009 at 3:16 PM, Kaushal Shriyan wrote: > Hi > > what does error 121 means in mysql. is there a way to find out the > description of error code 121. > > Thanks and Regards > > Kaushal

Re: Rename InnoDB database

ttp://lists.mysql.com/mysql?unsub=prajapat...@gmail.com > > -- Krishna Chandra Prajapati

Remote data

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

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) (Fed

Re: Resend: enabling storage engine with RPM install

have 5.0.22 installed on a test machine and for some reason the > >> innodb > >> > > storage engine was not installed with it. We install from RPMs so > I'm > >> > not > >> > > sure how to install the storage engine. If we compiled ourselves, > we'd > >> > > recompile but that's not an option. > >> > > > >> > > Does anyone know how to install a storage engine once mysql's been > >> > installed > >> > > by an RPM? How does one make the selections in the first place 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 > >> > > > >> > > >> > > >> > > >> > -- > >> > Baron Schwartz, Director of Consulting, Percona Inc. > >> > Our Blog: http://www.mysqlperformanceblog.com/ > >> > Our Services: http://www.percona.com/services.html > >> > > >> > >> > >> > >> -- > >> Jim Lyons > >> Web developer / Database administrator > >> http://www.weblyons.com > >> > >> > > > > > > -- > > Jim Lyons > > Web developer / Database administrator > > http://www.weblyons.com > > > > > > -- > Jim Lyons > Web developer / Database administrator > http://www.weblyons.com > -- Krishna Chandra Prajapati MySQL DBA, Email-id: prajapat...@gmail.com

Re: enabling storage engine with RPM install

ctions in the first place 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

Reading table information......

\g. Your MySQL connection id is 278 Server 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

column > >> > part. > >> > > >> > > >> > > >> > -- > >> > MySQL General Mailing List > >> > For list archives: http://lists.mysql.com/mysql > >> > To unsubscribe: > >> > > http://lists.my

Re: Data Inconsistent

ce > > http://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 P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: prajapat...@gmail.com

Re: A tool

Thanks lakshmi On Wed, Jan 21, 2009 at 11:53 AM, lakshmi pathi wrote: > 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 -- ye

Re: Applying an XML request to a database

// Free resultset mysql_free_result($result); // Closing connection mysql_close($link); ?> On Tue, Jan 20, 2009 at 11:31 PM, wrote: > Hi Krishna, > > Would you be so kind to give some pointers / refs ? > Or may be a snippet ... > > TIA, Cor > > - Original Message

Re: Data Inconsistent

status\G' 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 > wrote: > > Hi Baron, > > > > In production we have three servers. > &g

Re: Applying an XML request to a database

Yes On Tue, Jan 20, 2009 at 7:40 PM, 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 Ch

Data Inconsistent

r C will have different data than A and C. How to solve this issue. Krishna Chandra Prajapati

Re: Applying an XML request to a database

gt; working on generating the XML 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, Sindh

Re: stuck commits

. 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 wrote: > On Tuesday 13 January 2009 07:23:52 am Krishna Chandra Prajapati wrote: > > Hi Scott, > > > > I believe something wrong with innodb par

Re: stuck commits

ysql.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 P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: prajapat...@gmail.com

mk-slave-restart

-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

slave-skip-errors = 1048

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

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

fault available to it. Thanks, Krishna Chandra Prajapati On Tue, Dec 23, 2008 at 5:14 PM, Stefano Elmopi wrote: > > 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 con

Re: Problem with MySQL prompt

'\c' to clear the buffer. mysql5.1.30> Thanks, -Krishna Chandra Prajapati On Tue, Dec 23, 2008 at 2:00 PM, Stefano Elmopi wrote: > > Hi Krishna, > > thanks for the your answer !!! > > I have three different my.cnf for my three instances but one general my.cnf > to man

Re: Problem with MySQL prompt

3466147165 > tel. 0657060500 > email:stefano.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

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   >