Hello Nunzio,
Instead of Dropping a index, you can disable the indexes and get the work
done and re-enable them.
If you are ok with this then run the below as a shell script :-
MUSER="username"
MPASS="password"
DATABASE="dbname"
for db in $DATABASE
do
echo "starting disabling indexes for datab
Hi Michale,
I have made that parameter column name change. but I am unable to
understand how even after execution of update statement and commit
after that, data is getting reverted.
Any inputs on this will be a great help.
--
Regards,
Manasi Save
On Mon, 9 Aug 2010 14:11:19 -0400, Michael
Hello Pratiksha,
To get the uptime of the MYSQL instance :-
mysql>\s
as given above just give the above command " \s "
For Total number of users connected to server :-
mysql>show global status like '%user%';
---Database & Table wise Size in MB---
SELECT TABLE_SCHEMA AS 'Database', TABLE_NAME
Does anybody know how to use SSL-secured connections to a MySQL server?
Has anybody done that at all?
In the manual I have now found the following statement:
http://dev.mysql.com/doc/refman/5.1/en/ssl-options.html
> Note that use of --ssl does not require an SSL connection. For
> example, if the
On 8/5/2010 9:35 AM, Nunzio Daveri wrote:
So when I do top-c before I run the reports,
it says mysql is using 2GB, then I run the stress test (several reports) and it
hits 12GB then I stop the stress and even 30 mins later the server says there is
only 800mb of ram free???
That's normal Linux
Hello Gurus, is there a way / script that will let me DROP ALL the indexes in a
single database? for example, lets say my database is call db_Animals, and
inside db_Animals there are 97 tables, is there a SINGLE command or a perl
script of some kind that can read all the MYI files, remove the .
For most of your questions, use:
SHOW GLOBAL STATUS;
SHOW GLOBAL VARIABLES;
(7) Database performance statistics queries
(8) Top 5 queries taking more time for executions.
(9) Engine information.
For these, you need to enable the slow query log, gather queries over a given
interval of time, the
You might have better results if you use unique identifiers:
Select MyID From Test Where TestID = TestID;
I'm not sure how mysql is supposed to tell the param 'TestID' from the
column name.
- michael dykman
On Mon, Aug 9, 2010 at 3:10 AM, Manasi Save
wrote:
> Dear All,
>
> Table values are g
hello, i have a table called checkout, this has a row called products
which has contains a python dictionary data, like
http://pastie.org/1082137
{products: [{productId: 123, productName: APPLE,
productPrice: 2.34, productUrl: http://appple-fruits.net,
productDescription: "nice juicy
Hi All,
How can i get following information from database or is there any query for
the same.
(1) mysql server uptime
(2) Total number of users connected to server
(3) Data file information / where it is located through mysql prompt / size
of data file
(4) each Database size
(5) Database I/O info
On Sun, Aug 8, 2010 at 11:49 PM, Walter Heck - OlinData.com
wrote:
> Unless you have a very good reason, you probably shouldn't go with
> cluster in the first place. If it is HA you want to have, check out
> other options like MMM for MySQL (http://mysql-mmm.org), DRBD
> +Heartbeat and others.
> C
Dear All,
Table values are getting rollback without calling rollback.
I have a table Test with some columns in it.
Here's the Table Structure:-
Create Table TestID
(
TestID int not null,
MyID int
);
I am calling two procedures one is get the value of MyID column and one is to
set the va
12 matches
Mail list logo