Hello,
I am looking to post stuff on the mysql community mailing list. Please let
me know if there is any additional information you need.
Try maatkit mk-query-digest
mk-query-digest --filter '($event-{user} || ) =~ m/user/' mysql.slow.log
2010/9/28 Stefan Onken supp...@stonki.de
Hello,
is there any way to run a a slow query analyse with mysdumpslow only on
specific mysql user connections? We have multiply application
Server offset + increment works really well, is simple, and well
documented and reliable - not sure why you would want to re-invent
something that works so well :).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi Vikram,
Add binlog_format=row to your my.ini master's conf file
2010/4/21 Vikram A vikkiatb...@yahoo.in
Hi Hao Ding,
I attached in my request mail it self. Please find the attachment.
Thank you
--
*From:* hao ding fire9di...@gmail.com
*To:* Vikram A
Max Bube maxbube at gmail.com writes:
The problem starts when I run bulk writes like an alter table or a
restore
from mysqldump, its starts processing more than 5 rows/s but suddenly
the ratio goes down to 100 rows /sec. and then its stucked at this ratio
even if I restart MySQL
deletes 1 rows
/ sec
The problem is just only with writes on innodb, I can perfectly run
mysqldumps and bulk inserts on MyISAM.
This is happening with all MySQL 5.1.x versions I tested.
Any one have a clue about this issue??
Thanks in advance
Max
#INNODB Settings
: INSERT INTO `challenge` VALUES
(95794260,2,0),(95794261,3,1),(95794262,2,1),(95794263,5,0)
*** 3. row ***
Id: 7
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: NULL
Info: show full processlist
regards
Max
2010
Hi Jason
The DEFAULT value can't be an expression.
2009/6/26 Jason Todd Slack-Moehrle mailingli...@mailnewsrss.com
Hi All,
I want to create a table that defaults to current_date and current_time.
I have:
CREATE TABLE `personalevent`(
`pevent` mediumint(10) NOT NULL,
Try with GROUP_CONCAT(ScriptName)
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat
2009/6/12 bruce bedoug...@earthlink.net
Hi...
I have the following...
mysql INSERT INTO ParseScriptTBL VALUES
- ('auburnCourse.py',40,1,1),
-
We are experiencing a certain anomaly here on our db server. The
problem had occurred about 3 weeks ago.
We ran diagnostics on the hardware over a 48+hour period with no
failures or indications of problems with hardware. ( at least the
memory.) We rebooted the server, and had not experienced
efficiently trouble shooting this, where might I begin? I
can't figure out how to replicate it, it seems to be quite sporadic.
What would corrupt query results, temporarily fixed with a mysqld
restart?
Max Thayer wrote:
We are experiencing a certain anomaly here on our db server. The
problem had
QUOTE
And if you believe ASP.NET only provides a few benefits, then you are
adequately informed, my friend
Freddie
/QUOTE
I agree completely!
Max Michaels
Systems Engineer
Right Media LLC
-Original Message-
From: Freddie Sorensen [mailto:[EMAIL PROTECTED]
Sent: Friday, December 31
the developers re-write the
application using mysqli instead of mysql, but this is a very time sensitive
issue. Any opinions/ideas appreciated?
Regards,
Max
Max Michaels
Right Media, LLC | 276 5th Avenue, Suite 605 | New York , NY 10001
xxx.xxx. | [EMAIL PROTECTED] | www.rightmedia.com
appreciated.
Regards,
Max
Max Michaels
Right Media, LLC | 276 5th Avenue, Suite 605 | New York , NY 10001
212.561.6475 | mmichaels {at} rightmedia.com | www.rightmedia.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
. How do I tune my mysql db servers to resolve this error?
Thanks in advance,
-Max
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
create new thread errors on my system when load
gets extremely heavy, are there any additional things I can do to help
this? Would FreeBSD 5.1 be any better?
Thanks in advance,
-Max
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Hello:
I am trying to measure the difference between a single insert statement of
10,000 rows and 10,000 insert statements.
It is easy for me to see the single statement takes about 2 seconds.
However I can come up with no good way to get the total time for individual
statements.
Can anyone
is an indexed varchar column)
Is only one indexed, or are they both indexed?
- Max
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
|
+---+--+---++-
+---+--+-+
1 row in set (0.08 sec)
I'm using MySQL 4.0.18 for Solaris 8.
Can anyone explain this? Or is this a bug (or missing optimization)?
Thanks.
- Max
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
', 'zhu','em1','jtan180'));
Max
mysql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
Otherwise, you may ask whether MySQL is an option or
not. It means that if
your logs and related information can go to other
mean such as a text file
then you are no need to buy license.
In theory we can find option for any db appliance,
let say, we can store data in regular files.
Otherwise, you may ask whether MySQL is an option or
not. It means that if
your logs and related information can go to other
mean such as a text file
then you are no need to buy license.
In theory we can find option for any db appliance,
let say, we can store data in regular files.
Thank you KH
I think that statistics information might
become important part of our system, so it is safer to
buy license or have a look on others RDBMS.
As far as I know, if you only require MySQL as an
option or just an added
features, your company do not need to purchase a
license.
My company develops commercial project which is close
to well know ICQ but has slightly different appliance.
Can I use MYSQL for storing list of users, collecting
some statistics, logs and other related information or
I have to buy license?
__
line: mysql -u mysql -p -h
localhost. This works, but when i give:mysql -u mysql
-p -h machinename it doesnt work.
Why is that? The user mysql has all priviliges
granted.
You need to set proper hosts permissions for user. RTFM section 4 :-)
Max
for Java Server Pages (JSP) and Servlets. Google and java.sun.com
will help.
Max
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Thanks everyone for their help!
Max Clark [EMAIL PROTECTED] wrote in message
av2eai$8he$[EMAIL PROTECTED]">news:av2eai$8he$[EMAIL PROTECTED]...
Hi all,
I have a DATE column (CCYY-MM-DD), I would like to do a query like this:
select * from table where date = '2003-01'
What ad
Hi all,
I have a DATE column (CCYY-MM-DD), I would like to do a query like this:
select * from table where date = '2003-01'
What additional information do I need to provide for this query to work
properly?
Thanks in advance,
Max
Hi-
I am trying to write a sql query that will output (domain, transport,
sum(count), sum(size)) from multiple tables for many records.
When the domain field is dynamic based on the adminId passed to the query,
how do I execute the second query at the same time?
Thanks in advance,
Max
select
because of the error.
Can anyone point me in the right direction?
Thanks in advance,
Max
Max Clark [EMAIL PROTECTED] wrote in message
ataq2r$ev1$[EMAIL PROTECTED]">news:ataq2r$ev1$[EMAIL PROTECTED]...
Hi-
I am trying to write a sql query that will output (domain, transport,
sum(count),
table (select
transportId from acl where adminId='1').
When I try this I get a sql error, what do I need to do differently?
Thanks in advance,
Max
mysql describe transport;
+---+--+--+-+-++
| Field | Type | Null | Key
?
Thanks in advance,
Max
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e
the
first table insert?
Thanks in advance,
Max
insert into table1 (name, desc) values (foo, foouser);
id name desc
55 foo foouser
insert into table2 (table1Id, text) values (?, some text);
id table1Id text
69 55 some text
Fajar Priyanto wrote:
Hmm, thanks all..
But, before I remove the mysql installation, I want to restart it first so
that it reads my.cnf file, and see if it corrects the problem.
How do I restart the mysql from command prompt?
I'm using RH6.2 without XWindows.
/etc/init.d/mysqld restart
Max
or some other security manager.
Max
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
to create this database as well.
This is all done on MySQL 3.23.52/gcc 2.95.3/glibc-2.2.5/linux 2.4.19 (RH
7.3)
(please cc: me on replies -- I am not subscribed).
---max kalika
[EMAIL PROTECTED]
-lsit systems administrator
-
Before
/ext folder, not entire contents of zip file with
subdirectories.
Max
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
).
Then put a service file in /etc/init.d and make symlinks to appropriate
/etc/rc.d directories.
how do I login
once I get it up and going, or change passwords, or do
basic admin work?
There is a text client called 'mysql' :-) Check it out.
HTH,
Max
mysql,query
Hello!
Maybe I've missed something in the docs... how can I turn compression on
using JDBC with Connector/J? Or is it turned on by default? If so, how
can I check if it's on or off?
Regards,
Max
-
Before
VALUES(localhost, sample_db,
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
ERROR 1146: Table 'mysql.mysql' doesn't exist
With 'use' you're changing *databases*. You need to create a *table* to
insert data (see 'CREATE TABLE...').
Max
The solution that works best with all broken rpm dependiences is to use
--force --nodeps (verify with the man page).
HTH,
Max
spam filter pass: sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php
Hello!
I can't find a way to turn off buzzer (PC speaker) in mysql console. Am
I missing something or is it impossible and I should report user
interface bug to bugs mailing list?
mysql console version : 11.18 distribution 3.23.51
System: Windows 2000
Max
Mikhail Entaltsev wrote:
What's wrong with your PC speaker in mysql console?!
I am using the same version and have no problem with it.
It's making loud noise on each error. It is *extremely* annoying.
Max
-
Before
series of loud beeps when something goes wrong
for some reason.
Thanks,
Max
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Victoria Reznichenko wrote:
Max,
Friday, August 16, 2002, 11:36:19 AM, you wrote:
MM I can't find a way to turn off buzzer (PC speaker) in mysql console. Am
MM I missing something or is it impossible and I should report user
MM interface bug to bugs mailing list?
Option --no-beep for mysql
can help me, plz?
many thanks in advance
max
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
Perhaps the time component of the date is different, hence you are getting
back what looks like duplicate rows but they're not really?
- Max
Martin Anderson
QA Engineer
ProfitLogic
Eleven Cambridge Center
Cambridge, MA 02142
t: 617.218.1946
-Original Message-
From: Jay Blanchard
I don't want to doubt you :-) but can you show us a select including the
time component? I don't know how date comparison works in MySQL but here is
a test I ran in Oracle. I inserted some dates into a table using sysdate
which include time information and inserted more records using
SELECT MAX(id)
FROM (SELECT MAX(id)
FROM table
WHERE DATE = '20020509'
LIMIT 100)
Dunno if this works in MySQL, I can't access a MySQL database from here to
test it out.
This should return the value that you want but I would be interested to
learn the usefulness
SELECT main.id
FROM MainTable main OUTER JOIN MapTable map ON main.id = map.id
WHERE map.id = null
Does this work? Give it a whirl.
Another solution could be to do it like this:
SELECT col1, col2, coln
FROM MainTable
WHERE id IN (
SELECT id
FROM MainTable
WHERE id NOT IN (
for sql is that I added with
ALTER and remove with DROP. But I can't find anything that would allow me to
move the data from one column to another. Anything I can do?
Max
-
Before posting, please check:
http://www.mysql.com
Hi, my problem is that when i do a
show table status like al%
one of my innodb tables (named
'aluno') says to have 255 rows.
But, in fact, it have 286 rows, by:
select count (*) from aluno;
Someone can help me ?
__
ïîëüçîâàòåëÿ', 'Îáùèé âîïðîñ', 'Ðàñøèðåííûé çàïðîñ',
'Îøèáêà íà WEB ñåðâåðå', 'Îøèáêà ïîëüçîâàòåëÿ') NOT NULL DEFAULT 'Bug';
# It is to see what happens with ID
select ID from tableA;
Fix:
none
Submitter-Id: submitter ID
Originator:Max
Organization:
Integral Solutions Corp.
MySQL support
I have a linux redhat 7.2 system. I am trying to install bugzilla which
uses mysql. I have installed apache and have completed mysql
installation post tests successfully using the -p form of the commands.
However, I never succeeded in getting
mysql -u root -h 192.168.1.15 -p password
Hi,
I need to transform a europe date like 10/09/2001 (dd/mm/) in this
format: 2001/09/10 (/mm/dd) ... how can I do using the mysql functions?
many thanks in advance
max
-
Before posting, please check:
http
I'm sure I'm just missing something basic, but here goes...
I need to create a table, populated with data, from an existing table.
Easy enough:
create table TEST select * from OLD_DATA
Most cool. Now, let's say OLD_DATA has three columns: A, B, C. I
want to create new table TEST, with all
There are only 8,000 rows. Unfortunately, I was really hoping for some
sort of function within MySQL to do this. I'm not using PHP, but rather
Perl. I could pretty much do the same thing in Perl, I guess. Is there
any elegant solution or alternative within MySQL?
On Friday, July 20, 2001,
in set (0.01 sec)
Has MySQL a problem comparing a tinyint value with a supplied int?
I was able to reproduce this on other versions and other platforms, so what's
this? Any Comments?
Fix:
Submitter-Id:
none yet
Originator:max
Organization:
MySQL support: none
Synopsis
with Mysql via MyODBC I think
that is not good idea to use Approach as GUI for a mysql db/tables, but for
my personal experience they work together
max
-
Before posting, please check:
http://www.mysql.com/manual.php
,movimento,soggetto,lingua)
what does it means?? (vers. 3.23.37 on win2k box)
many thanks in advance
max
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
I work for a web hosting company that has mysql 3.22.23 on one
of our servers. The server is Free BSD unix version 3.5. It seems every
few weeks it pops up with this
error.
System Error: DBI-connect(WWWThreads:localhost) failed: Can't
create a new thread (errno 35). If you are not out of
I work for a web hosting company that has mysql 3.22.23 on one
of our servers. The server is Free BSD unix version 3.5. It seems every
few weeks it pops up with this
error.
System Error: DBI-connect(WWWThreads:localhost) failed: Can't
create a new thread (errno 35). If you are not out of
Hello, I've been trying to make and ODBC connection with a remote database
and I can't. What should I do?
Something else, Can I have a connection between Visaul Basic and MySqlwith a
remote database?
Thank you.
-
Before
63 matches
Mail list logo