with the same action time and event for one table'
Or any other alternate to do the same ?
Thanks Regards
Jeetendra Ranjan
--
Jesper Wisborg Krogh
Team Lead
Noggin IT • Level 8, 28 Foveaux St, Surry Hills NSW Australia 2010
T: +61 2 9219 8800 • F: +61 2 9280 4669 • E: jes...@noggin.com.au
On 09/12/2009, at 5:10 PM, Jeetendra Ranjan wrote:
Hi,
After analysing slow query log i found that some queries are not
using index and so i used the force index command in query and test
it and now it starts using index properly.Accordingly i implemented
the same query with force index
On 09/12/2009, at 6:56 PM, machiel.richards wrote:
Good day guys (and girls if any)
I am constantly in a position where variables on a
production mysql database needs to be changed.
The database runs a 24/7 system and thus to reboot
is not
preffered and
On Wed, 16 Dec 2009 07:39:09 Cantwell, Bryan wrote:
I have a situation where I need to always get a row returned even if no
match is in the table (only 1 or many rows are acceptable).
I can use:
select a, b, c from mytable where a = 'yarp';
and might get 20 rows if there are matches, but I
On 01/02/2010, at 7:33 PM, 曹凯 wrote:
Hi all,
if we just know the table name but don't know the name of primary
key, is there any variables or constants could instead of the PK?
for example:
there is a table game_log, and now I have the last inserted_id
but don't know what its
Try to run
SHOW ENGINE INNODB STATUS;
Near the top there will be some information on the latest deadlock.
That might help you to understand what is deadlocking. Sometimes
changing the query or changing the indexes can remove the condition
that causes the deadlock. I don't know whether you
How did you type the source command? Did you remember not to quote the file
name? E.g.
mysql SOURCE schema.sql
is the correct way.
Jesper
On Tue, 2 Feb 2010 10:38:08 kebede teferi wrote:
Hi, I'm very new to this and I need help.
What I want to do is to execute a source command statement
On 06/02/2010, at 5:31 PM, MuraliKrishna wrote:
Hi
I am in need to know about handlers and cursors.. if any site giving
detailed explanation and examples on these. thanks in advance
Cursors: http://dev.mysql.com/doc/refman/5.1/en/cursors.html
Handlers:
--- Original Message ---
From: viraj kali...@gmail.com
To: mysql@lists.mysql.com
Sent: 19/2/10, 05:48:41
Subject: ERROR 1442 (HY000) when delete inside trigger statement
issue: ERROR 1442 (HY000): Can't update table 'T1' in stored
function/trigger because it is already used by
Jesper Wisborg Krogh
Team Leader • Certified MySQL 5.0 Developer DBA
Noggin IT • Level 8, 28 Foveaux St, Surry Hills NSW Australia 2010
T: +61 2 9219 8800 • F: +61 2 9280 4669 • E: jes...@noggin.com.au
http://www.noggin.com.au
On 21/02/2010, at 4:46 AM, Paul DuBois wrote:
On Feb 20, 2010
On 21/02/2010, at 2:03 PM, Yang Zhang wrote:
Hi, I'm interested in piping out the contents of a mysql table to
stdout in tab-separated value format, but:
- using 'select * into outfile' can't write to stdout.
- mysqldump --fields-... requires --tab, which requires an output
file path.
- I
On 22/02/2010, at 9:20 PM, Tomasz Chmielewski wrote:
When I try to dump a database which contains views, mysqldump crashes:
# mysqldump -u root --opt --password=secret database dump.sql
*** stack smashing detected ***: mysqldump terminated
Aborted
#
I use MySQL 5.0.89-0.glibc23 binaries from
An example how to delete a foreign key from an InnoDB table:
test CREATE TABLE table_1 (id int unsigned NOT NULL auto_increment
PRIMARY KEY) ENGINE=InnoDB;
Query OK, 0 rows affected (0.56 sec)
test CREATE TABLE table_2 (table1_id int unsigned NOT NULL, FOREIGN
KEY (table1_id) REFERENCES
On 07/03/2010, at 3:30 AM, Brent Clark wrote:
Hi everyone,
Currently we have a policy that prohibit our customers from
creating stored procedures and triggers on their DB's which I
imagine must be driving them up the walls. It's like having a car
with a boot but you are not able to use
On 17/03/2010, at 9:10 PM, Anand kumar wrote:
you are right sir , the variables innodb_status_file will write the
show
innodb status information on to the file innodb_status.PID ...
however for
me the innodb status is logging into the default error log file...
i dont
have any clue on how
Be aware that if it is an unpatched version of 5.0.77, then there is
a bug related to name_const (http://bugs.mysql.com/bug.php?id=42014)
that can cause serious problems (infinite server crashes if it
happens in a replication thread). Redhat/CentOS have applied the
patch, but other sources
On Thu, 15 Apr 2010 09:31:04 Mike Diehl wrote:
I just created a new table called lines. I can use Open Office to read
the records in it just fine.
However, when I type this command at the cli, I get an error:
select * from lines;
ERROR 1064 (42000): You have an error in your SQL syntax;
On Tue, 27 Apr 2010 09:08:29 Peng Yu wrote:
I don't see there is a function to compute min or max of two numbers
in a row. Essentially I want to select all the rows where the minimum
of column1 and column2 are bigger than the maximum of col3 and col4
(The following code won't work as I
On Wed, 28 Apr 2010 08:53:57 Keith Clark wrote:
But I'd prefer not to see the extra sorting field.
You don't need to select a field in order to be able to order by it.
So
select chart_of_accounts.accountname as Account,
concat('$',format(coalesce(sum(sales_journal_entries.debit),0),2)) as
Hi,
According to the manual, the slave-net-timeout specifies how long time to wait
for data from the master before considering the connection dead. From my
experience this actually means that the slave will reconnect if it hasn't
received a full event in that period of time.
E.g. setting
Hi
On 16/10/2010, at 1:47 AM, Suresh Kuna wrote:
Hey Daevid,
As this time zone table won't change once it is set up. Do a copy
of the
table data into another database and give grants to it.
Copy the data is not a good solution. First of all, time zone data
does change. Secondly if you
Hi,
On 16/10/2010, at 8:50 AM, Daevid Vincent wrote:
Thanks for the reply Jesper, but either there isn't a solution in your
response, or I'm missing it?
What I mean is that you have to explicitly give the grant to each
user that should be allowed to query the table. You can't run one
On 17/12/2010, at 9:02 AM, Jerry Schwartz wrote:
I have to move the back-end of an Access application to MySQL, and I’ve run
into one issue that I haven’t been able to solve yet.
The Access database stores dates as text in a “/mm/dd” format. The
problem is that the default value is a
Hi,
On 22/01/2011, at 11:27 AM, Donovan Brooke wrote:
Just an idear..
Don't auto_increment the main table.. create a unique Id table,
auto_increment that, and grab that value first for use with both fields in
your main table.
This can be wrapped into a trigger, so the main table
Hi Frank,
On 20/06/2013 05:00, Franck Dernoncourt wrote:
Hi all,
A table `logs/#sql-ib203` appeared after a MySQL crash due to disk space
shortage while deleting some attributes in a table in the `logs` database
and adding an index.
`USE logs; SHOW TABLES;` does not list the table
Hi Matthew,
On 16/07/2013 21:21, Matthew Ward wrote:
I've noticed a weird issue in our chained replication environment where when
setting user-defined variables, the first time the variable is used in a
session the value is NULL, but all uses thereafter work correctly.
snip
The first time I
Hi Naga,
On 21/08/2013 23:43, shawn green wrote:
Hello Naga,
On 8/21/2013 6:45 AM, Nagaraj S wrote:
Hello,
Can anyone share the features/comparison from MySQL version 3.23 to
5.x in
single document? I can get from Google, however I have to navigate
different pages/sites, if it is in single
Hi Machiel,
On 8/11/2013 20:04, Machiel Richards wrote:
Good day all
I am hoping someone can assist me in the following.
One of our servers were running mysql 5.0 still and as part of
a phased upgrade route we have upgraded to version 5.1.
However since the upgrade,
Hi Jørn,
On 15/01/2014 04:36, Jørn Dahl-Stamnes wrote:
140114 18:20:08 InnoDB: Error: data file /data/mysql/data/ibdata3 uses page
size 1024,
140114 18:20:08 InnoDB: but the only supported page size in this release
is=16384
140114 18:20:08 InnoDB: Could not open or create data files.
That
On 12/02/2014 13:16, Morgan Tocker wrote:
Hi Zhigang,
On Feb 11, 2014, at 8:48 PM, Zhigang Zhang zzgang2...@gmail.com wrote:
I want to know the reason, in my opinion, to scan the smaller index data has
better performance than to scan the whole table data.
I think I understand the question
Hi Tim,
-Original Message-
From: Tim Dunphy [mailto:bluethu...@gmail.com]
Sent: Sunday, 29 June 2014 03:45
Cc: mysql@lists.mysql.com
Subject: Re: alter table modify syntax error
Hey guys,
Sorry to hit you with one more. But I'm trying to use a positional statement
in a column
Hi Tim,
-Original Message-
From: Tim Dunphy [mailto:bluethu...@gmail.com]
Sent: Sunday, 29 June 2014 10:09
To: Jesper Wisborg Krogh
Cc: mysql@lists.mysql.com
Subject: Re: alter table modify syntax error
The syntax sixth is not a supported syntax. You should use the
syntax
Hi Chris,
-Original Message-
From: Chris Knipe [mailto:sav...@savage.za.org]
Sent: Thursday, 24 July 2014 19:18
To: mysql@lists.mysql.com
Subject: Avoiding table scans...
mysql SELECT MIN(ArtNumber) AS ArtNumber, MessageID FROM
78168ea0a9b3b513a1f2d39b559b406e WHERE ArtNumber
Hi Brad,
-Original Message-
From: Brad Heller [mailto:b...@cloudability.com]
Sent: Sunday, 7 September 2014 03:07
To: MySQL General List
Subject: MySQL 5.5.33 History list not purging?
For some reason, the history list isn't purging on one of my masters. This is
causing all kinds
Hi Lejeczek,
On 1/03/2016 00:31, lejeczek wrote:
hi everybody
a novice type of question - having a php + mysql, can one just encrypt
(internally in mysql) tables and php will be fine?
If not, would it be easy to re-code php to work with this new,
internal encryption?
Starting with MysQL
Hi Machiel,
On 8/09/2016 05:24, Machiel Richards wrote:
...
Biggest issue at the moment is mysql taking all physical memory until
nothing left, the starts swapping as well until that is completely used up.
Since you are using MySQL 5.7, you can consider enabling memory
instrumentation in
Hi,
On 8/12/2016 18:39, mach...@seworx.co.za wrote:
...
So to recap what has been done for now :
- Triggers to insert a record in audit table to show
the table, type of query(insert/update) and who made the relevant change.
- Trigger to prevent
Hi Martin,
On 4/12/2016 07:23, Martin Mueller wrote:
I abandoned a MySQL 5.22 database that quite suddenly andthat I wasn’t able to
start up again. The data directory consists of a mix of ISAM and Inno tables.
I was able to copy the ISAM tables into a new 5.6 version, and they work.
38 matches
Mail list logo