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
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
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
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
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
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
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.
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
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
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
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
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
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:
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
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
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
+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
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
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
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
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
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
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
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
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
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
- 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
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/
...@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
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 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
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
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
%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
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
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,
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
/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
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
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
-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
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
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 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
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 definer=`*root...@`` TRIGGER
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 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
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
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
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
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
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
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
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,
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
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
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';
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
Hi All,
Any body can explain the difference between socket connection and tcp/ip
connection.
Thanks,
Krishna
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
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
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
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
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
Hi,
Is there anybody using infobright storage engine on production. Please let
me know the performance.
Thanks
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
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
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
for user 'dip'@'152.20.1.%' to
database 'dip' when doing LOCK TABLES
Thanks,
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
--
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
--
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
--
Krishna Chandra Prajapati
MySQL DBA,
Mob: 9912924044
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
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
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)
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
://www.weblyons.com
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
--
Krishna Chandra Prajapati
MySQL DBA,
Email-id: prajapat...@gmail.com
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
://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
--
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
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 than A and C.
How to solve this issue.
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
' 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
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
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
.
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
-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
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
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
,
-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
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
%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
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 267 matches
Mail list logo