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_a
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,
>>
>
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 a
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 chunk
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
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
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 se
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
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 My
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
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 ?
>
>
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
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
>
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
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 e
Hi Yectli,
I am talking about mysql server. Is it 32bit or 64bit.
Provide some additional information. mysql configuration file, show
variables, Error log file details etc.
Kirshna
On Fri, Aug 13, 2010 at 8:36 PM, Yectli Huerta wrote:
> On Fri, Aug 13, 2010 at 04:33:38PM +0530, Kris
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,
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 m
; `resultsdescription` MEDIUMTEXT DEFAULT NULL ,
-> `resultsdate` DATE DEFAULT NULL ,
-> `nextdate` DATE DEFAULT NULL ,
-> `ptlevel` VARCHAR( 10 ) DEFAULT NULL ,
-> `givenhere` INTEGER not null primary key);
Query OK, 0 rows affected (0.11 sec)
Krishna
On Wed, Jun 23, 201
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 recor
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 )
or some thing
else.
Does the delete command exits in binlog.
Regards,
Krishna
On Wed, Apr 28, 2010 at 2:37 PM, David Florella wrote:
> Hi,
>
>
>
> I am using MySQL replication :
>
>
>
> - The version of the master is 4.1.12-log
>
> - T
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 t
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
Hi guys,
Is the information is true.
http://planet.mysql.com/
http://tokutek.com/2010/04/tokutek-acquires-oracle/
Regards,
Krishna
- 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
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:
>
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
faster among the
web**servers. According to this benchmark, Cherokee is, for instance,
79% **faster than Apache, and 18% faster than nginx.*
Thanks,
Krishna
On Fri, Mar 12, 2010 at 5:12 PM, Johan De Meersman wrote:
> On Thu, Mar 11, 2010 at 4:49 PM, Brent Clark >wrote:
>
> > O
/1344/MySQL_asynchronous_balancing_with_HTTP_JSON.html
Thanks,
Krishna
On Fri, Mar 12, 2010 at 10:32 AM, Walter Heck - OlinData.com <
li...@olindata.com> wrote:
> Take a look at haProxy. It can be combined with some scripts to
> loadbalance mysql.
>
> http://www.alexwilliams.ca/blog/2009/08/10/using-haproxy
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 cas
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
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.
>
>
>
>
7 02:40:07 DCTNMVH1 kernel: cpu 9 hot: high 186, batch 31 used:25
Feb 7 02:40:07 DCTNMVH1 kernel: cpu 9 cold: high 62, batch 15 used:44
Is the error related to mysql. Any body else facing similar issues.
Thanks,
Krishna
Thanks a lot.
On Fri, Jan 29, 2010 at 8:50 AM, Carlos Proal wrote:
>
> Krishna
> I dont have any benchmark but you can take a look on the Cafepress
> presentation that includes some data (or ask the authors for deep reference)
>
> http://assets.en.oreilly.com/1/event/2/Ho
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
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 wrote:
>
> Hi Krishna
>
> Depending on your programming language, you can use http://www.hivedb.org/
>
> Also yo
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
,
Krishna
On Fri, Jan 22, 2010 at 12:25 PM, madunix wrote:
> I have the following update procedure that update mySQL DB over the
> internet between source Linux Centos (local machine on my net behind a
> DMZ with real IP A.B.C.D) and target Linux fedora (web server
> www.myweb.com) ev
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
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
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
Hi Suresh,
my question is how i can run concurrent connection with the above work load.
Thanks,
Krishna
On Thu, Jan 21, 2010 at 4:46 PM, Suresh Kuna wrote:
> Hi Krishna,
> As table is using MyISAM engine and it acquires a table level lock, the
> queries will be executed one after o
rrent queries. As duplicate messages will be send. What
can be the solution for this ?
Any response is highly appreciated.
Thanks,
Krishna
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!
&g
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
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 de
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
Hi Mos,
In the below two command does 1 is faster than 2.
*
1. LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;*
2. *LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet* *LINES
TERMINATED BY '\r\n' enclosed by '"';*
Thanks,
Krishna Ch. Pra
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
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 SA
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
r the immediate response.
Thanks & Regard,
Krishna Ch. Prajapati
On Thu, Nov 19, 2009 at 2:22 PM, Gavin Towey wrote:
> Assuming you're using either myisam tables, or innodb with file-per-table
> option turned on, then dropping a whole partition at a time will allow you
> to
disk space
available is 2.3TB.
Deleting data doesn't free up the disk space. So, I was thinking of rotating
the table. But doesn't have enough disk space.
Any Idea, how this task can be performed.
Any idea or suggestion is highly appreciated.
Thanks & Regards,
Krishna Ch. 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 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
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 ?
>
>
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 m
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
|
partitioned| |
+---++-++---++--+-+--+-++-+-++---+--++-+
1 row in set (2 min 11.29 sec)
mysql> drop table bkp_mtlog;
Query OK, 0 rows affected (39 min 7.39 sec)
Thanks,
Krishna
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 t
Hi All,
Any body can explain the difference between socket connection and tcp/ip
connection.
Thanks,
Krishna
(`sql_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3168162 DEFAULT CHARSET=latin1
Thanks,
Krishna
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
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:
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
insert 1000records/sec in send_sms table and taken out at
the rate 1000records/seconds from alt_send_sms.
Which engine is more better for the above senario.
Regards,
Krishna
Hi,
Is there anybody using infobright storage engine on production. Please let
me know the performance.
Thanks
Krishna Chandra Prajapati
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
h the result.
Please sugget me what storage engine must be used and how i can get the
things done. Is there any other alternative.
Any response is highly appreciated.
Thanks,
Krishna
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
nied for user 'dip'@'152.20.1.%' to
database 'dip' when doing LOCK TABLES
Thanks,
Krishna Chandra Prajapati
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
= 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
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
; -----
> Lin Chun
>
--
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
wrote:
> On Mon, Apr 13, 2009 at 3:21 PM, Krishna Chandra Prajapati <
> prajapat...@gmail.com> wrote:
>
>> prajap...@debian:~$ perror 121
>> OS error
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
ttp://lists.mysql.com/mysql?unsub=prajapat...@gmail.com
>
>
--
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
)
(Federated is not working efficiently)
Is there any solution apart from scripting.
--
Krishna
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
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
\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
nks,
Krishna
On Wed, Jan 21, 2009 at 9:29 PM, John Daisley <
john.dais...@mypostoffice.co.uk> wrote:
> I think maybe in the default sql_mode 5.0 is more forgiving when it comes
> to accepting invalid values, quietly converting them to the nearest
> acceptable value and giving a warning
t; > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk
> >
> >
> > __
> > This email has been scanned by Netintelligen
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
// 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
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
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
r C will have different data than A and C.
How to solve this issue.
Krishna Chandra Prajapati
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
.
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
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
-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
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
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
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
'\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
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
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 - 100 of 291 matches
Mail list logo
