Tag Info

Hot answers tagged

6

Well, you could not grant execute on it explicitly to end users (deny it even), and only enable it in stored procedures that use EXECUTE AS with some login that does have execute permissions. Then grant execute on only that stored procedure to the user that needs to run the command. First, make sure xp_cmdshell is enabled for the instance: EXEC ...


5

"Isn't it possible to scale database servers through virtualization, like forever?" Yes, you can make more and more database servers and you can also make a larger and larger database server (but the scale up limit can be reached very quickly), but in the scale out scenario are the servers you mention supposed to cooperate in any way or are they ...


5

Please keep in mind that prior to MySQL 5.1.38, InnoDB was not designed to access multiple CPUs. You have one of two options to get MySQL to take advantage of multiple CPUs. OPTION 1 : Install MySQL 5.5 OPTION 2 : Install MySQL 5.1 InnoDB Plugin There are new options available since MySQL 5.1.38 (InnoDB Plugin Only) that is now fully available in MySQL ...


5

You can also setup a proxy account using sp_xp_cmdshell_proxy_account to allow non-administrators to use xp_cmdshell. This will allow you to setup a less privileged Windows account rather than xp_cmdshell always using the SQL Server service account. This is similar to setting up proxy accounts for SQL Agent jobs.


5

The no-beep option causes the mysql command line client not to beep when errors occur. If that's an option you want, it should be in the [mysql] section of your my.cnf. This error suggests that it's in the [client] section of your my.cnf, which causes mysql_upgrade to throw the error since the option isn't recognized. Check your my.cnf and either remove ...


4

The only option to think about is disk layout but you only have six of them. This isn't enough for "optimum performance" A RAID 1 volume with 2 disks will be around 135GB so if your database is 100GB+ you'd need RAID5/RAID 10 with 4 disks, but then you don't have enough for separate logs/OS/Tempdb volumes. As an aside, with 100GB+ DB why only 16GB RAM? ...


3

Xp_cmdshell would work fine - just access the file using the UNC path (\server1\share\file.exe). As the other person mentioned, make sure you have proper permissions for you sql agent service account to access the file. If, instead, you actually want to run the file on the remote server, you can use a tool called PSEXEC that will run am exe on another ...


3

You could still use xp_cmdshell; however, you'll need to make sure that your SQL Server Service account (the AD account used to run SQL Server) has access to the directory containing the exe file and any other directories that that program may require. xp_cmdshell runs on your SQL Server itself; you can use it just like any other command window. If, on the ...


3

It seems that postgresql doesn't like your postgresql.conf file. The log message clearly says that it wasn't expecting a " character on line 392, but it doesn't tell you which one (of two " on this line) is it. I would assume that there is an unclosed " earlier in the config file.


3

