For all I know it could just as well be an intermittently faulty network
device. Should be another interesting little war against the computers.
- Original Message -
> From: "Ananda Kumar"
> To: "Claudio Nanni"
> Cc: "Johan De Meersman" , &qu
- Original Message -
> From: "Claudio Nanni"
> " Print out warnings such as Aborted connection... to the error log."
> the dots are not telling if they comprise Aborted clients as well.
Hah, how's that for selective blindness. Totally missed that :-)
> I find the MySQL error log extreme
Yo,
I'm having trouble with clients aborting, but for some reason they don't get
logged.
The documentation at http://preview.tinyurl.com/27w9a4x clearly states "If a
client successfully connects but later disconnects improperly or is terminated,
the server increments the Aborted_clients stat
- Original Message -
> From: "Jan Steinman"
>
> That's been the common wisdom for a long time.
>
> However, this just popped up on my RSS reader. I haven't even looked
> at it, let alone tried it.
In brief: convert all your tables to myisam, delete ibdatafile during a
restart, convert
- Original Message -
> From: "Reindl Harald"
>
> interesting because i have here a dbmail-server with no CPU load and
> innodb with compression enabled since 2009 (innodb plugin in the past)
Ah, this is a mixed-use server that also receives data from several Cacti
installs.
> [--] Da
- Original Message -
> From: "Reindl Harald"
>
> 95% of mysqld-installations have no problem with
> innodb_file_per_table so DEFAULTS should not be for 5%
There is "no problem", and there is "better practice" - and if your system is
I/O bound it makes sense to minimize on-disk fragmenta
- Original Message -
> From: "Ananda Kumar"
> yes, Barracuda is limited to FILE_PER_TABLE.
Ah, I didn't realise that. Thanks :-)
> Yes, true there is CPU cost, but very less.
> To gain some you have to loss some.
I've only got it enabled on a single environment, but enabling it added
- Original Message -
> From: "Reindl Harald"
> Subject: Re: Reducing ibdata1 file size
>
> well but for what price?
> the problem is the DEFAULT
>
> users with enough knowledge could easy change the default
> currently what is happening is that mostly every beginner
> is caught in the tr
- Original Message -
> From: "Ananda Kumar"
> yes, there some new features you can use to improve performance.
> If you are using mysql 5.5 and above, with files per table, you can
> enable BARACUDA file format, which in turn provides data compression
> and dynamic row format, which will
- Original Message -
> From: "Reindl Harald"
>
> as multiple said the default of a single table space
> is idiotic in my opinion, but however this is well
> known over years
I suppose there's a certain logic to favouring one-shot allocation and never
giving up free space, in that it red
- Original Message -
> From: "Pothanaboyina Trimurthy"
>
> hi sir,
Please keep the list in CC, others may benefit from your questions, too.
> can we see any performance related improvements if we use
> "innodb_file_per_table" other than using a single ibdatafile for all
> inn
- Original Message -
> From: "Manivannan S."
>
> How to reduce the ibdata1 file size in both LINUX and WINDOWS
> machine.
This is by design - you cannot reduce it, nor can you remove added datafiles.
If you want to shrink the ibdata files, you must stop all connections to the
server, t
- Original Message -
> From: "Rick James"
>
> * should not begin with the table name
Personally, I tend to prefix all column names with three-letter abbreviations
of the table name, so that they are both unique across joins, and it's obvious
what table they're from wherever they appear
- Original Message -
> From: "Reindl Harald"
>
> but what about the dramatical reduced query-cache hits i see
> in some peace of software switching to prepared statements?
>
> dbmail2 as example had around 300 sql-actions per second
> dbmail3 using prepared statements currently around
- Original Message -
> From: "Govinda"
>
> 1.) Is anyone *who knows what he is doing* still using
> mysql_real_escape_string()? Ever?
I seem to vaguely remember someone showing me some code that would bypass
escaping; but I didn't really pay a lot of attention, to be honest :-)
Person
- Original Message -
> From: "Ananda Kumar"
>
> If numeric, then why are u using quotes. With quotes, mysql will
> ignore the index and do a full table scan
Will it? Common sense dictates that it would convert to the column's native
type before comparing; and a quick explain seems to co
- Original Message -
> From: "Hiromichi Watari"
>
> I uploaded the technology whitepaper to the website.
Hmm, interesting idea, to allocate a thread per table - I can imagine it's
going to be pretty heavy on the thread cache, though :-) How does it respond to
self-joins, subselects and
- Original Message -
> From: "Baron Schwartz"
>
> Because it can be resolved by rolling back just one of them. Why
> destroy ALL the work people are trying to accomplish, if you could
> just throw away some of it?
What I fail to understand, Baron, is how there can be a deadlock here - bo
- Original Message -
> From: "Rick James"
>
> If you have 14 partitions in each of 390 tables, and if you have most
> of the tables 'active', then you are possibly thrashing in the
> table_open_cache.
A distinct possibility.
> Compute (SHOW STATUS):
> Opened_tables / Uptime -- don't wan
- Original Message -
>
> > From: "Baron Schwartz"
> >
> >> Bugs Fixed
> >> * Security Fix: Bug #64884 was fixed.
> >> * Security Fix: Bug #59387 was fixed.
> >
> > Anyone want to elaborate on the nature or severity of the security
> > problem? Both are private / inaccessible t
- Original Message -
> From: "Hiromichi Watari"
>
> I created Parallel Universe which is a MySQL 5.5 compatible server
> with fast query execution.
> Speed is achieved by the new patent pending technology which utilizes
> multi core/CPU of server hardware.
Just like when you posted this
- Original Message -
> From: "Claudio Nanni"
> Yes indeed,
> but I think we are talking about MySQL level deadlocks,
> that can happen only with row level locking and transactions.
> If the deadlock is generated at application level then you can have
> it on anything, also blackhole :-)
- Original Message -
> From: "nixofortune"
>
> Few more things. You can't have a deadlock on Mylsam table. You can
You *can* have deadlocks in MyISAM; the concept is not related to any specific
engine - or even databases.
What you can't have, is deadlock on a single table :-)
--
Bier
- Original Message -
> From: "Baron Schwartz"
>
>> Bugs Fixed
>> * Security Fix: Bug #64884 was fixed.
>> * Security Fix: Bug #59387 was fixed.
>
> Anyone want to elaborate on the nature or severity of the security
> problem? Both are private / inaccessible to me.
Bug #64884
- Original Message -
> From: "Zhangzhigang"
>
> As i known, the mysql writes the data to disk directly but does not
> use the Os cache when the table is updating.
If it were to use the OS cache for reading but not writing, then the OS cache
would be inconsistent with the underlying file
- Original Message -
> From: "Zhangzhigang"
>
> The mysql does not use this approach what you said which is
> complicated.
>
> I agree with ohan De Meersman.
Umm... It's not a matter of who you agree with :-) Karen's technical detail is
quite correct; I merely presented a simplified pic
- Original Message -
> From: "Zhangzhigang"
> Ok, Creating the index *after* the inserts, the index gets created in
> a single operation.
> But the indexes has to be updating row by row after the data rows has
> all been inserted. Does it work in this way?
No, when you create an index on
- Original Message -
> From: "Zhangzhigang"
>
> Creating indexes after inserting massive data rows is faster than
> before inserting data rows.
> Please tell me why.
Plain and simple: the indices get updated after every insert statement, whereas
if you only create the index *after* the
- Original Message -
> From: "Charles Brown"
>
> Interestingly, over the years, I've been reading your postings and
> threads - without a doubt you're a major contributor. You've been
> very resourceful and helpful to your peers. We may never know what
> caused you to violently snap this
- Original Message -
> From: "Reindl Harald"
>
> why does this idiotic list-server not add
> Precedence-Headers to supress autoreplies?
How many autoreplies did you get to that? :-D
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras e
- Original Message -
> From: "Kaushal Shriyan"
>
> Any performance bottleneck if HT (Hyper Threading) is enabled in quad
> core processors on CentOS 5.8 running MySQL DB Server ? Please help me
> understand about pros and cons of this feature.
That very much depends on your workload. I'd
- Original Message -
> From: "joe j"
>
> Good suggestion. But I am a perl/unix illiterate. However I may learn
> in them future-you never know!
You're never too old to learn :-)
http://tldp.org/LDP/abs/html/
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwe
- Original Message -
> From: "joe j"
>
>
> /*STEP 2. from the dos prompt?*/
>
> for x in UK ZA IN CN;
> do mysql -ujoe -p -e "INSERT INTO `table_new`
> SELECT var1, var2`, (case when (country='${x}') then 1 else 0 end) AS
> citizen
> ,'${x}' AS ctry
> FROM `'${x}'_table`
> LEFT JOIN
>
- Original Message -
> From: "Rick James"
>
> That sounds like the wrong way to design the schema. Why not have
> `country` as a column in a single table?
Given that he got all the data for the new tables from existing ones, I was
assuming he needed separate tables for some specific pu
A little heads-up for those thinking of toying with NDB. Not the actual NDB,
mind you, the packaging.
While the packages you download are very eloquently named
(mysql-cluster-gpl-7.2.5-debian5.0-x86_64.deb), someone inside Oracle either
doesn't quite grok how dpkg works, or deliberately made a
- Original Message -
> From: "HaidarPesebe"
>
> I asked for help, how to order that each time I add an item then the
> item number in column 1 move to column 2, column 2 moves to the
> column 3, column 3 to 4 and so on.
>
> product | 1 | 2 | 3 | 4 | total
> [...]
What a most peculia
- Original Message -
> From: "joe j"
>
> So what I am trying to get is a script that runs through a list of
> country names (US, UK, NL, etc) and create tables for each one of
> them as above. Is this feasible in MySql?
You can't create multiple tables with one statement; but you *can* p
- Original Message -
> From: "Ian"
>
> with each master having any number of slaves. Set MySQL Proxy to
> send writes to the masters and reads to the slaves.
Yes, except when you have replication delays (asynchronous, remember?) like
someone else recently posted, your application write
- Original Message -
> From: "Martin Gainty"
That... made no sense whatsoever. Good thing I'm not Dutch, I suppose.
Anyway, I invoke Godwin's Law. Thread ended.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
- Original Message -
> From: "Wes Modes"
>
> Hi, I received a suggestion from Baron Schwartz that I consider your
> company for consulting advice as a solution to an enquiry I made to
> the MySQL list. I did not respond to Baron Schwartz and now I receive
> this email from an account exe
- Original Message -
> From: "Singer X.J. Wang"
>
> Perhaps something called a VM can be use?
Perhaps something called documentation can be provided?
I also notice that the original poster seems to have vanished again, which
makes the whole thing even more shady.
--
Bier met grenady
- Original Message -
> From: "AdmSA"
> We have a problem when we try to stop the mysql service (mysql Ver
> 14.14 Distrib 5.5.12, for Linux (x86_64) using readline 5.1) on a
> remote server throught SSH.
> The problem is that mysql_safe, start again mysqld before that mysql
> kill all th
- Original Message -
> From: "Kinaan Khan Sherwani"
>
> that MySQL server keeps data dictionary information in .frm files
> which it stores in the database directories, whereas InnoDB also stores
> the information into its own data dictionary inside the table space files.
>
> I want to
- Original Message -
> From: "Cifer Lee"
>
> it seems none of you hava answered my question.
Yes, that happens :-)
I'm slightly confused as to the difference between "user variables" and "local
variables", though. Are you saying you couldn't just declare @myvar and use it
in your
- Original Message -
> From: "Halász Sándor"
>
> input for Word (yes, I have to work MySQL CSV-ish output into real
> CSV, ensuring that there are no escapes in it, nor 'NULL' either).
And this is why it's beneficial to specify your goal along with your question
:-)
MySQL does have a
- Original Message -
> From: "Brent Clark"
>
> Mar 26 14:43:54 xyz-web02 mysqld: 120326 14:43:54 [ERROR]
> /usr/sbin/mysqld: Table './db/comm_opens' is marked as crashed and should be
> repaired
That needs a 'repair table' command; probably because the snapshot was taken
while the tabl
*plonk*
- Original Message -
> From: "Charles Brown"
> To: "Reindl Harald"
> Cc: "MySql"
> Sent: Thursday, 22 March, 2012 5:37:00 AM
> Subject: tables do not have the same number of columns.
>
> I have two mysql instances in my mysql cluster. I noticed that their
> MysSQL.user tables d
You keep repeating that, and I already replied to it the first time. If my
answer isn't acceptable, spamming the question isn't going to make it better -
or make people more inclined to help you, for that matter.
- Original Message -
> From: "Charles Brown"
> To: "Charles Brown" , mysql
- Original Message -
> From: "Charles Brown"
>
> I have two mysql instances in my mysql cluster. I noticed that their
> MysSQL.user tables do not have the same number of columns. Their
> USER table attributes are not the same. One instance has 39 columns
> while the other has 42 columns.
- Original Message -
> From: "Baron Schwartz"
>
> 1. With mysqldump. mysqldump -hmysql-inst1 mysql | mysql
> -hmysql-inst2 mysql
And then, of course, issue a FLUSH PRIVILEGES on mysql-inst2 :-)
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't dri
- Original Message -
> From: "Baron Schwartz"
>
> If you want to go to this year's MySQL conference like all the cool
> kids, now's your chance. Percona is giving away free tickets (and
Bit far, but please tell me there's gonna be another Percona Live in London or
another bit of Europe
- Original Message -
> From: "David Lerer"
>
> Have you tried to set city = null (i.e. without the quotes)?
Spot on, I'd think.
NULL values are not a string with "NULL" in it - that's only what it looks like
in query results :-) An empty string ('') is to strings what 0 (zero) is for
- Original Message -
> From: "Chris Tate-Davies"
>
> Not sure if anyone on this list has heard of this, but I found this
> yesterday and it may prove to be quite useful one day.
>
> http://www.sqlfiddle.com/
Hee, funny :-) Thanks for that.
--
Bier met grenadyn
Is als mosterd by den w
By using your shell's variable substitution, I'm afraid.
export outfile='/path/to/file'
mysql -e "select blah into outfile '$outfile'"
You'll have to build a shell script or something that generates your filename,
and then do an interactive call.
Maybe you could write a stored procedure tha
- Original Message -
> From: "Baron Schwartz"
>
> You may be interested in this:
> http://www.mysqlperformanceblog.com/2009/09/28/how-number-of-columns-affects-performance/
Heeh, very interesting. You guys keep churning out the good stuff :-)
--
Bier met grenadyn
Is als mosterd by den
- Original Message -
> From: "Charles Brown"
>
> Anyone out there with experience in Mysql Clustering. My management
> requests that i migrate from replication to clustering. Why? Because
> everyone is doing clustering and he would like to stay competitive.
Your management has no clue w
And there are no outgoing connections from that host to another mysql server?
- Original Message -
> From: "Reindl Harald"
> To: mysql@lists.mysql.com
> Sent: Monday, 27 February, 2012 1:48:15 PM
> Subject: Re: file descriptor leak?
>
> it is simply not possible that there are 1926 or mo
Well, it *did* close the gap by a couple of hundred connections :-)
I honestly have no idea what could cause this. I wouldn't immediately think of
a leak in MySQL as those are system tools that *should* check the same location
for their stats. Most peculiar.
I seem to remember you running mostl
- Original Message -
> From: "Reindl Harald"
>
> other machines (rsyslog configured for mysql)
Hmm, that would mean a lot of very brief connections, I guess. Coud you try
with my line? I don't expect it to vanish, but I think it should close the gap
a little.
>
> netstat | grep mysql
Interesting. I slightly reformatted your commands for both speed and to
minimise the time between them:
(lsof -n| grep '^mysqld' | grep ESTABLISHED | wc -l) & (netstat -n | grep
3306 | grep ESTABLISHED | wc -l) & wait
I get the occasional couple of connections difference, but mostly it turns o
- Original Message -
> From: "Daevid Vincent"
>
> d.`date_release`!='-00-00' AND sd.`scene_id`=s.`scene_id` GROUP
> BY sg.`scene_id` ORDER BY num DESC, sd.`count_dl_monthly` DESC LIMIT 30;
Could you put an index on sg.scene_id? Not sure, but it might help the grouping
be more effici
- Original Message -
> From: "Adarsh Sharma"
> Thanks Johan, but i mentioned before that adding auto increment
> column doesn't solve the issue & it causes errors in the multi
> threaded application.
If it causes errors, you have other problems than this.
> Multiple clients calls this
- Original Message -
> From: "Honza Horak"
>
> particular reason why the line is not used by default?
Can't be bothered to go look at the script, but it should be doing a "flush
logs" somewhere. The line is commented by default because MySQL will recreate
it's logfiles automatically, a
- Original Message -
> From: "Steven Staples"
You're asking the wrong question, though. WHY do you want to do that? You
should never, ever ever rely on auto_increment for stuff like record insert
order. Did I mention NEVER?
Autoincrements can get reset for a variety of reasons. The onl
- Original Message -
> From: "Johnny Withers"
>
> I'm not sure, It seems to me the proper way to do would be to insert
> into table1, get the insert ID, then insert into table2 using that ID,
> this is pretty standard stuff.
>
> Not sure why, in this case, he cannot do that.
last_insert
- Original Message -
> From: "Adarsh Sharma"
>
> Today I noticed some duplicacy in my c_id column which is not
Yes, that's what you get if you don't use auto_increments.
> I need multiple client select cid from 2 tables & insert data with
> adding 1 to previous C_id in isolated manner.
- Original Message -
> From: "Jason J. W. Williams"
>
> I've got an issue where two MySQL servers are in circular/multimaster
> replication. One is server_id 6871 and the other 206871. The issue is
> that GRANT statements issued on 6871 are replicated to 206871 and
> then
> back to 6871 w
- Original Message -
> From: "Alex Schaft"
>
> From the user's perspective, they just need to know the process didn't
> hang. The count() query is more for getting memory requirements upfront.
> Can I handle it all, or do I need to break it down into pages?
Then just use the cursor-bas
- Original Message -
> From: "Alex Schaft"
>
> If I were to do a select count(*) from x where y prior to doing
> select * from x where y to get a number of records, how would this impact
> performance on the server itself? Would the first query be the one to
> do the most processing, with
- Original Message -
> From: "Stan Iverson"
> Yes, it's a binary file; however, MySQL Connector for ODBC only works
> in Windows and I'm using a Mac. If no other solutions, will try
> tomorrow on a friend's PC.
If it's binary, you're gonna have no other choice but to restore the files o
- Original Message -
> From: "Stan Iverson"
>
> I have a Mac and a Linux server and I need to read the table schema
> for a database dump from MSSQL. Possible? How?
Heeh. If you're talking about an SQL dump into a textfile, that should be
doable - you might have to mess with some dataty
- Original Message -
> From: k...@inbox.lv
>
> I have some merged tables. Can I alter 1 table and change a table
> comment? Is it legal?
As long as you don't change the table structure or name that shouldn't be a
problem, I think.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die'
- Original Message -
> From: "Halász Sándor"
>
> noting that MySQL does not really support CSV: one can set all
Not *entirely* accurate: MySQL does include a CSV engine that you can use in
the same way you would use InnoDB or any other engine.
If you create a table a with engine=CSV a
- Original Message -
> From: "Adarsh Sharma"
>
> Is it possible I upgrade to higher version 5.5 with existing data
Yes, look for the upgrade notes in the online documentation.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een eze
- Original Message -
> From: "P.R.Karthik"
>
> And also make sure that you have the SUPER privilege to kill it.
Note that even then, it might not die immediately (although it's status in show
processlist will change to "killed") if it's waiting for I/O.
--
Bier met grenadyn
Is als mo
- Original Message -
> From: "Halász Sándor"
>
> Therefore, it well may be easier to do it all in PHP, since therewith
I agree with the assessment, but I take issue with this whole "do it in
PHP/Python/language-of-the-month".
Why would I want to install PHP, Python or whatever on a da
- Original Message -
> From: "kalin m"
>
> thanks. it took about 15 hrs. but right now everything seems ok. does
> the check last as long as the repair?
No, a check (myisamcheck -c or "check table" in sql) is a read operation that
verifies structures, pointers and such but makes no chan
- Original Message -
> From: "Todd Lyons"
>
> It doesn't matter what you set in innodb_force_recovery. If you do
> not have the obras.frm file (which contains the schema definition of
> the table), I don't know if you can retrieve the info. Put that file
I recommended he delete that f
Can you send the error logs from my and Suresh' solutions, so we can see what
the next thing to go wrong is ? :-)
- Original Message -
> From: "Suporte Avanutri"
> To: "Suresh Kuna"
> Cc: "Johan De Meersman" , "Shafi AHMED"
> ,
- Original Message -
> From: "Suporte Avanutri"
> To: "Shafi AHMED" , mysql@lists.mysql.com
> Sent: Tuesday, 24 January, 2012 3:43:36 PM
> Subject: RES: Force drop table
>
> 120124 12:29:28 InnoDB: Error: table `avanutri/obras` does not exist in the
> InnoDB internal
> InnoDB: data di
- Original Message -
> From: "Adarsh Sharma"
>
> 1. Go to data dir : cd /hdd2-1/mysql_data/
> 2. mv abc abc1
Whatever gave you the idea that it's a good plan to start messing with the
files of a service whose inner workings you have no clue about?
> ERROR 1146 (42S02): Table 'abc1.job_
- Original Message -
> From: "bars0.bars0.bars0"
>
> Hi all!
>
> I need to copy data (result set from query) from one server to
> another.
> This will be done once a month (so cron will be involved:), for data
> from previous month.
> Any ideas how can I achieve this?
>
> Should I expor
- Original Message -
> From: "kalin m"
>
> ok. thanks. i thought so. it's been about 8 hrs so far. and the TMD
> file is about half the MYD/MYI file. although MYI is about a gig smaller
> than the MYD. which one has the TDM to reach in size in order for the
> repair to be complete?
The M
- Original Message -
> From: "Adarsh Sharma"
> 1. I am planning to to fix one partition /hdd2-1 for my binary logs
> for HA, rotate them monthly to extra backups.
Keeping binary and other logs on separate disks from your datafiles is a very
good plan. For backup purposes, make sure you
Gah, my eyes :-)
That seems... needlessly complex. As a general rule, it's a good idea to have
one datafile per physical disk. Putting more datafiles on a single disk doesn't
magically increase parallellism.
- Original Message -
> From: "Adarsh Sharma"
> To: "mysql"
> Sent: Monday,
It doesn't particularly say, but this:
> 120116 19:15:29 120116 19:15:29 InnoDB: 1.1.8 started; log sequence number
> 1595675
suggests to me that there's still junk from a previous install around. You
might want to clean that up.
- Original Message -
> From: "mantianyu"
> To: mysql@lis
- Original Message -
> From: "Monte Milanuk"
>
> Again, I *don't* want to connect to 192.168.56.1 - I want to connect
> to 192.168.56.20 - so why the heck is mysql refusing to do that.
Yes. Now take a deep breath and read what I said again.
You can perfectly connect to .20 - as proven b
- Original Message -
> From: "Monte Milanuk"
> 'Connection Failed: [HY000][MySQL][ODBC 5.1 Driver] Access denied for
> user 'ijdb'@'192.168.56.1' (using password: YES)'
The connector is not trying to connect to the host address; it's connecting
*from* the host address - in your MySQL,
- Original Message -
> From: "Johnny Withers"
>
> Security through obscurity?
That sentence has been overused way too much. If you want to remove all
obscurity from your security, just publish your passwords and private keys.
> If none of your MySQL (or samba) servers are open to untru
- Original Message -
> From: "Reindl Harald"
>
> sure? what's the binary between version and "mysql_native_password"?
No idea, I never bothered to look at the raw protocol :-)
> mysql 5.5 would be enough i guess, but how to create a patch for
> rpmbuild which must not be permanently cha
I suppose the assumption is that any client needs the server version to figure
out the compatible set of capabilities, as there is no separate protocol
versioning afaik.
I suppose you could change the version in the source to the lowest that has the
full featureset you need.
--
Bier met gren
http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html
If you use InnoDB for your tables, you can use the ON UPDATE CASCADE option for
your foreign key constraints.
However, your habit is indeed a nasty one :-p It forces you to do joins where
none are necessary, thus needles
Reinventing chroots, then?
Welcome to 2012, when everything has been done before :-)
--
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:
- Original Message -
> From: "Adam Lanier"
>
> What is the recommended course of action to keep data synchronized
> between the two platforms?
Not an easy one, I think :-)
For simple one-shot copies the MySQL Connector for ODBC should do fine. I'm not
sure if you can set up a continuou
First off, as part of this bit of mayhem I found an answer for the recent (and
common) question how to verify if the server is properly started with
skip-name-resolve, as there's no status variable for that: if you perform a
grant on a hostname instead of an IP, it'll spew a warning at you :-)
- Original Message -
> From: "Stdranwl"
>
> So then no use of setting 3G sort buffer in my.cnf untill system will
> take a rebot?
> I was in the impression that 10M will be used and it will be
> scratched to 3G whenever required as same is set globally?
No, you've got it the wrong way ro
- Original Message -
> From: "Reindl Harald"
>
> DO NOT REPLY OFF-LIST
Also, do not shout :-)
> the difference is "set" or "set global"
Same for show, and 'show variables' is implicitly the same as the clearer 'show
session variables'.
> global is what would be used if the thread doe
Allright, that will do, I think?
This is a MySQL mailinglist, let's not have it devolve into vendor rants.
The defaults may or may not be sensible, but they're documented, and there's as
much to say for sensible defaults as there is for not changing defaults between
releases.
Let's leave it at
- Original Message -
> From: "Halász Sándor"
>
> mysql> update address set membersince = (select membersince from
> address where memberid = 1258) where memberid = 1724;
IIRC, subselects are allowed, except for selects that reference the table
you're updating.
--
Bier met grenadyn
Is a
- Original Message -
> From: "Yu Watanabe"
>
> So, which memory corresponds to 'pages' for the MyISAM then?
> It would be helpful if you can help me with this.
None, as Reindl said. This is not a memory issue, it's a function of I/O
optimization. Records are stored in pages, and pages a
201 - 300 of 809 matches
Mail list logo