what is mysql2010, it it host name or password.
If password, there cannot be space for a password, it its host, then dont
use if u connecting from the server.
regards
anandkl
On Fri, Apr 9, 2010 at 2:06 AM, Michael Dykman wrote:
> If you want to specify the password itself on the command line
We've seen good results throwing more RAM to the buffer pool.
It is true that InnoDB data never gets accessed directly on disk.
The only downside I know of with a larger buffer pool is slower restarts.
The load speed depends on the order of the inserts.
Random inserts or updates to primary key wil
Hi *
mysqld process consuming more 100% of cpu usage and execution time also very
high.
1. how to reduce CPU?
2. why mysqld process consuming high cpu utilization?
3. Wether need to fine tune sql application. then how to use plan table in
mysql?
4. which storage engine is better for transaction?
If you want to specify the password itself on the command line use
'--password' (double hyphen). '-p' requests interactive password
prompt.
- michael
On Thu, Apr 8, 2010 at 4:31 PM, Carsten Pedersen wrote:
> don't have a space between '-p' and 'password', i.e. -ppassword
>
> / Carsten
>
> alb
don't have a space between '-p' and 'password', i.e. -ppassword
/ Carsten
alba.albetti skrev:
I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've written
>C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says >Enter pa
Hi List,
I'm using regular expressions on a simple table.
I was wondering how large a regular expression is allowed to be? Are
there any limitations and if so which ones?
Thanks,
Jelle S.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
At 09:02 AM 4/8/2010, alba\.albetti wrote:
I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've
written >C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says >Enter password: and I've given
and I get
mysqladmin: con
At 09:10 PM 4/7/2010, you wrote:
Also depends on your data access pattern as well.
If you can take advantage of clustering my primary key for your
selects, then InnoDB could do it for you.
My suggestion would be to write some queries based on projected
workload, build 2 tables with lots and lots
I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've written
>C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says >Enter password: and I've given and I
get
mysqladmin: connect to server at 'localhost' failed
error: 'A
Tompkins Neil wrote:
Just looking for some confirmation that under a single database - I assume
it is perfectly normal to have both MyISAM and InnoDB engines for different
tables ? Is there anything I need to be aware of ?
In most case no problems. MySQL can mix engines without problems.
Every
Different engines' tables have no connect each other.
2010-04-08
Best regards
Timo Seven
blog: http://zauc.wordpress.com
#请翻墙浏览，或者指定hosts到74.200.243.252###
UNIX System Admin & MySQL DBA
发件人: Tompkins Neil
发送时间: 2010-04-08 18:22
主 题: Multiple table engine
收件人: "[MySQL]"
Hi
Ju
On Thu, Apr 8, 2010 at 10:25 AM, nwood wrote:
> OK, at a 5 minute glance:
> 1.) I think the reason it isn't working is that MySQL/PHP don't support
> reading from two buffered result sets concurrently: read from one then
> the other.
>
Specifically, it doesn't support multiple buffered result se
On Thu, Apr 8, 2010 at 9:33 AM, spacemarc wrote:
> 2010/4/7 Carsten Pedersen :
> > AFAIR, MySQL 4.x supports LIKE, e.g.
> >
> > SHOW TABLE STATUS LIKE 'tab_%'
>
> yes, but if the tables have different names (table1, tab_2, abcd... )
> your syntax will not work. How to do?
>
Multiple statements.
Or MySQL Connector :)
On Apr 8, 2010 10:11 AM, "Carsten Pedersen" wrote:
The MySQL ODBC driver?
/ Carsten
On Thu, 8 Apr 2010 10:42:28 +0530 (IST), Vikram A
wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular
db.
> Is there any...
> !DSPAM:451,4bbd65f93304
Hi
Just looking for some confirmation that under a single database - I assume
it is perfectly normal to have both MyISAM and InnoDB engines for different
tables ? Is there anything I need to be aware of ?
Thanks
Neil
You can also use HeidiSQL, another free tool to visually manage and export
structure/data etc (and a whole host of other stuff) I use it to manage
windows and linux hosted databases.
George
-Original Message-
From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
Sent: 08 April 2
Hi Vikram,
You can use toad for mysql ( It's a free tool) to export table structure or
data.
Even you can use mysqldump also.
Krishna
On Thu, Apr 8, 2010 at 10:42 AM, Vikram A wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular db.
> Is there any tool for d
On Wed, 2010-04-07 at 21:37 -0700, Karthick Subramanian wrote:
> I need to read an array's content using a while loop and inside the loop
> read another array's content. Using the variables from the two arrays I need
> to execute a query. My problem is the inner while loop reads all records of
> th
On Wed, Apr 7, 2010 at 11:45 PM, shamu...@gmail.com wrote:
> Below is my MySQL Server's status and configuration. But I can not see
> anything under /tmpfs/, it is showing empty to me.
>
> here is the result of "ls -al"
>
> drwxrwxrwx 2 mysql mysql60 Apr 7 17:43 tmpfs
> Could anyone tell me
2010/4/7 Carsten Pedersen :
> AFAIR, MySQL 4.x supports LIKE, e.g.
>
> SHOW TABLE STATUS LIKE 'tab_%'
yes, but if the tables have different names (table1, tab_2, abcd... )
your syntax will not work. How to do?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
The MySQL ODBC driver?
/ Carsten
On Thu, 8 Apr 2010 10:42:28 +0530 (IST), Vikram A
wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular
db.
> Is there any tool for doing this?
>
> Please guide me.
>
> Thank you
>
> VIKRAM A
>
>
>
>
21 matches
Mail list logo
