_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
wrote:
> On Mon, Jan 25, 2016 at 8:26 PM, Johnny Withers
> wrote:
> > You should probably turn this into a UNION and put an index on each
> column:
> >
> > SELECT f_tag_ch_y_bottom AS ftag FROM data_cst WHERE f_t
> clause, as that would exclude the already 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 m
s ran you get a duplicate
key entry for an attempt to insert 1000 again.
On Mon, Jun 29, 2015 at 7:03 PM, Johnny Withers
wrote:
> Hello all,
>
> I have a tabled defined:
>
> CREATE TABLE `store_seq` (
> `seq_type_id` smallint(3) unsigned NOT NULL DEFAULT '0',
>
it may not be working on that one server?
Thanks,
--
-
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" wrote:
> hello,
>
> I have a replication client where replication stopped because mysql said
> that the SUPER privilege was required for an u
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 dre
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" wrote:
> Yes sorry, here's the explain. It w
responsibility
> for any loss or damage arising from the use of this email or attachments.
> This disclaimer was added by Policy Patrol: http://www.policypatrol.com/
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
es in the list of tables from which
> >>>>>> to
> >>>>>> delete rows in a multiple-table delete, the default database is used
> >>>>>> unless
> >>>>>> one is specified explicitly. For example, if the default database is
>
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 wrote:
>
> Dear all,
>
> I realize this is a very
The client indicates a warning after the update. Issue a show warnings
after the update.
On Aug 19, 2012 11:19 AM, "william drescher"
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 it to 'X'
Would you consider a service like www.xeround.com?
Sent from my iPad
On Jul 17, 2012, at 7:23 PM, Carl Kabbe 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
> obvious that NDB w
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
M, Charles 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
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 Withers
601.209.4985
joh...@pixelated.net
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" wrote:
>
> Hello,
>
> I have be
rchives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
S.PHONE = CALLS.PHONE
> WHERE CUSTOMERS.DATE = "02/28/12" AND CALLS.DATE = "02/28/12"
>
> I've tried 100's of combinations of this query; many different OR, AND,
> GROUP BY combinations --- but I can't pull up ALL records from CUSTOMERS
> with DATE
he 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 al
th current value + 1.
> 4. Unlock 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
>
ld was not the only condition.
>
> - michael
>
> On Thu, Feb 9, 2012 at 9:22 AM, Johnny Withers 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 iPa
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 wrote:
> On 2/9/2012 8:22 AM, Johnny Withers wrote:
>> Update table set mydate=now() where
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 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 would appreciate
> sug
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 wrote:
>
>
> Am 10.01.2012 13:29, schrieb Johan De Meersman:
>> - Original Message ---
"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 wrote:
> I remain convinced that users simply need to learn patience, though.
--
MySQL General Mailing List
Fo
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" wrote:
* Claudio Nanni [111018 17:02]:
> FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
> etc,
>
> Usually this ...
linus:~ tim$ sudo mysql
Pas
Max packet size?
On Oct 10, 2011 6:12 PM, "Neil Tompkins"
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: http://lists.mysql.com/mysql
To unsub
long time, so i'm not sure about this but.. is
the INSERT locked 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
d recover and prune,etcno luck.
> thanks
> mjh
>
> On Thu, Oct 6, 2011 at 9:15 AM, Johnny Withers 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
>
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,
t help.
>
> -- Forwarded message --
> From: Tompkins Neil
> Date: Wed, Oct 5, 2011 at 9:48 AM
> Subject: Re: Slow query - please help
> To: Johnny Withers
> Cc: "mysql@lists.mysql.com"
>
>
> I just revised my query and now get the followin
Can you post the explain extended output of your query?
Sent from my iPad
On Oct 4, 2011, at 2:45 PM, Neil Tompkins wrote:
> Can anyone help me ?
>
>
> Begin forwarded message:
>
>> From: Tompkins Neil
>> Date: 30 September 2011 20:23:47 GMT+01:00
>> To: mark carson
>> Cc: "[MySQL]"
>> Su
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" 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 10.1.20.97 /* my windows box */
97
try to put all this information in one
> table?
>
> Thanks,
>
> Richard
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
g. 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
Change the definer to one of your registered root accounts. Root@127 or
root@localhost.
On Aug 17, 2011 8:39 AM, "Brent Clark" 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 with:
CREATE DEFINER=`root`
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" wrote:
> I know my previous email was vague, it was sent via smartphone. I’ve got a
> simple PHP page pulling information from o
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" 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 mysql data file, 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
>
>
is case, no table name at all is needed. (I like to use the same field
> > name in all tables where 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...@pixelated.net
What's your vb code for outputting the results look like?
On Jul 24, 2011 8:22 AM, "Velen Vydelingum" 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
paymentdate<='2010-12-0
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" wrote:
Hi all,
I can't explain strange behaviour of the INSERT statement in the stored
procedure.
The idea is t
What did the explain output look like after the new index?
On Fri, Jul 8, 2011 at 8:53 AM, Leonardo Borges wrote:
> Hi Johnny,
>
> I just gave that a try but it didn't help as I suspected.
>
> I still believe the problem is in mysql not being able to handle set
> subt
| a | ref | user_idx,email_idx,activity_idx |
> user_idx | 5 | getup.u.id | 20 | Using where |
>
> ++-+---+---+-+--+-++----+-+
>
>
> Cheers,
> Leonardo Borges
> www.leonardoborges.com
>
>
> On Fri, Jul 8, 2011 at 11:58 AM, Johnny Withers wro
Can you post show create table for activity and explain output of the
problem query?
On Jul 7, 2011 8:51 PM, "Leonardo Borges"
wrote:
Hello everyone,
I have an increasingly popular web application running on top of mysql and
due to its popularity, I'm running into performance issues. After care
7;m not quite
sure why it would fail. I could understand 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
ySQL 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
***
Variable_name: version_compile_os
Value: redhat-linux-gnu
Thanks!
--
-----
Johnny Withers
601.209.4985
joh...@pixelated.net
t; > 1298999201 - (1298999201 % 85400)
>> > That just gives me a unix time from yesterday...
>> >
>> > How can I convert 1298999201 (3/1/2011 11:06:41 AM) to 1298959200
>> > (3/1/2011 12:00:00 AM)?
>> >
>> >
>> > --
>> > M
hit
yet, but it performed well in testing. Our 5.0 installs are handling about
25gb of data and 1200qps during peak hours.
On Feb 27, 2011 2:29 PM, "Yang Yang" wrote:
thanks johnny
what about 5.1,did it performance better than 5.0 on centos when it has
large traffic?
5.1 is newe
e php+mysql
>
> 2.the my.cnf should i configure or where i can find some information?
>
> thanks all ,hope receive responce
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
e of your contribution; not just the information that leads to
> judgement in one particular direction or another. -- Richard P. Feynman
> Jan Steinman, 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
ds=1
> >
> > log-slow-queries = /var/log/mysql2-slow.log
> > innodb_file_per_table
> > query_cache_size = 128M
> > join_buffer_size = 3M
> > tmp_table_size = 256M
> > max_heap_table_size = 256M
> > thread_cache_size = 4
> > table_cache = 6608
> > inn
ms.ID'. When I fixed this, it
> worked :)
>
> Thanx anyway.
>
> --
> Jørn Dahl-Stamnes
> homepage: http://www.dahl-stamnes.net/dahls/
>
> --
> 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
how to measure where the issue could
> be would help as well.
>
> Steve
>
>
> --
> 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
he slave matches the master 100%.*
> *
> *
> Try it with *semi-synchronous* replication.
>
> Best regards.
> --
> Wagner Bianchi
>
>
> 2010/12/27 Johnny Withers
>
> Might want to check out LVM snapshots:
>>
>>
>> http://www.mysqlperformanceblog.c
s.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
>
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
gt; whereas the results I want is
>
> +--+
> | id |
> +--+
> |5 |
> |7 |
> | 11 |
> +--+
>
> Please tell me, where is wrong
>
> Thanks & Regards
> --
> Muhammad Subair
> +62 8176583311
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
ery. Then I iterate through the array again and check the
> value in the field. 1 means the UID has an entry, 0 means it doesn't. I
> thought doing 1 mysql call would be more efficient than lots of calls as I
> iterate through the array. But since there will probably never be more than
> 100 images 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
Your very first mysql_fetch_array consumes the first result.
On Dec 19, 2010 8:19 AM, "Gary" 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 DB that lists beers.
k, you might try
>>> and change the data type to DECIMAL to see if it helps (or BIGINT if your
>>> numbers are not using 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
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
27;
>
>
> --
> 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
2.168.%.%';
>
> but, within that somewhere also check to see if src_ip exists in mappings.
> If it does, do not return it.
>
> Is this possible?
>
> Thanks.
> --
> Paul Halliday
> Ideation | Individualization | Learner | Achiever | Analytical
> http://www.pintumbler.org
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
ATE TABLE `dim_seat` (
> `id_dim_seat` int(10) unsigned NOT NULL auto_increment,
> `seat` varchar(4) default NULL,
> PRIMARY KEY (`id_dim_seat`),
> KEY `seat` (`seat`)
> ) ENGINE=InnoDB
>
> id_dim_seat seat
> --- --
> ... ...
>888 35C <---
>889 35D <---
>890 35E <---
>891 35F
>892 35G
>... ...
>
>
> --
> 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
gt; --
> 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
--
MySQL General Mailing
--+
>1 row in set (0.00 sec)
>
>
>
> Would it make sense to split the Call_No data off into it's own table, and
> put in a proper numeric ID, instead of the current VARCHAR(36) it uses? So
> in Newspaper_Issues I'd just have a Call
PM, Vokern wrote:
> 2010/9/23 Johnny Withers
> >
> > Can you show us the output of: show status like '%innodb%'
> > JW
> >
>
>
> Sure.
>
> mysql> show status like '%innodb%';
> +-
This is even better!
JW
On Wed, Sep 22, 2010 at 2:27 PM, Steve Staples wrote:
> What about:
> select `id`, `column1` as 'column2', `column2` as 'column1';
>
> Steve
>
>
>
> On Wed, 2010-09-22 at 13:06 -0500, Johnny Withers wrote:
> >
-+-+
> | id | column1 | column2 |
> ++-+-+
> | 1 | a | z |
> | 2 | b | y |
> | 3 | c | x |
> | 4 | d | w |
> | 5 | e | v |
> ++-+-+
>
> Can you achieve this with a simple query?
> so for id 1 column1 = 'z' and column2 = 'a' and so on.
>
> Thanks guys,
> Igor
>
> --
> 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
.42 4.49 3.40
> > 8.00 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
601.209.4985
joh...@pixelated.net
an De Meersman wrote:
>
>
> On Mon, Sep 13, 2010 at 8:59 PM, Johnny Withers wrote:
>
>>
>> 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
>> >
> >> >> >> offset + increment thingy is good if you know in advance that
> you'll
> >> >> have
> >> >> >> a
> >> >> >> limited number of servers. But if you have no idea that you will
> have
> >> 2,
> >> >> >> 20,
> >> >> >> or 200 servers in your array in the future, you just can't pick an
> >> >> optimal
> >> >> >>
> >> >> >
> >> >> > What benefit do you think you will reap from that many masters ?
> Don't
> >> >> > forget that every write still has to be done on every server, so
> >> you're
> >> >> not
> >> >> > actually distributing that load; while for reads you only need
> simple
> >> >> > slaves.
> >> >> >
> >> >> >
> >> >> > --
> >> >> > Bier met grenadyn
> >> >> > Is als mosterd by den wyn
> >> >> > Sy die't drinkt, is eene kwezel
> >> >> > Hy die't drinkt, is ras een ezel
> >> >> >
> >> >>
> >> >
> >> >
> >> >
> >> >--
> >> >Bier met grenadyn
> >> >Is als mosterd by den wyn
> >> >Sy die't drinkt, is eene kwezel
> >> >Hy die't drinkt, is ras een ezel
> >>
> >>
> >>
> >>
>
>
>
>
> --
> 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
oduction over SSH and multithreaded them at the staging server, but SQL
> stuff would be much more 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
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)
------
*John
; > > Uwe Brauer
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
> > > http://lists.mysql.com/mysql?unsub=george.g.lar...@gmail.com
> > >
> > >
> >
>
>
> --
>
> Steve Staples
> Web Application Developer
> 519.258.2333 x8414
>
>
> --
> 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
disk array 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 Vieir
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 wrote:
> Hi,
>
Very confusing...
Why is index_length zero ?
On top of that, there's only 500K rows in the table with a data size of
41MB. Maybe InnoDB is flushing to disk too often?
What's the output of iostat -dxk 60 ? (run for a minute+ to get 2 output
girds)
-----
> 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 wrote:
>
>> Ok, so I'm stumped?
>>
>> What kind of
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 wrote:
> Hi Johnny,
>
> mysql> EXPLAIN SELECT * FROM clientinfo WHERE
writes/s, 40.73 fsyncs/s
> -
> INSERT BUFFER AND ADAPTIVE HASH INDEX
> -
> Ibuf: size 1, free list len 0, seg size 2,
> 0 inserts, 0 merged recs, 0 merges
> Hash table size 1452727, used cells 496505, node hea
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 wrote:
> 1. Find out what is slow
> 2. Fix it
> 3. GOTO 1
>
of storage left even though I
> 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 wrote:
>
>> I recently ran out of table space on a production server that ha
t
add 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 With
neral 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
ttp://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
>
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
t; the last month. I.E. How many records are there where Dep and Des are
>> the
>> same during the last month. With some changes to the application that
>> captures the data in the first place, I should be able to drop the need
>> for
>> this query completely. You have made me think
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...@pixelated.net
> a example. For our query like SELECT check_in_date FROM bookings how 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
o 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...@jab.org
t that's a small
> price to pay for correctness.
>
> Regards,
> Gavin Towey
>
> -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
(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `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
g the sitefieldsort index?
>
> If I change the query to something that returns no rows, such as:
>
> SELECT * FROM form_fields_items WHERE siteid = 1 AND fieldid = 1 ORDER
> BY sortorder
>
> An explain shows it using the correct index.
>
> Thanks for your time!
>
&
; 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
colleagues.
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:http://lists.mysql.com/mysql?unsub=c...@etrak-plus.com
>>
>>
>>
>
> --
> 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
gt; > necessary script
> > > to apply to db_prod.
> > >
> > > Thanks,
> > > Randall Price
> > >
> > >
> >
> >
> > --
> > Bier met grenadyn
> > Is als mosterd by den wyn
> > Sy die't drinkt, is eene kwezel
> > Hy die't drinkt, is ras een ezel
> >
>
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=dae...@daevid.com
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
>
>
>
>
>
>
> --
> 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
n Wed, Jan 13, 2010 at 12:38 PM, Victor Subervi wrote:
> On Mon, Jan 11, 2010 at 3:21 PM, mos 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
unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
>
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
1 - 100 of 223 matches
Mail list logo
