Ladies and Gentlemen:
I am getting below errors and therefore the user sessions terminate causing
business impact...Can some one who is expertise already in this advice at
the earliest?
120513 8:19:45 [Warning] Aborted connection 1167257 to db: 'iib' user:
'iibuser' host: '210.18.3.94' (Got tim
Hello Shafi,
The below blog will give you more information on the error -
http://sureshkuna.blogspot.in/2010/12/aborted-connection-31084472-to-db-ms.html
Thanks
Suresh Kuna
On Mon, May 21, 2012 at 1:15 PM, Shafi AHMED wrote:
> Ladies and Gentlemen:
>
> I am getting below errors and therefore th
Hi suresh: I have gone through your blog..and feel it is more generic...
Can you please elaborate why the other setup(DR) works fine when the similar
prod(with no application code/web/db structural changes etc) has gone thru'
successfully with no such warning msgs ?
Thanks again...
Best Rgs,
Sorry- a typo :)
Hi suresh: I have gone through your blog..and feel it is more generic...
Can you please elaborate why the other setup(DR) works fine when the similar
prod(with no application code/web/db structural changes etc) has gone thru'
failures with such warning msgs ?
Best Rgs,
Sh
- Original Message -
> From: "Rick James"
>
> * should not begin with the table name
Personally, I tend to prefix all column names with three-letter abbreviations
of the table name, so that they are both unique across joins, and it's obvious
what table they're from wherever they appear
Hi ,
I am trying to reduce the ibdata1 data file in MySQL. In MySQL
data directory the ibdata1 data file is always increasing whenever I am
creating a new database and inserting some data into database. If I drop the
existing database, the table structures only dropped from the
Manivannan,
There is no way to reduce the InnoDB main tablespace.
You can get rid (=regain disk space) of InnoDB tablespaces only if you have
innodb_file_per_table setting,
which allows you to get disk space back if you drop the table.
The best option you have to free your current shared tablespace
- Original Message -
> From: "Manivannan S."
>
> How to reduce the ibdata1 file size in both LINUX and WINDOWS
> machine.
This is by design - you cannot reduce it, nor can you remove added datafiles.
If you want to shrink the ibdata files, you must stop all connections to the
server, t
I have got this query that returns the correct rows I want to display,
BUT the columns dr_ther_qty, dr_not_ther_qty, and dr_all_ther_qty are
not calculating correctly:
--- START QUERY ONE ---
SELECT q1.* FROM
(SELECT apt.user_id, apt.client_id, c.last_name, c.first_name,
MIN(apt.time_sta
On 2012-05-21 11:17 AM, Don Wieland wrote:
I have got this query that returns the correct rows I want to display,
BUT the columns dr_ther_qty, dr_not_ther_qty, and dr_all_ther_qty are
not calculating correctly:
--- START QUERY ONE ---
SELECT q1.* FROM
(SELECT apt.user_id, apt.client_id, c.l
Instead of
SELECT tla_foo
FROM ThreeLetterAcronym
JOIN ...
I prefer
SELECT tla.foo -- Note "." instead of "_"
FROM ThreeLetterAcronym AS tla
JOIN ...
Using aliases is mandatory when a "self join" is used.
> -Original Message-
> From: Johan De Meersman [mailto:vegiv...@tuxera.be]
> Sent
This needs to be investigated on the server, and cannot be guessed.
On Mon, May 21, 2012 at 2:29 PM, Shafi AHMED wrote:
> Sorry- a typo :)
>
> Hi suresh: I have gone through your blog..and feel it is more generic...
> Can you please elaborate why the other setup(DR) works fine when the
> similar
12 matches
Mail list logo
