Both versions, 4.0.4b and 4.0.5a are from mysql.com.
RPM doesn't seem to have a way to get a description of a package (that i can
find) or i would paste the information (maybe author or whatever) of the
packages i'm using.. to make sure they really are MySQL AB's.
-johnny
Quotin
s implimentation of mysql_connect (on the tcp/ip side)? Or myabe
it's something wrong with the MySQL library?
Comments?
-Johnny Withers
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (
r.created_dt BETWEEN '2008-12-30 00:00:00' AND '2008-12-30
23:59:59'
That works on both servers, but I really don't want to have to put the time
in there (unless that's the way you are supposed to do this).
I've though about using DATE_FORMAT... not sure about that either.
-
Johnny Withers
601.209.4985
joh...@pixelated.net
he query to select from the customer_id table first, if a row
is found.. just return the matching customer_id from the customer table..
but I wanted to see if maybe i'm going about this the wrong way before I
"engineer" some way around this.
Thanks in advance,
-
Johnny Withers
601.209.4985
joh...@pixelated.net
ctoin system
(RHEL 64-Bit 16GB ram, Dual Xeon 2Ghz).. the search in the test system is
almost instant as compared to the production system its taking 4 to 6
seconds. There's not much traffic today on it.
I'm going to put the UNION into production and see how it goes.
Thanks for the replies.
27;s data is who's). It also
>> feels like it could leak data if a malformed query were to get through,
>> although I'm not terribly worried about this as we do some heavy UAT
>> before pushing from DEV to TEST to PROD.
>>
>> Performance is a major factor c
could leak data if a malformed query were to get through,
> >> although I'm not terribly worried about this as we do some heavy UAT
> >> before pushing from DEV to TEST to PROD.
> >>
> >> Performance is a major factor concern here given our huge d
, Wm Mussatto wrote:
> On Wed, March 18, 2009 06:29, Johnny Withers wrote:
> > Everytime we make a schema change in development we save an SQL script
> > into
> > a directory named in MMDD format. The scripts are named in
> > MMDD_NNN_DESCRIPTION.SQL format, where
st
> log
>> file name in binary log index file' from master when reading data from
>> binary log
>>
>>
>>
>> I'm sure that I've overlooked something, well, stupid, but have
>> struggled with it the last few days to no avail. All servers are u
e` (
> `id` , `id-crc`
> )
> VALUES (
> NULL , LAST_INSERT_ID()
> );
>
> But LAST_INSERT_ID() is 0 How can I make that, that he use the actual
> INSERT-ID?
>
> Best regards
>
> Thunder
>
>
>
>
>
>
>
>
>
>
> --
> MySQL General
On Sunday, May 3, 2009, thun...@isfahan.at wrote:
> Hi Johnny,
>
> I need the CRC32 for a unique URL-ID...
>
> I think it isn't to slow when I make a SELECT later in this form:
>
> Rows in Table: 825,984
>
> Search for id: 2532552 (CRC32: 46316330)
>
> SELECT i
Yes, Triggers... I so rarely use them I forget they exist.
On Tue, May 5, 2009 at 10:22 AM, Thomas Pundt wrote:
> Johnny Withers schrieb:
>
>> Well, I think an update after insert is the only way. Other than
>> perpopulating another table with possibe crc values then usinga
lclient.so.16.0.0
-rwxr-xr-x 1 root root 2044464 Mar 31 22:48
/usr/lib/libmysqlclient.so.16.0.0
--
_
Johnny Stork
Open Enterprise Solutions
"Empowering Business With Open Solutions"
http://www.openenterprise.ca
Mountain Hosting
"Secure Hosting Solutions for Business"
http://www.mountainhosting.ca
Typo, moved from 5.0.67 to 5.1.34
Johnny Stork wrote:
I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from
5.64. Access to the db seesm fine from the shell, phpmyadmin or even
the Trixbox/FreePBX tool, but trying to apply Trixbox changes, or
running a "pear update" pr
tp://lists.mysql.com/mysql?unsub=g...@primeexalia.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=li...@openenterprise.ca
--
_
Johnny Stork
Open Enter
le1 in A's data? Could we then export (SELECT INTO OUTFILE) from A's data
and import (LOAD DATA) into B's data?
Has anyone done something like this before? Did you have problems?
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
e the ID column in table1, then add
the same # to the table1_id columns in any other table. After we do this, we
could do the select from.. insert into method I suppose.
-jw
On Mon, May 11, 2009 at 2:49 PM, Weston, Craig (OFT) <
craig.wes...@oft.state.ny.us> wrote:
>
>
> -Origin
l
> server. Is there anybody using on productions.
>
> Thanks,
> Prajapati
>
> Krishna Chandra Prajapati
> Email-id: prajapat...@gmail.com
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
MySQL General Mailing List
For list arc
see it continuing to write to this file
until the loop is complete.
You can assume what you like about PHP, but that doesn't make it true.
-johnny
On Wed, Jun 3, 2009 at 2:03 PM, Daevid Vincent wrote:
> We have a "NOC" that displays this sort of thing and shows myTop in six
).
>>>>
>>>> Does such a tool exists? No problem if it is mysql only. If not, I think
>>>> I
>>>> will write one.
>>>>
>>>> Peter Boros
>>>>
>>>
>>> It is by no means the only such tool, but I have often use JMeter as
>>> an all-purpose load-generation tool. It has good support for database
>>> testing among other things..
>>>
>>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>>
>>>
>>
> --
> 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
low 10, 50 and 100 mile radi for example)
>
> Any ideas?
>
> Thanks in advance!
>
> Matt
>
> --
> 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
-
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com <http://www.avg.com> Version: 8.5.364 / Virus
> Database: 270.12.80/2187 - Release Date: 06/19/09 06:53:00
>
>
>
>
--
-
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
version = 5.0.32-Debian_7etch8-log
>
> TIA,
> Ralph
>
>
> --
> 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
?
> > >> >> >
> > >> >> > thanks,
> > >> >> >
> > >> >> > --
> > >> >> > Tianjing
> > >> >> >
> > >> >>
> > >> >>
> > >> >>
> > >> >> --
> > >> >> A: It reverses the normal flow of conversation.
> > >> >> Q: What's wrong with top-posting?
> > >> >> A: Top-posting.
> > >> >> Q: What's the biggest scourge on plain text email discussions?
> > >> >
> > >> >
> > >> >
> > >> > --
> > >>
> > >>
> > >> --
> > >> A: It reverses the normal flow of conversation.
> > >> Q: What's wrong with top-posting?
> > >> A: Top-posting.
> > >> Q: What's the biggest scourge on plain text email discussions?
> > >>
> > >> --
> > >> MySQL General Mailing List
> > >> For list archives: http://lists.mysql.com/mysql
> > >> To unsubscribe:
> > >> http://lists.mysql.com/mysql?unsub=jingtian.seu...@gmail.com
> > >>
> > >
> > >
> > >
> > > --
> > > Tianjing
> > >
> > >
> >
> >
> >
> > --
> > A: It reverses the normal flow of conversation.
> > Q: What's wrong with top-posting?
> > A: Top-posting.
> > Q: What's the biggest scourge on plain text email discussions?
> >
>
>
>
> --
> Tianjing
>
> Bioinformatics Center,
> Beijing Genomics Institute,Shenzhen
> Tel:+86-755-25273851
> MSN:tianjing...@hotmail.com <
> msn%3atianjing...@hotmail.com >
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
---+
> | 1 | SIMPLE | REF_SEQ | ALL | NULL | NULL | NULL| NULL
> | 219728 | Using where |
>
> ++-+-+--+---+--+-+--++-+
>
>
>
>
> 2009/7/13 Johnny Withers
>
>>
| index_ref_start |
> 8 | NULL | 2408 | Using where |
>
> ++-+-+---+-+-+-+--+--+-+
>
> in this sql,the index is on REF_ID and START_POSITION, the rows in the
> output is more less than that i
-- 1 mysql mysql 70038585344 2009-06-17 04:09 ibdata1
> -rw-rw 1 mysql mysql 5242880 2009-07-14 01:43 ib_logfile0
> -rw-rw 1 mysql mysql 5242880 2009-06-17 03:22 ib_logfile1
> drwxr-xr-x 2 mysql mysql4096 2009-07-14 00:36 mysql
>
>
> --
> 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
; machine.
> --
> Scott
> Iphone says hello.
>
> --
> 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
unt(*) from orders where item_id = 9602 and customer_id = 5531 ->
> 1226 records
> select count(*) from orders where item_id = 9602 and customer_id = 5531 and
> status_id IN (1,2) -> 1174 records
>
>
>
> --
> 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
lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
>
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
Maybe I'm wrong :)
On Tuesday, July 21, 2009, John Daisley wrote:
>
>
> On Tue, 2009-07-21 at 19:42 +0200, Morten Primdahl wrote:
>
>> On Jul 21, 2009, at 3:27 PM, Johnny Withers wrote:
>>
>> > MySQL is unable to use your index when you use IN and/or OR on
uld do in the event of a
> disconnect with the ignore_user_abort() function. See the connection
> handling page for more details:
>
> http://us3.php.net/manual/en/features.connection-handling.php
>
> On Wed, Jun 3, 2009 at 2:54 PM, Johnny Withers wrote:
>> It just seems odd to me t
y
> > other approach available to achieve this in mysql.
> >
> > Looking for your help.
> >
> > Thanks,
> > Manoj
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.my
t;
> ---
> INSERT IGNORE test.test_table (name) VALUES ('test')
>
> SHOW TABLE STATUS
> Nametest_table
> ...
> Auto_increment 6
>
>
>
> --
> ---
> This is a signature.
>
> --
> 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
s: 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
QL 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
ver, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database questions? Check the forum:
> http://www.databasedevelopmentforum.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
sing where
>
> Can anyone tell me how to make it use the available indexes? Or do I
> need to add some sort of multi-column index? I'm guessing not as I'm
> doing OR's
>
> Thanks
>
> Simon
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
ect substr(t, instr(t, '/sr/db/'), instr(substr(t, instr(t, '/sr/db/'),
> length(t)), chr(10))) from tmp;
> /sr/db/ora/ora.ora
> /sr/db/ora/ora.ora
> where chr(10) ..represents "NEW LINE" in oracle
>
> How do i do the same in mysql.
>
> Thanks for all you help.
>
> regards
> anandkl
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
.
Maybe?
On Fri, Aug 21, 2009 at 10:13 AM, Jerry Schwartz wrote:
> >-Original Message-
> >From: Ananda Kumar [mailto:anan...@gmail.com]
> >Sent: Friday, August 21, 2009 2:55 AM
> >To: Johnny Withers
> >Cc: MySQL
> >Subject: Re: alternate in mysql
>
rt to look for the causes?
>
> Thanks.
>
> Jia
>
> --
> 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
't connect
> to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
> Aug 25 22:18:20 chenj-desktop /etc/init.d/mysql[11094]: Check that mysqld is
> running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
> Aug 25 22:18:20 chenj
I'm at work now, this is the cmd I used:
chcon -R -u system_u -r object_r -t mysql_db_t /data
(my data lives in /data/mysqlXX -- were XX is the server version)
On Wed, Aug 26, 2009 at 8:02 AM, Johnny Withers wrote:
> Yes, error 13, permission denied. Check selinux setup. I had t
claudio.na...@gmail.com
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=eric.ber...@gmail.com
>
>
>
>
>
>
>
>
>
>
>
> --
> MySQL Genera
mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
>
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
ets).
>
> My brain is melting. What am I doing wrong?
>
> --
> 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
Yes, I don't see why that wouldn't work...
On Mon, Nov 2, 2009 at 11:09 AM, Brian Dunning wrote:
> Johnny - Your solution might actually help me solve my next step, which is
> to also return a count of pets bought only within the last 7 days. Something
> like this:
>
sorry I didn't catch it before sending the
> mail. The ls output was copy-pasted from a terminal and there the ownerships
> are correct.
>
> Regards,
> Sebastiaan
>
>
--
-
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
/lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=john.l.me...@gmail.com
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.425 / Virus Database: 270.14.52/2484 - Release Date: 11/08/09
> 07:37:00
>
>
>
03:12:22] mysql_real_connect failed: Access denied for
> >> user 'root'@'localhost' (using password: NO)
> >> [2009-12-21 03:12:22] read-function of plugin `mysql' failed. Will
> >> suspend it for 10 seconds.
> >>
> >> I am not able to figure out why i get r...@localhost and not
> >> nag...@localhost in the collectd.log file even after specifying it in
> >> the collectd.conf file.
> >>
> >> Please suggest/guide.
> >>
> >> Thanks,
> >>
> >> Kaushal
> >>
> >
> > Hi Again,
> >
> > Any updates to my earlier post to this Mailing List ?
> >
> > Thanks,
> >
> > Kaushal
> >
>
> Hi Again,
>
> I have not got any reply for my query. Checking in again on this Mailing
> List.
>
> Thanks,
>
> Kaushal
>
> --
> 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
design for the shopping cart I just finished building and need to
> get this up __n_o_w__, what would your advice be?
> V
>
> >
> > Regards,
> > Baron
> >
> > --
> > Baron Schwartz
> > Percona Inc: Services and Support for MySQL
> > http://www.percona.com/
> >
>
>
>
> --
> The Logos has come to bear
> http://logos.13gems.com/
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
>
>
--
-
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
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
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
; 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
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!
>
&
(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
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
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
> 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
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
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
ttp://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
>
>
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
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
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
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
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
>
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
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
> 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
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)
-----
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,
>
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
; > > 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
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
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
>> >
> >> >> >> 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
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
.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
-+-+
> | 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
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:
> >
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%';
> +-
--+
>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
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
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
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
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
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
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.
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
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
s.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
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
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
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
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
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
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
1 - 100 of 223 matches
Mail list logo
