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
> Hello,
>
> is there any way to run a a slow query analyse with "mysdumpslow" only on
> specific mysql user connections? We have multiply application accessing
> the
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:http://lists.mysql.com/mysql?unsub=
Hi Vikram,
Add binlog_format=row to your my.ini master's conf file
2010/4/21 Vikram A
> Hi Hao Ding,
>
> I attached in my request mail it self. Please find the attachment.
> Thank you
>
> --
> *From:* hao ding
> *To:* Vikram A
> *Sent:* Wed, 21 April, 2010 7:25:0
0.99 0.0015.8416.00
0.000.00 0.00 0.00
sdj 0.00 0.00 0.00 0.99 0.00 1.98 2.00
0.000.00 0.00 0.00
sdk 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.000.00 0.00 0.00
2010/3/18 Raj Shekhar
> Max Bube g
: 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
where id = xxx" 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
Hi Jason
The DEFAULT value can't be an expression.
2009/6/26 Jason Todd Slack-Moehrle
> 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,
>`eventid` mediumint(10)
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
> Hi...
>
> I have the following...
>
> mysql> INSERT INTO ParseScriptTBL VALUES
> -> ('auburnCourse.py',40,1,1),
> -> ('auburnFaculty.py',40,2,2),
> -> ('uof
might I 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. T
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 anym
e 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.rightmedi
And if you believe ASP.NET only provides a few benefits, then you are
adequately informed, my friend
Freddie
I agree completely!
Max Michaels
Systems Engineer
Right Media LLC
-Original Message-
From: Freddie Sorensen [mailto:[EMAIL PROTECTED]
Sent: Friday, December 31, 2004 10:02
ite this query?
Any help is greatly 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 un
esses. 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]
uot;cannot 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 unsub
>
>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
select * from bar where foo='1' (1 with quotes)
(foo 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]
_date | 21 |
const |1 | Using where |
+---+--+---++-
+---+--+-+
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: h
an180')");
In Java you would write it like this:
stmt.executeUpdate("insert into apidbusers values('"+ str +"', 'jp', 'zhu','em1','jtan180')");
Max
mysql, query
-
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.
>
> 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.
>
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?
__
D
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
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 * fro
boozled.
Seach 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 li
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 ad
am missing something 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 q
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
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&qu
?
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 unsub
e acl 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
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
are
blocked eg. by firewall 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 &l
er (-u mysql).
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
to jre/lib/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 t
database,
but it seems that the Create_priv permission somehow extends to allow this
user 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 -
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
--
nged
>mysql> INSERT INTO mysql VALUES(localhost, sample_db,
>'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
>ERROR 1146: Table 'mysql.
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
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 m
has arrived. I just don't want to annoy myself and all
people around with long series of loud beeps when something goes wrong
for some reason.
Thanks,
Max
-
Before posting, please check:
http://www.mysql.com/manual.php
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
--
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
is job but w/o success :(
anyone 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
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 (
S
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 th
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
to_date('20
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 Blan
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.mysq
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.mysq
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 ?
__
_Date (F_Date),
KEY F_Thread_owner (F_Thread_owner),
KEY F_Modified_by (F_Modified_by),
KEY F_Modification_date (F_Modification_date),
KEY F_Assign_date (F_Assign_date),
KEY F_Assigned_to (F_Assigned_to,F_State)
) TYPE=MyISAM;
# It is to see that ID exists in this table
select ID from tableA;
#
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 actua
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
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, a
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 a
1 |
+++
10 rows 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
>O
Hi Phil,
I can confirm u that Approach can work 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 p
_prezzo,settore,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://
>>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 no
>>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 no
>Date: Mon, 19 Feb 2001 10:57:35 -0800
>To: [EMAIL PROTECTED], [EMAIL PROTECTED]
>From: Max Harper <[EMAIL PROTECTED]>
>Subject: error 35
>Bcc: [EMAIL PROTECTED]
>
>I work for a web hosting company that has mysql 3.22.23 on one
>of our servers. The server is Free
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 postin
65 matches
Mail list logo
