McGranaham, Jamen wrote:
Have two virtual machines, both running RedHat 7. Both are also running
MySQL 5.6.29 and both have the same data. We have two databases, however,
that keep throwing odd characters on one system but it's OK on the other and
we've not been able to figure out why.
What it sho
On Tue, August 4, 2015 16:05, Ryan Coleman wrote:
> No but there should be. If there's not my task is useless.
>
> Secondly yes. Unique name on it too.
>
> --
> Ryan Coleman
> Publisher, d3photography.com
> ryan.cole...@cwis.biz
> m. 651.373.5015
> o. 612.568.274
On Tue, August 4, 2015 11:19, Ryan Coleman wrote:
> I have been a MySQL user and supporter for over a decade (since 2001) and
> I am almost ashamed to admit that I haven’t the faintest idea on how to do
> joins and unions.
>
> I have a specific query I would love to run…
>
> I have two tables, one
On Thu, December 11, 2014 13:43, Larry Martell wrote:
> On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 wrote:
>> Hi all,
>>
>> It seems like a simple question, however I'm not able to find the
>> answer.
>>
>> Let me explain. I have a DB with lots of columns, one is labeled as
>> 'kenteken' and i
Why not use ENUM with True|False or Y|N Only issue is it doesn't throw
and error of you enter an illegal value but I don't think I've ever
flagged the field as NOT NULL.
On Wed, May 22, 2013 11:32, Darryle Steplight wrote:
> Hey Neil,
> Why not just store it as a TINYINT, that's what I do when I
On Thu, May 9, 2013 15:25, Robinson, Eric wrote:
>>
>> > -Original Message-
>> > From: Robinson, Eric [mailto:eric.robin...@psmnv.com]
>> > Sent: Thursday, May 09, 2013 1:58 PM
>> > To: mysql@lists.mysql.com
>> > Subject: Slow Response -- What Does This Sound Like to You?
>> >
>> > We have
On Fri, April 5, 2013 13:19, Joe Kosinski wrote:
> I also tried mysql_tzinfo_to_sql /usr/share/zoneinfo > sqlLines with the
> following Terminal output:
>
>
> -bash: sqlLines: Permission denied
>
> Joe
Well at lease we are on familiar territory now. Whatever d
On Tue, November 13, 2012 22:38, Prabhat Kumar wrote:
> No, If you are using non-persistence connection & once the query get
> complete you are closing the connection properly.
>
Is this true if you are using mod_php or equivalent?
>
> On Wed, Nov 14, 2012 at 11:44 AM, Trimurthy wrote:
>
>> hi eve
On Sat, December 31, 2011 05:14, Claudio Nanni wrote:
> Ryan,
> My opinion here.
> Any write to memory can go wrong,
> OS , MySQL , Storage engines, client library and so on.
> Innodb has some advanced mechanism for ACID compliance like the double
> write buffer but these are mostly to assure durab
On Fri, December 23, 2011 12:27, Reindl Harald wrote:
>
>
> Am 23.12.2011 21:14, schrieb Jim McNeely:
>> Hello all, happy holidays!
>>
>> What is the best way to run a mysqldump to get the tables, the data, the
>> triggers, the views, the procedures, the privileges and users,
>> everything? It seem
On Tue, October 18, 2011 22:40, Johan De Meersman wrote:
> - Original Message -
>> From: "Ryan Mark"
>>
>> (WordPress does not like to share an app server) and added memcache.
>
> Really? We run dozens of the thing on a couple of virtuals with no
> problems at all. Then again, we don't exa
On Thu, September 15, 2011 11:27, The Doctor wrote:
> On Thu, Sep 15, 2011 at 08:55:16AM -0400, Shawn Green (MySQL) wrote:
>> On 9/14/2011 15:26, The Doctor wrote:
>>> On Wed, Sep 14, 2011 at 09:49:34PM +0530, Ananda Kumar wrote:
So,
You want to have 100,000 buttons for 100,000 entries or
On Fri, August 26, 2011 00:44, Johan De Meersman wrote:
> - Original Message -
>> From: "Adarsh Sharma"
>>
>> Today by chance I am checking the space in mysql data directories.
>
> By chance? That should be automated, as should a million other standard
> checks. Install Nagios.
>
>> When
On Fri, June 17, 2011 07:11, Jerry Schwartz wrote:
>>-Original Message-
>
>
>>What I was really trying to figure out was why it takes me 4
hours to
>>add a new column to my 22-million-row table, and
whether a different
>>table design can avoid that problem.
That reply in the forum says
On Thu, June 9, 2011 11:59, Jerry Schwartz wrote:
>
>
>>
>>A single table is
always consistent. Data inconsistency occurs in sets of
>>interrelated tables, in other words, on the database level.
>>
> [JS] Not even a single table is always consistent
(unless there is
> transactions). Consider a
On Fri, May 13, 2011 08:21, Tina Matter wrote:
> I have a MySQL question that I'm hoping someone can help answer.
>
> We have a linux machine which has MySQL 5.5.8 installed.
> It is currently installed in this location:/opt/mysql
>
> When creating a new database, a folder (with the name of the
On Thu, March 31, 2011 12:33, mos wrote:
> At 11:20 AM 3/31/2011, you wrote:
>>At 07:29 AM 3/31/2011, you wrote:
>>>Thanks for your insight! But I'm still worried about the performance of
>>>IN ( big list of values ). Can you tell me how it is implemented?
>>>
>>>Suppose I have SELECT a FROM b WHER
On Tue, March 22, 2011 10:32, Karen Abgarian wrote:
> Why, if they shut down the slave, it will be quite consistent. Only that
> this technique is not as much of the 21th century, but is like 30 years
> old.
> Placing locks is about the same as shutting it down.
>
Ah, but if you have the dump func
On Tue, March 15, 2011 12:36, Joerg Bruehe wrote:
> Hi!
>
>
> Adarsh Sharma wrote:
>> Dear all,
>>
>> Taking Backup is must needed task in Database Servers. [[...]]
>
> Correct.
>
>>
>> We have options RAID, mylvmbackup , mysqldump. But it depends on the
>> company requirement too.
>
> RAID is no b
On Fri, December 3, 2010 14:11, Basil Daoust wrote:
> Any help
greatly appreciated.
>
> Our mysql is restarting a
LOT!
> Here is what is in the log, it doesn't seem to give much
help.
>
> --start of log--
> InnoDB: Warning: a
long semaphore wait:
> 101203 15:12:40 - mysqld got signal 11;
> This
On Thu, September 16, 2010 13:30, mohit verma wrote:
> hello ,
> when we install any package the terminal shows in end "
reading database"
> (used by package manager like .deb or
rpm). but as in linux everything is
> nothing but a file. so
database shown above must be a part of the
> filesystem
On Mon, September 13, 2010 15:37, Daevid Vincent wrote:
>>
-Original Message-
>>
From: Kiss D�niel
[mailto:n...@dinagon.com]
>> Sent: Monday, September 13, 2010
5:59 AM
>>
>> Well, thanks, but I'm afraid using
UUID's (even with hex
>> compression) is
>> kind of
a suicide, when it comes to
On Mon, August 16, 2010 07:26, Nunzio Daveri wrote:
> Hi all, I
was reading a few of the notes on this forum from a few months
>
back
> and it seems that ONE WAY of upgrading from 4.x to 5.X with
MyISAM only
> databases is to copy the actual data folder from the
4.X version to a temp
> place, the
On Wed, August 4, 2010 11:40, Nunzio Daveri wrote:
> Hello Gurus :-)� I was running a simple load generator against our 16GB
> Dual
> Quad core server and it pretty much came down to it's knees within two
> hours of
> running tests.� The customer DOES NOT WANT to change any code, they just
> want t
On Tue, July 20, 2010 09:28, dennis skinner wrote:
>
>
>
>
>
> Hello I am a new mysql user. Can anyone tell me why this does not
> create a table?
>
> < ?php(the spaces before the question mark are not in the
> code)
> $dbuser="smeduser";
> $dbpassword="x";
> $dbname="smed";
>
On Wed, June 16, 2010 14:47, Don Cohen wrote:
> Daevid Vincent writes:
>
> > For the love of God and all that is holy,
> > do NOT put the user/pass on the URL like that!!
> What's so unholy (or even unwise) about it?
The username and password shows up in logs on the server and in the
browser'
On Mon, March 22, 2010 11:08, Andres Salazar wrote:
> Hello,
>
> Everytime i run a mysqldump (mysql-server-5.0.77) all the other
> legitimate queries that are ocurring at that time pretty much sleep
> and build up in the processlist untill I either stop the dump or wait
> for it finish. The moment
On Wed, March 10, 2010 09:04, Dan Nelson wrote:
> In the last episode (Mar 10), John G. Heim said:
>> I have read (and have been told) to stay away from RAID-5 for
>> update-intensive systems. Are there performance concerns with RAID-10
>> as
>> well? We will be buying from Dell (done deal for re
On Wed, February 17, 2010 09:24, Cantwell, Bryan wrote:
> Is there a simple function or method to compare a value in a column to one
> or more items in a comma separated list?
>
> select * from table where value
> ('apple','orange','banana');
>
> and say value may = something like
> 'produce(grape
On Fri, January 22, 2010 09:42, Scott Swaim wrote:
> I ran into this when I upgraded from 4.0.xx to 5.0.xx There was a change
> in
> the logic for the Joins. I determined that the FROM clause needs to be in
> parenthesis. i.e.FROM (team, person, teamperson) this allows all of
> the
> fields
On Thu, November 19, 2009 09:47, James Coffman wrote:
> Hello all,
>
> My website has been hacked using a url such as:
> -1%20union%20all%20select%201,2,concat(username,char(58),password),4,5,6%20f
rom%20users-- .
>
> I have been searching on the web for a solution/fix to this issue
On Thu, November 19, 2009 09:47, James Coffman wrote:
> Hello all,
>
> My website has been hacked using a url such as:
> -1%20union%20all%20select%201,2,concat(username,char(58),password),4,5,6%20f
> rom%20users-- .
>
> I have been searching on the web for a solution/fix to this iss
On Fri, October 2, 2009 12:28, Bennett Haselton wrote:
> At 02:53
AM 10/2/2009, Joerg Bruehe wrote:
>>Hi Bennett, all!
>>
>>
>>Bennett Haselton wrote:
>> > At 08:24 AM 9/25/2009, Dan Nelson wrote:
>>
>> In the last episode (Sep 25), Bennett Haselton said:
>> >> > I have a script that runs several
On Mon, April 13, 2009 11:55, mos wrote:
> Jerry,
>
> At 09:53 AM 4/13/2009, Jerry Schwartz wrote:
>>Sorry for top-posting, but this is getting unwieldy.
>>
>>The problems with hardware in multiprocessor systems have been dealt with
>>long since, assuming that Intel, AMD, et al have implemented the
On Fri, April 10, 2009 05:24, Uwe Kiewel wrote:
> Moon's Father wrote:
>> Hi.
>>If the server has 16 cores, how to set parameters to make MySQL runs
>> well.
>
> IIRC is mysqld multi threaded - so if you have parallel queries, mysqld
> will spam multiple threads across multiple cores.
---^^
We are using the PostgreSQL currently to store the Bayes information. It
seems to periodically spend a lot of time 'vacumming' which of course
drives up disk load. The system admin has adjusted it so it only does
this at low load. I'm curious if anyone has actually tested the
PostgreSQL vs MySQL
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 NNN is the sequence number.
> This
I realize its probably
On Mon, March 9, 2009 12:51, Mihail Manolov wrote:
> I would strongly suggest logging all your 4.0 queries for at least 24
> hours and then running them on your new 5.x server to avoid any
> surprises such as incompatible queries for example.
>
> Good luck!
>
> Mihail
Good idea. I would pay partic
Looks like the system is doing a lot of disk WRITES. Your writes/sec are
much higher than your reads/sec. But the time stuff waits in the queue is
low. Did you try top -i with the x option entered? That will produce a
colored line if a dask is I/O bound.
On Fri, February 27, 2009 11:51, dbrb2002
On Fri, February 27, 2009 05:50, Baron Schwartz wrote:
> On Fri, Feb 27, 2009 at 4:19 AM, wrote:
>> Hi
>>
>> Recently I noticed the server takes lot of time on and off when opening
>> and closing tables. And I tried to increase the table_cache more the the
>> total tables (file_limit is properly
On Tue, January 6, 2009 13:30, PJ wrote:
> My comments, questions & explanations inserted below
>
> mos wrote:
>> At 09:55 AM 1/6/2009, you wrote:
>>
>>> >-Original Message-
>>> >From: c...@l-i-e.com [mailto:c...@l-i-e.com]
>>> >Sent: Tuesday, January 06, 2009 9:47 AM
>>> >To: mysql@lists.m
On Tue, January 6, 2009 07:55, Jerry Schwartz wrote:
>
>>-Original Message-
>>From: c...@l-i-e.com [mailto:c...@l-i-e.com]
>>Sent: Tuesday, January 06, 2009 9:47 AM
>>To: mysql@lists.mysql.com
>>Subject: RE: how to design book db
>>
>>
>>Just theories here:
>>
>>
>>
>>The same book re-issue
On Fri, December 5, 2008 12:14, Martijn Tonies wrote:
> Hi,
>
> What is the exact error message?
Here's the latest query:
delimiter //
create trigger jobposts_control
before delete on jobposts for each row
begin
declare dummy varchar(255);
On thing that tripped me up when I did the same move was the change in
LEFT JOIN syntax. It now joins to the LAST table in a list. This change
actually happened half way through the 4.0x series. Doesn't effect data,
but does effect queries. There MAY also be a difference on how string
compariso
On Mon, July 21, 2008 09:14, Brent Baisley wrote:
> Copying 5GB files shows you what kind of performance you would get for
> working with say video, or anything with large contiguous files.
> Database access tends to be random, so you want a drive with faster
> random access, not streaming speed. T
On Fri, June 13, 2008 08:26, Ian Simpson wrote:
> Hi Jerry,
>
> It could be a kernel issue; however, currently I'm suspecting that the
> drive in the new server simply doesn't have the same bandwidth
> capability. The iostat results I'm getting (although I'm not an expert
> in reading them, having
On Mon, April 28, 2008 09:44, Rob Wultsch wrote:
> On Mon, Apr 28, 2008 at 6:49 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
>> I am going to assume that you are asking this question because
>> performance has not improved from this change. Is this correct?
>>
>> I don't think that your surogate ke
On Mon, April 21, 2008 07:28, Waynn Lue wrote:
> Is there any way to prevent UPDATEs on one database on one mysql
> instance from affecting SELECTs on other databases in the same
> instance? I'm noticing a whole bunch of backed up connections on
> other databases when I run massive UPDATEs on one.
On Tue, April 15, 2008 02:03, [EMAIL PROTECTED] wrote:
> I'm still trying to decript the EXPLAIN result, and there is something I
> really
> don't understand:
>
> mysql> EXPLAIN SELECT STRAIGHT_JOIN media.* FROM country,content,media
> WHERE
> country.id='Germany' AND country.detail_tid=content.tid
On Fri, April 11, 2008 06:47, Ben Clewett wrote:
> Are you using MyIsam or InnoDB? Or something else?
>
> In either case the speed to get a COUNT() is largely down to the speed
> if your disks and size of disk caching. A COUNT() forces the system to
> read every row in order to count them, and an
On Tue, April 1, 2008 10:01, Robert DiFalco wrote:
> I've been told that an index always contains the primary key. So if I
> have a LONG ID that is the primary key of table and create on index on
> LONG VALUE, the index on LONG VALUE will actually work as a typical
> compound index on ID,VALUE. My
On Fri, February 22, 2008 10:01, Ed Curtis wrote:
> I'm doing the above migration as mentioned in the subject line. I
> figured I would use the MySQL Migration Toolkit to help it along but it
> won't let me connect to my 3.23.49 server. Is there any other way to
> migrate all my data easily.
>
> Th
On Fri, February 8, 2008 13:09, Paolo Amodio wrote:
>
> Il giorno 08/feb/08, alle ore 21:55, Riccardo Perotti ha scritto:
>
>> Hi all:
>>
>> Our sistem crashed and we're trying to recover our data. The disc is
>> fine but the OS is gone, so I'm trying to get at the actual mysql
>> databases documen
On Tue, January 15, 2008 14:19, Daevid Vincent wrote:
>> -Original Message-
>> From: [EMAIL PROTECTED]
>> [mailto:[EMAIL PROTECTED] On Behalf Of Baron Schwartz
>> Sent: Tuesday, January 15, 2008 1:49 PM
>> To: Daevid Vincent
>> Cc: mysql@lists.mysql.com
>> Subject: Re: does 'disable network
se issues. Your open source
will live on a system, not in isolation, that's what I am concerned about.
However, if it makes your job much easier in python then go for it. In,
perl at least we can work around it.
Bill
> On Jan 4, 2008 2:00 PM, Wm Mussatto <[EMAIL PROTECTED]> wrote:
>
&g
Question is, will anyone ever have to write a quick utility in perl (or
any language which uses '$' as a delimiter) to support this? Will you
have to explain your tables to anyone else?
On Fri, January 4, 2008 09:15, Victor Subervi wrote:
> LOL! True. I'm a Python guy ;)
>
> On Jan 4, 2008 1:14 PM
Can you look at the directory where the data files are
(e.g., in debian its: /var/lib/mysql/{databasename})?
For the problem table you should see {tablename}.MYD and ...MYI files it
he engine is myisam.
Hope this helps
On Wed, November 28, 2007 09:34, Richard Edward Horner wrote:
> FYI, this did n
On Wed, September 5, 2007 7:17, Jay Blanchard said:
> [snip]
> I have a Table and want to know the most visited products.
> Products
>
> - Id
>
> - Name
>
> - Visited
> [/snip]
>
> SELECT Id, Name, count(Visited) AS Total_Visits FROM product GROUP
> BY(Id)
order by Tota
I concur. Also it makes it easier to remove a customer if they leave.
Finally your backups will only lock up one customer's database at time and
for a much shorter period.
On Thu, August 23, 2007 10:50, Jerry Schwartz said:
> Personally, I think I'd go with one DATABASE per customer. That way th
On Wed, August 15, 2007 13:09, Kebbel, John said:
> I have a table with 1600 student locks in random order. I would like them
> permanently sorted by the locker number they are assigned to. I assumed
> that ...
>
> ~ I would copy the table under a different name
> ~ Delete all records from this co
On Tue, July 31, 2007 8:52, David Ruggles said:
> I need to find a userid across several different tables.
>
> What is the best way to do this?
>
> For example I have three tables
> TableA
> TableB
> TableC
>
> They all have a field "id"
>
> I want to find the value 123 in the field "id" in any one
On Fri, July 20, 2007 12:32, Andrew Rosolino said:
>
> Whenever I alter a mysql table like add a new field it gets really slow
> and
> all other processes lag.
> Is there a memory variable I can adjust for this?
> --
> View this message in context:
Without more information it might be hard to answe
On Mon, June 4, 2007 14:21, murthy gandikota said:
> Hi
> When restoring a DB from a tar file, I had to repair some of the tables.
> Whereas when the DB is started after a power failure, everything works
> fine. I noticed this on RedHat linux and MySQL5.
>
> Any thoughts?
>
> Thanks
> Murth
On Mon, June 4, 2007 9:31, paulizaz said:
>
> What do you mean by "same output" ?
Can you write a program to access both databases and have it check to see
if the data matches. A lot depends on how the structure changed. If the
new database rows have a one to one correspondence to the original
da
On Thu, May 24, 2007 2:12, Przemys?aw Klein said:
> Wm Mussatto wrote:
>> Assuming you are using MYISAM table types, each table requires at least
>> three files on the disk. If they are in one database they will all be
>> in
>> one directory (how fast is your OS
On Tue, May 22, 2007 23:29, PrzemysÅaw Klein said:
> Martijn Tonies wrote:
>> Hi,
>>
>>
>>> I'm working on quite big database. It consists of about 200 tables.
>>> Additionaly about 50 tables are per year (because of annual data). It
>>> means every year new 50 tables will have to appear in applic
On Tue, April 10, 2007 19:45, Paul DuBois said:
> At 10:15 AM +0800 4/11/07, wangxu wrote:
>>follow is my sql:
>>
>>
>>
>>select * into dumpfile '/home/wangxu/test4.data' from mytable ;
>>
>>
>>
>>
>>
>>mysql server report: Result consisted of more than one row
>>
>>
>>
>>why?how to use the "select
On Mon, March 26, 2007 16:21, Daevid Vincent said:
>> You're about 5 years too late for this converation, but I recall it
>
> Really? People have just happily accepted this absurd limitation for
> _five_
> years? Wow.
>
>> having to do with the fact that when you're on a table that supports
>> tran
long as you never ran IIS on them, and that
was a while ago. Hopefully someone else on the list can help. You might
google for AES and ASP and see what comes up.
>
>>From: "Wm Mussatto" <[EMAIL PROTECTED]>
>>To: "Neil Tompkins" <[EMAIL PROTECTED]>
>&g
On Mon, March 12, 2007 13:04, Neil Tompkins said:
> Sorry Bill, I'm unsure what you mean by bin
My error, too early in the morning here 'blob'
>
>>From: "William R. Mussatto" <[EMAIL PROTECTED]>
>>To: mysql@lists.mysql.com
>>Subject: Re: ENCODE() and DECODE()
>>Date: Mon, 12 Mar 2007 10:31:53 -0700
70 matches
Mail list logo
