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 from pid
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...
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 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
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-- ON
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
what is the purpose of 'Grant usage ' command
http://search.mysql.com/search?site=refman-50q=grant+usagelr=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
-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, UPDATE, SELECT
will use highly
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
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
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
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
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
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
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,
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.
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
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
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 sac.fai...@gmail.com wrote:
user will create more number of tickets per day. so INSERT, UPDATE, SELECT
will use
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:
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 sac.fai...@gmail.com wrote:
Hi
iam getting the following error while login into mysql server.
andd141# mysql -u root
ERROR 1045 (28000):
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
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
changed from 186252 to
186251|
| DB1.tables1 | repair | status | OK
|
+--++--+-+
10 rows in set (1 min 27.77 sec)
PLS help me ASAP
-tables.html about
mysqleers comments.
Thanks
ViSolve DB Team.
- Original Message -
From: Nilnandan [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, July 02, 2007 3:58 PM
Subject: Re: Frequently MyISAM TABLE corruption.Pls help
hello
I am still facing the same problem..
MyISAM
.
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 marked as
crashed and should be repaired
070509 4:06:17 [ERROR] /usr/sbin/mysqld: Sort aborted
How big is the index file? the data file?
Has
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 REPAIR option I have given here
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 REPAIR
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 have
i have to write one query
DivisionUnitsYear
a 200 2004
a 300 2005
b 500 2004
b 800 2005
b 900 2006
c
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
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
]
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 server. On the MySQL side, is anything being written
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
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
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:
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
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
- 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
, 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 the web
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 24, 2004 12:08 PM
Subject: Fw: pls help
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
, 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 turn out to have the same error.
My
]
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]
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
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
[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
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 actually a
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
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
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
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 support
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! Auctions for all
|
+---+--+-+--+-+--+--
++
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]
Subject: Re: pls help !!
On Wed, 2001-10-31 at 08:52
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
: 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 TABLE gw.
b.
kmlau wrote:
-Original Message
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 the command 'myisamchk -a gw.MYI' before sending
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
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 result,
-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 also ran
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
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
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
65 matches
Mail list logo