So far (I'll update this as you provide more info). 2 disk RAID 1 for the OS, 2 disk RAID 1 for the data, 2 disk RAID 1 for the transaction logs. These are the kinds of questions you should be asking before you purchase hardware.


3

I one up'd the answer above because, technically, it's correct on how to accomplish it. However, I would make the opposite recommendation. Meaning, I would recommend using linked servers for what you are doing. This is because it seams like you're asking the question about architecting Federated Servers using Distributed Partitioned Views techniques. There ...


3

You can indeed do this, but I recommend against it. You can create a linked server on DB-SERVER-1, connecting it to DB-SERVER-2. You then could write a query using four part naming convention as follows: (assuming you are running this query on DB-SERVER-1) select * from DB1.dbo.YourTable a join [DB-SERVER-2].DB2.dbo.OtherTable b on b.ID = a.ID ...


3

There are several reasons why this can happen: Make sure you are not using the query cache on your old server and not on the new one. Execute always benchmarks with SELECT SQL_NO_CACHE. Execute the same queries several times. If it is a new server -the buffer pool, filesystem cache and other buffer are probably not yet settled for best performance, ...


2

What you can do is restrict access to the SQL server and the Windows server that SQL is on. There are database server level roles with sysadmin giving you the highest privileges. Review this link to see what you will need to give your temp. The temp should never be in the sysadmin server level role, based on what I read from your requirements. Then there ...


2

SQL Server 2008 includes all sorts of auditing which can be used to monitor what is done in SQL Server. I've written about this in "Securing SQL Server" which may be of some use.


2

Percona, a leading MySQL support and consulting company, offers a MySQL configuration wizard. It asks several questions, and produces my.cnf file based on your answers. It's a good starting point, and should produce somewhat safe values. Several people from Percona offer wrote a book called "High Performance MySQL". The third edition was recently ...


2

Note you say this is in the server log and there are no known problems with clients. Consequently, I don't think that it is libpq per se. Additionally on doing some additional searches, it looks like this is a standard Windows "connection refused" message, which suggests that PostgreSQL is trying to connect to something and being refused. If you are ...


2

For this scenario, the database server should not be publicly exposed, for obvious security reasons. You should expose a public interface (API) of your application, probably by using something like web services. The mobile application instances then only communicate directly with the API. This separation (decoupling) allows for all sorts of good things to ...


2

Start by commenting out the offending line in your postgresql.conf and retry. It is possible that a change made some time ago caused this problem and you are only now seeing it because a reload operation or similar failed, and so PostgreSQL was running on old configuration. If that works address what you have on that line (maybe get rid of the quotes?) If ...


2

No. The instance is configured to use cluster resources and as such if the cluster is removed the instance will not function correctly. If you like to play with fire in an experimental-not-in-production-learn-by-trial-and-error way, you can do the opposite of How to move SQL Server from Standalone to Cluster environment.


2

Firstly: unless this is a replication slave, development box, or similar, that can easily be reconstructed from other sources should the worst happen, RAID0 is not recommended. It provides good performance but potentially seriously bad reliability: if any one of your four drives fails then the whole array is toast. Edit after new information: it would ...


2

Except in Windows-land there's no difference between a "Server" and a "PC" other than typical hardware choices and installed software. PostgreSQL follows that, and doesn't care in the slightest what you're installing it on. Install it on Win2k8 the same way you would on any Windows desktop OS. The only possible wrinkle is Group Policy and Active Directory ...


2

The entire folder should be owned by mysql cd /usr/local/mysql-5.6.21-osx10.8-x86_64/data/ chown -R mysql:mysql * Then go restart mysql Give it a Try !!!


2

You can use machines of different sizes as long as the lesser machines can actually keep up with the more capable primary when replicating (particularly at peak traffic times). You can use priorities to ensure that the more powerful machines are preferred when they are up and healthy and you can set any host that absolutely should not become primary to ...


2

The way to gauge hardware performance is to be take a look at your current workload. So I would begin by quantifying that: Take a look at Brent Ozar's perf tuning stuff Identify your bottlenecks (are you seeing bad parallelization, CPU chugging away without finishing, memory, storage) Determine what differences there will be between your new and old ...


2

Ideally you can shutdown using /etc/init.d/mysqld stop I cannot add comments so requesting to post what do you see in error log when you do mysqladmin shutdown About kill commands please note that mysqld_safe is wrapper script which will start mysqld upon killing... so you should kill mysqld_safe first followed by mysqld. ( not a suggested way ...


1

MySQL 5.6 wants more memory It's likely that MySQL 5.6 just needs more memory than your previous version. MySQL 5.6 tries to allocate more memory per connection than previous versions - I believe a lot of this is attributable to the performance schema, which is now enabled by default. Small servers (esp. ~512MB memory), or servers with a high ...


1

Please pay attention to the raid status: VERIFYING. The progress is displayed as %V/I/M. You can see the verify schedule with the show verify command parameter. As long as the raid is being verified I assume the io performance isn't great. You should use iostat or vmstat to get a better picture what is happening. The cache is enabled for your raid unit. You ...


1

While there some manual things that could be done at database level (moving tablespaces around, etc.), most of the settings for MySQL are transparent to the storage layer, meaning that you do not need to do anything to take advantage of the RAID. While a RAID 0 could provide you a better theoretical throughput in reads and writes (at the cost of having 4 ...


1

Please do not change Sql Server's TCP port unless you know what you are doing. This needs to be done only in specific scenarios like manual SPN registrations with failover cluster setups or restricted environments. Sql Server installations contain a special service called Sql Browser Service. When a client tries to connect to a named instance, it will ask ...



Only top voted, non community-wiki answers of a minimum length are eligible