Hi,
It sounds like a bad case of transactions handling by the application. If you
have transactions/statements open for very long time, the list which contains
the unflushed changes, grows. These unflushed changes will slow down the purge
and in extreme cases, will also affect the DMLs.
So,
Sent: Friday, April 5, 2013 11:26 AM
Subject: Re: MySQL on RHEL4
On 2013-04-05, Nitin Mehta ntn...@yahoo.com wrote:
We're trying to upgrade our existing MySQL 5.1.26 to MySQL 5.1.68 but the
installation gives error:libc.so.6(GLIBC_2.4) is needed by
MySQL-server-community-5.1.68-1.rhel5
Hi,
We're trying to upgrade our existing MySQL 5.1.26 to MySQL 5.1.68 but the
installation gives error:
libc.so.6(GLIBC_2.4) is needed by MySQL-server-community-5.1.68-1.rhel5.i386
rtld(GNU_HASH) is needed by MySQL-server-community-5.1.68-1.rhel5.i386
Now, GLIBS2.4 is not available for
Hi,
There was sort of a bug which was fixed in MySQL 5.5 with replication
heartbeat. Before the replication heartbeat, a new relay log file would be
created after every slave_net_timeout. It doesn't have any negative impact
though.
Hope that helps.
From:
Hi Tim,
It looks like your '.sql backup file' has changed the password for root user
and why it is persisting is perhaps you have data directory outside the install
directory.
How you correct the problem:
Stop the service, start the service with option '--skip-grant-tables', login
with root
get the below
error . What can be the reason and how can i repair it ?
Regards
Mysql_error: Table ./x/y ' is marked as crashed and should be repaired
--
Regards,
/Nitin Mehta/
Hi Aastha,
I'm not 100% sure but you could try defining the full connectstring using:
ndb-connectstring = localhost:1186
See if that helps.
Regards,
From: Aastha aast...@gmail.com
To: mysql@lists.mysql.com
Sent: Sunday, September 23, 2012 7:51 AM
I'm more of an hit and try guy and do good only with a data set available.
Still I think making a little change might do the trick.
SELECT DISTINCT
p.productid,
pd.name
FROM menu_product as p
INNER JOIN menu as m ON (m.menuid = p.menuid AND m.name = 'name obtained from
!
Regards,
From: Brown, Charles cbr...@bmi.com
To: Nitin Mehta ntn...@yahoo.com
Cc: mysql@lists.mysql.com mysql@lists.mysql.com
Sent: Thursday, May 3, 2012 4:24 PM
Subject: master BIN-LOG maintenace
Hi Gurus,
I would like to set BIN-LOG maintenance procedure
Thanks for your kind words, Charles! It comes easily to you when you have
experienced it. I'm glad it worked for you.
From: Brown, Charles cbr...@bmi.com
To: Nitin Mehta ntn...@yahoo.com
Cc: mysql@lists.mysql.com mysql@lists.mysql.com
Sent: Thursday, May 3
I guess, it only makes things even more simple.
You should use replicate-do-table=db1.tb1 and so one in slave's cnf to ensure
that only this particular table gets replicated. However, all the databases on
master will get bin-logged and you may or may not want to do that.
So making it even
on slave. So in one word response to your question, no!
Hope that helps!
Also, please reply to all so the people, helping you, know about the status of
your problem.
Regards,
From: Brown, Charles cbr...@bmi.com
To: Nitin Mehta ntn...@yahoo.com
Sent
Hi Jeff,
threads_connected tells you total number of connections created since server
startup and threads_cached says how many stay alive (connection pooling) even
if there are no clients connected. This means that because the value of
threads_cached was reduced on your server, it is having
I'm not sure but you might try with sql_mode set to ANSI. Otherwise try the
dump
remotely from a Linux box.
Regards,
Nitin
From: Manasi Save manasi.s...@artificialmachines.com
To: win.a win@gmail.com
Cc: mysql@lists.mysql.com mysql@lists.mysql.com
Sent:
Hi,
Have you recently upgraded your MySQL installation? 1064 in earlier days used
to
mean use of reserved word. Few clients have reported this error in last couple
of months after they upgraded from 5.1.41 to higher versions. As of now, I
don't
have a solution other than changing the name
I believe that will not be logged unless you have enabled log_warnings. Too
many
connections would normally mean that the number is going beyond the configured
limit and denying new sessions is an expected behavior and should not be an
error really.
Regards,
Nitin
Manasi,
Your table structure doesn't show that the column TestID is unique. I believe
what Michael also suggested was that unless this column contains unique values,
you never know which row your procedure is reading.
I hope I'm making myself understood.
Regards,
Nitin
Hi,
This is probably very simple for someone who has encountered the problem before
but I'm struggling to find how I can contain the MySQL error log from being
flushed at FLUSH LOGS command. This command is executed as part of the
database backup every night and simply moves the old error log
Hi,
First thing that comes to my mind is that it is probably the best time to put
your application server and database server on different hosts. Having said
that, in this case increasing buffer pool size is still advisable as per my
understanding. Your swap consumption will go up in that case
Thanks, Prabhat! You're very right, but did you read the questions I asked?
From: Prabhat Kumar aim.prab...@gmail.com
To: Nitin Mehta ntn...@yahoo.com
Cc: mysql@lists.mysql.com
Sent: Tue, May 11, 2010 11:54:22 AM
Subject: Re: starting multiple instances
Hi,
I am exploring multiple instances with MySQL which will be running using the
same set of binaries (single MySQL base). Two things which I'm not able to work
out are -
1. Why mysqld_multi stop grp_id doesn't work? Well, I know why it
doesn't because there is nothing in the script
I think you've got it a little wrong. In MySQL, transaction log is different
from bin-log. Transaction logs are used only for Innodb while bin-logs are
optional and capture data related to all the storage engines. I believe, you
cannot read thru the transaction logs and these logs files (used
Is mysql the owner of the directories?
- Original Message
From: Manasi Save manasi.s...@artificialmachines.com
To: Johan De Meersman vegiv...@tuxera.be
Cc: Waynn Lue waynn...@gmail.com; mysql mysql@lists.mysql.com
Sent: Wed, November 25, 2009 8:12:25 PM
Subject: Re: question regarding
Hi,
- Original Message -
From: Alan Williamson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 31, 2004 5:17 PM
Subject: CURDATE() bug?
Could anyone tell me if this is a bug or not.
SQL: SELECT CURDATE()+0;
RESULT: 20040331
Thats good. However consider this:
please include the query, you are using with no success and also specify the
version of your mysql.
Nitin
- Original Message -
From: Ed Reed [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 29, 2004 1:27 PM
Subject: Access to MySQL query problem
I'm coverting an Access
Hello buddy,
try installing
MySQL-shared-compat for your platform
HTH
Nitin
- Original Message -
From: Timothy Venn [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 29, 2004 7:13 PM
Subject: Libmysqlclient.so.14 on Solaris 2.8 (SPARC)
Hello,
Please can someone tell
which ver of mysql are you using? multiple table update is possible only
with ver starting from 4.0.4.
HTH..
Nitin
- Original Message -
From: Laercio Xisto Braga Cavalcanti [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, March 26, 2004 11:39 PM
Subject:
You need to download Dynamic client libraries - (including 3.23.x
libraries) to satisfy these dependencies. This is available on mysql
download page. Choose for your particular version.
And if that helps, read the installation procedure, next time before
installation.
Hope that helps
Nitin
you can very well use those files, though, im not sure, if you can check the
table structure bafore restoring it.
HTH
Nitin
- Original Message -
From: dan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 23, 2004 9:34 PM
Subject: using old frm files
we had a database
mysql doesn't write any files to any directory other than its data
directory, so try:
SELECT * INTO OUTFILE 'Results.txt' FROM Answer;
and then copy it whereever you want.
HTH
Nitin
- Original Message -
From: Rick Duley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Geoff Roy [EMAIL
i dont think its possible. you can do it by using time_to_sec() function of
mysql and then sec_to_time after addition
Hope that helps
Nitin
- Original Message -
From: Elly Wisata [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 19, 2004 10:08 AM
Subject: Sum for time
Hi *,
Hi,
- Original Message -
From: Chris Knipe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, March 20, 2004 12:33 PM
Subject: *very* strange...
Lo everyone,
I'm *baffled* completely I've never seen something like this
before.
: I tried this exact query from PHP,
UPDATE `Table A`,`Table B` SET `Table A`.`text`=concat_ws('', `Table
B`.`B-num`, from ,`Table B`.`date`) WHERE `Table A`.`A-num` = `Table
B`.`A-num`
Hope it works
Nitin
- Original Message -
From: Wouter Coppieters [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, March 13, 2004
UPDATE `Table A`,`Table B` SET `Table A`.`text`=concat_ws('', `Table
B`.`B-num`, from ,`Table B`.`date`) WHERE `Table A`.`A-num` = `Table
B`.`A-num`
Hope it works
Nitin
- Original Message -
From: Wouter Coppieters [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, March 13, 2004
WHERE (nickname = '$nickname') and (password = '$password'), $connection);
remember to place quotes around the value
nickname = $nickname wont work but
nickname = '$nickname' will do
Hope that helps
Nitin
- Original Message -
From: electroteque [EMAIL PROTECTED]
To: Togochog
there must be some problem in concatenation of strings and number variables. If you
can send the lines, we'll be able to suggest the exact change.
Hope that helps
Nitin
- Original Message -
From: CurlyBraces Technologies ( Pvt ) Ltd
To: [EMAIL PROTECTED]
Sent: Tuesday,
that's called, cache-hit
- Original Message -
From: Matt W [EMAIL PROTECTED]
To: Mike Mapsnac [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 5:25 AM
Subject: Re: run query second time
Hi Mike,
- Original Message -
From: Mike Mapsnac
Sent: Monday,
are you using MySql 4.x?
try only
mysql
Hope that helps
Nitin
- Original Message -
From: Davut Topcan [EMAIL PROTECTED]
To: Maria Yndefors [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 3:37 PM
Subject: Fw: install problem
Hi,
From: Maria Yndefors [EMAIL
Hi all,
I m looking for any function or a work around to fetch numerical data without its sign
(-10 -- 10, 10 -- 10). Any ideas?
Thanx
subqueries are introduced in 4.1 only
- Original Message -
From: Emmanuel Ohannessian [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 26, 2004 12:10 PM
Subject: subqurey syntax error
I am getting the error message:
mysql SELECT s1 FROM t1 WHERE s1 IN(SELECT s1
function can b used, but value parameter seems syntactically wrong, check
that.
'#session.month#' to '$month'
which is the language,u r using anyway?
- Original Message -
From: Yves Arsenault [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 6:37 PM
Subject:
Hi everybody,
I dont know, if it's been asked before, I was looking for the syntax to fetch dynamic
no of column, which are actually the record values. I dont know, if it's possible with
mysql as it doesn't yet provide sub-query feature (prod ver).
I need to select a column's value as
thanx for reply but not a good idea. Though i did it through PHP script
Nitin
- Original Message -
From: Mechain Marc [EMAIL PROTECTED]
To: Nitin Mehta [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 16, 2004 1:38 PM
Subject: RE: is this possible?
To drop all tables, yes
it cannot b related with primary key. i do not hav any idea how u update it,
but it's supported to update any dat in any table with or without PK
- Original Message -
From: Hans van Dalen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 6:20 PM
Subject: table
hello everybody,
i was wondering, if there's a single command to drop all or selected tables from the
database, something like, where i can give the table names (1-2-3) not to be deleted.
Thanx in advance
Nitin
i dont think that, cauz 'Password' field in 'user' table was always 16 char
long and still is. In fact, check for the no. of privs in 'user' table. if
it is 21 or 14, as in 3.23.x it was 14 and in 4.0.17 is 21.
Hope that helps
Nitin
- Original Message -
From: Director General: NEFACOMP
If the data is 10-char in length always, CHAR is better performance-wise.
- Original Message -
From: Hassan Shaikh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, January 11, 2004 6:34 PM
Subject: Which one is better: CHAR or VARCHAR?
Hi,
I've a column of type VARCHAR(10) where
these are definitely MySQL connection identities. Each with specific
(different) privileges. You can connect to the database directly with these.
- Original Message -
From: Matthew Stuart [EMAIL PROTECTED]
To: MySQL email support [EMAIL PROTECTED]
Sent: Monday, January 12, 2004 6:32 PM
you need not write any scripts, just use MySQL Front to Import/Export dat from M$
Access
zzapper [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]
Hi Ya,
How to this has always been somewhat fuzzy in my head. I looked around
for tools unsuccessfully . So I thought I'd share my
first download and install Dynamic client libraries
(including 3.23.x libraries) available on same page to satisfy the
dependencies
Enjoy
Nitin
- Original Message -
From: Nikos Gatsis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 6:01 PM
Subject: MySQL 4.1
You can just install MyODBC on the client (running MS Access) then you can
link tables stored anywhere.
have a look at:
http://forums.devshed.com/t56700/s.html
for more info
Hope that helps
Nitin
- Original Message -
From: Matthew McNicol [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
You dont need Apache to run MySQL. Apache is a web server, which is required
to publish web pages. So the answer is yes.
Enjoy
Nitin
- Original Message -
From: EP [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 09, 2004 9:53 AM
Subject: Mysql by itself?
OK, I need to
Oh, if that's the case, I'm sorry for false info.
Of course, if server is not accessible, then you cannot connect to it
anyway, directly or through Access.
Sorry again
Nitin
- Original Message -
From: Daniel Kasak [EMAIL PROTECTED]
To: Nitin Mehta [EMAIL PROTECTED]; Matthew McNicol
Hi all,
as the subject of the mail says, is there any function to apply in a query, that finds
out if the value returned from the database is numeric?
thanx for help in advance
Nitin
- Original Message -
From: Mike [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 05, 2004 10:53 AM
Subject: Re: Table: NULL (yes or no)
I create two tables. And when I do
desc table_name;
NULL value can be 'Yes' or 'No'. What the difference when NULL value is
'Yes' or
move the data files to another directory (partition) and create symlinks in
original directory
- Original Message -
From: Mike Mapsnac [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 03, 2004 7:42 PM
Subject: Delete logs: not enough space on /var/lib/mysql
I don't
56 matches
Mail list logo