Hi All,
Can anyone provide me any input on How to make mysql use multiple CPU
cores avaliable.
I am sorry if I am souding very unclear with this. Let me know if you have
any questions.
Thanks in advance.
--
Regards,
Manasi Save
Artificial Machines Pvt Ltd.
--
MySQL General Mailing List
MySQL is already a multithreaded process, even though you only see a single
process. Note that it doesn't scale very well above eight or so cores,
especially InnoDB iirc.
If you are wondering about parallel query execution (that is, splitting a
single query over multiple cores for faster
Hi Johan,
Thanks for the quick response.
Is there any command available in mysql using which I can check how much
CPU is being used by each mysql thread. Or any article where how mysql
multi-threading works.
--
Thanks and Regards,
Manasi Save
Artificial Machines Pvt Ltd.
MySQL is already a
the command 'top -H' will show you the individual threads with their CPU
use, but I'm afraid I don't know how to link that up with a MySQL 'show
processlist'.
On Tue, Nov 24, 2009 at 12:22 PM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi Johan,
Thanks for the quick response.
2009/11/24 Johan De Meersman vegiv...@tuxera.be:
If you are wondering about parallel query execution (that is, splitting a
single query over multiple cores for faster execution), that is currently
not supported by MySQL.
[offtopic]
Probably is something stupid, but could that be done with ndb
At 06:44 AM 11/24/2009, you wrote:
2009/11/24 Johan De Meersman vegiv...@tuxera.be:
If you are wondering about parallel query execution (that is, splitting a
single query over multiple cores for faster execution), that is currently
not supported by MySQL.
[offtopic]
Probably is something
). We've added app-level caching and turned down our tomcat NIO thread
count to just 8 (very little contention inside the app) but now we're seeing
that rollbacks appear to be up to 30x slower than commits?! Is that normal?
Here's a typical TX:
Set autocommit=0;
Select * from users where
NIO thread count
to just 8 (very little contention inside the app) but now we're seeing that
rollbacks appear to be up to 30x slower than commits?! Is that normal?
Here's a typical TX:
Set autocommit=0;
Select * from users where name=bob;
Update users set visit_count=X where id=bobId
Hello,
I am using MySQL in a booking system I am working on. I decided to use an
embedded server so downloaded 5.0.45 from source and compiled it with the
embedded library enabled.
It works fine except that disconnecting seems to take an exceptionally
long time. Relevant lines from the log file
2006 15:29:37 +
From: Jonathon Wardman [EMAIL PROTECTED]
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com, Anthony [EMAIL PROTECTED]
Subject: Re: Mysql Web interface for normal Users
References: [EMAIL PROTECTED]
[EMAIL
Hello,
i am looking for a simple Web interface,
for normal users (non admin), that will only have access to their Database,
and have the possibility to manage their tables (create,delete,insert,...).
for root access, i already have phpMyAdmin installed on the server.
--
MySQL General
Anthony ha scritto:
for root access, i already have phpMyAdmin installed on the server.
You can also use phpmyadmin for normal user.
In my organization i use it for all users...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Vittorio Zuccalà ha scritto:
You can also use phpmyadmin for normal user.
In my organization i use it for all users...
Uff...
I didn't remember...
If it is not enought you can use Dadabik (www.dadabik.org)
It is great: do not be impressed from its simple interface. It is very
completed
Vittorio Zuccalà wrote:
Anthony ha scritto:
for root access, i already have phpMyAdmin installed on the server.
You can also use phpmyadmin for normal user.
In my organization i use it for all users...
Indeed, if you set PHPMyAdmin to 'HTTP' or 'cookie' authentication mode
it will ask
Hi all,
We have a copy of an old version of a database and a huge LOG file ( 9
Gig ) ( not the binary log unfortunately but the GENERAL QUERY LOG )
started when we put this database live.
The only solution I see would be to run the queries from this log file
to the database. What do you think?
I've also checked the error log and there isn't anything that indicates
where these aborted_client connections are coming from. I checked today and
I have 100 more of these.
-James
I used phpMyAdmin to look at the stats for my MySQL server.
here's what they show...
http://www.2-bit-toys.com/db_info/server_status.html
What concerns me mainly are the stats at the top-right...'Failed attempts'
and 'Aborted.'
When would these situations occur? Is it normal to see these?
I'm
I just issued a show status query and the numbers are what MySQL returns.
Strange.
Failed attempts (aka aborted_clients) : 8154
Aborted (aka Aborted_connects): 319
Total (aka Connections) : 4626
So phpMyAdmin is basing the % calculations on these numbers, that's why we
see the weird percentage.
but
doesn't matter what i type there - even nothing i get straight in...
is this normal??
thanks...
What is the error message? Is yor server running?
Usually by default this should work:
/usr/local/mysql/bin/mysql
i.e. default user root without password connecting from localhost
but
doesn't matter what i type there - even nothing i get straight in...
is this normal??
thanks...
Sorry I first misread yor question (I hope I cancelled prev. post on
time). I thought you have problems connecting to mysql while actual
problem is: Why it is so easy for everyone (even
Sorry I first misread yor question (I hope I cancelled prev. post on
time). I thought you have problems connecting to mysql while actual
problem is: Why it is so easy for everyone (even from outside) to
connect?
Yes this is normal: default user is root *without password*
if you wan't to secure
Yes you're right! you can safely delete those - but first make some
changes... as it seems you've set up root password only for :
[EMAIL PROTECTED] - right? that's why you can't login using
localhost (mysql without -h host option assumes -h localhost and if you
only changed password for
what i type there - even nothing i get straight in...
is this normal??
thanks...
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have to pull in 200
search rows and store them temporarily in a Table called xmllinks This is
so I can track the click on the one link of the 200 I bring down. Nothing
is permanently stored in this table
This is just a normal
table in a db right now but during peak traffic times it bogs
-
From: sol beach [mailto:[EMAIL PROTECTED]
Sent: Friday, November 26, 2004 11:25 AM
To: [EMAIL PROTECTED]
Subject: Re: Take a normal Table and Make it a Heap table
When your only tool is a hammer, then all problems are views as nails.
A shovel is a great tool for creating a hole in the ground
- The used table type doesn't support AUTO_INCREMENT columns
Thanks
Donny Lairson
President
http://www.gunmuse.com
469 228 2183
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 26, 2004 11:59 AM
To: sol beach
Cc: Mysql
Subject: RE: Take a normal
Can I put a MyISAM table into Ram permanently?
Thanks
Donny Lairson
President
http://www.gunmuse.com
469 228 2183
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 26, 2004 11:59 AM
To: sol beach
Cc: Mysql
Subject: RE: Take a normal Table
hi
my site is hosted on a machine on which i am not root.
so i don't have access to the mysql db. i'm quite sure
that the admin on that server doesn't know how to do
the security right. he gave my id almost root access
on his mysql server so that i could access it. two
three others have almost the
Hi,
I am construction a Full Text Search engine replacing the internal MySQL
engine in an experiment for index all the content of neswspaper's 20 years
of publications , and the first layer to do a search is to convert the
Boolean Phrase entered by the user to a CNF (conjuntive normal form).
I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi again;
A few days ago I've posted the following question (during a WE)...
unfortunately I had no answer, so I'm just giving it a second chance.
As this is the second (and last) round for this question, please don't
restrict yourself,
I'd be
On Thu, 16 Oct 2003, Serge Cohen wrote:
[...]
Now I'd like to use the libmysqld, so that I can have a an embedded
server, still this same application should be able to connect to a DB
server (over internet).
From what I've read and tried, the libmysqld library does not provide
the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi;
I've been using the libmysqlclient library for a while now, and
developing some client application which are using MySQL server as DB
backend.
Now I'd like to use the libmysqld, so that I can have a an embedded
server, still this same
On Wed, Jul 09, 2003 at 01:08:56PM -0400, Dave [Hawk-Systems] wrote:
load). Is there a known issue (running on FreeBSD 4.8,
MySQL 3.23.55 MyISAM)?
its been a known issue for quite a long time
use linuxthreaded version and it should work fine.
although much of work has been done on
noticed it was once again
sitting up there at 95% (or thereabouts) and doing nothing of value from what i
could tell.
Have restarted MySQL during peak usage times for that server and its database,
and it has showed normal loads and CPU usage (approx 20% CPU with .1 to .3
load). Is there a known issue
hi,
load). Is there a known issue (running on FreeBSD 4.8,
MySQL 3.23.55 MyISAM)?
its been a known issue for quite a long time
use linuxthreaded version and it should work fine.
although much of work has been done on threads implementation,
there are still such problems with mysql. it
On Wed, 2003-07-09 at 10:31, Dave [Hawk-Systems] wrote:
Is there a known issue (running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)?
Is there something I should check when next I notice the high CPU usage?
I used to see the same kind of behavior a while back with a MySQL
installation I did for a
load). Is there a known issue (running on FreeBSD 4.8,
MySQL 3.23.55 MyISAM)?
its been a known issue for quite a long time
use linuxthreaded version and it should work fine.
although much of work has been done on threads implementation,
there are still such problems with mysql. it happens
Is there a known issue (running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)?
Is there something I should check when next I notice the high CPU usage?
I used to see the same kind of behavior a while back with a MySQL
installation I did for a client. It turned out that what was happening
was a poorly
: Friday, January 24, 2003 4:12 PM
Subject: Re: Is it normal?
Any calculation involving a floating point number will be imprecise.
It does not mater what column types are involved.
Octavian Rasnita wrote:
And does anyone know what column type I should use if I want a precise
calculation?
I've
[EMAIL PROTECTED]
To: Octavian Rasnita [EMAIL PROTECTED]
Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; MySQL
[EMAIL PROTECTED]
Sent: Friday, January 24, 2003 4:12 PM
Subject: Re: Is it normal?
Any calculation involving a floating point number will be imprecise.
It does not mater what column
: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]
To: Octavian Rasnita [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Sent: Monday, January 20, 2003 11:42 PM
Subject: Re: Is it normal?
Octavian,
mysql create table test(id float);
mysql insert into test values(1.123), (3.1495);
mysql select * from
Subject: Re: Is it normal?
Octavian,
mysql create table test(id float);
mysql insert into test values(1.123), (3.1495);
mysql select * from test where id=1.123;
Empty set (0.00 sec)
Shouldn't this last query show me the record that has the id=1.123?
Well ... 1.123 is greater than 1.123
],
MySQL [EMAIL PROTECTED]
References: 006101c2c09a$9c0f7330$[EMAIL PROTECTED]
01e601c2c0ce$1a5cf1d0$dc4fc7d9@mephisto
Subject: Re: Is it normal?
Date: Thu, 23 Jan 2003 22:13:07 +0200
MIME-Version: 1.0
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority
Hi all,
I've tried the following SQL queries:
mysql create table test(id float);
Query OK, 0 rows affected (0.00 sec)
mysql insert into test values(1.123), (3.1495);
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql select * from test where id=1.123;
Empty set
, 2003 10:34
Subject: Is it normal?
Hi all,
I've tried the following SQL queries:
mysql create table test(id float);
Query OK, 0 rows affected (0.00 sec)
mysql insert into test values(1.123), (3.1495);
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql select
(Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Octavian Rasnita [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Monday, January 20, 2003 9:34 AM
Subject: Is it normal?
Hi all,
I've tried the following SQL queries:
mysql create table test(id float
Hello,
I'm working with mySQL 3.23.32 under Solaris. I have
a database with two tables 'bron' and 'topic'. Those
tables are related via 'naam_bron'. Lets say that
table 'bron' contains 100 records where column
'media' = 'Book' and table 'topic' contains 30
records where column 'topic_code' =
On 14 Jan 2003, at 15:28, Peter van der Kamp wrote:
What should be the result when I issue the following
query:
select naam_bron from bron, topic where
(bron.media=Book)
or (topic.naam_bron = bron.naam_bron and
topic.topic_code = 5.1);
Before posting my results I'll wait for your
I won't say you need to go back to high school, but maybe you need to
review how SQL works. You have no criterion for joining your two
At least my knowledge of SQL needs an update.
Although there are criteria for joining the two
tables I realize that the way I specified them is
wrong.
I type (as normal user called jupshoes) the following:
mysql -u jupshoes -p password guestbook.sql
and I don't connect to the server but I'm sent back to the shell after
printing the help lines.
Why?
Josep
-
Before posting
Hi.
On Mon, Dec 10, 2001 at 11:56:03AM +0100, [EMAIL PROTECTED] wrote:
I type (as normal user called jupshoes) the following:
mysql -u jupshoes -p password guestbook.sql
^^^
The probabe cause is that you really typed that space. Write it
without space (compare http
On Wed, Apr 04, 2001 at 05:26:39PM +0200, Gunnar von Boehn wrote:
As I asked them why their mysql-server die so often, I got their
standard problem email-answer that claims "mysql is scaling rather
badly".
The truth is probably closer to "we are scaling mysql badly". A well
run MySQL server
To: mysql
Cc: gvb
Subject: Provider claims 'it's normal that mysql crashes', is that true?
Hello
My provider 11-Puretec (www.puretec.de)
hosting more than 1.000.000 domains
runs about 14 Databaseserver with MySQL 3.22.32-log
on Linux dual Penti-III 500Mhz machines.
In the last 6 month the average
-answer that claims "mysql is scaling rather badly".
After further asking I got a personal answer that says:
"it's normal the mysql-servers die because of heavy load".
"We can't help that the mysql task keeps crashing if to many users access it.
That's totally no
In the last 6 month the average uptime of the mysql-servers was around 8 hours.
As I asked them why their mysql-server die so often, I got their
standard problem email-answer that claims "mysql is scaling rather badly".
After further asking I got a personal answer that says:
"it's n
was around 8 hours.
As I asked them why their mysql-server die so often, I got their
standard problem email-answer that claims "mysql is scaling rather badly".
After further asking I got a personal answer that says:
"it's normal the mysql-servers die because of heavy load&qu
After further asking I got a personal answer that says:
"it's normal the mysql-servers die because of heavy load".
"We can't help that the mysql task keeps crashing if to many users access it.
That's totally normal for a mysql database"
Running 3.22.32 that's prehistoric (
-
From: --==[bMan]==-- [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 7:40 PM
To: MySQL List
Subject: Is this a normal behaviour?
O.K. I use MySQL version 3.23 (RedHat 7.0 release) and have a question
about
this query:
1.) [...] LIKE '%pattern'
2.) [...] LIKE 'pattern%'
The first
On Wed, 21 Feb 2001, Hagen Hoepfner wrote:
I can normaly use mysql
if I am root. But if i'm logged in as normal user or try to connect to mysql
via php i got the following error message:
MySQL Connection Failed: Can't connect to local MySQL server through socket
'/var/lib/mysql
On Mon, Feb 26, 2001 at 04:45:50PM +0100, Thomas Spahni wrote:
On Wed, 21 Feb 2001, Hagen Hoepfner wrote:
I can normaly use mysql
if I am root. But if i'm logged in as normal user or try to connect to mysql
via php i got the following error message:
MySQL Connection Failed: Can't
Hello,
I use SuSE Linux 7.1 with a 2.4 kernel. I have installed the normal
SuSE-MySQL packages and creates the default tables. I can normaly use mysql
if I am root. But if i'm logged in as normal user or try to connect to mysql
via php i got the following error message:
MySQL Connection
possible they all are, but in many cases I cannot
tell. The Cold Fusion server is running on the same Linux box, by the way.
Is this normal behavior?
TIA,
Paul
***
Paul A. Rubin
tell. The Cold Fusion server is running on the same Linux box, by the way.
Is this normal behavior?
TIA,
Paul
***
Paul A. RubinPhone:(517) 432-3509
Department of Management
Hi guys..would you be so kind to tell me what's the normal % of cpu usage per mysqld
thread?
i get some 10.5 or 12 % peaks, which frighten me a lil' bit.
Thanks!
AML
64 matches
Mail list logo