hi thanks for your response..
this is solaris 8 machine. thanks a lot. i found the problem and resolved..
problem is: access problem in file system
'./mysql-bin.25' is created in root.root but it should be in
mysql.mysql (user.group). i changed this to mysql, then service started...
thanks
Hi Faizal, all!
F.A.I.Z.A.L wrote:
> hi
>
> anyone can help. its urgent. iam trying to start mysql server but it is not
> starting.
Just read the output:
>
> bash-2.03# ./mysqld_safe &
> [2] 3422
> bash-2.03# Starting mysqld daemon with databases from /usr/local/mysql/var
> STOPPING server fr
hi
anyone can help. its urgent. iam trying to start mysql server but it is not
starting.
bash-2.03# ./mysqld_safe &
[2] 3422
bash-2.03# Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/andd141.pid
100114 11:31:22 mysqld ended
log
hi all
this is my innodb preference. i need to change anything for increasing the
db performance..
innodb_additional_mem_pool_size --> 1048576
innodb_autoextend_increment --> 8
innodb_buffer_pool_awe_mem_mb --> 0
innodb_buffer_pool_size --> 8388608
innodb_checksums--
HI experts
I am facing performance issue for last couple of months. it taking more time
to execute query..
developers created tables on myIsam and Innodb. i have a doubts whether we
can use both storage same time..
i have 2 thinks in my minds to check this performance.
1. to check innodb and myi
what is the purpose of 'Grant usage ' command
http://search.mysql.com/search?site=refman-50&q=grant+usage&lr=lang_en
Check the documentation, if you have more questions after that, get back to
us.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Wo
Hi,
(better change the message subject if you change, well, the subject)
user will create more number of tickets per day. so INSERT, UPDATE, SELECT
will use highly.
in document says' Myisam will not support transaction but it has self
backup
and restoration method. but in InnoDB good for tr
This particular reference is little too vague to be of much use.
MyISAM may outperform innodb in signle process situations but in
contentious mixed read/write traffic (suchas a typical webapp), innodb
is much faster for a variety of reasons.
>
> 13.1. Comparing Transaction and Nontransaction Engin
-transactions.html
best regards
liuyann
> From: sac.fai...@gmail.com
> Date: Thu, 1 Oct 2009 15:06:54 +0530
> Subject: Re: login issue..pls help
> To: aim.prab...@gmail.com
> CC: mysql@lists.mysql.com
>
> user will create more number of tickets per day. so INSERT,
hi kumar
what is the purpose of 'Grant usage ' command
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Thu, Oct 1, 2009 at 3:06 PM, F.A.I.Z.A.L wrote:
> user will create more number of tickets per day. so INSERT, UPDATE, SELECT
> will use highly.
>
> in documen
user will create more number of tickets per day. so INSERT, UPDATE, SELECT
will use highly.
in document says' Myisam will not support transaction but it has self backup
and restoration method. but in InnoDB good for transaction but no self
managed backup and restoration..
now how can i choose my
innodb.
Since, If there are many modifications of the data, it's said that InnoDB
works faster because it uses row locking instead of table locking, like
MyISAM. However, if there are mainly SELECT statements, a MyISAM table might
be faster.
On Thu, Oct 1, 2009 at 2:33 PM, F.A.I.Z.A.L wrote:
>
a. at Linux level you can make soft link to database dir to particular
database ie schema. I don't is it possible at mysql level?
b. There is no relation between storage engine and table space.
Yes, Innodb uses tablespace you can read more on both.
c. http://mysql-tips.blogspot.com/2005/04/setup
1 doubt
the front end application is lab ticketing system. so user will create many
ticket. iam expecting per day 200k ticket user will create. so which storage
engine is best to use. innodb or myisam..?
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Thu, Oct 1, 2
thanks kumar.
Storage
in datadir contain only one location.is it possible to have multiple
location to store datafiles.if yes, how?
what is the different between storage engine and tablespace in mysql?
account creation
*create user 'test'@'%' identified by 'test';
grant usage on test.* to 'tes
A. For transaction *innoDB* is best.
B. *ALTER TABLE table_name ENGINE = InnoDB;
* but* *if you tons of tables so better export all tables in file and
replace all occurs of *myisam* with *InnoDB *the import it.
and enable InnoDB engine.
http://www.linux.com/archive/articles/46370
C. 1. Stop MyS
hi Kumar
thanks for your info..
another doubt.. which storage engine is best for transaction..
in my server. the default engine is myisam. now i changed one of my schema
to innoDB. is that correct.
now i want to create another schema in different location. how to create
that? because current mo
a. INFORMATION_SCHEMA is the information database ie metadata, the place
that stores information about all the other databases that the MySQL server
maintains. Inside INFORMATION_SCHEMA there are several read-only tables.
They are actually views, not base tables, so there are no files associated
wi
thanks kumar..
now its working
i have another doubt
i created an user with limited privilege on particular schema.
schema name: test
*mysql> create user 'test'@'%' identified by 'test';
mysql> grant select,insert,update,delete,create,drop on test.* to 'test'@
'%';*
after that i login with 'tes
Use : mysql -u root -p (it will prompt for password) and if its not a local
host also add -h ipaddress
On Thu, Oct 1, 2009 at 11:01 AM, F.A.I.Z.A.L wrote:
> Hi
>
> iam getting the following error while login into mysql server.
>
> andd141# mysql -u root
> ERROR 1045 (28000): Access denied for us
Hi
iam getting the following error while login into mysql server.
andd141# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
Can someone please help me understand why I am not able to login from root?
Best Regards
Faizal S
GSM : 9840118673
Blog:
On May 9, 2008, at 6:58 AM, Chris Pirazzi wrote:
Hello,
I _thought_ I knew how InnoDB worked, but due to a recent mysql doc
change, I am no longer sure--the change made the dox significantly
less clear, and potentially code-breaking.
Please can someone tell me the real behavior of InnoDB in t
Hello,
I _thought_ I knew how InnoDB worked, but due to a recent mysql doc
change, I am no longer sure--the change made the dox significantly
less clear, and potentially code-breaking.
Please can someone tell me the real behavior of InnoDB in the
following case, and ideally clarify the dox too...
tp://dev.mysql.com/doc/refman/5.0/en/corrupted-myisam-tables.html about
mysqleers comments.
Thanks
ViSolve DB Team.
- Original Message -
From: "Nilnandan" <[EMAIL PROTECTED]>
To:
Sent: Monday, July 02, 2007 3:58 PM
Subject: Re: Frequently MyISAM TABLE corruption.
Found block with too small length at
967177484; Skipped |
| DB1.tables1 | repair | warning | Number of rows changed from 186252 to
186251|
| DB1.tables1 | repair | status | OK
|
+--+----+--+-
Hello all,
>>
>> I have one server which has mysql 5.0.27 installed. There is one table
>> named
>> table1.
>> that table has 122000 records..It has 114 fields and 22 indexes.
>>
>> Now this table always been corrupt. I have try to found the solution
but
&g
ays been corrupt. I have try to found the solution but
>> i
>> couldn't.
>> Pls help me ASAP. I have used CHECK and REPAIR option I have given here
>> the
>> output.
>>
>> 070509 4:06:17 [ERROR] /usr/sbin/mysqld: Table 'table1' is ma
Nilnandan wrote:
Hello all,
I have one server which has mysql 5.0.27 installed. There is one table named
table1.
that table has 122000 records..It has 114 fields and 22 indexes.
Now this table always been corrupt. I have try to found the solution but i
couldn't.
Pls help me ASAP. I
Hello all,
I have one server which has mysql 5.0.27 installed. There is one table named
table1.
that table has 122000 records..It has 114 fields and 22 indexes.
Now this table always been corrupt. I have try to found the solution but i
couldn't.
Pls help me ASAP. I have used CHECK and R
I think this is what you want to do:
SELECT t1.Division,t1.year, t1.units this_year_units, t2.units
last_year_units, case when t2.units is null then t1.units else
(t1.units-t2.units) end as Difference_Units
FROM `narra_table` t1 left join narra_table t2
on (t1.Division=t2.Division) and (t1.Ye
i have to write one query
DivisionUnitsYear
a 200 2004
a 300 2005
b 500 2004
b 800 2005
b 900 2006
c
TECTED]
> Sent: Wednesday, December 01, 2004 11:22 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Table Locking Problem? Very Slow MyISAM DB - PLS HELP!
>
>
> >The reason I ask is because eight select statements should not bog down a
> >production serve
When the server begins to slow down, what does top reveal?
Andrew Nelson wrote:
The reason I ask is because eight select statements should not bog
down a production server. On the MySQL side, is anything being
written to the slow query log? On the application side is there any
virus scanning or
The reason I ask is because eight select statements should not bog down a
production server. On the MySQL side, is anything being written to the slow
query log? On the application side is there any virus scanning or similar
activity being performed? Does iostat show any heavy reading or writing
The reason I ask is because eight select statements should not bog down
a production server. On the MySQL side, is anything being written to the
slow query log? On the application side is there any virus scanning or
similar activity being performed? Does iostat show any heavy reading or
writing
Hi Victor,
How did you deduce that the database server is the bottleneck? Are all your
processes running on the same machine?
Because 'ps -aux' shows it running at 94% of the CPU and when I
stop/start the mysql server, it seems to be ok again for another
hour.
Any ideas?
Andrew Nelson wrote:
Hi
Hi,
I have a MySQL 3.23.55 server managing accounts on my exim mail server..
The table type on all tables MyISAM.. I have the MTA performing various
queries
for each incoming email - determining mail aliases, vacation messages and
filtering rules etc but they're all pretty much SELECT statements
How did you deduce that the database server is the bottleneck? Are all
your processes running on the same machine?
Andrew Nelson wrote:
Hi,
I have a MySQL 3.23.55 server managing accounts on my exim mail server..
The table type on all tables MyISAM.. I have the MTA performing
various queries
fo
blem 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, February
esday, February 24, 2004 12:08 PM
Subject: Fw: pls help ...
- Original Message -
From: CurlyBraces Technologies ( Pvt ) Ltd
To: [EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 12:05 PM
Subject: pls help ...
hi ,
when i try to get mysql data to th
- Original Message -
From: CurlyBraces Technologies ( Pvt ) Ltd
To: [EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 12:05 PM
Subject: pls help ...
hi ,
when i try to get mysql data to the web browser via
php , always it is showing
Parse error: parse error
hi ,
when i try to get mysql data to the web browser via
php , always it is showing
Parse error: parse error, unexpected T_LNUMBER, expecting
',' or ';' in /var/www/html/smsc/test1.php on line 14
error message. but i tried to rectify the essage ,
i couldn't.
can some body help me to solve
t;
Sent: Friday, December 05, 2003 12:14 AM
Subject: Lost connection to MySQL server during query - pls help
Hi Guys,
I have a problem with
"Error 2013 - Lost connection to MySQL server during query"
I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win
XP Pro.
They t
; <[EMAIL PROTECTED]>; "Kiky" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, December 06, 2003 12:56 AM
Subject: RE: Lost connection to MySQL server during query - pls help
> At 10:44 -0600 12/5/03, Jay Blanchard wrote:
> >[snip]
> >Ple
At 10:44 -0600 12/5/03, Jay Blanchard wrote:
[snip]
Please upgrade you MySQL Windows client to 4.0.16 there is a bug
with net_read_timeout and net_write_timeout on 4.0.15 that
disconnect when the query takes more than 30 secons.
[/snip]
Can you elaborate on this, we have not seen this problem
See t
"Kiky" <[EMAIL PROTECTED]> wrote:
> I have a problem with
> "Error 2013 - Lost connection to MySQL server during query"
>
> I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win XP Pro.
> They turn out to have the same error.
>
> My problem is:
> I have a Java program which is
[snip]
Please upgrade you MySQL Windows client to 4.0.16 there is a bug
with net_read_timeout and net_write_timeout on 4.0.15 that
disconnect when the query takes more than 30 secons.
[/snip]
Can you elaborate on this, we have not seen this problem
--
MySQL General Mailing List
For list archives:
At 14:14 5/12/2003 +0800, Kiky wrote:
Hi Guys,
I have a problem with
"Error 2013 - Lost connection to MySQL server during query"
I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win
XP Pro.
They turn out to have the same error.
Please upgrade you MySQL Windows client to 4.0.16
Hi Guys,
I have a problem with
"Error 2013 - Lost connection to MySQL server during query"
I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win XP Pro.
They turn out to have the same error.
My problem is:
I have a Java program which is actually a thread to send emails, so it
Hi,
I would like to enquire abt Result datatype in MySql++.
After getting songList,
Result songList=dac.getSong();
1. Is it possible for me to get a specific record out?
2. Is it possible for me to get a random record out?
Regards,
Petty_folly
_
Hi,
I would like to enquire abt Result datatype in MySql++.
After getting songList,
Result songList=dac.getSong();
1. Is it possible for me to get a specific record out?
2. Is it possible for me to get a random record out?
Regards,
Petty_folly
_
I'm trying to figure out how can I do this:
I'm designing a mysql db for a delivery service, and I encounter a problem
each item delivered has a code associated
and it also does some querys in other associated tables, I mean:
Prod ID = 11 Prod = PizzaRecipeID=01 REcipe has the ingredi
senthil,
Friday, March 08, 2002, 10:51:51 AM, you wrote:
s> pls. help me , how to update 2 tables like this sql
s> update table1 set table1.fld2 = table1.fld2 where table1.fld1 = table2.fld1
MySQL doesn't currently support multi-table UPDATE statement. It is in
our plans to supp
hi
pls. help me , how to update 2 tables like this sql
update table1 set table1.fld2 = table1.fld2 where table1.fld1 = table2.fld1
senthil.r
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
IT'S ENOUGH HOW MANY DATA'S(BYTES)
STORING IN DATABASE.
PLS HELP TO ME.
NOW I AM START WITH MY PROJECT.PLS HELP TO ME.PLS SEND
MAIL TO ME.AS SOON AS POSSIBLE.
THANKS
RAMESH.I
__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctio
NULL |NULL | NULL | 10627007
| where used |
+---+--+-+--+-+--+--
++
1 row in set (0.00 sec)
mysql>
-Original Message-
From: Tonu Samuel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 5:33 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
On Wed, 2001-10-31 at 08:52, kmlau wrote:
> hi all,
>
>Let me to introduce somethings first, we use mysql for a logging system
> and take about max 150 000 records hourly. And we need to take a period of
> data for analyzing.
I haven't followed the thread but do you use INSERT DELAYED alread
hi all,
Let me to introduce somethings first, we use mysql for a logging system
and take about max 150 000 records hourly. And we need to take a period of
data for analyzing.
>Well, how many records are in the table? How many would be returned by the
>query you present?
The previous table
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: FW: pls help for index problem
Well, how many records are in the table? How many would be returned by the
query you present?
Is the SQL you show the FULL sql?
What is the output of the EXPLAIN SELECT
What about "SHOW INDEX FROM TAB
u [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 24, 2001 9:42 AM
> To: 'Bill Adams'
> Subject: RE: pls help for index problem
>
> Thanks yr promptly reply !!
>
> It seems no any change(improvement) by running explain again after erase
> quotes. I also ran
-Original Message-
From: kmlau [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 9:42 AM
To: 'Bill Adams'
Subject: RE: pls help for index problem
Thanks yr promptly reply !!
It seems no any change(improvement) by running explain again after erase
quotes. I al
kmlau wrote:
> I encountered a problem about indexing. I want to add index on timerecord
> field in table gw (shown as below) to speed up query relating with time.
> However, I use explain command (explain select * from gw where timerecord =
> '010902') to analyze the performace. As a resul
hi,
I encountered a problem about indexing. I want to add index on timerecord
field in table gw (shown as below) to speed up query relating with time.
However, I use explain command (explain select * from gw where timerecord =
'010902') to analyze the performace. As a result, it seems the q
It sounds like the PHP module was compiled without MySQL support.
root wrote:
>
> Hi,
>
> I'm running mysql MAX 3.23.41 on LinuxPPC, everything was installed from
> an RPM.
> My problem is whenever I try to call mysql_connect (), from a php3
> script, I got the error function not found or misco
Hi,
I'm running mysql MAX 3.23.41 on LinuxPPC, everything was installed from
an RPM.
My problem is whenever I try to call mysql_connect (), from a php3
script, I got the error function not found or misconfigured
The script is a simple form, that passes the data to be added to an
empty d
Hi,
i tried searching through the net for help, but could not find an answer.
Could anyone out there please help?
i'm running the mysql server on a redhat linux 7.0, kernel
2.2.16-22enterprise on a 2-processor i686.
I've been trying to connect to a database but i keep getting the access
denied e
Hello everyone.
I'm newbee to databases.
I need one help pls help me out I'm not on list so pls directoly mail me back on this
email address.
table articles has following fields and some of the sample entries like following in
the exactly same order . (here id is index).
id
67 matches
Mail list logo
