o require_once()
> >
> >
> >Although it looks like a bug in Moodle, but the guys said it is a MySQL
> >issue. I am confused about that. If you have any idea please let me
> >know. What does this error say exactly?
> >
> > Regards,
> >Mahmood
>
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
On Mon, Jan 25, 2016 at 9:32 PM, Larry Martell <larry.mart...@gmail.com>
wrote:
> On Mon, Jan 25, 2016 at 8:26 PM, Johnny Withers <joh...@pixelated.net>
> wrote:
> > You should probably turn this into a UNION and put an index on each
> column:
> >
> >
lready aggregated rows and I want
> to filter then before the aggregation. Anyone have any idea how I can
> do this?
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
>
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
Found the problem here, someone had created on insert and on update
triggers on this table that were interferring with the process.
This logic works wonderfully when you need sequence numbers that are also
transaction safe. The key is you need a unique index on all the columns
involved.
I think
you get a duplicate
key entry for an attempt to insert 1000 again.
On Mon, Jun 29, 2015 at 7:03 PM, Johnny Withers joh...@pixelated.net
wrote:
Hello all,
I have a tabled defined:
CREATE TABLE `store_seq` (
`seq_type_id` smallint(3) unsigned NOT NULL DEFAULT '0',
`store_id` int(10
,
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
It's there an update trigger defined on the table? It could be doing
something that requires the super privilege.
On May 9, 2015 3:12 AM, Peter Abplanalp pabplan...@accucode.com wrote:
hello,
I have a replication client where replication stopped because mysql said
that the SUPER privilege was
There's a duplicate key on the audit table, 18699. Delete it and restart
slave (start slave). Check slave status again, might be more rows in there
duplicated.
You might want to compare the row to master to ensure it's a duplicate
before deleting from slave.
On Aug 30, 2014 7:52 AM, william
Just because it says filrsort doesn't mean it'll create a file on disk.
Table schema and full query would be helpful here too
http://www.mysqlperformanceblog.com/2009/03/05/what-does-using-filesort-mean-in-mysql/
On Aug 11, 2013 1:28 PM, Brad Heller b...@cloudability.com wrote:
Yes sorry,
/
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
and then upgrade to
5.6
and test.
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
When you say locked, do queries on the other databases fail with an
error? If so, whats the error? Is it all queries, or just inserts?
Also, how are you doing your export and import?
Sent from my iPad
On Sep 10, 2012, at 2:38 AM, Roland RoLaNd r_o_l_a_...@hotmail.com wrote:
Dear all,
I
The client indicates a warning after the update. Issue a show warnings
after the update.
On Aug 19, 2012 11:19 AM, william drescher will...@techservsys.com
wrote:
On 8/17/2012 12:13 PM, Rik Wasmus wrote:
I get 1 row affected, but the status does not change when I look
at the row.
If I set
Would you consider a service like www.xeround.com?
Sent from my iPad
On Jul 17, 2012, at 7:23 PM, Carl Kabbe c...@etrak-plus.com wrote:
On Monday, I asked if there were consultants out there who could help set up
an NDB high availability system. As I compared our needs to NDB, it became
I don't see any attachments.
First, I would upgrade to 5.5 as 5.0 is very old. The upgrade process
is painless.
Second, make sure your Innodb buffer pool is allocating as much ram as
possible. I'd even go as far as adding another 8gb of ram to the
server. The buffer pool setting is going to give
Cazabon
charlesc-mysql@pyropus.ca wrote:
Johnny Withers wrote:
I hope someone can help me out here. I'm having trouble with some new
servers and memory allocation.
Some basic specs on the servers:
32GB total mem
2GB swap
64-bit RHEL
64-bit mysqld
overcommit_memory=2
:~]$ cat /etc/crontab | grep oom
0,15,30,45 * * * * root bash /usr/local/bin/mysql-no-oom.sh
[root@mail:~]$ cat /usr/local/bin/mysql-no-oom.sh
#!/bin/bash
pgrep -f /usr/libexec/mysqld | while read PID; do echo -1000
/proc/$PID/oom_score_adj; done
--
-
Johnny
You may want to ensure the nic is connected to the network at the
right speed and duplex. It seems that every new server I get now has
to have the speed and duplex explicitly set instead of auto negotiate.
Sent from my iPad
On Apr 9, 2012, at 4:00 AM, J. Bakshi joydeep.bak...@infoservices.in
/mysql
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
the table.
5. Do your inserts.
The lock will be very brief, perhaps brief enough to satisfy your
requirement.
--
Arthur
Cell: 647.710.1314
Only two businesses refer to their clientele as users: drug dealing and
software development.
-- Arthur Fuller
--
-
Johnny
miised the first message in this thread but is there some compelling
reason why you simply don't use a unique index on the primary key of the
table to prevent duplicates in the first place?
--
Rhino
On 2012-02-22 09:40, Johnny Withers wrote:
You can also handle this with transactions
Update table set mydate=now() where mydate='-00-00'; should do it.
Sent from my iPad
On Feb 9, 2012, at 7:15 AM, william drescher will...@techservsys.com wrote:
I want to update a date field in a record. if the date in the field is
-00-00 I want to change it to the current date. I
So, add your other criteria to the where clause, you failed to say
there were other conditions in your first email.
Sent from my iPad
On Feb 9, 2012, at 7:56 AM, william drescher will...@techservsys.com wrote:
On 2/9/2012 8:22 AM, Johnny Withers wrote:
Update table set mydate=now() where
of the date field was not the only condition.
- michael
On Thu, Feb 9, 2012 at 9:22 AM, Johnny Withers joh...@pixelated.net wrote:
So, add your other criteria to the where clause, you failed to say
there were other conditions in your first email.
Sent from my iPad
On Feb 9, 2012, at 7:56 AM
Security through obscurity?
If none of your MySQL (or samba) servers are open to untrusted
networks, why do you need to hide this information.
Sent from my iPad
On Jan 10, 2012, at 6:35 AM, Reindl Harald h.rei...@thelounge.net wrote:
Am 10.01.2012 13:29, schrieb Johan De Meersman:
-
I remain convinced that users simply need to learn patience, though.
HAHAHAHAHAHAHAHAHAHAHAHAHAHAHA!!!
Good one!
Sent from my iPad
On Oct 20, 2011, at 8:44 AM, Johan De Meersman vegiv...@tuxera.be wrote:
I remain convinced that users simply need to learn patience, though.
--
MySQL General
Why does mysql say using password: no? Seems to me the password is not
being sent.
On Oct 18, 2011 8:37 PM, Tim Johnson t...@akwebsoft.com wrote:
* Claudio Nanni claudio.na...@gmail.com [111018 17:02]:
FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
etc,
Usually
Max packet size?
On Oct 10, 2011 6:12 PM, Neil Tompkins neil.tompk...@googlemail.com
wrote:
As per the subject we've a large insert query that gives up the error
MySQL server has gone away when we try to execute it. Any ideas why ?
--
MySQL General Mailing List
For list archives:
I think in order to solve your problem you will need to post the queries
running against this table along with the explain output of each problem query.
Optimizing server settings is a good start, however, individual query
performance sounds like your problem now.
Sent from my iPad
On Oct 6,
no luck.
thanks
mjh
On Thu, Oct 6, 2011 at 9:15 AM, Johnny Withers joh...@pixelated.net wrote:
I think in order to solve your problem you will need to post the queries
running against this table along with the explain output of each problem
query. Optimizing server settings is a good
due to the SELECT queries that have been running for so
long? And are the rest of the selects (with 8s running time) locked by the
INSERT?
-
Johnny Withers
601.209.4985
joh...@pixelated.net
that
would be a great help.
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Wed, Oct 5, 2011 at 9:48 AM
Subject: Re: Slow query - please help
To: Johnny Withers joh...@pixelated.net
Cc: mysql@lists.mysql.com mysql@lists.mysql.com
I just revised
Can you post the explain extended output of your query?
Sent from my iPad
On Oct 4, 2011, at 2:45 PM, Neil Tompkins neil.tompk...@googlemail.com wrote:
Can anyone help me ?
Begin forwarded message:
From: Tompkins Neil neil.tompk...@googlemail.com
Date: 30 September 2011 20:23:47
Check your auto negotiate setting on your nic. Run ifconfig and see if there
are a lot of errors.
On Sep 29, 2011 10:13 AM, Jim Moseby jmos...@elasticfabrics.com wrote:
Yeah:
# host 72.30.2.43 /* yahoo.com */
43.2.30.72.in-addr.arpa domain name pointer ir1.fp.vip.sk1.yahoo.com.
# host
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
Change the definer to one of your registered root accounts. Root@127 or
root@localhost.
On Aug 17, 2011 8:39 AM, Brent Clark brentgclarkl...@gmail.com wrote:
Hiya
Ill be up front my saying my knowledge of store procedures is limited.
A Developer gave me a procedure to load.
It starts off
. I really appreciate it.
I know the answer (well I think I do :) ), but im still going to ask. What
is the risk if do the GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED
BY 'mysql' WITH GRANT OPTION;
To satisfy the developer.
Thank you again.
Brent
On 17/08/2011 15:42, Johnny Withers wrote
This is a poor benchmark because the query never changes. Query cache takes
over after first request.
Sent from my iPad
On Aug 16, 2011, at 4:28 PM, Alvin Ramos alvin.ra...@reachsmart.com wrote:
I know my previous email was vague, it was sent via smartphone. I’ve got a
simple PHP page
du reports how much space the file takes on the disk. This # depends on the
block size of each file system.
On Aug 11, 2011 9:13 PM, Feng He short...@gmail.com wrote:
Hello DBAs,
Though this is not exactly a mysql problem, but I think this list may
be helpful for my question.
I have dumped a
It's simple... ttwwadi is the only reason I assume.
Sent from my iPad
On Aug 5, 2011, at 2:39 PM, (Hal�sz S�ndor) h...@tbbs.net wrote:
2011/08/04 10:21 -0500, Johnny Withers
http://en.wikipedia.org/wiki/Hungarian_notation
On Thu, Aug 4, 2011 at 9:41 AM, Mike Diehl mdi
it has the same function.)
--
Take care and have fun,
Mike Diehl.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh
What's your vb code for outputting the results look like?
On Jul 24, 2011 8:22 AM, Velen Vydelingum ve...@biz-mu.com wrote:
Hi,
I have the following query which is fine when I run it from the mysql shell
screen:
select supplier_code,0,0,0,0,0-sum(amountpaid),0 from custpayments where
It seems to me that your insert statement is trying to insert duplicate rows
into the storage table. This is why insert ignore and replace work.
On Jul 9, 2011 3:49 AM, Igor Shevtsov nixofort...@googlemail.com wrote:
Hi all,
I can't explain strange behaviour of the INSERT statement in the stored
|
++-+---+---+-+--+-+++-+
Cheers,
Leonardo Borges
www.leonardoborges.com
On Fri, Jul 8, 2011 at 11:58 AM, Johnny Withers joh...@pixelated.netwrote:
Can you post show create table for activity and explain output of the
problem query?
On Jul 7, 2011 8:51 PM, Leonardo Borges
,
Leonardo Borges
www.leonardoborges.com
On Fri, Jul 8, 2011 at 11:18 PM, Johnny Withers joh...@pixelated.netwrote:
Leonardo,
I think a new compound key on email_id and activity in the activities
table may help.
I'm not sure if this will help or not, Its hard to test w/o having a large
Can you post show create table for activity and explain output of the
problem query?
On Jul 7, 2011 8:51 PM, Leonardo Borges leonardoborges...@gmail.com
wrote:
Hello everyone,
I have an increasingly popular web application running on top of mysql and
due to its popularity, I'm running into
a later statement failing due to
this one having the table locked or something.
MySQL v5.5.9-log
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
: version_compile_os
Value: redhat-linux-gnu
Thanks!
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
(3/1/2011 12:00:00 AM)?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
should i configure or where i can find some information?
thanks all ,hope receive responce
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
not newer is better
thanks again
2011/2/28 Johnny Withers joh...@pixelated.net
I think the version CentOS (5.5) wants to use is 5.0.77-log. I don't think
CentOS will be updat...
, EcoReality Co-op
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
= 6608
innodb_buffer_pool_size = 2G
long_query_time = 10
log-error=/var/log/mysqld2.log
tmpdir = /tmp/tmpdir
Is there anything I can do?
Thank you.
Santiago
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
the data on the slave matches the master 100%.*
*
*
Try it with *semi-synchronous* replication.
Best regards.
--
Wagner Bianchi
2010/12/27 Johnny Withers joh...@pixelated.net
Might want to check out LVM snapshots:
http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup
in the table at any one time, it may not make any difference.
But now I'm just curious as to why this is happening.
Thanks,
Bob
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
me, where is wrong
Thanks Regards
--
Muhammad Subair
+62 8176583311
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
Your very first mysql_fetch_array consumes the first result.
On Dec 19, 2010 8:19 AM, Gary gp...@paulgdesigns.com wrote:
I have an issue that the first record in a query is not being displayed. It
seems that the first row in alphabetical order is not being brought to the
screen.
I have a MySQL
any digits after the decimal since BIGINT and DOUBLE
both use 8 bytes for storage).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
Halliday
Ideation | Individualization | Learner | Achiever | Analytical
http://www.pintumbler.org
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
To unsubscribe: http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
vok...@gmail.com wrote:
2010/9/23 Johnny Withers joh...@pixelated.net
Can you show us the output of: show status like '%innodb%'
JW
Sure.
mysql show status like '%innodb%';
+---++
| Variable_name | Value
0.33 338.96 1.14 0.11
The db is still slow. Thanks for the future helps.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
This is even better!
JW
On Wed, Sep 22, 2010 at 2:27 PM, Steve Staples sstap...@mnsi.net wrote:
What about:
select `id`, `column1` as 'column2', `column2` as 'column1';
Steve
On Wed, 2010-09-22 at 13:06 -0500, Johnny Withers wrote:
Couldn't you just rename the columns?
JW
Meersman vegiv...@tuxera.bewrote:
On Mon, Sep 13, 2010 at 8:59 PM, Johnny Withers joh...@pixelated.netwrote:
This sounds like a good job for a 'NoSQL' system. Maybe?
I can't help but blink at that. How exactly is NoSQL going to fix issues
that are related to topology, not inherent SQL
://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
If you still have the mysqld binary and you _think_ it is version
5.3.something, you could try this:
strings /usr/libexec/mysqld | grep 5.3.*
The version # should be somewhere near the top of the output. (Is on my copy
anyway, of 5.0.x)
--
*Johnny Withers*
jwith
time-critical - can't select before the insert :-)
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
Ok, so I'm stumped?
What kind of hardware is behind this thing?
-JW
On Fri, Sep 3, 2010 at 4:44 AM, Alexandre Vieira nul...@gmail.com wrote:
Hi Johnny,
mysql EXPLAIN SELECT * FROM clientinfo WHERE userid='911930694';
1 read views open inside InnoDB
Increasing innodb_thread_concurrency might help without causing any
problems to the overall performance.
Makes total sense if you read:
http://peter-zaitsev.livejournal.com/9138.html
Thanks in advance.
BR
AJ
On Fri, Sep 3, 2010 at 2:31 PM, Johnny Withers
|
+++-++++-+-+--+---++-+-++---+--+++
1 row in set (0.02 sec)
BR
AJ
On Fri, Sep 3, 2010 at 3:18 PM, Johnny Withers joh...@pixelated.netwrote:
What does
SHOW TABLE STATUS LIKE 'table_name'
Say about this table?
-JW
On Fri, Sep 3, 2010 at 8:59 AM
disks?
I'm not an iostat expert, use my research and recommendations with caution
=)
--
*Johnny Withers*
jwith...@ecashsoftware.com
601.919.2275 x112
[image: eCash Software Systems]
On Fri, Sep 3, 2010 at 10:37 AM, Alexandre Vieira nul...@gmail.com wrote:
Hi
than where
your data is. If you have binary and query logging enabled, it's probably a
good idea.
--
*Johnny Withers*
jwith...@ecashsoftware.com
601.919.2275 x112
[image: eCash Software Systems]
On Fri, Sep 3, 2010 at 12:45 PM, Alexandre Vieira nul...@gmail.com
###
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
So, it's not just me that is stuck in this infinite loop? I thought I had
gone mad!
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
On Tue, Aug 31, 2010 at 5:23 AM, Johan De Meersman vegiv...@tuxera.bewrote:
1. Find out what is slow
2. Fix it
3. GOTO 1
increased the table space by 8GB?
About the above - it is saying 6144 KB so it is 6.1 GB.
On Tue, Aug 3, 2010 at 12:05 AM, Johnny Withers joh...@pixelated.netwrote:
I recently ran out of table space on a production server that had the
following configuration line:
innodb_data_file_path
it to the end like so:
innodb_data_file_path=ibdata1:1G;ibdata2:1G;ibdata3:1G;ibdata4:1G;ibdata5:1G;ibdata6:16G;
*ibdata7:16G*
Or will that cause MySQL to complain the file size isn't correct the next
time it starts?
Thanks for any help!
--
-
Johnny Withers
601.209.4985
joh
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
: 8.5.437 / Virus Database:
271.1.1/2859 - Release Date: 05/07/10 06:26:00
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
. Surely there is some way to make InnoDB faster.
Any ideas?
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh
would
I know to automatically insert a missing date like 2010-03-29 between the
date range I search ?
Thanks,
Neil
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
-Original Message-
From: Johnny Withers [mailto:joh...@pixelated.net]
Sent: Monday, March 08, 2010 1:31 PM
To: MySQL General List
Subject: UDF - Sequence Numbers
I have two servers, both running 5.0.77-log, one is setup as a master, the
other as a replication slave.
The database contains
`store_key` (`store_id`),
KEY `store_seq_num_key` (`company_id`,`store_id`,`store_seq_num`),
) ENGINE=InnoDB AUTO_INCREMENT=3049363 DEFAULT CHARSET=latin1
;
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
shows it using the correct index.
Thanks for your time!
Simon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
13, 2010 at 12:38 PM, Victor Subervi victorsube...@gmail.comwrote:
On Mon, Jan 11, 2010 at 3:21 PM, mos mo...@fastmail.fm wrote:
At 09:56 AM 1/11/2010, Johnny Withers wrote:
Victor,
The temporary table solution is not a good one. Use a single table and
store
each item put
://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
1 - 100 of 203 matches
Mail list logo